Capacity Planning Worksheet for Repetitive Tasks

830 KB | 3 files |  DOC, PDF, XLS

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

Laptop Microsoft Excel 2013 Cheat Sheet

This Excel 2013 Cheat Sheet from CustomGuide covers program fundamentals, as well as essential keyboard shortcuts for navigation, editing and formatting that can make your work go even faster. ...  More >>

Job Description: Data Migration Specialist Job Description: Data Migration Specialist

The Data Migration Specialist analyzes the current method of data migration from mainframe application data to distributed database formats and provides recommendations for processing....  More >>

Microsoft Access 2010 Reference Guide Microsoft Access 2010 Reference Guide

CustomGuide gives users a handy 'cheat sheet' to quickly master the basics of using Access 2010. ...  More >>

Subscribe to our Newsletters

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


Resource centers

Business Intelligence

Business performance information for strategic and operational decision-making


SOA uses interoperable services grouped around business processes to ease data integration

Data Warehousing

Data warehousing helps companies make sense of their operational data