The Resource Calculators are a set of Microsoft Office Excel spreadsheets that enable you to determine optimal operations staffing levels. They help you answer the question, "How many people do I need for my operations staff?"
Each calculator calls out specific operational activities required for a specific function or technology. As such, you can use it as a reference for the operational tasks that you need to perform in your organization. The specific tasks identified in the Resource Calculators are derived from published Microsoft operational guides as well as interviews and discussions with field experts, consultants, and support professionals. The Resource Calculators also draw on material from the Microsoft Operations Framework (MOF) and the Operating Quadrant Service Management Functions (SMFs).
The following Resource Calculators are available:
Service Monitoring and Control
Active Directory Management
Windows SharePoint Services Management
SQL Server 2005 Management
The Resource Calculators are available online at Operations Templates.
How to Use the Resource Calculators
To use a calculator, you open the spreadsheet and enter the amount of time and the frequency required for an operations task. The spreadsheet then calculates the full-time employee (FTE) work effort. When you first open a calculator, you will find placeholder numbers for time and frequency. Delete these numbers before you begin.
For the most reliable results, be sure to obtain valid time and frequency data prior to working with the calculators. Track your resource usage day-to-day and analyze how your staff is spending their hours at work. The more accurate you are at analyzing the effort required by staff to perform a task, the more valid the results provided by calculator.
|The calculators are not designed to define the actual required amount of effort to perform an operations task as a specific work effort can be reduced through a number of variables, including automation and the adoption of best practices.|