Sales planning: how to calculate quota and team capacity

Reliable sales planning crosses two calculations: the target the executive team wants, top-down, and the revenue the customer base, the funnel and the team can deliver, bottom-up. The bottom-up math starts with the revenue the base renews and expands, works out how much new revenue is missing, converts that amount into customers, opportunities and reps, discounts the ramp of new hires and the expected departures of current ones, and ends with the pipeline marketing and pre-sales need to generate each month. When the two calculations do not meet, the gap becomes a list of levers with an owner and a deadline. In most of the companies I work with, the target arrives ready-made from the budget, and the sales director finds out in April that the hiring should have started in October.

At year-end, the executive team closes the budget with 30% growth, finance splits the number into twelve installments and the sales director spreads the target across reps based on each one’s history. Nobody asks how many opportunities the funnel needs to generate in December to close in March, or how long a rep hired in February takes to close a first contract. By the second quarter the monthly target is already above what the team delivers, and the conversation shifts from planning to pressure.

Why doesn’t the top-down target match the team?

The top-down target answers a legitimate question, how much the company needs to grow to fund its investment plan. The problem starts when the executive team takes that number straight to rep quotas without checking capacity. A growth percentage says nothing about how many customers the base will lose, how many opportunities marketing generates per month or how many reps will be fully productive in each quarter.

Gartner recorded this gap in a survey of nearly 300 people responsible for sales operations at complex B2B organizations. Leaders saw returns from analytics in sales force sizing and named quota setting, territory planning and territory design as the areas where they had not yet tapped the potential of analytics (Gartner, 2020).

How do you build a bottom-up sales plan?

The math follows the order of the money: first the customer base, then the new revenue still missing, then the funnel that generates it and, last, the people who run the funnel. Each step depends on an assumption measured in the CRM or by finance, using the last four quarters of history.

Start with the base: renewal, churn and expansion

In a recurring revenue business, most of next year’s revenue is already under contract. The first question is how much of that base stays, and the answer comes from GRR, gross revenue retention, and expected expansion, which I explain in RevOps metrics. If the base loses 10% of its revenue per year to cancellations and downgrades, the sales team starts the year owing that amount. Companies that sell projects run the same math with the repurchase rate of active customers.

New revenue, average deal size and number of customers

The new revenue required is the target minus the base that remains after churn and expansion. Divided by the average deal size of a new customer, it becomes a number of customers. Deal size has to be broken down by segment, because a single average hides that each segment requires a different volume of opportunities. The average discount also lives in this assumption: the larger it is, the smaller the deal and the more customers the plan needs, a subject I cover in discount policy.

Stage conversion and cycle: how many opportunities per month

Stage conversion tells you how many opportunities the funnel needs to reach the number of customers. Use conversion by entry cohort, the share of opportunities created in a quarter that ended up won, in place of the default probability configured in the CRM. The sales cycle defines when those opportunities need to exist: with a median cycle of 90 days, the pipeline for next year’s first quarter forms in the last quarter of the current year.

Rep capacity, ramp and expected attrition

The capacity of a fully ramped rep is the new revenue that person closes in a year with a supplied funnel, measured as the average of reps with more than a year at the company. A new rep produces a fraction of that capacity during ramp, and the ramp curve comes from the company’s own recent hiring classes, as I show in sales onboarding. The math also accounts for who will leave: if the company loses one rep per year on average, the plan removes that capacity from the likely month of departure and adds the replacement with its full ramp.

The pipeline marketing and pre-sales need to generate

The historical source mix separates what comes from inbound from what comes from outbound prospecting. The conversion of qualified leads into opportunities tells you how many leads marketing needs to deliver per month, and the productivity of each SDR, the person who prospects and qualifies before the account executive, tells you how many people pre-sales needs.

Sales planning example: the full calculation

The example is hypothetical, with round numbers invented to show the math, and none of them is a benchmark for your market. The company sells a recurring B2B service, ends 2026 with R$ 10 million in annual recurring revenue (ARR, the sum of active contracts annualized) and has four fully ramped reps. The executive team wants 30% growth in 2027.

Step	Math	Result
Executive target	10.0 × 1.30	R$ 13.0 million in ARR
Expected loss in the base	GRR of 90%	minus R$ 1.0 million
Expected expansion in the base	6% of 10.0	plus R$ 0.6 million
New revenue required	13.0 minus the 9.6 base	R$ 3.4 million
New customers	3.4 million ÷ R$ 48 thousand deal size	71
Opportunity-to-win conversion	50% to proposal × 30% proposal to win	15%
Opportunities in the year	71 ÷ 0.15	473, about 40 per month
Qualified leads per month	24 inbound opportunities ÷ 25%	96
SDRs	16 outbound opportunities ÷ 8 per SDR	2
Current team capacity	4 ramped reps at R$ 720 thousand, one departure in June and a replacement in July	R$ 2.59 million
Hires	Two in January and one in April, with ramp	plus R$ 1.01 million
Planned capacity	2.59 plus 1.01	R$ 3.60 million, 6% headroom

Capacity depends on ramp. In the example, a new rep produces nothing in the first quarter at the company, 40% in the second, 80% in the third and 100% from the fourth onward. With R$ 60 thousand of full monthly capacity, a January hire delivers R$ 396 thousand in 2027, an April hire delivers R$ 216 thousand and the July replacement delivers R$ 72 thousand, while the rep who leaves in June takes six months of capacity, R$ 360 thousand. Two January hires would leave the plan R$ 16 thousand short of the target with no room for delay, which is why the example includes a third.

A note for finance: a contract signed in November adds R$ 48 thousand to ARR and only two months to revenue recognized in 2027, and each team needs to say in the meeting which of the two numbers it is presenting.

Who owns each assumption in the plan?

The plan holds up when each assumption has an owner who answers for it during the year and a source someone else can check. Without an owner, the assumption becomes a negotiated guess: marketing accepts an optimistic conversion to lower its own lead target, sales accepts a high deal size to lower the number of customers, and the plan closes on paper with numbers nobody will defend in June.

Assumption	Owner	Where the number comes from
Starting ARR and GRR	Finance, with CS	Billing and cancellations recorded in the CRM
Base expansion	CS, with sales	Expansion pipeline and upgrade history
Deal size by segment	Sales leadership, with finance	Won deals from the last four quarters
Stage conversion and cycle	Sales management, with RevOps	Funnel report by cohort and create and close dates
Source mix and lead conversion	Marketing	Contact source and lead status in the CRM
SDR productivity	Pre-sales leadership	Opportunities accepted by sales, per SDR
Ramped rep capacity	Sales leadership	Average of ramped reps over the last four quarters
Ramp curve	Sales management, with HR and L&D	Performance of recent hiring classes
Expected attrition and time to hire	HR	History of departures and sales job openings

An assumption that came from a conversation enters the plan flagged as an estimate, with the date when someone will replace it with a measured number.

How do you reconcile the top-down target with the bottom-up math?

In the example, the current team without new hires reaches R$ 12.19 million in ARR, about 22% growth, and the 30% requires three new reps starting by April. Presented this way, the gap shows that each point above the bottom-up math has a cost, a deadline and an assumption that still needs to hold.

The most common levers are reducing churn, increasing expansion, raising conversion or deal size and shortening ramp, and each depends on a different team. One point less of churn is worth R$ 100 thousand in the example and depends on customer success, with the retention plan I discuss in B2B churn. Raising proposal-to-win conversion from 30% to 33% cuts the opportunities required by about 9%, and it only enters the plan if sales shows a pilot of at least one quarter that supports the improvement. A lever without evidence stays on record as a possibility and does not lower the lead target or the hiring plan.

Conservative, base and aggressive scenarios

Each scenario changes a few assumptions, with values leadership considers plausible, and keeps the others the same.

Assumption or result	Conservative	Base	Aggressive
GRR	88%	90%	92%
Base expansion	4%	6%	8%
Ramped rep capacity	R$ 630 thousand	R$ 720 thousand	R$ 780 thousand
Hire start dates	Two in April and one in July	Two in January and one in April	Two in January and one in April
New revenue in the year	R$ 2.71 million	R$ 3.60 million	R$ 3.90 million
Year-end ARR	R$ 11.91 million	R$ 13.20 million	R$ 13.90 million
Growth	19%	32%	39%

The conservative scenario shows the weight of the calendar: with hires one quarter late and slightly worse retention and productivity, growth drops from 32% to 19%. Each scenario serves one decision. The company publishes as its target a number the base scenario supports, in the example the 30% with two points of headroom, finance plans cash and overhead on the conservative case, and the aggressive case becomes a list of triggers, such as opening one more position if first-quarter conversion beats the agreed value.

Spread the target along the capacity curve

In the base scenario, the first quarter supports R$ 720 thousand of new revenue, the second R$ 864 thousand, the third R$ 900 thousand and the fourth R$ 1.12 million. With R$ 3.4 million divided by twelve, a target of about R$ 283 thousand per month puts the first quarter 18% above capacity, and reps spend three months chasing a number the plan knew was out of reach. A new rep’s quota follows the same curve, in proportion to ramp, and the design of variable pay on top of it is in sales commission.

How many reps should you hire, and when?

The capacity gap divided by each hire’s contribution to the year gives the answer, and that contribution depends on the start month. The hiring calendar is born with the target: whoever needs to produce in the second quarter starts in January, and the position opens in October.

Start month	Open the position by	Contribution to 2027 in the example	First fully ramped quarter
January	October of the prior year	R$ 396 thousand	Q4 2027
April	January	R$ 216 thousand	Q1 2028
July	April	R$ 72 thousand	Q2 2028
October	July	None	Q3 2028

A position opened in July weighs on the 2027 salary budget and delivers almost all of its capacity in 2028. Replacements for departures go on the same calendar: if the company only opens the position after the resignation, with 90 days to hire and the ramp in the example, each departure costs about eight months of full capacity.

How do you review the sales plan every quarter?

The quarterly review compares each assumption with actuals and reruns the math. It plays a different role from the sales forecast, which looks at open deals in the current period; here leadership checks whether the year’s hypotheses still hold, with each owner presenting their row and RevOps rerunning the calculation before the meeting.

Two rules keep the review from turning into a target renegotiation. The quota published to the team stays, while the hiring plan, the marketing budget and the pipeline target adjust. The triggers are written before the year starts, such as moving a hire forward if departures exceed the expected number or reinforcing outbound if inbound stays below 80% of plan for two consecutive months.

What changes for each leader, and why must managers defend the math?

The sales director starts defending assumptions: they arrive at the meeting with measured conversion, cycle and capacity and show what has to be true for the executive number to happen. Marketing receives a monthly target for leads and opportunities, with the date each batch needs to exist. Customer success answers for churn and base expansion with the same weight as sales, finance sees each hire tied to the revenue it should generate and HR receives the hiring calendar in the same document as the target.

The spreadsheet can sit with RevOps, and defending the number sits with whoever leads. If the sales director cannot explain what happens to the lead target when conversion drops from 15% to 12%, the math goes back to being negotiated as a percentage. In an in-company training on this subject, the core exercise is building the math with the company’s real data, with marketing, sales, CS and finance in the same room, and simulating each lever across the scenarios until every leader can redo the calculation in front of the board.

A roadmap for leadership to build the sales plan

For a fiscal year starting in January, the roadmap fits between September and November.

1. Close the base with finance and CS. Revenue at the start of the year, GRR and expansion for the last four quarters, by segment.
2. Pull the funnel assumptions from the CRM. Deal size by segment, conversion by cohort, median cycle and source mix, over the same period.
3. Measure real capacity and ramp. Ramped rep productivity, the curve of recent hiring classes and, with HR, the history of departures and time to hire.
4. Run the bottom-up math and the three scenarios in the three-tab spreadsheet, with owner and source for each assumption.
5. Reconcile with the executive target. Present the gap as levers with owner, cost, deadline and evidence.
6. Approve the hiring calendar together with the target and confirm the onboarding track with L&D.
7. Spread the target along the capacity curve. Publish quotas by quarter and the pipeline targets for marketing, pre-sales and retention.
8. Schedule the quarterly reviews and write down the triggers.

Sales planning and L&D: what HR needs to assess

How to recognize the need

HR receives an urgent hiring request in the middle of the year, and the position only delivers capacity the following year. Sales leadership cannot explain where each rep’s quota came from, and the team treats the target as an imposed number. Another sign is the newly promoted manager who becomes responsible for planning without ever having calculated capacity and ramp.

Who takes part

The core group is sales leadership and management, with the marketing and customer success leaders, finance and the RevOps or CRM person. HR takes part in the capacity work, because it owns the assumptions for attrition, time to hire and ramp, and the CEO joins the reconciliation, when the top-down target meets the bottom-up math.

How to measure

Before the program, record whether the current plan has assumptions with owners and sources, the gap between target and actuals over the last two years and how many sales positions opened after the month the plan needed them. After the first cycle, compare planned and actual capacity in each quarter and check whether the reviews happened with owners presenting their assumptions.

If your company’s target arrives ready-made from the budget and leadership finds out in the second quarter that the team and the funnel cannot carry the number, that is the work of the in-company Revenue Operations training. I run the program with the sales, marketing, CS, finance and HR leaders on your operation’s data, and the group builds next year’s math. It leaves with the RevOps metrics matrix, which feeds the plan’s assumptions, and with the SLA between marketing, sales and CS, which sets the handoff conversions and deadlines the target depends on.

Frequently asked questions

What is sales planning?

Sales planning is the process in which the company sets the sales target for the period and what it requires in customers, opportunities, pipeline, reps and hires. Reliable planning crosses the target the executive team wants with the capacity calculated from the customer base, the funnel and the team.

How do you set a realistic sales target?

Start with the revenue the base renews and expands, calculate the new revenue still missing and convert that amount into customers and opportunities using the deal size and conversion measured in the CRM. Compare the result with the team’s capacity, after discounting new hire ramp and expected departures, and present the gap as levers with owners.

How do you calculate sales team capacity?

Measure the average new revenue a ramped rep closes per year over the last four quarters and multiply it by the number of ramped reps in each period. Add the contribution of new reps according to the company’s ramp curve and remove the capacity of those expected to leave, from the likely month of departure.

How many reps do you need to hire to hit the target?

Divide the gap between required new revenue and current team capacity by each hire’s contribution to the year, which depends on the start month and the ramp. A rep who starts in January contributes far more to the year than one who starts in July, so the decision about how many to hire comes with the decision about when.

How often should you review the sales plan?

Every quarter, with assumption owners presenting actuals and RevOps rerunning the math. The team’s quota stays, while the hiring plan, the marketing budget and the pipeline target adjust according to triggers agreed before the year starts.

How do you train managers to build the sales plan?

Bring together the sales, marketing, CS, finance and HR leaders to build the math with the company’s real data and simulate the scenarios. Each manager needs to explain their own team’s assumptions and how they affect the others. The measurement compares planned and actual capacity in the following cycle.