Amendment 2_Attachment_P6_Cost_Spreadsheet.xls

XLS spreadsheet 55 KB Posted Aug 2, 2012

Attached to: Air Vehicle Modification and Instrumentation (AVMI) Federal contract opportunity
Solicitation number: N00421-11-R-0055
Issued by: Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

From the source

Amendment 2 - Revised Attachment P6

View the file

Other files for this federal contract opportunity

Other files attached to Air Vehicle Modification and Instrumentation (AVMI), newest first.
File	Type	Posted
Amendment 0006 FINAL 9-4-12.doc	DOC document	Sep 4, 2012
N00421-11-R-0055 BID DD254.pdf	PDF	Aug 30, 2012
Amendment 0005 FINAL 8-30-12	—	Aug 30, 2012
Amendment 0004.doc	DOC document	Aug 16, 2012
N00421-11-R-0055 Amendment 3 Conform Document.doc	DOC document	Aug 10, 2012
N00421-11-R-0055 Amendment 3.rtf	RTF text file	Aug 10, 2012
Amendment 3 - Section L.doc	DOC document	Aug 8, 2012
Question 52 - 54.doc	DOC document	Aug 8, 2012
AVMI I.pdf	PDF	Aug 6, 2012
AVMI II.pdf	PDF	Aug 6, 2012
Questions 51 -.doc	DOC document	Aug 6, 2012
Amendment 2_MD Revised.txt	TXT text file	Aug 2, 2012
Amendment 2_CA - Ventura County.txt	TXT text file	Aug 2, 2012
Amendment 2.doc	DOC document	Aug 2, 2012
Amendment 2 - Conform Document.doc	DOC document	Aug 2, 2012
Amendment 2_CA Revised - Kern County.txt	TXT text file	Aug 2, 2012
Q A 3.doc	DOC document	Jul 27, 2012
Z - Question Compilation	—	Jul 24, 2012
16 - Final Attachment P6 Cost Spreadsheet.xls	XLS spreadsheet	Jul 18, 2012
19 - Final Exhibit A CDRLS A001 and A002.doc	DOC document	Jul 18, 2012
9 - Final Attachment 5 OCI List.doc	DOC document	Jul 18, 2012
18 - Final Attachment P8- Past Performance Questionaire.doc	DOC document	Jul 18, 2012
1 - Final RFP for AVMI	—	Jul 18, 2012
6 - Final Attachment 2 Department of Labor Wage Determination - Maryland.txt	TXT text file	Jul 18, 2012
21 - Final Exhibbit A CDRLS A005 and A006.doc	DOC document	Jul 18, 2012
17 - Final Attachment P7 - CPARS Update Questionaire.doc	DOC document	Jul 18, 2012
11 - Final Attachment 7 Equipment List.pdf	PDF	Jul 18, 2012
20 -Final Exhibit A CDRLS A003 and A004.doc	DOC document	Jul 18, 2012
14 - Final Attachment P4 Past Performance Matrix.doc	DOC document	Jul 18, 2012
12 - Final Attachment P1 Workforce Qualifications.xls	XLS spreadsheet	Jul 18, 2012
5 - Final Attachment 1 - DD254.pdf	PDF	Jul 18, 2012
15 - Final Attachment P5 Past Performance Questionnaire Package for Services.doc	DOC document	Jul 18, 2012
Q A Posted to FedBizOpps - 1 thru 21.pdf	PDF	Jul 18, 2012
Attachment_P4_Past_Performance_Matrix.doc	DOC document	Jul 2, 2012
Attachment_6_SAAR.pdf	PDF	Jul 2, 2012
Attachment_P7 - CPARS Update Questionaire.doc	DOC document	Jul 2, 2012
Attachment_P5_Past_Performance_Questionnaire_Package_for_Services.doc	DOC document	Jul 2, 2012
Attachment_3_Department of Labor Wage Determination - California.txt	TXT text file	Jul 2, 2012
Attachment_P8- Past Performance Questionaire.doc	DOC document	Jul 2, 2012
Exhibit_A_CDRLs_A001_and_A002.doc	DOC document	Jul 2, 2012
Exhibbit_A_CDRLS_A005_and_A006.doc	DOC document	Jul 2, 2012
Attachment_1_DD254.pdf	PDF	Jul 2, 2012
Attachment_5_OCI_List.doc	DOC document	Jul 2, 2012
Attachment_P1_Workforce_Qualifications.xls	XLS spreadsheet	Jul 2, 2012
Attachment_7_Equipment List.pdf	PDF	Jul 2, 2012
Attachment_2_ Department of Labor Wage Determination - Maryland.txt	TXT text file	Jul 2, 2012
Attachment_P6_Cost_Spreadsheet.xls	XLS spreadsheet	Jul 2, 2012
Exhibit_A_CDRLS_A003_and_A004.doc	DOC document	Jul 2, 2012
Attachment_4_QASP.doc	DOC document	Jul 2, 2012
Final RFP for AVMI	—	Jul 2, 2012

Show all 50

Air Vehicle Modification and Instrumentation (AVMI) has more files on GovTribe.

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.

CPFF

SOLICITATION NO. N00421-11-R-0055 - ATTACHMENT P6 Amendment #2
COST SUMMARY FORMAT
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:
Contract Total - Base+Options I-III	$ - 0		Total for All Years		Base Period			Option Year I			Option Year II			Option Year III
Cost Elements	Labor Category	SCA	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount
Prime Contractor Labor Cost
Prime Contractor Direct Labor
Employee Name 1	Drafter III	30063	84,480			21120			21120			21120			21120
Employee Name 2	Drafter IV	30064	69,120			17280			17280			17280			17280
Etc.	Engineering Tech I	30081	84,480			21120			21120			21120			21120
	Engineering Tech I (Overtime)	30081	2,536			634			634			634			634
	Engineering Tech II	30082	138,240			34560			34560			34560			34560
	Engineering Tech II (Overtime)	30082	3,840			960			960			960			960
	Engineering Technician III (Aircraft Wiring Tech)	30083	61,440			15360			15360			15360			15360
	Engineering Technician III (Aircraft Wiring Tech)(Overtime)	30083	2,304			576			576			576			576
	Engineering Technician IV (Aircraft Wiring Tech)	30084	46,080			11520			11520			11520			11520
	Engineering Technician IV (Aircraft Wiring Tech)(Overtime)	30084	1,920			480			480			480			480
	Engineering Technician III (Aircraft Sheet Metal Mechanic)	30083	80,640			19200			19200			21120			21120
	Engineering Technician III (Aircraft Sheet Metal Mechanic)(Overtime)	30083	2,304			576			576			576			576
	Engineering Technician IV (Aircraft Sheet Metal Mechanic)	30084	38,400			9600			9600			9600			9600
	Engineering Technician IV (Aircraft Sheet Metal Mechanic)(Overtime)	30084	3,840			960			960			960			960
	Engineering Technician III (Machinist)	30083	30,720			7680			7680			7680			7680
	Engineering Technician III (Machinist)(Overtime)	30083	768			192			192			192			192
	Engineering Technician IV (Machinist)	30084	30,720			7680			7680			7680			7680
	Engineering Technician IV (Machinist)(Overtime)	30084	1,536			384			384			384			384
	Engineering Technician III (Instrumentation Tech)	30083	65,280			15360			15360			17280			17280
	Engineering Technician III (Instrumentation Tech)(Overtime)	30083	2,304			576			576			576			576
	Engineering Technician IV (Instrumentation Tech)	30084	197,760			48000			49920			49920			49920
	Engineering Technician IV (Instrumentation Tech)(Overtime)	30084	11,520			2880			2880			2880			2880
	Laborer	11210	15,360			3840			3840			3840			3840
	Senior Aircraft Kitting & Supply Function Technician (Supply Technician)	01410	61,440			15360			15360			15360			15360
	Technical Writer III	30463	19,200			3840			3840			5760			5760
	Technical Writer IV	N/A	23,040			3840			5760			5760			7680
	Tool and Parts Attendant	21210	15,360			3840			3840			3840			3840
	Engraver III (Engineering Technician III)	30083	7,680			1920			1920			1920			1920
	Engraver IV (Engineering Technician IV)	30084	7,680			1920			1920			1920			1920
	Aircraft Painter	23050	7,680			1920			1920			1920			1920
	Electroplater (Engineering Technician III)	30083	7,680			1920			1920			1920			1920
	Junior Aircraft Kitting Technician (Material Handling Laborer)	21050	28,800			5760			7680			7680			7680
	Aircraft Kitting Technician (Material Coordinator)	21030	34,560			7680			7680			9600			9600
	Shop Machinery Technician (Engineering Tech II)	30082	7,680			1920			1920			1920			1920
	General Maintenance Worker	23370	26,880			5760			5760			7680			7680
	Facility Support (Engineering Technician IV)	30084	23,040			5760			5760			5760			5760
	Senior Aircraft Hangar Manager (Engineering Technician V)	30085	27,840			5760			6720			7680			7680
	Shipping and Receiving Clerk	21130	15,360			3840			3840			3840			3840
	Engineer	N/A	61,440			15360			15360			15360			15360
	Instrumentation Engineer	N/A	61,440			15360			15360			15360			15360
	Systems Engineer (KEY)	N/A	26,880			3840			5760			7680			9600
	Senior Engineer	N/A	34,560			7680			7680			9600			9600
	Structural Engineer (KEY)	N/A	21,120			3840			5760			5760			5760
	Program Manager (KEY)	N/A	7,680			1920			1920			1920			1920
	Secretary I	01311	15,360			3840			3840			3840			3840
	Secretary II	01312	23,040			5760			5760			5760			5760
	Secretary III	01313	13,440			1920			3840			3840			3840
	Administrative Assistant	01020	15,360			3840			3840			3840			3840
	Subtotal		1,569,832			374,938			387,418			401,818			405,658
	Electronics Technician III (AISD)(West Coast)	30083	34,560
	China Lake			19,200		3,840			3,840			5760			5760
	Pt Mugu			15,360		3,840			3,840			3840			3840
	Electronics Technician IV (AISD)(West Coast)	30084	36,480
	China Lake			21,120		3,840			5760			5760			5760
	Pt Mugu			15,360		3,840			3840			3840			3840
	Subtotal
Total Direct Labor Cost			1,640,872			390,298			404,698			421,018			424,858
Prime Contractor Indirect Labor Cost	Proposed Rates											- 0			- 0
Overhead	X.XX%											- 0			- 0
Fringe Benefits	X.XX%											- 0			- 0
G&A	X.XX%											- 0			- 0
Total Indirect Labor Cost															- 0
Total Direct and Indirect Labor cost															- 0
COM															- 0
Total Prime Contractor Labor Cost															- 0
															- 0
Subcontractor Labor Cost															- 0
Subcontractor proposed cost and fee															- 0
Subcontractor 1															- 0
Subcontractor 2															- 0
Etc.															- 0
Total proposed subcontractor labor cost and fee															- 0
Prime contractor pass through (not including fee)	Proposed Rates														- 0
Handling	X.XX%														- 0
G&A	X.XX%														- 0
Other (if any)	X.XX%														- 0
Total pass through (not including fee)	X.XX%														- 0
Total Subcontractor Cost including pass through															- 0
															- 0
Total Labor Cost (Prime and Subcontractor Labor)															- 0
	Proposed Rates														- 0
Fixed Fee															- 0
Prime Contractor Fee for Prime Contractor Labor	X.XX%														- 0
Prime Contractor Fee for Subcontractor Labor *	X.XX%														- 0
Total Fee (for Prime and Subcontractor Labor)	X.XX%														- 0
															- 0
Total Labor Cost Plus Fixed Fee (CPFF)															- 0
Other Direct Costs	Proposed Rates
Travel				$ 2,000,000.00			$ 500,000.00			$ 500,000.00			$ 500,000.00			$ 500,000.00
Material				$ 6,000,000.00			$ 1,500,000.00			$ 1,500,000.00			$ 1,500,000.00			$ 1,500,000.00
Any adders to ODCs such as G&A (cost only - no fee)	X.XX%
Total ODCs
Total CPFF all CLINs (Labor and ODCs)
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)
Maximum Pass Through Allowed by SeaPort-e IDIQ Contract			8%
Fee Analysis - Total for All Years	Amount		Percent
Prime Contractor Labor Cost
Fixed Fee for Labor Performed by Prime Contractor			0%
Maximum Fixed Fee Allowed by SeaPort-e IDIQ Contract
* When analyzing pass through costs, the Government will consider prime offeror fee on subcontractor price as an element of pass through as explained in the Section H Savings Clause of the MACs. In Section B, however, 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.

RFP

Labor Category	SCA	Total	Base	OY I	OY II	OY III
Drafter III	30063	84,480	21120	21120	21120	21120
Drafter IV	30064	69,120	17280	17280	17280	17280
Engineering Tech I	30081	84,480	21120	21120	21120	21120
Engineering Tech I (Overtime)	30081	2,536	634	634	634	634
Engineering Tech II	30082	138,240	34560	34560	34560	34560
Engineering Tech II (Overtime)	30082	3,840	960	960	960	960
Engineering Technician III (Aircraft Wiring Tech)	30083	61,440	15360	15360	15360	15360
Engineering Technician III (Aircraft Wiring Tech)(Overtime)	30083	2,304	576	576	576	576
Engineering Technician IV (Aircraft Wiring Tech)	30084	46,080	11520	11520	11520	11520
Engineering Technician IV (Aircraft Wiring Tech)(Overtime)	30084	1,920	480	480	480	480
Engineering Technician III (Aircraft Sheet Metal Mechanic)	30083	80,640	19200	19200	21120	21120
Engineering Technician III (Aircraft Sheet Metal Mechanic)(Overtime)	30083	2,304	576	576	576	576
Engineering Technician IV (Aircraft Sheet Metal Mechanic)	30084	38,400	9600	9600	9600	9600
Engineering Technician IV (Aircraft Sheet Metal Mechanic)(Overtime)	30084	3,840	960	960	960	960
Engineering Technician III (Machinist)	30083	30,720	7680	7680	7680	7680
Engineering Technician III (Machinist)(Overtime)	30083	768	192	192	192	192
Engineering Technician IV (Machinist)	30084	30,720	7680	7680	7680	7680
Engineering Technician IV (Machinist)(Overtime)	30084	1,536	384	384	384	384
Engineering Technician III (Instrumentation Tech)	30083	65,280	15360	15360	17280	17280
Engineering Technician III (Instrumentation Tech)(Overtime)	30083	2,304	576	576	576	576
Engineering Technician IV (Instrumentation Tech)	30084	197,760	48000	49920	49920	49920
Engineering Technician IV (Instrumentation Tech)(Overtime)	30084	11,520	2880	2880	2880	2880
Laborer	11210	15,360	3840	3840	3840	3840
Senior Aircraft Kitting & Supply Function Technician (Supply Technician)	01410	61,440	15360	15360	15360	15360
Technical Writer III	30463	19,200	3840	3840	5760	5760
Technical Writer IV	N/A	23,040	3840	5760	5760	7680
Tool and Parts Attendant	21210	15,360	3840	3840	3840	3840
Engraver III (Engineering Technician III)	30083	7,680	1920	1920	1920	1920
Engraver IV (Engineering Technician IV)	30084	7,680	1920	1920	1920	1920
Aircraft Painter	23050	7,680	1920	1920	1920	1920
Electroplater (Engineering Technician III)	30083	7,680	1920	1920	1920	1920
Junior Aircraft Kitting Technician (Material Handling Laborer)	21050	28,800	5760	7680	7680	7680
Aircraft Kitting Technician (Material Coordinator)	21030	34,560	7680	7680	9600	9600
Shop Machinery Technician (Engineering Tech II)	30082	7,680	1920	1920	1920	1920
General Maintenance Worker	23370	26,880	5760	5760	7680	7680
Facility Support (Engineering Technician IV)	30084	23,040	5760	5760	5760	5760
Senior Aircraft Hangar Manager (Engineering Technician V)	30085	27,840	5760	6720	7680	7680
Shipping and Receiving Clerk	21130	15,360	3840	3840	3840	3840
Engineer	N/A	61,440	15360	15360	15360	15360
Instrumentation Engineer	N/A	61,440	15360	15360	15360	15360
Systems Engineer (KEY)	N/A	26,880	3840	5760	7680	9600
Senior Engineer	N/A	34,560	7680	7680	9600	9600
Structural Engineer (KEY)	N/A	21,120	3840	5760	5760	5760
Program Manager (KEY)	N/A	7,680	1920	1920	1920	1920
Secretary I	01311	15,360	3840	3840	3840	3840
Secretary II	01312	23,040	5760	5760	5760	5760
Secretary III	01313	13,440	1920	3840	3840	3840
Administrative Assistant	01020	15,360	3840	3840	3840	3840
Subtotal		1,569,832	374938	387418	401818	405658
Electronics Technician III (AISD)(West Coast)	30083	34,560
China Lake			3840	3840	5760	5760
Pt Mugu			3840	3840	3840	3840
Electronics Technician IV (AISD)(West Coast)	30084	36,480
China Lake			3840	5760	5760	5760
Pt Mugu			3840	3840	3840	3840
Subtotal
Total
		1,640,872	390,298	404,698	421,018	424,858
		1,640,872

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