Attachment_P7_Subcontractor.xls

XLS spreadsheet 138 KB Posted Jul 23, 2015

Attached to: IDS Technical and Integration Support Services
Solicitation number: N00421-15-R-0023
Issued by: Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

From the source

Subcontractor CLIN breakout

View the file

Other files

File	Type	Posted
N00421-15-R-0023-0003.docx	DOCX document	Aug 14, 2015
Attachment_P7_Subcontractor_10Aug15.xls	XLS spreadsheet	Aug 11, 2015
Attachment_P6_Offeror_10Aug15.xls	XLS spreadsheet	Aug 11, 2015
Attachment_2_OCI_(5AUG2015).docx	DOCX document	Aug 11, 2015
N00421-15-R-0023-0002.docx	DOCX document	Aug 11, 2015
Attachment_2_OCI_(29Jul2015).docx	DOCX document	Jul 30, 2015
N00421-15-R-0023-0001.docx	DOCX document	Jul 30, 2015
N00421-15-R-0023.docx	DOCX document	Jul 27, 2015
Attachment_1_QASP.docx	DOCX document	Jul 23, 2015
Attachment_2_OCI_List.doc	DOC document	Jul 23, 2015
Attachment_7_Small_Business_Subcontracting_Plan.doc	DOC document	Jul 23, 2015
Exhibit_B_CDRL_Templates.pdf	PDF	Jul 23, 2015
Attachment_6_Wage_Determinations.txt	TXT text file	Jul 23, 2015
Attachment_8_Issuance_of_Performance_Based_Streamlined_Orders.docx	DOCX document	Jul 23, 2015
Attachment_P5_Past_Performance.doc	DOC document	Jul 23, 2015
Attachment_4_Data_Transmittal.doc	DOC document	Jul 23, 2015
Attachment_5_GFP.pdf	PDF	Jul 23, 2015
N00421-15-R-0023.docx	DOCX document	Jul 23, 2015
Exhibit_A_CDRLs.pdf	PDF	Jul 23, 2015
Attachment_3_DD254.pdf	PDF	Jul 23, 2015
Draft_RFP.pdf	PDF	May 19, 2015

Show all 21

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
	Subcontractor:
1	On Header Tab for each worksheet, insert the proposal number.
2	On Footer Tab for the worksheet, insert the firm's name after colon.
3	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.
4	Within the work sheet any cell colored "blue" contains a formula and should not be edited, unless required to be consistent with the subcontractor's accounting system.
5	All dollar figures shall be carried out no further than two decimal places.
6	In column A, starting at row 5 to 38, the Government Labor Categories from the Historical Information should have been inserted. In column B, the subcontractor can insert the title of the labor category it will be utilizing, which must be comparable to one of the Government Labor Categories. If necessary, insert additional rows--but ensure integrity of formulas. In evaluation, the subcontractor's proposal will be compared to the Government Estimate in terms of labor categories, hours, and labor mix. Also, labor categories with more than one person providing service shall be listed multiple times for each person performing work. For example, if the subcontractor proposes four Senior Analysts, then the labor category Senior Analyst shall be listed four times along with their applicable rates and information.
7	In column C, the subcontractor should insert a "K" if the worker will be performing at the Contractor's facility or a "G" if it will be performing in Government spaces.
8	In column D, the subcontractor should input employees or contingency/prospective hires.
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, enter the name of the proposed individual for that position.
11	In column G:
	(a) for the subcontractor, enter the unburdened labor rate for each individual (e.g. rows 5-38)
	(b) In Cell G40 the subcontractor should insert its fringe rate for full time, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank.
	(c) In Cell G41 the subcontractor should insert its fringe rate for part-time, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank. If no part-time employees are proposed this should also be left blank.
	(d) In Cell G44, the subcontractor should insert its overhead rate for work performed at the contractor's facility.
	(e) In Cell G45, the subcontractor should insert its overhead rate for work performed at the Client/Government's facility.
	(f) In Cell G47, the subcontractor should insert its G&A rate being applied.
	(i) In Cell G52, the subcontractor should insert the fixed fee rate applied to its labor cost.
12	Under Other Direct Costs, the subcontractor should insert the Material, Travel, Shipyard Services, Calibration Services, and NMCI by CLIN.
13	Column W automatically calculated the total hours for all the CLINS.
14	Column Y is a summation of the costs.
15	In cells I63, K63, M63, O63, Q63, S63, and U63 enter the amount for material
16	In cells I71, K71, M71, O71, Q71, S71, and U71 enter the amount for travel
17	In cells I79, K79, M79, O79, Q79, S79, and U79 enter the amount for shipyard services
18	In cells I87, K87, M87, O87, Q87, S87, and U87 enter the amount for calibration services
19	In cells I95, K95, M95, O95, Q95, S95, and U95 enter the amount for NMCI
20	In cell G64, G72, G80, G88, and G96 enter the rate for material handling if it is being applied .
21	In cell G65, G73, G81, G89, and G97 enter the rate for G&A if it is being applied .
22	If there is not going to be any data entry in a row or group of rows, please just hide the rows. Do not delete.
23	When submitting this file, the instructions may be deleted.

&L&8Attachment_P6_CLIN_Breakout_Spreadsheet&R&8Proposal Number:

&L&8KTR: (insert name)&C&8Source Selection Information - See FAR 2.101 & 3.104 &R&8RFP: N00421-15-R-0023

Ordering Period

DO NOT TYPE IN ANY COLORED AREAS
Period of Performance:	06 Apr 16 - 05 Apr 20						CLIN	1000	CLIN	1001	CLIN	1002	CLIN	1003	CLIN	1004	CLIN	1005	CLIN	1006
Services	Contractor						hrs	subtotal	hrs	subtotal	hrs	subtotal	hrs	subtotal	hrs	subtotal	hrs	subtotal	hrs	subtotal	Hrs
Government Labor Category	Proposed Category	site	sub	f/p	Employee Name	Rate		NWCF		OPN		O&MN		RDT&E		FMS		SCN		PRIVATE PARTY	SUM	Total
Administrative Assistant						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Computer Scientist						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Drafter/CAD Operator II						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Drafter/CAD Operator III						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Electronics Technician, Maintenance I						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Electronics Technician, Maintenance II						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Electronics Technician, Maintenance III*						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Engineer/Scientist I						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Engineer/Scientist II						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Engineer/Scientist III*						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Engineering/Electronics Technician, Senior*						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Environmental Technician						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Financial Analyst						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Maintenance Worker						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Logistics Analyst						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Maintenance Technician , Senior						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Operations Security Specialist						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Order Clerk I						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Order Clerk II						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Painter, Maintenance						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Pipefitter, Maintenance						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Production Control Clerk						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Program Analyst						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Project Manager*						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Program Manager*						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Supply Technician						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Technical Instructor/Course Developer						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Technical Writer III						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Welder, Combination, Maintenance						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
Word Processor I						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
x						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
x						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
x						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
x						$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
subtotal							0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	0	$ - 0	- 0	$ - 0
fringe fulltime						0.00%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0		$ - 0
fringe part time						0.00%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0		$ - 0
subtotal								$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Overhead							Base		Base		Base		Base		Base		Base		Base
Contractor site						0.00%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0		$ - 0
Client site						0.00%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0		$ - 0
subtotal								$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
G&A						0.00%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0		$ - 0
COM						0.00%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0		$ - 0
subtotal								$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Total Labor																						$ - 0
Fee/Profit - subcontractor						0.0%	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Total Cost								$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Fee/Profit Pool								$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Total Labor Cost Plus Fee/Profit							-0	$ - 0	-0	$ - 0	-0	$ - 0	-0	$ - 0	-0	$ - 0	-0	$ - 0	-0	$ - 0	- 0	$ - 0
Other Direct Costs
Material							CLIN	2000	CLIN	2001	CLIN	2002	CLIN	2003	CLIN	2004	CLIN	2005	CLIN	2006
								Subtotal		Subtotal		Subtotal		Subtotal		Subtotal		Subtotal		Subtotal
								NWCF		OPN		O&MN		RDT&E		FMS		SCN		PRIVATE PARTY		Total
material								$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
material handling						0.00%		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
G&A on material						0.00%		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Total Material								$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Travel							CLIN	3000	CLIN	3001	CLIN	3002	CLIN	3003	CLIN	3004	CLIN	3005	CLIN	3006
								Subtotal		Subtotal		Subtotal		Subtotal		Subtotal		Subtotal		Subtotal
								NWCF		OPN		O&MN		RDT&E		FMS		SCN		PRIVATE PARTY		Total
travel								$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
material handling						0.00%		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
G&A on travel						0.00%		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Total travel								$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Shipyard Services							CLIN	4000	CLIN	4001	CLIN	4002	CLIN	4003	CLIN	4004	CLIN	4005	CLIN	4006
								Subtotal		Subtotal		Subtotal		Subtotal		Subtotal		Subtotal		Subtotal
								NWCF		OPN		O&MN		RDT&E		FMS		SCN		PRIVATE PARTY		Total
shipyard services								$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
material handling						0.00%		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
G&A on shipyard services						0.00%		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Total shipyard services								$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Calibration Services							CLIN	5000	CLIN	5001	CLIN	5002	CLIN	5003	CLIN	5004	CLIN	5005	CLIN	5006
								Subtotal		Subtotal		Subtotal		Subtotal		Subtotal		Subtotal		Subtotal
								NWCF		OPN		O&MN		RDT&E		FMS		SCN		PRIVATE PARTY		Total
calibration services								$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
material handling						0.00%		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
G&A on calibration services						0.00%		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Total calibration services								$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Grand Total ODCs																						Total
																						$ - 0
Grand Total Services & ODCs																						Total
																						$ - 0

&LAttachment_P6_CLIN_Breakout_Spreadsheet&R(insert proposal number) &A &LKTR:(insert name)&CSource Selection Information See: FAR 2.101 & 3.104&RRFP:N00421-15-R-0023 &L&F &R(insert proposal number) &A &LKTR:(insert name)&CSource Selection Information See: FAR 3.104&RRFP:N00024-09-R-3185

File details come from the government source that posted it. Updated Nov 14, 2017.