5 Workforce Planning Templates (Free Excel Download)
Workforce planning answers a question that a budget alone cannot: will we have the people, with the skills, in the places, at the cost, that the plan needs, and if not, what do we do about it? It compares projected demand for roles with projected supply after attrition, retirement and internal moves, and turns the gap into decisions: hire, develop, redeploy, contract, automate or change the plan.
Five templates do the work. A headcount plan by role and month, a supply-and-demand gap analysis with attrition built in, a skills inventory that shows who can do what and how deeply, a scenario model that tests the plan against growth and cost assumptions, and a succession plan for the roles that would hurt most to lose. The Excel workbook does the arithmetic; the Word and PDF versions carry the plan narrative. The strategic workforce planning guide covers the longer horizon and the method.
Download the templates
Free files: Word, Excel and PDF
Three files, free, no email required. Word to edit, Excel to track, PDF to print or share.
Templates open in Microsoft Word, Excel, Google Docs and Sheets, LibreOffice and any PDF reader. Free to use and adapt for your organization.
The five templates
| Template | Question it answers | Horizon |
|---|---|---|
| Headcount plan | How many of each role, by quarter, at what cost? | One year |
| Gap analysis | After attrition and moves, where are we short or long? | One to three years |
| Skills inventory | Who can do what, and where is one person the only one? | Now |
| Scenario model | What if growth is 20 percent, or minus 15? | One to three years |
| Succession plan | Who covers the roles that would hurt most to lose? | One to three years |
The gap analysis is the core
Demand is the FTE each role needs under the plan. Supply is current headcount minus expected attrition (current headcount times the attrition rate for that role, not the company average), minus known retirements, plus and minus internal moves. The gap is supply minus demand, and the sheet suggests the action: hire or develop where short, redeploy or hold where long. The two numbers that make or break the analysis are the attrition rate by role, which the turnover rate entry explains how to calculate, and the loaded cost per FTE, which the employee cost calculator provides.
Run the gap analysis by role, not by department. Departments are usually balanced in total and short in the two roles that matter.
Skills, not just seats
A headcount plan that is full can still fail if the skills are in the wrong people. The skills inventory rates each person on each critical skill from 0 to 4, and the coverage sheet counts how many people are independent on each skill and flags any skill where one person or none is. Those single points of failure are the succession plan's first entries. Keep the skills list short, six to ten that matter for the plan, and rate honestly; a sheet of fours is a sheet nobody believes.
Plan for more than one future
- Base, growth and downturn columns with the same structure, so the plan can be compared, not just the headline.
- Change assumptions, not outputs: volume, attrition, lead time, loaded cost.
- Hires required accounts for leavers; a flat headcount at 15 percent attrition still means hiring 15 percent of the workforce.
- Hiring lead time turns a gap into a start date for recruitment; a role needed in March with a twelve-week lead time is a January requisition.
- The capacity planning templates handle the quarter; this model handles the year and beyond.
Key takeaways
- Workforce planning compares demand for roles with supply after attrition and moves, and turns the gap into hire, develop, redeploy or change-the-plan decisions.
- Use attrition by role and fully loaded cost per FTE; the company averages hide the problem.
- Inventory critical skills and flag single points of failure; they are the succession plan's first entries.
- Model base, growth and downturn with the same structure, and convert gaps into requisition dates using hiring lead time.
Frequently asked questions
What is a workforce planning template?
A set of sheets that project how many people, in which roles and with which skills, an organization will need against how many it will have after attrition, retirement and internal moves, and that record the actions to close the gap. The download includes a headcount plan, gap analysis, skills inventory, scenario model and succession plan.
How do I calculate the workforce gap?
Projected supply is current headcount minus expected attrition (headcount times the role's attrition rate) minus known retirements, plus internal moves in, minus moves out. Gap is projected supply minus demand. A negative gap means hire or develop; a positive one means redeploy or hold.
What attrition rate should I use?
The role's own trailing twelve-month rate, not the company average; frontline and early-career roles often run two to three times the average. Calculate it as leavers divided by average headcount for the period.
What is the difference between workforce planning and capacity planning?
Capacity planning matches a team's hours to its commitments over a quarter. Workforce planning matches roles, skills and headcount to the business plan over one to three years, including hiring, development and succession. Capacity gaps that persist become workforce planning inputs.
How often should the workforce plan be updated?
Annually as part of budgeting, with a quarterly refresh of attrition, open requisitions and the gap. Scenario assumptions are revisited when the business outlook changes.