Find AI Prompts
Home›Human Resources›Workforce Planning
Human ResourcesWorkforce & Talent Planning

AI Prompts for Workforce Planning

Workforce planning answers: what capabilities and how many people will the business need, what will we have if nothing changes, and how do we close the gap? Demand comes from business drivers — volume, revenue, projects, productivity assumptions — not from managers' wish lists. Supply comes from today's headcount projected through attrition, retirements, mobility and current hiring. The gap is closed with a mix of build (develop), buy (hire), borrow (contract, partner) and automate, each with cost and lead time.

These prompts model demand, project supply, and evaluate the options. They work at role-family level over one to three years; the model shows the arithmetic and the assumptions, and it does not know your business's drivers — you supply them.

Before you use these

Have these ready to replace the highlighted [variables]:

These prompts analyze workforce data in aggregate to improve policy, management and support. They must not be used to score, rank or flag individual employees, to predict which named person will leave, or to inform decisions about individuals; analysis is reported at group level above the anonymity threshold, and any group-level finding is a prompt for a conversation, not a conclusion about people. Check local law and policy on workforce data use.

The prompts

1. Forecast workforce demand from business drivers

Best forDemand by role family and period, derived from what the business plans to do.
Inputs needed
  • Business drivers
  • Ratios linking drivers to headcount
  • Productivity assumptions
How to use itGive the drivers and the ratios you use (or historical ones to derive them). The model builds demand by role family and period, shows the arithmetic, and states which assumptions carry the result.
Expected outputDemand table by role family and period with the driver and ratio behind each line, scenarios (low/base/high), and the sensitivity.
Act as a workforce planning analyst forecasting demand for [company / division] over [horizon].

Business drivers: [volume, revenue, customers, projects, new locations, product launches — by period]
Ratios and assumptions: [e.g. customers per support agent, revenue per sales rep, engineers per product, span of control; productivity change from tooling or automation; historical ratios if current ones are unknown]
Role families: [list]

1. Demand model: for each role family, the driver, the ratio, and the resulting headcount by period; show the arithmetic for one family end to end.
2. Productivity effects: where automation or process change reduces the ratio, the timing and the confidence.
3. Scenarios: low/base/high demand from the business plan's own ranges, and the headcount range per family.
4. Capability shifts inside the numbers: where the same headcount needs different skills (e.g. fewer generalists, more specialists), stated by family.
5. Sensitivity: the assumption that most affects total demand and the effect of a ±20% change.
6. Assumptions register: every ratio and its source (measured, benchmark, judgment).

Do not accept manager headcount requests as demand. Demand comes from drivers; requests are checked against it.

2. Project internal supply with attrition and mobility

Best forWhat the workforce will look like if nothing changes: by family, level and period.
Inputs needed
  • Current headcount by family/level/location
  • Attrition and retirement patterns
  • Internal mobility and promotion rates
  • Hiring in progress
How to use itGive the current state and the rates. The model projects supply forward by period, including retirements, promotions and moves between families, and flags where the projection is weakest.
Expected outputSupply projection by family, level and period with the flows (attrition, retirement, promotion, transfer, hires in progress), the assumptions, and the confidence.
You are projecting internal workforce supply for [company / division] over [horizon].

Current state: [headcount by role family, level, location; age-band data for retirement projection at group level; tenure bands]
Rates: [voluntary attrition by family and level; retirement patterns; promotion rates; transfers between families; hiring in progress with expected start dates]
Anonymity threshold: [n]

1. Projection by period: opening headcount − attrition − retirements + promotions in − promotions out + transfers ± hires in progress = closing, per family and level; show the arithmetic for one family.
2. Flows that matter: families where retirements or attrition remove critical capability within the horizon; levels that hollow out as promotions outpace inflow.
3. Mobility as supply: internal moves that could fill demand elsewhere, and the capability gap that would need closing.
4. Confidence: rates with thin history, and the range that implies.
5. Group-level reporting only: retirement and attrition projections by family and level, never by named individual.
6. Assumptions register.

Project honestly. A supply projection that assumes attrition stops is a wish.

3. Close the gap with build, buy, borrow and automate

Best forA costed, sequenced plan to close the demand–supply gap by role family.
Inputs needed
  • Demand and supply projections
  • Options with cost and lead time
  • Constraints
How to use itGive both projections and the options. The model sizes the gap per family and period, evaluates each option, recommends a mix with timing, and shows the total cost and the risks.
Expected outputGap by family and period, option evaluation (build, buy, borrow, automate, restructure) with cost, lead time and risk, recommended mix and timing, budget roll-up, and decisions required.
Act as a workforce planning lead building the gap-closing plan for [company / division] over [horizon].

Demand: [by family and period, base scenario] Supply: [projection by family and period]
Options and their economics: [hire: cost per hire, time to fill, ramp; develop/reskill: cost, duration, success rate; contract/partner: rate, availability, limits; automate: investment, timing, headcount effect; restructure: redeploy from surplus families]
Constraints: [budget, hiring capacity, change capacity, location rules]

1. Gap table: demand − supply by family and period; surpluses and shortages; capability gaps inside balanced headcount.
2. For each shortage: the options that can close it in time (lead time versus when the gap binds), the cost of each, the risk (quality, retention of contractors, reskilling success), and reversibility.
3. For each surplus: redeployment paths (with reskilling needed), natural attrition, and the point at which structural decisions are required — flagged for the consultation and legal process that applies, not decided here.
4. Recommended mix and timing per family; the decisions that must be made now because of lead time.
5. Budget roll-up by period; the effect on total workforce cost; the sensitivity to the demand scenario.
6. Monitoring: the triggers (demand signal changes, attrition changes) that reopen the plan, and the review cadence.

Present as tables with a one-page narrative. Every option carries a cost, a lead time and a risk; a plan that is all 'hire' is not a plan.

Demand, supply and gap in numbers

Illustrative arithmetic for one role family over two years.

DEMAND (customer support agents) Customers: 40,000 → 52,000 (yr1) → 62,000 (yr2) Ratio: 800 customers per agent today; tooling change → 900 from yr2 Required: 50 → 65 (yr1) → 69 (yr2) SUPPLY (if nothing changes) Opening 50; voluntary attrition 18%/yr; retirements 1/yr; promotions out 2/yr Yr1 close: 50 − 9 − 1 − 2 + 0 hires = 38 Yr2 close: 38 − 7 − 1 − 2 = 28 GAP: yr1 65 − 38 = 27 yr2 69 − 28 = 41 (cumulative hiring need ≈ 41 over 2 yrs, plus 2 internal moves to backfill promotions) OPTIONS (yr1 gap of 27, must be ready by month 6): Hire: 27 × (6-wk fill + 8-wk ramp) → recruiting must start now; cost 27 × [cost/hire] Reskill: 8 from a surplus back-office family (12-wk program, 80% success) → 6 net Contract: 10 seasonal for the peak quarter only Automate: the tooling change is already in the ratio — no double count Sensitivity: attrition at 12% instead of 18% reduces the yr2 gap by 7. The retention action is worth ~7 hires.
The plan is not 'hire 41'. It is a mix, sequenced by lead time, with retention as one of the levers.

Related prompts

Logical next step

After this, most HR teams move on to Succession Planning.

Get the free HR & Recruiting AI Starter Kit → Nine of these prompts as an intake → assess → offer hiring workflow with an intake worksheet, delivered by email. See what's inside

All Human Resources prompts · Search the full library