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
BeginnerKPI tree: link strategy to drivers and metrics
Creates a KPI tree that connects strategic objectives to operational drivers and metrics with definitions. Useful for leadership alignment and dashboard design.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
40
Management Accounting & FP&A
BeginnerMonthly variance analysis: budget vs actual with bridges
Automates variance analysis with price/volume/mix and spending bridges where applicable. Produces exec-ready narratives and follow-up questions.
GPT-5.2 Thinking; GPT-4.1; o3-mini
0
0
47
Management Accounting & FP&A
IntermediateCost 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
0
0
66