• Preview of Workforce Planning Workbook (Supply, Demand and Gap)Excel workbook preview

Workforce Planning, Succession and Restructuring

Workforce Planning Workbook (Supply, Demand and Gap)

$17.99 Free XLSX
Excel workbook · 18 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

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.