Search only in titles

---

Activity Sheet

The values for the following cost-related units are calculated according to the assignments, as follows:

Planned Cost & Remaining Cost

Planned Cost and Remaining Cost for the assigned resource will be calculated based on the number of the units * the rate per unit.

Planned Cost is calculated as Planned units * price/unit.

If the rate source is an override, the system uses the rate present in the activity sheet that corresponds to that assignment.

The resource rate is derived from the rate based on the effective date between the start and the finish dates.

The exchange rates for that day are applied if the resource/role does not have the same currency as the project.

Remaining Cost

Remaining Cost for the assigned resource will be calculated based on the number of remaining units * price per unit.

If the rate source is an override, the system uses the price/unit for the calculating remaining cost.

Actual Cost

The system calculates the Actual Cost based on the number of actual units * rate per unit.

The rate is based on the Actual Start Date onwards.

The unit rate is based on the effective date which falls on the actual start date.

At Completion Cost

At Completion Cost value is equal to: Actual Cost + Remaining Cost.

All the calculated costs (Planned Cost, Actual Cost, Remaining Cost, and At Completion Cost) will be rolled up to the activity sheet and to the:

• Planned Total Cost
• Actual Total Cost
• Remaining Total Cost
• At Completion Total Cost

The following units will be rolled up from Assignments tab:

• Planned Total Units
• Actual Total Units
• Remaining Total Units
• At Completion Total Units

Activity % Complete

The system calculates this field as a simple and intuitive formula for Units % Complete of Activities, with labor or non-labor assignments:

Activity % Complete = [Actual Units] / ([Actual Units] + [Remaining Units] )

Earned Value Calculations at the Activity level:

• Planned Value (uuu_P6PVCost)

  This is the planned total cost of the activity that is complete as of the data date.

• Earned Value (uuu_P6EVCost)

  The cost of all activities in the project that are actually completed as of the data date.

  The Budget At Completion is calculated from the project baseline and is calculated as: Budget At Completion multiplied by Performance % Complete.

• Estimate to Complete (uuu_P6ETC)

  The estimated cost to complete the activity, WBS, or project.

  It is calculated as Remaining Total Cost for the activity or the Performance Factor multiplied by (Budget At Completion minus Earned Value), depending on the Earned Value technique selected for the activity's WBS.

  The Budget at Completion is calculated from the project baseline. The ETC technique will be fetched from the WBS sheet for the respective activity.

• Schedule Performance Index (uuu_P6SPIndex)

  A measure of the work accomplished as a percentage of the work scheduled.

  The Schedule Performance Index indicates whether you are meeting earned and planned values within your schedule. A value less than 1 indicates that less work was performed than was scheduled.

  It is calculated as Earned Value divided by Planned Value.

• Cost Performance Index (uuu_P6CPIndex)

  A measure of the value of work accomplished as a percentage of the actual costs.

  The Cost Performance Index (CPI) indicates whether you have spent money over the budget to date.

  It is calculated as Earned Value Cost divided by Actual Cost. A value less than 1 indicates that the actual cost has exceeded the planned value.

• Cost Schedule Index (uuu_P6CSIndex)

  It is a product of Schedule Performance Index & Cost Schedule Index.

• Schedule Variance (uuu_P6ScheduleVariance)

  The measure of Schedule Performance Index on a project. A negative value indicates that less work was actually performed than was scheduled.

  It is calculated as Earned Value minus Planned Value.

• Cost Variance (uuu_P6CostVariance)

  A measure of Cost Schedule Index on an activity, WBS, or project. A negative value indicates that the actual cost has exceeded the planned value.

  It is calculated as Earned Value minus Actual Cost.

• To Complete Performance Index (uuu_P6TCPIndex)

  The ratio of the remaining work to the remaining funds.

  It is calculated as (Budget at Completion minus Earned Value) divided by (Estimate at Completion minus Actual Units or Cost).

• Estimate at Completions (uuu_P6EACCost)

  The expected total cost of a schedule activity, a work breakdown structure (WBS) component, or the project when the defined scope of work will be completed.

  It is calculated as Actual Cost plus Estimate to Complete Cost. The method for calculating estimate to complete depends on the earned value technique selected for the activity's WBS.

• Budget at Completion (uuu_P6BAC)

  The planned total cost through activity or project completion.

  It is calculated as Planned Labor Cost plus Planned Non-labor Cost plus Planned Expense Cost plus Planned Material Cost.

• Variance at Completion (uuu_P6VAC)

  The difference between the baseline total cost and the current estimate of total cost. A negative value indicates an estimated cost overrun.

  The Budget At Completion is calculated from the current baseline.

  It is calculated as Budget At Completion minus Estimate At Completion.

All the earned value calculations will be performed at activity level.

• Assign a CBS Code at Assignment level:

  You can assign the CBS Code at the resource level similar to the CBS Code assignment at the activity level. CBS code is a picker column which shows active CBS Codes defined in the project cost sheet.

  All the costs and units will be rolled up to the cost sheet and cash flow based on the CBS assignment.

  Note: All the calculations will be performed during recosting.

---

Last Published Wednesday, July 2, 2025