Attach_P1.xlsx

XLSX spreadsheet 38 KB Posted Mar 7, 2017

Attached to: 4. 11. 5 (ETMS) ENGINEERING, TECHNICAL, AND MANAGEMENT SERVICES
Solicitation number: N00421-16-R-0021
Issued by: Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

From the source

Cost Summary Spreadsheet

View the file

Other files

File	Type	Posted
Question_&_Answers.docx	DOCX document	Jun 20, 2017
Question.docx	DOCX document	Jun 19, 2017
N00421-16-R-0021_Amendment_5.docx	DOCX document	Jun 16, 2017
N00421-16-R-0021_Amendment_5.docx	DOCX document	Jun 16, 2017
Attach_P2.xlsx	XLSX spreadsheet	Apr 6, 2017
N00421-16-R-0021_Amendment_4.docx	DOCX document	Apr 6, 2017
Questions_and_Answers.docx	DOCX document	Apr 6, 2017
Amendment_3_N00421-16-R-0021.docx	DOCX document	Mar 30, 2017
Questions_and_Answers-032817.docx	DOCX document	Mar 28, 2017
N00421-16-R-0021_Amendment2.docx	DOCX document	Mar 23, 2017
P5_Past_Performance_Information_Form_Mar_2017.pdf	PDF	Mar 23, 2017
Attach_5.xlsx	XLSX spreadsheet	Mar 23, 2017
Attach_P1.xlsx	XLSX spreadsheet	Mar 23, 2017
Attach_3.docx	DOCX document	Mar 23, 2017
Attach_P2.xlsx	XLSX spreadsheet	Mar 23, 2017
QuestionsAnswers__N00421-16-R-0021_031617_(2).docx	DOCX document	Mar 16, 2017
Attach_P3.pdf	PDF	Mar 7, 2017
Attach_P4.pdf.docx	DOCX document	Mar 7, 2017
Attach_3.docx	DOCX document	Mar 7, 2017
Attachment_2_DD254.pdf	PDF	Mar 7, 2017
Attach_1_QASP_022217.doc	DOC document	Mar 7, 2017
Attach_4.docx	DOCX document	Mar 7, 2017
Exhibit_A_DD1423_(CDRLS)_2-16-17.xlsx	XLSX spreadsheet	Mar 7, 2017
Attach_5.xlsx	XLSX spreadsheet	Mar 7, 2017
Attach_6.xlsx	XLSX spreadsheet	Mar 7, 2017
RFP_N00421-16-R-0021.docx	DOCX document	Mar 7, 2017
Attach_P2.xlsx	XLSX spreadsheet	Mar 7, 2017
ETMS_Questions&Answers.docx	DOCX document	Feb 2, 2017
Past_Performance_Information_Form.pdf	PDF	Jan 27, 2017
Attachment_P3_Past_Performance_Questionnaire.docx	DOCX document	Jan 27, 2017
Attachment_5_SGFE_(Excel).xlsx	XLSX spreadsheet	Jan 27, 2017
Attachment_1_QASP.docx	DOCX document	Jan 27, 2017
ETMS_Solitication.docx	DOCX document	Jan 27, 2017
Exhibit_A_CDRLs.xlsx	XLSX spreadsheet	Jan 27, 2017
Instructions_for_CPAQ.docx	DOCX document	Jan 27, 2017
Attachment_2_DD_Form_254.pdf	PDF	Jan 27, 2017
Attachment_6_RGFE_(Excel).xlsx	XLSX spreadsheet	Jan 27, 2017
Attachment_4_Data_Item_Xmittal_Form.docx	DOCX document	Jan 27, 2017
Attachment_P2_Fully_Burdened_Labor_Rates.xlsx	XLSX spreadsheet	Jan 27, 2017
Contractor_Performance_Assessment_Questionnaire_(CPAQ).pdf	PDF	Jan 27, 2017
Attachment_P1_Cost_Summary_Spreadsheet.xlsx	XLSX spreadsheet	Jan 27, 2017
Attachment_3_OCI_List.docx	DOCX document	Jan 27, 2017
N00421-16-R-0021_ETMS_Questions.docx	DOCX document	Jul 7, 2016
LCATs_Min_Quals.docx	DOCX document	Apr 27, 2016
ETMS_IGE_DRAFT.xlsx	XLSX spreadsheet	Apr 27, 2016
DRAFT_ETMS_SOW.docx	DOCX document	Apr 27, 2016

Show all 46

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

	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 accordinly.
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.
20	Offerors may adjust the spreadsheet to match the company's accounting system.

	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 accordinly.
11	For subcontractor cost summary sheets, delete Rows 22-48.
12	When submitting this file, the instructions may be deleted.
13	Offerors may adjust the spreadsheet to match the company's accounting system.

Cost Summary Spreadsheet CPFF

COST SUMMARY SPREADSHEET

Prime Offeror Name:

Attachment P1

Subcontractor Name (if applicable):

RFP # N00421-16-R-0021

Year 1

Year 2

Year 3

Year 4

Year 5

Ordering Period 1

Ordering Period 2

Option Period 3

Ordering Period 4

Ordering Period 5

Total for All Periods

Cost Elements: CPFF

Government Labor Category

Proposed Labor Category

F/P

Site: Govt/CTR

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

CPFF Labor Categories:

Total

Hours

Employee Name 1	Program Manager, Senior (Key)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
Employee Name 2	Manager (Key)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
Etc.	Engineer/Scientist, Senior (Key)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Engineer/Scientist, Journey Level	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Engineering/Electronics Technician, Senior	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Engineering/Electronics Technician, Journey	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Principal Cybersecurity and Information Assurance Specialist (Key)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Information Assurance Analyst, Senior (Key)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Information Assurance Analyst	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	System Analyst, Senior (Key)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Systems Analyst, Junior	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Systems Analyst, Journey Level	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Information Management and Technology Analyst, Senior	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Information Management and Technology Analyst, Junior	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Information Management and Technology Analyst	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	System Administrator, Senior (Key)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	System Administrator, Junior	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Field Technician, Journey Level	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Multimedia Specialist, Senior (Key)	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Multimedia Specialist	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Analyst, Junior	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Analyst	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Project Analyst	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
	Computer Programmer II	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	- 0	- 0
Total Direct Labor Cost
Prime Contractor Indirect Labor Cost
Overhead
Fringe Benefits
G&A
Total Indirect Labor Cost
Total Direct and Indirect Labor cost
COM
Total Prime Contractor Labor Cost

	Subcontractor Labor Cost
	Subcontractor proposed cost and fee
	Subcontractor 1
	Subcontractor 2
	Etc.
	Total proposed subcontractor labor cost and fee
	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	Sub-Total
		FFP Labor Categories:		Total
Hours			Total
Hours			Total
Hours			Total
Hours			Total

Hours

Total Labor Cost (Prime and Subcontractor Labor)	General Clerk I	0
	Administrative Assistant	0
Fixed Fee	Word Processor II	0
Prime Contractor Fee for Prime Contractor Labor	Personal Computer Support Technician	0
Prime Contractor Fee for Subcontractor Labor *	Sub-Total
Total Fee (for Prime and Subcontractor Labor)

Total Labor Cost Plus Fixed Fee (CPFF) CLIN 0001 Total Hours

Other Direct Costs

Travel CLIN 0017

Field Services CLIN 0033

Material CLIN 0025

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)

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!

* When analyzing pass through costs, the Government will consider prime offeror fee on subcontractor price as an element of pass through. In Section B, however, prime offeror fee on subcontractor price is a fee element rather than a cost element. Prime offeror fee on subcontractor price should be included in the fee column (rather than the cost column) of Section B.

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 CPFF	455,000	0	0	0
0009	Labor FFP	60,000	0		0
0017	ODC Travel COST		0		0
0025	ODC Material COST		0		0
0033	ODC Field Services COST		0		0
Total			0		0
						`

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.

1	Instructions for Subcontractors:
	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.

Summary Spreadsheet FFP

FIRM FIXED PRICE (FFP) SPREADSHEET

RFP N00421-16-R-0021

Prime Offeror Name:

Subcontractor Name (if applicable):

		Year 1			Year 2			Year 3			Year 4			Year 5			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	Amount
	General Clerk I			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	0.00
	Administrative Assistant			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	0.00
	Word Processor II			$0.00			$0.00			$0.00			$0.00			$0.00	0.00	0.00
	Personal Computer Support Technician			$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.