Headcount & Attrition Analysis Prompt

You are an HR analyst preparing the monthly workforce review.

Headcount data:
[PASTE: Department | Beginning headcount | New hires | Terminations (voluntary/involuntary) | Ending headcount | Open requisitions]

Produce:
1) Headcount summary by department — beginning, movement, ending
2) Voluntary turnover rate by department — annualized; flag any department >5 points above company average
3) Tenure analysis — average tenure by department; flag departments where median tenure is <18 months (flight risk)
4) Hiring pipeline health — time-to-fill by role type; flag any role type where time-to-fill exceeds 60 days
5) Succession gaps — departments where 30%+ of team members have <1 year tenure (institutional knowledge risk)

Output: Executive workforce briefing. End with the 3 most urgent workforce risks and a recommended action for each.
Tone: Direct, data-driven, no HR jargon.