More

    Capacity Planning Excel Template: Free Download

    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.

    Get the Free Newsletter!

    Subscribe to Daily Tech Insider for top news, trends, and analysis.

    Latest Articles