Labor Utilization Analytics: Data Sources

The data displayed in Labor Utilization Analytics is calculated using a combination of employee attribute and organization data from Costpoint.

Calculation Dependencies

Timesheets must be posted in Costpoint to be considered in the labor utilization calculations.

Employees, subcontractors, vendors, and vendor employees must be set up as employees to be considered in Labor Utilization calculations.

Calculations

The system administrator configures the calculations for labor utilization. For example, staff utilization percent at one company may include vacation hours, but at another company it does not.  

The system administrator also makes such decisions as whether or not to include cost only pay types or bonus timesheets.

Data Item

Source

Direct Labor Utilization by Hours

 

Direct Labor Utilization by Hours = Direct Labor Hours/Total Labor Hours

This is defined by account or a combination of project classification and project type.

Direct Labor Utilization by Cost

 

Direct Labor Utilization by Cost = Direct Labor Cost/Total Labor Cost

This is defined by account or a combination of project classification and project type.

Available Labor Utilization by Hours

 

Available Labor Utilization by Hours = Direct Labor Hours/(Total Labor Hours — Leave Hours)

Available Labor Utilization by Cost

Available Labor Utilization by Cost = Direct Labor Cost/(Total Labor Cost — Leave Cost)

Direct Hours Utilization %

Direct Hours Utilization % = Direct Hours/Total Hours

Direct Cost Utilization %

Direct Cost Utilization % = Direct Cost/Total Cost

Available Hours Utilization %

Available Hours Utilization % = (Direct Hours/(Total Hours — Leave Hours))

Available Cost Utilization %

Available Cost Utilization % = (Direct Cost/(Total Cost — Leave Cost))

Leave

This is defined by account or a combination of Project Classification and Project Type

Non-Direct Hours or Cost

This is calculated by subtracting the Direct Hours (or Cost) from the Total Hours (or Cost)

Target

The Target is entered in the budget files.  There is only one value, and it is not broken down by period or project.