Costing Green Circles and Red-Circle Freezes
This lesson is part of the course
In this lesson
You cost every green circle up to the range minimum and measure every red circle above the maximum with MAX(0, …), total both by department and express the fix as a share of payroll.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Point-Factor Job Evaluation: From Factor Levels to Grades Locked
- Aging and Blending Market Survey Data Locked
- Designing Salary Ranges: Midpoints, Spreads & Overlap Locked
- Compa-Ratios, Range Penetration & Green/Red Circles Locked
- Raw vs Grade-Adjusted Pay Gaps Locked
- The Merit Matrix: Rating × Compa-Ratio → Increase Locked
- Costing Green Circles and Red-Circle Freezes Locked
- Capstone: Pay Structure Summary & Scatter Chart Locked