The Workforce Composition Analysis workbook investigates employee composition by assignment details, salary band, and time service band.

It enables you to:

• Compare employee assignment details across organizations.

• Analyze salary information across organizations.

• Change salary groupings.

• Report on salary and time in service bands.

Workbooks

This workbook has the following worksheets:

• By Assignment Details

• By Salary Band

• By Time In Service Band

By Assignment Details Worksheet

This worksheet enables you to analyze employee assignment details by organization, job, position, or grade.

Business Questions

What is the composition of my workforce by assignment?

Parameters

This worksheet has no parameters.

By Salary Band Worksheet

This worksheet enables you to analyze the distribution of employees within an organization by length of service.

Business Questions

What is the composition of my employees by salary band?

Parameters

This worksheet has no parameters.

By Time In Service Band Worksheet

This worksheet enables you to analyze the distribution of employees within an organization by length of service.

Business Questions

What is the composition of my employees by service band?

Parameters

This worksheet has no parameters.

Headings and Calculations

This worksheet uses the following calculations:

• Service Band

  Populates the Service Band page item in the worksheet. This calculation creates the service bands.