Commission across multiple rate slabs. The Tiered Commission Calculator takes sales for the period, tier 1 upper limit, tier 1 rate, tier 2 upper limit, tier 2 rate, rate above tier 2 and returns total commission plus effective commission rate, commission from tier 1, commission from tier 2, commission above tier 2. Results update as you type, and the formula is shown under the result so you can repeat it in your own spreadsheet.
Pricing and sales metrics decide how much of the value you create you actually keep. Test price changes against margin, not volume alone, and measure the pipeline consistently so forecasts can be trusted. Use the worked example below to check the maths against your own figures.
How the Tiered Commission Calculator works
Tiered plans pay a higher rate only on the sales within each band (marginal tiers), so the effective rate rises gradually. Some plans pay the top rate on everything once a threshold is passed; check which yours does.
Worked example
With the example values (sales for the period of $120,000, tier 1 upper limit of $50,000, tier 1 rate of 5%, tier 2 upper limit of $100,000, tier 2 rate of 7%, rate above tier 2 of 10%), the total commission is $8,000.00; effective commission rate 6.67%, commission from tier 1 $2,500.00, commission from tier 2 $3,500.00, commission above tier 2 $2,000.00. Change any figure above and the result updates immediately; use Copy results to paste the summary into a note or email.
Related Calculators
Frequently Asked Questions
How is total commission calculated?
commission = sales in each tier × that tier's rate, summed.
Which figures do I need?
Sales for the period, tier 1 upper limit, tier 1 rate, tier 2 upper limit, tier 2 rate, rate above tier 2. Take them from the same period and the same set of accounts or reports so the ratio is consistent, and check the example values as a guide to the units expected.
Should I test a price change before rolling it out?
Yes. Model the margin impact here first, then test on a segment or product line and measure volume and margin before applying it everywhere.
