Fair Pay Architecture: Job Grading, Range Design, Compa-Ratios & Merit Budgets
Score jobs into grades, age and blend market data, design salary ranges, measure compa-ratios and pay gaps, spend a merit budget to the cent and cost the outliers at one fictional company, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you build a complete pay structure for one fictional company, step by step in a live spreadsheet. You score jobs on weighted factors with SUMPRODUCT and place them in grades with an approximate-match lookup, age three salary surveys to one date and blend them, then design midpoints, minimums, maximums and range overlap. You calculate compa-ratios and range penetration, flag green and red circles with IFS, compare raw and grade-adjusted pay gaps with AVERAGEIFS, look up merit increases in a two-way matrix, scale them onto the budget pool and cost the outliers. A scatter chart of salary by grade closes the course.
Lessons
- Point-Factor Job Evaluation: From Factor Levels to Grades Pro
- Aging and Blending Market Survey Data Pro
- Designing Salary Ranges: Midpoints, Spreads & Overlap Pro
- Compa-Ratios, Range Penetration & Green/Red Circles Pro
- Raw vs Grade-Adjusted Pay Gaps Pro
- The Merit Matrix: Rating × Compa-Ratio → Increase Pro
- Costing Green Circles and Red-Circle Freezes Pro
- Capstone: Pay Structure Summary & Scatter Chart Pro