A utilization report is essentially a view of hours worked vs hours paid – simple, right? You can determine appropriate staffing levels by understanding how much work they’re performing and how much work needs to be performed.

It turned out “the utilization report” at my company actually meant six distinct reports. Here’s how the system worked:

  • At the beginning of every month, a user would submit an IT ticket as a reminder to “run” the report on the 15th of the next month
  • Somewhere near the 15th of the month, a specific developer would navigate to a directory on his machine and double-click an Access database
  • The developer would then locate each of the six reports in the Access database and run them all in turn, exporting them as RTF files when they finished
  • Each report was extremely resource-intensive and completely took over the IT guy’s computer, rendering him useless for hours – and even longer if the Access database crashed
  • When all reports had been exported, they were attached to an email and sent to the user from Step 1

continue reading…