Labor Reports

User Personas: Admin | Project Management

Project labor reports provide insights into your field productivity. The reports give project members (that have the appropriate permissions) the ability to compare the budgeted to actual labor hours and unit productivity as the project progresses, enabling your team to make proactive changes to gauge risk and increase overall profitability. 

To perform the actions described in this article, a user must have the Analytics - Labor Reports - View permission.

Use the links below to quickly jump to a topic:

• View Project Labor Reports
• Labor Productivity
  • Labor Productivity Features
• Labor Unit Productivity
  • Labor Unit Productivity Features
• Lost Hours Report

  • Lost Hours Features

  • How to Use the Lost Hours Report

View Project Labor Reports

Select a project from the project list, then select Labor Productivity, Labor Unit Productivity, or Lost Hours under Reporting from the slide out menu.

• 1. Select a custom date range as necessary
  2. To export the data to Excel, select the Download CSV in the top right

Labor Productivity

The Labor Productivity Report is labor focused and compares your total hours for each cost code to the actual hours reported in the field.

Labor Productivity Features

• Project Cost Code ID and Name: The cost code number and name as it appears on the project cost code list. 
• Original Budgeted Hours: The original hour estimates that are associated with each cost code. The values under this column pull from the Budgets page under Settings.
• COR Hours: The hours from change orders in Approved status that are associated with each cost code.
• Total Budgeted Hours: The sum of the original hour estimates and the approved change order hours for each cost code.
• Actual Hours: The sum of all reported hours for each cost code from Crew member's timecards, which is derived from Daily Reports.
• Remaining Hours: The difference between Total Budgeted Hours and Actual Hours.
• Lost Hours: The sum of the reported Lost Hours for the cost code, which is derived from Daily Reports.

Labor Unit Productivity

The Labor Unit Productivity Report combines labor and production unit data for each cost code. It will give users a look at the percentage complete for each cost code, as well as compare budgeted versus actual production rates. The columns displayed in the report can be broken down into three categories of data: Budgeted values, actual values, and production rates.

Labor Unit Productivity Features

Budgeted Values

• Project Cost Code ID and Name: The cost code number and name as it appears on the project cost code list. 
• Original Budgeted Hours:  The original hour estimates that are associated with each cost code. The values under this column pull from the Budgets page under Settings.
• Approved CO Hours: The hours from change orders in Approved status that are associated with each cost code.
• Total Hours: The sum of the original hour estimates and the approved change order hours for each cost code.
• Original Budgeted Units: The original unit estimates that are associated with each cost code. The values under this column pull from the Budgets page under Settings.

Actual Values

• Actual Hours: The sum of all reported hours for each cost code from Crew member's timecards, which is derived from Daily Reports.
• % Complete Hours: The value of Actual Hours divided by the Total Hours for each cost code.
• Completed Units: The sum of all reported units for each cost code from Crew member's timecards, which is derived from Daily Reports.
• % Complete Units: The value of Actual Units divided by the Original Budgeted Units for each cost code.
• Remaining Units: The difference between Total Budgeted Units and Actual Units.

Production Rates

• Budgeted Rate: The value of Total Budgeted Units divided by the Total Hours for each cost code.
• Actual Production Rate: The value of Actual Units divided by the Total Hours for each cost code.
• Production Rate Difference: The difference between Actual Production Rate and the Budgeted Rate for each cost code.

Lost Hours Report

The Lost Hours Report helps track and document hours lost on the job due to various issues, such as trade stacking, material delays, site access problems, or appointments. This data allows for better tracking of project productivity and helps in managing project costs effectively. Below are details to assist with understanding each section of the Lost Hours Report.

Lost Hours Features:

• Date: Captures the specific date when the lost hours occurred. It helps pinpoint when delays happened and provides a timeline for analysis.
• Cost Code: Refers to the specific code associated with the work being performed (e.g., 100 Labor). This helps to categorize and track the types of work impacted by delays.
• Labor Class: Identifies the role or job title of the affected crew member (e.g., Foreman, Journeyman, Laborer). This is useful for tracking delays across different labor categories.
• Crew Member: Lists the specific crew member who was affected by the delay. It allows for individual tracking and accountability within the project.
• Lost Hours*: Quantifies the number of hours each crew member lost due to the delay. This helps to understand the overall impact on productivity for that day.
• Comments: Provides context to the lost hours, detailing the specific reason for the delay. For example: "Team had to stay 2 extra hours because of the late material delivery," providing insights into recurring issues that may need to be addressed.
• DR (Daily Report) Number: Links the lost hours to a specific daily report, making it easier to cross-reference additional details from that day.

Example of Lost Hours Report:

How to Use the Lost Hours Report:

• Tracking Project Delays: Review the comments and total hours lost to determine the root causes of delays on your project. You can identify recurring issues, such as material delays or trade stacking, and take corrective actions.

• Cost Management: Since lost hours contribute to additional project costs, this report can help in cost forecasting and budget adjustments.

• Performance Monitoring: By keeping track of lost hours, project managers can assess productivity levels and look for ways to improve workflow and reduce delays.

• Reimbursement: If lost hours are due to issues out of your control (e.g., weather delays, late deliveries, or incomplete work by another subcontractor), the lost hours report can serve as documentation of why you should be reimbursed for the cost of the additional time on site. 

*Note: Lost hours are not noted or included in Timecards (i.e., Hours Lost are for reporting purposes only). The full number of hours the employee worked for the day should still be entered into the Hours Worked fields in the Daily Report.