// GuidesTemplate
Sales capacity planning model template: reps = target ÷ (quota × attainment) (2026)
Short answer
Reps needed = revenue target ÷ (quota per ramped rep × the share of quota a ramped rep delivers), then add hires for ramp and attrition, and one manager for roughly every eight seats. Use your own trailing four quarters for attainment; the published figures count reps rather than quota delivered: 47% of sellers at quota with a median seller at 101% (Forrester, 2023) and 48% of reps hitting annual quota (Bridge Group, 2026, which puts ramp at 6.2 months). The template below adds the column most models lack, which is who watches each assumption weekly, one rep at a time.
What is the sales capacity planning formula?
Reps needed equals the revenue target divided by what one ramped rep delivers in a year, and one ramped rep delivers quota times expected attainment. Ramp, attrition and span do not change the formula; they adjust the count for reps who are not yet productive, will not stay, or will not be managed.
QuotaPath’s capacity planning guide (December 2024) gives the bare version: "A company aiming for $10M in revenue with average quotas of $500K per rep would require 20 reps." That is the formula at 100% attainment; the same page puts the share of reps who typically hit quota at about 51%. At 80% attainment the 20 reps become 25; at 70%, 29.
Write the units down first. Target is new revenue closed this year in one definition (new ARR, bookings or gross margin); quota is the annual number for a rep past ramp.
The sales capacity model template: four assumptions and who watches each one weekly
Copy the table into your planning sheet. The last column is what most templates leave out.
| Assumption | Planning value | Observed benchmark | Source | Who watches it weekly |
|---|---|---|---|---|
| Attainment (ramped rep, full year) | 60–80% of quota; 70% in the example (our rule of thumb) | 47% of sellers at quota, median seller at 101%; 48% of reps hit annual quota, down from 51% in 2024 | Forrester 2023; Bridge Group 2026 | The rep’s manager: pipeline created, committed deals gone quiet, win rate per rep |
| Ramp | Months to full quota by segment; count half output during ramp | 6.2 months for AEs, "the highest in this research's history"; 3–6 months typical in SaaS | Bridge Group 2026; QuotaPath 2024 | The new rep’s manager: first meetings, pipeline created, first deal past discovery |
| Attrition | 20% annualized; each leaver means a backfill plus a full ramp | "20% to 30% annualized attrition" called normal; 20% in QuotaPath’s example | Mostly Metrics, September 2025; QuotaPath 2024 | The rep’s manager: activity fading, threads going quiet, 1:1s skipped |
| Manager span | One manager per 8 seats in SMB, per 5 in enterprise | 8:1 SMB, 5:1 enterprise; average "8 ½ direct reports", range 2 to 38 | Mostly Metrics, September 2025; Alexander Group (first published 2013, updated 2024, per the page’s metadata) | The VP, monthly: 1:1s held, flagged reps acted on, coaching hours |
| Quota per rep and quota-to-OTE | Your comp plan; check the ratio | Median AE quota $960K, OTE $200K, ratio 4.6× | Bridge Group 2026 | RevOps and finance, at plan and at each quarterly re-plan |
| Over-assignment | Sum of quotas at 120–130% of target, ramp quotas prorated | "Most companies over-assign quotas by 20-30%" | Mostly Metrics, September 2025 | RevOps at plan; the CEO reads the sum before quotas go out |
Which attainment to plug in. The model needs the share of quota a ramped rep delivers over a year, and none of the benchmarks cited here publishes that. Forrester (March 2023) reports that 47% of B2B sellers hit quota while the median seller reached 101%, and The Bridge Group (June 2026) puts the share of reps at annual quota at 48%. Both count reps who hit quota, so neither goes into the formula as it stands. Take average attainment for ramped reps over a full year from your own data. 60–80% is our rule of thumb; at 80% you over-assign quota by 25%, inside the 20–30% Mostly Metrics calls common. See quota attainment benchmarks for the reconciliation.
Watch out
Set in Q4, watched by nobody
The error is rarely the arithmetic. It is carrying last year’s attainment, ramp and attrition into the model with nobody assigned to notice when a rep’s weeks leave the assumption behind.
A worked example: a $9M target with a 10-rep team (illustrative)
Every line is illustrative except the quota (a Bridge Group 2026 median) and the ramp (Bridge Group’s 2026 figure). Read it for the shape and replace each line with your own.
| Line | Value | How it is computed |
|---|---|---|
| Revenue target for the year | $9,000,000 | Set by the CEO |
| Quota per ramped rep | $960,000 | Bridge Group 2026 median AE quota |
| Planning attainment, ramped rep | 70% | From the template |
| Output per ramped rep-year | $672,000 | $960,000 × 0.70 |
| Ramped rep-years needed | 13.4 | $9,000,000 ÷ $672,000 |
| Ramped reps on January 1 | 10 | Your roster |
| Attrition, 20% a year, leaving mid-year on average | −1.0 rep-year | 10 × 0.20 × 0.5 |
| Output from the existing team | 9.0 rep-years, $6.05M | (10 − 1.0) × $672,000 |
| Gap | 4.4 rep-years, $2.95M | 13.4 − 9.0 |
| First-year output of a January hire, 6.2-month straight-line ramp | 0.74 rep-year | Half output for 6.2 months (0.26), full output for 5.8 months (0.48) |
| Hires needed in January to close the gap | 6 | 4.4 ÷ 0.74, rounded up |
| Backfills for the two leavers | 2 | Nothing this year; protects next year |
| Total hires | 8 | Twice the 4 the bare formula gives (13.4 − 10, rounded up) |
| Seats by year end | 18 | 10 + 8 |
| Managers at 8:1 | 2 to 3 | 18 ÷ 8 = 2.25; the second manager is hired first |
QuotaPath (December 2024) states the buffer as a rule: "For a 20% annual turnover rate and 6-month ramp-up, the company may need to hire 25% more reps than planned". Here it is larger, because the new hires also carry the gap in the year they ramp. Start dates matter most; an April start instead of January gives up about a third of first-year output (0.49 against 0.74 rep-years).
| Planning attainment | Ramped rep-years needed | Against the 70% line |
|---|---|---|
| 50% (a stress case) | 18.8 | +5.4 |
| 60% | 15.6 | +2.2 |
| 70% | 13.4 | 0 |
| 80% | 11.7 | −1.7 |
Seven reps of difference on a ten-rep team. Argue this assumption hardest at plan time and watch it closest during the year.
Sales ramp time benchmarks: how long until a new rep carries a full quota?
About six months for an account executive. The Bridge Group (June 2026) found that the experience companies ask for at hire rose to 3.7 years, from 2.7 years in 2022, and that ramp still reached 6.2 months: "That's the highest in this research's history." Vendor pages publish ranges by role; none of the pages we read defines ramped, so they disagree.
| Source | Year | Role or segment | Ramp | Provenance |
|---|---|---|---|---|
| The Bridge Group | 2026 | AE, 158 B2B companies | 6.2 months | Publisher’s own survey, 10th edition |
| QuotaPath | 2024 | SaaS | 3–6 months, typical | Vendor guidance, no sample stated |
| Mostly Metrics | 2025 | SMB / mid-market / enterprise | 2–3 / 4–6 / 6–9 months | Newsletter rule of thumb |
| Chambr | 2026 | SDR / full-cycle AE (SMB, mid-market) / enterprise AE | 2–3 / 4–6 / 7–12 months | Vendor ranges; no definition of ramped |
| Bridge Group 2020 and 2024, as cited by Chambr | 2026 | AE | 4.3 months in 2020, 5.7 months in 2024 | Secondhand; the 2024 report not checked here |
Write the definition into the plan before the number. First closed deal, a sustained share of the monthly run-rate, and full quota are all in use, and they differ by months for the same rep. Our rule of thumb is two consecutive months at or above 80% of the monthly run-rate.
A ramp that will stall shows it by week four, in numbers the new rep’s manager already has, such as first meetings booked and pipeline created. A model that only counts a hire as ramped at month six finds the miss at month nine, when the backfill should have started.
What breaks the plan mid-year, and who notices first?
The plan breaks one rep at a time, and the first person who can see it is that rep’s first-line manager, weeks before a number in the model moves.
| What breaks | When the model reports it | Where it shows first | Who sees it first |
|---|---|---|---|
| A new hire’s ramp stalls | Month 6 or 7 | Week 4: no first meetings, no pipeline created | The rep’s manager |
| A ramped rep drifts toward leaving | The quarter after the resignation | Weeks before: activity fading, threads going quiet, 1:1s skipped | The rep’s manager |
| Attainment slides | Quarter end, as a miss | Mid-quarter: pipeline created per rep falls, committed deals go quiet | The rep’s manager, then the VP |
| A manager is over span | Never; span is a cost line | 1:1s slip, flagged reps go unactioned, deals go stale | The VP, if the VP looks |
How diffi helps
The model stays yours; diffi works where the plan breaks, one rep at a time. Each first-line manager gets a living file per rep from Salesforce or HubSpot (read-only; it does not write to your CRM), the public Slack channels and the Gmail labels or Outlook folders the manager selects (the whole inbox if none is selected), and the calendar. A new hire’s file shows meetings held, pipeline created and deals that moved or went quiet, so a stalling ramp is a conversation in week four. For a ramped rep, diffi flags disengagement, pipeline and performance risk with the evidence behind each. As the VP or CEO, ask each manager monthly to open their team and show which reps are ramping, at risk or drifting, and what was done; the numbers and the hiring calls stay yours. Book a demo to see what a manager sees the week a ramp slips.
See it on your own teamHow often should you re-plan sales capacity?
Quarterly for the numbers, monthly for the people. An hour a quarter keeps the four assumptions honest; the monthly per-manager review above is where the early evidence comes from.
Quarterly capacity re-plan (about an hour)
- Replace planning attainment with the trailing four quarters, ramped reps only, and re-run the sensitivity table.
- Re-measure ramp on the last eight hires against the written definition; move the assumption if the median shifted by more than a month.
- Recount attrition as regretted and not; ask each manager which leavers they had flagged, and how early.
- Recount seats per manager; any manager above ten reps becomes a manager hire in the plan.
- Compare hires started with hires planned, by month; a class that slipped a quarter lost about a third of its first-year output.
- Check the sum of quotas after backfills and prorated ramp quotas; keep it at 120–130% of the target.
Frequently asked questions
How do you calculate how many sales reps you need?
Divide the revenue target by what one ramped rep delivers in a year, which is quota multiplied by expected attainment. Then add hires for the months new reps spend ramping and for the reps who will leave, and one manager for roughly every eight seats. A $9M target at a $960K quota and 70% attainment needs 13.4 ramped rep-years, which on a 10-rep team means 8 hires once ramp and 20% attrition are counted (illustrative).
What quota attainment should you assume in a sales capacity model?
Average attainment for ramped reps over a full year, taken from your own trailing four quarters; 60–80% is a common planning range (our rule of thumb). The published figures measure something else: Forrester (2023) reports 47% of sellers at quota with a median seller at 101%, and the Bridge Group (2026) 48% of reps at annual quota. Those are shares of reps who hit quota, not the share of quota a rep delivers.
How long does it take a new sales rep to ramp?
About six months for an account executive. The Bridge Group (2026) measured 6.2 months, the highest in its research’s history, and QuotaPath (2024) puts SaaS at typically 3–6 months. Vendor ranges run from 2–3 months for SDRs to 7–12 months for enterprise AEs. Define ramped before you pick a number; the benchmarks disagree because the definitions do.
How much extra headcount should you plan for sales attrition?
More than the attrition rate. QuotaPath (2024) gives the rule "For a 20% annual turnover rate and 6-month ramp-up, the company may need to hire 25% more reps than planned", and Mostly Metrics calls 20% to 30% annualized attrition normal. Each leaver costs the rest of their year, the vacancy and a full ramp on the replacement, so the backfill belongs in the same quarter as the resignation.
How many reps per manager should a capacity model assume?
Eight per manager in SMB and five in enterprise, the spans Mostly Metrics plans with; Alexander Group measures the average first-line manager at 8 ½ direct reports, with a range from 2 to 38. Put span in the model as a cost line, and treat any manager above ten reps as the assumption most likely to break the other three.
Is there a sales capacity model template in Excel or Google Sheets?
The template table on this page copies into any sheet as six rows, attainment, ramp, attrition, span, quota per rep and over-assignment, each with a planning value, an observed benchmark, a source and an owner. Add the worked example as a second tab and the sensitivity table as a third. Whatever sheet you use, keep the "who watches it weekly" column; that is the part that makes the plan survive the year.