Individual Payouts: Salary × Target × Company Factor × Multiplier
This lesson is part of the course
In this lesson
You look up each employee's target bonus % by grade and the multiplier by rating, combine them with the company factor into the payout, and total the payouts in one SUMPRODUCT to compare them with the funded pool.
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