Estimate at Completion (EAC) column - Project Work Plan

The Show Estimate at Completion is available when managing/creating/editing the details of a Project Work Plan View. When selected, the EAC column is displayed for Roles and Resources on the Project Work Plan when Group by Resource or Group by Project is selected.

The calculation for EAC is as follows:

• For Users: Actual Hours in the past + Forecast Hours in the Future
• For Roles: Forecast Hours in the Future

A matching algorithm is in place for the calculation of the Actual Hours. This algorithm matches the Timesheet hours and Forecast booking in the following order User > Task > Billable or Non-billable.

1. The Work Plan is checked for the same Task with the same attribute as those present in the Timesheet.
2. Upon finding a match the hours are added to the EAC of that Booking in the Work Plan.
   1. If there is one and only one hard booking match (booking row) with the same user/task/billable or non-billable attribute, Timesheet hour is allocated to this booking line.
   2. If there are multiple matching hard bookings, Timesheet hour is allocated to the first created booking that has allocations.
   3. If there are Hard Booking and Soft Booking, Timesheet hour is allocated the Hard Booking row.
   4. If there are no Hard Booking rows but one and only one Soft Booking row, and if Hard booked and soft booked is selected in the associated Financial Planner Template, the system matches the User/Task/Billable or Non-billable attribute and the Timesheet hours are allocated to the Soft Booking line.
   5. If there are multiple Soft Bookings, Timesheet hours are allocated to the first created booking that has allocations.
   6. If there is a booking but it is hidden based on some View settings, the related hours are added to the EAC at the Resource level.

This article details how to include the Estimate at Completion (EAC) column within the Project Work Plan.

1. From the Icon Bar click Project List .
2. From the Project List page, select the Project you wish to edit by following one of these steps:
   1. Click the Project context menu button to expand it. From the available options click Edit.
      OR
   2. Click the name of the Project you wish to access.

      Tip: Use the search capability for an efficient way of finding the specific project. For further details refer to Searching for a Project within the Project List page.

3. From the Project Edit page, hover your mouse over the Planners tab and select Work Plan from the available options.
4. Click the View box.
5. Select Manage from the available options.

   

6. From the available Scheduling View List page, click the View you wish to manage.

   

7. From the Scheduling View Edit page select the Show Estimate at Completion option.
8. Click Save to apply your changes.
9. Click Back to return to the previous page.
10. View your changes: Upon the Project Work Plan displaying, click the Group by Resource or Group by Project icon. Note that the Show Estimate at Completion column is displayed for Roles and Resources.

    

Example Calculation of EAC (User)

In our Example:

• The User has entered 40 hours in the past.

• The User is booked for a Grand Total of 90 Hours in the future for the same Task.

• The Forecast Start Date in Financial Planner Template associated to the Project is set to Start Date of Current Week.

EAC for Users is calculated as: Actual Hours in the past + the Forecast Hours in the future

Which is: 40(Actual Hours in the past)+90(Forecast Hours in the future)=130 hours