Attachment_J-4_Pricing_Worksheet.xlsx

XLSX spreadsheet 39 KB Posted Mar 25, 2019

Attached to: USS SSBN Submarine Engineered Refueling Overhaul (ERO) Preservation and non-SUBSAFE Structural Repairs
Solicitation number: N4523A19R0800
Issued by: Department of the Navy Naval Sea Systems Command

About this file

From the source

Pricing Worksheet

View the file

Other files

File	Type	Posted
N4523A19R0800_0006.pdf	PDF	May 21, 2019
N4523A19R0800__Amendment_Summary.pdf	PDF	May 21, 2019
N4523A19R0800__Amendment_8_Answer_To_Request_for_Clarification.pdf	PDF	May 14, 2019
N4523A19R0800__Amendment_8_Summary.pdf	PDF	May 14, 2019
Attachment_J-4_Pricing_Worksheet_Revised_09_May_19.xlsx	XLSX spreadsheet	May 9, 2019
NWRMC-501-20_ERRATA_2.pdf	PDF	May 9, 2019
N4523A19R0800_Amendment__7_Clarifications.pdf	PDF	May 9, 2019
N4523A19R0800__Amendment_6_Summary.pdf	PDF	Apr 24, 2019
LAC-_Errata_Pkg__1.pdf	PDF	Apr 24, 2019
N4523A19R0800__Amendment_5_Summary_17_Apr_19.pdf	PDF	Apr 17, 2019
Attachment_J-4_Pricing_Worksheet_Revised_16_Apr_19.xlsx	XLSX spreadsheet	Apr 17, 2019
N4523A19R0800__Amendment_5_Answer_To_Request_for_Clarification.pdf	PDF	Apr 17, 2019
N4523A19R0800_0005.pdf	PDF	Apr 17, 2019
Attachment_J-3_Request_for_Clarification_Updated.pdf	PDF	Apr 11, 2019
N4523A19R0800_0004.pdf	PDF	Apr 11, 2019
N4523A19R0800__Amendment_4_Summary.pdf	PDF	Apr 11, 2019
N4523A19R0800__Amendment_3_Answer_To_Request_for_Clarification.pdf	PDF	Apr 8, 2019
N4523A19R0800__Amendment_3_Summary.pdf	PDF	Apr 8, 2019
Attachment_J-4_Pricing_Worksheet_Revised_02_Apr_19.xlsx	XLSX spreadsheet	Apr 8, 2019
N4523A19R0800_0003.pdf	PDF	Apr 8, 2019
N4523A19R0800_0002.pdf	PDF	Apr 5, 2019
N4523A19R0800__Amendment_2_Summary.pdf	PDF	Apr 5, 2019
N4523A19R0800__Amendment_2_Answer_To_Request_for_Clarification.pdf	PDF	Apr 5, 2019
N4523A19R0800__Amendment_1_Summary.pdf	PDF	Mar 28, 2019
N4523A19R0800_0001_Solicitation_Amendment.pdf	PDF	Mar 28, 2019
Attachment_J-5_Previous_Efforts_Form.pdf	PDF	Mar 25, 2019
Attachment_J-1_SSBN_FY19_ERO_-_Contract_Package.pdf	PDF	Mar 25, 2019
Attachment_J-2_Badging_and_Security_Requirements.pdf	PDF	Mar 25, 2019
Attachment_J-3_Request_for_Clarification.pdf	PDF	Mar 25, 2019
Solicitation__N4523A19R0800.pdf	PDF	Mar 25, 2019
Exhibit_J-1_CDRLs.pdf	PDF	Mar 25, 2019
Exhibit_J-2_DIDs.pdf	PDF	Mar 25, 2019

Show all 32

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.

Summary Sheet

USS LOUISIANA FY19 ERO - Summary Sheet
Work Item #	Title	Direct Man Hours	Direct Labor Total Price	CFM/Equipment & Material Total Price	Sub Contractor Direct Man Hours	Sub Contractor Direct Labor Total Price	SUB Contractor Equipment & Material Total Price	Other Direct Costs	G&A	Profit	Work Item Total
042-10-001	Work Place Requirements								$ - 0	$ - 0	$ - 0
077-11-001	Hazardous Waste Produced on Naval Vessels; control								$ - 0	$ - 0	$ - 0
111-11-001	Superstructure Group 1; repair								$ - 0	$ - 0	$ - 0
111-11-002	Superstructure Group 2; repair								$ - 0	$ - 0	$ - 0
111-11-003	Superstructure Group 3; repair								$ - 0	$ - 0	$ - 0
111-11-004	Superstructure Group 4; repair								$ - 0	$ - 0	$ - 0
111-11-005	Superstructure Group 5; repair								$ - 0	$ - 0	$ - 0
111-11-007	Superstructure Group 6; repair								$ - 0	$ - 0	$ - 0
111-11-008	Hinged Cleat Recess Port; repair								$ - 0	$ - 0	$ - 0
111-11-009	Hinged Cleat Recess Starboard; repair								$ - 0	$ - 0	$ - 0
111-11-010	Non-Pressure Hull Group 7; repair								$ - 0	$ - 0	$ - 0
111-11-011	Sail; repair								$ - 0	$ - 0	$ - 0
111-11-012	WQC-6 Matching Network Mounting Plate; Install								$ - 0	$ - 0	$ - 0
111-11-013	Combat Systems Sail; repair								$ - 0	$ - 0	$ - 0
111-11-014	Hatches and covers; install								$ - 0	$ - 0	$ - 0
112-11-001	Active Emissions Recess ; repair								$ - 0	$ - 0	$ - 0
112-11-002	Bow Dome; repair								$ - 0	$ - 0	$ - 0
112-11-003	Depth Sounder Recess; repair								$ - 0	$ - 0	$ - 0
112-11-004	Magnetic Silencing System (MSS) Recess Port Upper; repair								$ - 0	$ - 0	$ - 0
112-11-005	Magnetic Silencing System (MSS) Recess Starboard Upper; repair								$ - 0	$ - 0	$ - 0
112-11-006	Magnetic Silencing System (MSS) Recess Port Lower; repair								$ - 0	$ - 0	$ - 0
112-11-007	Magnetic Silencing System (MSS) Recess Starboard Lower; repair								$ - 0	$ - 0	$ - 0
112-11-008	Magnetic Silencing System (MSS) Recess Top Centerline; repair								$ - 0	$ - 0	$ - 0
112-11-009	Group C Recess Port; repair								$ - 0	$ - 0	$ - 0
112-11-010	Noise Vibration Monitoring System(NVMS)No.4 Recess; repair								$ - 0	$ - 0	$ - 0
112-11-011	Velocity Position Reference System(VPRS) Recess Bottom STBD; repair								$ - 0	$ - 0	$ - 0
112-11-012	Sonar Cable Trunk; repair								$ - 0	$ - 0	$ - 0
112-11-013	Sonar Penetration Splice Trunk; repair								$ - 0	$ - 0	$ - 0
123-16-001	Main Ballast Tank (MBT) 1A; repair								$ - 0	$ - 0	$ - 0
123-16-002	Main Ballast Tank (MBT) 1B; repair								$ - 0	$ - 0	$ - 0
123-16-003	Main Ballast Tank (MBT) 2A; repair								$ - 0	$ - 0	$ - 0
123-16-004	Main Ballast Tank (MBT) 2B; repair								$ - 0	$ - 0	$ - 0
151-11-001	Group 1 Safety Track; repair								$ - 0	$ - 0	$ - 0
151-11-002	Group 2 Safety Track; repair								$ - 0	$ - 0	$ - 0
151-11-003	Group 3 Safety Track; repair								$ - 0	$ - 0	$ - 0
151-11-004	Group 4 Safety Track; repair								$ - 0	$ - 0	$ - 0
151-11-005	Group 5 Safety Track; repair								$ - 0	$ - 0	$ - 0
151-11-006	Group 6 Safety Track; repair								$ - 0	$ - 0	$ - 0
151-11-007	Bow Dome Foundation Platform; install								$ - 0	$ - 0	$ - 0
191-11-001	Main Ballast Tank 1A Sealed Lead Bins; convert (Non SUBSAFE Structural Repair)								$ - 0	$ - 0	$ - 0
191-11-002	Main Ballast Tank 1B Sealed Lead Bins; convert (Non SUBSAFE Structural Repair)								$ - 0	$ - 0	$ - 0
191-11-003	Main Ballast Tank 2A Sealed Lead Bins; convert (Non SUBSAFE Structural Repair)								$ - 0	$ - 0	$ - 0
191-11-004	Main Ballast Tank 2B Sealed Lead Bins; convert (Non SUBSAFE Structural Repair)								$ - 0	$ - 0	$ - 0
191-11-005	Main Ballast Tank 2A Free Flood Lead Bins; repair (Non SUBSAFE Structural Repair)								$ - 0	$ - 0	$ - 0
191-11-006	Main Ballast Tank 1A Free Flood Lead Bins; repair [Option] (Non SUBSAFE Structural Repair)								$ - 0	$ - 0	$ - 0
191-11-007	Main Ballast Tank 1B Free Flood Lead Bins; repair [Option] (Non SUBSAFE Structural Repair)								$ - 0	$ - 0	$ - 0
191-11-001	Main Ballast Tank 1A Sealed Lead Bins; convert (Lead Work)								$ - 0	$ - 0	$ - 0
191-11-002	Main Ballast Tank 1B Sealed Lead Bins; convert (Lead Work)								$ - 0	$ - 0	$ - 0
191-11-003	Main Ballast Tank 2A Sealed Lead Bins; convert (Lead Work)								$ - 0	$ - 0	$ - 0
191-11-004	Main Ballast Tank 2B Sealed Lead Bins; convert (Lead Work)								$ - 0	$ - 0	$ - 0
191-11-005	Main Ballast Tank 2A Free Flood Lead Bins; repair (Lead Work)								$ - 0	$ - 0	$ - 0
191-11-006	Main Ballast Tank 1A Free Flood Lead Bins; repair [Option] (Lead Work)								$ - 0	$ - 0	$ - 0
191-11-007	Main Ballast Tank 1B Free Flood Lead Bins; repair [Option] (Lead Work)								$ - 0	$ - 0	$ - 0
406-00-001	Sail EMI Ground Strap; Install								$ - 0	$ - 0	$ - 0
631-20-001	Forward Shore Power Trunk and Hatch; preserve								$ - 0	$ - 0	$ - 0
631-51-001	Main Ballast Tank (MBT) 1A; commercial blast								$ - 0	$ - 0	$ - 0
631-51-002	Main Ballast Tank (MBT) 1B; commercial blast								$ - 0	$ - 0	$ - 0
631-51-003	Main Ballast Tank (MBT) 2A; commercial blast								$ - 0	$ - 0	$ - 0
631-51-004	Main Ballast Tank (MBT) 2B; commercial blast								$ - 0	$ - 0	$ - 0
631-51-005	Superstructure Group 6; commercial blast								$ - 0	$ - 0	$ - 0
631-51-006	Superstructure Group 5 and Sail; commercial blast								$ - 0	$ - 0	$ - 0
631-51-007	Superstructure Group 1; commercial blast								$ - 0	$ - 0	$ - 0
631-51-008	Superstructure Group 2; commercial blast								$ - 0	$ - 0	$ - 0
631-51-009	Superstructure Group 3; commercial blast								$ - 0	$ - 0	$ - 0
631-51-010	Superstructure Group 4; commercial blast								$ - 0	$ - 0	$ - 0
631-51-011	Magnetic Silencing System (MSS) Recess, Lower Port; commercial blast								$ - 0	$ - 0	$ - 0
631-51-012	Magnetic Silencing System (MSS) Recess, Lower Starboard; commercial blast								$ - 0	$ - 0	$ - 0
631-51-013	Magnetic Silencing System (MSS) Recess Topside; commercial blast								$ - 0	$ - 0	$ - 0
631-51-014	Magnetic Silencing System (MSS) Recess Upper Port; commercial blast								$ - 0	$ - 0	$ - 0
631-51-015	Magnetic Silencing System (MSS) Recess Upper Starboard; commercial blast								$ - 0	$ - 0	$ - 0
631-51-016	Noise Vibration Monitoring System(NVMS) Recess Topside; commercial blast								$ - 0	$ - 0	$ - 0
631-51-017	Sonar Cable and Splice Trunks; commercial blast								$ - 0	$ - 0	$ - 0
631-51-018	Sonar Dome Free Flood; commercial blast								$ - 0	$ - 0	$ - 0
631-51-019	Velocity Position Reference System(VPRS) Recess; commercial blast								$ - 0	$ - 0	$ - 0
631-51-020	Active Emissions Recess; commercial blast								$ - 0	$ - 0	$ - 0
631-51-021	Depth Sounder Recess; commercial blast								$ - 0	$ - 0	$ - 0
631-51-022	Group C Recess; commercial blast								$ - 0	$ - 0	$ - 0
631-51-023	Main Ballast Tank (MBT)1A; preserve								$ - 0	$ - 0	$ - 0
631-51-024	Main Ballast Tank (MBT) 1B; preserve								$ - 0	$ - 0	$ - 0
631-51-025	Main Ballast Tank (MBT) 2A; preserve								$ - 0	$ - 0	$ - 0
631-51-026	Main Ballast Tank (MBT) 2B; preserve								$ - 0	$ - 0	$ - 0
631-51-027	Superstructure Group 6; preserve								$ - 0	$ - 0	$ - 0
631-51-028	Superstructure Group 5 and Sail; preserve								$ - 0	$ - 0	$ - 0
631-51-029	Superstructure Group 1; preserve								$ - 0	$ - 0	$ - 0
631-51-030	Superstructure Group 2; preserve								$ - 0	$ - 0	$ - 0
631-51-031	Superstructure Group 3; preserve								$ - 0	$ - 0	$ - 0
631-51-032	Superstructure Group 4; preserve								$ - 0	$ - 0	$ - 0
631-51-033	Non-Pressure Hull (NPH) Group 7, Top; preserve								$ - 0	$ - 0	$ - 0
631-51-034	Non-Pressure Hull (NPH) Group 110, Bottom; preserve								$ - 0	$ - 0	$ - 0
631-51-035	Non-Pressure Hull (NPH) Group 110, Port; preserve								$ - 0	$ - 0	$ - 0
631-51-036	Non-Pressure Hull (NPH) Group 110, Starboard; preserve								$ - 0	$ - 0	$ - 0
631-51-037	Pressure Hull (PH) Group 120 Bottom; preserve								$ - 0	$ - 0	$ - 0
631-51-038	Pressure Hull (PH) Group 120, Port; preserve								$ - 0	$ - 0	$ - 0
631-51-039	Pressure Hull (PH) Group 120, Starboard; preserve								$ - 0	$ - 0	$ - 0
631-51-040	Pressure Hull (PH) Group 140-1, Bottom; preserve								$ - 0	$ - 0	$ - 0
631-51-041	Pressure Hull (PH) Group 140-1, Port; preserve								$ - 0	$ - 0	$ - 0
631-51-042	Pressure Hull (PH) Group 140-1, Starboard; preserve								$ - 0	$ - 0	$ - 0
631-51-043	Pressure Hull (PH) Group 140-2 Bottom; preserve								$ - 0	$ - 0	$ - 0
631-51-044	Pressure Hull (PH) Group 140-2, Port; preserve								$ - 0	$ - 0	$ - 0
631-51-045	Pressure Hull (PH) Group 140-2, Starboard; preserve								$ - 0	$ - 0	$ - 0
631-51-046	Pressure Hull (PH) Group 140-3, Bottom; preserve								$ - 0	$ - 0	$ - 0
631-51-047	Pressure Hull (PH) Group 140-3, Port; preserve								$ - 0	$ - 0	$ - 0
631-51-048	Pressure Hull (PH) Group 140-3, Starboard; preserve								$ - 0	$ - 0	$ - 0
631-51-049	Pressure Hull (PH) Group 140-4, Bottom; preserve								$ - 0	$ - 0	$ - 0
631-51-050	Pressure Hull (PH) Group 140-4, Port; preserve								$ - 0	$ - 0	$ - 0
631-51-051	Pressure Hull (PH) Group 140-4, Starboard; preserve								$ - 0	$ - 0	$ - 0
631-51-052	Magnetic Silencing System (MSS) Recess, Lower Port; preserve								$ - 0	$ - 0	$ - 0
631-51-053	Magnetic Silencing System (MSS) Recess, Lower Starboard; preserve								$ - 0	$ - 0	$ - 0
631-51-054	Magnetic Silencing System (MSS) Recess, Topside; preserve								$ - 0	$ - 0	$ - 0
631-51-055	Magnetic Silencing System (MSS) Recess, Upper Port; preserve								$ - 0	$ - 0	$ - 0
631-51-056	Magnetic Silencing System (MSS) Recess, Upper Starboard; preserve								$ - 0	$ - 0	$ - 0
631-51-057	Noise Vibration Monitoring System (NVMS) Recess Topside; preserve								$ - 0	$ - 0	$ - 0
631-51-058	Sonar Cable and Splice Trunks; preserve								$ - 0	$ - 0	$ - 0
631-51-059	Sonar Dome Free Flood; preserve								$ - 0	$ - 0	$ - 0
631-51-060	Volicity Position Reference System (VPRS) Recess; preserve								$ - 0	$ - 0	$ - 0
631-51-061	Active Emissions Recess; preserve								$ - 0	$ - 0	$ - 0
631-51-062	Depth Sounder Recess; preserve								$ - 0	$ - 0	$ - 0
631-51-063	Group C Recess; preserve								$ - 0	$ - 0	$ - 0
631-51-064	Main Ballast Tank (MBT) 1A, Canning after install; preserve								$ - 0	$ - 0	$ - 0
631-51-065	Main Ballast Tank (MBT) 1B, Canning after install; preserve								$ - 0	$ - 0	$ - 0
631-51-066	Main Ballast Tank (MBT) 2A, Canning after install; preserve								$ - 0	$ - 0	$ - 0
631-51-067	Main Ballast Tank (MBT) 2B, Canning after install; preserve								$ - 0	$ - 0	$ - 0
631-51-069	Main Ballast Tank (MBT) 1A [OPTION] Lead Bins; commercial blast								$ - 0	$ - 0	$ - 0
631-51-070	Main Ballast Tank (MBT) 1B [OPTION] Lead Bins; commercial blast								$ - 0	$ - 0	$ - 0
631-51-071	Main Ballast Tank (MBT) 2A [OPTION] Lead Bins; commercial blast								$ - 0	$ - 0	$ - 0
631-51-072	Main Ballast Tank (MBT) 1A, Lead Bins; preserve [OPTION]								$ - 0	$ - 0	$ - 0
631-51-073	Main Ballast Tank (MBT) 1B, Lead Bins; preserve [OPTION]								$ - 0	$ - 0	$ - 0
631-51-074	Main Ballast Tank (MBT) 2A, Lead Bins; preserve [OPTION]								$ - 0	$ - 0	$ - 0
631-51-075	Main Ballast Tank (MBT) 1A, Canning after install; preserve [OPTION]								$ - 0	$ - 0	$ - 0
631-51-076	Main Ballast Tank (MBT) 1B, Canning after install; preserve [OPTION]								$ - 0	$ - 0	$ - 0
631-51-077	Main Ballast Tank (MBT) Canning Plates; preserve [OPTION]								$ - 0	$ - 0	$ - 0
631-51-078	Non-Pressure Hull (NPH) Group 7, Top; commercial blast								$ - 0	$ - 0	$ - 0
992-10-001	Contractor Facilities; provide			$ - 0			$ - 0		$ - 0	$ - 0	$ - 0
				PROPOSAL TOTAL PRICE (EXCLUDING OPTIONS)							$ - 0
				PROPOSAL TOTAL PRICE (INCLUDING OPTIONS)							$ - 0
1. Only insert information in the highlighted cells: blue for prime, yellow for subcontractor, green for G&A and Profit rates (as appropriate).
2. WORK ITEM TOTAL COLUMNS are FORMULAS. DO NOT ENTER INFORMATION OR ALTER THIS FORMULA.
3. Proposal Total Price, gray shaded at bottom of sheet, is also a FORMULA - DO NOT ENTER INFORMATION or ALTER THIS FORMULA.
4. Work items are highlighted to indicated the related production work being performed: (Purple for Preservation; Red for Non-SUBSAFE Structural Repair; Orange for Lead Work)

CFM Equip & Mat'l

	USS LOUISIANA FY19 ERO - Contractor Furnished Equipment & Material
	Work Item # 992-10-001	Equipment/Material Required	Qty	Unit Price	CFM/Equipment & Material Total Price	Qty	Unit Price	SUB Contractor Equipment & Material Total Price
	3.1.1	Office Trailers able to fit in an area measuring no greater 12 feet X 25 feet stackable;			$ - 0			$ - 0
	3.1.2	Materials for a 45/90 Hazardous Waste/Material Storage Area
measuring 12 feet x 16 feet,and shipboard containments			$ - 0			$ - 0
	3.1.3	Materials for building all work site containments and
protection that meets the requirements 2.1			$ - 0			$ - 0
	3.1.4	Blast and Recovery Equipment; ARS Trailer or equivalent			$ - 0			$ - 0
	3.1.5	Grit			$ - 0			$ - 0
	3.1.6	Filtered and non filtered ventilation for lead work, hot work
and general ventilation			$ - 0			$ - 0
	3.1.7	Air Compressors			$ - 0			$ - 0
	3.1.8	Dehumidification Equipment			$ - 0			$ - 0
	3.1.9	Plural component paint pump and associated equipment			$ - 0			$ - 0
	3.1.10	Inline heater			$ - 0			$ - 0
	3.1.11	Explosion Proof Lighting			$ - 0			$ - 0
	3.1.12	Flammable Storage Locker			$ - 0			$ - 0
	3.1.13	Paint and Methyl Ethyl Ketone Thinner			$ - 0			$ - 0
	3.1.14	Steel blast 50/50 grit			$ - 0			$ - 0
	3.1.15	Paint Locker			$ - 0			$ - 0
	3.1.16	Breathing air manifolds and associated equipment			$ - 0			$ - 0
	3.1.17	Weld machines and welding support equipment			$ - 0			$ - 0
	3.1.18	Portable shower facilities for lead decontamination station			$ - 0			$ - 0
					$ - 0			$ - 0
					$ - 0			$ - 0
					$ - 0			$ - 0
					$ - 0			$ - 0
		PROPOSAL TOTAL PRICE			$ - 0			$ - 0
	1. Only insert information in the highlighted cells: blue for prime, yellow for subcontractor (as appropriate), ODC/G&A/Profit, Growth Rates.
	2. WORK ITEM TOTAL COLUMN is a FORMULA. DO NOT ENTER INFORMATION OR ALTER THIS FORMULA.
	3. Total Price, gray shaded at bottom of sheet, is also a FORMULA - DO NOT ENTER INFORMATION or ALTER THIS FORMULA.
	4. Enter data to TWO DECIMAL POINTS.

Contract Change Rate

Notice: Only enter data on this worksheet in the yellow highlighted cells below. The offeror may insert more rows for trade level breakdowns if necessary.
	Total Labor Proposed	Applicable Area Measurement		Production Contract ChangeRate
1) Preservation ($/per sq ft)	$ - 0		SQ FT	ERROR:#DIV/0!
2) Non-SUBSAFE Structural Repair ($/per sq in)	$ - 0	71,397	SQ IN	$ - 0
3) Lead work ($/per LBS)	$ - 0	265,764	LBS	$ - 0

NOTE 1:

The total labor accounted for within the Preservation Change Rate are for the work items beginning with 631 listed in Attachment J-1. [Work Items highlighted in Purple on the Summary Sheet] The total labor accounted for within the Non-SUBSAFE Structural Repair Change Rate are for work items as detailed in 3.2.1.1 of work item 042-10-001 listed in Attachment J-1. [Work Items highlighted in Red on the Summary Sheet] The total labor accounted for within the Lead Work Change Rate are for the work items beginning with 191 listed in Attachment J-1. [Work Items highlighted in Orange on the Summary Sheet]

NOTE 2: In the yellow highlighted cell, the offeror shall enter the total area of square footage used by the offeror as the basis of calculating the proposed labor costs associated with the preservation work items (all work items beginning with 631 [Highlighted in Purple on the Summary Sheet].

NOTE 3:

The total square inches for Non-SUBSAFE Structural Repairs is an established number detailed in 3.2.1.1 of work item 042-10-001 in Attachment J-1.

The total pounds for Lead Work is an established number detailed in the work items beginning with 191 listed in Attachment J-1.

NOTE 4: The production contract change rate (in $/sq ft; $/sq in; $/lb) is an all inclusive (consumables, G&A, profit) and consolidated rate that applies to the entire availiability period for all RCCs.

File details come from the government source that posted it.