Contractor Cost Data Reporting (CCDR) Tool
June 2018 – The CCDR Tool is an automation process that helps expedite the fulfillment of the Contractor Cost Data Reporting requirements. This is a tool that OPDEC has made several variations of, and we can synchronize it with either OPDEC’s IPM cost module or any other cost system utilized.
The DD 1921, 1921-1, and 1921-2 reports are contractual requirements that must be submitted annually. These reports request that the contract’s inception to date actuals and estimates at completion be grouped into several different categories. They must be divided by recurring and nonrecurring work, and then separated by type. The types are dictated by the report.
OPDEC’s tool helps the user ensure they have all of their required cost data mapped to an appropriate predefined category, and then create the reports. It works in conjunction with the CSDR Planning and Execution Tool (cPET), which is the official software provided by DCMA. The cPET allows all of the data to be inserted into one, simply formatted flat file. OPDEC’s CCDR Tool creates this flat file. The cPET can then transform that flat file into the final, heavily formatted deliverable versions of the reports. Below, you can see examples of the forms of two versions of the tool. Both of these are customized to the user’s specifications, and the amount of detail can be seen here.
Regardless of the cost system utilized, the steps to create a 1921, 1921-1, or 1921-2 are roughly the same. First, the source data is imported into the tool. This will typically include the ITD actuals and the EAC data from the cost system as well as other mapping files created through discussions with OPDEC and the user. The mapping files are going to work with the user’s data to set up a system allowing the user to dictate which expenditures belong to which predefined reporting category. This system will vary depending upon how the user has set up their cost data, but the goal is to try and take advantage of built in logic to mass update the data with what CCDR category each item belongs to.
Automation is especially helpful with this report due to the time gap between deadlines. Since the report is submitted annually, using a system can ensure data accuracy across reporting periods. Also, retaining the same logic implemented to generate last year’s report becomes easy and reduces any duplication of effort (i.e. a user will not have to map the same data twice