Benefit Calculator

As you set up benefit plans, you can use the Benefit Calculator to test a benefit plan's calculations for an eligible employee. If the plan was set up in HRMS Employee Self Service for open enrollment, you can also test the calculations that would be performed if the employee chooses to enroll in that benefit plan during open enrollment or a life event.

The results of the calculation show the specific plan amounts for the selected employee, including the employee premium, dependent premium, employee contribution, and employer contribution.

Before you begin

Before you use the calculator, make sure you have done the following for the plan you want to test:

• In Sage HRMS, set up the benefit plan and specify the values/formulas for the required amounts as required by the plan.
• In Sage HRMS, specify the enrollment plan setup.
• In HRMS Employee Self Service, set up elections for the benefit plan..
• In HRMS Employee Self Service, set up employee eligibility for the benefit plan.

Using the Benefit Calculator

1. On the Administrator menu, select Benefit Setup > Benefit Calculator.

2. The table on the Benefit Calculator plans page shows all current, unexpired benefit plans that were set up and also have their elections and eligibility completed. The table includes the benefit plan description, the enterprise or specific employer, and the plan's effective date range. (Only plans that are included.)

   Select the benefit plan you want to test by clicking (the view icon) at the end of the row.

3. The table on the Benefit Calculator employees page shows all employees eligible for the selected benefit plan. (If there are no employees in the list, review the plan's benefit eligibility to determine the reason. If a specific employee is not included in the list, review their eligibility criteria and related employee information in Sage HRMS.)

   Select the employee you want to test by clicking (the view icon) at the end of the row.

4. On the Benefit Calculator calculation page, review the plan information:
   • Benefit Election Plan: The code and description for the selected plan. (If you need to select another plan, click the Select Plan link to return to the Benefit Calculator - Select Plan page.)
   • Employee: The employee you selected for the test. (If you need to select another employee, click the Select Employee link to return to the Benefit Calculator - Select Employee page.)
   • Election Requirement: The plan's election coverage type, such as Employee Only, Dependents Only, One Choice Employee with Dependents, or Employee and Dependents - Separate Elections.

   • Store Employee Election Value In If the plan's election was set up to store the employee's election value in Sage HRMS, this shows the election selection, the table name, and the field name.

     Example: If Coverage Amount was selected for the election, this item shows Coverage Amount (hbene.b_coverage).

   • Store Dependent Election Value In If the plan's election was set up to store the dependent's election value in Sage HRMS, this shows the election selection, the table name, and the field name.

5. Choose one of the following calculation options:

   • Live Plan Setup: Calculate the plan as it is currently set up in Sage HRMS.
   • Open Enrollment Setup: Calculate the plan as it is currently set up for open enrollment or a life event. (This option is unavailable if the plan is not set up in HRMS Employee Self Service for open enrollment.)

6. Select the following test criteria:

   • Effective Date: Enter the date when the calculated costs for this benefit plan are effective for this employee.

     Example: If the cost of a benefit starts for the selected employee on June 1, 2022, enter 06/01/2022.

   • Election description: Select one of the elections for the plan.

     The elections depend on the plan setup. For a medical plan where the employee selects who is covered, the description might be Choose who is covered, so you would select from the available coverage choices. For a 401(k) savings plan where the employee specifies a percentage contribution, the description might be Enter your % contribution, so you would type a percentage. For a group term life insurance plan where the employee selects a level of coverage (such as 1x salary or 2x salary), the description might be Choose your level of coverage, so you choose the level. If the plan has no election options required, None displays.

   • Dependents: If dependents are covered by the plan, select the check boxes for the dependents to be included.

7. Click Calculate Cost.

8. Review the information in the Calculation Steps area, which shows the steps that the system goes through as it calculates the costs. There will be a section for each relevant calculation (such as Calculation of Employee Contribution, Calculation of Employer Contribution, Calculation of Employee Premium, Calculation of Dependent Premium). Each element in the plan setup (such as a rate table or expression) is shown. If there is an error, it is listed in red directly below the step that caused the error.

   The costs of the employee contribution, employer contribution, and premiums are shown at the end in the Calculation Results section.

   Note: The There are errors in this calculation. message displays if there were errors in the calculation. Go to the source of the error (which could be in the plan setup or the Benefit Elections setup in HRMS Employee Self Service), correct the problem, and re-test the calculation.