Variable Rate based on Age and Salary Amount — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Variable Rate based on Age and Salary Amount

edited Sep 5, 2020 12:33AM in Payroll and Global Payroll Interface (GPI) 1 comment

Summary

Create Variable Rate Based on Age and Salary Amount

Content

Hi All,

Has anyone create variable rates for supplemental insurance that assigns the rate to a benefit option depending on both the EE's age and their salary amount?

For the age ranges we will make eligibility profiles, but we also need to assign the correct rate automatically based off the employees salary. Example:

Age  Cost per Thousand Spouse (50% of EE's 25,000 Salary) $13,000 Employee $25,000 Salary Spouse (50% of EE's 50,000 salary) $25,000 Employee $50,000 Salary
Underage 20 0.055 0.72 1.38 1.38 2.75
20-24 0.065 0.85 1.63 1.63 3.25
25-29 0.075 0.98 1.88 1.88 3.75

 

Version

18c
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!