Headcount-to-Quota Capacity Calculator
A step-by-step reverse calculation that turns a revenue target into the exact number of reps you need to hire, split by ramp stage and adjusted for attrition, so headcount planning stops being a guess.
What's inside
- Input worksheet: revenue target, quota, attainment rate, ramp curve, attrition rate
- Step 1 formula: Quota-Capacity Required
- Step 2 formula: Ramp-Weighted Effective Capacity per rep
- Step 3 formula: Attrition-Adjusted Headcount to Hire
- Step 4 formula: Latest-Start-Date backwards scheduling
- Default customizable ramp curve table
- Two fully worked numeric examples
- Sensitivity checks — what silently breaks the model
Purpose
Given a revenue target, work backwards to the number of quota-carrying reps you actually need — accounting for the fact that new hires don't sell at full capacity from day one, average attainment is never 100%, and some reps leave before they fully ramp.
Step 0 — Inputs
| Input | Your Number |
|---|---|
| Net-new revenue target (period) | $__________ |
| Fully-ramped rep annual quota | $__________ |
| Expected average attainment rate (use trailing 4-quarter team average, not the target) | ____% |
| Ramp period (months to full productivity) | ____ months |
| Expected annualized attrition (voluntary + involuntary) | ____% |
| Planning window | ____ months |
Step 1 — Quota-Capacity Required
`` Quota-Capacity Required (FTE) = Revenue Target ÷ (Fully-Ramped Quota × Attainment Rate) ` Worked example: Target = $6,000,000. Quota = $600,000. Attainment = 80%. ` $6,000,000 ÷ ($600,000 × 0.80) = $6,000,000 ÷ $480,000 = 12.5 FTE ``
Step 2 — Ramp-Weighted Effective Capacity
New hires don't produce full quota from month one. Apply a ramp curve (edit to match your own sales cycle):
| Month since start | % of full quota productivity |
|---|---|
| 1–2 | 0% (enablement, shadowing) |
| 3–4 | 25% |
| 5–6 | 50% |
| 7–8 | 75% |
| 9+ | 100% |
`` Effective Capacity per Rep = Σ (months at each ramp stage × productivity %) ÷ 12 ` Worked example (rep hired day 1 of a 12-month window): ` (2×0%) + (2×25%) + (2×50%) + (2×75%) + (4×100%) = 0 + 0.5 + 1.0 + 1.5 + 4.0 = 7.0 months ÷ 12 = 0.58 effective FTE `` One new hire is worth 0.58 of a fully-ramped rep in year one — not 1.0.
Step 3 — Attrition-Adjusted Headcount
`` Headcount to Hire = (Quota-Capacity Required ÷ Effective Capacity per Rep) ÷ (1 − Attrition Rate) ` Worked example (15% annual attrition): ` 12.5 ÷ 0.58 = 21.6 reps if hired all at once on day 1 21.6 ÷ (1 − 0.15) = 21.6 ÷ 0.85 = 25.4 → round up to 26 reps ``
Step 4 — Latest-Start-Date Backwards Schedule
`` Latest Start Date = Target Date − Ramp Period − Hiring/Onboarding Buffer (recommend 1 month) `` If Q4 bookings are due Dec 31 and ramp is 8 months, reps needed at full capacity for Q4 must start by March 31 of the same year at the latest — earlier if you want any of Q4 above 75% productivity.
Sensitivity Check — What Breaks This Model
- Attainment rate is aspirational, not historical → capacity is silently overstated; always use trailing 4-quarter actuals.
- Ramp curve borrowed from a different segment/deal size → re-validate against your own last 3 cohorts' time-to-full-quota.
- Hiring assumed to land exactly on schedule → add 4–6 weeks recruiting-slippage buffer per req; tight labor markets need more.
- Attrition rate excludes involuntary/PIP exits → use total separations or you will under-hire.
Quick-Reference Formula Stack
```
- Quota-Capacity Required = Revenue Target ÷ (Quota × Attainment%)
- Effective Capacity per Rep = Σ(ramp-stage months × productivity%) ÷ 12
- Headcount to Hire = (Quota-Capacity ÷ Effective Capacity per Rep) ÷ (1 − Attrition%)
- Latest Start Date = Target Date − Ramp Period − Hiring Buffer
```
How to use it
Plug your revenue target, quota, attainment rate, ramp curve, and attrition rate into the four formulas in order — the output is the exact headcount number and the latest hire date needed to hit the target.