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 »

Scroll to Top