Capacity Planning Worksheet for Multiple Projects
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.
The attached Zip file includes:
- Intro Page.doc
- Cover Sheet and Terms.pdf
- Capacity Planning Worksheet for Multiple Projects.xls