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