Intermediate

Headcount planning model: hires, attrition, and cost impact

Builds a headcount planning model including start dates, attrition, and fully loaded cost impacts. Useful for annual planning and reforecasting.

Build a headcount plan for {company_name} for {planning_horizon}.

Inputs:
- Current roster: {current_roster}
- Planned hires (role, dept, start date): {planned_hires}
- Attrition assumptions: {attrition_assumptions}
- Compensation and benefits assumptions: {comp_benefits_assumptions}
- Hiring constraints and priorities: {constraints_priorities}

Output:
1) Headcount by month and department (opening + hires - attrition).
2) Fully loaded cost impact by month (salary, bonus, payroll tax, benefits).
3) Variance vs approved plan (if provided).
4) Notes: risks (hiring delays) and levers (timing shifts).

Provide as tables and clear formulas.

Related Prompts

Management Accounting & FP&A
Intermediate

Driver-based budget model template (revenue, headcount, opex)

Creates a driver-based budgeting framework and templates that link revenue drivers, headcount, and operating expenses. Useful for FP&A teams building a scalable budget process.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
2
Management Accounting & FP&A
Intermediate

Rolling forecast update: variance bridge to new forecast

Updates a rolling forecast by bridging from prior forecast to actuals and new assumptions. Produces a clear bridge and narrative for leadership.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
2
Management Accounting & FP&A
Beginner

Budget kickoff pack: timeline, owners, templates, instructions

Generates a budget kickoff pack with roles, deadlines, template instructions, and FAQs. Useful for FP&A leaders coordinating cross-functional budgeting.

GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
2