SaaS RevOps & FP&A Capacity Planning
Sales Rep Ramp Quota Capacity & Attrition Formula
Calculate Ramped Rep Equivalents (RRE), Street Quota Capacity, and Attrition-Adjusted Expected Bookings against Board ARR targets using SUMPRODUCT.
Eliminate the headcount-times-quota FP&A illusion in SaaS revenue planning!
Multiplying ending sales headcount (20 Account Executives) by annual street quota ($1,000,000) creates a $20,000,000 paper illusion whenever hires arrive mid-year and require a 2-to-3 quarter onboarding ramp! Accurate RevOps and FP&A capacity models weight each hiring cohort by its Full-Year Average Ramp Productivity Factor r_i in [0, 1] to compute Ramped Rep Equivalents RRE = SUMPRODUCT(Headcount, Ramp_Factor) and Ramped Street Quota Capacity Q_ramped = SUMPRODUCT(Headcount * Ramp_Factor, Annual_Quota), then apply Historical Quota Attainment a (e.g., 85%) and Unreplaced Attrition Haircut h (e.g., 10%) to compare Risk-Adjusted Bookings Capacity = Q_ramped * a * (1 - h) against the Board New-ARR Target!
Verify across four AE cohorts in A2:E5 (8 Tenured AEs at 1.00 ramp, 4 Q1 Hires at 0.75 full-year average ramp, 4 Q2 Hires at 0.50 ramp, and 4 Q3 Hires at 0.25 ramp, each carrying $1,000,000 annualized street quota): Total Paper Headcount is 20 reps ($20M unadjusted), but Ramped Rep Equivalents equal 8*1.00 + 4*0.75 + 4*0.50 + 4*0.25 = 14.00 RRE (G2), Ramped Street Quota Capacity is $14,000,000 (G3, +40.0% street over-assignment vs $10,000,000 Board Target in B9), and at 85% Historical Attainment (B7) with 10% Attrition Haircut (B8), Risk-Adjusted Expected Bookings equal $14,000,000 * 0.85 * 0.90 = $10,710,000 (+$710,000 net buffer -> "Target Covered (+Buffer)")! If regrettable attrition doubles to 20% (B8 = 0.20), Risk-Adjusted Bookings drop to $9,520,000 ("Capacity Deficit: Hire Earlier")!
| AE Hiring Cohort | Headcount | Full-Year Ramp Factor | Ramped Street Capacity |
|---|---|---|---|
| Tenured_AE | 8 | 1.00 | $8,000,000 |
| Q1_Hire_Cohort | 4 | 0.75 | $3,000,000 |
| Q2_Hire_Cohort | 4 | 0.50 | $2,000,000 |
| Q3_Hire_Cohort | 4 | 0.25 | $1,000,000 |
Ramped Rep Equivalents (RRE) & Attrition-Adjusted Bookings Formula
Before accepting a contributor’s suggested hiring-plan delay in a shared Arte Sheets GTM capacity workbook, test shifting Q1 hires into Q3 or raising B8 attrition to 0.20 to inspect immediate ARR coverage impact!
=IF(OR(B7 <= 0, B7 > 2, B8 < 0, B8 >= 1, B9 <= 0), "Invalid GTM Capacity Input", ROUND(SUM(E2:E5) * B7 * (1 - B8), 2))Board ARR Target Coverage Verdict Formula
Compare Risk-Adjusted Bookings (G4) directly against Board New-ARR Target (B9).
=IF(ISTEXT(G4), G4, IF(G4 >= B9, "Target Covered (+Buffer)", "Capacity Deficit: Hire Earlier"))Try the example
Use the original values or change them to test your understanding.