Att_P1.xlsx

XLSX spreadsheet 46 KB Posted Feb 27, 2017

Attached to: 4. 11 Combat Integratiion & Identification Systems (CI&IDS) Division Multi Mission data Link Support (MMDLS) Federal contract opportunity
Solicitation number: N00421-15-R-0010
Issued by: Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

From the source

Cost/Price Summary

View the file

Other files for this federal contract opportunity

Other files attached to 4. 11 Combat Integratiion & Identification Systems (CI&IDS) Division Multi Mission data Link Support (MMDLS), newest first.
File	Type	Posted
N00421-17-R-0019-0001_Revised_Cost.xlsx	XLSX spreadsheet	Jun 26, 2017
N00421-17-R-0019-0001.docx	DOCX document	Jun 26, 2017
N00421-17-R-0019-0001_Revised_Fully_Burdened.xlsx	XLSX spreadsheet	Jun 26, 2017
Govt_response.docx	DOCX document	Jun 19, 2017
Exhibit_A_CDRLS.xlsx	XLSX spreadsheet	May 23, 2017
Att_P4_CPAQ.pdf	PDF	May 23, 2017
Att_P5_CPAQ_Instructions.docx	DOCX document	May 23, 2017
Att_P3_PPIF.pdf	PDF	May 23, 2017
Att_5_WD.txt	TXT text file	May 23, 2017
Att_2_QASP.docx	DOCX document	May 23, 2017
Att_1_DD254.pdf	PDF	May 23, 2017
Att_3_OCI.docx	DOCX document	May 23, 2017
Att_4_Data_Transmittal.docx	DOCX document	May 23, 2017
N00421-17-R-0019.docx	DOCX document	May 23, 2017
Att_P2_Annual_Fully_Burdened_Labor.xlsx	XLSX spreadsheet	May 23, 2017
Att_P1.xlsx	XLSX spreadsheet	May 23, 2017
Att_5_WD.txt	TXT text file	May 15, 2017
Exhibit_A_CDRLS.xlsx	XLSX spreadsheet	May 15, 2017
N00421-17-R-0019.docx	DOCX document	May 15, 2017
Att_5_WD.txt	TXT text file	Feb 27, 2017
Att_P3.pdf	PDF	Feb 27, 2017
Att_P4.pdf	PDF	Feb 27, 2017
Att_6_SGFP.xlsx	XLSX spreadsheet	Feb 27, 2017
Att_7_RGFP.xlsx	XLSX spreadsheet	Feb 27, 2017
Att_P2.xlsx	XLSX spreadsheet	Feb 27, 2017
Att_4_Data_Transmittal.docx	DOCX document	Feb 27, 2017
Att_3_OCI.docx	DOCX document	Feb 27, 2017
N0042117R0019_revised.docx	DOCX document	Feb 27, 2017
Exhibit_A.xlsx	XLSX spreadsheet	Feb 27, 2017
Att_2_QASP.docx	DOCX document	Feb 27, 2017
Att_1_DD254.docx	DOCX document	Feb 27, 2017
Draft_CIIDS_MMDLS_LOE.docx	DOCX document	Apr 7, 2016
Draft_CIIDS_MMDLS_P_Quals.docx	DOCX document	Apr 7, 2016
Draft_CIIDS_MMDLS__SOW.docx	DOCX document	Apr 7, 2016
Draft_CIIDS_MMDLS__CDRLs.pdf	PDF	Apr 7, 2016
LAMPS_Sources_Sought.docx	DOCX document	Oct 31, 2014
Data_Link_Recompete_-_SOW.docx	DOCX document	Oct 31, 2014
DRAFT_LEVEL_OF_EFFORT.xlsx	XLSX spreadsheet	Oct 31, 2014
DRAFT_LAMPS_SOW.docx	DOCX document	Oct 31, 2014
Revised_Personnel_Qualifications_10_June_2013.docx	DOCX document	Oct 31, 2014
Labor_Rate_key_to_Function_labor_Catagories_Dec_2013.xlsx	XLSX spreadsheet	Oct 31, 2014
LAMPS_Sign_in_Sheet_allowed_to_be_posted.doc	DOC document	Oct 31, 2014
Questions_and_Answers_from_SEAPORT-E.docx	DOCX document	Oct 31, 2014
Data_Link_Recompete_-_OCI_List.docx	DOCX document	Oct 31, 2014
Small_Business_Brief.ppt	PPT presentation	Oct 31, 2014
SOURCES_SOUGHT_FBO.docx	DOCX document	Oct 31, 2014
Supplemental_Eng_Integration_Support_Overiew.docx	DOCX document	Oct 31, 2014
Data_Link_Recompete_-_LOE.xlsx	XLSX spreadsheet	Oct 31, 2014
LAMPS_US_Navy_Recorder_System_USCG_SLEP.PPTX	PPTX presentation	Oct 31, 2014
LAMPS_Industry_Day_Brief.PPTX	PPTX presentation	Oct 31, 2014

Show all 50

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

Try for free Login

Text version

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

Instructions

	Instructions for Prime Contractor:
1	Enter Prime offeror name into cell A3.
2	Enter all prime employee names in Column A (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas.
3	Enter all prime labor categories in Column C (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In column C, the Offeror should insert the title of the labor category it will be utilizing. The Offeror is not required to utilize the Government's labor categories, however, each proposed labor category should appear opposite of the government labor category it is comparable to. Please note, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of hours and labor categories. Also, labor categories with more than one person providing service shall be listed multiple times for each person performing work. For example, if the offeror proposes four Senior Analysts, then the labor category Senior Analyst shall be listed four times along with their applicable rates and information.
4	Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor)
5	The worksheets of the workbook should all be formatted for printing on letter-size paper, without requiring "adjustments." It may be formatted for either landscape or portrait. DO NOT FORMAT FOR LEGAL SIZE PAPER.
6	All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
7	All dollar figures shall be carried out no further than two decimal places.
8	In column D, f identify for the specific labor category individual whether they are full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time.
9	In column E, the Offeror shall insert a "K" if the worker will be performing at the Contractor's facility or a "G" if it will be performing in the Government Spaces.
10	Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly.
11	For each subcontractor, enter the subcontractor name, total hours, and total amount for each period of performance.
12	Please note if more subcontractors are needed, the contractor may add additional rows to accommodate them, but ensure integrity of formulas.
13	The prime should insert the subcontractor handling charge, if any.
14	The prime should insert the fixed fee rate applied to its cost excluding subcontractor labor.
15	The prime should insert the fixed fee rate it is applying to the subcontractor labor, if any.
16	Under Other Direct Costs, the prime contractor should separate by Travel, Material and NMCI as applicable.
17	Apply indirects to the Other Direct Costs if applicable and if in compliance with the RFP instructions.
18	On the Summary tab, break out all costs by CLIN. Ensure that the total costs of the CLINs match Section B and the total on the Cost Summary Spreadsheet
19	When submitting this file, the instructions may be deleted.

	Instructions for Subcontractors:
1	Enter Prime offeror name into cell A3.
	Replace Prime Contractor with Subcontractor in A7, A8, A13, and A20.
2	Enter all subcontractor employee names in Column A (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas.
3	Enter all subcontractor labor categories in Column C (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In column C, the Offeror should insert the title of the labor category it will be utilizing. The Offeror is not required to utilize the Government's labor categories, however, each proposed labor category should appear opposite of the government labor category it is comparable to. Please note, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of hours and labor categories. Also, labor categories with more than one person providing service shall be listed multiple times for each person performing work. For example, if the offeror proposes four Senior Analysts, then the labor category Senior Analyst shall be listed four times along with their applicable rates and information.
4	Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor)
5	The worksheets of the workbook should all be formatted for printing on letter-size paper, without requiring "adjustments." It may be formatted for either landscape or portrait. DO NOT FORMAT FOR LEGAL SIZE PAPER.
6	All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
7	All dollar figures shall be carried out no further than two decimal places.
8	In column D, f identify for the specific labor category individual whether they are full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time.
9	In column E, the Offeror shall insert a "K" if the worker will be performing at the Contractor's facility or a "G" if it will be performing in the Government Spaces.
10	Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly.
11	For subcontractor cost summary sheets, delete Rows 22-48.
12	When submitting this file, the instructions may be deleted.

Cost Summary Spreadsheet

COST SUMMARY SPREADSHEET

Prime Offeror Name:
Subcontractor Name (if applicable):
					Year 1			Year 2			Year 3			Year 4			Year 5			Option Period 1			Option Period 2			Total
Cost Elements	Government Labor Category	Proposed Labor Category	F/P	Site	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Hours	Amount
Prime Contractor Labor Cost
Prime Contractor Direct Labor
Employee Name 1	Cable Splicer						0			0			0			0			0			0			0	0	0
Employee Name 2	Clerk Typist						0			0			0			0			0			0			0	0	0
Etc.	Computer Programmer III						0			0			0			0			0			0			0	0	0
Etc.	Computer Programmer IV						0			0			0			0			0			0			0		0
Etc.	Computer Systems Analyst III						0			0			0			0			0			0			0		0
Etc.	Configuration Management Analyst						0			0			0			0			0			0			0		0
Etc.	Data Entry Operator II						0			0			0			0			0			0			0		0
Etc.	Drafter/CAD Operator, Journey Level						0			0			0			0			0			0			0		0
Etc.	Drafter/CAD Operator, Senior						0			0			0			0			0			0			0		0
Etc.	Engineering/Electronics Technician, Senior (Installation)						0			0			0			0			0			0			0		0
Etc.	Engineering Technician, Journey Level						0			0			0			0			0			0			0		0
Etc.	Engineering Technician, Junior						0			0			0			0			0			0			0		0
Etc.	Engineering Technician, Senior						0			0			0			0			0			0			0		0
Etc.	Engineer/Scientist, Journey Level						0			0			0			0			0			0			0		0
Etc.	Engineer/Scientist, Junior						0			0			0			0			0			0			0		0
Etc.	Engineer/Scientist, Senior (Computer)						0			0			0			0			0			0			0		0
Etc.	Engineer/Scientist, Senior (Digital Design)						0			0			0			0			0			0			0		0
Etc.	Engineer/Scientist, Senior (Electrical/Electronics)						0			0			0			0			0			0			0		0
Etc.	Engineer/Scientist, Senior (Systems, RF)						0			0			0			0			0			0			0		0
Etc.	Financial Analyst						0			0			0			0			0			0			0		0
Etc.	Logistician III						0			0			0			0			0			0			0		0
Etc.	Logistics Analyst						0			0			0			0			0			0			0		0
Etc.	Manager						0			0			0			0			0			0			0		0
Etc.	Material Coordinator						0			0			0			0			0			0			0		0
Etc.	Material Expediter						0			0			0			0			0			0			0		0
Etc.	Program Manager, Senior						0			0			0			0			0			0			0		0
Etc.	Project Analyst						0			0			0			0			0			0			0		0
Etc.	Quality Control Inspector						0			0			0			0			0			0			0		0
Etc.	Secretary						0			0			0			0			0			0			0		0
Etc.	Supply Technician						0			0			0			0			0			0			0		0
Etc.	Technical Writer II						0			0			0			0			0			0			0		0
Etc.	Technical Writer III						0			0			0			0			0			0			0		0
Etc.	Travel Clerk I						0			0			0			0			0			0			0		0
Etc.	Warehouse Specialist (Warehouse Worker)						0			0			0			0			0			0			0		0
Etc.	Word Processor I						0			0			0			0			0			0			0		0
Total Direct Labor Cost							0			0			0			0			0			0			0	0	0
Prime Contractor Indirect Labor Cost
Overhead
Fringe Benefits
G&A
Total Indirect Labor Cost
Total Direct and Indirect Labor cost							0			0			0			0			0			0			0		0
COM
Total Prime Contractor Labor Cost							0			0			0			0			0			0			0		0

Subcontractor Labor Cost
Subcontractor proposed cost and fee
Subcontractor 1	Cable Splicer
Subcontractor 2	Clerk Typist
Etc.	Computer Programmer III
Etc.	Computer Programmer IV
Etc.	Computer Systems Analyst III
Etc.	Configuration Management Analyst
Etc.	Data Entry Operator II
Etc.	Drafter/CAD Operator, Journey Level
Etc.	Drafter/CAD Operator, Senior
Etc.	Engineering/Electronics Technician, Senior (Installation)
Etc.	Engineering Technician, Journey Level
Etc.	Engineering Technician, Junior
Etc.	Engineering Technician, Senior
Etc.	Engineer/Scientist, Journey Level
Etc.	Engineer/Scientist, Junior
Etc.	Engineer/Scientist, Senior (Computer)
Etc.	Engineer/Scientist, Senior (Digital Design)
Etc.	Engineer/Scientist, Senior (Electrical/Electronics)
Etc.	Engineer/Scientist, Senior (Systems, RF)
Etc.	Financial Analyst
Etc.	Logistician III
Etc.	Logistics Analyst
Etc.	Manager
Etc.	Material Coordinator
Etc.	Material Expediter
Etc.	Program Manager, Senior
Etc.	Project Analyst
Etc.	Quality Control Inspector
Etc.	Secretary
Etc.	Supply Technician
Etc.	Technical Writer II
Etc.	Technical Writer III
Etc.	Travel Clerk I
Etc.	Warehouse Specialist (Warehouse Worker)
Etc.	Word Processor I
Total proposed subcontractor labor cost and fee		0	0	0	0	0	0	0	0
Prime contractor pass through (not including fee)
Handling
G&A
Other (if any)
Total pass through (not including fee)
Total Subcontractor Cost including pass through									0

Total Labor Cost (Prime and Subcontractor Labor)

Fixed Fee

Prime Contractor Fee for Prime Contractor Labor

Prime Contractor Fee for Subcontractor Labor *

Total Fee (for Prime and Subcontractor Labor)

Total Labor Cost Plus Fixed Fee (CPFF) 0

Other Direct Costs

Other Direct Costs (ODCs)

Any adders to ODCs such as G&A (cost only - no fee)

Total ODCs

Total CPFF all CLINs (Labor and ODCs) 0

Grand Total of CPFF all CLINs

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!

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

Page &P &F

KTR: (name) Source Selection Information - See: FAR 2.101 and 3.104 RFP:

Summary CLIN Summary Sheet

CLINS	CLIN Description	Total Hours	Total Cost	Total Fixed Fee	Total Value $
0001	Labor Term (LOE)
0008	Labor Completion
0020	Material
0027	Travel
0037	Field Services
Total

FFP Instructions

	Instructions for Prime Contractor:
1	Enter Prime offeror name into cell A3.
2	Enter all prime employee names in Column A (starting at row 8) If necessary, insert additional rows--but ensure integrity of formulas.
3	Enter all prime labor categories in Column B (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In column B, the Offeror should insert the title of the labor category it will be utilizing. Labor categories with more than one person providing service shall be listed multiple times for each person performing work. For example, if the offeror proposes four Senior Analysts, then the labor category Senior Analyst shall be listed four times along with their applicable rates and information.
4	Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor)
5	The worksheets of the workbook should all be formatted for printing on letter-size paper, without requiring "adjustments." It may be formatted for either landscape or portrait. DO NOT FORMAT FOR LEGAL SIZE PAPER.
6	All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
7	All dollar figures shall be carried out no further than two decimal places.
8	When submitting this file, the instructions may be deleted.

	Instructions for Subcontractors:
1	Enter Prime offeror name into cell A3.
2	Enter all subcontractor employee names in Column A (starting at row 8) If necessary, insert additional rows--but ensure integrity of formulas.
3	Enter all subcontractor labor categories in Column B (starting at row 8) If necessary, insert additional rows--but ensure integrity of formulas. In column B, the Offeror should insert the title of the labor category it will be utilizing. Labor categories with more than one person providing service shall be listed multiple times for each person performing work. For example, if the offeror proposes four Senior Analysts, then the labor category Senior Analyst shall be listed four times along with their applicable rates and information.
4	Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor)
5	The worksheets of the workbook should all be formatted for printing on letter-size paper, without requiring "adjustments." It may be formatted for either landscape or portrait. DO NOT FORMAT FOR LEGAL SIZE PAPER.
6	All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
7	All dollar figures shall be carried out no further than two decimal places.
8	When submitting this file, the instructions may be deleted.

FFP Summary Spreadsheet

FIRM FIXED PRICE (FFP) SPREADSHEET

Prime Offeror Name:

Subcontractor Name (if applicable):

		Year 1			Year 2			Year 3			Year 4			Year 5			Opton Period 1			Option Period 2			Total for all periods
Employee Name	Proposed Labor Category	Hours	Rate*	Amount	Hours	Rate*	Amount	Hours	Rate*	Amount	Hours	Rate*	Amount	Hours	Rate*	Amount	Hours	Rate*	Amount	Hours	Rate*	Amount	Hours	Amount
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
				$0.00			$0.00			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	$0.00
*Fully burdened rate

File details come from the government source that posted it. Updated Nov 14, 2017.