Actual Cost of Work Performed (ACWP)

Introduction to the Cost and Software Data Reporting (CSDR) Reporting Requirements

, , , ,

A common client request is to assist them with sorting through the various DoD contractual reporting requirements and contract value reporting thresholds that apply. We frequently run into situations where a contractor needs clarification on why they have a Cost and Software Data Reporting (CSDR) requirement and whether they should seek to waive the requirement. Subcontractors to a prime often question the requirement to provide actual cost data directly to the DoD, especially for Firm Fixed Price (FFP) contracts.

Background

CSDRs are the primary means the DoD uses to collect data on the development, production, and sustainment costs incurred by contractors performing DoD acquisition contracts. It is a DoD system for collecting actual costs, software data, and related business data. The resulting data repository serves as the primary source for contract cost and software data for most DoD resource analysis efforts including cost database development, applied cost estimating, cost research, program reviews, analysis of alternatives (AoAs), and life cycle cost estimates.

CSDR reporting requirements are determined by the contract value regardless of the acquisition phase and contract type. In general, CSDR reporting is required for Acquisition Category I-II programs and Information System (IS) programs valued at more than $50M. They can also be required for Middle Tier Acquisition programs (greater than $20M) and other programs (greater than $100M). Risk can also be a determining factor regardless of the contract value.

DoD Instruction (DoDI) 5000.73, Cost Analysis Guidance and Procedures (March 2020), provides additional details about the cost data reporting. Table 1 in the 5000.73 lists the cost reporting requirements contract value thresholds. The DoD Manual 5000.04 Cost and Software Data Reporting (May 2021) is the primary requirements document for the development, implementation, and operation of the DoD CSDR system to ensure data reported is accurate and consistent.

About CADE

The Office of the Secretary of Defense Cost Assessment and Program Evaluation (OSD CAPE) established the Cost Assessment Data Enterprise (CADE), a secure web-based information system that hosts the controlled unclassified CSDR repository, the Defense Acquisition Cost Information Management System, and the forward pricing rate library. CADE also contains a selected acquisition report database, a contracts database, data analytics capabilities, and a library containing cost estimating content such as cost analysis requirement descriptions and cost estimates. CADE is access-controlled, and available through the public-facing CADE Portal website.

Similar to the cost estimating and proposal pricing functions within contractor’s organizations that rely on historical actual costs to assess the validity of a proposed cost estimate, independent and sound cost estimates are vital for effective DoD acquisition decision making and oversight. CADE plays a critical role in capturing the expenditure, technical, and programmatic data after contract execution in a consistent manner to enable independent cost estimating and analysis. This cost estimate data is essential to support efficient and effective resource allocation decisions throughout the planning, programming, budgeting, and execution process for the DoD.

CSDR Reporting Requirements

There are a series of Data Item Descriptions (DIDs) for this reporting requirement.  Some forms are submitted electronically using DoD defined XML schemas, Excel, or JSON encoded data in accordance with a File Format Specification (FFS) and Data Exchange Instruction (DEI). The list of DIDs are as follows. These DIDs can be downloaded from the CADE website.

  • Contract Work Breakdown Structure, DI-MGMT-81334D (May 2011).
  • Cost Data Summary Report, DI-FNCL-81565C (May 2011), DD Form 1921, XML Schema.
  • Functional Cost-Hour Report, DI-FNCL-81566C (September 2015), DD Form 1921-1, XML Schema.
  • Progress Curve Report, DI-FNCL-81567C (May 2011), DD Form 1921-2, XML Schema. 
  • Sustainment Functional Cost-Hour Report, DI-FNCL-81992 (May 2011), DD Form 1921-5, XML Schema.
  • Contractor Business Data Report, DI-FNCL-81765C (March 2021), DD Form 1921-3, Excel. 
  • Software Development Report, DI–MGMT-82035A (October 2022), DD Form 3026-1, XML Schema. 
  • Software Maintenance Report, DI–MGMT-82035A (October 2022), DD Form 3026-2, XML Schema.
  • Enterprise Resource Planning (ERP) Software Development Report, DI-MGMT-82035A (October 2022), DD Form 3026-3, XML Schema.
  • Cost and Hour Report (FlexFile), DI-FNCL-82162 (November 2017), JSON encoded data file following FFS and DEI.
  • Quantity Data Report, DI-MGMT-82164 (November 2017), JSON encoded data file following FFS and DEI.
  • Maintenance and Repair Parts Data Report, DI-MGMT-82163 (November 2017), Excel.
  • Technical Data Report, DI-MGMT-82165 (November 2017), Excel.

The Cost and Hour Report (FlexFile) and Quantity Data Report play a critical role in collecting cost data from contractors for the DoD data repository because they use JSON data encoding to organize the content. They are intended to replace the legacy 1921 series of paper-based formats including the DD 1921, 1921-1, 1921-2, and 1921-5. It also requires contractors to provide significantly more historical cost data than the 1921 formats. As a result, the DoD cost estimating community has additional insight into historical costs. The goal is to establish a common framework and standard nomenclature to collect data from different contractors, all of them with unique cost accounting structures, that are mapped to the DID, FFS, and DEI requirements for use in the data repository.

Establishing a Consistent, Repeatable Process to Produce the CSDR Data Deliverables

For contractors new to the CSDR reporting requirements and in particular, the FlexFile JSON data encoding, can appear to be daunting. That’s where software tools such as those from Midnite Dynamics can help. Midnite Dynamics specializes in assisting contractors with producing the CSDR data deliverables. 

Their software tool, C*CERT+, streamlines, automates, validates, and produces the legacy 1921 family of Excel and XML reports as well as the FlexFile and Quantity Data Report JSON submittals. C*CERT+ eliminates what otherwise is a manually intensive, resource draining, tedious and costly effort subject to recurring rejections. It is one thing to create the required legacy reports or FlexFile JSON files for submittal, it is another to pass the submittal validation process. C*CERT+ provides numerous data validations and analysis reports to ensure the data is 100% compliant before it is submitted. For example, the software includes over 90 FlexFile validations to ensure data compliance as illustrated in Figure 1.

Figure 1: Example of FlexFile data validation results.
Figure 1: Example of FlexFile data validation results.

The software includes a Validation and Remarks utility to analyze the source data details that could result in a Validation Trip. Remarks can be entered directly into the validation module for anything that requires an explanation. This is illustrated in Figure 2. This narrative is included with the data submittal.

Figure 2: Example of providing remarks about the FlexFile data content.

C*CERT+ also interfaces with existing EVM cost tools and accounting systems to produce the existing legacy 1921 reports, the FlexFile, and other data submittals as well as to consolidate separate projects/CLINs/task orders into a single contract report.

Once the C*CERT+ Standard Category Mapping Rules are set up, they can be shared throughout the corporation or business unit to establish a standard and repeatable process for producing the data deliverables. This mapping process translates the contractor’s source data into an output that matches the CSDR data submittal format rules. This saves a tremendous amount of time and makes it much easier to consistently produce the CSDR data deliverables. An example of the Mapping Rules is illustrated in Figure 3.

Figure 3: Mapping Rules translate contractor unique cost data into a format that matches the CSDR data submittal requirements.

Do your process and procedures or training materials need an update to include specific guidance for project control teams to produce required DoD contractual reports or data submittals using your tool sets of choice? Give us a call today at (714) 685-1730 to get started. 

Introduction to the Cost and Software Data Reporting (CSDR) Reporting Requirements Read Post »

EVMS Guidelines and Required Elements

, , , , ,

Video Contents

This video reviews the data points that an Earned Value Management System provides and how variances can be calculated from those data points.  Timely analysis of performance data and variances assists contractors to proactively resolve issues and effectively manage the remaining work on a project.

You can use the links below to jump to a specific part of the video.

Earned Value Contractors’ Internal Systems must be able to provide the following:
00:06Budgeted Cost for Work Scheduled (BCWS)
00:26Budgeted Cost for Work Performed (BCWP)
00:38Actual Cost of Work Performed (ACWP)
00:47Buget At Completion (BAC)
00:52Estimate At Completion (EAC)

Variances can be calculated using the BCWS, BCWP, ACWP, BAC and EAC.
00:58Variances Explanations
01:03Schedule Variance (SV)
01:19Cost Variance (CV)
01:31Variance at Completion (VAC)
01:45Why do we calculate Variances?


01:54EAC and BAC Comparison
2:06What does Variance at Completion (VAC) indicate?
2:18Structure your Earned Value Management System so that Variances can be traced to their source.
2:32Use your existing project management systems.

We also have additional free resources for learning about

You can also find Earned Value Definitions as well as additional free resources for learning more about EVMS concepts like Budgeted Cost for Work Performed (BCWP), Actual Cost of Work Performed (ACWP), Buget At Completion (BAC), and Estimate At Completion (EAC) in our EVMS Education Center and in other posts on this blog.


More EVMS Training

If you liked this video you can purchase the entire course below. This video is an excerpt from the Department of Defense (DOD) version of this eLearning module. We also offer the same course customized for the Department of Energy’s (DOE) specific Earned Value Management (EVM) implementation/requirements, as well as a version of the course customized for NASA’s EVM implementation/requirements.  

— Purchase This Course —
EVMS DOD Virtual Learning Lab

— Purchase the DOE Version of this Course —
EVMS DOE Virtual Learning Lab

— Purchase the NASA Version of this Course —
EVMS NASA Virtual Learning Lab


EVMS Document Matrix

EVMS Document Matrix

Not sure what the different requirements are between the DOE and NASA? Can’t remember if Cost and Software Data Reporting (CSDR) is required for an NSA contract? Check out our easy to read Earned Value Management Systems Document Matrix


All Online Courses

All Online Courses Available from Humphreys & Associates

Earned Value Training

EVMS Guidelines and Required Elements Read Post »

Management Reserve; Comparing Earned Value Management (EVM) and Financial Management Views of “Reserves”

, , , , , , , , , ,
Management Reserve & Earned Value ManagementPerhaps you have witnessed the collision of earned value management’s views on “management reserve” with the Chief Financial Officer (CFO) and the finance department’s views on “balance sheet reserves.” Most companies tend to organize EVM, the function, reporting to either the programs’ organization or to the finance organization. Either will work but either can fail if the two organizations do not understand the interest of the other.

In this article we will outline three areas. The first will be EVM and Management Reserve (MR). The second will be finance and balance sheet “contingencies, loss provisions, or reserves.” The third will compare the two views and identify where they are similar and where they differ.

We will use two terms for both EVM and Financial Management; “in play” and “on the sideline.” “In play” for EVM means that it is in your Performance Measurement Baseline (PMB) and Budget at Completion (BAC). “On the sideline” for EVM means “not in scope” therefore in MR. “In play” for financial management means recorded on the balance sheet (e.g.: current liability; an accrued liability). “On the sideline” for financial management means not recorded on the balance sheet, because it is more likely than not that a liability has been incurred.   If material, however, it will likely be disclosed in the notes to the financial statements, even if it is not recorded on the balance sheet.

 

Earned Value Management and Management Reserve

A program manager and his or her team must deal with – mitigate – risk or be consumed by those risks as they become issues. There are two types of risks, known and unknown. The known risks are entered into a risk register, and their likelihood and consequence are determined. Mitigation for those known risks is done at the activity level in a program’s Integrated Master Schedule (IMS) (Planning and Scheduling Excellence Guide — PASEG page 141, ¶ 10.3.1). Mitigation of known risks is part of the PMB (in the BAC) and is therefore “in play.”

The second type of risk – unknown or unknowable risks – are covered by management reserve if within the Scope of Work (SOW) of the existing contract. If contractor and customer conclude that the realized risk is outside the existing contract, then an Engineering Change Proposal (ECP) would likely be created by the contractor; and a contract modification would be issued by the authorized customer contracting officer if they agreed.   The program manager should ask this question of his team: what work is “at risk” and what work is not “at risk?” Does labor or material present more risk? Management reserve “is an amount of the overall contract budget held for management control purposes and for unplanned events” (Integrated Program Management Report–IPMR DI-MGMT-81861 page 9, ¶ 3.2.4.6). Management reserve is “on the sidelines.” MR has no scope. MR is not earmarked. MR stands in waiting.

 

Earned Value Management Reserve (MR) Compared To Financial Management “Contingency”

Because the audience reading this blog is most likely from the EVM community, I’ll offer a Financial Management example of a company that faces many risks and must manage those risks or be consumed by them. Altria Group, Inc. and Subsidiaries (stock symbol: MO) are in the tobacco, e-Vapor and wine business. Altria’s history clearly shows that the company measures and successfully mitigates the risks they face. Altria faces a blizzard of litigation each year and must protect its shareholders from that risk. So how does Altria manage known risks (mostly from litigation) and how does Altria handle unknown risks?

Altria is a publicly traded company and its annual report (10K) is available on-line to the public. This data is from their 2014 annual report.

I am an MBA, not a CPA, so I’ll stick to Altria’s 2014 balance sheet. For those not familiar with financial statements, a balance sheet has on its left hand side all of a company’s assets – what the company owns and uses in its business (current assets = cash, accounts receivable, inventory; long term assets = property, plant and equipment). The right hand side of a company’s balance sheet shows current and non-current liabilities and shareholders’ equity. The top right hand side of the balance sheet includes current and non-current liabilities (accounts payable, customer advances, current and long-term debt, and accrued liabilities like income taxes, accrued payroll and employee benefits, accrued pension benefits and accrued litigation settlement costs) and the bottom of the right hand side of the balance sheet includes shareholders’ equity consisting of common and preferred stock, paid in capital and retained earnings.

Altria’s 2014 annual report shows under current liabilities; accrued liabilities; settlement charges (for pending litigation Contingency note # 18) a value of $3.5 billion dollars. The 2013 amount was $3.391 billion dollars.

So Altria has “in play” $3.5B for litigation for 2014. In financial terms, Altria has recorded $3.5 billion in expense related to the litigation, probably over several years as it became more likely than not that a liability had been incurred and was reasonably estimable. In EVM terms Altria has $3.5B in their baseline, or earmarked, or in scope for litigation (court cases).

What happens if Altria ultimately has more than $3.5B in litigation settlement costs? What does Altria have waiting on the “sidelines” to cover the unknown risks? Essentially Altria has on its balance sheet waiting “on the sidelines” $3.321 billion in cash and the ability to borrow additional funds or perhaps to sell additional shares of stock to fund the settlement costs. In EVM terms Altria has $3.5B in its baseline (on its balance sheet) to manage the risks associated with litigation. Altria’s market capitalization at the market close on May 17, 2015 was $52.82 billion and its 2014 net revenues were $24.522 billion. It is reasonable to understand that Altria has more than enough MR.

 

Differences Between EVM MR and Financial Management Balance Sheet Reserves

In EVM, MR is only released to cover unplanned or unknown events that are in scope to the contract but out-of-scope to any control account. A cost under-run is never reversed to MR, and a cost over-run is never erased with the release of MR into scope.

In industry in general, and Altria in particular, if the “in play” current liability for settlement charges of $3.5B are not needed (an under-run), then Altria will reverse a portion of the existing accrued liability into income, thereby improving profitability. If Altria’s balance sheet reserve of $3.5B is insufficient, then Altria’s future profits will be reduced as an additional provision will be expensed to increase the existing reserve (an over-run).

[Humphreys & Associates wishes to thank Robert “Too Tall” Kenney for authoring this article.]

Management Reserve; Comparing Earned Value Management (EVM) and Financial Management Views of “Reserves” Read Post »

EVMS compliance: Material Transfers and Loan/Paybacks

, , , , , , , ,

Earned Value Management System (EVMS) compliance | Material Transfers and Loans/Paybacks

In a high rate production environment, it is not unusual for different Contract Lot Buys to have demands for the same required parts. Circumstances driven by delivery schedules, fee incentives, national priorities, or quality issues will prioritize the demand for these common parts. Companies will be challenged to respond to these dynamics while satisfying contractual requirements and continuing to remain Earned Value Management System (EVMS) compliant. A documented Material Transfer and Borrow and Payback (e.g., TBLP) policy/procedure describing a disciplined, auditable approach is a mandatory prerequisite for EVMS project managers.

Material Management and Accounting System (MMAS)

There are a number of applicable Government documents that come into play but none more important than the Material Management and Accounting System (MMAS). It is a DoD Policy (242.7202) that contractors have a MMAS that:

(1) Reasonably forecasts material requirements
(2) Ensures the cost of purchased and fabricated material charged or allocated to a contract are based on valid time-phased requirements
(3) Maintains a consistent, equitable, and unbiased logic for costing of material transactions.

MMAS Standards 6, 7 and 8 are especially apropos to material transfers and loan/paybacks:

• MMAS Standard 6 (Material Transfers) requires that the contractor’s policies and procedures provide detailed descriptions of circumstances which will result in manual or system generated transfers of parts.
• MMAS Standard 7 (Material Costing) requires that the contractor’s system transfer parts and associated costs within the same billing period or use an ACO approved “Loan/Payback” technique.
• MMAS Standard 8 (Inventory Allocations) requires that the contractor’s system handle allocations of common inventory in such a manner as to preclude improper allocation and costing of allocations.

Material Transfer versus Loan/Payback

For a number of reasons, a material transfer involves the most problematic issues for accommodating changing demands and priorities for common parts:
• Transfer costs are based on labor, material and applicable burdens when originally incurred and not based on the year when they are physically transferred (i.e. 2010 costs vs. 2014 costs). Related funding issues may also surface (requesting 2014 funding to ‘build’ a 2010 requirement in 2014).
Replacement costs will, in most cases, be at a higher value and there may be a potential schedule impact; both represent negative impacts to the customer.
• Previously reported Budgeted Cost for Work Performed (BCWP) and Actual Cost of Work Performed (ACWP) for work already accomplished will be impacted.
• Potential for inadvertently gaining a cost benefit when transfers are made between a Cost Plus and Fixed Price contract.
A transfer approach should only be considered when there is no replenishment currently in the procurement system. If there is a replenishment currently in the ‘pipeline’ then a loan/payback approach should be used as this will result in no cost transfer.
Under a loan/payback scenario, a part is moved temporarily from the contract but the cost of the part remains on the contract. As noted earlier, contractor procedures for the loan/pay-back technique must be approved by the Administrative Contracting Officer (ACO). Per Defense Contract Audit Agency (DCAA), when the technique is used, the contractor must have controls to ensure that:
• Parts are paid back expeditiously.
• Procedures and controls are in place to correct any over-billing that might occur.
• Monthly, at a minimum, identify the borrowing contract and the date the part was borrowed.
• The cost of the replacement part is charged to the borrowing contract.
Material Management and planning within an EVMS environment is quite challenging. Thankfully, there are a number of Earned Value Management Systems software programs available to assist contractors in meeting and managing this challenge.

Consider Humphreys & Associates to assist you in guiding your efforts in this complex endeavor, to ensure a firm foundation is established that meets or exceeds your material management needs.

EVMS compliance: Material Transfers and Loan/Paybacks Read Post »

Scroll to Top