You are here

Cost Worksheet Calculations

The Cost Columns table lists all the columns available, the calculations they use and any related information about how and why they are used.

Cost Columns table

Column

Calculation

Notes

Accrued Period

Sum of Accrued amounts from all Direct Actuals for the current reporting period

"See Project Settings > Direct Actuals to set how you want Accrued amounts to be defined/calculated: Option 1: Manually defined (or imported) Option 2: (Estimate at Completion x Current Percent Complete) - Direct Actuals to Date Option 3: Incurred - Actual"

Accrued to Date

Sum of Accrued amounts from all Direct Actuals for all previous reporting periods plus the current reporting period

See above.

All Actuals to Date

Direct Actuals to Date + Pending Contract Actuals + Approved Contract Actuals

"Pending Contract Actuals are Payment Applications with a “Submitted” status Approved Contract Actuals are Payment Applications with an “Approved” status "

All Commitments

Current Commitments + Pending Contract Commitments

Approved Budget

Baseline Budget + Approved Budget Changes + Approved Budget Transfers

"Approved Budget Changes come from Budget Changes and/or Change Events Approved Budget Transfers come from Change Events"

Approved Budget Changes

"If Budget Changes is enabled for the Approved Budget, then Approved Budget Changes equals (Budget Change Items with a Budget Change amount when the status assigned to the parent Budget Change has been defined as “Apply"") + (Change Event Items with a Budget Change amount and a status of “Approved"") If Budget Changes is not enabled for the Approved Budget, then Approved Budget Changes equals Approved Budget - Baseline Budget"

Budget Changes for the Approved Budget is enabled in Project Settings > Budget Changes

Approved Budget Transfers

Sum of Budget Transfer amounts from all Change Event Items with a status of “Approved”

Approved Budget Transfers

Sum of Budget Transfer amounts from all Change Event Items with a status of “Approved”

Approved Contract

Sum of the Approved Contract amounts from Contract Pay Items

Approved Contract Actuals

Sum of Accepted Amounts from Payment Application Items when the status of the parent Payment Application is “Approved”

Approved Contract Changes

Sum of Change Amounts from Contract Change Pay Items when the status of the parent Contract Change is “Approved”

At Completion Variance

Approved Budget - Estimate at Completion

Baseline Budget

Manually defined or imported

Control Budget

Manually defined or imported + Control Budget Changes

Control Budget Changes

"If Budget Changes is enabled for the Control Budget, then Control Budget Changes it is the sum of Budget Change Items with a Control Budget Change amount when the status assigned to the parent Budget Change has been defined as “Apply” If Budget Changes is not enabled for the Control Budget and the Link Control Budget to Baseline Budget setting is true, then Control Budget Changes equals Control Budget - Baseline Budget"

"See Project Settings > Budget for the Link Control Budget to the Baseline Budget setting See Project Settings > Budget Changes to enable Budget Changes"

Current Commitments

Current Contracts + Direct Actuals to Date

Current Contracts

Approved Contract + Approved Contract Changes

Current Percent Complete

Depends on the Percent Complete Method defined for the Control Account (see below). Calculated at the Control Account level and rolled up.

Rollup of Current Percent Complete is the weighted average of the subordinates based on each Control Accounts’ approved budget contribution to the superior.

Percent Complete Methods

CAE: Actual to Date Cost

All Actuals to Date / Estimate at Completion

CCB: Control Budget Cost

Control Budget to Date / Total Control Budget

Requires time phasing of data

CEB: Early Approved Budget Cost

Early Approved Budget to Date / Total Approved Budget

Early Approved Budget to Date requires time phasing of data

CLB: Late Approved Budget Cost

Late Approved Budget to Date / Total Late Approved Budget

Late Approved Budget to Date requires time phasing of data

CLS: Closed

100% Complete and Closed

Days Requested and Days Accepted

When making contract changes, thes fields show how many days the changes will affect the original schedule. You add these at item level can see them in the contracts details. Depending on the Contract Change status, they can be edited but they are not required fields.

FIN: Finished

100% Complete

HAE: Actual to Date Hours

All Actuals to Date / Estimate at Completion

HCB: Control Budget Hours

Control Budget to Date / Total Control Budget

Control Budget to Date requires time phasing of data

HEB: Early Approved Budget Hours

Early Approved Budget to Date / Total Approved Budget

Early Approved Budget to Date requires time phasing of data

HLB: Late Approved Budget Hours

Late Approved Budget to Date / Total Late Approved Budget

Late Approved Budget to Date requires time phasing of data

MAN: Manual

Manual Entry

QAE: Actual to Date Quantity

All Actuals to Date / Estimate at Completion

If there are multiple quantity Control Elements assigned to the Control Account, then you will define a contribution weight for each element.

QCB: Control Budget Quantity

Control Budget to Date / Total Control Budget

"If there are multiple quantity Control Elements assigned to the Control Account, then you will define a contribution weight for each element. Requires time phasing of data."

QEB: Early Approved Budget Quantity

Approved Budget to Date / Total Approved Budget

"If there are multiple quantity Control Elements assigned to the Control Account, then you will define a contribution weight for each element.. Requires time phasing of data."

QLB: Late Approved Budget Quantity

Late Approved Budget to Date / Total Late Approved Budget

If there are multiple quantity Control Elements assigned to the Control Account, then you will define a contribution weight for each element.

ROC: Rules of Credit

Composite Rules of Credit Percent Complete

Percent complete is documented for each rule assigned to the Control Account. If there are multiple rules assigned to the Control Account, then you will define a contribution weight for each rule.

SCH: Schedule Activities

Composite Schedule Activities Percent Complete

Percent complete is documented for each Schedule Activity assigned to the Control Account. If there are multiple Schedule Activities assigned to the Control Account, then you will define a contribution weight for each activity.

TCF: Schedule Finish

100% at Current Schedule Finish

Requires schedule dates to be defined for the Control Account(s)

TCS: Schedule Start

100% at Current Schedule Start

Requires schedule dates to be defined for the Control Account(s)

Direct Actual Period

Sum of Actual amounts from Direct Actuals for the current reporting period

Direct Actual to Date

Sum of Actual amounts from Direct Actuals for all previous reporting periods and the current reporting period

EAC Variance

Previous EAC - Estimate at Completion

Earned Period

Approved Budget for the current reporting period x Period Percent Complete

Approved Budget for the current reporting period requires the time phasing of data

Earned to Date

Approved Budget to date x Current Percent Complete

Approved Budget to date requires the time phasing of data

Estimate to Complete (ETC) and Estimate at Completion (EAC)

"Control Account ETC = Sum of Estimate to Complete (ETC) amounts from the assigned Control Elements Control Account EAC = Sum of Estimate at Completion (EAC) amounts from the assigned Control Elements NOTE: The calculation of Estimate to Complete (ETC) and Estimate at Completion (EAC) at the Control Element level depends on the Forecast Method selected (see below)"

Options may vary depending on the selected default Percent Complete Method (Project Settings > Percent Complete)

Forecast Methods

ETC 1

ETC = User controlled value + (automated system adjustments)

EAC = All Commitments + ETC. System sets up the ETC and EAC from the Baseline Budget. System adjusts the ETC as commitments are processed until there is no ETC remaining. The EAC is then set to the value of the commitments

ETC 2

"ETC = Efficiency Factor x (Approved Budget - Earned Value) Efficiency Factor = 1 Efficiency Factor = 1 / CPI Efficiency Factor = 1 / (CPI x SPI) Efficiency Factor = [User Defined Value]"

EAC = All Commitments + ETC. This method forecasts ETC based on manually provided efficiency ratios. It's like applying your own CPI. This is primarily used for Earned Value forecasting.

ETC 3

ETC = Approved Budget - All Commitments

EAC = All Commitments + ETC. This method essentially sets the EAC to the Approved Budget, calculating a negative ETC when commitments exceed budget. Use the negative ETC to determine what budget changes are required to balance budget and costs.

ETC 4

ETC = Manually entered value

EAC = All Commitments + ETC. Set the ETC to whatever value you need. The EAC will fluctuate based on changes to commitments.

EAC 1

EAC = User controlled value + (automated system adjustments)

ETC = EAC - All Commitments. System sets up the ETC and EAC from the Baseline Budget. System holds the EAC as commitments are processed until there is no ETC remaining. The EAC is then set to the value of the commitments.

EAC 2

EAC = Approved Budget / CPI

ETC = EAC - All Commitments. An Earned Value forecast method, using the CPI to scale up or down the forecast for the entire scope of work.

EAC 3

EAC = All Actuals + (Approved Budget - Earned to Date)

ETC = EAC - All Commitments. Basic Earned Value forecast for use when CPI/ SPI are not available.

EAC 4

EAC = All Actuals + (Approved Budget - Earned to Date) / (CPI x SPI)

ETC = EAC - All Commitments. Sophisticated Earned Value forecast method, applying the CPI and SPI to the remaining work to earn.

EAC 5

EAC = Manually entered value

ETC = EAC - All Commitments. User can simply set the EAC to whatever value required. This may result in credit forecasts, aka negative ETC. Consider using the first EAC forecast method instead.

Incurred Period

Sum of Incurred amounts, from Direct Actuals, for the current reporting period

"See Project Settings > Direct Actuals to define how Incurred amounts are calculated Option 1: Manually defined (or imported) Option 2: Actual amount + Accrued amount"

Incurred to Date

Sum of Incurred amounts, from Direct Actuals, for all previous reporting periods and the current reporting period

See above.

Pending Contract

Sum of Original Contract amounts from Contract Pay Items when the parent Contract has a “Pending” status

Pending Contract Actuals

Sum of Requested Amounts from Payment Application Items when the parent Payment Application has a “Submitted” status

Pending Contract Changes

(Sum of Change Amounts from Contract Change Pay Items when the Cost Impact of the Contract Change is “Pending”) + (Sum of Change Event Item amounts when the Change Event Items have a Contract Impact and a status of “Pending” and have not yet been linked to a Contract Change)

Pending Contract Commitments

Proceed Contract + Proceed Contract Changes + Pending Contract + Pending Contract Changes

Percent Invoiced

(Pending Contract Actuals + Approved Contract Actuals) / Current Contract Amount

Percent Spent

All Actuals to Date / Estimate at Completion

Potential Budget

Approved Budget + Potential Budget Changes + Potential Budget Transfers

Potential Budget Changes

(Budget Change Items when the status assigned to the parent Budget Change has been defined as “Apply to Potential") + (Change Event Items with a Budget Change amount and a status of “Potential”)

"The rules for Budget Changes statuses are defined in Project Settings > Budget Changes. The rules for each status include the following options: Apply - Adds the change amount to “approved” changes Apply to Potential - Adds the change amount to “potential” changes None - The change amount is not included"

Potential Control Budget

Control Budget + Potential Control Budget Changes

Potential Control Budget Changes

Sum of all Budget Change Items with a Control Budget Change amount when the status of the Budget Change is one where it is set to "Apply to Potential"

Potential EAC

Estimate at Completion + Potential ETC Changes + Potential Contract Changes

Previous Percent Complete

Current Percent Complete value from the previous reporting period

When a reporting period is closed, the Current Percent Complete value is copied to the Previous Percent Complete field

Proceed Contract

Sum of Original Contract amounts from Contract Pay Items when the parent Contract has a “Proceed” status

Proceed Contract Changes

Sum of Change Amounts from Contract Change Pay Items when the status of the Contract Change is “Pending”

Potential ETC Changes

(Sum of all Budget Change Items with an ETC Change amount when the status of the parent Budget Change is one where it is set to "Apply to Potential”) + (Sum of all Change Event Items with an ETC Change amount when the status is “Potential")

"The rules for Budget Changes statuses are defined in Project Settings > Budget Changes. The rules for each status include the following options: Apply - Adds the change amount to “approved” changes Apply to Potential - Adds the change amount to “potential” changes None - The change amount is not included"

Previous EAC

Estimate at Completion (EAC) amount from the previous reporting period

Remaining to Spend

Estimate at Completion (EAC) – All Actuals to Date

Was this article helpful?

Thanks. A ticket has been opened with the Support Central team.