Attachment P1 Cost Summary.xlsx

XLSX spreadsheet 43 KB Posted Feb 7, 2022

Attached to: Area Control Systems Hardware and Support Services Federal contract opportunity
Solicitation number: N0042121R0161
Issued by: Department of the Navy Naval Air Systems Command

About this file

Written by GovTribe AI · Dec 31, 2023

This document contains a cost summary spreadsheet template and instructions for a federal solicitation seeking proposals for area control systems hardware and support services. The cost template requires offerors to provide detailed labor category, rate, and cost information for both prime and subcontractor employees for the base year and four option years. Instructions specify formatting requirements and how to populate fields for prime contractors, subcontractors, labor categories, rates, hours, indirect costs, fees, and other direct costs. Proposals are due by 2:00 PM ET on March 9, 2022 to the Department of the Navy Naval Air Systems Command for solicitation N0042121R0161. The cost template and instructions provide guidance to offerors on the level of cost detail and compliance required for the solicitation.

View the file

Other files for this federal contract opportunity

Other files attached to Area Control Systems Hardware and Support Services, newest first.
File	Type	Posted
ACS Hardware_QA-2.pdf	PDF	Feb 25, 2022
ACS Hardware RFP AMD 0002.pdf	PDF	Feb 25, 2022
Attachment 6 Wage Determination 2015-4279 Rev.16.pdf	PDF	Feb 25, 2022
ACS Hardware RFP AMD 0002 Conformed.pdf	PDF	Feb 25, 2022
ACS Hardware RFP AMD 0001 Conformed.pdf	PDF	Feb 15, 2022
ACS Hardware_QA.pdf	PDF	Feb 15, 2022
ACS Hardware RFP AMD 0001.pdf	PDF	Feb 15, 2022
Attachment P1 Cost Summary.xlsx	XLSX spreadsheet	Feb 15, 2022
Attachment 6 - Wage Determination 2015-4280 Rev 13.pdf	PDF	Feb 7, 2022
Attachment 5 Locator Form.pdf	PDF	Feb 7, 2022
Attachment P3 CPAQ.pdf	PDF	Feb 7, 2022
Attachment P2 FB Rates.xlsx	XLSX spreadsheet	Feb 7, 2022
Attachment P5 CPAQ Instructions.pdf	PDF	Feb 7, 2022
Attachment P4 PPIF.pdf	PDF	Feb 7, 2022
Attachment 1 DD254.pdf	PDF	Feb 7, 2022
ACS Hardware RFP.pdf	PDF	Feb 7, 2022
Exhibit A CDRLS.pdf	PDF	Feb 7, 2022
Attachment 3 OCI List.pdf	PDF	Feb 7, 2022
Attachment 2 CSP.pdf	PDF	Feb 7, 2022
Attachment 4 Data Transmittal Acceptance Form.pdf	PDF	Feb 7, 2022

Show all 20

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 B3.
2	Enter all prime employee names in Column C (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas.
3	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 E, 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 F, 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, labor category the subcontractor will be performing, 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 and Material 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 B3.
	Enter Subcontractor offeror name into cell B4.
2	Replace Prime Contractor with Subcontractor in cells B7, B82, and B89.
3	Enter all subcontractor employee names in Column C (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas.
4	Enter all subcontractor labor categories in Column B (starting at row 9). If necessary, insert additional rows--but ensure integrity of formulas. Remove any labor categories in Column B that the Subcontractor is not performing. 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.
5	Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor)
6	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.
7	All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
8	All dollar figures shall be carried out no further than two decimal places.
9	In column E, 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.
10	In column F, 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.
11	Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly.
12	For subcontractor cost summary sheets, please delete Rows 90-135 as well as any unused labor category rows.
	When submitting this file, the instructions may be deleted.

N00421-21-R-0161

Cost Spreadsheet (LOE)

COST SUMMARY SPREADSHEET (LOE)

	Prime Offeror Name:
	Subcontractor(s) Name (if applicable):
						Base Year			Option Year 1			Option Year 2			Option Year 3			Option Year 4			Total
Position	Government Labor Category	Employee Name	SCA Code	F/P	Site	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Hours	Amount
	Prime Contractor Labor Cost				K = Contractor
					G = Government
1	General and Operations Managers (Program Manager)*	Employee Name 1			K		480	0.00		480	0.00		480	0.00		480	0.00		480	0.00	2400	0.00
2	General and Operations Managers (Project Manager)*	Employee Name 2			G		1920	0.00		1920	0.00		1920	0.00		1920	0.00		1920	0.00	9600	0.00
3	Electrical Engineers (Engineer/Scientist V)	Etc.			G		960	0.00		960	0.00		3840	0.00		3840	0.00		3840	0.00	13440	0.00
4	Electrical Engineers (Engineer/Scientist V) OT	Etc.			G		96	0.00		96	0.00		384	0.00		384	0.00		384	0.00	1344	0.00
5	Electrical Engineers (Engineer/Scientist IV)	Etc.			K		960	0.00		960	0.00		960	0.00		960	0.00		960	0.00	4800	0.00
6	Electrical Engineers (Engineer/Scientist IV) OT	Etc.			K		96	0.00		96	0.00		96	0.00		96	0.00		96	0.00	480	0.00
7	Electrical Engineers (Engineer/Scientist IV)	Etc.			G		960	0.00		960	0.00		960	0.00		960	0.00		960	0.00	4800	0.00
8	Electrical Engineers (Engineer/Scientist IV) OT	Etc.			G		96	0.00		96	0.00		96	0.00		96	0.00		96	0.00	480	0.00
9	Electrical Engineers (Engineer/Scientist III)	Etc.			K		960	0.00		960	0.00		960	0.00		960	0.00		960	0.00	4800	0.00
10	Electrical Engineers (Engineer/Scientist III) OT	Etc.			K		96	0.00		96	0.00		96	0.00		96	0.00		96	0.00	480	0.00
11	Electrical Engineers (Engineer/Scientist III)	Etc.			G		960	0.00		960	0.00		480	0.00		960	0.00		960	0.00	4320	0.00
12	Electrical Engineers (Engineer/Scientist III) OT	Etc.			G		96	0.00		96	0.00		48	0.00		96	0.00		96	0.00	432	0.00
13	Electrical Engineers (Engineer Scientist II)	Etc.			K		960	0.00		960	0.00		960	0.00		960	0.00		960	0.00	4800	0.00
14	Electrical Engineers (Engineer Scientist II) OT	Etc.			K		96	0.00		96	0.00		96	0.00		96	0.00		96	0.00	480	0.00
15	Electrical Engineers (Engineer Scientist II)	Etc.			G		960	0.00		960	0.00		480	0.00		960	0.00		960	0.00	4320	0.00
16	Electrical Engineers (Engineer Scientist II) OT	Etc.			G		96	0.00		96	0.00		48	0.00		96	0.00		96	0.00	432	0.00
17	Electrical Engineers (Engineer/Scientist I)	Etc.			K		960	0.00		960	0.00		960	0.00		960	0.00		960	0.00	4800	0.00
18	Electrical Engineers (Engineer/Scientist I) OT	Etc.			K		96	0.00		96	0.00		96	0.00		96	0.00		96	0.00	480	0.00
19	Electrical Engineers (Engineer/Scientist I)	Etc.			G		960	0.00		960	0.00		960	0.00		960	0.00		960	0.00	4800	0.00
20	Electrical Engineers (Engineer/Scientist I) OT	Etc.			G		96	0.00		96	0.00		96	0.00		96	0.00		96	0.00	480	0.00
21	Management Analysts (Management Analyst I)	Etc.			K		960	0.00		960	0.00		960	0.00		960	0.00		1920	0.00	5760	0.00
22	Management Analysts (Management Analyst I) OT	Etc.			K		48	0.00		48	0.00		48	0.00		48	0.00		96	0.00	288	0.00
23	Management Analysts (Management Analyst I)	Etc.			G		960	0.00		960	0.00		960	0.00		960	0.00		1920	0.00	5760	0.00
24	Management Analysts (Management Analyst I) OT	Etc.			G		48	0.00		48	0.00		48	0.00		48	0.00		96	0.00	288	0.00
25	Management Analysts (Project Analyst)	Etc.			K		960	0.00		960	0.00		960	0.00		960	0.00		1920	0.00	5760	0.00
26	Management Analysts (Project Analyst) OT	Etc.			K		48	0.00		48	0.00		48	0.00		48	0.00		96	0.00	288	0.00
27	Management Analysts (Project Analyst)	Etc.			G		960	0.00		960	0.00		960	0.00		960	0.00		1920	0.00	5760	0.00
28	Management Analysts (Project Analyst) OT	Etc.			G		48	0.00		48	0.00		48	0.00		48	0.00		96	0.00	288	0.00
29	Logisticians (Logistics Analyst II)	Etc.			K		960	0.00		960	0.00		960	0.00		960	0.00		960	0.00	4800	0.00
30	Logisticians (Logistics Analyst II) OT	Etc.			K		48	0.00		48	0.00		48	0.00		48	0.00		48	0.00	240	0.00
31	Logisticians (Logistics Analyst II)	Etc.			G		1920	0.00		1920	0.00		1920	0.00		1920	0.00		1920	0.00	9600	0.00
32	Logisticians (Logistics Analyst II) OT	Etc.			G		96	0.00		96	0.00		96	0.00		96	0.00		96	0.00	480	0.00
33	Logisticians (Logistics Analyst I)	Etc.			K		1920	0.00		1920	0.00		1920	0.00		1920	0.00		1920	0.00	9600	0.00
34	Logisticians (Logistics Analyst I) OT	Etc.			K		96	0.00		96	0.00		96	0.00		96	0.00		96	0.00	480	0.00
35	Logisticians (Logistics Analyst I)	Etc.			G		1920	0.00		1920	0.00		1920	0.00		1920	0.00		1920	0.00	9600	0.00
36	Logisticians (Logistics Analyst I) OT	Etc.			G		96	0.00		96	0.00		96	0.00		96	0.00		96	0.00	480	0.00
37	Computer Programmer I (Computer Programmer I)	Etc.			K		1920	0.00		1920	0.00		1920	0.00		1920	0.00		1920	0.00	9600	0.00
38	Computer Programmer I (Computer Programmer I) OT	Etc.			K		96	0.00		96	0.00		96	0.00		96	0.00		96	0.00	480	0.00
39	Computer Programmer I (Computer Programmer I)	Etc.			G		1920	0.00		1920	0.00		1920	0.00		1920	0.00		1920	0.00	9600	0.00
40	Computer Programmer I (Computer Programmer I) OT	Etc.			G		96	0.00		96	0.00		96	0.00		96	0.00		96	0.00	480	0.00
41	Management Analysts (Systems Analyst II)	Etc.			K		1920	0.00		1920	0.00		1920	0.00		1920	0.00		1920	0.00	9600	0.00
42	Management Analysts (Systems Analyst II) OT	Etc.			K		96	0.00		96	0.00		96	0.00		96	0.00		96	0.00	480	0.00
43	Management Analysts (Systems Analyst II)	Etc.			G		1920	0.00		1920	0.00		1920	0.00		1920	0.00		1920	0.00	9600	0.00
44	Management Analysts (Systems Analyst II) OT	Etc.			G		96	0.00		96	0.00		96	0.00		96	0.00		96	0.00	480	0.00
45	Management Analysts (Systems Analyst I)	Etc.			K		1920	0.00		1920	0.00		1920	0.00		1920	0.00		960	0.00	8640	0.00
46	Management Analysts (Systems Analyst I) OT	Etc.			K		96	0.00		96	0.00		96	0.00		96	0.00		48	0.00	432	0.00
47	Management Analysts (Systems Analyst I)	Etc.			G		960	0.00		960	0.00		960	0.00		960	0.00		960	0.00	4800	0.00
48	Management Analysts (Systems Analyst I) OT	Etc.			G		48	0.00		48	0.00		48	0.00		48	0.00		48	0.00	240	0.00
49	Engineering Technicians, Except Drafters, All Other (Engineering Technician VI)	Etc.	30086		G		3840	0.00		3840	0.00		3840	0.00		3840	0.00		5760	0.00	21120	0.00
50	Engineering Technicians, Except Drafters, All Other (Engineering Technician VI) OT	Etc.	30086		G		192	0.00		192	0.00		192	0.00		192	0.00		288	0.00	1056	0.00
51	Engineering Technicians, Except Drafters, All Other (Engineering Technician V)	Etc.	30085		G		5760	0.00		3840	0.00		3840	0.00		5760	0.00		5760	0.00	24960	0.00
52	Engineering Technicians, Except Drafters, All Other (Engineering Technician V) OT	Etc.	30085		G		288	0.00		192	0.00		192	0.00		288	0.00		288	0.00	1248	0.00
53	Engineering Technicians, Except Drafters, All Other (Engineering Technician IV)	Etc.	30084		G		3840	0.00		5760	0.00		3840	0.00		3840	0.00		5760	0.00	23040	0.00
54	Engineering Technicians, Except Drafters, All Other (Engineering Technician IV) OT	Etc.	30084		G		192	0.00		288	0.00		192	0.00		192	0.00		288	0.00	1152	0.00
55	Electrical and Electronic Engineering Technologists and Technicians (Electronics Technician Maintenance III)	Etc.	23183		K		3840	0.00		3840	0.00		3840	0.00		3840	0.00		5760	0.00	21120	0.00
56	Electrical and Electronic Engineering Technologists and Technicians (Electronics Technician Maintenance III) OT	Etc.	23183		K		192	0.00		192	0.00		192	0.00		192	0.00		288	0.00	1056	0.00
57	Electrical and Electronic Engineering Technologists and Technicians (Electronics Technician Maintenance II)	Etc.	23182		K		3840	0.00		3840	0.00		3840	0.00		3840	0.00		5760	0.00	21120	0.00
58	Electrical and Electronic Engineering Technologists and Technicians (Electronics Technician Maintenance II) OT	Etc.	23182		K		192	0.00		192	0.00		192	0.00		192	0.00		288	0.00	1056	0.00
59	Electrical and Electronic Engineering Technologists and Technicians (Electronics Technician Maintenance I)	Etc.	23181		K		3840	0.00		3840	0.00		3840	0.00		5760	0.00		3840	0.00	21120	0.00
60	Electrical and Electronic Engineering Technologists and Technicians (Electronics Technician Maintenance I) OT	Etc.	23181		K		192	0.00		192	0.00		192	0.00		288	0.00		192	0.00	1056	0.00
61	Drafter / CAD Operator II	Etc.	30062		K		960	0.00		960	0.00		960	0.00		1920	0.00		1920	0.00	6720	0.00
62	Drafter / CAD Operator II OT	Etc.	30062		K		48	0.00		48	0.00		48	0.00		96	0.00		96	0.00	336	0.00
63	Drafter / CAD Operator II	Etc.	30062		G		960	0.00		960	0.00		960	0.00		1920	0.00		1920	0.00	6720	0.00
64	Drafter / CAD Operator II OT	Etc.	30062		G		48	0.00		48	0.00		48	0.00		96	0.00		96	0.00	336	0.00
65	Technical Writer II	Etc.	30462		K		960	0.00		1920	0.00		1920	0.00		1920	0.00		1920	0.00	8640	0.00
66	Technical Writer II OT	Etc.	30462		K		48	0.00		96	0.00		96	0.00		96	0.00		96	0.00	432	0.00
67	Technical Writer II	Etc.	30462		G		960	0.00		1920	0.00		1920	0.00		1920	0.00		1920	0.00	8640	0.00
68	Technical Writer II OT	Etc.	30462		G		48	0.00		96	0.00		96	0.00		96	0.00		96	0.00	432	0.00
69	General Clerk I	Etc.	01111		K		1920	0.00		1920	0.00		1920	0.00		1920	0.00		1920	0.00	9600	0.00
70	General Clerk I OT	Etc.	01111		K		96	0.00		96	0.00		96	0.00		96	0.00		96	0.00	480	0.00
71	General Clerk I	Etc.	01111		G		1920	0.00		1920	0.00		1920	0.00		1920	0.00		1920	0.00	9600	0.00
72	General Clerk I OT	Etc.	01111		G		96	0.00		96	0.00		96	0.00		96	0.00		96	0.00	480	0.00
	Total Direct Labor Cost						68,352			70,368			70,464			77,568			86,640		373,392	0.00
	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
	<Insert Subcontractor Name>
83	<Insert Labor Category >	Employee Name 1
84		Employee Name 2
85		Etc.
86		Etc.
87		Etc.
88		Etc.
89		Etc.
90		Etc.
91		Etc.
92		Etc.
	<Insert Subcontractor Name>
93	<Insert Labor Category >	Employee Name 1
94		Employee Name 2
95		Etc.
96		Etc.
97		Etc.
98		Etc.
99		Etc.
100		Etc.
101		Etc.
102		Etc.
	<Insert Subcontractor Name>
103	<Insert Labor Category >	Employee Name 1
104		Employee Name 2
105		Etc.
106		Etc.
107		Etc.
108		Etc.
109		Etc.
110		Etc.
111		Etc.
112		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

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)

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)

Grand Total of CPFF all CLINs

Pass Through Analysis - Total for All Years	Amount	Percent
Subcontractor proposed cost and fee
Pass Through Amount (not including fee)
Prime Contractor Fee for Subcontractor Labor *
Total Pass Through Amount (including fee)		ERROR:#DIV/0!

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

Solicitation N00421-20-R-0119 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 $

Total

N00421-21-R-0161 P1 Cost Summary

File details come from the government source that posted it. Updated Feb 7, 2022.