Hitting a revenue target takes enough sales reps, and new reps take time to produce. This sales rep capacity calculator takes your revenue target, quota, average attainment, ramp time, current reps and cost per rep to show the realistic output per rep, the reps needed, the hires needed this year once ramp time is counted, and the cost of the sales team as a share of the target.
How the calculation works
- Realistic output per rep = quota × average attainment.
- Reps needed once ramped = revenue target ÷ realistic output, rounded up.
- Ramp factor = 1 − ramp months ÷ 24, because a new rep ramps up in a straight line and produces half of full output during the ramp.
- Hires needed this year = (target − existing reps’ output) ÷ (output per rep × ramp factor), rounded up.
- Team cost = (existing reps + hires) × cost per rep.
Example
A company wants $3,000,000 of new revenue with 4 ramped reps. The quota is $600,000 but reps reach 75 % on average, so each delivers $450,000 and 7 ramped reps are needed. A new rep takes 6 months to ramp, which cuts their first-year output by 25 %, so you need 4 hires this year. The team of 8 costs $960,000 at $120,000 each, 32 % of the target.
Why it matters
Sales plans fail when the headcount is based on quota alone. Reps rarely all reach 100 percent, and a rep hired in January may not be productive until mid-year, so the plan needs more hires and earlier hiring than a simple division suggests. Putting attainment and ramp into the math shows how many people to recruit, when to start, and whether the cost of the sales team fits the revenue it is expected to bring.
Good to know
Use real attainment from past years, not the target. If only half your reps hit quota, the average is lower than the median rep and the plan should reflect that. The straight-line ramp assumes a new rep reaches full output at the end of the ramp, which is a simplification. Hiring earlier lowers the risk of missing the target, while hiring later saves cost but needs a shorter ramp. Sales cost includes salary, commission, benefits, tools, travel and management time. Add sales support and managers if the team grows. The result is a planning aid and not a forecast.
Related tools
The commission calculator works out pay for one deal, the employer cost calculator gives the full cost of an employee, and the CAC payback calculator shows how fast sales cost returns.