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:
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 >>
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 >>
CustomGuide gives users a handy 'cheat sheet' to quickly master the basics of using Access 2010. ... More >>