Sales Capacity & Team Sizing Planner

Model your revenue capacity by rep, account for ramp time and attrition, and identify exactly when and where you need to hire.

1. Company Inputs

Annual Bookings Target

Target ($)

$2.04M

$3.00M

$3.96M

Quarterly Distribution

Sum: 100%

Monthly Seasonality

Sum: 100%

Within each quarter (hockey stick)

Monthly Sales Attrition

Rate

Productive capacity degradation per month

2. Role Configuration

Current ramped AEs

Enterprise / Mid-Market split (existing)

50%

50% Enterprise, 50% Mid-Market

Enterprise monthly quota (fully ramped)

Mid-Market monthly quota (fully ramped)

Attainment (80%)

80%

Enterprise ramp (7 mo)

Mid-Market ramp (7 mo)

Planned Hires

New Hire 1

3. Capacity vs. Target Timeline

Annual capacity

$4.88M

Annual target

$12.00M

Coverage ratio

0.41x

Deficit

$7.12M

4. Headcount Timeline

Solid = fully ramped · Lighter = still ramping

5. Insights & Hiring Recommendations

Coverage ratio

0.41x

Critical shortfall — capacity below target

First capacity gap

Feb

$218,320 shortfall — add capacity before this month to stay on plan.

New hire impact

$1.07M

1 planned hires; only $80K lands in the first 6 months due to ramp.

Hiring recommendation

Hire 6 months ago

Critical: to close the gap in Feb, you needed to start ramp 6 months ago.

SDR meeting capacity

Stage 0 meetings/month average at current headcount and attainment.

SC deal support capacity

Stage 1 deals/month average. Compare to Stage 1 demand to validate SC sizing.

Built by Craig W. Irwin · craigwirwin.com