Three-Scenario Headcount Forecast with Sensitivities

Three-Scenario Headcount Forecast with Sensitivities

📄 Prompt Template

Build base, upside, and downside headcount scenarios for [Company] covering [Timeframe] across [Regions]. Vary [RevenueTrajectory] (e.g., ±[PctVariance]%), [AttritionRateRange], and [AutomationImpact] to quantify demand and hiring needs by role. Output: (1) Scenario comparison table (columns: Scenario, TotalFTE, HiringNeed, Cost_[Currency], KeyAssumptions). (2) Role-level matrix showing FTE by Month × Role for each scenario. (3) Waterfall (text table) from BaseDemand to NetHires by lever: productivity, attrition, automation, redeployment. (4) Sensitivity grid showing HiringNeed change per +/−5% shift in [RevenueTrajectory] and [AttritionRateRange]. (5) Recommendation: select preferred scenario with trigger conditions to pivot (leading indicators and thresholds). Include explicit assumptions, decision checkpoints, and owner RACI (TA, HRBP, Finance, Operations).

⚙️ Customize Your Prompt

Scroll to Top