Analyze pay parity using wages, staffing, and hours. Estimate weighted gaps across multiple employee groups. Plan equitable adjustments with clear evidence for smarter decisions.
Use as many groups as needed. Blank rows are ignored automatically.
| Group | Current Wage | Target Wage | Headcount | Annual Hours |
|---|---|---|---|---|
| Operations | $18.50 | $20.00 | 14 | 2080 |
| Support | $16.25 | $18.00 | 12 | 2080 |
| Sales | $22.00 | $23.50 | 10 | 2080 |
| Logistics | $17.10 | $19.00 | 9 | 2080 |
Parity Ratio (%) = (Current Wage ÷ Target Wage) × 100
Hourly Gap = Target Wage − Current Wage
Current Payroll = Current Wage × Annual Hours × Headcount
Target Payroll = Target Wage × Annual Hours × Headcount
Adjustment Cost = Max(0, Hourly Gap) × Annual Hours × Headcount
Weighted Parity (%) = Total Current Payroll ÷ Total Target Payroll × 100
Wage parity compares actual pay to a chosen standard. The standard may be a market rate, internal band midpoint, union rate, or fairness target for similar work.
The inputs are structured around hourly wages. You can still compare annual salaries by converting them into an hourly equivalent before entering the numbers.
Annual hours convert wage gaps into payroll impact. This helps HR teams estimate how much budget is needed to bring a group up to the selected benchmark.
Weighted parity compares total current payroll against total target payroll. It gives larger groups more influence, which often reflects budget reality better than a simple average.
Adjustment cost estimates the money required to raise below-target groups to parity. Groups already above target do not add extra cost in this calculation.
Yes. Target wages can represent internal grade midpoints, location-adjusted ranges, negotiated rates, or external survey benchmarks. The calculator works with any clear reference value.
Average parity treats every group equally. Weighted parity reflects payroll size. A small high-paid group can lift the average while large lower-paid groups still create a weaker weighted result.
No. This tool is a planning aid. A full pay equity review may also consider tenure, geography, job family, performance, incentives, and legal compliance requirements.
Important Note: All the Calculators listed in this site are for educational purpose only and we do not guarentee the accuracy of results. Please do consult with other sources as well.