The Workforce Planning Model for Lean HR Teams

Workforce planning, forecasting the headcount, skills, and structure your organization will need over a 12 to 24 month horizon, is typically the domain of large HR teams with dedicated analytics staff. Lean HR teams often skip it entirely, defaulting to reactive hiring that creates structural problems: persistent skill gaps, unexpected attrition cascades, and headcount requests that arrive with impossible timelines.

"Workforce planning done reactively is just expensive hiring. You spend more per role, you hire faster under pressure and make worse decisions, and you fill gaps that could have been prevented with six months of forward visibility. The lean HR team that plans ahead will always outperform the large HR team that reacts."

— Dave Ulrich, Professor, Ross School of Business, University of Michigan and Author of The Why of Work (2023)

A spreadsheet-first workforce planning model does not require analytics infrastructure. It requires data that most HR teams already have and 8 to 10 hours of focused work per quarter.

Headcount forecasting

Start with your current headcount by department and role level. Add two inputs: the company revenue or growth plan for the next 12 months, and historical hiring ratios (headcount growth per unit of revenue growth, or headcount at each function as a percentage of total). These ratios are imperfect but they provide a baseline model that can be refined with departmental input.

Overlay the business plan. If the company plans to grow revenue from $8M to $12M, what does that imply for customer success headcount? For sales capacity? For engineering throughput? Walking through these implications with department heads produces a first-draft headcount forecast that HR can then validate against budget constraints and hiring timeline realities.

Skills gap analysis

The skills gap question is: what skills does the company need to execute its 12-month plan that it does not currently have in sufficient quantity? This is a different question from "what roles do we need to hire?" Sometimes the answer is retraining existing employees, sometimes it is partnering rather than hiring, sometimes it is contracting for capabilities that do not need to be permanent.

Attrition modeling

Most HR teams track attrition after it happens. Workforce planning requires predicting attrition before it happens. Your baseline model starts with historical attrition rates by department and tenure band. If your engineering team has had 18 percent annual attrition for three years, planning for 18 percent attrition in the next year is rational.

Overlay risk factors: employees who have not received a salary increase in 18 months are higher attrition risk. Teams with pending reorganizations see elevated attrition. Teams with new managers see elevated attrition in the first six months.

The spreadsheet model structure

Three tabs: Current State (headcount by department, level, and tenure), 12-Month Forecast (planned hires, expected attrition, net headcount change, skills gaps identified), and Action Plan (hiring priorities with target timelines, retraining investments, and open role dependencies). Update quarterly. The model does not need to be right. It needs to be useful. A workforce plan that is 80 percent accurate gives the hiring manager four weeks of additional lead time on a critical role. That is the value.

📊By the numbers