Automation one
Workforce planning that updates itself
What runs on its own: the headcount and cost plan refreshes from your HRIS and finance actuals every month, with spans, ratios, and revenue per employee against benchmark.
What you get: a living headcount model, three scenarios, and a one-page board view that is never more than 30 days old.
30 to 45 days
- The problem it solves
- The headcount plan lives in a spreadsheet that is rebuilt before every board meeting, disagrees with finance, and cannot answer "what if we slow hiring in Q3" without a weekend.
- What we automate
- Monthly pull of the anonymized roster and hires, terms, and cost from the HRIS and the finance system; recalculation of headcount by function, spans and layers, attrition, cost per employee, and revenue per employee; benchmark comparison; scenario tables for base, lean, and growth; an AI-written variance narrative for the CEO that explains what moved and what it means; distribution of the one-page board view on a schedule.
- Deliverables
- The workforce model in your spreadsheet or BI tool with live connections; the scheduled refresh; the narrative prompt and its guardrails documented; the one-page board view template; a runbook; a trained owner in finance or HR.
- Tools we use
- Claude for the variance narrative and scenario commentary; Sheets or Excel for the model, fed by a scheduled HRIS export (Rippling, BambooHR, Gusto, ADP, UKG, Workday) and the monthly close file; Zapier or Make for the refresh and distribution to Slack, Teams, or email; Smartsheet for the board view where you already use it.
- Decision it serves
- Whether the hiring plan holds up against the revenue and EBITDA plan, and what to change this quarter.
- Measures
- Hours per month to produce the plan, before and after; days between period close and board view; number of unreconciled headcount differences with finance.