Employee Commission Analysis
Calculate tiered commission for six reps, where each rate applies only to the slice of sales inside its tier, then add a quota bonus and summarise the team.
What you will practise: Apply marginal tier rates to the slice of sales inside each tier using MIN and MAX, add a threshold bonus, and summarise the plan's cost.
Premium
This is a Premium exercise
Premium members can open this exercise and practise it in the spreadsheet.