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.
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.
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.