Review employee master
Overview
Use the Employee Listing sheet as reference to calculate when salary adjustments occur throughout the planning cycle. This sheet lists all employees by job code and includes details regarding each employee's current base rate and next year's rate as well as their merit and market increase month and percentage. You must populate the Employee_Roster_YYYY tables when using this labor sheet. This annual table populates the individual employee rows in each job code section. A standard import called Load Employee Master has been provided to populate this table.
To make the budget plan file as accurate as it can be when calculating salaries, the system takes into account any potential current year rate increases set to take place — depending on when the budget plan file is built. For example, the following budget plan file is built in month 8. All the radiology technicians, except Michael and Jeff, have likely received their rate increases already because 0% displays in the CY Inc % column and their anniversary dates have already passed. However, Michael is set to receive his increase in month 9 and Jeff in month 10. The system anticipates this increase by showing that their beginning rate as 3% higher than their current rate and uses this rate for the budget.
The system does the same for scheduled budget market and merit increases as well. In this example, everyone will receive a 3% merit increase but no market increases. The system allows you to include up to two market increases, which simply provides a way to apply additional percentages beyond the merit increase. For example, a contract may stipulate that nurses receive two market increases per year.
The system then layers together all of the rate adjustments as well as the merit and market increases to provide you with values related to the amount that salaries will increase month-over-month over the year. In the following example, July starts with an increase of 0.70% but begins to increase month to month as more employees receive their salary adjustments. These values are used in the Jobcode tab to calculate salaries.
The last month of the fiscal year becomes the "fully burdened" month because by this point all of the increases have occurred. The effective rate for the fiscal year is located in the Total FTEs column. Knowing the effective rate helps you determine the effect of adding merit or market adjustments. In the example below, the user now knows that adding a 3% merit increase will result in a 1.67 effective rate.
The remaining section of the sheet is devoted to the scheduled hours for scheduled FTE employees. The system projects scheduled hours based on when the employee was hired and whether they are working full or part time.
Important considerations when configuring the Labor Rate driver to assign Step increases in the Salary Sheets:
-
Step rate adjustments are assigned in Payroll at the employee level. In order to apply Step adjustments from the 14 Budget Labor Rates Driver, the Step fields must be provided in the Employee Master source file. A standard import called Load Employee Master is provided to populate the Employee_Roster_YYYY tables.
-
Employee_Roster_YYYY table is a mandatory component when choosing to use the Employee Salary method. It is used to populate the Empl_List tab and the individual employee rows within the Employee salary sheet.
-
The Step code assigned in the 14 Budget Labor Rates Driver is matched to the Step code in the Empl_List tab to apply driver adjustments to applicable employees.
-
Base Rates: Start and End Rates reference the employee level salary calculations performed against the base rates on the Empl_List tab. Start and End Rates in the Salary tab will match the calculated rates on the Empl_List tab when rates are set to Base in the 27 Override Driver.
-
History Rates: Current, Start, and End Rates are calculated based on either the Current Period (Regular) or the YTD values (all other standard pay types) from the Act_Pay27 tables. Salary adjustments are calculated on the Empl_List at employee level and applied to the historical calculated rates on the Salary tabs. The Current, Start, and End Rates in the salary tabs will not match what is shown on the Empl_List since they are calculated from posted dollars/hours as opposed to the reported Base Rates from Payroll.
-
Global Rate: This rate comes directly from the 27 Budget Override Driver. This rate overrides all base or historical calculations and does not apply Merit or Market Increases. Start and End Rates will be the rate which is entered in the driver.
-
If multiple employees are budgeted in a single jobcode, a weighted average increase is calculated in the Empl_List tab and applied each month in the Salary sheet.
-
Calculations on the Empl_List tab are referenced first on the Salary sheets when budgeting the merit increases to maintain consistency in the calculations across salary methods. This also ensures that Step increases are applied if provided.
-
Populating the Empl_List from the Employee_Roster_YYYY table is required to assign Step increases at the employee level.
-
If the Step field in Empl_List or Employee_Roster_YYYY table is not populated, the Step increases cannot be applied at the employee level. If the Step code is not provided, the next applicable increase above the Step increase will be applied from the driver.
-
-
Note the following when using this sheet:
- Employees are only listed in their home department. The Jobcode sheet may show more employees than what are listed for the job code in the Employee Listing sheet. This means that employees have been borrowed from other departments.
- The Employee Listing sheet only displays current active employees.
- To add an employee, you must do so through the labor method itself. For example, if you use the employee budgeting methodology, you must add a new employee in the Employee sheet.
- Merit and market increase factors are defined in the LaborRates sheet of the Budget Labor Assumptions driver
- This sheet incorporates max rate logic to calculate the lump sum payout if an employee is currently above their max limit or defined increases will put them above the limit.
- Max limits are defined in the
Use this sheet to calculate PTO accrual hours if activated in the Budget Configuration driver
