Headcount Planning Worksheet

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:
{{role_title_start_date_base_salary_locati}}

For each new hire, calculate:
- Fully loaded cost (salary + benefits at {{x}}% + payroll taxes at {{x_2}}%)
- 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.

Copied to clipboard.

Why this works

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

Risks & review

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