P1 Cost Summary Spreadsheet.xlsx

XLSX spreadsheet 42 KB Posted Dec 26, 2019

Attached to: AIR 411- CI&IDS Integration and Production
Solicitation number: N00421-19-R-0105
Issued by: Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

Written by GovTribe AI · Dec 31, 2023

This document contains a cost summary spreadsheet template and instructions for a federal contract opportunity soliciting technical and integration support services. Offerors must submit a capabilities statement by July 8, 2019 demonstrating experience supporting similar requirements, managing teams and subcontractors, and technical skills to perform tasks outlined in the draft Statement of Work. The small business prime must perform at least 50% of the work. The Naval Air Systems Command seeks these services for the Combat Integration & Identification Systems Division to support systems integration and production. The anticipated contract is a single-award IDIQ with a five-year ordering period valued at over 1 million hours to be performed at contractor and government sites. Respondents must qualify as a small business in NAICS 541330 with a $38.5 million size standard and hold a secret facility and information security clearance.

View the file

Other files

File	Type	Posted
Integration and Production RFP (2.26.20).pdf	PDF	Feb 26, 2020
CDRLs Integration and Production2.26.20.docx	DOCX document	Feb 26, 2020
Integration and Production RFP Q&A.xlsx	XLSX spreadsheet	Feb 26, 2020
CSP_ CIIDS.docx	DOCX document	Feb 12, 2020
Integration and Production RFP 2122020.pdf	PDF	Feb 12, 2020
Integration and Production DD 254.pdf	PDF	Feb 12, 2020
CPAQ Instructions_CIIDS.docx	DOCX document	Feb 12, 2020
P1 (Cost Summary Spreadsheet).xlsx	XLSX spreadsheet	Feb 12, 2020
CDRLs Integration and Production.docx	DOCX document	Feb 12, 2020
CPAQ_CIIDS.pdf	PDF	Feb 12, 2020
LIST OF APPLICABLE WAGE DETERMINATIONS CIIDS.docx	DOCX document	Feb 12, 2020
Data Transmittal Form_CIIDS.docx	DOCX document	Feb 12, 2020
PPIF_CIIDS.pdf	PDF	Feb 12, 2020
OCI List_CIIDS.docx	DOCX document	Feb 12, 2020
Locator Form_CIIDS.doc	DOC document	Feb 12, 2020
P2 (Annual Fully Burdened Rates).xlsx	XLSX spreadsheet	Feb 12, 2020
Integrationand Production_CPAQ Instructions.docx	DOCX document	Dec 26, 2019
OCI List.docx	DOCX document	Dec 26, 2019
CDRLs.docx	DOCX document	Dec 26, 2019
Data Transmittal Form.docx	DOCX document	Dec 26, 2019
Integration and Production P2 Annual Fully Burdened Rates.xlsx	XLSX spreadsheet	Dec 26, 2019
Integration and Production_CPAQ.pdf	PDF	Dec 26, 2019
Integration and Production PPIF.pdf	PDF	Dec 26, 2019
CSP.docx	DOCX document	Dec 26, 2019
Integration and Production_Amended DRAFTRFP (12.26.19).pdf	PDF	Dec 26, 2019
Integration and Production_LIST OF APPLICABLE WAGE DETERMINATIONS.docx	DOCX document	Dec 26, 2019
DD 254.pdf	PDF	Dec 26, 2019
Integration and Production Locator Form.doc	DOC document	Dec 26, 2019
CPAQ.pdf	PDF	Dec 13, 2019
Locator Form.doc	DOC document	Dec 13, 2019
Integration and Production_DRAFT RFP (12.12.19).pdf	PDF	Dec 13, 2019
Integration and Production_CSP.docx	DOCX document	Dec 13, 2019
Attachment_P1_Integration and Production.xlsx	XLSX spreadsheet	Dec 13, 2019
P2 Annual Fully Burdened Rates.xlsx	XLSX spreadsheet	Dec 13, 2019
Integration and Production_CDRLs.docx	DOCX document	Dec 13, 2019
Integration and Production_OCI List.docx	DOCX document	Dec 13, 2019
Data Transmittal_Installationand Production.docx	DOCX document	Dec 13, 2019
CPAQ Instructions.docx	DOCX document	Dec 13, 2019
LIST OF APPLICABLE WAGE DETERMINATIONS.docx	DOCX document	Dec 13, 2019
PPIF.pdf	PDF	Dec 13, 2019
Integration and Production_DD254.pdf	PDF	Dec 13, 2019
Sources_Sought_Responses.pdf	PDF	Jul 30, 2019
Draft_SOW.docx	DOCX document	Jun 20, 2019
Draft_LOE.docx	DOCX document	Jun 20, 2019
Draft_CDRLs.docx	DOCX document	Jun 20, 2019

Show all 45

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, 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):

Govt

CTR

Year 1

Year 2

Year 3

Year 4

Year 5

Total

Position

Cost Elements

Government Labor Category

Proposed Labor Category

F/P

Site (G)

Site (C)

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

Administrative Assistant

Employee Name 2

CAD Operator III

Employee Name 3

CAD Operator IV*

Etc.

Computer and Information Research Scientists / Journeyman

Etc.

Electronics Technician I, Maintenance

Etc.

Electronics Technician II, Maintenance

Etc.

Electronics Technician III, Maintenance

Etc.

Electrical Engineers / Journeyman

Etc.

Electrical Engineers / Senior*

Etc.

Engineering Technician II

Etc.

Engineering Technician III

Etc.

Engineering Technician IV

Etc.

Engineering Technician V*

Etc.

Budget Analysts / Senior

Etc.

Budget Analysts / Journeyman

Etc.

General Clerk I

Etc.

Logisticians / Journeyman*

Etc.

Material Coordinator

Etc.

Management Analysts / Journeyman

Etc.

General and Operations Managers / Senior*

Etc.

General and Operations Managers / Journeyman

Etc.

Warehouse Specialist/Warehouse Worker

Etc.

Supply Technician

Etc.

Technical Writer III

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
1	Subcontractor Name 1	Manager/

Operations Manager

(Program Manager)	G	0	0	0	0	0	0	0
	Manager/

Operations Manager

(Program Manager)				C
	2	Subcontractor Name 2	Manager/

Operations Manager

(Project Manager)	G	0	0	0	0	0	0	0
	Manager/

Operations Manager

(Project Manager)				C
	3	Etc.	Electrical Engineers
(Engineer/Scientist III)			G			0	0	0	0	0	0	0
			Electrical Engineers
(Engineer/Scientist III)				C
	4	Etc.	Electrical Engineers
(Engineer/Scientist II)			G			0	0	0	0	0	0	0
			Electrical Engineers
(Engineer/Scientist II)				C
	5	Etc.	Electrical Engineers
(Engineer/Scientist I)			G			0	0	0	0	0	0	0
			Electrical Engineers
(Engineer/Scientist I)				C
	6	Etc.	Program/ Project/Management Analysts (Program Analyst)		G		0	0	0	0			0	0	0
			Program/ Project/Management Analysts (Program Analyst)			C
	7	Etc.	Program/ Project/Management Analysts (Program Analyst)		G		0	0	0	0			0	0	0
			Program/ Project/Management Analysts (Program Analyst)			C
	8	Etc.	Computer Systems Analysts (Computer Specialist)		G		0	0	0	0			0	0	0
			Computer Systems Analysts (Computer Specialist)			C
	9	Etc.	Computer Systems Analysts (Computer Specialist)		G		0	0	0	0			0	0	0
			Computer Systems Analysts (Computer Specialist)			C
	10	Etc.	General and Operations Managers (Logistics Manager)		G		0	0	0	0			0	0	0
			General and Operations Managers (Logistics Manager)			C
	11	Etc.	Logisticians
(Logistics Analyst III)			G			0	0	0	0	0	0	0
			Logisticians
(Logistics Analyst III)				C
	12	Etc.	Logisticians
(Logistics Analyst II)			G			0	0	0	0	0	0	0
			Logisticians
(Logistics Analyst II)				C
	13	Etc.	Logisticians
(Logistics Analyst I)			G			0	0	0	0	0	0	0
			Logisticians
(Logistics Analyst I)				C
	14	Etc.	Management Analysts		G		0	0	0	0			0	0	0
			Management Analysts			C
	15	Etc.	Computer Network Support Specialists (IT Analyst)		G		0	0	0	0			0	0	0
			Computer Network Support Specialists (IT Analyst)			C
	16	Etc.	Financial Analysts
(Financial Analyst)			G			0	0	0	0	0	0	0
			Financial Analysts
(Financial Analyst)				C
	17	Etc.	Financial Analysts
(Financial Analyst)			G			0	0	0	0	0	0	0
			Financial Analysts
(Financial Analyst)				C
	18	Etc.	Engineering Technician V		G		0	0	0	0			0	0	0
			Engineering Technician V			C
	19	Etc.	Engineering Technician IV		G		0	0	0	0			0	0	0
			Engineering Technician IV			C
	20	Etc.	Engineering Technician III		G		0	0	0	0			0	0	0
			Engineering Technician III			C
	21	Etc.	Engineering Technician II		G		0	0	0	0			0	0	0
			Engineering Technician III			C
	22	Etc.	Computer Programmer II		G		0	0	0	0			0	0	0
			Computer Programmer II			C
	23	Etc.	Technical Writer III		G		0	0	0	0			0	0	0
			Technical Writer III			C
	24	Etc.	Technical Writer II		G		0	0	0	0			0	0	0
			Technical Writer II			C
	25	Etc.	Drafter/CAD Operator III		G		0	0	0	0			0	0	0
			Drafter/CAD Operator III			C
	26	Etc.	Drafter/CAD Operator II		G		0	0	0	0			0	0	0
			Drafter/CAD Operator II			C
	27	Etc.	Supply Technician		G		0	0	0	0			0	0	0
			Supply Technician			C
	28	Etc.	Warehouse Specialist		G		0	0	0	0			0	0	0
			Warehouse Specialist			C
	29	Etc.	General Clerk III		G		0	0	0	0			0	0	0
			General Clerk III			C
	30	Etc.	Administrative Assistant		G		0	0	0	0			0	0	0
			Administrative Assistant			C
		Total proposed subcontractor labor cost and fee					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 $

Total

File details come from the government source that posted it. Updated Dec 26, 2019.