Rep earnings from 50% to 150% quota attainmentEvery curve uses the same bookings and clawback assumptions
Business
Sales Commission Scenario Calculator
Compare three different incentive philosophies on one sales book. The flat plan rewards revenue uniformly, the tiered plan changes payout above quota, and the margin plan pays on gross profit. The model keeps rep earnings, payout rate, company retained contribution, and downside clawback exposure visible at current attainment and across an attainment curve.
Highest current rep payout-
Flat-plan payout-
Tiered-plan payout-
Margin-plan payout-
Lowest company payout rate-
Highest retained contribution-
Current bookings-
Plan payout spread-
Highest plan payout as a share of gross profit
Compensation landscape
Compare three plan philosophies across the full attainment curve
Rep payout curvesCurrent attainment marker
| Plan | Bookings | Gross profit | Gross payout | Net payout | Payout/bookings | Retained contribution |
|---|
Plan comparison
Hold sales performance constant before judging incentive mechanics
- Enter quota and the attainment level to evaluate.
- Set the gross margin shared by all three plans.
- Define the flat revenue rate.
- Define the tiered base, threshold, and accelerator rates.
- Define the gross-profit rate, then compare rep pay with company retained contribution.
Three incentive philosophies
Each curve rewards a different economic behavior
The flat plan values every revenue dollar equally. The tiered plan concentrates reward above quota. The margin plan changes pay with the profit quality of the booked revenue.
Detailed calculation process
Price all three plans on the same bookings and clawback base
Bookings = Monthly quota × AttainmentGross profit = Bookings × Gross marginFlat payout = Bookings × Flat rateTiered payout = min(Bookings, Threshold bookings) × Base rate + max(0, Bookings − Threshold bookings) × Accelerator rateMargin payout = Gross profit × Margin-plan rateNet payout(plan) = Gross payout(plan) × (1 − Clawback rate)Attainment, margin, rates, threshold, and clawback are converted from percentages to decimals. The payout-rate check divides net payout by bookings. Retained contribution reconciles gross profit less net payout for each plan.
Design examples
Use the curves to expose plan tradeoffs
Growth push: leadership tests whether a 10% accelerator above quota creates a meaningful earnings slope without consuming too much contribution.
Discount discipline: finance compares the margin plan with revenue plans when gross margin falls, making the cost of rewarding low-quality bookings visible.
Three-plan payout reconciliation
Hold bookings constant and isolate compensation mechanics
Flat payout = $112,000 x 6% x (1 - 3%) = $6,518Tiered payout = [$100,000 x 4% + $12,000 x 10%] x (1 - 3%) = $5,044Gross-profit payout = $112,000 x 62% x 9% x (1 - 3%) = $6,062The tiered plan is $1,474 below the flat plan at the default attainment level and retains $64,396 of contribution after commission. That comparison isolates plan design; it does not assume behavior stays unchanged after adoption.
Plan-review questions
Pressure-test behavior as well as math
- Does credit follow bookings, billings, or collections?
- Which discounts require approval?
- How are multi-rep splits handled?
- What events trigger a clawback?
Behavioral limitation
The calculator does not predict motivation
Changing the plan may change effort, deal mix, discounting, risk selection, and retention. The scenario deliberately holds sales constant to isolate mechanics; test behavioral effects separately.
Sales commission scenario FAQ
Questions about fair plan comparison
Why show the full attainment curve?
A plan that looks similar at 100% may behave very differently below or above quota.
Which plan is best?
The highest payout is not automatically best; align the slope with strategy, controllability, and margin quality.
Can the gross-profit plan exceed the revenue plan?
Yes, depending on gross margin and the entered rate.
Practical examples
Sales Commission Scenario Calculator in real planning situations
- Compare a 6% flat plan with a 4%/9% accelerator.
- Test whether a margin-based plan protects contribution on discounted deals.
- See how each plan behaves from 50% to 150% quota attainment.
Important note
Before relying on this result
Calculated from the entered values using the displayed accounting method. Reconcile material decisions with source records and applicable accounting policy.
Additional Sales Commission Scenario Calculator questions
Why compare plans at the same bookings?
It isolates plan mechanics before assuming a motivational lift.
Does the margin plan require product-level costs?
The model uses one blended gross-margin percentage; detailed mixes need product-level modeling.
Are clawbacks applied to all plans?
Yes, so plan design—not different recovery assumptions—drives the comparison.