Equipment_Utilization
Intro: See exactly how your company utilizes its equipment on a monthly basis.
In Kompass: If you open "Schedule" and switch to the Equipment view, the Office row at the bottom shows all the equipment that is stuck in the office. You can then decide whether to sell some or off-hire them. It is not easy, however, to get the utilization figures. Also, what if a piece of equipment is assigned to an employee who is not working on any task, and it sits unused in their storage? That information is not easy to find in Kompass.
File Needed: This file uses an API token, so there is no need to export any data from Kompass. We will send you the file by email.
Updating method: API Token
The File: The file needs your API token to update. First, select the time period of your analysis, then click the "Refresh Here!" button, both in the "HOW TO" sheet.

As with most such files, instructions on how to use the file are in the sheet itself.
The "Data" sheet contains several useful views.
-
Find utilization on task and on assignment by equipment category or for each piece of equipment. Utilization on task is the percentage of days the equipment is used on a task. Utilization on assignment is the percentage of days the equipment is not dropped back to the office. The higher both percentages, the better.

-
Find out which department uses which equipment category and piece of equipment the most. As before, feel free to expand or collapse your dataset to show categories or individual items.

-
Check your utilization by department or by equipment category.

-
Finally, manage utilization by seeing how it changes over the months. Investigate how it changes by equipment owner. You most certainly want hired equipment to be fully utilized.

Further analysis: The file already slices the data in numerous ways. Feel free to add more tabs, graphs and pivots to your liking.



