Capacity Planning Worksheet for Multiple Projects

This attached spreadsheet helps IT managers avoid maxing out project resources and the resulting costly overtime.


Partner logo

Navigate projects safely no matter where you are in the process with proactive, responsive solutions from Papercut Project Monitoring.

All IT Downloads from Papercut Project Monitoring » | Visit Papercut Project Monitoring »

From Papercut Project Monitoring | Jun 14, 2010

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
IT Downloads help you save time and money while executing essential IT management tasks. Download this useful resource now and put it to work for your business.

The Business Case for Project Portfolio Management

This white paper presents industry best practices of how companies are using project portfolio management solutions to deliver on key performance goals of being on time, budget, quota, and target.

Define, Hire, and Develop Your Next-Generation Project Managers

This Forrester white paper explores the evolution of project management and outlines steps for defining, hiring, and developing your next-generation project managers.