• Preview of Resource Plan and Capacity Planner (FTE by month)Excel workbook preview

Project Resources and Team Management

Resource Plan and Capacity Planner (FTE by month)

$17.99 Free XLSX
Excel workbook · 17 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

A project manager or PMO analyst asked by the sponsor or resource managers to show which roles the project needs each month and where commitments fall short.

What is inside

  • Demand sheet with 10 sample rows over 12 months and 18 blank rows, live FTE-month and peak totals
  • Capacity sheet with 9 roles, who committed them and when
  • Summary gap grid per role and month: red where demand exceeds commitment
  • Monthly totals with utilisation turning amber above 90% and red above 100%
  • Line chart of planned against committed FTE across the year
  • Role dropdown fed from the capacity list, TBC names highlighted amber

How to use it: List each role once on Capacity with the FTE committed, then plan demand per month on Demand. Fix every red gap in Summary before the monthly resource review.

Files & formats
  • XLSXresource-plan-capacity-planner-template.xlsx17 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.