Add the Change Events Columns to a Budget View (Including Revenue ROM)

Objective

To add the change events columns to a budget view. 

Background

If your company has opted to use the Change Events tool on a project, you can use the steps below to add one or more of the data columns associated with the Change Events tool to your project's budget view.  The Change Events data columns include:

Things to Consider

Prerequisites

Steps

Step 1: Choose a Budget View

When adding the columns detailed in this article, you have these choices:

After choosing the preferred option for your budget view, add all of the recommended columns using the steps detailed below.  

Step 2: Add the Recommended Columns

Next, add and/or update the following columns in the order recommended below:

Add a Cost ROM Column

This adds a source column named 'Cost ROM' which shows a ROM estimate for change events. The value that appears in this column on a budget line item is not yet associated with a CCO, an RFQ, or a Non-Commitment Cost. 

Steps from the Configure Columns window in the Company Admin tool… Settings
  1. Click Create Source Column.
  2. Under New Source Column, do the following:
    • Column Name. Enter the name: Cost ROM
    • Column Source. Select Change Events. 
  3. Mark the ROM (Rough Order of Magnitude) checkbox to apply these filters: 
    1. Under Prime PCO, remove all of the marks from these checkboxes. 
    2. Under RFQ or Commitment Cost, mark the Without Cost checkbox only.
       Note
      This ensures that the source column includes only items that do not have associated costs, which excludes amounts from:
      • Request for Quotes (RFQs)
      • 2-tier Commitment Potential Change Orders (Commitment PCOs)
      • 1-tier Commitment Change Orders (CCOs)
    3. Under Non-Commitment Cost, mark the Without Cost checkbox only.
       Note
      This ensures that the source column includes only amounts with commitment costs and excludes Non-Commitment Costs (NCCs). 
    4. Under Scope, mark these checkboxes only:
      • In Scope
      • TBD
    5. Under Change Event Status, mark these boxes only:
      • Open
      • Closed
      • Pending
         Note
        • When filtering the columns data by change event status, any statuses not considered 'Void' are selected by default. 
        • If your company created custom statuses, those will NOT be shown by name. However,  any custom status considered 'Open', 'Closed', and 'Pending' are also selected by default. 
        • To learn more about custom statuses, see Set the Default Change Management Configurations.
  4. Click Create.
 bv-column-cost-rom.png

Add a Cost RFQ Column

This adds a source column named 'Cost RFQ' which shows costs associated with RFQs. The value that appears in this column on a budget line item is not yet associated with a CCO or a Non-Commitment Cost. 

Steps from the Configure Columns window in the Company Admin tool… Settings
  1. Click Create Source Column.
  2. Under New Source Column, do the following:
    • Column Name. Enter the name: Cost RFQ
    • Column Source. Select Change Events. 
  3. Mark the RFQ (Request for Quote) checkbox to apply these filters: 
    1. Under Prime PCO, remove all of the marks from these checkboxes. 
    2. Under RFQ or Commitment Cost, mark the Without Cost checkbox only.
       Note
      This ensures that the source column only includes values that do not have costs. This setting excludes amounts from:
      • 2-tier Commitment Potential Change Orders (Commitment PCOs)
      • 3-tier Commitment Potential Change Orders (Commitment PCOs)
      • 1-tier Commitment Change Orders (CCOs)
    3. Under Non-Commitment Cost, mark the Without Cost checkbox only.
       Note
      This ensures that the source column includes only amounts with commitment costs and excludes Non-Commitment Costs (NCCs). 
    4. Under Scope, mark these checkboxes only:
      • In Scope
      • TBD
    5. Under Change Event Status, mark these boxes only:
      • Open
      • Closed
      • Pending
         Note
        • When filtering the columns data by change event status, any statuses not considered 'Void' are selected by default. 
        • If your company created custom statuses, those will NOT be shown by name. However,  any custom status considered 'Open', 'Closed', and 'Pending' are also selected by default. 
        • To learn more about custom statuses, see Set the Default Change Management Configurations.
    6. Under RFQ Status, remove all of the marks from these checkboxes. 
  4. Click Create.
 bv-column-cost-rfq.png

Add a Non-Commitment Cost Column

This adds a source column named 'Non-Commitment Cost' column. The value that appears in this column on a budget line item represents a Non-Commitment Cost. 

 Important

If you plan to use the 'Non-Commitment Cost' column in the calculation for the 'Projected Cost' column (or for a 'Forecast' column), it is important to choose one (1) of the following options to ensure the calculation is NOT double-counted when related direct costs impact your budget:

  • Optional: Update the 'Cost RFQ' column to exclude 'Closed' change event statuses. Then instruct users who create relevant direct costs to also change the appropriate change event's status to 'Closed.' This will exclude the Non-Commitment Cost from the column's value. 
    OR
  • Optional: When users create relevant direct costs, instruct your users to delete the 'Non-Commitment Cost' from the appropriate change event. 
    OR
  • Optional: Do NOT create direct costs for the 'Non-Commitment Costs' being tracked in your budget.
Steps from the Configure Columns window in the Company Admin tool… Settings
  1. Click Create Source Column.
  2. Under New Source Column, do the following:
    • Column Name. Enter the name: NCC
    • Column Source. Select Change Events. 
  3. Select the RFQ (Request for Quote) checkbox to apply these filters: 
    1. Under Prime PCO, remove all of the marks from these checkboxes. 
    2. Under Scope, mark these checkboxes only:
      • In Scope
      • TBD
    3. Under Change Event Status, mark these boxes only:
      • Open
      • Closed
      • Pending
         Note
        • When filtering the columns data by change event status, any statuses not considered 'Void' are selected by default. 
        • If your company created custom statuses, those will NOT be shown by name. However,  any custom status considered 'Open', 'Closed', and 'Pending' are also selected by default. 
        • To learn more about custom statuses, see Set the Default Change Management Configurations.
    4. Under Non-Commitment Costs, mark the Without Costs checkbox.  
  4. Click Create.
 bv-column-ncc.png

 

Update the Pending Cost Changes Column

The Procore Standard Budget View includes a 'Pending Cost Changes' source column. Use the steps below to update that column.  

Steps from the Configure Columns window in the Company Admin tool… Settings
  1. Under Source, highlight the 'Pending Cost Changes' column.
  2. Click Edit.
  3. Ensure the Column Source is set to Commitments.
  4. Under Subcontracts, mark the Draft checkbox and remove the marks from all other checkboxes.
  5. Under Purchase Order Contracts, mark the Draft checkbox and remove the marks from all other checkboxes.
  6. Under Change Orders, mark the Draft checkbox and remove the marks from all other checkboxes. 
  7. Click Update.
 bv-column-pending-cost-changes.png

Update Projected Costs Column

The Procore Standard Budget View includes a 'Projected Cost ' calculated column. Use the steps below to update that column.  

Steps from the Configure Columns window in the Company Admin tool… Settings
  1. Under Calculated, highlight the 'Projected Costs' column.
  2. Click Edit.
  3. Configure the calculation's drop-down lists as follows:
    • Select the 'Cost ROM' column. 
    • Select the plus (+) sign.
    • Select the 'Cost RFQ' column. 
    • Select the plus (+) sign.
    • Select the 'NCC' column.  
  4. Click Update.
 bv-column-projected-costs.png

 

Add a Revenue ROM Column

This adds a 'Revenue ROM' column to show Revenue ROM not yet associated with a 2- or 3-tier Prime Potential Change Order (PCO) or a 1-tier Prime Contract Change Order (PCCO).

Steps from the Configure Columns window in the Company Admin tool… Settings
  1. Click Create Source Column.
  2. Under New Source Column, do the following:
    • Column Name. Enter the name: Revenue ROM
    • Column Source. Select Change Events. 
  3. Mark the Revenue ROM (Rough Order of Magnitude) checkbox.
  4. Under Amount, select one (1) of these options:
    • Optional: Base Amount
      This option shows a Revenue ROM amount without the default financial markup applied from the Prime Contract.
    • Optional: Markup
      This option shows the default financial markup applied from the prime contract calculated from the Revenue ROM amount.
    • Recommended: Base Amount + Markup
      This option shows both the Revenue ROM amount and the default financial markup applied from the Prime Contract calculated from the Revenue ROM amount. This will match what the Change Event tool shows.
  5. Under Prime PCO, mark the Without Price checkbox.  
  6. Under Scope, mark these checkboxes:
    • In Scope
    • Out of Scope
    • TBD
  7. Under Change Event Status, mark these boxes only:
    • Open
    • Closed
    • Pending
       Note
      • When filtering the columns data by change event status, any statuses not considered 'Void' are selected by default.
      • If your company created custom statuses, those will NOT be shown by name. However, any custom status considered 'Open', 'Closed', and 'Pending' are also selected by default.
      • To learn more about custom statuses, see Set the Default Change Management Configurations.
  8. Click Create.
 bv-column-revenue-rom.png

Update the Pending Budget Changes Column

The Procore Standard Budget view includes a 'Pending Budget Changes' source column. Modify that column to show amounts for change orders in the 'Draft' status. 

Steps from the Configure Columns window in the Company Admin tool… Settings
  1. Under Source, highlight the 'Pending Budget Changes' column.
  2. Click Edit.
  3. Set the Column Source to Prime.
  4. Mark the Change Orders checkbox. 
  5. Under Status, mark the Draft checkbox only.  
  6. Click Update.
 bv-column-pending-budget-changes.png

Update the Projected Budget Column

The Procore Standard Budget View includes a 'Projected Budget' column. Use the steps below to modify that column. 

Steps from the Configure Columns window in the Company Admin tool… Settings
  1. Under Calculated, highlight the 'Projected Budget' column.
  2. Click Edit.
  3. Configure the calculation's drop-down lists as follows:
    • Select the 'Revenue ROM' column. 
    • Select the plus (+) sign.
    • Select the 'Pending Budget Changes' column. 
  4. Click Update.
 bv-column-projected-budget.png

See Also