Within your enterprise you have many different groups of employees. You can group employees by common criteria, such as ethnic origin, grade, job, gender, and service band.
This workbook enables you to investigate the average salaries of these different groups of employees.
You can also select which area of your enterprise you want to investigate. You can choose the currency you want to view the salaries in and include or exclude salaries that you pay in a different currency.
Are average salaries in my enterprise rising at different rates for different groups of people in my enterprise?
How do salaries vary between different ethnic groups?
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 Category
Job
Grade
Position
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 Length of Work Band
By Age Band
By Gender
By US Ethnic Group
By GB Ethnic Group
The worksheets display one row for each grouping. For example, the by Position worksheet displays one row per position.
When you use the US Ethnic Group worksheet, or the GB Ethnic Group worksheet, employees from other countries will appear in the report with no ethnic group recorded against them. These employees will be counted as a separate group. To avoid this, you could restrict the report to just employees in the US or GB.
All worksheets contain the following columns
A grouping column
The heading depends on the selected worksheet, for example, in the by Length of Work Band worksheet, this column is named "Length of Work Band"
Average Salary
The current average annualized salary per grouping.