Green = editable inputs. Grey = auto-calculated (Base + Incentive and % of total).
Define up to three metrics and their quarterly targets (like the Regional Manager sheet). Year is SUM for $ / #, AVERAGE for %.
| Targets |
Type |
Q1 |
Q2 |
Q3 |
Q4 |
Year |
Will populate after you build the structure.
Tranche Performance + payout % grid copied from the Regional Manager logic (0 → 49.9 → 69.9 → 89.9 → 100).
Once setup is done, managers only enter actuals here. Attainment and payout per metric are auto-calculated.
Enter actuals to see the summary.
Enter actuals to see the payout figures.