More

    Capacity Planning Worksheet for Repetitive Tasks

    Capacity Planning Worksheet for Repetitive Tasks

    This worksheet helps IT managers determine capacity for workers who perform many repetitive tasks.

    If you find yourself with staff that performs high volumes of routine tasks, you may
    find this worksheet useful. The top portion of the worksheet lets you figure out your
    actual total capacity for the department you’re looking at.

    Below, that capacity is broken into three “buckets”. The first, “support capacity”
    lets you enter approximations of how long each task takes on average, and how many
    times those tasks are performed each week.

    The next, “administrative capacity” lets you enter things like meetings, seeking
    clarification, or other work that is necessary to keep business moving. Again, you can
    enter guesses on duration, and how many times those events happen a week.

    Those two buckets are added up as time you can’t touch. Whatever is left is time
    that’s available for variable work (like projects).

    When you add these three buckets together, you can see how you stand against total
    overall capacity. Maybe you need to cut down on the number of meetings, or reduce the
    number of routine tasks you do in a week to make room for a project. Or maybe you can’t
    realistically do the project without finding more people.

    Geoff Crane of Papercut Edge and Papercut Project Monitoring created the attached
    spreadsheet to help IT managers determine capacity for workers who perform many
    repetitive tasks.

    The attached Zip file includes:

    • Intro Page.doc
    • Cover Sheet and Terms.pdf
    • Capacity Planning Worksheet for Repetitive Tasks.xls

    Latest Articles