CLAMP_(WLIC_75D)_DS_FQ2_NEV_15E_Rev0.xlsx

XLSX spreadsheet 26 KB Posted Dec 16, 2014

Attached to: USCGC CLAMP (WLIC 75306) Dock Side Repairs
Solicitation number: HSCG85-15-Q-P45294
Issued by: Department of Homeland Security US Coast Guard

About this file

From the source

CLAMP (WLIC 75D) DS FQ2 NEV 15E Rev0 Blank

View the file

Other files

File	Type	Posted
CLAMP_(WLIC_75D)_DS_FQ2_NEV_15Rev0_(2).pdf	PDF	Dec 16, 2014
PAST_PERFORMANCE_QUESTIONAIRE.docx	DOCX document	Dec 16, 2014
HSCG85_15_Q_P45294_-_Solicitation.pdf	PDF	Dec 16, 2014

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.

SOS&S

GOVERNMENT ESTIMATE FOR:	APM
USCGC CLAMP (WLIC-75D) DOCKSIDE AVAILABILITY FY2015	Date Spec Due
	Date Est Due

ITEM	DESCRIPTION	UNIT PRICE	UNIT	QTY	EXTENDED PRICE
D-001	Ship Service Diesel Generator (SSDG) Exhaust Piping, Commercial Clean	$ - 0	JOB	1	$0.00
D-002	Boiler Exhaust Stack Uptakes, Commercial Clean	$ - 0	JOB	1	$0.00
D-003	Barge, Diesel Engine Exhaust Piping, Commercial Clean	$ - 0	JOB	1	$0.00
D-004	Compressed Air Receivers and System Valves (All), Clean, Inspect, Hydro and Lift - Tender	$ - 0	JOB	1	$0.00
D-005	Compressed Air Receivers and System Valves (All), Clean, Inspect, Hydro and Lift - Barge	$ - 0	JOB	1	$0.00
D-006	Hull Fittings (Weight Handling Rigging Hardware), Inspect and Test - Tender	$ - 0	JOB	1	$0.00
D-007	Compartment(s) Interior, Inspect for Lead-Based Paint	$ - 0	JOB	1	$0.00
D-008	Watertight Door, Renew	$ - 0	JOB	1	$0.00
O-009	Deck Covering (Interior Wet/Dry), Renew	$ - 0	JOB	1	$0.00
D-010	Main Diesel Engine (MDE) Exhaust Stack Uptakes, Clean	$ - 0	JOB	1	$0.00
D-011	Fuel Valves, Overhaul or Renew	$ - 0	JOB	1	$0.00
D-012	Temporary Services, Provide - Tender	$ - 0	JOB	1	$0.00
D-013	Umbilical Receptacles & Deck Penetrations, Tender, Replace	$ - 0	JOB	1	$0.00
D-014	Umbilical Receptacles & Deck Penetrations, Barge, Replace	$ - 0	JOB	1	$0.00
D-015	Plating, 01 Deck, Renew	$ - 0	JOB	1	$0.00
D-016	Hatch, Main Hold, Repair, Barge	$ - 0	JOB	1	$0.00
D-017	Overhead Plating in Main Hold and Other, Renew	$ - 0	JOB	1	$0.00
D-018	Potable Water and Aft Rake Tank Cover Mount Ring, Renew	$ - 0	JOB	1	$0.00
D-019	Watertight Doors & Scuttles, Renew, Barge	$ - 0	JOB	1	$0.00
D-020	Gooseneck Vent Pipes, Renew	$ - 0	JOB	1	$0.00
D-021	Sewage and Waste Water Valves, Renew	$ - 0	JOB	1	$0.00
D-022	Plating, 01 Deck Bulkhead, Renew	$ - 0	JOB	1	$0.00
D-023	Spud Winch Foundations, Renew	$ - 0	JOB	1	$0.00
D-024	Plating, Bulwark Stiffeners, Repair	$ - 0	JOB	1	$0.00
D-025	Sewage Holding Tank(s), Clean and Inspect - Tende	$ - 0	JOB	1	$0.00
D-026	Grey Water Piping, Clean and Flush	$ - 0	JOB	1	$0.00
D-027	Sewage Piping, Clean and Flush	$ - 0	JOB	1	$0.00
D-028	Tender Fuel Oil Supply Header Piping, Renewal	$ - 0	JOB	1	$0.00
D-029	Air Conditioner Condenser, Renew	$ - 0	JOB	1	$0.00
D-030	Sewage Piping Repair	$ - 0	JOB	1	$0.00
D-031	Compartment Insulation, Renew	$ - 0	JOB	1	$0.00
D-032	Wheel House Window Frame, Repair	$ - 0	JOB	1	$0.00
D-033	Hull Fittings (Mooring and Towing), Inspect and Test - Barge	$ - 0	JOB	1	$0.00
D-034	Shower Stall and Drain, Renew	$ - 0	JOB	1	$0.00
D-035	Mechanical Chain Stoppers, Inspect and Service - Barge	$ - 0	JOB	1	$0.00
D-036	Plating, Galley Deck, Renew	$ - 0	JOB	1	$0.00
O-037	Tender Weather Deck Stuffing Tubes, Renew	$ - 0	JOB	1	$0.00
O-038	Ship Surfaces, Spot Abate Lead Coatings	$ - 0	JOB	1	$0.00
O-00A	Composite Labor Rate	$ - 0	Hour	ERROR:#DIV/0!	ERROR:#DIV/0!
D-00B	GFP Report	NSP	EA		NSP
D-00C	Travel and Perdiem	ERROR:#DIV/0!	JOB		ERROR:#DIV/0!
O-00Z	Laydays	$ 500.00	Day	5	$2,500.00
	Total Price of Definite Items				ERROR:#DIV/0!
	Total Price of Option Items				ERROR:#DIV/0!
	Total Price of Definite and Optional Items				ERROR:#DIV/0!
	Remarks:
	Was unable to locate the following RWI/TCTO Specs, And need CSMP specs as indicated.

Brief DesCrption (Include hyperlink to CSMP exported fm FLS) SME Tasked Date Spec Done Type Date Est Done

(9/4/2014)_x000D_ Draft-1 - Page &P of &N

CostEstimateBreakdowns

	Composite Labor Rate	55
	Assumed G&A Factor	15%
	Assumed Profit Factor	10%						Direct Labor										Direct Material/Subs Cost
ITEM	DESCRIPTION	UNIT PRICE	Sub-Contracted (put a "1" in the blank)		Total Labor Hours		Total Material & Subs (cost + G&A + profit)	Eng Tech	Machinest/Pipe Fitter	Electrician	Shipfitter	Welder	Firewatch	Insulator/Lagger	Painter	Gen Labor/Helper/Rigger	Supt/QA/NDT	Mat/Sub Cost 1	Mat/Sub Cost 2	Mat/Sub Cost 3	Mat/Sub Cost 4	Lab Rate	Area	WorkItemID	WIFileID	LoadData
D-001	Main Diesel Engine (MDE) Exhaust Piping, Commercial Clean	$ - 0			0		0															62	Baltimore, MD	5074	1	22
D-002	Ship Service Diesel Generator (SSDG) Exhaust Piping, Commercial Clean	$ - 0			0	45	0															52	Biloxi, MS	693	1	34
D-003	Boiler Exhaust Stack Uptakes, Commercial Clean	$ - 0			0		0															56	Boston, MA	694	1	WLIC 75D
D-004	Barge, Diesel Engine Exhaust Piping, Commercial Clean	$ - 0			0		0															50	Charleston, SC	2843	1	62
D-005	Compressed Air Receivers and System Valves (All), Clean, Inspect, Hydro and Lift - Tender	$ - 0			0	45	0															60	Corpus Christi, TX	347	1	1
D-006	Compressed Air Receivers and System Valves (All), Clean, Inspect, Hydro and Lift - Barge	$ - 0			0	45	0															51	Hampton Roads	347	3	52
D-007	Hull Fittings (Weight Handling Rigging Hardware), Inspect and Test - Tender	$ - 0		3000	0	30	0															64	Honolulu, HI	5138	1	FY2015
D-008	Hull Fittings (Weight Handling Rigging Hardware), Inspect and Test - Barge	$ - 0		5000	0	30	0															55	Houston, TX	5138	3	DS
D-009	Watertight Doors, Renew	$ - 0		4000	0	30	0															56	Los Angeles, CA	2446	3	C
O-009	Deck Covering (Interior Wet/Dry), Renew	$ - 0			0	30	0															55	Median Rate	665	1	CLAMP (WLIC 75D) DS FQ2 NEV 15D1.doc
D-011	Main Diesel Engine (MDE) Exhaust Stack Uptakes, Clean	$ - 0			0	45	0															49	Miami	1731	1
D-012	Fuel Valves, Overhaul or Renew	$ - 0			0	45	0															50	Narragansett Bay, RI	688	1
D-013	Temporary Services, Provide - Tender	$ - 0			0	45	0															55	New London, CN	10000	0
D-014	Umbilical Receptacles & Deck Penetrations, Tender, Replace	$ - 0			0	45	0															45	New Orleans	10000	0
D-015	Umbilical Receptacles & Deck Penetrations, Barge, Replace	$ - 0			0	45	0															62	NYNY	10000	0
D-016	Plating, 01 Deck, Renew	$ - 0			0	45	0															49	Panama City, FL	10000	0
D-017	Hatch, Main Hold, Repair, Barge	$ - 0			0	45	0															60	Philadelphia, PA	10000	0
D-018	Overhead Plating in Main Hold and Other, Renew	$ - 0			0	45	0															51	Portland, ME	10000	0
D-019	Potable Water and Aft Rake Tank Cover Mount Ring, Renew	$ - 0			0	45	0															57	Portland, OR	10000	0
D-020	Watertight Doors, Repair, Barge	$ - 0			0	45	0															55	San Diego, CA	10000	0
D-021	Gooseneck Vent Pipes, Renew	$ - 0			0	45	0															67	San Francisco, CA	10000	0
D-022	Sewage and Waste Water Valves, Renew	$ - 0			0	45	0															55	Santa Barbara, CA	10000	0
	Plating, 01 Deck Bulkhead, Renew					45																55	SE North Carolina
	Spud Winch Foundations, Renew					45
	Plating, Bulwark Stiffeners, Repair					45
	Sewage Holding Tank(s), Clean and Inspect - Tende					45
	Grey Water Piping, Clean and Flush					45
	Sewage Piping, Clean and Flush					45
	Tender Fuel Oil Supply Header Piping, Renewal					45
	Air Conditioner Condenser, Renew					45
	Sewage Piping Repair					45
	Compartment Insulation, Renew			80000		30
	Mounting Stud, Wheel House, Renew					45

Shower Stall and Drains, Renew	45
Mechanical Chain Stoppers, Inspect and Service - Barge	45
		65	Seattle, WA
		48	Tampa-St. Petersburg
		60	Wilmington, DE

(09/28/2009)_x005F_x000D__x000D_ Page &P of &N

CostEstimateTemplate

	Composite Labor Rate	55
	Assumed G&A Factor	15%
	Assumed Profit Factor	10%						Direct Labor										Direct Material/Subs Cost
			Sub-Contracted (put a "1" in the blank)		Total Labor Hours		Total Material & Subs (cost + G&A + profit)	Eng Tech	Machinest/Pipe Fitter	Electrician	Shipfitter	Welder	Firewatch	Insulator/Lagger	Painter	Gen Labor/Helper/Rigger	Supt/QA/NDT
	DESCRIPTION	UNIT PRICE																	Lab Rate	Area
	Ship Service Diesel Generator (SSDG) Exhaust Piping, Commercial Clean	$0			0	45	$0												62	Baltimore, MD
	Boiler Exhaust Stack Uptakes, Commercial Clean	$0			0		$0												52	Biloxi, MS
	Barge, Diesel Engine Exhaust Piping, Commercial Clean	$0			0		$0												56	Boston, MA
	Compressed Air Receivers and System Valves (All), Clean, Inspect, Hydro and Lift - Tender	$0			0	45	$0												50	Charleston, SC
	Compressed Air Receivers and System Valves (All), Clean, Inspect, Hydro and Lift - Barge	$0			0	45	$0												60	Corpus Christi, TX
	Hull Fittings (Weight Handling Rigging Hardware), Inspect and Test - Tender	$0		3000	0	30	$0												64	Honolulu, HI
	Hull Fittings (Weight Handling Rigging Hardware), Inspect and Test - Barge	$0		5000	0	30	$0												55	Houston, TX
	Watertight Doors, Renew	$0		4000	0	30	$0												56	Los Angeles, CA
O-009	Deck Covering (Interior Wet/Dry), Renew	$0			0	30	$0												55	Median Rate
	Main Diesel Engine (MDE) Exhaust Stack Uptakes, Clean	$0			0	45	$0												55	Median Rate
	Fuel Valves, Overhaul or Renew	$0			0	45	$0												50	Narragansett Bay, RI
	Temporary Services, Provide - Tender					45													55	New London, CN
	Umbilical Receptacles & Deck Penetrations, Tender, Replace					45													45	New Orleans
	Umbilical Receptacles & Deck Penetrations, Barge, Replace					45													62	NYNY
	Plating, 01 Deck, Renew					45													49	Panama City, FL
	Hatch, Main Hold, Repair, Barge					45													60	Philadelphia, PA
	Overhead Plating in Main Hold and Other, Renew					45													51	Portland, ME
	Potable Water and Aft Rake Tank Cover Mount Ring, Renew					45													57	Portland, OR
	Watertight Doors, Repair, Barge					45													55	San Diego, CA
	Gooseneck Vent Pipes, Renew					45													67	San Francisco, CA
	Sewage and Waste Water Valves, Renew					45													55	Santa Barbara, CA
	Plating, 01 Deck Bulkhead, Renew					45													55	SE North Carolina
	Spud Winch Foundations, Renew					45
	Plating, Bulwark Stiffeners, Repair					45
	Sewage Holding Tank(s), Clean and Inspect - Tende					45
	Grey Water Piping, Clean and Flush					45
	Sewage Piping, Clean and Flush					45
	Tender Fuel Oil Supply Header Piping, Renewal					45
	Air Conditioner Condenser, Renew					45
	Sewage Piping Repair					45
	Compartment Insulation, Renew			80000		30
	Mounting Stud, Wheel House, Renew					45

Shower Stall and Drains, Renew	45
Mechanical Chain Stoppers, Inspect and Service - Barge	45
		65	Seattle, WA
		48	Tampa-St. Petersburg
		60	Wilmington, DE

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