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.

Category:: Territory & Quota
Formats:: PDF + CSV + web view
Sections:: 6
Updated:: September 24, 2026

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

1
Ramp schedule assumption
3 columns, 5 worked example rows
2
Rep-by-rep ramped capacity
7 columns, 5 worked example rows
3
From ramped capacity to realistic capacity
4 columns, 6 worked example rows
4
Turning the gap into hires
Guidance notes
5
Assumptions log
6 fields to complete
6
Before you present the capacity plan
7-point checklist

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

The preview shows part of section 1. The full template has all 6 sections (5 not previewed here), with blank rows ready to fill in. Download the full template

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.