EVM: The IPMR and Subcontract Flowdown

, , , , , ,

EVM Contractors, EVM Subcontractors, IPMR & Flowdown

For decades government EVM project managers performed the task of integration of all prime and subcontractor performance and the associated data on a project. In the late 1960s things changed. The U.S. Federal Government mandated that the prime contractor become the integrator of the performance and the data. Many contractors undertook this responsibility nicely. However, for many contractors in this new role their subcontract management expertise and data accumulation capabilities were lacking on large R&D, SDD, and LRIP subcontract efforts in particular. The primes needed to include all of the data from their subcontractors that comprised as much as 80% of the contract effort. The timing of subcontractor reports became very important. However, software was “what it was” in the 1960s and ‘70s, and many EVM subcontractors were unable to meet the required delivery dates.

In the early 1980s the National Security Industrial Association [now the NDIA] conducted a survey and found that 40% of the subcontractor data was delayed by a month [additional reference, 2008 – NDIA.org source]. Consequently, January data from subcontractors would not be entered into the prime contractor’s performance reports [now IPMR or CPR] until the prime’s February report which may be delivered around 15 March. Today’s software has improved extensively and many EVM subcontractors recognize the importance of timeliness of data; they are also prime contractors on other EVM projects.

Many companies have not yet begun delivering performance data using the new Integrated Program Management Report (IPMR). Companies that are using the IPMR appear to be adapting well to the new requirements, specifically in regards to the submission date and successful retrieval of subcontractor data. The new IPMR Data Item Description, DI-MGMT-81861, specifically requires that “Formats 1-6 shall be submitted to the procuring activity no later than 12 working days following the contractor’s accounting period cutoff date. This requirement may be tailored through contract negotiations to allow submission as late as 17 working days, provided the contractor and Government agree that contract complexity and/or integration of subcontractor and vendor performance data warrant additional time and will yield more accurate performance.”

The table below illustrates the results of a survey H&A conducted of fifteen major contractors. While the sample size is small, the survey found that five prime contractors had an IPMR requirement flowdown to a subcontractor with NTE 12 working days submission CDRL requirement. In all five cases, the prime contractors were able to successfully incorporate subcontract data in time to meet the submission requirement.

EVM IPMR chart

While it has taken over 40 years, it is now recognized by both the government and contractors that timely incorporation of subcontractor performance data in the prime’s performance report helps validate the project data–the purpose of early visibility and prompt decision making.

Our survey found that those contractors submitting the IPMR are successfully incorporating subcontractors’ performance data in their IPMRs as the DID Instructions stipulate. It is hoped that the era of the “one-month lag” with subcontractor performance data has ended; and the government will be receiving accurate, timely IPMR performance data from its prime contractors.

EVM: The IPMR and Subcontract Flowdown Read Post »

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 »

Scroll to Top