Accelerator & Decelerator Curve Calculator
Models the payout curve from 50% to 150%+ quota attainment across a realistic team attainment distribution, so leaders see the true blended cost of a plan, not just its cost at 100%, before they sign off on it.
How to use it
Enter your own band multipliers and your team's actual historical attainment distribution into Steps 1–3, then compare the Step 3 total against your planned variable OTE budget in Step 4 before approving the plan.
What's inside
- Attainment-band rate/multiplier table template (0%–150%+)
- Marginal (band-by-band) per-rep payout formula
- Fully worked per-rep payout example at 130% attainment
- Blended team-cost formula across a realistic attainment distribution
- Worked 10-rep team cost example
- True-cost check against budgeted variable OTE
- Sensitivity flags: bimodal distributions, whale-deal risk, cliff vs. marginal mechanics
Step 1, Define the Attainment Bands
Replace with your own plan's multipliers (defaults shown):
| Attainment Band | Multiplier on Base Rate | Type |
|---|---|---|
| 0–49% | 0.5x | Decelerator |
| 50–79% | 0.75x | Decelerator |
| 80–99% | 1.0x | Standard |
| 100–119% | 1.5x | Accelerator |
| 120–149% | 2.0x | Accelerator |
| 150%+ | 2.5x | Accelerator |
Step 2: Per-Rep Payout Formula
`` Payout = Base Commission Rate × Revenue Sold × Band Multiplier (applied MARGINALLY, band-by-band) `` Marginal application matters: a rep at 130% attainment does NOT get the 120–149% multiplier on their entire revenue, only on the revenue that falls in that band. Getting this wrong is the single most common modeling error, and can overstate cost by 2–4x.
Worked example: Rep with $600,000 quota, 8% base rate, $780,000 actual sales (130% attainment):
| Band | Revenue in Band | Rate | Multiplier | Payout |
|---|---|---|---|---|
| 0–79% ($0–$474,000) | $474,000 | 8% | 0.75x | $28,440 |
| 80–99% ($474,000–$594,000) | $120,000 | 8% | 1.0x | $9,600 |
| 100–119% ($594,000–$714,000) | $120,000 | 8% | 1.5x | $14,400 |
| 120–130% ($714,000–$780,000) | $66,000 | 8% | 2.0x | $10,560 |
| Total | $780,000 | $63,000 |
Blended effective rate = $63,000 ÷ $780,000 = 8.08%, sanity-check this lands where Finance expects.
Step 3, Blended Team Cost
Don't model cost at "100% for everyone", no real team performs that way. Model against a realistic distribution: `` Total Plan Cost = Σ (# reps in each attainment bucket × Avg payout for that bucket) `` Worked example: 10-rep team, realistic distribution:
| Attainment Bucket | # Reps | Avg Payout/Rep | Bucket Cost |
|---|---|---|---|
| <50% | 1 | $18,000 | $18,000 |
| 50–79% | 1 | $32,000 | $32,000 |
| 80–99% | 3 | $44,000 | $132,000 |
| 100–119% | 3 | $58,000 | $174,000 |
| 120–149% | 1 | $72,000 | $72,000 |
| 150%+ | 1 | $95,000 | $95,000 |
| Total | 10 | $523,000 |
Step 4, True-Cost Check vs. Budgeted OTE
`` True Cost Variance = Total Plan Cost (Step 3) − (Headcount × Planned Variable OTE) `` If budgeted variable = $50,000/rep × 10 = $500,000, and modeled cost = $523,000, the plan runs 4.6% over budget even with an "average" attainment near 100%, because the accelerator tail costs more than the decelerator floor saves. Bring this number to Finance before approval, not after Q1 actuals.
Sensitivity Flags
- Bimodal distribution (reps cluster at very-low and very-high attainment) → re-run Step 3 against your actual last-4-quarter distribution; bimodal teams cost more than a bell-curve model predicts.
- Whale-deal risk: one large deal can push a rep from 100% to 300%+ attainment; if the top band is uncapped, model the cost of your single largest historical deal landing on the accelerator tail alone.
- Marginal vs. cliff mechanics: confirm your plan applies multipliers marginally, not retroactively to $1 once a threshold is crossed; cliff mechanics cost dramatically more and invite quarter-end gaming.