Sales Capacity Planner

Ramped Rep Equivalents × productivity × attainment × (1 − attrition) — supply-side capacity, not pipeline conversion.

Illustrative B2B / AU services sales team until you enter actuals. Not financial advice. Distinct from Lead-to-Revenue (demand / stage conversion).

Headcount, productivity, and target

AU services sample (labelled). Persist locally only. Results update live below · Jump to capacity

Productivity basis

Prefer steady-state bookings per fully ramped rep. Quota is the same math with different labelling.

Measure as

Capacity vs target

RRE, expected bookings capacity, gap, and hires to close — supply side only.

Stretch (placeholder only): monthly ramp curve · SMB vs enterprise split · mid-period turnover timing — not in this build.

How this is calculated
  • RRE = fully ramped reps + (ramping reps × ramp factor %)
  • Expected capacity = RRE × productivity (or quota) × attainment % × (1 − attrition %)
  • Gap = capacity − target (positive = surplus)
  • Hires to close = if gap < 0, ceiling of |gap| ÷ (productivity × attainment × (1 − attrition)) — full-productivity hire equivalent with attrition buffer
  • Uncalibrated coverage check (optional) = target ÷ single win rate — not a stage forecast. Use Lead-to-Revenue for calibrated coverage.

Further reading (footnote only, not scraped): Lative · Ziel Lab · Prospeo · Wall Street Prep. Illustrative — not advice.

Sensitivity dials

+1 ramped rep · +5 pts attainment · faster ramp — live capacity and gap.

What-if dials

Each dial stacks on your base inputs. Biggest lever call updates with the insight above.

Adds one RRE each at full productivity × attainment × (1 − attrition).

Adds percentage points to historical attainment (capped at 150%).

Lifts the ramp factor on ramping reps (capped at 100%).

Take it with you

Download a prompt, export the Excel workbook, or email yourself — then pair with Lead-to-Revenue for the pipeline side.

Downloads stay on your device. Inputs are saved in this browser (localStorage).