Table of Contents
For customers with Field Productivity and Project Financials, you can track and manage your production quantities in your budget.
You can leverage flexible Work Breakdown Structure (WBS) when budgeting the resource hours and associated cost, as well as a production plan based on units to install for production quantities. Flexible WBS allows your team to budget, track time and units installed in Timesheets, and report at the right level of granularity, for an enhanced real time labor productivity cost Budget View.
You can also set up a budget view named 'Procore Labor Productivity Cost' budget view. This is a pre-built view that you can quickly add to a project. It allows users to input production quantities to your project's budget.
This guide walks you through how to:
This workflow shows the setup instructions as well as the time entries needed to see that information in the budget view.
When this setting is turned ON, project administrators can perform these tasks:
To adjust your company's Work Breakdown Structure (WBS) for a Procore project.
After creating a new project in your company's Procore account, you can use the built-in WBS features to define the cost structure for Procore's Project Financials tools. When defining a project's WBS cost structure, you have two choices. If you are unsure which choice to make, contact your company's Procore Administrator for guidance:
Assign the Default Cost Type for timecard entries in the Company Timesheets tool.
To configure additional settings, see Configure Advanced Settings: Company Level Timesheets.
You can leverage flexible Work Breakdown Structure (WBS) when budgeting the resource hours and associated cost, as well as a production plan based on units to install for production quantities. Flexible WBS allows your team to budget, track time and units installed in Timesheets, and report at the right level of granularity, for an enhanced real time labor productivity cost Budget View.
With Flexible WBS: |
Without Flexible WBS: |
This guide shows you how to configure a real-time labor productivity budget view that integrates with Procore's Field Productivity tools. This view provides the project's Budget tool with the ability to instantly leverage the timecard entry hours submitted by your project's field personnel in the Timecard, Timesheets, My Time (Android), and My Time (iOS) tools and update the project's budget view immediately after timecard hour entries are submitted.
For project managers, this eliminates the need to wait for timecard data to be manually input into a budget. This functionality is particularly useful for self-performing contractors who want to gain real-time insight into a project's actual labor costs, and can help to minimize the potential for labor overruns to occur on a project.
Real-Time Labor Productivity Budget View in the Budget Tool
The illustration below shows you the recommended layout for the 'Real-Time Labor Productivity' budget view, as it will look when applied to your project's Budget tool.
These are the recommended column settings for the Real-Time Labor Productivity budget view:
Column Name | Column Type | Column Format | Description |
---|---|---|---|
Approved COs Amount | Source | Currency | This is a hidden column that you create to perform a calculation for the values appearing in the 'Revised Budget Amount' column. |
Approved COs Unit Quantity | Source | Number | This is a hidden column that you create to perform a calculation on the values appearing in the 'Revised Units' column. |
Revised Units | Calculated | Number | This shows the original Budget Unit Qty + Approved COs Unit Qty. |
Budget UOM | Standard | n/a | This shows the Unit of Measure (UOM) for the budget line item. |
Budget Change Production Quantity | Source | Number | Represents internal changes to budgeted production quantities to be installed (outputs). It includes Unit Quantity and UOM. |
Budget Change Unit Quantity | Source | Number | This shows the Unit Qty and UOM amount from a Budget Change. |
Revised Budget Production Quantity | Calculated | Number | Shows the original Budgeted Production Qty + Approved CO Production Qty + Approved Budget Changes Production Qty. |
Revised Budget Unit Quantity | Calculated | Number | Shows the original Budget Unit Qty + Approved CO Units + Approved Budget Changes Unit Qty. |
Revised Budget Amount | Calculated | Currency | This shows the Original Budget Amount + Approved COs Amount. |
Actual Cost | Source | Currency | This shows the Direct Costs amount. |
Actual Units | Source | Number | This shows the Direct Costs Unit Quantity. |
Actual Unit Cost | Calculated | Currency | This shows the Actual Cost/Actual Units. |
Timesheet Hours | Source | Number | This shows all Timecard Entry Hours. |
% Hours Used | Calculated | Percent | This shows the Timesheet Hours/Revised Units. |
Estimated Real-Time Cost | Calculated | Currency | This shows the Actual Unit Cost x Timesheet Hours. |
Hours Remaining | Calculated | Number | This shows the Revised Units - Timesheet Hours. |
Note: You must add this column before you can add a calculated column named 'Revised Budget Amount'.
Steps from the Configure Columns window… | Settings |
---|---|
|
Note: You must add this column before you can add a calculated column named 'Revised Units'.
Steps from the Configure Columns window… | Settings |
---|---|
|
Note: You must first create the 'Approved COs Unit Qty' column. See Approved COs Unit Qty.
Steps from the Configure Columns window… | Settings |
---|---|
|
Note: You must also remove all other columns under Standard Budget.
Steps from the Configure Columns window… | Settings |
---|---|
|
Note: This adds a source column named 'Budget Change Production Quantities.' You must add this column before you can add a calculated column named 'Revised Budget Production Quantity.'
Steps from the Configure Columns window… | Settings |
---|---|
|
Note: This adds a source column named 'Budget Change Unit Quantities'. You must add this column before you can add a calculated column named 'Revised Budget Unity Quantity'.
Steps from the Configure Columns window… | Settings |
---|---|
|
Note: You must first create the Budget Change Production Quantity column. See Budget Change Production Quantity.
Steps from the Configure Columns window… | Settings |
---|---|
|
Note: You must first create the Budget Change Unit Quantity column. See Budget Change Unit Quantity.
Steps from the Configure Columns window… | Settings |
---|---|
|
Steps from the Configure Columns window… | Settings |
---|---|
|
For companies using the ERP Integrations tool:
Steps from the Configure Columns window… | Settings |
---|---|
|
Steps from the Configure Columns window… | Settings |
---|---|
|
For companies using the ERP Integrations tool, keep in mind that you will NOT be able to configure an 'Actual Units' column on a budget view unless the Direct Costs tool is enabled and you are using the Sage 300 CRE® connector to sync job cost transactions. See Add the Columns for Job Cost Transaction Syncing to a Budget View for ERP Integrations.
Steps from the Configure Columns window… | Settings |
---|---|
|
When adding a 'Timesheet Hours' source column to the budget view, it is recommended that you include timecard entries in both the 'Approved' and 'Pending' status. However, your company's Procore Administrator may prefer to use a different setting for your company's account.
Steps from the Configure Columns window… | Settings |
---|---|
|
Steps from the Configure Columns window… | Settings |
---|---|
|
Steps from the Configure Columns window… | Settings |
---|---|
|
Steps from the Configure Columns window… | Settings |
---|---|
|
If you created the 'Real-Time Labor Productivity' budget view from the 'Blank Budget View' template contains a few columns that can be hidden from this view. This is an optional step.
Steps from the Configure Columns window… | Settings |
---|---|
|
The 'Procore Labor Productivity Cost' budget view provides project teams with the ability to include production quantities on the project's budget. See What are 'production quantities'? Building off the Real-Time Labor Costing feature, the 'Procore Labor Productivity Cost' budget view is designed to provide self-performing and specialty contractors with the ability to gain greater insight into your project's production rates to make better decisions that maximize profit margins. With this release, you can:
By default, Procore provides its users with a standard 'Procore Labor Productivity Cost' budget view, which is available to your company's Procore Administrator in the Company level Admin tool.
Procore Labor Productivity Cost Budget View in the Budget Tool
The illustration below shows you the recommended layout for the 'Procore Labor Productivity Cost' budget view, as it will look when applied to your project's Budget tool.
Default Columns
The following table details the default columns provided with the 'Procore Labor Productivity Cost' budget view. In the Description column, the following symbols represent the operator for a calculation:
Column Name | Column Type | Column Format | Column Description | Column Configuration |
---|---|---|---|---|
Revised Budget | Calculated | Currency | Shows the Original Budget amount, plus the Budget Change amount, plus the Approved COs amount. | Original Budget Add (+) Budget Changes Add (+) Approved COs |
Direct Costs | Source | Currency | Shows the Direct Costs amount. | Source Category: Direct Costs Source: Direct Costs Source Filtering: Status = Pending, Revise and Resubmit, Approved |
Direct Costs Unit Cost | Source | Number | Shows the actual cost per unit for direct costs. | Direct Costs Divide (/) Direct Costs Unit Qty |
% Budget Complete | Calculated | Percent | Shows how much of the current budget amount for the budget line item is estimated to be used based on the real-time labor hours and actual labor cost. | Estimated Cost w/ Timesheet Hours Divide (/) Revised Budget |
Projected Labor Cost at Completion | Calculated | Currency | Shows the projected labor cost at completion for the budget line item. | Projected Hours at Completion Multiply (*) Direct Costs Unit Cost |
Projected Labor Cost Over/Under | Calculated | Current | Shows the Revised Budget minus the Projected Labor Cost at Completion. | Revised Budget Subtract (-) Project Labor Cost at Completion |
Revised Budgeted Unit Qty | Calculated | Number | Shows the Budget Production Qty plus the Approved COs Production Qty. | Budget Unit Qty Add (+) Approved CO Units |
Budget UOM | Standard | n/a | Shows the Unit of Measure (UOM) for the budget line item. | n/a |
Timesheet Hours 1 | Source | Number | Shows all Timecard Entry Hours. You can optionally apply Status filters to narrow the data in the view. | Source Category: Timecard Entry Hours Source: Timecard Entry Hours Filtering: None |
% Hours Used | Calculated | Percent | Shows how much of the current budget unit qty (labor hours) have been used based on time submitted in Procore. | Timesheet Hours Divide (/) Revised Budget Unit Qty |
Earned Hours | Calculated | Number | Shows the number of labor hours earned (merited) based on the work produced to date for that cost code. |
Revised Budget Unit Quantity |
Projected Hours at Completion | Calculated | Number | Shows the estimated labor hours needed to complete production for the cost code based on the work produced to date. | Timesheet Hours Divide (/) % Complete Production |
% Complete Production | Calculated | Percent | Shows the percentage of the production quantity has been installed to date of the current budgeted production quantity for the cost code. | Actual Qty Installed Divide (/) Revised Budgeted Production Qty |
Production UOM | Source | n/a | Shows the UOM for the budgeted production quantity (i.e., for the cost code on the line item). | Source Category: Production UOM Source: Budgeted Production UOM Source Filtering: n/a |
Revised Budgeted Production Rate | Calculated | Number | Shows the actual budgeted production rate based on labor hours and installed quantities to date. | Revised Budgeted Production Qty Divide (/) Revised Budget Unit Qty |
Actual Production Rate | Calculated | Number | Shows the actual budgeted production rate based on labor hours and installed quantities to date. | Actual Qty Installed Divide (/) Timesheet Hours |
Variance Production Rate | Calculated | Number | Shows the difference between the current budgeted production rate and the actual production rate. A positive number indicates you are performing faster than expected. A negative number indicates you are performing slower than expected. | Actual Production Rate Subtract (-) Revised Budgeted Production Rate |
1 The 'Labor Productivity Cost' budget view is only available to customers using Procore's Field Productivity tools. However, the 'Timesheet Hours' column can be added to other budget views. To learn how to add the column, see Can we import our third-party timecard entries to work with the 'Timesheet Hours' column in Procore's Budget tool?
If you want to customize the Procore Labor Productivity Cost budget view, you can click the Configure Columns button. This opens the Configure Columns window, which allows you to edit the budget view. To learn about your editing options, see Configure the Columns for a Budget View in the Set Up a New Budget View tutorial. When you are finished, click the 'x' in the Configure Columns window to close it.
After closing the Configure Columns window, the system returns you to the new budget view's window. Under Column Configuration, you can get an idea of how your budget view will look in Procore by selecting a project from the Preview with Project drop-down list.
The budget import template that you downloaded must be used for the import. In addition, the column layout and headings in the template are required:
If you select 'False' in the ''Manual Calculation' column and enter data in the Unit Qty, Unit of Measure, and Unit Cost columns, you can leave the 'Budget Amount' column blank. Procore will automatically calculate this value for you after your data is imported into the project's Budget tool.
You can also use these options to create a new daily timesheet:
The selections that are available in the 'Cost Codes' drop-down list depend on how the 'Limiting Cost Codes by Cost Types' setting is configured in your Company level Timesheets tool. See Configure Advanced Settings: Company Level Timesheets. In addition, one (1) of the following items must also be true on your project:
Now that you have filled out your timesheet, perform the following actions before you submit:
Click Submit and Add Quantities.
Note: This button will be disabled if quantities have not been uploaded to the project. See Import a Unit Quantity Based Budget.
In the 'Add Quantities' page, enter an amount in the Units Installed field.
Click Submit.
To add changes to production quantities in a change event.
For companies using Procore's Project Financials and Workforce Management tools with the 'Procore Labor Productivity Cost' budget view, you can log additional production quantities and production hours associated with your change event line items in the 'Production Quantities' section of a change event.
Let's assume that after your project's budget is locked, the project owner requests a design change that is out of scope with the original design. The change requires additional drywall, so you first create a change event and add a line item to that change event for that drywall. If that change represents a change to production, you will also want to record that change in the 'Production Quantities' tab of the change event.
Once you record the production quantities in the change events, the values are updated in the Change Events view page. The production quantities may also be associated with any Prime potential change order or Budget Change created from a Change Event. However, you must follow these steps: Create a Prime Potential Change Order from a Change Event.
After you have submitted your prime contract change order to the owner for review, the owner can then approve or reject it. See Approve or Reject Prime Contract Change Orders. When the status of the prime contract change order changes to 'Approved', the updated production quantities are reflected in the 'Procore Labor Productivity Cost' budget view and the Field Production Report.
For production quantities to interact with labor productivity tracking feature, you must:
Production Quantities relate to contracts and the budget through a combination of sub job and cost code. Users may edit these fields when editing change events line items in the change events edit page. However, if the Production Quantities are associated with a Prime potential change order or Budget Change, the Production Quantity will be locked unless unlinked from the change objects.
To add changes to production quantities in a Prime Potential Change Order (Prime PCO).
For companies using Procore's Project Financials and Workforce Management tools with the 'Procore Labor Productivity Cost' budget view, you can log additional production quantities associated with a Prime Potential Change Order (PCO) in the 'Production Quantities' tab on the project's Prime Contract's tool.
For production quantities to interact with the labor productivity tracking feature, you must: