1 of 15

Layton Utilization

Problem

Ryan McBride, Murray Poulson, Alejandro Perez-Tamayo, Rajeh Albugami

2 of 15

Overview

  • Process Explanation
  • YTD Utilization Scores
  • Determining which individuals are ready for utilization
  • Conclusions

3 of 15

Business Problem

  • How to utilize employees more efficiently by utilizing data technology
    • Calculating the effectiveness of managers
    • Deriving how many employees can be relocated to a new project

4 of 15

Methodology

  • We began by filtering our data to only contain Job Costing Employees
  • Combined our data files together for usability
  • Finally we used DOMO’s data visualization software to sort our data

5 of 15

Employee Profile Data File

Trade Description Data File

Employee Profile Data File

Filter for Permanent

Overhead Staff

Final Filtered Data Profile

Timesheets Data File

6 of 15

Note on YTD Utilization

  • The sample sizes for different managers is highly skewed, so Utilization as a statistic must be taken with a grain of salt

7 of 15

8 of 15

YTD Utilization Scores

  • Dashboard versions can be sorted by department
  • Filtered out PTO, JURY, and HLY
  • Filtered out inactive managers
  • Filtered out overhead time codes

9 of 15

10 of 15

Utilization Solution

  • Regularly monitor managers utilization percentages
  • Set a base utilization percent at which point individual managers could receive an automatic reminder (suggested 80%)
  • Below 70% utilization upper management should find contextual details of the situation and determine if further intervention is necessary

11 of 15

Number of Hours OH Per Employee for Current Pay Period (October 10th-17th)

12 of 15

13 of 15

Relocation Solution

  • Hire less managers, supervisors and higher level positions
    • Higher level slackers= more money spent
  • Data technology usage for forecasting

14 of 15

15 of 15

Summary

  • Utilization can be monitored through DOMO
  • Use dashboard info to determine staffing requirements for management positions