Calculator Inputs
Formula Used
Adjusted hourly wage: Current hourly wage × (1 + Shift premium ÷ 100)
Adjusted range value: Base range value × (1 + Market differential ÷ 100)
Compa ratio: (Adjusted hourly wage ÷ Adjusted midpoint) × 100
Range penetration: ((Adjusted hourly wage − Adjusted minimum) ÷ (Adjusted maximum − Adjusted minimum)) × 100
Range spread: ((Adjusted maximum − Adjusted minimum) ÷ Adjusted minimum) × 100
Target hourly wage: Adjusted midpoint × (Target compa ratio ÷ 100)
Hourly gap: Target hourly wage − Adjusted hourly wage
Annual gap: Hourly gap × Hours per week × Weeks per year
How to Use This Calculator
- Enter the employee name or job title.
- Add the current hourly wage.
- Enter the pay range minimum, midpoint, and maximum.
- Set the target compa ratio. Use 100 for midpoint alignment.
- Add work hours, paid weeks, overtime, and premium details.
- Press the calculate button.
- Review the result summary, chart, and detailed table.
- Download the CSV or PDF report for records.
Example Data Table
| Job | Hourly Wage | Range Min | Midpoint | Range Max | Compa Ratio | Range Position |
|---|---|---|---|---|---|---|
| Warehouse Associate | $19.50 | $17.00 | $21.00 | $25.00 | 92.86% | Lower middle |
| Customer Support Agent | $24.00 | $19.00 | $24.00 | $29.00 | 100.00% | At midpoint |
| Senior Technician | $31.25 | $24.00 | $30.00 | $36.00 | 104.17% | Above midpoint |
Understanding Hourly Compa Ratio
Hourly compa ratio shows how an employee’s hourly wage compares with the pay range midpoint. It turns pay data into one simple percentage. A result of 100 percent means the wage matches the midpoint. A result below 100 percent means pay is below midpoint. A result above 100 percent means pay is above midpoint.
Why This Calculator Helps
Hourly roles often have many pay variables. Shift premiums, local market adjustments, overtime, and range spreads can change the real picture. This calculator brings those items together. It compares the adjusted wage with the adjusted midpoint. It also shows range penetration, annualized pay, target gaps, and market status. These outputs help managers review pay with less guesswork.
Using Results Fairly
A compa ratio should not be used alone. It is best reviewed with skill level, tenure, performance, job scope, location, and internal equity. A new employee may sit below midpoint. A highly skilled employee may sit near or above midpoint. The result becomes more useful when paired with clear compensation rules.
Range Penetration
Range penetration shows where the wage sits between the minimum and maximum rate. It is different from compa ratio. A worker can have a strong compa ratio while still being low in a wide range. This is why both measures are shown together.
Budget Planning
The target gap shows the hourly raise needed to reach a selected target ratio. The annual gap converts that raise into a yearly cost estimate. This helps teams plan merit increases, equity adjustments, or retention offers. It also helps avoid overpaying when the wage is already above the selected target.
Better Pay Decisions
Transparent calculations create stronger pay discussions. They give HR teams a shared method. They also help supervisors explain decisions with numbers. Use this tool during compensation reviews, hiring checks, promotion planning, and wage range audits. Always verify the pay range first. Then compare the result with policy, budget, and business needs.
Review Cycle Tips
Save each review date and note the chosen range source. Compare employees in the same job family first. This keeps reviews consistent. It also reduces bias when pay decisions affect many hourly workers.
FAQs
1. What is an hourly wage compa ratio?
It is a percentage that compares an hourly wage with the pay range midpoint. A 100 percent result means the wage equals midpoint.
2. What does a compa ratio below 100 mean?
It means the adjusted hourly wage is below the selected midpoint. This may be normal for new, developing, or entry level workers.
3. What does a compa ratio above 100 mean?
It means the adjusted hourly wage is above midpoint. This can reflect experience, strong performance, scarce skills, or market pressure.
4. Is range penetration the same as compa ratio?
No. Compa ratio compares pay with midpoint. Range penetration shows where pay sits between range minimum and maximum.
5. Should shift premium be included?
Include shift premium when you want to compare effective hourly earnings. Exclude it when reviewing base wage policy only.
6. What target compa ratio should I use?
Use 100 percent for midpoint alignment. Use a higher or lower target when your pay policy supports a different position.
7. Can this help with raise planning?
Yes. The hourly gap and annual gap show the estimated increase needed to reach the selected target ratio.
8. Is this calculator enough for final pay decisions?
No. Review performance, skills, tenure, budget, internal equity, and legal rules before making final compensation decisions.