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 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:
- Intro Page.doc
- Cover Sheet and Terms.pdf
- Capacity Planning Worksheet for Multiple Projects.xls
Want to become a master of all things Excel? Check out this Advanced Excel Formulas & Functions course in the TechRepublic Academy.
