Setup Request: Benefit premium multiplied by percentage depending on EEs salary range
Summary
Looking for setup to fulfill requirement of monthly premiums being multipled by a percentage based on the employees salary range. Please see below example.Content
Health Plan | Premium Amount |
Single | 740 |
Employee & Spouse | 1480 |
Family | 2116 |
Parent & Child | 1376 |
Salary Range | |
less than $25,000 | 4% |
25 - 29,999.99 | 5% |
30 - 34,999.99 | 6% |
35 - 39,999.99 | 7% |
40 - 44.999.99 | 8% |
Example: Employee enrolled in Employee + Spouse that makes $42,000/year = 1480* 8% = $118.40
Question: I know we will have to do the below, but how do we get the premium to multiply by the percentage amount (8%) based on the salary range?
- Derived Factor based on Salary ranges
- Eligibility profiles based on Salary Ranges
- Variable rate for each salary range using calculation method multiple of compensation
Tagged:
0