Attachment P6 FINAL.xls

XLS spreadsheet 91 KB Posted Apr 15, 2021

Attached to: NAWCAD WOLF SCMS Life Cycle Support (LCS) RFP
Solicitation number: N0042120R0145
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 Request for Proposal for Life Cycle Support services for the Special Communication Mission Solutions Division of Naval Air Warfare Center Aircraft Division. The government seeks to award an Indefinite Delivery Indefinite Quantity contract with a five-year ordering period and Cost Plus Fixed Fee Level of Effort Orders to provide Life Cycle Sustainment including in-service and engineering support, Integrated Product Support, technical data and configuration management, and technical and project management for C5ISR systems. The estimated award date is September 7, 2021. Questions regarding this solicitation must be submitted by email to the points of contact provided by October 7, 2021. The North American Industry Classification code is 541330 for Engineering Services and the Product Service Code is J059 for Maintenance, Repair, and Rebuilding of Electrical and Electronic Equipment Components. The incumbent contractor is the holder of contract N00421-18-D-0062.

View the file

Other files

File	Type	Posted
N0042120R0145 Amendment 0001 Released.pdf	PDF	May 7, 2021
LCS N0042120R0145 0001.pdf	PDF	May 5, 2021
Exhibit A CDRLs.docx	DOCX document	May 5, 2021
N0042120R0145 Amendment 1 Questions.pdf	PDF	May 5, 2021
Attachment 16 - Locator Form.doc	DOC document	Apr 15, 2021
Attachment 2 - LCS CSP.pdf	PDF	Apr 15, 2021
Attachment P8 - Labor Hours.xlsx	XLSX spreadsheet	Apr 15, 2021
Attachment 14 - LAN SOP.pdf	PDF	Apr 15, 2021
Attachment 10 - Applicable Wage Determination.docx	DOCX document	Apr 15, 2021
Attachment 7 - Small Business Subcontracting Plan.docx	DOCX document	Apr 15, 2021
Attachment 3 - Segregation of Costs Format.docx	DOCX document	Apr 15, 2021
Attachment 4 - Workforce Reporting Template.xlsx	XLSX spreadsheet	Apr 15, 2021
N0042120R0145 LCS Final RFP.pdf	PDF	Apr 15, 2021
Attachment 1 - DD254 Final.pdf	PDF	Apr 15, 2021
Attachment P4 -BLS Chart Final.xlsx	XLSX spreadsheet	Apr 15, 2021
Attachment 12 - COR Designation Letter.docx	DOCX document	Apr 15, 2021
Attachment 5 - TASK ORDER CLOSEOUT.docx	DOCX document	Apr 15, 2021
Attachment P2 - CPAQ.pdf	PDF	Apr 15, 2021
Attachment 8 - List of Key Personnel.docx	DOCX document	Apr 15, 2021
Attachment 9 - List of Approved Subcontractors.docx	DOCX document	Apr 15, 2021
Attachment 6 - Data Item Transmittal Form.docx	DOCX document	Apr 15, 2021
Attachment P3 - Fully Burdened Labor Rates.xlsx	XLSX spreadsheet	Apr 15, 2021
Attachment 15- Non-Navy IT Certification Form.docx	DOCX document	Apr 15, 2021
Attachment 13 - ACOR Designation Letter.docx	DOCX document	Apr 15, 2021
Attachment 11 - OCI.docx	DOCX document	Apr 15, 2021
Attachment P1 - Past Performance Information Form.pdf	PDF	Apr 15, 2021

Show all 26

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 (found in Column B), however, each proposed labor category should appear opposite of the government labor category it is comparable to. In Column B, insert the government role and reference the Location Labor-Cat Spreasheet for these entries. 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	In column D, choose the work location that the contractor will be working at in accordance with the P4. Note, the Location-Labor Cat Spreadsheet can be referenced to show how the P4 locality lines up with the SOW. If a labor category is to be worked at two different locations, please specify these differences. (For example Emloyee A and Employee B are both Junior Electrical Engineers. Employee A will work in Maryland and Eployee B will be working in Texas. Entries should be made in two seperate rows, noting this locality difference.)
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.
	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 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.
	Instructions for Subcontractors:
1	Enter Prime offeror name into cell A3.
	Replace Prime Contractor with Subcontractor in A7, A8, A13, A20, and A38.
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. In Column B, insert the government role and reference the Location Labor-Cat Spreasheet for these entries. 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	In column D, choose the work location that the contractor will be working at in accordance with the P4. Note, the Location-Labor Cat Spreadsheet can be referenced to show how the P4 locality lines up with the SOW. If a labor category is to be worked at two different locations, please specify these differences. (For example Emloyee A and Employee B are both Junior Electrical Engineers. Employee A will work in Maryland and Eployee B will be working in Texas. Entries should be made in two seperate rows, noting this locality difference.)
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 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.
10	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.
11	Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordinly.
12	For subcontractor cost summary sheets, clear contents for Rows 22-27, 32, 39-40, and 44-47. Please note, the subcontractor can not propose pass through charges.
13	When submitting this file, the instructions may be deleted.

Location-Labor Cat Spreadsheet

P4 Location	Location specified in SOW	Labor Category	BLS SOC	SCA Code
California-Lexington Park, MD	WOLF, St. Inigoes, MD	General and Operations Manager, Senior	11-1021
Fayettville, NC	Spring Lake, NC	General and Operations Manager, Journeyman	11-1021
San Diego, CA	San Diego, CA	General and Operations Manager, Junior	11-1021
VA Beach-Norfolk, VA	Chesapeake, Suffolk, & Norfolk, VA	Logistician, Senior	13-1081
Pensacola, FL	Fort Walton Beach, FL	Logistician, Journeyman	13-1081
Jacksonville, NC	Camp Lejeune, NC	Logistician, Junior	13-1081
El Paso, TX	Fort Bliss, TX	Electrical Engineer, Senior	17-2071
Colorado Springs, CO	Fort Carson, CO	Electrical Engineer, Journeyman	17-2071
Miami, FL	Homestead Air Force Base, FL	Electrical Engineer, Junior	17-2071
Seattle-Tacoma, WA	Joint Base Lewis-McChord, WA	Computer Hardware Engineer, Journeyman	17-2061
Fort Campbell, KY	Christian, KY	Computer Hardware Engineer, Junior	17-2061
Panzer Kaserne, Germany	Panzer Kaserne, Germany	Computer Network Support Specialist, Journeyman	15-1231
		Computer Network Support Specialist, Junior	15-1231
		Computer Network Architects, Journeyman	15-1241
		Computer Network Architects, Junior	15-1241
		First-Line Supervisors of Production, Junior	51-1011
		Computer Systems Analyst, Journeyman	15-1211
		Computer Systems Analyst, Junior	15-1211
		Management Analyst, Journeyman	13-1111
		Management Analyst, Junior	13-1111
		Computer and Information Research Scientist, Junior	15-1221
		Project Management Specialist, Junior	13-1082
		Video Teleconference Technician (SCA)	27-4011	13110
		Electronics Technician Maintenance III (SCA)	17-3023	23183
		Electronics Technician Maintenance II (SCA)	17-3023	23182
		Electronics Technician Maintenance I (SCA)	17-3023	23181
		Engineering Technician III (SCA)	17-3029	30083
		Engineering Technician II (SCA)	17-3029	30082
		Engineering Technician I (SCA)	17-3029	30081
		Telecommunications Mechanic, II (SCA)	49-2022	23932
		Material Coordinator (SCA)	43-5061	21030
		Drafter/CAD Operator, II (SCA)	17-3012	30062
		Drafter/CAD Operator, I (SCA)	17-3012	30061
		Technical Instructor/Course Developer (SCA)	25-3099	15095
		Technical Instructor (SCA)	25-3099	15090
		Technical Writer I (SCA)	27-3042	30461
		Technical Writer II (SCA)	27-3042	30462
		Secretary II (SCA)	43-6011	1312
		Word Processor III (SCA)	43-9022	1613
		Word Processor II (SCA)	43-9022	1612
		Warehouse Specialist (SCA)	53-7065	21410

Cost Summary Spreadsheet

COST SUMMARY SPREADSHEET
Prime Offeror Name:
Subcontractor Name (if applicable):
						Ordering Period Year 1			Ordering Period Year 2			Ordering Period Year 3			Ordering Period Year 4			Ordering Period Year 5			Total for All Years
Cost Elements	Government Labor Category	Proposed Labor Category	Location (IAW P4)	F/P	Site	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								0			0			0			0			0	0	0
Employee Name 2								0			0			0			0			0	0	0
Etc.								0			0			0			0			0	0	0
Total Direct Labor Cost								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
COM
Total Prime Contractor Labor Cost								0			0			0			0			0		0
Subcontractor Labor Cost
Subcontractor proposed cost and fee
Subcontractor 1
Subcontractor 2
Etc.
Total proposed subcontractor labor cost and fee								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	0%
Fee Analysis - Total for All Years	Amount	Percent
Prime Contractor Labor Cost	$0
Fixed Fee for Labor Performed by Prime Contractor	$0	0%
*In Section B, the 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.

&CPage &P&R&F &LKTR: (name)&CSource Selection Information - See: FAR 2.101 and 3.104&RRFP:

Summary

Ordering Period Year Summary Sheet
Ordering Period Year	Ordering Period Year Description	Total Hours	Total Cost	Total Fixed Fee	Total Value $
X001
X002
X003
X004
X005
Total					$ - 0

B-1 Composite Rates

Labor Category (* = Labor Category with Key Employee (s))	Composite Fully Burdened Rates, Exclusive of Fee
	Year 1	Year 2	Year 3	Year 4	Year 5
	09/07/2021 – 09/06/2022**	09/07/2022 – 09/06/2023**	09/07/2023 – 09/06/2024**	09/07/2024 – 09/06/2025**	09/07/2025 – 09/06/2026**
*General and Operations Manager, Senior
General and Operations Manager, Journeyman
General and Operations Manager, Junior
*Logistician, Senior
Logistician, Journeyman
Logistician, Junior
Electrical Engineer, Senior
Electrical Engineer, Journeyman
Electrical Engineer, Junior
Computer Hardware Engineer, Journeyman
Computer Hardware Engineer, Junior
Computer Network Support Specialist, Journeyman
Computer Network Support Specialist, Junior
Computer Network Architect, Journeyman
Computer Network Architect, Junior
First-Line Supervisors of Production and Operating Workers, Junior
First-Line Supervisors of Production and Operating Workers (Danger Pay), Junior
Computer Systems Analyst, Journeyman
Computer Systems Analyst, Junior
Management Analyst, Journeyman
Management Analyst, Junior
Computer & Information Research Scientist, Junior
Project Management Specialist, Junior
Video Teleconference Technician (SCA)
Electronics Technician Maintenance III (SCA)
Electronics Technician Maintenance III (Danger Pay) (SCA)
Electronics Technician Maintenance III (Overtime)(SCA)
Electronics Technician Maintenance II (SCA)
Electronics Technician Maintenance II (Overtime)(SCA)
Electronics Technician Maintenance I (SCA)
Electronics Technician Maintenance I (Overtime)(SCA)
Engineering Technician III (SCA)
Engineering Technician III (Overtime) (SCA)
Engineering Technician II (SCA)
Engineering Technician II (Overtime) (SCA)
Engineering Technician I (SCA)
Engineering Technician I (Overtime) (SCA)
Telecommunications Mechanic, II (SCA)
Telecommunications Mechanic, II (Overtime) (SCA)
Material Coordinator (SCA)
Drafter/CAD Operator, II (SCA)
Drafter/CAD Operator, I (SCA)
Technical Instructor/Course Developer (SCA)
Technical Instructor (SCA)
Technical Writer I (SCA)
Technical Writer II (SCA)
Secretary II (SCA)
Word Processor III (SCA)
Word Processor II (SCA)
Warehouse Specialist (SCA)
** Dates to be adjusted at contract award

File details come from the government source that posted it. Updated Apr 15, 2021.