Estimated Actuals

Estimated actuals lets you track costs, quantities, man-hours, and equipment hours on a cost item before these values are validated through the ERP system. This provides more up-to-date visibility on progress and increases forecast accuracy. Estimated actuals can be generated in Control through quantity claims, or brought in from approved daily plans in Progress. After actuals are validated in the ERP system, you can reverse the estimated actuals and maintain the confirmed actuals.

To view estimated actuals in Control, you must first enable the feature in Control’s project settings. To enable, go to the Project Tracking tab in settings, and under Estimated actuals, switch the Turn on estimated actuals toggle to ON, and then select the applicable cost categories under Control and Progress.

When you enable estimated actuals, you can add relevant columns to a data block to view estimated actuals.

The following table shows columns related to estimated actuals.

Column

Description

Confirmed actual cost

The expended cost verified through the ERP system.

Confirmed actual equipment

The expended equipment cost verified through the ERP system.

Confirmed actual man hours

The number of labor hours verified through the ERP system.

Confirmed actual qty

The cost item quantity verified through the ERP system.

Estimated actual cost

Recorded actual cost that has not yet been confirmed through the ERP system.
Estimated actual equipment Recorded equipment cost that has not yet been confirmed through the ERP system.
Estimated actual man hours Recorded labor hours that have not yet been confirmed through the ERP system.
Estimated actual qty Recorded cost item quantity that has not yet been confirmed through the ERP system.
Last estimated actual cost reversal The date and time the last Reverse estimated actuals > Reverse estimated actual cost action was performed.
Last estimated actual man hours reversal The date and time the last Reverse estimated actuals > Reverse estimated actual man-hours and labor cost action was performed.
Last estimated actual eqp hours reversal The date and time the last Reverse estimated actuals > Reverse estimated actual equipment hours and construction cost action was performed.

Claim Estimated Actuals in Control

Claim Estimated Actuals

  1. From the CBS, right-click a cost item, and then select Actuals details.

  2. From the Quantities tab, enter a claimed quantity.

  3. When you select Estimated actuals to be added on claiming, cost category values automatically populate based on the claimed quantity entered using Current Estimate unit rates.

  4. Click Apply when you are done.

The estimated values for the cost item can now be viewed in the relevant columns.

Estimated Actuals from Progress

With the correct settings enabled, estimated actuals can be brought in from Progress based on approved daily plans.

Note in the example below, prior to the creation of a new daily plan, the estimated actuals for this cost item have a value of 0.

In Progress, labor hours and equipment hours are tracked on the Time Sheet tab of a daily plan.

Quantities are tracked on the Quantities tab of a daily plan.

After the daily plan is submitted and approved in Progress, the estimated actuals values automatically update in Control.

Estimated actuals values are only general estimates. They are not confirmed until synced with an ERP or an external payroll system.

Reverse Estimated Actuals

After actuals are reviewed and confirmed in your ERP system, they are brought into Control through a sync. These values are then reflected as “confirmed” actuals. Following this process, you can reverse the estimated actuals, since the confirmed actuals now reflect the most up-to-date information.

If you keep the estimated values without reversing after syncing with the ERP system, those values are detected as double values.

Reverse Estimated ACtuals

  1. From the CBS, select the cost items which have recorded estimated actuals.

  2. From the Actions menu, select Reverse estimated actuals, and then select the appropriate type of reversal.

  3. Click Yes to confirm the reversal.

  4. In the CBS, the estimated values are reset to 0.