Reporting is key to ensuring your projects close on-time and on-budget. Below are a description of all eSUB reports that help you stay on track and provide insight into your projects.
Pro Tip: All Labor Reports and Graphs populate from data entered in Daily Reports. For those using eSUB Time or eSUB Kiosk to track time, Labor Productivity and Labor Unit Productivity are the two reports that can pull data from Timecard Management.
The Labor Productivity report provides access to the health and status of a project. You can track the budgeted labor hours vs. used labor hours by system, phase, and Cost Code. By utilizing the % complete column, the report will calculate the projected hours and efficiency of a project. This allows you to determine if you are working ahead of or behind schedule and to make adjustments on site, if possible, before the opportunity is lost.
Labor Productivity Report Details
Labor Unit Productivity (Excel Export)
The Labor Unit Productivity report provides unit tracking by Cost Codes or Job Costing when filtered by Labor Class. Tracking labor unit productivity provides real-time insights into contractors’ field productivity. The Labor Unit Productivity Report allows foremen, project managers, and executives to compare budgeted to actual unit productivity as the project progresses so that they can make proactive changes to increase profitability.
- By default, unit tracking is turned OFF in eSUB. To turn it ON, go to Start > Administration > Company Setup > Company Preferences > DRs.
- Units are tracked in Daily Reports. Units can be estimated in Project Configuration > Add Job Cost Estimates.
Labor Unit Productivity Details
The Labor Summary report provides an overview of labor hours by: month, work type, labor class, system, phase, and Cost Code as tracked in Daily Reports. It includes regular hours and delay hours (Hours Lost). This summary also shows the overall units installed by Cost Code.
Hours Lost Summary
The Hours Lost Summary report sorts Hours Lost by Cost Code. This critical report provides key insights into why your team may be behind schedule. As foremen track hours lost on daily reports, such as “jobsite not open” or “late delivery”, a project management team has insight into why work may be delayed. This information can help improve communication with workers and vendors for increased performance, or as backup to a GC as to why you are not responsible for the schedule delay or owed additional payment.
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.
The Budgeted Hours report summarizes the planned hours, COR budgeted hours, and actual hours by Cost Code. If you have added budgeted hours expected by week, this report will summarize those planned and actual hours as well.
Job Cost Reports
Cost to Complete
The Cost to Complete report values come from the Cost Details report. This report provides a summary by cost type only and allows managers to understand the profitability of the project. To accurately run this report, you will need to click on “Copy from Cost Details” (or manually input the values) on the actual cost and projected cost columns, then click “Calculate & Save”.
Cost to Complete Report Details
Cost Details (Excel Export)
The Cost Details report provides a breakdown of Cost Type per Cost Code, and System/Phase if applicable. Should you choose, you can copy the Committed Costs over, or manually enter Actual Costs provided by accounting. The Project Additional Costs column will automatically calculate Budgeted Costs minus Actual Costs, unless overwritten. The details in this table will then pull into the Cost to Complete report.
The benefit of this report is to understand how your project is performing at a Cost Code level throughout the project, and at the end. This allows the project team to make adjustments, if possible, before the completion of the project to avoid any major bust to the budget. And additionally at the end of the job, it will provide the estimating team a detailed understanding of how the project performed compared to their original assumptions.
Change Order Status
The Change Order Status report provides a list of all change orders and their current status. The log may be sorted by all CORs, or by approved or pending specifically. This provides managers with a high-level view of outstanding CORs so they can follow-up with the owner/GC accordingly.
Equipment and Material Reports
Material Item Summary
The Material Item Summary report provides a list of all materials ordered and received through the PO module and materials used via Daily Reports.
Materials Item Summary Details
Equipment Log (Excel Export)
The Equipment Log provides a log of equipment usage by day, as reported in Daily Reports. Assuming the foreman are keeping accurate notes about the status of equipment, this log will also allow you to see the notes and if there are any equipment issues or maintenance due. While this data does not pull directly into POs, it does allow management to track equipment usage and commit costs to the PO module as needed.
Equipment Usage Summary
While the Equipment Log lists equipment usage by Daily Report, the Equipment Usage Summary only notes the equipment type and hours used cumulatively on the project. The manager can review this log over a certain timeline and gain an understanding of how much each piece of equipment is being used on a weekly, monthly, or yearly basis.
Article is closed for comments.