Attachment 0004 - DD2794 CSDR.xls

XLS spreadsheet 99 KB Posted

Attached to
Head, Rotary Wing for the Apache AH-64
Solicitation number
W58RGZ-25-B-0014
Issued by

View the file

Other files

Show all 23

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

DD Form 2794, Pg 1 (METADATA)

COST AND SOFTWARE DATA REPORTING PLANOMB No. 0704-0188
The public reporting burden for this collection of information is estimated to average 8 hours per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions for reducing the burden, to Department of Defense, Executive Services Directorate (0704-0188). Respondents should be aware that notwithstanding any other provision of law, no person shall be subject to any penalty for failing to comply with a collection of information if it does not display a currently valid OMB control number.

PLEASE DO NOT RETURN YOUR COMPLETED FORM TO THE ABOVE ORGANIZATION.

1a. PROGRAM NAME
AH-64E Apache Remanufacture
1b. PHASE/MILESTONE (check all that apply)
Pre-A
A
B
C-LRIP
C-FRP
XO&S
1c. PRIME MISSION PRODUCT
CH-47F Overhaul Mechanical Transmission
1d. ACQUISITION CATEGORY (ACAT)
Pre-ACAT
XACAT I (MDAP)
ACAT IA (MAIS)
ACAT II
ACAT III
Other
2. COMMODITY TYPE
Aircraft Systems
3. PLAN ITERATION TYPE
XINITIAL
REVISION
4. CURRENT SUBMISSION DATE (YYYYMMDD)
20230225
5. LAST APPROVED PLAN DATE (YYYYMMDD)
6a. GOVERNMENT PLAN POINT OF CONTACT (POC) NAME (Last, First, M.)
Duckett, Tihera L (Shay)
6b. ADDRESS (Include ZIP Code)
5300 Martin Road Redstone Arsenal, AL 35898
6c. TELEPHONE NUMBER (Include Area Code)
256-313-1341
6d. E-MAIL ADDRESS
tihera.l.duckett.civ@army.mil
7. PLAN TYPE
GOVERNMENT
XCONTRACT (PRIME)
CONTRACT (SUB)
8. PLAN GOVERNMENT PREPARING ORGANIZATION
AMCOM Logistic Center
9a. CONTRACTOR NAME/ADDRESS
i. REPORTING ORGANIZATION NAME
TBD
ii. DIVISION NAME
TBD
iii. LOCATION
TBD
iv. CONTRACTOR BUSINESS DATA REPORT (CBDR 1921-3) REQUIREMENT:
XCBDR REQUIRED FOR THIS ORGANIZATION
9b. CONTRACT NUMBER (List all that apply, separated by commas)
W58RGZ-24-B-0048
9c. APPROPRIATION (check all that apply)
RDT&E
PROCUREMENT
XO&M
FMS
WCF
OTHER
10a. APPROVED PLAN NUMBER
D-23-A-C8
10b. APPROVED PLAN REVISION NUMBER
0
10c. APPROVED PLAN REQUIREMENTS
XAT COMPLETION COSTS FOR STANDARD FUNCTIONAL CATEGORIES (FlexFile or Legacy)
XAT COMPLETION COSTS FOR RECURRING/NONRECURRING (FlexFile only)
TECHNICAL DATA REQUIRED
10d. COST REPORT TYPE
XFLEXFILE
LEGACY DD 1921 SERIES
DRAFT DD FORM 2794 (PAGE 1), METADATA, JANUARY 2019PREVIOUS EDITION IS OBSOLETE

Check lanquage.

tihera.l.duckett.civ@army.mil

DD Form 2794, Pg 2 (REPORTING)

COST AND SOFTWARE DATA REPORTING PLANCOST, SOFTWARE, & TECHNICAL DATA REPORTING/EARNED VALUE MANAGEMENT CO-PLAN
11. WORK BREAKDOWN STRUCTURE (WBS)12. COST13. TECHNICAL DATA
a. WBS
CODEb. WBS
LEVELc. WBS ELEMENT NAMEa. ACTUALS TO
DATE (ATD)b. LEGACY
1921-1c. LEGACY
1921-2d. LEGACY
1921-5e. EAC/FAC
(See item 10d)a. QUANTITYb. SRDR
FORMATSc.

MAINT. &

REPAIR

PARTS

i. QUANTITY
DATAii. GFE

QUANTITY

1.01Sustainment - AH-64 Apache Rotary Wing Head
1.12Unit-Level Manpower (System Level Cost Only)0
1.1.13Operations ManpowerXX
1.1.23Unit-Level Maintenance ManpowerXX
1.1.33Other Unit-Level Manpower (Specify In Remarks)XX
1.22Unit Operations (System Level Cost Only)XX
1.32Maintenance00X
1.3.13Consumables and Repair Parts00X
1.3.1.14Airframe/Hull/Vehicle Consumables and Repair PartsXXX
1.3.1.24Propulsion Consumables and Repair PartsXXX
1.3.1.34Electronics/Avionics Consumables and Repair PartsXXX
1.3.1.44Other Major Subsystem Consumables and Repair Parts 1..n (Specify)XXX
1.3.1.54Other Consumables and Repair PartsXXX
1.3.23Depot Level Reparables (DLRs) / Repair of Reparables (RORs)00X
1.3.2.14Airframe/Hull/Vehicle DLRsXXX
1.3.2.24Propulsion DLRsXXX
1.3.2.34Electronics/Avionics DLRsXXX
1.3.2.44Other Major Subsystems DLRs 1..n (Specify)XXX
1.3.2.54Other DLRsXXX
1.3.33Intermediate Maintenance00X
1.3.3.14Intermediate Maintenance Consumable Materials and Repair PartsXXX
1.3.3.24Intermediate-Level Government MaintenanceXXX
1.3.3.34Intermediate-Level Contractor MaintenanceXXX
1.3.3.44Other Intermediate-Level MaintenanceXXX
1.3.43Depot Maintenance00X
1.3.4.14Scheduled Overhaul00X
1.3.4.1.15Airframe/Hull/Vehicle Scheduled OverhaulXXX
1.3.4.1.25Propulsion Scheduled OverhaulXXX
1.3.4.1.35Electronics/Avionics Scheduled OverhaulXXX
1.3.4.1.45Other Major Subsystems Scheduled Overhaul 1..n (Specify)XXX
1.3.4.1.55Other Scheduled OverhaulXXX
1.3.4.24Unscheduled Overhaul00X
1.3.4.2.15Airframe/Hull/Vehicle Unscheduled OverhaulXXX
1.3.4.2.25Propulsion Unscheduled OverhaulXXX
1.3.4.2.35Electronics/Avionics Unscheduled OverhaulXXX
1.3.4.2.45Other Major Subsystems Unscheduled Overhaul 1..n (Specify)XXX
1.3.4.2.55Other Unscheduled Unscheduled OverhaulXXX
1.3.63Packing, Handling, Shipping and Transportation (PHS&T)00
1.3.6.14ContainersXX
1.3.6.24TransportationXX
1.42Sustaining Support (System Level Cost Only)00
1.4.13System Specific TrainingXX
1.4.23Support Equipment Replacement and RepairXX
1.4.33Sustaining/Systems EngineeringXX
1.4.43Program Management00
1.4.4.14Contractor Logistics Support (CLS) ManagementXX
1.4.4.24CLS Supply ManagementXX
1.4.4.34Financial/Schedule Planning and ReportingXX
1.4.4.44Transition to Lead ServiceXX
1.4.4.54Quality Assurance (Program Level)XX
1.4.4.64Administrative SecurityXX
1.4.4.74Transition to Performance Based Logistics (PBL)XX
1.4.4.84Risk MitigationXX
1.4.4.94CSDR ReportingXX
1.4.53Data and Technical PublicationsXX
1.4.63Simulator/Training Device Operations and RepairXX
1.4.73Other Sustaining Support (Specify in Remarks)XX
1.52Continuing System ImprovementsXX
Subtotal CostXX
Reporting Contractor G&AXX
Reporting Contractor Undistributed BudgetXX
Reporting Contractor Management ReserveXX
Reporting Contractor FCCMXX
Total CostXX
Reporting Contractor Profit/Loss or FeeXX
Total PriceXX
DRAFT DD FORM 2794 (PAGE 2), REPORTING, JANUARY 2019

DD Form 2794, Pg 3 (EVENTS)

COST AND SOFTWARE DATA REPORTING PLAN
14. CSDR SUBMISSION EVENTS
a.
EVENT IDb.
DATA REPORT(S)c.
SUBMISSION EVENT NAMEd.
REPORT CYCLEe. AS OF DATEf. DUE DATE
(YYYYMMDD)(YYYYMMDD)
1Cost and Hour Report (FlexFile), Quantity Data ReportContract Award (plus 12 months)Interim2025093020251129
2Maintenance and Repair Parts Data ReportContract Award (plus 12 months)Interim2025093020251129
3Cost and Hour Report (FlexFile), Quantity Data ReportAnnual Report - Year 2Interim2026093020261129
4Maintenance and Repair Parts Data ReportAnnual Report - Year 2Interim2026093020261129
5Cost and Hour Report (FlexFile), Quantity Data ReportAnnual Report - Year 3Interim2027093020271129
6Maintenance and Repair Parts Data ReportAnnual Report - Year 3Interim2027093020271129
7Cost and Hour Report (FlexFile), Quantity Data ReportContract CompletionFinal2028093020281129
8Maintenance and Repair Parts Data ReportContract CompletionFinal2028093020281129
DRAFT DD FORM 2794 (PAGE 3), SUBMISSION EVENTS, JANUARY 2019PREVIOUS EDITION IS OBSOLETE

Does Quantity Data Report belong here?

DD Form 2794, Pg 4 (REMARKS)

COST AND SOFTWARE DATA REPORTING PLAN
15. REMARKS
a. CSDR Planning Approach & Preparation Instructions
1. In addition to the direction provided in the associated CSDR Data Item Descriptions (DIDs) and the CSDR Manual (DoDM 5000.04), the following instructions, requirements, and considerations found on this page/worksheet shall be utilized when collecting data and preparing CSDR submissions.
2. This CSDR Contract plan is intended to capture costs associated with the contract number(s) listed in block 9.b. The contractor shall capture and report any and all costs incurred in order to perform the scopes of work on the Contract irrespective of contract type (e.g., firm-fixed price, cost-plus fixed fee) or funding source (i.e., via contract, via contractor internal research & development funds).
3. Costs reported against this CSDR Plan shall be cumulative in nature (i.e., each submission shall report any and all costs incurred on and prior to the submission’s “AS OF DATE” (block 14.e)).
4. Other than the Resource Distribution Table, submission events associated with this CSDR Plan are classified as either "Initial", "Interim", or "Final" submissions as identified in block 14.d of this CSDR Plan.
5. Regarding the WBS Structure (block 11): This CSDR Plan utilizes the Office of the Secretary of Defense Cost Assessment and Program Evaluation Operating and Support Cost-Estimating Guide's Cost Estimating Structure (available here: https://www.cape.osd.mil/files/OS_Guide_Sept_2020.pdf) as the baseline for its WBS which has been extended to provide additional insight into system(s) or subsystem(s) which the Government believes to be high-risk or high-technical-interest in accordance with DoD Manual 5000.04. The contractor shall utilize the definitions found in the Operating and Support Cost-Estimating Guide when mapping its costs into this CSDR plan’s WBS.
i. WBS Element Names (block 11.c) Ending with "1...n (Contractor Shall Specify)": The contractor shall extend and specify (i.e., include additional WBS elements determined by the contractor) in order to provide additional insight into the contractor's technical approach or design. The additional WBS elements shall be developed in accordance with the WBS guidelines included in MIL-STD-881E and DoD Manual 5000.04.
ii. The contractor may extend any WBS element to allow the contractor to provide additional insight into its technical solution. Any and all extensions or tailoring of the WBS shall be in accordance with guidelines included in MIL-STD-881E and DoD Manual 5000.04.
iii. If changes to the contract scope, hours, or options (as applicable) necessitate the need to revise or add additional WBS elements to remain in compliance with the Operating and Support Cost-Estimating Guide's Cost Estimating Structure, MIL-STD-881E, or DoD Manual 5000.04, any associated contract cost/price changes related to the updated CSDR Plan or submission of revised CSDR deliverables, shall be included within the contract modification that awards the changed scope of work, hours, or options (as applicable).
b. Resource Distribution Table
1. Submissions of the Resource Distribution Table (RDT) are required under the following conditions:
i. An RDT shall be delivered seven calendar days before the “Post-Award Cost and Software Data Reporting Conference”. Prepare this submission of the RDT at FAC/EAC value and utilizing the instructions at Block15.a.4.i.This copy of the RDT will be used during the “Post-Award Cost and Software Data Reporting Conference” in order to finalize which subcontractors will be required to provide CSDR reporting via electronic submission of deliverables directly to the Defense Cost and Resource Center (DCARC) and which subcontractors may qualify for a CSDR direct reporting subcontractor waiver.
ii. An RDT shall be delivered within thirty calendar days of the contractor identifying that a subcontractor who, at the time of initial subcontractor award, was not anticipated to qualify for direct subcontractor CSDR reporting via electronic submission of deliverables directly to the DCARC but is subsequently anticipated to meet the CSDR direct reporting subcontractor threshold value due to changes to scopes of work, end-item design, subcontractor/supplier, or subcontract price changes since initial contract award (unless the newly identified subcontractor has already been issued a subcontractor reporting waiver associated with this contract).
c. Submission Dates
1. All CSDR deliverable “AS OF DATE[S]” and “DUE DATE[S]” listed in blocks 14.e and 14.f are identified for planning purposes only. Submission dates are subject to change and are determined in accordance with the event drivers as identified below:
i. Except for the initial submission, all “DUE DATE” requirements are equal to the “AS OF DATE” plus 60 calendar days. The initial submission's "DUE DATE" shall be 90 days after the identified "AS OF DATE". If the calculated “Due Date” does not fall on a regular business day, the “Due Date” will be the next regular business day on the contractor’s accounting calendar.
ii. Initial Submission: Submission events marked as an "Initial" submission in block 14.d. shall have an “AS OF DATE” as of the date of contract award.
iii. Interim Submission(s): Submission events marked as an "Interim" submission in block 14.d shall have an "AS OF DATE" based on the submission event name in block 14.c. For example, if the submission event name was "Contract Award Plus 24 Months" then the submission's "AS OF DATE" is the contract award date plus 24 calendar months. If the submission event name was "Complete Delivery of First Article Test Assets" then the submission's "AS OF DATE" would be the date the final First Article Test Asset was delivered.
iv. Final Submission(s): Submission events marked as "Final" submission in block 14.d shall have an "AS OF DATE" when the following conditions have been met:

1. Condition 1: All end items anticipated to be procured on the contract have been delivered and accepted by the government (e.g., as evidenced by a completed DD Form 250) or higher tier contractor in the case of a subcontractor.

2. Condition 2: 95% or more of all ATD total costs have been incurred relative to all costs the reporting entity expects to incur for each and every Order/Lot (defined in Data Group B, Item 4 of the approved FlexFile DID).

d. Cost and Hour Report (FlexFile) & Quantity Data Report
1. FAC vs EAC: Block 12.e of this CSDR Plan indicate that a "Forecast at Completion" (FAC) is required to be reported in CSDR deliverables. The FAC required is not subject to the standards established in ANSI/EIA-748 guideline #27 (Estimate at Complete); therefore, the FAC does not need to be, but may be, derived from Industry Earned Value Management (EVM) processes.
2. Nonrecurring/Recurring Segregation: The contractor shall utilize the specific definitions and requirements in the CSDR Manual (DoDM 5000.04) and the definitions in the DID for the Cost and Hour Report (FlexFile) report (DI-FNCL-82162) to segregate Recurring and Nonrecurring costs discretely and not as an aggregate.
3. Order Lot Scope: Block 16 of this CSDR Plan is meant to capture the discrete Delivery Orders/Task Orders (as applicable) exercised on the contract.
i. If a Delivery Order/Task Order (as applicable) is exercised on the contract but is not listed in block 16, the contractor shall submit the dollars and hours in the Cost and Hour Report (FlexFile) and the quantity information in the Quantity Report tagged using the name of the Delivery Order/Task Order (as applicable) utilized on the contract. The CSDR Plan will be updated to include the appropriate Delivery Order/Task Order (as applicable) name in block 16, after report submission, if required.
ii. When preparing Cost and Hour Report (FlexFile) and Quantity Data Reports for multi-award actions (e.g., Basic Ordering Agreement, Subsumable Contracts) the parent award number shall be listed in block 9.b., child award/order numbers shall be identified in addition to the Delivery Order/Task Order (as applicable) in block 16, For example, "X12345-21-F-0001 - TO1" would be used to identify the Order Lot for the first task order on child award contract number "X12345-21-F-0001".
4. End Item Scope: Block 17 of this CSDR Plan is meant to capture the discrete hardware end items that are DD-250'ed, ordered, procured, or exercised (as applicable) on the contract (e.g., each NIIN is considered an end item).
i. End Item ID 1: The "Common" end item tag shall be used to report costs and hours which are not incurred or directly attributable to an individual end item. For example, overarching program management costs and hours that are required, independent of the type or quantity of end items on contract would be tagged against the “Common” end item. Common hardware (i.e., identical/homogeneous part numbers) procured and integrated into multiple end items shall utilize the end item tag for the prime product they were integrated onto and shall not be tagged with the “Common” end item.
ii. End Item ID 2 ...n: The contractor shall submit the dollars and hours in the Cost and Hour Report (FlexFile) and the quantity information in the Quantity Data Report (if required) by NIIN or Kit and each NIIN or Kit shall be tagged as its own End Item. Utilize the NIIN number as the End Item ID and utilize the NIIN nomenclature as the End Item Name; utilize the Kit's part number as the End Item ID and the Kit's name as the End Item Name.
5. The contractor shall provide unit reporting for any given Order/Lot and End Item name as outlined in block 18 of this CSDR Plan. If Unit Reporting is selected in block18.c (Unit Reporting), it is expected that all touch labor costs and hours that are associated with the discrete units or sublots be tagged as Touch Manufacturing or Touch Maintenance as defined in DI-FNCL-82162, Data Group E, Item 7.
6. In addition to the data required by the Cost and Hour Report (FlexFile) report (DI-FNCL-82162), the contractor shall provide the following within the remarks section of the CSDR deliverable:
i. The contractor shall provide a description of the type and timing of all impacts to program schedule, incurred actual costs, and forecasted at complete costs, in process quantities, and delivered quantities which are directly attributable to the COVID-19 pandemic: provide general impacts within the Summary Remark; provide impacts to specific WBS Elements or Functional Elements within the WBS Element Definitions and Remarks by DD FORM 2794 WBS Element. If applicable, the contractor shall provide an explanation of any new charge codes, work packages, control accounts, pricing categories, or other methods explicitly utilized to capture impacts of COVID-19. Note any relevant information that could be used in the interpretation of the data. If applicable, the contractor shall utilize a “Tag” or the “Additional Data Field” referenced in Section B of the FlexFile DID (DI-FNCL-82162) to identify COVID-19 related data.
ii. The contractor shall provide a copy of the contract, contract section, or contract attachment (as applicable) that identifies the kinds and quantities of NIINs the government has procured and/or are on order on the Cost and Hour Report (FlexFile)'s as-of date along with the Cost and Hour Report (FlexFile) and Quantity Data Report submission. This supporting file will be utilized by the government to ensure the list of End Item NIINs reported in the Cost and Hour Report (FlexFile) and Quantity Data Report is complete and accurate.
iii. If the contract is a Performance Based Logistics contract, the contractor shall provide the performance metric(s) on contract (e.g., availability, reliability, flying hours, steaming hours, turnaround time, and parts order time) as well as achieved level(s) of performance within the submission remarks of the Cost and Hour Report (FlexFile).
iv. If identified on the contract, provide the number of systems supported and number of repairs performed. T
v. If identified on the contract, the nominal capacity (e.g., the # of repairs, # of overhauls, # of flight hours, etc.) planned for each Delivery Order/Task Order (as applicable). This requirement is intended to capture what services are being bought with each effort.
vi. Other than NIINs (which are required to be listed and reported via their own End Items) the contract shall provide a description within the remarks section of each WBS element which identifies the kinds and quantity of equipment repaired, replaced, modified, or procured and reported in the WBS element.
e. Period Of Performance & Additional Scope Of Work
1. If the Contract period of performance is extended by more than six months, or if the scope of work is modified to include work not otherwise covered by the CSDR Plan, the government may modify the CSDR Plan to require additional submission events and add additional WBS elements in order to ensure the accurate and complete collection of cost data associated with the modified contract. Depending on the scope and complexity of the contract modification, the contractor may be required to host or attend an additional Post-Award Cost and Software Data Reporting Conference to review the CSDR Plan changes and the contractor’s plan to collect and report costs associated with the additional scope of work.
f. Cost Accounting Standards (CAS) Disclosure Statement Differences
1. The contractor shall follow the accounting procedures specified in its latest approved CAS Disclosure Statement and with any clauses or requirements included in the contract. As part of the Post-Award Cost and Software Data Reporting Conference, the contractor shall identify any aspect(s) of its latest approved CAS Disclosure Statement which preclude or inhibit compliance with this CSDR Plan and DoD 5000.04 (CSDR Manual). The contractor shall identify any deviations from its CAS disclosure statement it intends to utilize to prepare CSDR submissions.
g. Nonrecurring/Recurring Segregation
1. The contractor shall utilize the specific definitions and requirements in the CSDR Manual (DoDM 5000.04) and the definitions in the DID for the Cost and Hour Report (FlexFile) report (DI-FNCL-82162) to segregate Recurring and Nonrecurring costs discretely and not as an aggregate.
h. CSDR Readiness Review
1. The contractor shall host a CSDR Readiness Review (CSDR-RR) at the contractor’s facility where CSDRs are prepared with the Government’s Cost Working Group Integrated Product Team (CWIPT) IAW DFARS 242.503-2(b) and DoD Manual 5000.04 (CSDR Manual). The purpose of the CSDR-RR is to review the contract’s CSDR requirements and assess how the Contractor’s accounting system satisfies the CSDR requirements found in DoD 5000.04 (CSDR Manual) and this CSDR Plan. In a briefing presented by the Contractor in its own format, the Contractor shall:

- Demonstrate how it collects cost data in its accounting system and how that data will be utilized to provide actual cost transactions and minimize cost allocations when preparing CSDR data deliverables.

- Describe how recurring vs. nonrecurring costs are segregated in its accounting system and for the purpose of CSDR reporting.

- Demonstrate how the data from its accounting system will be mapped into the CSDR reports required by this CSDR Plan and associated CDRLs.

- Present the methodologies used for mapping internal cost accounts to the WBS, specifically showing how individual WBS elements and functional element codes will be populated.

- Propose any changes to this CSDR Plan in order to tailor the plan to the contractor's accounting system to include any contractor recommended changes or additions to the WBS elements. These changes may include adjustments to the submission events and/or submission timelines, particularly in the case of a direct-reporting subcontractor performing against a different delivery schedule than the associated prime contractor.

The contractor and CWIPT will also review the initial submission of the "Resource Distribution Table (RDT)", in order to finalize which subcontractors will be required to provide CSDR reporting and electronic submission of deliverables directly to the Defense Cost and Resource Center (DCARC) and which subcontractors may qualify for a CSDR direct reporting subcontractor waiver.

The CSDR-RR shall be held within 60 days of contract award or the start of work meeting on a date mutually agreed to by the CWIPT and the contractor. This meeting has an anticipated duration of one business day.

DRAFT DD FORM 2794 (PAGE 4), REMARKS, JANUARY 2019 PREVIOUS EDITION IS OBSOLETE

DD Form 2794, Pg 5 (SCOPE DEF)

COST AND SOFTWARE DATA REPORTING PLAN
INTRA-CONTRACT SCOPE REPORTING DEFINITION
16. ORDERS/LOTS
a. IDb. NAMEc. PHASE/MILESTONE
DO1Delivery Order 1O&S
DO2Delivery Order 2O&S
DO3…nDelivery Order 3…nO&S
17. END ITEMS
a. IDb. NAME
1Common
1615-01-512-0889Rotary Wing Head
...n(See Block 15.d.4 within this CSDR Plan)
18. OPTIONAL REQUIREMENTS
a. ORDER/LOT IDb. END ITEM IDc. UNIT REPORTING
(X if applicable)d. SEQUENCING

(X if applicable)

DRAFT DD FORM 2794 (PAGE 5), INTRA-CONTRACT SCOPE, JANUARY 2019

File details come from the government source that posted it. Updated .