Build a headcount plan with fully loaded employee costs
A role-by-role hiring plan that converts start dates and salaries into monthly fully loaded cost.
The prompt
Help me build a headcount plan and cost it on a fully loaded basis.
Current headcount: [PASTE: role, department, location, salary - or summary by department]
Planned hires: [ROLE, DEPARTMENT, LOCATION, TARGET SALARY, PLANNED START MONTH]
Expected attrition: [% per year or specific known leavers]
Cost loading assumptions: [payroll taxes %, benefits per head, bonus target %, equity, recruiting fees, equipment/software per hire]
Salary increase timing: [e.g. "3% merit every April"]
Plan period: [e.g. "FY2027, monthly"]
Typical hiring delay: [WEEKS from planned start to actual start - or "none"]
Rules:
- Cost new hires from their start month only, and apply the hiring delay above.
- Separate one-time costs (recruiting, equipment) from recurring costs.
- Show backfills for expected attrition separately from net new roles.
Return:
1. A monthly table by department: opening headcount, hires, leavers, closing headcount, and fully loaded cost.
2. A per-role cost summary showing how base salary becomes fully loaded cost.
3. Annual totals vs. [BUDGET, if given], with the gap.
4. The 3 levers that would most change cost (hiring timing, location mix, loading rates), with the impact of each.
5. A checklist of assumptions to confirm with HR and payroll.
Use only my figures; mark gaps as [CONFIRM WITH HR].
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Finance & Accounting prompts
What to fill in
- e.g. "3% merit every April"
- e.g. "FY2027, monthly"
- WEEKS from planned start to actual start - or "none"
- BUDGET, if given
- CONFIRM WITH HR
How this prompt is built
This prompt follows the Few-Shot structure (Few-shot prompting). A few-shot prompt includes one or more worked examples of the input and the output you want, so the model can copy the pattern instead of guessing it.
Related prompts
- Prepare a progress billing pay application with retainageA schedule of values and monthly pay application that matches work in place, handles retainage and stored materials, and avoids rejection.
- Write a credit memo for a commercial loan requestA structured credit memo covering the borrower, repayment capacity, collateral, risks, and a clear recommendation for the credit committee.
- Cost and price a multi-day tour packageA tour costing sheet with fixed and per-person costs, break-even group size, markup, and a sellable inclusions list.
- Check whether a design project will finish within its feeA fee-burn check comparing fee spent with percent complete by phase, with an estimate at completion and recovery options.