Most employers have pay ranges; almost none compute against them. Salaries get set by negotiation, raised by uniform percentages, and years later nobody can say who's parked at the bottom of their range, who's quietly crested the top, or why the two groups look demographically different. The range becomes decoration, and every pay decision loses its reference point.
This worksheet restores the math: the penetration formula with a worked example, a full-roster calculation table, an interpretation guide from green circles (below minimum — fix now) to red circles (above maximum — decide, don't drift), an equity flag pass, and a merit matrix that finally makes increases respond to both performance and position-in-range.
Who should use this compensation worksheet
- HR teams preparing merit cycles with a real budget constraint
- Owners who suspect pay has drifted from any structure
- Compensation analysts standardizing after growth or acquisition
- Municipal and nonprofit employers with published scales to honor
What it helps prevent
- Merit budgets that push maxed-out employees over range while low-in-range performers stall
- Green-circled new hires (below minimum) nobody noticed
- Red-circled veterans (above maximum) with no plan or conversation
- Ranges that decay into decoration because no one computes against them
- Pay decisions that can't explain themselves later
What’s inside
- Part 1 — The Formula
- Part 2 — Employee Calculation Table
- Part 3 — Position Interpretation Guide
- Part 4 — Flags
- Part 5 — Action Planning
- Part 6 — Merit Matrix Connection
Before you process payroll, terminate, classify, deduct, or respond to a claim, get the decision reviewed.
Faulkner HR Solutions helps Texas employers, nonprofits, municipalities, and growing businesses fix the people systems behind recurring workplace problems. If this resource raised a risk flag, do not guess your way through the next step.