Free · no email · runs entirely in your browser

reps × quota × attainment
is not a plan.

Real capacity depends on when reps start, how long they ramp, and who leaves. QuotaMath walks your year month by month — so the number you take to the board is one finance will sign. This is a free sales capacity planning calculator: no signup, no email gate.

Your plan — ramp & attrition adjustedLive
Effective capacity
what this team can actually sell
Coverage of target
Gap to target
Rep-years short
fully-ramped rep-years missing
Sellable capacity / month vs required run-rate ----
ramped reps new hires (ramping) required run-rate
Edit this plan ↓
5.7 mo
average B2B sales ramp — Bridge Group
30%
median annual rep turnover — Bridge Group
43%
of reps hit quota, n≈47k — RepVue Q2 '25
$1.4M
gap the naive formula hides — sample plan below
Your plan
The worksheet

Punch in your numbers. See your real gap.

The verdict — in plain language
Sellable capacity / month vs required run-rate ----
ramped reps new hires (ramping) required run-rate
View chart data as table
01

Target & team

Annual new-business target, fully-ramped reps today, and quota per rep.

02

Honest assumptions

Use your trailing 12-month attainment — the B2B median is 50–70%, not 100%.

03

Hiring & attrition

Hires per quarter and your annual rep attrition rate. Both move the answer more than you think.

04

Read the gap

Coverage tells you if the plan works; the walk shows when capacity actually arrives.

How the math works

Same team. Same quota. $1.4M apart.

The naive formula
reps × quota × attainment

Ignores ramp and attrition. Overstates capacity all year — the miss shows up in Q4.

The annual average
average heads × quota × attainment

Closer on the full year, but hides quarterly timing misses and hiring deadlines.

Month-by-month
Σ monthly sellable capacity

What this calculator does: ramped reps, ramping hires, and attrition — walked across all 12 months.

Three adjustments the naive formula skips

01

Ramped reps decay

Existing reps produce quota × attainment ÷ 12 each month — reduced pro-rata as attrition bites.

02

New hires ramp, not arrive

A Q1 hire is worth ≈75% of a full rep-year. A Q3 hire? ≈25%. Hiring timing is half the plan.

03

Gaps in rep-year equivalents

The shortfall is expressed in ramped-rep-years — the language a CRO can actually hire against.

Sales capacity model for Excel

The version finance actually signs off on.

  • Month-by-month hiring plan — not quarterly buckets
  • Editable ramp curve: linear, S-curve, or custom by month
  • Attrition with backfill lag + cost of open territories
  • Base / Upside / Downside scenarios side by side
  • Capacity walk chart + hiring deadline table, board-deck ready
Sales capacity model for Excel
$9.99
one-time · no subscription
Get the Excel model
Instant download · Excel & Google Sheets

Questions, answered honestly

What is sales capacity planning?

Working out how much revenue your team can actually produce — given headcount, quotas, realistic attainment, ramp time, and attrition — and comparing it to target to decide how many reps to hire, and when. Effective capacity is almost always lower than reps × quota.

What attainment should I assume?

B2B median is 50–70%. The calculator defaults to 70% — deliberately on the optimistic side of the benchmarks. If your board deck assumes 100%, that is the first fix.

How long do reps take to ramp?

SMB 3–4 months, mid-market 4–6, enterprise 6–9+. The Bridge Group pegs the cross-segment average at 5.7 months. More in the ramp-time benchmarks.

Why does hiring timing matter so much?

Ramp is paid up front. On a 5-month ramp, a January hire contributes ≈83% of a rep-year; hired in October, ≈10%. Two identical headcount plans can differ by millions purely on start dates. The full math is in the capacity formula guide.

How is capacity computed?

Month by month: existing reps contribute quota × attainment ÷ 12, reduced pro-rata by attrition; new hires contribute on a linear ramp curve from their start month. Defaults are anchored to published benchmarks — Bridge Group SaaS AE research (5.7-mo ramp, 30% turnover, 51% of AEs at quota) and RepVue's Q2 2025 Cloud Sales Index (≈43% attainment, n≈47,000). The same engine powers the Excel model.

Where does my data go?

Nowhere. The calculator runs entirely in your browser — no data leaves the page, no email required.

Coverage Gap