Within your enterprise it is useful to know the salary ranges for different groups of employees. This workbook investigates the spread of salaries within groups such as age, position, grade, organization and location.
Employees, within the area of the enterprise you select, have their salary plotted against a group. You can then quickly see where the main spread of salaries lie for each group.
What range of salaries do employees have in a particular group?
How do salaries vary across age groups?
How do salaries vary across organizations or locations?
To what extent do salaries increase with length of service?
In order for this report to return data, you must have successfully attached performance reviews to the pay proposals. To attach a performance review, set a performance review date before you approve the pay proposal. For instructions see: Changing Other Information in Proposing a Salary Change for a Current Employee
You must enter a value for the following parameters:
Organization Hierarchy
Top Organization
Rollup Organizations - Yes/No
Convert to Currency
The workbook converts the salaries to the currency you select here, before averaging them for the grouping
Use the following parameters to further restrict the values in the workbook:
Location
Job
Grade
Position
Performance Rating
Include Currencies
The workbook has the following worksheets, each representing a salary grouping:
By Organization
By Location
By Job
By Grade
By Position
By Performance Rating
By Age
By Length of Service
The worksheets display one row for each person. Age and Length of Service are measured in years.
All worksheets contain the following columns
A grouping column
The heading depends on the selected worksheet, for example, in the by Grade worksheet, this column is named "Grade".
Person
Employee names listed within each grouping.
Total Salary
Displays the employee's total annualized salary for all assignments Each employee appears in the worksheet grouping.