Capacity Planning Worksheet for Multiple Projects This attached spreadsheet helps IT managers avoid maxing out project resources and the resulting costly overtime. Let’s say you have a bunch of projects on the go, your portfolio management system is too clunky (or you don’t have one) and you need to do some “what-if” analysis. You have […]
This attached spreadsheet helps IT managers avoid maxing out project resources and the resulting costly overtime.
Let’s say you have a bunch of projects on the go, your portfolio management system
is too clunky (or you don’t have one) and you need to do some “what-if” analysis.
You have one pool of Business Analysts, Developers and Testers and up to five
projects. How do they all fit together? To get all these projects done, how many
resources do you really need? What happens to your other projects if one of your
projects is late by a week? What happens if you lose someone?
Enter the durations of your projects, and the number of each type of resource. Use
the slider buttons to move your projects back and forth through time. When you do that,
the graph at the top will change. If any of the lines in the graph go over the capacity
line, you have a problem.
Geoff Crane of Papercut
Edge and Papercut Project
Monitoring created the attached spreadsheet to help IT managers avoid
maxing out project resources and the resulting costly overtime.
The attached Zip file includes:
Want to become a master of all things Excel? Check out this Advanced Excel Formulas & Functions course in the TechRepublic Academy.
The go-to resource for IT professionals from all corners of the tech world looking for cutting edge technology solutions that solve their unique business challenges. We aim to help these professionals grow their knowledge base and authority in their field with the top news and trends in the technology space.
Property of TechnologyAdvice. © 2025 TechnologyAdvice. All Rights Reserved
Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.
