Headcount Planning Model

CFOs, FP&A managers, and department heads use this prompt during annual planning and mid-year reforecasting to translate hiring intentions into quarterly budget impact. It is especially valuable when the board has approved a headcount budget and the finance team needs to sequence hires to stay within it while meeting operational targets.

You are a senior FP&A analyst and workforce planning specialist helping [COMPANY NAME] build a headcount plan for [DEPARTMENT] covering [FISCAL YEAR]. The goal is a quarter-by-quarter hiring model that ties headcount decisions directly to budget and operational metrics. All figures are in [CURRENCY].

Use the following inputs:
- Current headcount in [DEPARTMENT] as of today: [CURRENT HEADCOUNT]
- Planned hires by role and quarter: [PLANNED HIRES BY ROLE AND QUARTER]
- Average base salary by role: [SALARIES BY ROLE]
- Benefits and payroll tax load factor (as % of base salary): [BENEFITS LOAD %]
- Equipment and onboarding cost per new hire: [ONBOARDING COST]
- Overhead allocation per head (facilities, IT, shared services): [OVERHEAD PER HEAD]
- Expected attrition rate per quarter: [ATTRITION RATE]
- Approved total department budget for [FISCAL YEAR]: [TOTAL BUDGET]

Build the following outputs:

1. **Quarterly Headcount Table**
   Show opening headcount, planned new hires, expected attrition, and closing headcount for each quarter of [FISCAL YEAR]. Break down by role or level where the inputs allow.

2. **Fully Loaded Cost per Role**
   For each role, calculate: base salary, benefits and payroll taxes, onboarding (amortized across tenure), and overhead allocation. Present as an annual fully loaded cost per head and a quarterly cost per head.

3. **Quarterly Budget Impact**
   Model total department personnel cost by quarter — accounting for partial-quarter start dates (assume mid-quarter starts count as 50% of quarter cost for new hires). Show quarterly cost versus budget allocation and flag any quarter where spend exceeds budget.

4. **Headcount Ratio Metrics**
   Calculate for year-end close headcount: revenue per employee (using [COMPANY REVENUE TARGET]), headcount as % of total company headcount, and department cost as % of total operating expense. Benchmark these against typical ranges for [DEPARTMENT] at a [COMPANY STAGE] company.

5. **Hiring Sequence Recommendation**
   If total planned hires would breach the budget in any quarter, recommend a revised hiring sequence that keeps quarterly spend within budget while minimizing operational impact. Explain the trade-off clearly.

Prompt Variables

Replace each placeholder with your specific information:

What You'll Get

A quarterly headcount table with opens, hires, attrition, and closings; a fully loaded cost breakdown by role covering salary, benefits, onboarding, and overhead; a quarterly budget vs. spend model with overage flags; year-end headcount ratio metrics benchmarked against industry norms; and a hiring sequence recommendation if any quarter breaches budget.

💡 Pro Tip

Always model attrition explicitly — most headcount plans assume zero voluntary departures and then face mid-year budget surprises when backfills are needed. Even a 10–15% annual attrition assumption changes the quarterly cost profile significantly and gives the board a more honest picture.

Compatible AI Tools

Related Prompts

Related Resources