Capacity Planning Worksheet for Multiple Projects

168.8 KB | 3 files | null DOC,null PDF,null XLS

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
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.

This Download is provided by:

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 »
Related IT Downloads

Misc64 Microsoft PowerPoint 2016 Quick Reference

This Microsoft PowerPoint 2016 Quick Reference covers the basics screen layout, fundamentals of using the program and working with slides, keyboard shortcuts, formatting, transitions and working with images and multimedia files. ...  More >>

infra84 Microsoft Word 2016 Quick Reference Card

This Word 2016 Quick Reference Card covers program fundamentals, as well as essential keyboard shortcuts for navigation, editing and formatting that can make your work go even faster. ...  More >>

Misc33 Microsoft PowerPoint 2013 Cheat Sheet

Microsoft PowerPoint 2013 is a slide-based presentation software that helps you show your information in a organized, visual manner for easier understanding. ...  More >>

Subscribe to our Newsletters

Sign up now and get the best business technology insights direct to your inbox.


By submitting your information, you agree that itbusinessedge.com may send you ITBbusinessEdge offers via email, phone and text message, as well as email offers about other products and services that ITBbusinessEdge believes may be of interest to you. ITBbusinessEdge will process your information in accordance with the Quinstreet Privacy Policy.