wowprompt

Annual headcount plan from business goals and attrition

Turns next year's business goals, current team sizes and expected attrition into a quarter-by-quarter hiring plan with roles, priority, cost and recruiting load. Use it during annual budgeting or when leaders ask how many people each team really needs.

A table of teams with current headcount, attrition, new roles and quarter-wise hires, a cost summary, and the recruiting capacity check with risks
The output this prompt produced, unedited.

The prompt

Fill in these first

  • Business goals for next year: [e.g. double customers in two new cities, launch a mobile app]
  • Current headcount by team and level: [paste table]
  • Last year's attrition by team: [percent or number of exits]
  • Workload measures per team, if any: [e.g. tickets per support agent, accounts per sales rep]
  • Average cost per hire and annual cost per role: [figures by level]
  • Recruiters and their monthly capacity: [e.g. two recruiters, about six hires each per month]
  • Budget limit: [amount, or none set]

Task

Estimate the people needed to meet the goals, add replacements for expected exits, and schedule the hiring so it is possible with the recruiting team available.

Steps

  1. For each goal, the teams it affects and the workload it adds.
  2. New roles per team from the workload measures; show the calculation.
  3. Replacement hires: current headcount times attrition rate.
  4. Timing: hire ahead of the work by the usual time to fill and ramp-up.
  5. Cost: hiring cost plus prorated annual cost for the months each hire is in the year.
  6. Capacity: total hires per month against recruiter capacity.

Output format

  1. | Team | Current | Expected exits | New roles | Total hires | Q1 | Q2 | Q3 | Q4 |
  2. | Role | Level | Reason | Priority | Start quarter | Annual cost |
  3. Cost summary against the budget.
  4. Recruiting capacity check by month and the gap, if any.
  5. Three risks and a cheaper option for each, such as contractors, internal moves or automation.

Rules

  • Show every calculation; never present a number without where it came from.
  • Use only the figures given; write [assumption] beside any estimate and state it.
  • Flag any team where the plan more than doubles headcount in a year.
headcount planningworkforce planninghiring planattrition forecasthr budgetingrecruitment plan

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity