Assess pay fairness across grades and groups. Model midpoint targets, review variances, estimate correction budgets, and support better compensation decisions with practical evidence.
| Name | Role | Grade | Group | Current Pay | Midpoint Pay | Performance Rating | Tenure Years |
|---|---|---|---|---|---|---|---|
| Aisha Khan | HR Generalist | G5 | Women | 52000 | 56000 | 4.4 | 3 |
| Bilal Ahmed | HR Generalist | G5 | Men | 55000 | 56000 | 4.2 | 4 |
| Sara Noor | Recruiter | G6 | Women | 61000 | 64000 | 4.6 | 5 |
| Usman Ali | Recruiter | G6 | Men | 65000 | 64000 | 4.3 | 6 |
This calculator estimates equitable pay by comparing current pay with a target pay level. The target starts with midpoint pay for the grade. It then adjusts for performance and tenure.
Target Pay = Midpoint Pay × (1 + Performance Factor + Tenure Factor)
Performance Factor = ((Performance Rating − 3) ÷ 2) × Performance Weight
Tenure Factor = Min(Tenure Years, 10) × Tenure Weight
Pay Gap Amount = Target Pay − Current Pay
Pay Gap % = ((Target Pay − Current Pay) ÷ Target Pay) × 100
Equity Ratio % = (Current Pay ÷ Target Pay) × 100
Compa Ratio % = (Current Pay ÷ Midpoint Pay) × 100
Employees outside the selected threshold are marked for review. Positive gaps indicate underpayment against the modeled fair target. Negative gaps can suggest over-range pay or role-specific exceptions needing context.
This tool is best used for internal review, not automatic decisions. Final compensation actions should include legal review, role scope, geography, market data, and documented business factors.
Equitable pay analysis helps HR teams compare current compensation with a structured reference point. That reference point often includes grade midpoint, job scope, performance, and service length. A repeatable method reduces guesswork and supports consistent decisions across managers.
This calculator gives People Ops teams a practical review workflow. It highlights employees whose modeled fair target differs from current pay beyond a chosen threshold. That makes it easier to prioritize audits, estimate budget impact, and prepare leadership discussions.
Good pay analysis does not replace human judgment. It creates an evidence-based starting point. Teams should still consider labor market data, internal parity, location, critical skills, and legal compliance before changing pay.
The equity ratio shows how close current pay is to modeled target pay. A value near one hundred percent suggests close alignment. Lower values can point to possible underpayment. Higher values may reflect premium skills, scarcity, or old pay decisions needing review.
The compa ratio measures current pay against grade midpoint. It helps teams see whether pay sits below, near, or above the grade center. Used together, compa ratio and equity ratio create a stronger review picture than either measure alone.
Teams can use this calculator during annual compensation planning, promotion reviews, merger integration, or workforce audits. It works well when compensation structures exist and employee records are organized in simple rows. The built-in summary table also helps compare average pay positions across workforce groups.
Budget planning becomes easier when each pay gap amount is added into one recommendation figure. Leaders can see the likely investment needed to close modeled shortfalls. That supports scenario planning before compensation committees make final approvals.
Every pay model depends on the assumptions used. The performance and tenure weights in this calculator are adjustable because organizations value these factors differently. Keep your methodology documented and consistent. Consistency improves trust, auditability, and communication.
Use the findings as a structured review signal. Do not treat them as automatic pay instructions. Fair pay decisions should always include market benchmarking, role architecture, local law, and leadership review.
It compares current employee pay with a modeled target pay. The model uses grade midpoint, performance, and tenure. It then shows pay gap amount, pay gap percent, equity ratio, compa ratio, and a review status.
It supports internal analysis, not legal certification. Use it as a screening tool. Formal compliance reviews should also include legal counsel, jurisdiction rules, market data, role evaluation, and documented non-discriminatory pay factors.
Midpoint pay anchors the model to a compensation structure. It represents the intended central rate for a grade. Using midpoint helps compare employees consistently across similar job levels and salary ranges.
The equity ratio shows current pay as a percentage of modeled target pay. Lower percentages may indicate underpayment against your rules. Higher percentages can reflect premiums, retention actions, or exceptions that need documentation.
Many teams start with a small percentage, such as three to five percent. The best threshold depends on budget, policy, pay philosophy, and legal guidance. Smaller thresholds catch more cases.
Yes. The method is flexible for any function with grade midpoints and employee data. You only need consistent records and a clear compensation framework for reliable results.
These weights reflect common compensation considerations. They let you model fair target pay with more context than midpoint alone. Adjust them carefully and keep the methodology consistent across comparable employees.
Review each case with role scope, market benchmarks, location, manager context, and past pay actions. Confirm whether the variance is justified. Then build a budgeted action plan with documented reasoning.
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.