Attachment_L-08_-_Cost_and_Price_Proposal_Tables_Updated12JUN2018.xls

XLS spreadsheet 128 KB Posted Jun 12, 2018

Attached to: Electronic Warfare Training Systems (EWTS)
Solicitation number: N00024-18-R-5113
Issued by: Department of the Navy Naval Sea Systems Command

About this file

From the source

Updated Attachment L-08

View the file

Other files

File	Type	Posted
Attachment_L-02_Addressing_a_new_EW_Capability_Sample_Problem27JUNE2018.docx	DOCX document	Jun 27, 2018
Attachment_L-03_AOEW_Capability_Design__Implementation_Sample_Problem27JUNE2018.docx	DOCX document	Jun 27, 2018
Questions_Round_3_Final.xlsx	XLSX spreadsheet	Jun 27, 2018
18-R-5133_Amendment_3.pdf	PDF	Jun 27, 2018
N00024-18-R-5113_Bidders_Questions_Final.xlsx	XLSX spreadsheet	Jun 26, 2018
Attachment_L-08_-_Cost_and_Price_Proposal_Tables_Amended_18JUN2018.xls	XLS spreadsheet	Jun 26, 2018
18-R-5113_Amendment_2.docx	DOCX document	Jun 26, 2018
18-R-5113_Amendment_1.pdf	PDF	Jun 12, 2018
Attachment_L-11_-_Employee_Qualifications_Form_Updated12JUN2018.xlsx	XLSX spreadsheet	Jun 12, 2018
Bidders_Questions_and_Answers_FBO_Round_1.xlsx	XLSX spreadsheet	Jun 12, 2018
Attachment_J-08_Consolidated_GFP_Attachment.xls.xlsx	XLSX spreadsheet	May 30, 2018
Attachment_L-02_Addressing_a_new_EW_Capability_Sample_Problem.docx	DOCX document	May 30, 2018
Attachment_L-01_-_Cross_Reference_Matrix.xlsx	XLSX spreadsheet	May 30, 2018
Attachment_J-02_TRM-BFTT_Tailored_Source_Selection_Sensitive.docx	DOCX document	May 30, 2018
Attachment_L-08_-_Cost_and_Price_Proposal_Tables.xls	XLS spreadsheet	May 30, 2018
Attachment_J-04_BEWT_II_FAT_Procedure.docx	DOCX document	May 30, 2018
Exhibit_A-1_EWTS_CDRLS_Information_Package.pdf	PDF	May 30, 2018
Attachment_L-07_-_Past_Performance_Questionnaire.xlsx	XLSX spreadsheet	May 30, 2018
Attachment_J-01-2_-_BEWT_II_ProductionTechnical_Data_Package.docx	DOCX document	May 30, 2018
Attachment_L-03_AOEW_Capability_Design__Implementation_Sample_Problem(18May2018_r1).docx	DOCX document	May 30, 2018
Attachment_L-04_-_Question_Submittal_Form.doc	DOC document	May 30, 2018
Attachment_J-05_IWS_Common_WBS_Structure.pptx	PPTX presentation	May 30, 2018
Attachment_J-06_-_ITS_Portal_2010_Quick_Ref_Guide.pdf	PDF	May 30, 2018
Attachment_L-10_-_Facility_Checklist.xlsx	XLSX spreadsheet	May 30, 2018
Exhibit_A_EWTS_CDRLs_14NOV2017.pdf	PDF	May 30, 2018
N00024-18-R-5113_EWTS_RFP_5.30.18.pdf	PDF	May 30, 2018
Attachment_J-01_-_GFI_List_18R5113.xls	XLS spreadsheet	May 30, 2018
Attachment_J-01-4_-_NULKA_Technical_Information_Package.docx	DOCX document	May 30, 2018
Attachment_L-05_-_Pre-Award_Accounting_System_Adequacy_Checklist.DOC	DOC document	May 30, 2018
Attachment_J-03_IWS_1IT_ITS_SEP_1_Sept_2015.pdf	PDF	May 30, 2018
Attachment_J-01-5_-_BEWT_ISEA_Support_Technical_Information_Package.docx	DOCX document	May 30, 2018
Attachment_L-09_-_Contractor_Award_Information.docx	DOCX document	May 30, 2018
Attachment_L-11_-_Employee_Qualifications_Form.xlsx	XLSX spreadsheet	May 30, 2018
Attachment_L-06_-_Previous_Contract_Effort_Narratives.docx	DOCX document	May 30, 2018
Attachment_J-01-1_-_SEWTT_Technical_Information_Package.docx	DOCX document	May 30, 2018
Attachment_J-01-3_-_CIAT_Technical_Information_Package.docx	DOCX document	May 30, 2018
Attachment_J-07_18-R-5113_DD254_Signed.pdf	PDF	May 30, 2018

Show all 37

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.

Instructions

	Solicitation N00024-18-R-5113 Attachment L-08
CLIN	Description	Form L-08-A	Form L-08B	Form L-08-C	Form L-08-D	Form L-08-E
0001	Training Syst. Eng. and Tech Support	X	X	X		X
1001	Training Syst. Eng. and Tech Support	X	X	X		X
2001	Training Syst. Eng. and Tech Support	X	X	X		X
3001	Training Syst. Eng. and Tech Support	X	X	X		X
4001	Training Syst. Eng. and Tech Support	X	X	X		X
0005	BEWT II Production				X
1005	BEWT II Production				X
2005	BEWT II Production				X
3005	BEWT II Production				X
4005	BEWT II Production				X
0007	Depot Repair and ISEA Support	X	X	X		X
1007	Depot Repair and ISEA Support	X	X	X		X
2007	Depot Repair and ISEA Support	X	X	X		X
3007	Depot Repair and ISEA Support	X	X	X		X
4007	Depot Repair and ISEA Support	X	X	X		X
0009	FAU/BEWT II					X

L-08-A

Solicitation #: N00024-18-R-5113

Offeror:

Offeror Proposal #:

Offeror POC:

CLINs 0001, 0007, 1001, 1007, 2001, 2007, 3001, 3007, 4001, 4007

Total

Base Year

Option Year 1

Option Year 2

Option Year 3

Option Year 4

Proposed Hours

Proposed Rate

Total Proposed Dollars

Proposed Hours

Proposed Rate

Total Proposed Dollars

Proposed Hours

Proposed Rate

Total Proposed Dollars

Proposed Hours

Proposed Rate

Total Proposed Dollars

Proposed Hours

Proposed Rate

Total Proposed Dollars

Proposed Hours

Proposed Rate

Total Proposed Dollars

Prime Contractor Direct Labor Cost

Labor Category 1

Labor Category 2

Labor Category 3

Labor Category 4

Labor Category 5

etc.

Total Direct Labor

Prime Contractor Indirect Labor Cost

Overhead

Fringe Benefits

Etc.

Total Indirect Labor Cost

Total Prime Contractor Labor Cost

Subcontractor Labor Cost

Subcontractor 1 Labor Category

Subcontractor 2 Labor Category

Etc.

Total Direct Labor

Subcontractor Indirect Labor Cost

Handling

G&A

Other (if any)

Total Indirect Labor Cost

Total Subcontractor Labor Cost

TOTAL COSTS ($)

COM

Fee ($)

Fee (%)

Total ESTIMATED COSTS ($) Plus Fixed Fee

Composite Rate (Total Dollars Proposed/Total Hours)

Add or delete rows as necessary

&CAttachment 5 Cost and Price Workbook and Supporting Labor Data

L-08-B

Solicitation #: N00024-18-R-5113		Offeror:
Offeror Proposal #:		Offeror POC:
CLINs 0001, 1001, 2001, 3001, 4001			Total			Base Year				Option Year 1				Option Year 2				Option Year 3				Option Year 4
Government Labor Categories	Current Clearance	Offeror/Subcontractor Labor Categories	Notional Labor Hours All Years	Notional % Labor Mix Per Year	Fully Loaded Cost Total	Base Yr	% Labor Mix	Loaded Hourly Rate	Fully Loaded Base Yr	Opt 1	% Labor Mix	Loaded Hourly Rate	Fully Loaded Opt 1 Yr	Opt 2	% Labor Mix	Loaded Hourly Rate	Fully Loaded Opt 2 Yr	Opt 3	% Labor Mix	Loaded Hourly Rate	Fully Loaded Opt 3 Yr	Opt 4	% Labor Mix	Loaded Hourly Rate	Fully Loaded Opt 4 Yr
Program Manager - (Key Personnel)			9,600	4.4%	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.3%	$ - 0	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.5%	$ - 0	$ - 0
Assistant PM/Senior Engineer - (Key Personnel)			9,600	4.4%	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.3%	$ - 0	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.5%	$ - 0	$ - 0
Senior Engineer			19,200	8.8%	$ - 0	3,840	8.9%	$ - 0	$ - 0	3,840	8.7%	$ - 0	$ - 0	3,840	8.6%	$ - 0	$ - 0	3,840	8.8%	$ - 0	$ - 0	3,840	9.0%	$ - 0	$ - 0
Mid-Level Engineer			19,200	8.8%	$ - 0	3,840	8.9%	$ - 0	$ - 0	3,840	8.7%	$ - 0	$ - 0	3,840	8.6%	$ - 0	$ - 0	3,840	8.8%	$ - 0	$ - 0	3,840	9.0%	$ - 0	$ - 0
Project Engineer			19,200	8.8%	$ - 0	3,840	8.9%	$ - 0	$ - 0	3,840	8.7%	$ - 0	$ - 0	3,840	8.6%	$ - 0	$ - 0	3,840	8.8%	$ - 0	$ - 0	3,840	9.0%	$ - 0	$ - 0
Hardware Designer/Technician			19,200	8.8%	$ - 0	3,840	8.9%	$ - 0	$ - 0	3,840	8.7%	$ - 0	$ - 0	3,840	8.6%	$ - 0	$ - 0	3,840	8.8%	$ - 0	$ - 0	3,840	9.0%	$ - 0	$ - 0
Senior Software Engineer (Key Personnel)			9,600	4.4%	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.3%	$ - 0	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.5%	$ - 0	$ - 0
Senior Software Engineer			9,600	4.4%	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.3%	$ - 0	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.5%	$ - 0	$ - 0
Software Designer			48,000	22.0%	$ - 0	9,600	22.2%	$ - 0	$ - 0	9,600	21.8%	$ - 0	$ - 0	9,600	21.5%	$ - 0	$ - 0	9,600	22.1%	$ - 0	$ - 0	9,600	22.5%	$ - 0	$ - 0
Senior Project Analyst			22,489	10.3%	$ - 0	3,893	9.0%	$ - 0	$ - 0	4,649	10.6%	$ - 0	$ - 0	4,649	10.4%	$ - 0	$ - 0	4,649	10.7%	$ - 0	$ - 0	4,649	10.9%	$ - 0	$ - 0
Project Analyst			13,284	6.1%	$ - 0	2,880	6.7%	$ - 0	$ - 0	2,934	6.7%	$ - 0	$ - 0	3,601	8.1%	$ - 0	$ - 0	2,268	5.2%	$ - 0	$ - 0	1,601	3.7%	$ - 0	$ - 0
Test & Certification/QA Specialist			9,600	4.4%	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.3%	$ - 0	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.5%	$ - 0	$ - 0
Technical Writer			9,600	4.4%	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.3%	$ - 0	$ - 0	1,920	4.4%	$ - 0	$ - 0	1,920	4.5%	$ - 0	$ - 0
Total			218,173	100.0%	$ - 0	43,253	100.0%			44,063	100.0%			44,730	100.0%			43,397	100.0%			42,730	100.0%
							*Loaded Hourly Rate is exclusive of FCCOM and fee
			Total				Base Year				Option Year 1				Option Year 2				Option Year 3				Option Year 4
			Composite Rate		$ - 0		Composite Rate		$ - 0		Composite Rate		$ - 0		Composite Rate		$ - 0		Composite Rate		$ - 0		Composite Rate		$ - 0
			Total Cost		$ - 0		Total Cost		$ - 0		Total Cost		$ - 0		Total Cost		$ - 0		Total Cost		$ - 0		Total Cost		$ - 0
			FCCOM		$ - 0		FCCOM		$ - 0		FCCOM		$ - 0		FCCOM		$ - 0		FCCOM		$ - 0		FCCOM		$ - 0
			Fixed Fee		$ - 0		Fixed Fee	0%	$ - 0		Fixed Fee	0%	$ - 0		Fixed Fee	0%	$ - 0		Fixed Fee	0%	$ - 0		Fixed Fee	0%	$ - 0
			Total CPFF		$ - 0		Total CPFF		$ - 0		Total CPFF		$ - 0		Total CPFF		$ - 0		Total CPFF		$ - 0		Total CPFF		$ - 0
			Fully Burdened Composite Rate		$ - 0		Fully Burdened Composite Rate		$ - 0		Fully Burdened Composite Rate		$ - 0		Fully Burdened Composite Rate		$ - 0		Fully Burdened Composite Rate		$ - 0		Fully Burdened Composite Rate		$ - 0
CLINs 0007, 1007, 2007, 3007, 4007
Government Labor Categories	Current Clearance	Offeror/Subcontractor Labor Categories	Notional Labor Hours All Years	Notional % Labor Mix Per Year	Fully Loaded Cost Total	Base Yr	% Labor Mix	Loaded Hourly Rate	Fully Loaded Base Yr	Opt 1	% Labor Mix	Loaded Hourly Rate	Fully Loaded Opt 1 Yr	Opt 2	% Labor Mix	Loaded Hourly Rate	Fully Loaded Opt 2 Yr	Opt 3	% Labor Mix	Loaded Hourly Rate	Fully Loaded Opt 3 Yr	Opt 4	% Labor Mix	Loaded Hourly Rate	Fully Loaded Opt 4 Yr
Project Analyst			14,400	100.0%	$ - 0	2,880	100.0%	$ - 0	$ - 0	2,880	100.0%	$ - 0	$ - 0	2,880	100.0%	$ - 0	$ - 0	2,880	100.0%	$ - 0	$ - 0	2,880	100.0%	$ - 0	$ - 0
			Total				Base Year				Base Year				Base Year				Base Year				Base Year
			Composite Rate		$ - 0		Composite Rate		$ - 0		Composite Rate		$ - 0		Composite Rate		$ - 0		Composite Rate		$ - 0		Composite Rate		$ - 0
			Total Cost		$ - 0		Total Cost		$ - 0		Total Cost		$ - 0		Total Cost		$ - 0		Total Cost		$ - 0		Total Cost		$ - 0
			FCCOM		$ - 0		FCCOM		$ - 0		FCCOM		$ - 0		FCCOM		$ - 0		FCCOM		$ - 0		FCCOM		$ - 0
			Fixed Fee		$ - 0		Fixed Fee	0%	$ - 0		Fixed Fee	0%	$ - 0		Fixed Fee	0%	$ - 0		Fixed Fee	0%	$ - 0		Fixed Fee	0%	$ - 0
			Total CPFF		$ - 0		Total CPFF		$ - 0		Total CPFF		$ - 0		Total CPFF		$ - 0		Total CPFF		$ - 0		Total CPFF		$ - 0
			Fully Burdened Composite Rate		$ - 0		Fully Burdened Composite Rate		$ - 0		Fully Burdened Composite Rate		$ - 0		Fully Burdened Composite Rate		$ - 0		Fully Burdened Composite Rate		$ - 0		Fully Burdened Composite Rate		$ - 0
							*Loaded Hourly Rate is exclusive of FCCOM and fee
			Percent of Time on This Contract
Key Personnel			Base Year	Option Year 1	Option Year 2	Option Year 3	Option Year 4
Program Manager
Assistant PM/Senior Engineer
Senior Software Engineer

L-08-C

Solicitation #: N00024-18-R-5113	Offeror:
Offeror Proposal #:	Offeror POC:
Rates Table						Supporting Data
	Proposed Rates						Current	Reason for difference between CY17 actual current rates and CY18 proposed rates	Historical Actuals
Rates Category	CY18	CY19	CY20	CY21	CY22	Rates Category	CY17		CY16	CY15	CY14
Escalation						Escalation
Escalation %						Escalation %
Direct Labor Rate						Direct Labor Rate
Category 1						Category 1
Category 2						Category 2
Category n						Category n
Indirect Rate						Indirect Rate
Category 1						Category 1
Category 2						Category 2
Category n						Category n
General & Adminstrative Rate						General & Adminstrative Rate
Category 1						Category 1
Category 2						Category 2
Category n						Category n
Other Rate						Other Rate
Category 1						Category 1
Category 2						Category 2
Category n						Category n
Facility Capital Cost of Money Rate						Facility Capital Cost of Money Rate
Category 1						Category 1
Category 2						Category 2
Category n						Category n
Prepare one of these forms as needed for each CY and each labor category as applicable
Round direct labor rates to 2 decimals, indirect rates to 2 decimals, and G&A and FCCOM to 3 decimals

L-08-D

Solicitation #: N00024-18-R-5113			Offeror:
Offeror Proposal #:			Offeror POC:
BEWT II Production Stepladder Pricing
Item	From Quantity	To Quantity	Unit Price
0005	1	5	$ - 0
	6	10	$ - 0
	11	15	$ - 0
	16	20	$ - 0
1005	1	5	$ - 0
	6	10	$ - 0
	11	15	$ - 0
	16	20	$ - 0
2005	1	5	$ - 0
	6	10	$ - 0
	11	15	$ - 0
	16	20	$ - 0
3005	1	5	$ - 0
	6	10	$ - 0
	11	15	$ - 0
	16	20	$ - 0
4005	1	5	$ - 0
	6	10	$ - 0
	11	15	$ - 0
	16	20	$ - 0

L-08-E

Solicitation #: N00024-18-R-5113		Offeror:
Offeror Proposal #:		Offeror POC:
Section B Pricing
CLIN	Description	Type	Firm/Option	QTY	Unit	Unit Price	Total	Est. Cost	Fixed Fee $
0001	Training Syst. Eng. And Tech Support	CPFF	Firm	43,253	Hrs	$ - 0	$ - 0	$ - 0	$ - 0
0002	Data	NSP	Firm
0003	ODC Material	Cost	Firm	1	Lot	$ 264,500.00	$ 264,500.00
0004	Travel	Cost	Firm	1	Lot	$ 49,500.00	$ 49,500.00
0005	BEWT II Production	FFP	Option	20	Ea
0006	Storage - Non Production	Cost	Option	1,000	Sq Ft
0007	Depot Repair/ISEA Support	CPFF	Option	2,880	Hrs	$ - 0	$ - 0	$ - 0	$ - 0
0009	FAU/BEWT II	FFP	Firm	1	Ea		$ - 0
						Total Base	$ 314,000.00
1001	Training Syst. Eng. And Tech Support	CPFF	Option	44,063	Hrs	$ - 0	$ - 0	$ - 0	$ - 0
1003	ODC Material	Cost	Option	1	Lot	$ 356,827.00	$ 356,827.00
1004	Travel	Cost	Option	1	Lot	$ 65,793.00	$ 65,793.00
1005	BEWT II Production	FFP	Option	20	Ea
1006	Storage - Non Production	FFP	Option	1,000	Sq Ft
1007	Depot Repair/ISEA Support	CPFF	Option	2,880	Hrs	$ - 0	$ - 0	$ - 0	$ - 0
						Total OY 1	$ 422,620.00
2001	Training Syst. Eng. And Tech Support	CPFF	Option	44,730	Hrs	$ - 0	$ - 0	$ - 0	$ - 0
2003	ODC Material	Cost	Option	1	Lot	$ 356,827.00	$ 356,827.00
2004	Travel	Cost	Option	1	Lot	$ 65,793.00	$ 65,793.00
2005	BEWT II Production	FFP	Option	20	Ea
2006	Storage - Non Production	FFP	Option	1,000	Sq Ft
2007	Depot Repair/ISEA Support	CPFF	Option	2,880	Hrs	$ - 0	$ - 0	$ - 0	$ - 0
						Total OY 2	$ 422,620.00
3001	Training Syst. Eng. And Tech Support	CPFF	Option	43,397	Hrs	$ - 0	$ - 0	$ - 0	$ - 0
3003	ODC Material	Cost	Option	1	Lot	$ 272,677.00	$ 272,677.00
3004	Travel	Cost	Option	1	Lot	$ 50,943.00	$ 50,943.00
3005	BEWT II Production	FFP	Option	20	Ea
3006	Storage - Non Production	FFP	Option	1,000	Sq Ft
3007	Depot Repair/ISEA Support	CPFF	Option	2,880	Hrs	$ - 0	$ - 0	$ - 0	$ - 0
						Total OY 3	$ 323,620.00
4001	Training Syst. Eng. And Tech Support	CPFF	Option	42,730	Hrs	$ - 0	$ - 0	$ - 0	$ - 0
4003	ODC Material	Cost	Option	1	Lot	$ 182,900.00	$ 182,900.00
4004	Travel	Cost	Option	1	Lot	$ 35,100.00	$ 35,100.00
4005	BEWT II Production	FFP	Option	20	Ea
4006	Storage - Non Production	FFP	Option	1,000	Sq Ft
4007	Depot Repair/ISEA Support	CPFF	Option	2,880	Hrs	$ - 0	$ - 0	$ - 0	$ - 0
						Total OY 4	$ 218,000.00
						Total	$ 1,700,860.00
Gray cells shall not be filled in

File details come from the government source that posted it.