Attachment_P6_Cost_Spreadsheet.xls

XLS spreadsheet 41 KB Posted Jul 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

Attachment P-6 - Cost Spreadsheet

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
Amendment 0005 FINAL 8-30-12	—	Aug 30, 2012
N00421-11-R-0055 BID DD254.pdf	PDF	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
Amendment 2_Attachment_P6_Cost_Spreadsheet.xls	XLS spreadsheet	Aug 2, 2012
Q A 3.doc	DOC document	Jul 27, 2012
Z - Question Compilation	—	Jul 24, 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
16 - Final Attachment P6 Cost Spreadsheet.xls	XLS spreadsheet	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_P8- Past Performance Questionaire.doc	DOC document	Jul 2, 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
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
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
COST SUMMARY FORMAT
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:
Contract Total - Base+Options I-IV, and FAR 52.217-8 Option	$ - 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
	Wiring Tech III	30083	61,440			15360			15360			15360			15360
	Wiring Tech III (Overtime)	30083	2,304			576			576			576			576
	Wiring Tech IV	30084	46,080			11520			11520			11520			11520
	Wiring Tech IV (Overtime)	30084	1,920			480			480			480			480
	Sheet Metal III	30083	80,640			19200			19200			21120			21120
	Sheet Metal III (Overtime)	30083	2,304			576			576			576			576
	Sheet Metal IV	30084	38,400			9600			9600			9600			9600
	Sheet Metal IV (Overtime)	30084	3,840			960			960			960			960
	Machinist III	30083	30,720			7680			7680			7680			7680
	Machinist III (Overtime)	30083	768			192			192			192			192
	Machinist IV	30084	30,720			7680			7680			7680			7680
	Machinist IV (Overtime)	30084	1,536			384			384			384			384
	Instrumentation Tech III	30083	65,280			15360			15360			17280			17280
	Instrumentation Tech III (Overtime)	30083	2,304			576			576			576			576
	Instrumentation Tech IV	30084	197,760			48000			49920			49920			49920
	Instrumentation Tech IV (Overtime)	30084	11,520			2880			2880			2880			2880
	Laborer	11210	15,360			3840			3840			3840			3840
	Supply Tech	01410	61,440			15360			15360			15360			15360
	Tech Writer III	30463	19,200			3840			3840			5760			5760
	Tech Writer IV	30364	23,040			3840			5760			5760			7680
	Tool Room	21210	15,360			3840			3840			3840			3840
	Engraver III	30083	7,680			1920			1920			1920			1920
	Engraver IV	30084	7,680			1920			1920			1920			1920
	Aircraft Painter	23050	7,680			1920			1920			1920			1920
	Electroplater	30083	7,680			1920			1920			1920			1920
	Material Handling Labor	21050	28,800			5760			7680			7680			7680
	Material Coordinator	21030	34,560			7680			7680			9600			9600
	Shop Machinery Tech	30082	7,680			1920			1920			1920			1920
	Maintenance Worker	23370	26,880			5760			5760			7680			7680
	Facility Support	30084	23,040			5760			5760			5760			5760
	Sr. Facility Support	30085	27,840			5760			6720			7680			7680
	Shipping / Rec	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	N/A	26,880			3840			5760			7680			9600
	Sr. Engineer	N/A	34,560			7680			7680			9600			9600
	Structural Engineer	N/A	21,120			3840			5760			5760			5760
	Program Manager	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
	Weapons Instrumentation Tech III (West Coast)	30083	34,560			7680			7680			9600			9600
	Weapons Instrumentation Tech IV (West Coast)	30084	36,480			7680			9600			9600			9600
	Subtotal
			71,040			15360			17280			19200			19200
	Total
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.00%								- 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.

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