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

Cost allocation model: shared services and drivers

Designs a cost allocation approach for shared services using clear drivers and documentation. Useful for management reporting and chargeback models.

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

128

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

Management Accounting & FP&A

Beginner

Expense variance triage: controllable vs noncontrollable

Separates expense variances into controllable and noncontrollable buckets and drafts targeted follow-ups. Useful for expense owners and cost governance.

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

101