Capacity Planning Worksheet for Repetitive Tasks

830 KB | 3 files | null DOC,null PDF,null 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

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.