Using the Same Rate for BCWS and BCWP

, , , , , ,
Using the Same Rate for Budgeted Cost for Work Scheduled (BCWS) and Budgeted Cost for Work Performed (BCWP)
There is often an EVMS project managers debate regarding which rates to use for common budget costing EVMS data elements. For Actual Cost of Work Performed (ACWP), it is fairly obvious as the most recently approved actual rates are applied. A planning rate is generally used for BCWS and BCWP, but many in the EVM project management industry use incorrect rate application for the BCWP calculation. In some cases EVM contractors use a weighted average rate; the percent complete in hours multiplied by the dollarized BAC to derive the BCWP in dollars. This method is noncompliant with the EIA-748 Guideline 22 which states that if work is planned on a measured basis, then the BCWP must be calculated on a measured basis using the same rates and values. In other words, the rate and methods used to calculate BCWS and BCWP must be the same. As shown in Example #1, it can be seen that work planned in hours (BCWS) was performed as scheduled (BCWP) each month. Each hour was planned at a rate of $100/hour until the end of the calendar year when the rate increased to $105/hour. In this example, the rates used to calculate BCWS and BCWP are the same.
EVMS: BCWS & BCWP rate calculation example table #1
EVMS: BCWS & BCWP rate calculation example table #1

Example #2 below illustrates a very common scenario. In this example work that was planned in November and December was not completed until the next year. In January, the rate increased from $100 to $105. What should the BCWP in dollars be for both January and February?

EVMS: BCWS & BCWP rate calculation example table #2
EVMS: BCWS & BCWP rate calculation example table #2

For both January and February, the original 10 hours planned was earned at $105/hour equaling $1,050. The work that was planned in November and December, but completed late in January and February, was earned at its planned rate of $100/hour resulting in $1,000 of BCWP.  The sum ($1,050 + $1,000) equals the BCWP of $2,050 in each month. See the Example #3 graphic below:

EVMS: BCWS & BCWP rate calculation example table #3
EVMS: BCWS & BCWP rate calculation example table #3

Even though the rate was escalated in the new year, the BCWP that should have been earned in the prior year is calculated using the rate that was originally planned. The same approach would be logical if the work planned at $105 per hour were performed ahead of schedule in let us say, December of the prior year. It would be earned at $105 per hour even though it was performed in a time frame where the planning rate is $100 per hour. In some instances, business systems are programmed to earn as a percent of the entire Budget at Completion (BAC). This could result in an inaccurate BCWP dollar value. As an example, let us assume 10 hours are earned in September. If those 10 hours were 1/8 of the total BAC, then the BCWP dollars associated with this 10 hours would be $102.50 per hour and the contractor would be earning too much for those 10 hours. They must earn at the planned $100 per hour! Thus the rate used for BCWP is the same as for BCWS and is compliant with Guideline 22; one earns in the same manner as they plan to earn.

In summary, EVM concepts require that in order for the work to be complete, cumulative values of BCWS and BCWP must equal the BAC.  So, from a common-sense standpoint, if BCWP is earned at a different rate than that used for planning the BCWS, the Control Account (or even the Contract) cannot be closed properly.  Examples:

  • If BCWP earns at a lower rate, the BCWP would be, say, 98% of the BAC when the actual work is done.
  • Likewise, if BCWP earns at a higher rate, the BCWP would be, say, 105% of the BAC when the actual work is concluded.

Both of these scenarios violate the EVM concepts.

Using the Same Rate for BCWS and BCWP Read Post »

Control Account Manager’s Log – A Valuable Tool

It is not always easy on a rapidly changing project for a Control Account Manager (CAM) to keep track of where the Control Account is with regard to the current scope, schedule, and budget status and the history behind revisions, both directed and requested, approved or disapproved, and incorporated or pending actions.

The Control Account Manager’s Log is a valuable tool the CAM could use to keep track of all of the transactions affecting control account scope, schedule and budgets. This tool is most helpful to the CAM when there have been multiple Baseline Change Requests (BCR) submitted that are not necessarily approved in the order submitted (if approved at all) or are not approved as submitted; i.e., Program Manager approval varies from the CAM’s submittal. Using this type of Log, the CAM can track change requests as they are approved, rejected or altered. The CAM can update the Log with the change in scope, schedule, and budget for every change. The CAM can also compare what was submitted to what was actually approved and ensure that the scope, schedule, and budget amounts on updated Control Account Work Authorizations are correct for each transaction, or at least understand any reasons for the differences.

An example CAM Log is shown below. Obviously, the example can, and should, be tailored to fit the organization’s requirements. For example, the budget shown below is a total; one may want to show budget elements in terms of labor, materials, or other direct costs. If the organization issues budgets through overhead costs to the CAMs, then a logical breakout would be to show those as well as the direct budget elements.

Control Account Manager (CAM) log

For example, as you can see in the second transaction adding WBS 6.6.3.5, the entire amount was approved, increasing the total budget to $2,086,570. For BCR 171, however, the CAM submitted a request for $11,310 in September; in October the Project Manager’s decision was to approve only $11,200 from Management Reserve (MR), raising the total budget to $2,097,770. Meanwhile, BCR 194 was submitted requesting $121,320, but that BCR has not yet been approved, and since then three other transactions have taken place (AUW 101, BCR 162 approved, and BCR 182 was submitted but not yet resolved).

As you can see, without a CAM level log, it could easily become very difficult for a CAM to keep track of the control account’s budget.

Feel free to call or email us if you have any questions regarding this article. Your comments are always welcome.

Control Account Manager’s Log – A Valuable Tool Read Post »

Ensuring CPI to TCPI Comparisons are Valid at the Total Contract Level

TCPI and CPI ComparsionHave you been in a meeting when presenters show differing To-Complete Performance Index (TCPI) values at the total contract level for the same contract? In these situations, the presenters have made different assumptions about the inclusion of Undistributed Budget and Management Reserve (MR) in the TCPI calculations. So let’s use some sample values and show different ways the TCPI can be calculated at the total contract level.

As a reminder, this is the formula for TCPI:

TCPI

Consider the following extract from the lower right portion of Format 1 of the Integrated Program Management Report (IPMR) (Contract Performance Report (CPR)).

To-Complete Performance Index (TCPI)

When comparing the TCPI to the CPI at the total contract level, the most realistic approach is to calculate the TCPI at the level of the Distributed Budgets. Stated differently, the TCPI should be calculated without Undistributed Budget and Management Reserve. The Cost Performance Index (CPI), BCWP divided by ACWP, represents the cost efficiency for the work performed to date. Notice in the above table that the BCWP and ACWP values in the rows for “Distributed Budgets by WBS”, “Subtotal”, and “Total” are the same; therefore, the CPI calculation will be the same for any of these data levels. The TCPI represents the cost efficiency necessary to achieve the reported EAC. The “Distributed Budgets by WBS” contain approved budgets as well as performance data against those budgets. The CPI and TCPI compared at this level of data certainly provide a valid comparison of past performance to projected performance. The CPI for the above data is 0.73 while the TCPI is .92.

Since the difference between the CPI and TCPI is greater than 0.10, the control account managers (CAMs) and the analysts should research the reasons that the future performance indicates improvement and provide EAC rationale.

Calculating the TCPI at the Performance Measurement Baseline level (i.e. including Undistributed Budget in the BAC and EAC) yields a different TCPI than at the Distributed Budget level. Mathemati-cally, the TCPI will be the same for the Distributed Budgets and PMB only if the value of the Estimate to Complete (EAC – ACWP) equals the budgeted value of the remaining work (BAC – BCWP). In that case, the TCPI will be 1.0. If the contract has an unfavorable cost variance and projects an overrun on future work, the TCPI at the PMB level (includes UB) will be higher than the TCPI calculated at the Distributed Budget level (does not include UB).

For the data in the above table, the Distributed Budget TCPI = 0.92 but increases to 0.94 if Undistributed Budget is included in the calculation. The Undistributed Budget, with the same value added to both BAC and EAC, represents a portion of the Estimate to Complete (ETC) that will be performed at an efficiency of 1.0. In an overrun situation at the distributed budget level, the disparity between the CPI and TCPI increases when Undistributed Budget is included in the TCPI because more work must be accomplished at a better efficiency to achieve the EAC. In the above data, the disparity between CPI and TCPI increased from 0.19 to 0.21.

Calculating the TCPI at the total contract level with Undistributed Budget and Management Reserve in both the BAC and EAC yields TCPI values very close to TCPI values calculated at the distributed PMB level. The UB and MR values included in the BAC and EAC increase the proportion of the remain-ing work that is forecast to be completed at an efficiency of 1.0 and push the TCPI toward the 1.0 val-ue. The larger the values of UB and MR, the more the TCPI will diverge from the TCPI calculated at the Distributed Budgets level. Using this approach for the sample data above, the CPI is 0.73 and the TCPI is 0.94.

Calculating the TCPI at the total contract level, but not including Management Reserve in the EAC, creates a significant disparity between the CPI and TCPI. This situation represents the classic “apples to oranges” comparison: the work remaining in the formula includes MR, but the funds estimated do not. Obviously, with a higher numerator, the TCPI would be higher than any of the other approaches discussed above. Using this approach for the sample data above, the CPI is 0.73 and the TCPI is 1.06. While situations arise where exclusion of MR from the EAC makes sense, it is still important to review the project manager’s rationale with respect to MR application. Most situations assume that MR will be depleted during contract performance; consequently, it should be added to the EAC at the PMB level.

In summary, be sure you understand what is included in the TCPI calculation before you make comparisons to the CPI at the total contract level. The following table summarizes the CPI and TCPI for the sample data in this article and highlights the differences in the TCPI when calculated at the various data summary levels.

CPI / TCPI

To ask about this topic or if you have questions, feel free to contact Humphreys & Associates.

Ensuring CPI to TCPI Comparisons are Valid at the Total Contract Level Read Post »

Scroll to Top