Analyzing Crew Utilization

This article provides information on the Schedule Analytics graphs related to Crew Utilization available in ALICE.

The table below provides a general overview of the available analytics graphs as well as their basic properties.

Available Graph Cumulative Vs Daily Affected By Filters
Crew Utilization Daily By Crew Filters
Workforce Utilization Daily No


Crew Utilization Graph Example


The Crew Utilization graph provides a daily histogram displaying which crews are performing productive work on site for the duration of the project. Please note that the graph does not include the presence of idle crews on site. ALICE computes Crew Utilization across all crews and shows the average crew utilization on the analyze page. 

The utilization is color-coded per crew so you can intuitively see what the crew composition is on site each day.


Using Filters

You may use crew filters to switch between the specific graphs for every crew, and, if applicable, use the search function to filter by subcontractor.


Exporting the CSV data for this graph will include a breakdown of crew utilization by day, by crew, and by subcontractor.


Workforce Utilization

Similarly, the workforce utilization graph provides a daily histogram displaying the total personpower on site day-by-day, grouped by subcontractor.


How Utilization is Calculated

For any single crew, the Crew Utilization in a project is defined as:

Days Worked / Total Work Days on site

* It is important to remember that ALICE uses hours instead of days as the base unit of time
** Calendars are fully accounted for. So if a crew is on a 4 day workweek (i.e. working Monday to Thursday), they will have 4 working days in a week.

Example 1

Crew A is on a 4 day work calendar with Friday, Saturday, and Sunday off. In the project, they perform work on Monday and Tuesday in the first week and Tuesday, Wednesday and Thursday in the following week and then finish. The Crew Utilization for Crew A is visualized as:


This example results in a Crew Utilization of 62% for Crew A.

Crew Utilization = Days Worked / Total Work Days on site = 5 / 8 = 0.625 or 62%

Example 2

Crew B is on a 5 day calendar. Here is Crew B’s time-sheet for a project:


Here the Crew Utilization for Crew B is 86%.

Crew Utilization = Days Worked / Total Work Days on site = 13 / 15 or 86%

Was this article helpful?
1 out of 1 found this helpful