Payout Summary: Cost vs Pool by Department and Fairness by Grade
This lesson is part of the course
In this lesson
You sum the final payouts per department with SUMIFS, measure how much of each department's pool is used, chart cost against pool and test whether payouts relative to target are fair across grades.
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
- Rating Distribution vs the Target Curve Locked
- Calibration: Z-Scores Within Each Manager Locked
- Relative Ranking: Percent Ranks and Rating Bands Locked
- Funding the Pool: Threshold, Target and Maximum Locked
- Individual Payouts: Salary × Target × Company Factor × Multiplier Locked
- Pro-Rating for Joiners, Leavers and Part-Timers Locked
- Fitting Payouts to the Budget: Scale, Round, Fix the Residual Locked
- Payout Summary: Cost vs Pool by Department and Fairness by Grade Locked