Headcount & Hiring Plan Simulator
Model headcount growth with attrition and recruiter capacity planning. Enter values for instant results with step-by-step formulas.
Formula
Total Hires = Net Growth + (Current Headcount ร Attrition% ร Period Years)
Account for both net growth and replacement hires from attrition. Hires per month = Total Hires / Months. Recruiter needs = Hires per Month / Recruiter Capacity.
Worked Examples
Example 1: Startup Scaling
Problem:Current: 20 employees. Target: 50 in 12 months. 15% attrition, 60 days TTH, $90K avg, 1 recruiter (5/mo capacity).
Solution:Net growth: 50 - 20 = 30\nAttrition: 20 ร 15% = 3/year\nTotal hires: 30 + 3 = 33\n\nPer month: 33 / 12 = 2.75 hires\nPer quarter: 8.25\n\nRecruiter check:\n2.75 hires/mo < 5 capacity โ\n1 recruiter sufficient\n\nPipeline:\n60-day TTH = start 2 months early\nNeed 2.75 ร 4 funnel ร 2mo = 22 candidates in process\n\nCosts:\nRecruiting: 33 ร $5,000 = $165K\nComp (avg 6mo): 33 ร $121.5K ร 0.5 = $2M\nTotal: $2.16M
Result:2.75 hires/mo | 1 recruiter OK | $2.16M total cost
Example 2: Aggressive Expansion
Problem:Current: 100. Target: 200 in 18 months. 12% attrition, 45 days TTH, $110K avg, 2 recruiters.
Solution:Net growth: 100\nAttrition: 100 ร 12% ร 1.5yrs = 18\nTotal hires: 100 + 18 = 118\n\nPer month: 118 / 18 = 6.6 hires\nPer quarter: 19.7\n\nRecruiter check:\n2 recruiters ร 5 capacity = 10/mo capacity\n6.6 < 10 โ (but tight)\n\nPipeline:\n6.6 hires ร 4 funnel = 26 interviews/mo\nร 2 mo lead time = 52 candidates active\n\nCosts:\nRecruiting: 118 ร $5,000 = $590K\nComp (avg 9mo): 118 ร $148.5K ร 0.75 = $13.1M\nTotal: $13.7M\n\nFeasibility: Aggressive but achievable
Result:6.6 hires/mo | Need 2 recruiters minimum | $13.7M cost
Example 3: Replacement Hiring Only
Problem:Current: 200. Maintain 200. 18% attrition, 50 days TTH, $95K avg.
Solution:No growth, just backfills.\n\nAnnual attrition: 200 ร 18% = 36 employees/year\nMonthly: 3 hires/month\n\nRecruiters: 3 / 5 = 0.6 FTE\n1 recruiter with bandwidth\n\nThis is maintenance hiring.\nHigh attrition (18%) is expensive:\n\nCosts:\nRecruiting: 36 ร $5,000 = $180K/year\nCompensation: Always paying full 200\nKnowledge loss, productivity dips\n\nRecommendation: Reduce attrition to 12%\nSaves 12 hires/year = $60K recruiting\n+ intangible productivity gains
Result:3 hires/mo (backfill only) | 18% attrition is expensive | Focus on retention
Frequently Asked Questions
How do I plan headcount growth?
Steps: 1) Set target headcount and timeline. 2) Account for attrition (turnover during hiring period). 3) Calculate hires per month. 4) Assess recruiter capacity. 5) Model costs. 6) Build pipeline ahead of need.