Cost Reporting
To facilitate the reporting of cost information, Open Plan provides a number of standard calculated fields related to costs at the activity level.
These fields are available for display in any view.
| Field | Description | Calculation |
|---|---|---|
| BACcum | Budget at complete. This value represents the total budgeted cost of the activity or project and is calculated from the costs of the Project Measurement Baseline (PMB).
If the PMB does not exist, Open Plan uses the currently selected baseline, or, in the case of multiple baselines, the first selected baseline. |
BAC_LAB + BAC_MAT +
BAC_ODC + BAC_SUB |
| ACWPcum | Actual cost of work performed.
This value represents the actual cost of the work performed on the activity or project from its inception to Time Now. Open Plan has two methods for acquiring actual quantity:
The method used depends on settings made on the General tab of the Resource Details dialog box. |
ACWP_LAB + ACWP_MAT +
ACWP_ODC + ACWP_SUB |
| Planned Baseline Progress | For activities with a duration greater than zero:
For activities with zero duration, Open Plan compares the baseline finish date with Time Now, and takes one of the following actions:
When subtracting the baseline start from Time Now, Open Plan takes into account the effect of calendars. |
|
| BCWScum | Budgeted cost of work scheduled.
BCWScum is a field on the activity table that represents the cumulative to-date budgeted cost of work scheduled for the activity and is populated during cost calculations by determining the value of the baseline resource assignments that should have been accomplished by Time Now. A baseline must be selected in order for Open Plan to calculate the Activity BCWS. |
BCWS_LAB + BCWS_MAT +
BCWS_ODC + BCWS_SUB |
| BCWPcum | Budgeted cost of work performed.
This value represents the sum of the budgets for the completed work PMB. The cumulative budgeted cost of work performed (BCWP) is frequently referred to as earned value (EV). |
BCWP_LAB + BCWP_MAT +
BCWP_ODC + BCWP_SUB |
| ETC | Estimate to complete.
This calculated field shows the total ETC for an activity by combining the ETC for each resource category. |
ETC_LAB + ETC_MAT +
ETC_ODC + ETC_SUB |
| EAC | Estimate at complete.
This value represents the final costs of the activity or project when completed and is calculated from the current resource assignments. |
ACWPcum + ETC |
| CV | Cost variance.
This value represents the numerical difference between the earned value (BCWP) and the actual cost (ACWP). |
BCWPcum – ACWPcum |
| SV | Schedule variance.
This value is used as an indicator of how much a program is ahead or behind schedule |
BCWPcum – BCWScum |
| VAC | Variance at complete.
This value represents the algebraic difference between Budget at Complete and Estimate at Complete |
BACcum – EAC |
| CPI | Cost performance index.
This value represents the cost efficiency factor representing the relationship between the actual costs expended and the value of the physical work performed. |
BCWPcum / ACWPcum |
| SPI | Schedule performance index.
This value is the planned schedule efficiency factor representing the relationship between the value of the initial planned schedule and the value of the physical work performed, earned value. |
BCWPcum / BCWScum |
In addition to these values, Open Plan calculates the planned baseline progress for each activity using the following approach:
- If no baseline dates have been set for the activity, Open Plan sets the value of planned baseline progress to –1.
- If the baseline finish date is before Time Now, Open Plan sets the value of planned baseline progress to 100%.
- If the baseline start date is after Time Now, Open Plan sets the value of planned baseline progress to zero.
If none of these cases apply, Open Plan calculates the value by first subtracting the baseline start from Time Now, dividing the result by the original duration, and then multiplying by 100. For activities with an original duration of zero, Open Plan divides the result by the difference between the baseline start and finish dates.