P1 (Cost Summary Spreadsheet) (002).xlsx

XLSX spreadsheet 37 KB Posted Oct 6, 2020

Attached to: FACSFAC Field Maintenance Support Federal contract opportunity
Solicitation number: N00421-20-R-0158
Issued by: Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

Written by GovTribe AI · Dec 30, 2023

This document contains a sources sought notice and draft statement of work for a field maintenance support contract. The Naval Air Warfare Center Aircraft Division is seeking field maintenance services for area control and surveillance systems including the Fleet Area Control and Surveillance Facility Air Control Tracking System, Stand Alone Radar Console, Integrated Range Status System, and Standard Terminal Automation Replacement System located at various sites. Interested small businesses are requested to submit a capabilities statement by June 4th, 2020 addressing their relevant experience, technical skills, and ability to perform at least 50% of the work. The requirement is anticipated to be a single-award IDIQ contract valued at approximately $388 million over five years, requiring facility and personnel security clearances.

View the file

Other files for this federal contract opportunity

Other files attached to FACSFAC Field Maintenance Support, newest first.
File	Type	Posted
FACSFAC Draft RFP_QuestionsAnswers.pdf	PDF	Nov 16, 2020
Locator Form.doc	DOC document	Oct 13, 2020
CPAQ Instructions.docx	DOCX document	Oct 13, 2020
Data Transmittal Form.docx	DOCX document	Oct 13, 2020
LIST OF APPLICABLE WAGE DETERMINATIONS FASCFAC.docx	DOCX document	Oct 13, 2020
CPAQ.pdf	PDF	Oct 13, 2020
PPIF.pdf	PDF	Oct 13, 2020
P2 (Annual Fully Burdened Rates).xlsx	XLSX spreadsheet	Oct 13, 2020
OCI List.docx	DOCX document	Oct 13, 2020
P1 (Cost Summary Spreadsheet).xlsx	XLSX spreadsheet	Oct 13, 2020
FASCFAC Draft RFP.pdf	PDF	Oct 13, 2020
CSP.docx	DOCX document	Oct 13, 2020
P2 (Annual Fully Burdened Rates).xlsx	XLSX spreadsheet	Oct 6, 2020
CPAQ.pdf	PDF	Oct 6, 2020
OCI List.docx	DOCX document	Oct 6, 2020
Data Transmittal Form.docx	DOCX document	Oct 6, 2020
Locator Form.doc	DOC document	Oct 6, 2020
PPIF.pdf	PDF	Oct 6, 2020
CPAQ Instructions.docx	DOCX document	Oct 6, 2020
CSP.docx	DOCX document	Oct 6, 2020
LIST OF APPLICABLE WAGE DETERMINATIONS FASCFAC.docx	DOCX document	Oct 6, 2020
Post Sources Sought Synopsis_N0042120R0158.docx	DOCX document	Jun 25, 2020
03_Field Maintenance Support_CSS SOW V2.docx	DOCX document	May 15, 2020
07_Field Maintenance Support CDRLs.docx	DOCX document	May 15, 2020
DRAFT LOE.docx	DOCX document	May 15, 2020

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

Govt

CTR

Year 1

Year 2

Year 3

Year 4

Year 5

Total

Position

Cost Elements

Locations & Government Labor Category

Proposed Labor Category

Pay Type

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

Manager / Operations Manager (Program Manager)*

960

4800

Employee Name 2

Manager / Operations Manager (Project Manager)*

960

4800

Employee Name 3

Program / Project / Management Analysts (Management Analyst)

960

4800

Etc.

Total

2880

14400

Locations & Labor Categories
ON-SITE FACSFAC SITES (5)
JACKSONVILLE, FL
Engineering Technician VI*	RG	C	1920	3,840	3840	3840	3840	17280
	OT		192	384	384	384	384	1728
Engineering Technician V	RG	C	13440	15,360	15360	15360	15360	74880
	OT		1344	1,536	1536	1536	1536	7488
VACAPES, VA
Engineering Technician VI*	RG	C	1920	1920	1920	1920	1920	9600
	OT		192	192	192	192	192	960
Engineering Technician V	RG	C	7680	7680	7680	7680	7680	38400
	OT		768	768	768	768	768	3840
ST INIGOES, MD
Engineering Technician VI*	RG	C	1920	1920	1920	1920	1920	9600
	OT		192	192	192	192	192	960
SAN DIEGO, CA
Engineering Technician VI*	RG	C	1920	1920	1920	1920	1920	9600
	OT		192	192	192	192	192	960
Engineering Technician V	RG	C	7680	7680	7680	7680	7680	38400
	OT		768	768	768	768	768	3840
PEARL HARBOR, HI
Engineering Technician VI*	RG	C	1920	1920	1920	1920	1920	9600
	OT		192	192	192	192	192	960
Engineering Technician V	RG	C	5760	7680	7680	7680	7680	36480
	OT		576	768	768	768	768	3648
Total			48576	54,912	54912	54912	54912	268224
Locations & Labor Categories
ON-SITE MARCORPS IRSS SITES (9)
TWENTYNINE PALMS, CA
Engineering Technician VI*	RG	C	1920	1920	1920	1920	1920	9600
	OT		192	192	192	192	192	960
CAMP PENDLETON, CA
Engineering Technician VI*	RG	C	1920	1920	1920	1920	1920	9600
	OT		192	192	192	192	192	960
CHERRY POINT, NC
Engineering Technician VI*	RG	C	1920	1920	1920	1920	1920	9600
	OT		192	192	192	192	192	960
OKINAWA, JP
Engineering Technician VI*	RG	C	1920	1920	1920	1920	1920	9600
	OT		192	192	192	192	192	960
TOWNSEND, GA
Engineering Technician VI*	RG	C	1920	1920	1920	1920	1920	9600
	OT		192	192	192	192	192	960
Locations & Labor Categories			10560	10560	10560	10560	10560	52800
ON-SITE U.S. ARMY IRSS SITES (2)
FORT BRAGG, NC
Engineering Technician VI*	RG	C	3840	3840	3840	3840	3840	19200
	OT		384	384	384	384	384	1920
Engineering Technician V	RG	C	5760	5760	5760	5760	5760	28800
	OT		576	576	576	576	576	2880
			10560	10560	10560	10560	10560	52800

388224

	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	0	0	0	0	0		0
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
1	Subcontractor Name 1	0	0	0	0	0	0	0
2	Subcontractor Name 2	0	0	0	0	0	0	0
3	Etc.	0	0	0	0	0	0	0
	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 Oct 6, 2020.