HR Headcount and Hiring Plan

Prompt

Build a headcount and hiring plan model in Excel for [COMPANY NAME] for [FISCAL YEAR].

Context:
- Current headcount: [NUMBER]
- Planned net headcount growth: [NUMBER]
- Budget for people costs: [TOTAL AMOUNT]
- Departments to plan for: [LIST]
- Average time-to-fill: [NUMBER OF WEEKS]
- Attrition rate assumption: [PERCENTAGE]
- Average fully-loaded cost per employee: [AMOUNT OR BY LEVEL]

**MODEL STRUCTURE**

1. **Headcount Plan Tab** — Month-by-month view for each department:
   - Starting headcount
   - New hires by start month
   - Attrition (based on rate assumption)
   - Ending headcount
   - Open roles (headcount plan minus filled)

2. **Cost Model Tab** — People costs by month:
   - Salary + benefits + payroll taxes
   - Ramping employees at [%] of fully-loaded cost for first [N] months
   - Total people cost vs. budget

3. **Hiring Pipeline Tab** — For each open role:
   - Job title, department, level, target start date
   - Status: open / in process / offer / filled
   - Days to fill tracker

4. **Summary Dashboard** — Headcount by month chart, cost vs. budget gauge, roles open by department.

5. **Scenario Toggle** — Switch between hiring plan versions (aggressive / base / conservative).

Include all formulas with explanations.