The FREE Compensation Metrics Cheatsheet is on it's way to your inbox!
In the meantime, would you like to get 2 spreadsheet templates for the price of 1?
The Salary Increase Analysis template and the Pay Structure Design template – already have all the comp metrics and formulas set up for you to plug your information into.
#1: Quickly analyze various salary increase requests against internal averages and market data, in this easy to use spreadsheet template:
The Salary Increase Analysis template has 3 separate pages to easily enter increase requests based on:
•Salaried to salaried position promotions and adjustments
•Hourly to hourly position promotions and adjustments
•Hourly to salaried promotions
Each page will also calculate the percentage increase, along with these metrics:
•Compa-Ratio
•Range Penetration
•Market Index
#2: Save time in reviewing the ranges per salary band or grade with this Pay Structure Design template:
The pay structure design template consists of 3 pages to help determine your salary band ranges. Just plug in the information you have, and the file will calculate for you:
Midpoint differential
Range Spread
Determine Min, Mid and Max depending on which information you input.