Salary Cost Projection Report

The Salary Cost Projection report lists employee gross salaries by salary grid. This report projects an employee's salary based on the employee's function lines and the selected optional grid within the salary grid. The optional grids give you the opportunity to project future adjustments to your salary grid and to use these as part of the projection process. For information on how to adjust the salary grid, see Salary Grid Adjustments.

In addition to projecting salary based on the salary grid, the system adds on any occupation and/or shift premiums that are attached to the function line.

The export file includes the following fields:

Employee Number
Employee Name
Salary Grid
Employee's Percentage Employed
Employee's hours
Employee's gross salary from first or all function lines
Employee's occupation and/or shift code premiums from first or all function lines
Total gross salary plus occupation premiums

NOTE: This job will run only in batch.

Use Test Grids or Actuals

Enter 1 to use Salary Grid #1 figures.
Enter 2 to use Salary Grid #2 figures.
Enter 3 to use Salary Grid #3 figures.
Enter 4 to use Salary Grid #4 figures.
Enter A to use the current function values

Enter the Projection Period

Enter the pay period to use in selecting function lines for this report.

The period selected will be used as a filter to determine what function lines should be included for purposes of projection. Only function lines which have a start date which is less than or equal to the projection period ending date and an end date which is greater than or equal to the projection period ending date will be selected and processed.

Enter Deduction to Select

Enter a deduction code to limit this report to the employees which currently have this deduction.
Enter 'All' to select all employees.

Basic Salary or All Functions

Enter 'B' to select the first function line for an employee only.
Enter 'A' to use all function lines. NB: The salary function lines selected allow for the inclusion of salary function Type L (lump sums) only if they are included in the first or primary function line on the employee's master file. Any L types used on function lines 2-7 will be excluded from the projection.

Report Employees Terminated / On Leave / On Leave with Benefits

Include Generation of CSV Export File

Enter 'N' to omit generation of the export file.
Enter 'Y' to include the generation of the export file with this report.

This report lists the following:

Employee name and number
Salary grid
Percent employed if applicable
Hours
Gross salary from first or all functions
Occupation and/or shift premiums from first or all functions
Total gross salary and occupation premium