-
Excel workbook preview
Project Resources and Team Management
Resource Plan and Capacity Planner (FTE by month)
3 downloads per free account, no card needed.
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.


