This workbook enables you to compare employee salaries for each job and grade. The worksheet shows the average, minimum, and maximum employee salaries for jobs and grades.
This workbook has the following worksheets:
Organization Hierarchy
Supervisor Hierarchy
This worksheet enables you to compare employee salaries for each job and grade. The report shows the average, minimum, and maximum employee salaries for jobs and grades, for a given organization and its subordinate organizations.
How do the lowest, average and highest salaries of employees in each organization, in a particular job, compare with the grade minimum, mid point and maximum?
You must specify values for the following parameters:
Organization Hierarchy
Top Organization
Effective Date
The worksheet includes those employees who held a primary assignment at the time of the Effective Date, and were employed within the selected organization hierarchy at the time of the Effective Date.
This report uses the following calculations:
Annualized Grade Maximum
Calculates the annualized maximum payment in a grade range. The calculation uses the grade annualization factor that is set up as part of the pay basis.
Annualized Grade Mid Value
Calculates the annualized mid value payment in a grade range. The calculation uses the grade annualization factor that is set up as part of the pay basis.
Annualized Grade Minimum
Calculates the annualized minimum payment in a grade range. The calculation uses the grade annualization factor that is set up as part of the pay basis.
Number of incumbents
This returns the total number of assignments for an employee on the effective date.
This worksheet enables you to compare employee salaries for each job and grade. The worksheet shows the average, minimum, and maximum employee salaries for jobs and grades, for a given supervisor and his/her subordinates.
How do the lowest, average and highest salaries of employees for a given supervisor, in a particular job, compare with the grade minimum, mid point and maximum?
You must specify values for the following parameters:
Supervisor
Effective Date
The worksheet includes those employees who held a primary assignment at the time of the Effective Date, and were assigned to the selected supervisor at the time of the Effective Date.
This report uses the following calculations:
Annualized Grade Maximum
Calculates the annualized maximum payment in a grade range. The calculation uses the grade annualization factor that is set up as part of the pay basis.
Annualized Grade Mid Value
Calculates the annualized mid value payment in a grade range. The calculation uses the grade annualization factor that is set up as part of the pay basis.
Annualized Grade Minimum
Calculates the annualized minimum payment in a grade range. The calculation uses the grade annualization factor that is set up as part of the pay basis.
Number of incumbents
This returns the total number of assignments for an employee on the effective date.