Cost Sheet Fields

Project Cost Sheet

Financial

Project Current Actuals

Total costs accrued on a project within a given time period.

The Actual Cost data for the project's life cycle is pulled from the P6 EPPM schedule.

Actual Cost data is only available when the application is connected with P6 EPPM and is not editable.

Project Current Budget

The total cost of the project budget, including all transfers and changes. This value is based on the base currency with specified exchange rate.

Project Earned Cost

The cost value used for the project's Earned Value Management, which allows project managers to quantify project progress and objectively measure the project's success.

General

CBS Code Name

The name of the CBS code.

Project CPI

The measure of a project's cost efficiency.

A value of less than 1 indicates the project is over budget, while a value greater than 1 indicates the project is under budget.

Type

The category of the cost breakdown structure code.

Expense: Represents an expense.

Capital: Represents capital.

None: Type is not divided into expense or capital. None is selected by default if no other choice is made.

Hours

Project Actual Hours

The actual number of hours spent on the line item.

Project Earned Hours

Calculated as Performance Percent Complete multiplied by BAC Hours.

Project HPI

Calculated as the total of Project Earned Hours divided by Project Actual Hours.

Actuals

Financial

Confirmed Actuals

Actuals that have been confirmed.

Pending Actuals

The total of all actuals values with a status of Pending.

Commitments

Financial

Approved Commitment Changes

The total value of all approved commitment change orders.

Approved Commitment Potential Change Orders

The sum of all approved potential change orders for commitments.

Approved Commitments

The total cost of all approved commitments.

Approved Spends

Spends that have been submitted and approved by an authorized reviewer.

Estimated Commitment Changes

The sum of all estimates for commitments.

Pending Commitment Changes

The sum of all pending cost changes in the change records for the commitment.

Pending Commitment Potential Change Orders

The sum of all pending potential change orders for commitments.

Pending Commitments

The total cost of all pending commitments.

Pending Spends

Spends that have been submitted for review but not approved or rejected.

Project Current Commitments

The sum of the approved original commitments and the approved commitment changes.

Contracts

Financial

Approved Contract Changes

The total cost for all approved changes in contracts.

Approved Contract Potential Change Orders

The sum of all approved potential change orders for contracts.

Approved Contracts

The total cost for all approved contracts.

Approved Revenue

Revenue that has been submitted and approved by an authorized reviewer.

Estimated Contract Changes

The sum of all estimates for contracts.

Pending Contract Changes

The total cost for all pending changes in contracts.

Pending Contract Potential Change Orders

The sum of all pending potential change orders for contracts.

Pending Contracts

The total cost for all pending contracts.

Pending Revenue

Revenue that has been submitted for review but has not been approved or rejected.

Project Current Contracts

The total cost for all current project contracts.

Budget

Financial

Approved Budget Changes

Calculated as the sum of all approved manual budget changes in the change records for the project budget.

Approved Budget Transfers

Calculated as the sum of all approved manual budget transfers for the project.

Approved Current Budget

The total approved current manual budget of a project, calculated as the sum of Approved Original Manual Budget plus Approved Manual Budget Changes plus Approved Manual Budget Transfers.

Approved Original Budget

Calculated as the sum of all costs approved for the original manual budget.

Pending Budget Transfers

Calculated as the sum of all pending manual budget transfers for the project.

Pending Original Budget

Calculated as the sum of all costs pending for the original manual budget.

Risk

Financial

Actual Risk Response

The actual cost of responding to a risk.

Planned Risk Response

The estimated cost associated with implementing the response action.

Risk Closed Post-Response Exposure

The mean post-response probability of the risk multiplied by the mean post-response cost impact of the risk.

Risk Closed Pre-Response Exposure

The mean pre-response probability of the risk multiplied by the mean pre-response cost impact of the risk.

Risk Open Post-Response Exposure

The mean post-response probability of the risk multiplied by the mean post-response cost impact of the risk.

Risk Open Pre-Response Exposure

The mean pre-response probability of the risk multiplied by the mean pre-response cost impact of the risk.

Scope

Earned Value

Scope BAC Cost

The Revised Cost or At Completion Cost at the time the current baseline was set, depending on the selection for the Budget at Completion Method. The Revised Cost of the current project if no baseline is set.

Scope BAC Hours

The Revised Hours or At Completion Hours at the time the current baseline was set, depending on the selection for the Budget At Completion Method. The Revised Hours of the current project if no baseline is set.

This is the cumulative value for all objects in the project with the same CBS code.

Scope EAC Cost

Calculated as ETC Cost plus Actual Cost to Date.

Scope EAC Hours

Calculated as ETC Hours plus Actual Hours to Date.

This is the cumulative value for all objects in the project with the same CBS code.

Scope Earned Cost

Calculated as Performance Percent Complete multiplied by BAC Cost.

Scope Earned Hours

Calculated as Performance Percent Complete multiplied by BAC Hours.

This is the cumulative value for all objects in the project with the same CBS code.

Scope ETC Cost

The estimate of the cost needed to complete the work.

Calculated as BAC Cost minus Earned Cost.

Scope ETC Hours

The estimated number of hours needed to complete the work.

Calculated as BAC Hours minus Earned Hours.

Financial

Scope Actual Cost to Date

The actual costs incurred on the scope assignment. This tracks the VOWD (Value of Work Done).

Scope Adjusted Cost

The amount the scope assignment work that is not yet accounted for. For example, you might enter a value to represent pending change requests that are likely to be approved.

Scope Approved Change Cost

The sum of all approved cost changes in the change records for the scope assignment.

Scope At Completion Cost

The total cost at the completion of the scope assignment.

Calculated as Revised Cost plus Adjusted Cost.

Scope Baseline Cost

The Revised Cost at the time the current baseline was set.

Scope Installed Cost

The total cost incurred on the scope assignment as of the current date.

If Rate By is set to Hours, then Installed Cost equals Revised Cost Rate multiplied by Installed Hours.

If Rate By is set to Quantity, then Installed Cost equals Revised Cost Rate multiplied by Installed Quantity.

Scope Original Cost

The original cost of the scope assignment.

If Rate By is set to Hours, then Original Cost equals Original Hours multiplied by Original Cost Rate. If this value is entered manually, then Original Cost Rate is recalculated to equal Original Cost divided by Original Hours.

If Rate By is set to Quantity, then Original Cost equals Original Quantity multiplied by Original Cost Rate. If this value is entered manually, then Original Cost Rate is recalculated to equal Original Cost divided by Original Quantity.

Scope Pending Change Cost

Calculated as the sum of all pending cost changes in the change records for the scope assignment.

Scope Remaining Cost

The amount left to be spent.

If Rate By set to Hours, then Remaining Cost equals Remaining Hours multiplied by Revised Cost Rate.

If Rate By set to Quantity, then Remaining Cost equals Remaining Quantity multiplied by Revised Cost Rate.

Scope Revised Cost

The Original Cost before the baseline is set. After the baseline is set, Revised Cost equals Original Cost plus Approved Change Cost.

Hours

Scope Actual Hours to Date

The actual hours spent on the scope assignment. This tracks the VOWD (Value of Work Done).

This is the cumulative value for all objects in the project with the same CBS code.

Scope Adjusted Hours

The amount of scope assignment work that is not yet accounted for. For example, you might enter a value to represent pending change requests that are likely to be approved.

This is the cumulative value for all objects in the project with the same CBS code.

Scope Approved Change Hours

The sum of all approved change hours in the change and transfer records for the scope assignment.

This is the cumulative value for all objects in the project with the same CBS code.

Scope At Completion Hours

The total hours expected for the scope assignment.

Calculated as Revised Hours plus Adjusted Hours.

This is the cumulative value for all objects in the project with the same CBS code.

Scope Baseline Hours

The Revised Hours at the time the baseline was set.

This is the cumulative value for all objects in the project with the same CBS code.

Scope Installed Hours

Hours spent on the scope assignment.

Calculated as Installed Quantity multiplied by Revised Productivity Rate.

This is the cumulative value for all objects in the project with the same CBS code.

Scope Original Hours

The original expected hours needed to complete all the work required to install the material quantity on the scope assignment.

Calculated as Original Quantity multiplied by Original Productivity Rate.

Before the baseline is set, this field can be entered manually. A manual entry recalculates the Original Productivity Rate to equal Original Hours divided by Original Quantity.

This is the cumulative value for all objects in the project with the same CBS code.

Scope Pending Change Hours

Calculated as the sum of all pending hour changes in the change records for the scope assignment.

This is the cumulative value for all objects in the project with the same CBS code.

Scope Remaining Hours

The number of hours left for the scope assignment.

Calculated as Remaining Quantity multiplied by Revised Productivity Rate.

This is the cumulative value for all objects in the project with the same CBS code.

Scope Revised Hours

Original Hours before the baseline is set. After the baseline is set, Revised Hours is equal to Original Hours plus Approved Change Hours.

This is the cumulative value for all objects in the project with the same CBS code.