-
Excel workbook preview
Workforce Planning, Succession and Restructuring
Workforce Planning Workbook (Supply, Demand and Gap)
3 downloads per free account, no card needed.
Who this is for
An HR business partner downloads this when finance asks how many people each function will need over the next three years and where the shortfalls are.
What is inside
- Supply sheet projects headcount for 3 years from attrition rate, known exits and internal moves (live formulas)
- Demand sheet forecasts required FTE from volume growth, productivity gain and new roles
- Gap sheet pulls supply and demand by job family name with SUMIF, so sorting a sheet never breaks it
- Shortfall, surplus or balanced flag per job family with red and amber colour rules
- 10 sample job families plus 20 blank rows on each of the 3 working sheets
- Strategy dropdown (hire, develop, redeploy, contract, automate, reduce) with owner and due date
How to use it: Enter today's headcount and attrition per job family on the Supply sheet, the volume drivers on the Demand sheet, and read the gaps on the Gap sheet; the yellow input cells are the only ones to type in.
Files & formats
- XLSXworkforce-planning-workbook.xlsx18 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves. These templates are original working documents built on the public law or guidance named here. They are not legal advice and are not endorsed by the government body or publisher.


