Sales capacity planning calculator
Most capacity plans multiply headcount by quota and call it a number. That assumes every rep is ramped on January 1, nobody leaves, and everyone hits 100%. None of those things happen. This calculator works rep by rep through the ramp, then applies attrition and a realistic attainment factor, so the gap to target shows up in the plan instead of in Q3.
Download it
What you get
- A rep-by-rep capacity table that counts ramp months at their actual percentage
- Separate lines for attrition and expected attainment, so each assumption is visible and arguable
- A gap-to-target calculation that converts directly into hires needed and by when
- A worked example where every number adds up
- An assumptions log so finance and sales are debating the same inputs
Who it's for
- RevOps leads building the annual headcount and bookings plan
- Finance partners pressure-testing sales hiring requests
- VPs of Sales who need to explain a gap to target in hires and dates
What's inside
6 sections, each listed with its own size. The first is previewed below; the remaining 5 come with the download, with blank rows ready to fill in.
| Section | Size | Previewed |
|---|---|---|
| Ramp schedule assumption | 3 columns, 5 worked example rows | Below |
| Rep-by-rep ramped capacity | 7 columns, 5 worked example rows | In the download |
| From ramped capacity to realistic capacity | 4 columns, 6 worked example rows | In the download |
| Turning the gap into hires | Guidance notes | In the download |
| Assumptions log | 6 fields to complete | In the download |
| Before you present the capacity plan | 7-point checklist | In the download |
Preview of section 1
Ramp schedule assumption
Percent of full monthly quota a rep is expected to carry by month of tenure. This example is a placeholder; replace it with the ramp your own reps actually achieved.
| Month of tenure | Ramp % | Full-month equivalents (cumulative) |
|---|---|---|
| 1 | 0% | 0.00 |
| 2 | 25% | 0.25 |
How to use it
1. Start from the ramp schedule, not headcount
Enter your ramp percentages by month of tenure first. A rep hired in July contributes a fraction of a full year, and the fraction is smaller than most people guess. The calculator counts it month by month.
2. List every rep, including hires not yet made
Put planned hires in the table with their target start month. If recruiting has historically slipped, push the start dates out by that slip now rather than hoping.
3. Apply attrition as its own line
Do not bury attrition inside a lower quota. Use your trailing twelve-month sales attrition rate as the haircut. If you do not have one, use a rule-of-thumb placeholder and flag it for replacement with your own data.
4. Use last year's median attainment, not 100%
Capacity at 100% attainment is a ceiling, not a forecast. Multiply by the attainment your team actually delivered. This is the step that separates a plan from a wish.
5. Convert the gap into dated hires
Divide the remaining gap by what one new hire contributes if they start in a given month. That tells you how many people you need and the latest date they can start, which is what recruiting needs to hear.
Frequently asked questions
How do you calculate sales capacity?
Add up each rep's ramped quota for the months they will be active, then reduce for expected attrition and multiply by realistic attainment. Ramped capacity = Sum over reps of (Full monthly quota x Ramp % for each active month). Headcount times quota overstates capacity every time.
What attainment rate should a capacity model use?
The median attainment your reps actually delivered over the last full year. Using 100% plans for the ceiling, not the likely outcome. If you have no history, use a conservative placeholder and replace it as soon as you have a year of data.
How should ramp be treated in capacity planning?
Month by month at the percentage a new rep is expected to carry. A rep hired mid-year contributes much less than half a year of capacity because the first months are heavily discounted.
What is the difference between capacity and quota?
Capacity is what the team can realistically produce given headcount, ramp, attrition, and attainment. Quota is what you assign. If total quota is far above realistic capacity, the plan is relying on over-performance to hit target.