Background documentationEstimate to Complete (ETC)

 

ETC calculation is based on a query to forecast the estimated cost and quantity of completing a task. ETC is calculated by subtracting actual plan values (quantity and cost) from total plan values (quantity and cost). In other words, ETC is the remaining plan (quantity and cost).

The following key figures are calculated:

  • ETC Quantity

  • ETC Cost

  • EAC Quantity

  • EAC Cost

Prerequisites

  • You have the required roles and authorizations.

  • Financial plans linked with master project structures (also known as execution structures) are available in the system.

  • SAP BusinessObjects Analysis, edition for Microsoft Office is installed on your system.

  • You have made the following settings in Customizing under Start of the navigation path SAP Commercial Project Management Next navigation step Project Cost and Revenue Planning End of the navigation path:

    • Define Plan Scenarios

    • Define Resource Types

    • Define Resources

    • Define Plan Types

Features

Characteristics

Financial Plan Item

This column contains the individual nodes of the bid structure or master project structure that you have created. You can add more line items if you wish to plan at the work breakdown structure level.

Line Item Description

It is the short description that defines each node of the structure.

Resource Types

Resource types are a superset of the kind of resources used in a project. Three standard resource types are provided: material, activity, and human. You can define your own resource types.

Resources

Resources are subsets of resource types – each resource is associated with a resource type. For example, if the resource type is ‘material’, then the corresponding resources can be ‘brick’, ‘cement’, ‘marble’, ‘wood’, and so on.

You can define your own resources.

Key Figures

Overall Plan Cost

It is the plan cost of the entire project.

Plan Cost up to (Month)

It is the plan cost of the current forecast month plus all the preceding months.

Remaining Plan Cost

It is the plan cost of all the months that fall after the current forecast month.

Approved Plan Cost

It refers to the approved change request costs.

Pending Plan Cost

It refers to the change request costs that are not approved.

Actual Cost

It refers to the actual cost of the resources.

Plan Cost ETC

It is calculated by subtracting the plan cost from the actual cost.

Plan Cost EAC

The estimated costs at completion or EAC is the expected total cost for the project. It is the sum of the total ETC and the total actual cost. The EAC is copied to all months of the project, including the EAC summary.

Forecast Summary Report Graph

This graph shows the cumulated figures of plan cost, actual cost, and ETC.

Activities

Launching the ETC Workbook

  1. On the Financial Plan screen, select the relevant plan.

  2. Choose Edit.

  3. In the Versions section, select the relevant version.

  4. Choose Forecast.

    The Forecasting dialog box appears.

  5. Select the month you want to forecast for.

  6. Select the ETC forecast query.

    The ETC planning sheet is launched.

Recalculating ETC

  1. Enter a new figure in the Plan Cost ETC cell for any month.

  2. On the Analysis ribbon in the Financial Planning section, choose Recalculate.

    The ETC and EAC are updated.

    Note Note

    The EAC of the current month will not be updated.

    End of the note.

  3. On the Analysis ribbon in the Planning section, choose Save Data to transfer the data to the InfoCube.