Attachment 4 Section L Attachments (Amendment1).xlsx

XLSX spreadsheet 82 KB Posted Aug 9, 2018

Attached to: Optical Communications (OCOMMS) Air-Water Interface (AWI) Demonstration System
Solicitation number: N00039-17-R-0005
Issued by: Department of the Navy Information Warfare Systems Command

View the file

Other files

File	Type	Posted
Attachment 9 OCOMMS CDRLS-20170727093503.pdf	PDF	Aug 9, 2018
Attachment 3 DD254 N00039-17-R-0005.pdf	PDF	Aug 9, 2018
N00039-17-R-0005-02.pdf	PDF	Aug 9, 2018
N00039-17-R-0005-01Posted to e-commerce.pdf	PDF	Aug 9, 2018
Posted Q&As 11-1-17.pdf	PDF	Aug 9, 2018
Attachment 6 OCOMMS Compliance Traceablity Matrix.xlsx	XLSX spreadsheet	Aug 9, 2018
OCOMMS NDA.pdf	PDF	Aug 9, 2018
NESI Collaborative Site Access Request - V3.pdf	PDF	Aug 9, 2018
Attachment 1 OCOMMS SOW.pdf	PDF	Aug 9, 2018
Attachment_7_Relevant_Experience_Form.pdf	PDF	Aug 9, 2018
N00039-17-R-0005 OCOMMS RFP FINAL.pdf	PDF	Aug 9, 2018
Attachment_8_Past_Performance_Questionnaire.pdf	PDF	Aug 9, 2018
Attachment 5 Labor Qualification Self Certification.pdf	PDF	Aug 9, 2018
Attachment 10 Data Rights Matrix.pdf	PDF	Aug 9, 2018

Show all 14

On GovTribe

Work with this file

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

L-1 WBS

Total Price
WBS #	Task Name	Hours	Labor Rate	Labor Dollars	Material	ODC	Total
1: CLIN 0001	OCOMMS AWI AIRBORNE DEMONSTRATION SYSTEM	0		$0	$0	$0	$0
1.1	Development of AWI Airborne Demo System						0
1.1.1	Pointing and Tracking System						0
1.1.1.1	Environmental Enclosure			$0			$0
1.1.1.2	Tracking System			$0			$0
1.1.1.3	Pointing System			$0			$0
1.1.2	OCOMMS Payload
1.1.2.1	EO Imaging System			$0			$0
1.1.2.2	Transmitter						$0
1.1.2.3	Receiver						$0
1.1.3	System Controller			$0			$0
1.1.4	System Cables			$0			$0
1.1.5	Shipping Container			$0			$0
1.2	Integration and Assembly
1.2.1	SubSystem Integration and Assembly			$0			$0
1.2.2	System Integration and Assembly and Test			$0			$0
1.3	Systems Engineering						$0
1.3.1	System Requirements Review			$0			$0
1.3.2	Preliminary Design Review			$0			$0
1.3.3	Critical Design Review			$0			$0
1.3.4	Test Readiness Review			$0			$0
1.3.5	System Engineering			$0			$0
1.4	System Test and Evaluation
1.4.1	System Test
1.4.1.1	Test Plan & Procedure Development (DVT)			$0			$0
1.4.1.2	Acceptance Testing			$0			$0
1.4.1.3	DVT Testing			$0			$0
1.4.2	Test Facilities/Equipment			$0			$0
1.5	Data			$0			$0
1.6	Program Management			$0			$0
1.6.1	Program Management			$0			$0
1.6.2	Financial Management			$0			$0
1.6.3	Subcontracts Management			$0			$0
1.6.4	Meetings			$0			$0

WBS #	Task Name	GFY 1				Total
2: Contractor Demonstration Support	Provisioning Item Order (PIO) Total (CLINs ….)	0.00	$0	$0	$0	$0
2.1	Onsite Support - SSC PAC
2.2	Onsite Support - West Coast Test Location
2.3	Program Management

UNCLASSIFIED - Competition Sensitive &A &D

&F - Page &P UNCLASSIFIED - Competition Sensitive

L-2 WBS Dictionary

WBS	WBS DESCRIPTION	DEFINITION
1	CLIN 0001 - OCOMMS AWI AIRBORNE DEMONSTRATION SYSTEM	This WBS element is a roll-up of costs associated with all lower levels required for CLIN 0001 to complete of the design, development, fabrication, and testing of the OCOMMS AWI Airborne Demonstration System, including Design Reviews and Program Management
1.1	DEVELOPMENT OF AWI AIRBORNE DEMO SYSTEM	This WBS element is a roll-up of costs associated with the design and development of the OCOMMS AWI Airborne Demonstration System, including the requirements specified in the OCOMMS Performance Specification - SPAWAR-S-OCOMMS001, Sections 3.2.1, 3.4, 3.7, and 3.2.8
1.1.1	POINTING AND TRACKING SYSTEM	This WBS element is a roll-up of costs associated with the design and development of the Pointing and Tracking System
1.1.1.1	ENVIRONMENTAL ENCLOSURE	This WBS element includes labor, material and ODC, as required, to complete the design and development of components/subsystems, as specified in the OCOMMS Performance Specification - SPAWAR-S-OCOMMS001 Sections 3.2.3, 3.5 and 3.6
1.1.1.2	TRACKING SYSTEM	This WBS element includes labor, material and ODC, as required, to complete the design and development of components/subsystems for the Tracking System, as specified in the OCOMMS Performance Specification - SPAWAR-S-OCOMMS001, Section 3.3.2.4.
1.1.1.3	POINTING SYSTEM	This WBS element includes labor, material and ODC, as required, to complete the design and development of components/subsystems of the Pointing System, as specified in the OCOMMS Performance Specification - SPAWAR-S-OCOMMS001, Section 3.3.1.
1.1.2	OCOMMS PAYLOAD	This WBS element is a roll-up of costs associated with the design and development of the OCOMMS Payload as specified in the OCOMMS Performance Specification - SPAWAR-S-OCOMMS001, Section 3.3.2
1.1.2.1	EO IMAGING SYSTEM	This WBS element includes labor, material, and ODC, as required, to complete the design and development of the EO Imaging System, as specified in the OCOMMS Performance Specification - SPAWAR-S-OCOMMS001, Section 3.3.2.1
1.1.2.2	TRANSMITTER	This WBS element includes labor, material, and ODC, as required, to complete the design and development of components/subsystems of the Transmitter, as specified in the OCOMMS Performance Specification - SPAWAR-S-OCOMMS001, Section 3.3.2.2
1.1.2.3	RECEIVER	This WBS element includes labor, material, and ODC, as required, to complete the design and development of components/subsystems of the Receiver, as specified in the OCOMMS Performance Specification - SPAWAR-S-OCOMMS001, Section 3.3.2.3
1.1.3	SYSTEM CONTROLLER	This WBS element includes labor, material, and ODC, as required, to complete the design and development of components/subsystems of the System Controller, as specified in the OCOMMS Performance Specification - SPAWAR-S-OCOMMS001, Sections 3.2.2, 3.2.5, 3.2.6, and 3.2.7
1.1.4	SYSTEM CABLES	This WBS element includes labor, material, and ODC, as required, to complete the design and development of System Cables, as specified in the OCOMMS Performance Specification - SPAWAR-S-OCOMMS001, Section 3.2.4
1.1.5	SHIPPING CONTAINER	This WBS element includes labor, material, and ODC, as required, to complete the design and development of the Shipping Container in the OCOMMS Performance Specification - SPAWAR-S-OCOMMS001, Section 5
1.2	INTEGRATION AND ASSEMBLY	This WBS element is a roll-up of costs associated with the integration and assembly of subsystems and the OCOMMS AWI Airborne Demo System
1.2.1	SUBSYSTEM INTEGRATION AND ASSEMBLY	This WBS element includes labor, material and ODC, as required, to complete the integration and assembly of the OCOMMS AWI Demonstration System subsystems
1.2.2	SYSTEM INTEGRATION AND ASSEMBLY AND TEST	This WBS element includes labor, material and ODC, as required, to complete the integration and assembly of subsystems to the OCOMMS AWI Demonstration System Level in preparation for Acceptance Testing
1.3	SYSTEMS ENGINEERING	This WBS element is a roll-up of costs associated with Systems Engineering Support required for the duration of the execution of CLIN 0001, including all Technical reviews.
1.3.1	SYSTEMS REQUIREMENT REVIEW (SRR)	This WBS element includes the preparation, participation and follow-up to the SRR as defined in the OCOMMS AWI Demonstration System SOW, Section 3.1.9.1. This scope includes the preparation of presentation materials, development of meeting minutes and action items, as well as resolution of action items.
1.3.2	PRELIMINARY DESIGN REVIEW (PDR)	This WBS element includes the preparation, participation and follow-up to the PDR as defined in the OCOMMS AWI Demonstration System SOW, Section 3.1.9.2. This scope includes the preparation of presentation materials, development of meeting minutes and action items, as well as resolution of action items.
1.3.3	CRITICAL DESIGN REVIEW (CDR)	This WBS element includes the preparation, participation and follow-up to the CDR as defined in the OCOMMS AWI Demonstration System SOW, Section 3.1.9.3. This scope includes the preparation of presentation materials, development of meeting minutes and action items, as well as resolution of action items.
1.3.4	TEST READINESS REVIEW (TRR)	This WBS element includes the preparation, participation and follow-up to the TRR as defined in the OCOMMS AWI Demonstration System SOW, Section 3.1.11.2. This scope includes the preparation of presentation materials, development of meeting minutes and action items, as well as resolution of action items.
1.3.5	SYSTEM ENGINEERING	This WBS element includes costs associated with System Engineering support for the duration of CLIN 0001
1.4	SYSTEM TEST AND EVALUATION	This WBS element is a roll-up of costs associated with test and evaluation of the OCOMMS AWI Airborne Demonstration System, including test plan and procedure development, testing of the system, and, if required, development of test fixtures/equipment and/or use of outside test facilities.
1.4.1	SYSTEM TEST	This WBS element is a roll-up of costs associated with test and evaluation of the OCOMMS AWI Airborne Demonstration System, including test plan and procedure development and testing of the system.
1.4.1.1	TEST PLAN AND PROCEDURE DEVELOPMENT (DVT)	This WBS element includes the development of the Draft and Final DVT Test Plan and Procedures as specified in SOW Sections 3.1.11.1
1.4.1.2	ACCEPTANCE TESTING	This WBS element includes labor, material, and ODC, as required, to complete System Level testing as defined in OCOMMS Performance Specification - SPAWAR-S-OCOMMS001, Section 4.1
1.4.1.3	DVT TESTING	This WBS element includes labor, material, and ODC, as required, to complete the DVT Testing as defined in the OCOMMS AWI Demonstration System SOW, Section 3.1.11.3
1.4.2	TEST FACILITIES/EQUIPMENT	This WBS element includes labor, material and ODC for the development of test fixtures/equipment and/or use of outside test facilities, if required. The test facilities/equipment is in support of testing as defined in the OCOMMS AWI Demonstration System SOW, Section 3.1.11.3 and in the OCOMMS Performance Specification - SPAWAR-S-OCOMMS001, Section 4.1
1.5	DATA	This WBS element is a roll-up of costs associated with development and consolidation of Technical Data Deliverables as defined in the OCOMMS AWI Demonstration System SOW. THis includes, but is not limited to, the Technical Data Package (TDP) and DVT Test Report as defined in the OCOMMS AWI Demonstration System SOW, Sections 3.1.13 and 3.1.11.4, respectively.
1.6	PROGRAM MANAGEMENT	This WBS element is a roll-up of costs associated with program management support for the duration of CLIN 0001.
1.6.1	PROGRAM MANAGEMENT	This WBS element includes costs associated with program management support for the duration of CLIN 0001 as identified in the OCOMMS AWI Demonstration System SOW, Sections 3.1.1, 3.1.2, 3.1.3, 3.1.7, and 3.1.8.
1.6.2	FINANCIAL MANAGEMENT	This WBS element includes costs associated with financial management support for the duration of CLIN 0001 as identified in the OCOMMS AWI Demonstration System SOW, Sections 3.1.1 and 3.1.4
1.6.3	SUBCONTRACTS MANAGEMENT	This WBS element includes costs associated with managing subcontractors supporting the OCOMMS project.
1.6.4	MEETINGS	This WBS element includes costs associated with conducting/supporting internal and external meetings, excluding the Technical Reviews identified in WBS 1.3. This includes the preparation, participation and follow-up to the CPAC and TIMs as defined in the OCOMMS AWI Demonstration System SOW, Sections 3.1.5 and 3.1.6.

2	CLIN 1001 - OCOMMS DEMONSTRATION SUPPORT	This WBS element is a roll-up of costs associated with all lower levels required for CLIN 1001 support of the post-delivery test and demonstration of the OCOMMS AWI Airborne Demonstration System, including Program Management
2.1	ONSITE TEST SUPPORT - SSC PAC	This WBS element include labor, material, travel and ODC, as required, to complete the 4 weeks of onsite support at SPAWAR Systems Center, Pacific in San Diego CA for 2 people. This also includes the development of the Trip Report as defined in the OCOMMS AWI Demonstration System SOW, Section 3.2
2.2	ONSITE TEST SUPPORT - WEST COAST TEST LOCATION	This WBS element include labor, material, travel and ODC, as required, to complete the 4 weeks of onsite support at West Coast test range for 2 people. This also includes the development of the Trip Report as defined in the OCOMMS AWI Demonstration System SOW, Section 3.2
2.3	PROGRAM MANAGEMENT	Program management support for the duration of CLIN 1001. This includes, but is not limited to status reports, financial reporting, ad-hoc telecons, and contracts support.

L-3 BOM

L-3 BILL OF MATERIAL

		Bill of Material
		WBS #	WBS ELEMENT	Item
Description	VENDOR	Type of Business	CAGE Code	Basis of Price	Basis of RQMT	Sole Source/Comp/ Make	Cost Category	Quantity	Unit Price	Total Extended $ w/o Burden	Long Lead
(Yes/No)	Discount Applied?

Total of 10% Remaining

TOTAL

Matrix /xl/drawings/drawing1.xml#Matrix!A1OFFEROR

MAJOR SUB

Summary

L-4 Prime Cost Summary

SOLICITATION NO. N00039-17-R-0005 - ATTACHMENT L-4

COST SUMMARY FORMAT

Prime Offeror Name:

Subcontractor Name (if applicable):

DCAA Point of Contact Information:

Total for All Years

CLIN 0001

CLIN 1001

CLIN 1002

Cost Elements

Labor Category

Qualifications (N/A to CLIN 1001)

Hours

Amount

Rate

Hours

Amount

Rate

Hours

Amount

Rate

Hours

Amount

Prime Contractor Labor Cost

Prime Contractor Direct Labor

Employee Name 1	$ - 0		$ - 0		$ - 0		$ - 0
Employee Name 2	$ - 0		$ - 0		$ - 0		$ - 0
Etc. (Insert Row Above To Add Employees)	$ - 0		$ - 0		$ - 0		$ - 0
Total Direct Labor Cost	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0

Prime Contractor Indirect Labor Cost

Overhead CTR Site	$ - 0
Fringe Benefits	$ - 0
G&A	$ - 0
Etc. (Insert Row Above to Add Indirect Rate)	$ - 0
Total Indirect Labor Cost	$ - 0	$ - 0	$ - 0	$ - 0
Total Direct and Indirect Labor cost	$ - 0	$ - 0	$ - 0	$ - 0
	$ - 0
COM (Insert Row Above to Add COM Rate)	$ - 0
Total Prime Contractor Labor Cost	$ - 0	$ - 0	$ - 0	$ - 0

Subcontractor Labor Cost

Subcontractor proposed cost and fee

Subcontractor 1	0	$ - 0
Subcontractor 2	0	$ - 0
Etc. (Insert Row Above To Add Subcontractors)	0	$ - 0
Total proposed subcontractor labor cost and fee	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0
Prime contractor pass through (not including fee)

Handling	$ - 0
G&A	$ - 0
Other (if any - Insert Row Above to Add Pass Through Rate)	$ - 0
Total pass through (not including fee)	$ - 0	$ - 0	$ - 0	$ - 0
Total Subcontractor Cost including pass through	$ - 0	$ - 0	$ - 0	$ - 0

Total Labor Cost (Prime and Subcontractor Labor) $ - 0 $ - 0 $ - 0 $ - 0

Material
Material		$ - 0
	$ - 0
M&H (Insert Row Above To Add Any Other Indirect Rates)	$ - 0
G&A
Total ODCs without fee		$ - 0

Fixed Fee (X%)

Prime Contractor Fee for Prime Contractor Labor	$ - 0
Prime Contractor Fee for Subcontractor Labor	$ - 0
Total Fee (for Prime and Subcontractor Labor)	$ - 0	$ - 0	$ - 0	$ - 0

Total Cost Plus Fee $ - 0 $ - 0 $ - 0 $ - 0

ODCs (CLIN 1003 non fee bearing)	$ 35,000.00
Total all CLINs (Labor and ODCs)		$ - 0

Pass Through Analysis - Total for All Years	Amount	Percent
Subcontractor proposed cost and fee	$0
Pass Through Amount (not including fee)	$0
Prime Contractor Fee for Subcontractor Labor	$0
Total Pass Through Amount (including fee)	$0	ERROR:#DIV/0!
Maximum Pass Through Allowed by SeaPort-e IDIQ Contract

Fee Analysis - Total for All Years	Amount	Percent
Prime Contractor Labor Cost (excluding COM)	$0
Fixed Fee for Labor Performed by Prime Contractor	$0	ERROR:#DIV/0!

Escalation Analysis	Percent
Labor escalation per year

L-5 Sub Cost Summary

SOLICITATION NO. N00039-17-R-0005 - ATTACHMENT L-5

COST SUMMARY FORMAT - SUBCONTRACTOR(S)

Prime Offeror Name:

Subcontractor Name:

DCAA Point of Contact Information:

Government Site or Contractor Site

Total for All Years

CLIN 0001

CLIN 1001

CLIN 1002

Option Year 3

Option Year 4

Cost Elements

Labor Category

Qualifications (N/A to CLIN 1001)

Hours

Amount

Rate

Hours

Amount

Rate

Hours

Amount

Rate

Hours

Amount

Rate

Hours

Amount

Rate

Hours

Amount

Subcontractor Labor Cost

Subcontractor Direct Labor

Employee Name 1	$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Employee Name 2	$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Etc. (Insert Row Above To Add Employees)	$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Total Direct Labor Cost	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0

Subcontractor Indirect Labor Cost

Overhead CTR Site	$ - 0
Fringe Benefits	$ - 0
G&A	$ - 0
Etc. (Insert Row Above to Add Indirect Rate)	$ - 0
Total Indirect Labor Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Direct and Indirect Labor cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

COM	$ - 0
Total Subcontractor Labor Cost	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Fee

Total Labor Cost Plus Fee $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Direct Labor Escalation Analysis	Percent
Labor escalation per year

L-6 Supporting Cost Data

SOLICITATION NO. N00039-17-R-0005 - ATTACHMENT L-6

SUPPORTING COST DATA - CONTRACTOR'S CURRENT DIRECT & INDIRECT RATES

Company Name:

DCAA Point of Contact Information:

	Historical Rates	Proposed Rates
Direct Labor:

Employee Name

Labor Category	Historical Year 1	Historical Year 2	Historical Year 3
(Actual Current Labor Rate)	Proposed CLIN 0001 Labor Rate	Proposed CLIN 1001 Labor Rate	Proposed CLIN 1002 Labor Rate	Reason for difference between actual current labor rate and proposed labor rates. Reason for difference between proposed rates and DCMA/DCAA Forward Pricing Rate Agreement (FPRA) rates.
	Ex: John Doe	Ex: Sr. Program Mgr	$	$	$	$	$	$
	Ex: Jane Doe	Ex: Sr. Systems Engineer	$	$	$	$	$	$
	Ex: New Employee 1	Ex: Jr. Junior Analyst	$	$	$	$	$	$
			$	$	$	$	$	$
			$	$	$	$	$	$

Indirect Rates:		Historical Year 1	Historical Year 2	Historical Year 3	Proposed CLIN 0001 Rate	Proposed CLIN 1001 Rate	Proposed CLIN 1002 Rate	Reason for difference between actual current labor rate and proposed labor rates. Reason for difference between proposed rates and DCMA/DCAA Forward Pricing Rate Agreement (FPRA) rates.
Fringe
Overhead CTR Site
G&A
Material and Handling
Other
Rate Period	Start Date	End Date
Historical Year 1:
Historical Year 2:
Historical Year 3:
Proposed CLIN 0001 Period:
Proposed CLIN 1001 Period:
Proposed CLIN 1002 Period:
Note to Offerors: The Offeror shall provide historical labor rates and proposed labor rates for the personnel (named and unnamed) identified above. The Offeror shall provide historical rates in Columns C, D and E; year 3 shall contain the Offeror's most recent annual labor rates. The Offeror shall then identify their proposed labor rates for those same individuals in columns F, G and H. The Offeror shall provide similar historical and proposed indirect rates for the items listed on lines 16 through 20. The Offeror shall identify the Start and End dates for each of their rate periods in the table on lines 23-28.

L-7 Small Bus Commitment

Subcontractor Name Proposed Total for Subcontractor Percent of Work Performed on Contract Type of Small Business CAGE Code NAICS

(add rows as necessary)

Proposed Total Acquisition Value

Prepare and submit one copy of this attachment (inclusive of formulas) to identify the extent of participation of specific small business concerns, whether as prime or subcontractors, in terms of the dollar value of the total acquisition.

In accordance with provision Section L, offerors must ensure that the subcontractor names and values listed in the Small Business Commitment Sheet match the subcontractor names and values listed in Volume III of the proposal. The inclusion of each subcontractor in the cost proposal shall serve as evidence that the prime contractor and subcontractor have entered into a business agreement; no further evidence of a business agreement is required. Only the portion of small business participation that is both listed in this matrix and substantiated by the cost proposal will be considered in the evaluation.

Identify the extent of participation of each small business concern in terms of the value of the total acquisition, based on the proposed total acquisition value.

L-8 BOE Sample

BASIS OF ESTIMATE
BOE ID#:		Program:		Date:
RFP:	N00039-17-R-0005	CLIN:		Prepared by:
Task ID:		Task Title:		Reviewed by:
CWBS:		PoP from:	To:		SOW Ref:
Basis of Estimate Method:

Summary:

Labor hrs by skill mix

Labor Category 1

Labor Category 2

Labor Category 3

Labor Category 4

Labor Category 5

Labor Category 6

Labor Category 7

Labor Category 8

Labor Category 9

Labor Category 10

Labor Category 11

Labor Category 12

Total hrs

Material: $

Task/Scope:

Subtasks:

Subtask ID Subtask Description Labor code Hrs

Sheet1

Sheet2

File details come from the government source that posted it.