ATT06R1_17-R-0007_Cost_Summary_Format.xls

XLS spreadsheet 70 KB Posted Aug 31, 2017

Attached to: Waterfront Operations Sppt Norfolk VA
Solicitation number: N00167-17-R-0007
Issued by: Department of the Navy Naval Sea Systems Command

About this file

From the source

N00167-17-R-0007 Amendment 4 Attachment 6R1

View the file

Other files

File	Type	Posted
ATT14_17_R-0007_Industry_Questions_Amendment_0004.docx	DOCX document	Aug 31, 2017
N00167-17-R-0007_Amendment_4.docx	DOCX document	Aug 31, 2017
N00167-17-R-0007_Amendment_3.pdf	PDF	Aug 24, 2017
ATT06R_17-R-0007_Cost_SummaryFormat.xls	XLS spreadsheet	Aug 15, 2017
ATT13R_17_R-0007_Site_Visit_and_Industry_Questions.docx	DOCX document	Aug 15, 2017
ATT11R_17-R-0007_DOL_Wage_Deter_15_4342_General.pdf	PDF	Aug 15, 2017
ATT05R_17-R-0007_Previous_Contracting_Efforts.doc	DOC document	Aug 15, 2017
ATT10R_17-R-0007_DOL_Wage_Deter_07_0134_Diver.pdf	PDF	Aug 15, 2017
ATT08R_17_R_0007_Historical_Labor_and_Sample_listing_of_ESH_Hazmat_Reports.xlsx	XLSX spreadsheet	Aug 15, 2017
N00167-17-R-0007_Amendment_2.docx	DOCX document	Aug 15, 2017
ATT03R_17-R-0007_Staffing_Plan_With_Cost.xlsx	XLSX spreadsheet	Aug 15, 2017
ATT04R_17-R-0007_Past_Performance_Questionnaire.doc	DOC document	Aug 15, 2017
ATT07R-17-R-0007_DirectLaborRateSubstantiationTable.xls	XLS spreadsheet	Aug 15, 2017
N00167-17-R-0007_Amendment_2_Conformed.docx	DOCX document	Aug 15, 2017
ATT02R_17-R-0007_Staffing_Plan_No_Cost.xlsx	XLSX spreadsheet	Aug 15, 2017
N00167-17-R-0007_Amendment_0001.docx	DOCX document	Aug 1, 2017
Solicitation_Questions_2017_07_18.docx	DOCX document	Jul 18, 2017
ATT01_17-R-0007 DD254 Waterfront Rev 2-22-2017.pdf	PDF	Jul 6, 2017
ATT10_17-R-0007_DOL Wage_Deter_07-0134_Diver.txt	TXT text file	Jul 6, 2017
ATT04_17-R-0007_Past_Performance_Questionnaire.doc	DOC document	Jul 6, 2017
ATT03_17-R-0007_Staffing_Plan_With_Cost.xlsx	XLSX spreadsheet	Jul 6, 2017
A012 CDRL.pdf	PDF	Jul 6, 2017
ATT08_17-R-0007_Historical_Labor_Hours_Report.xlsx	XLSX spreadsheet	Jul 6, 2017
ATT05_17-R-0007_Previous_Contracting_Efforts.doc	DOC document	Jul 6, 2017
A001 CDRL.pdf	PDF	Jul 6, 2017
A006 CDRL.pdf	PDF	Jul 6, 2017
A002 CDRL.pdf	PDF	Jul 6, 2017
ATT11_17-R-0007_DOL_Wage_Deter_15-4342_General.txt	TXT text file	Jul 6, 2017
ATT12_17-R-0007_DOL_Wage_Deter_15-0213.txt	TXT text file	Jul 6, 2017
A010 CDRL.pdf	PDF	Jul 6, 2017
A013 CDRL.pdf	PDF	Jul 6, 2017
A008 CDRL.pdf	PDF	Jul 6, 2017
A011 CDRL.pdf	PDF	Jul 6, 2017
A007 CDRL.pdf	PDF	Jul 6, 2017
A009 CDRL.pdf	PDF	Jul 6, 2017
N00167-17-R-0007.pdf	PDF	Jul 6, 2017
A004 CDRL.pdf	PDF	Jul 6, 2017
ATT07-17-R-0007_DirectLaborRateSubstantiationTable.xls	XLS spreadsheet	Jul 6, 2017
A003 CDRL.pdf	PDF	Jul 6, 2017
ATT06_17-R-0007_Cost_SummaryFormat.xls	XLS spreadsheet	Jul 6, 2017
A005 CDRL.pdf	PDF	Jul 6, 2017
ATT09-17-R-0007_DDForm1861.pdf	PDF	Jul 6, 2017
ATT02_17-R-0007_Staffing_Plan_No_Cost.xlsx	XLSX spreadsheet	Jul 6, 2017
N00167-17-R-0007.pdf	PDF	Feb 3, 2017
pdp30872_17_02_03.pdf	PDF	Feb 3, 2017

Show all 45

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.

FFP_CPFF

SOLICITATION NO. N00167-17-R-0007 - ATTACHMENT 6R1
COST SUMMARY FORMAT
Prime Offeror Name:
Subcontractor Name (if applicable):
DCAA Point of Contact Information:
Firm Fixed Price				Total for All Years		Year 1			Year 2			Year 3			Year 4			Year 5
Labor Category		Service Contract Exempt (Y/N)	Escalation Factor Applied to SCA exempt categories (Y/N)	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount
Total FFP CLIN:				0			0			0			0			0			0
Cost Plus Fixed Fee				Total for All Years		Year 1			Year 2			Year 3			Year 4			Year 5
Cost Elements	Labor Category	Service Contract Exempt (Y/N)	Escalation Factor Applied to SCA exempt categories (Y/N)	Hours	Amount	Rate	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	Able Seaman			38400			7680			7680			7680			7680			7680
Employee Name 2	Able Seaman OT			3000			600			600			600			600			600
Etc.	Boat Captain A			57600		57600	11520			11520			11520			11520			11520
	Boat Captain A OT			22200		22200	4440			4440			4440			4440			4440
	Boat Captain B			79200			15840			15840			15840			15840			15840
	Boat Captain B OT			3000			600			600			600			600			600
	Diver			400			80			80			80			80			80
	Diver OT			50			10			10			10			10			10
	Electrician			30400			6080			6080			6080			6080			6080
	Electrician OT			900			180			180			180			180			180
	Electrostatic Spray Painter			400			80			80			80			80			80
	Emergency Medical Technician			19200			3840			3840			3840			3840			3840
	Emergency Medical Technician OT			900			180			180			180			180			180
	Engineering Tech I (Electronics)			200			40			40			40			40			40
	Engineering Tech II (Electronics)			200			40			40			40			40			40
	Engineering Tech III (Electronics)			38500			7700			7700			7700			7700			7700
	Engineering Tech III (Electronics) OT			1200			240			240			240			240			240
	Engineering Tech IV (Electronics)			38400			7680			7680			7680			7680			7680
	Engineering Tech IV (Electronics) OT			1200			240			240			240			240			240
	Engineering Tech V (Electronics)			19200			3840			3840			3840			3840			3840
	Engineering Tech V (Electronics) OT			600			120			120			120			120			120
	Engineering Tech IV (Mech)			38400			7680			7680			7680			7680			7680
	Engineering Tech IV (Mech) OT			1200			240			240			240			240			240
	Engineering Tech V (Mech)			28800			5760			5760			5760			5760			5760
	Engineering Tech V (Mech) OT			1200			240			240			240			240			240
	Engineman			38400			7680			7680			7680			7680			7680
	Engineman OT			1500			300			300			300			300			300
	Fabric Worker			4800			960			960			960			960			960
	Fire Alarm System Mechanic			200			40			40			40			40			40
	Fire Extinguisher Repairer			200			40			40			40			40			40
	Heavy Equipment Operator			960			192			192			192			192			192
	HVAC Mechanic			200			40			40			40			40			40
	Instrument Mechanic			200			40			40			40			40			40
	Laboratory Technician			100			20			20			20			20			20
	Laborer			52800			10560			10560			10560			10560			10560
	Laborer OT			600			120			120			120			120			120
	Locksmith			80			16			16			16			16			16
	Machine Tool Operator			400			80			80			80			80			80
	Machinist			19200			3840			3840			3840			3840			3840
	Machinist OT			600			120			120			120			120			120
	Marine Chemist			200			40			40			40			40			40
	Marine Propeller Repairer			2400			480			480			480			480			480
	Marine Surveyor			4800			960			960			960			960			960
	Mechanic			67200			13440			13440			13440			13440			13440
	Mechanic OT			1800			360			360			360			360			360
	Metrology Technician I			400			80			80			80			80			80
	Metrology Technician II			400			80			80			80			80			80
	Metrology Technician III			200			40			40			40			40			40
	OEM Caterpillar Technician			400			80			80			80			80			80
	OEM Cummins Technician			4800			960			960			960			960			960
	OEM Detroit Diesel Technician			200			40			40			40			40			40
	OEM Furuno Technician			400			80			80			80			80			80
	OEM Hamilton Jet Technician			400			80			80			80			80			80
	OEM Mercury Technician			200			40			40			40			40			40
	OEM Motoren Turbinen Union (MTU) Tech			4800			960			960			960			960			960
	OEM Rolls Royce Kamewa Technician			4800			960			960			960			960			960
	OEM Steyr Technician			400			80			80			80			80			80
	OEM Twin Disc Technician			200			40			40			40			40			40
	OEM Yanmar Technician			400			80			80			80			80			80
	OEM Twin Disc, ZF Technician			200			40			40			40			40			40
	Ordinary Seaman			38400			7680			7680			7680			7680			7680
	Ordinary Seaman OT			1500			300			300			300			300			300
	Painter			9600			1920			1920			1920			1920			1920
	Photographer V			200			40			40			40			40			40
	Pipe Fitter			400			80			80			80			80			80
	Pneudraulic Systems Mechanic			1920			384			384			384			384			384
	Rigger			1920			384			384			384			384			384
	Sand Blaster			1200			240			240			240			240			240
	Sheet Metal Worker			200			40			40			40			40			40
	Shipfitter			9600			1920			1920			1920			1920			1920
	Small Engine Mechanic			960			192			192			192			192			192
	Technical Instructor/Course Developer			1600			320			320			320			320			320
	Tool and Die Maker			200			40			40			40			40			40
	Truckdriver			24000			4800			4800			4800			4800			4800
	Truckdriver OT			600			120			120			120			120			120
	Welder			24000			4800			4800			4800			4800			4800
	Welder OT			1200			240			240			240			240			240
	Woodcraft/Fiber Reinforced Plastic Worker			9600			1920			1920			1920			1920			1920
Total Direct Labor Cost
Prime Contractor Indirect Labor Cost
Overhead
Fringe Benefits
G&A
Total Indirect Labor Cost
Total Direct and Indirect Labor cost
COM
Total Prime Contractor Labor Cost
Subcontractor Labor Cost
Subcontractor proposed cost and fee
Subcontractor 1
Subcontractor 2
Etc.
Total proposed subcontractor labor cost and fee
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
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)
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):				766690			153338			153338			153338			153338			153338
CPFF 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)				0%
CPFF 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.