Description
Get 2 templates for the price of 1!
With the Salary Increase Analysis template and the Pay Structure Design template, you are all set to review increases and salary band structures with ease!
Salary Increase Analysis Template Details
This spreadsheet is already set up for you to quickly analyze various increase requests that usually occur throughout the year. There are 3 separate tabs/ pages, to tackle increases in these areas:
•Salaried to salaried position promotions and adjustments
•Hourly to hourly position promotions and adjustments
•Hourly to salaried promotions
Each of these pages will calculate the percentage increase, and do a comparison to the internal averages and market rates of the requested positions, along with calculating these metrics for you:
•Compa-Ratio
•Range Penetration
•Market Index
All that you have to do is plug in your organizations information and the current and requested increase amounts.
Pay Structure Design Template
This template will help you determine different ranges per salary band or grade. There are 3 different tabs/pages, which can be used depending on which information you have available to plug in.
Below are 3 different ways this worksheet can help you determine your ranges:
