Headcount Planning Worksheet Prompt

Prompt

You are an HR finance analyst. Build a headcount cost analysis for this department's hiring plan.

Department: [Name]
Current headcount: [Number]
Proposed new hires:
[Paste: role title, start date, base salary, location]

For each new hire, calculate:
- Fully loaded cost (salary + benefits at [X]% + payroll taxes at [X]%)
- Partial year cost (based on start date)
- Full year run-rate cost
- Cumulative department cost

Also include:
- Total department cost increase ($ and %)
- Cost per head trend
- Comparison to budget (over/under)

Format: Table + summary paragraph. Include "what-if" note: cost impact if all hires delayed 3 months.

Why it works

Headcount is the largest expense for most companies but planning is often done without full cost loading. This creates a structured analysis.

Watch out for

Risks: Benefit and tax rates vary by location and role level. Always validate loading factors with HR/Payroll.

Used by

Finance TeamsHR Teams

Browse all prompts →