Att_P1_Cost_Summary.xlsx

XLSX spreadsheet 71 KB Posted May 8, 2018

Attached to: AIR-4. 11_ATCLS_AOOSS Federal contract opportunity
Solicitation number: N00421-18-R-0024
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 for this federal contract opportunity

Other files attached to AIR-4. 11_ATCLS_AOOSS, newest first.
File	Type	Posted
N00421-18-R-0024-P00003.docx	DOCX document	Jun 11, 2018
Amendment_3.docx	DOCX document	Jun 11, 2018
Att_P1_Cost_Summary.xlsx	XLSX spreadsheet	Jun 7, 2018
N00421-18-R-0024-P00002.docx	DOCX document	Jun 7, 2018
Att_P1_Cost_Summary.xlsx	XLSX spreadsheet	May 22, 2018
Att_P2_Annual_Fully_Burdened_Labor.xlsx	XLSX spreadsheet	May 22, 2018
N00421-18-R-0024-P00001.docx	DOCX document	May 22, 2018
Att_P2_Annual_Fully_Burdened_Labor.xlsx	XLSX spreadsheet	May 8, 2018
Att_4_Data_Transmittal.doc	DOC document	May 8, 2018
Att_8_Locator_Form.doc	DOC document	May 8, 2018
Att_P3_PPIF.pdf	PDF	May 8, 2018
Att_P4_CPAQ.pdf	PDF	May 8, 2018
Att_3_OCI_List.doc	DOC document	May 8, 2018
N00421-18-R-0024.docx	DOCX document	May 8, 2018
Exhibit_A.pdf	PDF	May 8, 2018
Att_5_WD_15-4279_.txt	TXT text file	May 8, 2018
Att_2_QASP.doc	DOC document	May 8, 2018
Att_7_GFP.xlsx	XLSX spreadsheet	May 8, 2018
Att_1_DD254.pdf	PDF	May 8, 2018
Att_P5_CPAQ_Instructions.docx	DOCX document	May 8, 2018
Att_6_WD_15-5635.txt	TXT text file	May 8, 2018
N00421-18-R-0024_Section_L.docx	DOCX document	Mar 28, 2018
N00421-18-R-0024_Section_M.docx	DOCX document	Mar 28, 2018
N00421-18-R-0024_PWS.docx	DOCX document	Mar 28, 2018
N00421-18-R-0024_Level_of_Effort.docx	DOCX document	Mar 28, 2018

Show all 25

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, 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, A45, and A52.
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 54-97.
12	When submitting this file, the instructions may be deleted.

Cost Spreadsheet (LOE)

COST SUMMARY SPREADSHEET (LOE)

	Prime Offeror Name:
	Subcontractor Name (if applicable):
						Year 1			Year 2			Year 3			Year 4			Year 5			Option Period 1			Option Period 2			Total
Position	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
1	Employee Name 1	Manager/Operations Managers*						0			0			0			0			0			0			0	0	0
2	Employee Name 2	Manager/Operations Managers*						0			0			0			0			0			0			0	0	0
3	Etc.	Manager/Operations Managers*						0			0			0			0			0			0			0	0	0
4	Etc.	Electrical Engineers*						0			0			0			0			0			0			0	0	0
5	Etc.	Electrical Engineers*						0			0			0			0			0			0			0	0	0
6	Etc.	Electrical Engineers						0			0			0			0			0			0			0	0	0
7	Etc.	Program/Project/Management Analysts*						0			0			0			0			0			0			0	0	0
8	Etc.	Network and Computer Systems Administrators						0			0			0			0			0			0			0	0	0
9	Etc.	Network and Computer Systems Administrators						0			0			0			0			0			0			0	0	0
10	Etc.	Computer Systems Analysts						0			0			0			0			0			0			0	0	0
11	Etc.	Computer Systems Analysts – Contractor Site						0			0			0			0			0			0			0	0	0
12	Etc.	Program/Project/Management Analysts						0			0			0			0			0			0			0	0	0
13	Etc.	Program/Project/Management Analysts						0			0			0			0			0			0			0	0	0
14	Etc.	Program/Project/Management Analysts						0			0			0			0			0			0			0	0	0
15	Etc.	Program/Project/Management Analysts – Contractor Site						0			0			0			0			0			0			0	0	0
16	Etc.	Budget Analysts						0			0			0			0			0			0			0	0	0
17	Etc.	General and Operations Manager						0			0			0			0			0			0			0	0	0
18	Etc.	Management Analysts						0			0			0			0			0			0			0	0	0
19	Etc.	Management Analysts						0			0			0			0			0			0			0	0	0
20	Etc.	Management Analysts – Contractor Site						0			0			0			0			0			0			0	0	0
21	Etc.	Management Analysts						0			0			0			0			0			0			0	0	0
22	Etc.	Engineering Technicians, Except Drafters, All Other*						0			0			0			0			0			0			0	0	0
23	Etc.	Engineering Technicians, Except Drafters, All Other – Contractor Site*						0			0			0			0			0			0			0	0	0
24	Etc.	Engineering Technicians, Except Drafters, All Other						0			0			0			0			0			0			0	0	0
25	Etc.	Engineering Technicians, Except Drafters, All Other						0			0			0			0			0			0			0	0	0
26	Etc.	Engineering Technicians, Except Drafters, All Other						0			0			0			0			0			0			0	0	0
27	Etc.	Engineering Technicians, Except Drafters, All Other – Contractor Site						0			0			0			0			0			0			0	0	0
28	Etc.	Electrical and Electronic Engineering Technicians						0			0			0			0			0			0			0	0	0
29	Etc.	Electrical and Electronic Engineering Technicians						0			0			0			0			0			0			0	0	0
30	Etc.	Electrical and Electronic Engineering Technicians						0			0			0			0			0			0			0	0	0
31	Etc.	Engineering Technicians, Except Drafters, All Other						0			0			0			0			0			0			0	0	0
32	Etc.	Engineering Technicians, Except Drafters, All Other – Contractor Site						0			0			0			0			0			0			0	0	0
33	Etc.	Engineering Technicians, Except Drafters, All Other						0			0			0			0			0			0			0	0	0
34	Etc.	Engineering Technicians, Except Drafters, All Other – Contractor Site						0			0			0			0			0			0			0	0	0
35	Etc.	Engineering Technicians, Except Drafters, All Other						0			0			0			0			0			0			0	0	0
36	Etc.	Engineering Technicians, Except Drafters, All Other – Contractor Site						0			0			0			0			0			0			0	0	0
37	Etc.	Computer Programmers						0			0			0			0			0			0			0	0	0
38	Etc.	Computer Programmers – Contractor Site						0			0			0			0			0			0			0	0	0
39	Etc.	Computer Programmers						0			0			0			0			0			0			0	0	0
40	Etc.	General Clerk – Contractor Site						0			0			0			0			0			0			0	0	0
41	Etc.	General Clerk						0			0			0			0			0			0			0	0	0
42	Etc.	General Clerk						0			0			0			0			0			0			0	0	0
43	Etc.	Drafters						0			0			0			0			0			0			0	0	0
44	Etc.	Drafters						0			0			0			0			0			0			0	0	0
45	Etc.	Drafters – Contractor Site						0			0			0			0			0			0			0	0	0
46	Etc.	Production, Planning, and Expediting Clerks						0			0			0			0			0			0			0	0	0
47	Etc.	Production, Planning, and Expediting Clerks – Contractor Site						0			0			0			0			0			0			0	0	0
48	Etc.	Production, Planning, and Expediting Clerks						0			0			0			0			0			0			0	0	0
49	Etc.	Production, Planning, and Expediting Clerks – Contractor Site						0			0			0			0			0			0			0	0	0
50	Etc.	Stock Clerks and Order Fillers – Contractor Site						0			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							0			0			0			0			0			0			0		0
	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
1	Subcontractor Name 1	Manager/Operations Managers*	0	0	0	0	0	0	0	0	0
2	Subcontractor Name 2	Manager/Operations Managers*	0	0	0	0	0	0	0	0	0
3	Etc.	Manager/Operations Managers*	0	0	0	0	0	0	0	0	0
4	Etc.	Electrical Engineers*	0	0	0	0	0	0	0	0	0
5	Etc.	Electrical Engineers*	0	0	0	0	0	0	0	0	0
6	Etc.	Electrical Engineers	0	0	0	0	0	0	0	0	0
7	Etc.	Program/Project/Management Analysts*	0	0	0	0	0	0	0	0	0
8	Etc.	Network and Computer Systems Administrators	0	0	0	0	0	0	0	0	0
9	Etc.	Network and Computer Systems Administrators	0	0	0	0	0	0	0	0	0
10	Etc.	Computer Systems Analysts	0	0	0	0	0	0	0	0	0
11	Etc.	Computer Systems Analysts – Contractor Site	0	0	0	0	0	0	0	0	0
12	Etc.	Program/Project/Management Analysts	0	0	0	0	0	0	0	0	0
13	Etc.	Program/Project/Management Analysts	0	0	0	0	0	0	0	0	0
14	Etc.	Program/Project/Management Analysts	0	0	0	0	0	0	0	0	0
15	Etc.	Program/Project/Management Analysts – Contractor Site	0	0	0	0	0	0	0	0	0
16	Etc.	Budget Analysts	0	0	0	0	0	0	0	0	0
17	Etc.	General and Operations Manager	0	0	0	0	0	0	0	0	0
18	Etc.	Management Analysts	0	0	0	0	0	0	0	0	0
19	Etc.	Management Analysts	0	0	0	0	0	0	0	0	0
20	Etc.	Management Analysts – Contractor Site	0	0	0	0	0	0	0	0	0
21	Etc.	Management Analysts	0	0	0	0	0	0	0	0	0
22	Etc.	Engineering Technicians, Except Drafters, All Other*	0	0	0	0	0	0	0	0	0
23	Etc.	Engineering Technicians, Except Drafters, All Other – Contractor Site*	0	0	0	0	0	0	0	0	0
24	Etc.	Engineering Technicians, Except Drafters, All Other	0	0	0	0	0	0	0	0	0
25	Etc.	Engineering Technicians, Except Drafters, All Other	0	0	0	0	0	0	0	0	0
26	Etc.	Engineering Technicians, Except Drafters, All Other	0	0	0	0	0	0	0	0	0
27	Etc.	Engineering Technicians, Except Drafters, All Other – Contractor Site	0	0	0	0	0	0	0	0	0
28	Etc.	Electrical and Electronic Engineering Technicians	0	0	0	0	0	0	0	0	0
29	Etc.	Electrical and Electronic Engineering Technicians	0	0	0	0	0	0	0	0	0
30	Etc.	Electrical and Electronic Engineering Technicians	0	0	0	0	0	0	0	0	0
31	Etc.	Engineering Technicians, Except Drafters, All Other	0	0	0	0	0	0	0	0	0
32	Etc.	Engineering Technicians, Except Drafters, All Other – Contractor Site	0	0	0	0	0	0	0	0	0
33	Etc.	Engineering Technicians, Except Drafters, All Other	0	0	0	0	0	0	0	0	0
34	Etc.	Engineering Technicians, Except Drafters, All Other – Contractor Site	0	0	0	0	0	0	0	0	0
35	Etc.	Engineering Technicians, Except Drafters, All Other	0	0	0	0	0	0	0	0	0
36	Etc.	Engineering Technicians, Except Drafters, All Other – Contractor Site	0	0	0	0	0	0	0	0	0
37	Etc.	Computer Programmers	0	0	0	0	0	0	0	0	0
38	Etc.	Computer Programmers – Contractor Site	0	0	0	0	0	0	0	0	0
39	Etc.	Computer Programmers	0	0	0	0	0	0	0	0	0
40	Etc.	General Clerk – Contractor Site	0	0	0	0	0	0	0	0	0
41	Etc.	General Clerk	0	0	0	0	0	0	0	0	0
42	Etc.	General Clerk	0	0	0	0	0	0	0	0	0
43	Etc.	Drafters	0	0	0	0	0	0	0	0	0
44	Etc.	Drafters	0	0	0	0	0	0	0	0	0
45	Etc.	Drafters – Contractor Site	0	0	0	0	0	0	0	0	0
46	Etc.	Production, Planning, and Expediting Clerks	0	0	0	0	0	0	0	0	0
47	Etc.	Production, Planning, and Expediting Clerks – Contractor Site	0	0	0	0	0	0	0	0	0
48	Etc.	Production, Planning, and Expediting Clerks	0	0	0	0	0	0	0	0	0
49	Etc.	Production, Planning, and Expediting Clerks – Contractor Site	0	0	0	0	0	0	0	0	0
50	Etc.	Stock Clerks and Order Fillers – Contractor Site	0	0	0	0	0	0	0	0	0
	Total proposed subcontractor labor cost and fee		0	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:

Cost Spreadsheet Completion)