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:
When purchased through this page only, you get both templates for the price of 1.
Each template is designed in MS Excel and comes with PDF directions on how to use it, plus support for any questions.
You will receive these templates via email, within 24 hours, but usually same day.
Custom Changes – Sometimes customizations can help you save even more time and we’d love to help! With a background in Compensation/HR, I’m CCP (certified compensation professional) and PHR certified, with almost 10 years experience working in a Compensation Analyst role at manufacturing and retail companies. I’ve been creating templates and custom excel work for all industries since 2013. Feel free to contact me here for more information or a custom quote or any questions.