
We are implementing Payroll AX 2012 R2 CU7 and have a requirement for AX to automatically calculate supplemental life insurance premiums based on the age of the employee, the amount of coverage elected and fixed compensation amount.
Here is a portion of the table used to calculate costs of the insurance
Employee Age Monthly Rate per $1,000 of Coverage
Less than 30 $0.06
30-34 $0.08
35-39 $0.09
40-44 $0.17
Example:
An employee, age 38 (on January 1st), with basic annual earnings of $25,700, chooses 2 times basic annual earnings for their life insurance.
__2x________ x __$25,700_____ = $51,400 (rounded down to nearest $1000=$51,000)
Supp Choice Basic Annual Earning
____$51,000___ = 51 units of $1,000 x .09 = $4.60 per month
Supp Life Amnt. Rate Monthly Premium
Does AX provide anything that even comes close to this scenario?
*This post is locked for comments
I have the same question (0)