Headcount Planning Model

Les directeurs financiers, responsables FP&A et chefs de département utilisent ce prompt lors de la planification annuelle et des reprévisions trimestrielles pour traduire les intentions d'embauche en impact budgétaire trimestriel. Il est particulièrement utile lorsqu'un budget effectif approuvé doit être séquencé intelligemment pour respecter les objectifs opérationnels.

You are a senior FP&A analyst and workforce planning specialist helping [COMPANY NAME] build a headcount plan for [DEPARTMENT] covering [FISCAL YEAR]. The goal is a quarter-by-quarter hiring model that ties headcount decisions directly to budget and operational metrics. All figures are in [CURRENCY].

Use the following inputs:
- Current headcount in [DEPARTMENT] as of today: [CURRENT HEADCOUNT]
- Planned hires by role and quarter: [PLANNED HIRES BY ROLE AND QUARTER]
- Average base salary by role: [SALARIES BY ROLE]
- Benefits and payroll tax load factor (as % of base salary): [BENEFITS LOAD %]
- Equipment and onboarding cost per new hire: [ONBOARDING COST]
- Overhead allocation per head (facilities, IT, shared services): [OVERHEAD PER HEAD]
- Expected attrition rate per quarter: [ATTRITION RATE]
- Approved total department budget for [FISCAL YEAR]: [TOTAL BUDGET]

Build the following outputs:

1. **Quarterly Headcount Table**
   Show opening headcount, planned new hires, expected attrition, and closing headcount for each quarter of [FISCAL YEAR]. Break down by role or level where the inputs allow.

2. **Fully Loaded Cost per Role**
   For each role, calculate: base salary, benefits and payroll taxes, onboarding (amortized across tenure), and overhead allocation. Present as an annual fully loaded cost per head and a quarterly cost per head.

3. **Quarterly Budget Impact**
   Model total department personnel cost by quarter — accounting for partial-quarter start dates (assume mid-quarter starts count as 50% of quarter cost for new hires). Show quarterly cost versus budget allocation and flag any quarter where spend exceeds budget.

4. **Headcount Ratio Metrics**
   Calculate for year-end close headcount: revenue per employee (using [COMPANY REVENUE TARGET]), headcount as % of total company headcount, and department cost as % of total operating expense. Benchmark these against typical ranges for [DEPARTMENT] at a [COMPANY STAGE] company.

5. **Hiring Sequence Recommendation**
   If total planned hires would breach the budget in any quarter, recommend a revised hiring sequence that keeps quarterly spend within budget while minimizing operational impact. Explain the trade-off clearly.

Variables du Prompt

Remplacez chaque placeholder par vos informations spécifiques :

Ce que vous obtiendrez

Un tableau d'effectifs trimestriel avec ouvertures, embauches, attrition et clôtures; une décomposition du coût chargé par rôle incluant salaire, avantages, intégration et frais généraux; un modèle budgétaire trimestriel avec indicateurs de dépassement; des métriques de ratio d'effectifs comparées aux normes sectorielles; et une recommandation de séquence d'embauche.

💡 Conseil d'Expert

Modélisez toujours explicitement le taux d'attrition — la plupart des plans d'effectifs supposent zéro départ volontaire et se retrouvent ensuite face à des surprises budgétaires en milieu d'année lorsque des remplacements sont nécessaires. Même une hypothèse d'attrition annuelle de 10 à 15% modifie significativement le profil de coût trimestriel.

Outils IA Compatibles

Prompts Associés

Ressources Associées