Integrated Program Management Report (IPMR)

Aligning ACWP with BCWP for Proper EVM | Earned Value Management

, , ,

ACWP and BCWP by DAU

What is estimated Actual Cost of Work Performed (ACWP)?

Estimated ACWP is an adjustment to the Actual Cost of Work Performed (ACWP) in the earned value “engine” to align ACWP with Budgeted Cost for Work Performed (BCWP).  Estimated ACWP is synonymous with “estimated actuals.”

Why is Estimated ACWP necessary?

Without Estimated ACWP, timing mismatches between ACWP and Budgeted Cost for Work Performed (BCWP) cause false cost variances to appear in the Integrated Program Management Data Analysis Report (IPMDAR) information reported to the customer.  Typically these variances are favorable and can mask other unfavorable variances.  Additionally, if these variances exceed reporting thresholds, the explanations clutter Format 5 of the IPMDAR with variance explanations that discuss timing problems of the accounting system rather than actual performance issues.

To what types of cost does Estimated ACWP apply?

Estimated ACWP is most typically required for material costs.  When BCWP is claimed upon receipt of the material, the actual cost accrual typically occurs one or more months following material receipt, which creates the timing mismatch between BCWP and ACWP.  Other cost element types that may require Estimated ACWP include subcontracts and Other Direct Costs (ODC).  Examples of ODCs that may require Estimated ACWP include consultants, purchased labor, and travel.

How does Estimated ACWP function?

Receipt-type material:

  1. First, a determination must be made whether Estimated ACWP is necessary.  For some categories of material, when a material item is received, the BCWP is claimed.  If actual costs for the materials do not enter the accounting system in the same period that the BCWP was claimed, Estimated ACWP is necessary to ensure ACWP occurs when BCWP occurs.
  2. Second, the Estimated ACWP adjustment is entered into the Earned Value engine as a current period transaction.  The amount of the Estimated ACWP is based on the best information available for the material item using the invoice, purchase order, or receiving report.
  3. Third, the Estimated ACWP adjustment transaction is reversed in the EV engine prior to the next month’s update.  If actual costs were to come in that month and the transactions were not reversed, the ACWP would be double-counted when the actual cost data from the accounting system gets transferred to the EV engine.
  4. Finally, remember that if the actual data does not occur as expected in the month following material receipt, the Estimated ACWP is re-entered and the reversal process must continue every month until the accounting system receives the cost of the material item.  Also, Estimated ACWP transactions should be recorded in a log to maintain traceability.

Production-type (inventory) material:

The transactions described above were for material categories for which Earned Value is claimed at receipt of the material item.  For production type materials, or materials that are common to many control accounts or even contracts, that go into inventory, Earned Value is claimed upon issuance from inventory, sometimes several months after receipt of the material and after the incurrence of actual costs in the accounting system.  In this case, the opposite condition would exist.  The accounting actuals occur before earned value is claimed for material, but EVM rules in Guideline 21 (and common sense) state that ACWP is not to occur until BCWP takes place.  Therefore, the accounting actual costs have to be “suppressed” from entering the EVM engine until material Earned Value occurs. Since some companies say they cannot suppress actual costs, they let the actual costs enter the system, but make an off-setting “Negative Estimated ACWP” entry in the EVM system until the material is issued and BCWP can be claimed for the material.

Do you need to implement an Estimated ACWP process in your Earned Value Management System?  Humphreys & Associates has the earned value training experts to assess your material management processes and implement the appropriate procedures. Contact us today.

Aligning ACWP with BCWP for Proper EVM | Earned Value Management Read Post »

IPMR DID Change – Office of Secretary of Defense Publishes New Procedure

Office of Secretary of Defense (OSD) Publishes the Integrated Program Management Report (IPMR) Data Item Description (DID)

This is important, new information for companies with U.S. Department of Defense EVMS contractual requirements.

The Department of Defense Integrated Program Management Report (IPMR), Data Item Description (DID), DI-MGMT-81861, replaces the Contract Performance Report (CPR) DID, DI-MGMT-81466A, and the Integrated Master Schedule (IMS) DID, DI-MGMT-81650.

The IPMR DID can be downloaded from the ASSIST database:  IPMR ASSIST document

The IPMR DID will apply to new contracts and may be applied to follow on contracts, subject to negotiation with the government customer.

In summary:

  • The IPMR DID combines the CPR and IMS DIDs into one.  The intent is to emphasize the integration of the schedule and cost data for performance reporting.
  • CPR Formats 1 to 5 are now the IPMR Formats 1 to 5.  There are a few content changes for Formats 1 to 5 which are mostly confined to Format 3.  The Baseline Changes (Block 6.b.) row columns have been opened up for change detail content.
  • The Integrated Master Schedule (IMS) becomes IPMR Format 6.  There are additional schedule data elements that are required including specific data coding details.
  • A new Format 7 has been added for time phased cost data (historical and future time periods).  Format 7 is an annual submission.
  • The electronic data delivery format for the OSD EVM Central Repository is changing from the ANSI X12 standard to the UN/CEFACT XML standard.  Additional information about the XML data submittal instructions is available on the OSD EVM Central Repository website.

We highly recommend being prepared to support the new IPMR DID as it will impact existing EVM Systems.  It will be necessary to reference the old and new terms and forms.  Existing contracts will be against older DID requirements (unless otherwise negotiated with the client) and new contracts will be against the IPMR DID.

Be prepared to update:

  • Training materials to reflect the updated cost Formats 1 to 5 as well as discuss the new Format 6 and 7.
  • System Description and Storyboard text as well as example formats and/or artifacts.
  • Procedures or project directives that specify schedule data coding requirements and related details necessary to produce the required IMS data for submission to the OSD EVM Central Repository.
  • Desktop instructions for producing the cost IPMR Formats 1 to 5 as well as the new Format 7.
  • Software toolset outputs and electronic deliverables.
  • Contractor self-surveillance and subcontractor surveillance materials.

Most cost and schedule software vendors are aware of the IPMR data requirements.  You may want to check with your toolset vendor of choice to see when they plan to have software updates available to support the IPMR DID and the UN/CEFACT XML data submissions to the OSD EVM Central Repository.

Humphreys & Associates is available for consulting on this topic.  Contact us for more information.

IPMR DID Change – Office of Secretary of Defense Publishes New Procedure Read Post »

New Integrated Program Management Report (IPMR) DID

, , ,

This coming change, likely to take effect in May 2012, applies to government contractual requirements (CDRLs) on contracts that require Earned Value Management (EVM) by most federal agencies. This is of particular importance to program and project managers, corporate EVM focal points and other staff that maintain a corporate EVM System Description or training materials. In some cases it applies to IT resources responsible for maintaining the schedule and cost toolsets used on projects.

A new Data Item Description (DID) for contract performance reporting and integrated master schedules was recently circulated for public comment.  The new DID, Integrated Program Management Report (IPMR), DI-MGMT-81466B, will replace the current Contract Performance Report (CPR) DID, DI-MGMT-81466A, and the Integrated Master Schedule (IMS) DID, DI-MGMT-81650.

A copy of the draft IPMR DID can be found on the PARCA (Performance Assessments and Root Cause Analyses) website. PARCA is part of the Office of the Assistant Secretary of Defense for Acquisition.  The Earned Value Management Division of PARCA is the DOD focal point for all policy, guidance, and competency relating to EVM.

In summary:

  • The IPMR DID combines the CPR and IMS DIDs into one
  • CPR Formats 1 to 5 become the IPMR Formats 1 to 5
  • The IMS becomes IPMR Format 6
  • There are a few content changes mostly confined to Format 3, which opens up the Baseline Changes (Block 6.b.) row columns
  • It adds a new Format 7, time phased historical data (an annual submission)
  • The electronic data delivery format is changing from the ANSI X12 standard to the UN/CEFACT XML standard

The initial comment period for the IPMR DID closed on January 31, 2012, followed with additional discussions with industry through the NDIA Program Management Systems Committee (PMSC). The likely publication date is early May 2012 but this is dependent on the final formal coordination process within OSD. The new DID will begin being applied on new contracts once the DID is approved.

The new DID does impact current EVM Systems as it will be necessary to reference the old and new terms and forms.  As a result, it may be necessary to update:

  • Training materials
  • System Description and Storyboard text, example formats and/or artifacts
  • Desktop instructions for producing specified formats
  • Software toolset outputs and electronic deliverables
  • Self-surveillance and subcontractor surveillance materials

Most cost and schedule software vendors are aware of the pending changes.  You may want to check with your toolset vendor of choice to see when they plan to have software updates available to support the new DID requirements.

Humphreys & Associates is available to provide resources, consulting and information on this topic. Click here to contact us.

New Integrated Program Management Report (IPMR) DID Read Post »

Scroll to Top