Attachment_2_DBD_CCDR_RFP_Data_Request.xlsx

XLSX spreadsheet 101 KB Posted

Attached to
Dual Band Decoy BAA Federal contract opportunity
Solicitation number
N0001918R0086
Issued by
Department of the Navy Naval Air Systems Command Naval Air Warfare Center

View the file

Other files for this federal contract opportunity

Other files attached to Dual Band Decoy BAA, newest first.
File Type Posted
DBD_DET_FINAL_BAA_QAs_Answers_9-10.pdf PDF
Final_DBD_DET_BAA_v2.docx DOCX document
DBD_DET_FINAL_BAA_QAs_Answer_7.pdf PDF
DBD_DET_FINAL_BAA_QAs_Answers_4-6.pdf PDF
Final_DBD_DET_BAA_v1.docx DOCX document
DBD_DET_FINAL_BAA_QAs_Answers_1-3.pdf PDF
DFARS_227.7103-7_NDA.docx DOCX document
Final_DBD_DET_BAA.docx DOCX document
Attachment_1_DBD__Model_Contract_FINAL_110818.docx DOCX document

On GovTribe

Work with this file on GovTribe

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

Text version

Guide

COLOR KEY / TABS

Input Expand WBS as necessary and specify Hardware Modules or CSCIs as required for the proposed program

Traceability Matrix Identify BOE # and WBS reporting element mappings/definitions

CCDR SummaryIdentify quantities associated with the proposed lot in column D
Provide program information to include period of performance, contract type and number, as well as program completion percentage
Bucket the proposed values using the MIL-STD WBS; values should be reported in yellow cells

SEPM Hours by Month Provide proposed SEPM by month. Make the necessary adjustments to column B to align with the POP timeline.

SLOC Provide the software SLOC and hours for the proposed CSCI's

Module Design Provide the details related to the modules that will change or be re-designed

Vendor ListSummary of Vendors over TINA and the Suppliers in the BOM
BOM ExampleCost build up by Part Number, WBS, and Supplier

These WBS reporting elements do not align directly with the CSDR format. The reporting elements have been adjusted to collect the necessary information needed to evaluate the proposal.

Input

KEY:
Contractor InputSpecify reporting elements specific to the proposed approach using the yellow cells below.
Expand the table as necessary.
Recommended WBS is based on the MIL-STD 881 (Appendix B). The MIL-STD can be located at the following DCARC site: http://cade.osd.mil.
WBS CodeReporting ElementDictionary
ADual Band Decoy (DBD)Cost roll up of WBS AA, AB, AC, AD, AE, AF, AG, AH, AI, AJ, AK, AL
AADual Band Decoy (DBD) Prime Mission Product (PMP)Cost roll up of WBS AAA, AAB, AAC, AAD, AAE
AAADBD Module 1 HardwareIdentify Module 1 applicable to the DBD PMP (cost roll up AAAA, AAAB, AAAC)
AAAALabor DollarsAccounts for Direct Labor Dollars + Overhead Dollars for all functional labor categories that fall under "Module 1".
AAABMaterial DollarsAccounts for all Direct Materials (Raw, Purchased Parts, Purchased Equipment, and Subcontracts) as well as Material Handling Overhead dollars related to "Module 1".
AAACOther Costs Not Shown ElsewhereAny other costs that are tied to "Module 1" which are not previously reported in the Labor or Material reporting elements (i.e. Travel, Other Charges)
AABDBD Module 2 HardwareIdentify Module 2 applicable to the DBD PMP (cost roll up AABA, AABB, AABC)
AABALabor DollarsAccounts for Direct Labor Dollars + Overhead Dollars for all functional labor categories that fall under "Module 2".
AABBMaterial DollarsAccounts for all Direct Materials (Raw, Purchased Parts, Purchased Equipment, and Subcontracts) as well as Material Handling Overhead dollars related to "Module 2".
AABCOther Costs Not Shown ElsewhereAny other costs that are tied to "Module 2" which are not previously reported in the Labor or Material reporting elements (i.e. Travel, Other Charges)
AACDBD Module 3 HardwareIdentify Module 3 applicable to the DBD PMP (cost roll up AACA, AACB, AACC)
AACALabor DollarsAccounts for Direct Labor Dollars + Overhead Dollars for all functional labor categories that fall under "Module 3".
AACBMaterial DollarsAccounts for all Direct Materials (Raw, Purchased Parts, Purchased Equipment, and Subcontracts) as well as Material Handling Overhead dollars related to "Module 3".
AACCOther Costs Not Shown ElsewhereAny other costs that are tied to "Module 3" which are not previously reported in the Labor or Material reporting elements (i.e. Travel, Other Charges)
AADDBD SoftwareCost roll up of AADA, AADB, AADC
AADACSCI 1Identify specific CSCIs applicable to the DBD PMP
AADBCSCI 2Identify specific CSCIs applicable to the DBD PMP
AADCCSCI 3Identify specific CSCIs applicable to the DBD PMP
AAEDBD Integration, Assembly, Test and CheckoutAccounts for all costs related to the Integration, Assembly, Test and Checkout line item.
ABPlatform IntegrationAccounts for all costs related to the Platform Integration line item.
ACSystem EngineeringAccounts for Direct Labor Dollars + Overhead Dollars for all functional labor categories that fall under System Engineering.
ADProgram ManagementAccounts for Direct Labor Dollars + Overhead Dollars for all functional labor categories that fall under Program Management.
AESystem Test and EvaluationAccounts for all costs related to the System Test and Evaluation line item.
AFTrainingAccounts for all costs related to the Training line item.
AGDataAccounts for all costs related to the Data line item.
AHPeculiar Support EquipmentAccounts for all costs related to the Peculiar Support Equipment line item.
AICommon Support EquipmentAccounts for all costs related to the Common Support Equipment line item.
AJOperational/Site ActivationAccounts for all costs related to the Operational/Site Activation line item.
AKIndustrial FacilitiesAccounts for all costs related to the Industrial Facilities line item.
ALInitial Spares and Repair PartsAccounts for all costs related to the Initial Spares and Repair Parts line item.

Traceability Matrix

BOE #WBS CodeWBS Element NameCWBS Definition
ADual Band Decoy (DBD)
AADual Band Decoy (DBD) Prime Mission Product (PMP)
AAADBD Module 1 Hardware
AAAALabor Dollars
AAABMaterial Dollars
AAACOther Costs Not Shown Elsewhere
AABDBD Module 2 Hardware
AABALabor Dollars
AABBMaterial Dollars
AABCOther Costs Not Shown Elsewhere
AACDBD Module 3 Hardware
AACALabor Dollars
AACBMaterial Dollars
AACCOther Costs Not Shown Elsewhere
AADDBD Software
AADACSCI 1
AADBCSCI 2
AADCCSCI 3
AAEDBD Integration, Assembly, Test and Checkout
ABPlatform Integration
ACSystem Engineering
ADProgram Management
AESystem Test and Evaluation
AFTraining
AGData
AHPeculiar Support Equipment
AICommon Support Equipment
AJOperational/Site Activation
AKIndustrial Facilities
ALInitial Spares and Repair Parts

CCDR Summary

PROPOSED
Contract Type
Contract Number/Solicitation Number
Period of Performance Start Date
Period of Performance End Date
Cumulative Qty Made in Past

(all customers for this Item)

Quantity this Contract
Target Cost
Target Price
Target Profit
Percent Complete
Costs Table
PROPOSED
WBS

ELEMENT

CODE WBS REPORTING ELEMENTS NUMBER OF

UNITS AT

COMPLETIONCOSTS INCURRED AT COMPLETION (U.S. Dollars)
Non-RecurringRecurringTOTAL
ADual Band Decoy (DBD)$0.0$0.0$0.0
AADual Band Decoy (DBD) Prime Mission Product (PMP)$0.0$0.0$0.0
AAADBD Module 1 Hardware$0.0$0.0$0.0
AAAALabor Dollars$0.0
AAABMaterial Dollars$0.0$0.0
AAACOther Costs Not Shown Elsewhere$0.0
AABDBD Module 2 Hardware$0.0$0.0$0.0
AABALabor Dollars$0.0
AABBMaterial Dollars$0.0$0.0
AABCOther Costs Not Shown Elsewhere$0.0
AACDBD Module 3 Hardware$0.0$0.0$0.0
AACALabor Dollars$0.0
AACBMaterial Dollars$0.0$0.0
AACCOther Costs Not Shown Elsewhere$0.0
AADDBD Software$0.0$0.0$0.0
AADACSCI 1$0.0
AADBCSCI 2$0.0
AADCCSCI 3$0.0
AAEDBD Integration, Assembly, Test and Checkout$0.0
ABPlatform Integration$0.0
ACSystem Engineering$0.0$0.0
ADProgram Management$0.0
AESystem Test and Evaluation$0.0
AFTraining$0.0
AGData$0.0
AHPeculiar Support Equipment$0.0
AICommon Support Equipment$0.0
AJOperational/Site Activation$0.0
AKIndustrial Facilities$0.0
ALInitial Spares and Repair Parts$0.0
Subtotal Cost$0.0$0.0$0.0
G&AReporting Contractor G&A
UDBReporting Contractor Undistributed Budget
MRReporting Contractor Management Reserve
FCCMReporting Contractor FCCM
Total Cost$0.0

FEE Reporting Contractor Profit/Loss or Fee

Total Price $0.0

22. REMARKS

Labor Hours Table

WBS

ELEMENT

CODEWBS REPORTING ELEMENTSPROPOSED
PROPOSED
AB
Non-RecurringRecurring
ADual Band Decoy (DBD)- 0- 0
AADual Band Decoy (DBD) Prime Mission Product (PMP)- 0- 0
AAADBD Module 1 Hardware- 0
AABDBD Module 2 Hardware- 0
AACDBD Module 3 Hardware- 0
AADDBD Software- 0- 0
AADACSCI 1- 0
AADBCSCI 2- 0
AADCCSCI 3- 0
ABPlatform Integration
ACSystem Engineering- 0
ADProgram Management
AESystem Test and Evaluation
AFTraining
AGData
AHPeculiar Support Equipment
AICommon Support Equipment
AJOperational/Site Activation
AKIndustrial Facilities
ALInitial Spares and Repair Parts
Subtotal

SEPM Hours by Month

Proposed

% Complete
EXAMPLE
Feb-2012
Mar-2012
Apr-2012
May-2012
Jun-2012
Jul-2012
Aug-2012
Sep-2012
Oct-2012
Nov-2012
Dec-2012
Jan-2013
Feb-2013
Mar-2013
TOTAL hrs0.00
TOTAL Cost
SEPM POP
Specify proposed hours per month
SEPM POP (total months)

SLOC

In attempt to compare the software hours to NAVAIR datasets we want to ensure we are making comparisons accurately. Please identify any hours associated with NAVAIR software elements (listed below) that are captured elsewhere in the proposal if not included within the Software hours line.

NAVAIR datasets include the following elements:

- Software Coding and Testing
- Software Requirements Analysis
- Software Architecture Analysis
- Software Detailed Design
- Software Integration
- Software Qualification Testing
- System Integration

Elements not included in NAVAIR datasets :

- System Requirements Analysis
- System Architectural Analysis
- System Qualification Testing
- Software Installation
- Software Acceptance Support
Mod Code effortReuse Code effort
CSCINewModReuseAutoCOTSLanguageMod Design %Mod
Code %Mod Retest %Reuse Design %Reuse Code %Reuse Retest %
Design %Code %Test %Effort Sum Check
Design %Code %Test %Effort Sum CheckCode Complexity SimpleCode Complexity RoutineCode Complexity ComplexComplexity sum check

Jennifer.Meredith: Jennifer.Meredith:

This cell turns red if the sum of simple, routine and complex code does not equal 100%Total Software Hours Proposed
Dataset Example15%15%15%7%7%7%40%30%30%100%40%30%30%100%100%0%0%100%
CSCI 1 (specify)0%0%0%0%0%0%
CSCI 2 (specify)0%0%0%0%0%0%
CSCI 3 (specify)0%0%0%0%0%0%
0%0%0%0%0%0%
0%0%0%0%0%0%
0%0%0%0%0%0%
0%0%0%0%0%0%
0

Instructions Enter the logical Source Lines of Code (SLOC)

New - This is the amount of new code defined for the CSCI.

Mod – This is the amount of modified code defined for the CSCI.

Reuse – This is the amount of reuse code defined for the CSCI. Reuse code is different from Commercial Off-The-Shelf (COTS) code. Reuse typically comes from a previous weapon system development with limited applicability to a broad spectrum of users. The goal is to use the code without modification, however it must be retested in the new application environment. Frequently there will be some minor redesign and recode required to make the reuse code function in the new environment.

COTS – This is the amount of COTS code defined for the CSCI. COTS is not meant to cover things like the size of an Operating System (like Linux or MS-DOS). Rather it is applications software that meets a functional need of the program. For our purposes this is considered unmodified COTS. Any COTS that requires “tweaking” or modification is not COTS and should be treated as reuse or modified depending on the amount of modification required.

i.e., ADA, Assembly, C, C++, COBOL, Fortran, etc Mod Design % - This factor should reflect the amount of redesign that needs to take place for the code to be modified relative to designing it new. Note that this is effort and not lines of code. The amount of design effort required is often disproportionately higher than the amount of effort to recode the software. This is driven by unfamiliarity with the modified code, quality of the donor code, and how closely the new requirements match the original codes functionality.

Mod Code % - This factor reflects the amount of effort required to code the modified software relative to writing it as new. Frequently the amount of recoding required is higher, sometimes much higher, than the redesign %.

Reuse Design % - This factor reflects the amount of effort the design community will spend familiarizing themselves with the reuse code relative to having designed it new. Even code that will be completely untouched requires design effort to research and validate the code application.

Reuse Code % - This factor reflects the amount of effort required to code the reused software relative to writing it as new. It is rare that code can be truly reused without some minor coding effort.

Design % - This factor should reflect the amount of effort that needs to take place for the code to be designed/redesigned.

Code % - This factor reflects the amount of effort required to code the software.

Test % - This factor reflects the amount of effort required to test/retest the software. Simple - Code that performs easily tested functions, has generally linear inputs and outputs, i.e. linear domain & range relationships, single SW & hardware relationship, and performs simplistic data management functions like look up tables or library functions. The main difference between simple and routine code is the relative degree of testing required to determine code functionality. Simple code can consist of simulation, maintenance, data handling, or human interface components.

Routine - Code that has multiple input and output paths requiring a moderate degree of testing to certify functionality, maybe newly written or adaption of existing code from other DOD programs and generally performs non real time, non algorithm intense functions like simulation, tools, maintenance, Graphical User Interface (GUI) or data handling. Code is rarely constrained by the operating environment.

Complex - Code that has a very high number of input and output paths making it very difficult to test, may perform real time mathematical intense functions, maybe constrained by the operating environment, maybe written in a highly secure environment, or involves new or novel algorithms or applications. Complex code tends to be found in functions that emulate or interface with the physical world, i.e. radar signal processing, missile detection, data links protocol implementation, and electronic warfare. Human interface is infrequent with this type of code. Key to identifying complex code is the difficulty in verifying and validating the code in a laboratory environment. This should be the total Software hours proposed as compared to NAVAIR datasets for an apples to apples comparison.

Module Design

Module Name (SRA)Module TypeModule FunctionNew/Mod/COTS% Modification RequiredBrief Description of ModificationHours Proposed* Please provide details related to the modules that will change or be re-designed
Specify NameModule 1
Specify NameModule 2
Specify NameModule 3
0Total Hours
Instructionsi.e. Power, Analog, Digital, RFBrief description of moduleThis would be the percent of the module that needs to be modified as compared to if it was brand new.What work is being done? What is changing?

Vendor List Summary

Supplier NameSum of BOM% of BOM
$ - 0ERROR:#DIV/0!* Summary roll of all BOM Suppliers; identifies over TINA Suppliers
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0ERROR:#DIV/0!
$ - 0
WBSWBS DescriptionTotal BOM Value
AAADBD Module 1 Hardware$ - 0
AABDBD Module 2 Hardware$ - 0
AACDBD Module 3 Hardware$ - 0

$ - 0

BOM Example CLIN SOW Paragraph WBS Part Number Description EST Method Bullard, Michelle A CIV NAVAIR 4.2: Estimating Method used -

For example:

- Quote (Q)

- Purchase Order (PO)

- Estimate (E)

- Long Term Agreement (LTA) Validity Date / Expiration Date Bullard, Michelle A CIV NAVAIR 4.2:

When do quotes/LTAs expire?

If Estimating Method was PO history, what was the date the part was procured? Supplier Name Qty Unit Cost Extended Escalation Factor Bullard, Michelle A CIV NAVAIR 4.2:

If ApplicableMaterial w/EscalationScrap Factor
Bullard, Michelle A CIV NAVAIR 4.2: Scrap or Attrition FactorsMaterial w/ ScrapMin Buy QtyMin Buy ChargesTooling/NRE/Other ChargesTotal Extended CostCAGE CodesPO #

File details come from the government source that posted it.