Attachment_J-4_Pricing_Worksheet_Revised_16_Apr_19.xlsx

XLSX spreadsheet 44 KB Posted

Attached to
USS SSBN Submarine Engineered Refueling Overhaul (ERO) Preservation and non-SUBSAFE Structural Repairs
Solicitation number
N4523A19R0800
Issued by

About this file

From the source

Revised Attachment J-4 Pricing Worksheet

View the file

Other files

File Type Posted
N4523A19R0800_0005.pdf PDF
N4523A19R0800__Amendment_5_Summary_17_Apr_19.pdf PDF
N4523A19R0800__Amendment_5_Answer_To_Request_for_Clarification.pdf PDF

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.

Total Price

QTYUNITSUNIT PriceTotal Price
CLIN 00011JOB$0$0
CLIN 00021JOBNSP$0
CLIN 0003 (Option)1JOB$0$0
CLIN 0004 (Option)1JOB$0$0
CLIN 0005 (Option)1JOB$0$0
Contract Change Rates1EA$0$0
Total Price$0

THE TOTAL PRICE CALCULATED IS CONSIDERED THE TOTAL PRICE FOR THE CONTRACT FOR EVALUATION PURPOSES

Summary Sheet

USS LOUISIANA FY19 ERO - Summary Sheet0.00%0.00%
Work Item #TitleLabor HoursLabor RateDirect Labor Total PriceCFM/Equipment & Material Total PriceOther Direct CostsSub Contractor Direct Man HoursSub Contractor Direct Labor Total PriceSUB Contractor Equipment & Material Total PriceSUBTOTALG&AProfitWork Item Total
CLIN 0001 WORK
042-10-001Work Place Requirements$ - 0$ - 0$ - 0$ - 0$ - 0
077-11-001Hazardous Waste Produced on Naval Vessels; control$ - 0$ - 0$ - 0$ - 0$ - 0
111-11-001Superstructure Group 1; repair$ - 0$ - 0$ - 0$ - 0$ - 0
111-11-002Superstructure Group 2; repair$ - 0$ - 0$ - 0$ - 0$ - 0
111-11-003Superstructure Group 3; repair$ - 0$ - 0$ - 0$ - 0$ - 0
111-11-004Superstructure Group 4; repair$ - 0$ - 0$ - 0$ - 0$ - 0
111-11-005Superstructure Group 5; repair$ - 0$ - 0$ - 0$ - 0$ - 0
111-11-007Superstructure Group 6; repair$ - 0$ - 0$ - 0$ - 0$ - 0
111-11-008Hinged Cleat Recess Port; repair$ - 0$ - 0$ - 0$ - 0$ - 0
111-11-009Hinged Cleat Recess Starboard; repair$ - 0$ - 0$ - 0$ - 0$ - 0
111-11-010Non-Pressure Hull Group 7; repair$ - 0$ - 0$ - 0$ - 0$ - 0
111-11-011Sail; repair$ - 0$ - 0$ - 0$ - 0$ - 0
111-11-012WQC-6 Matching Network Mounting Plate; Install$ - 0$ - 0$ - 0$ - 0$ - 0
111-11-013Combat Systems Sail; repair$ - 0$ - 0$ - 0$ - 0$ - 0
111-11-014Hatches and covers; install$ - 0$ - 0$ - 0$ - 0$ - 0
112-11-001Active Emissions Recess ; repair$ - 0$ - 0$ - 0$ - 0$ - 0
112-11-002Bow Dome; repair$ - 0$ - 0$ - 0$ - 0$ - 0
112-11-003Depth Sounder Recess; repair$ - 0$ - 0$ - 0$ - 0$ - 0
112-11-004Magnetic Silencing System (MSS) Recess Port Upper; repair$ - 0$ - 0$ - 0$ - 0$ - 0
112-11-005Magnetic Silencing System (MSS) Recess Starboard Upper; repair$ - 0$ - 0$ - 0$ - 0$ - 0
112-11-006Magnetic Silencing System (MSS) Recess Port Lower; repair$ - 0$ - 0$ - 0$ - 0$ - 0
112-11-007Magnetic Silencing System (MSS) Recess Starboard Lower; repair$ - 0$ - 0$ - 0$ - 0$ - 0
112-11-008Magnetic Silencing System (MSS) Recess Top Centerline; repair$ - 0$ - 0$ - 0$ - 0$ - 0
112-11-009Group C Recess Port; repair$ - 0$ - 0$ - 0$ - 0$ - 0
112-11-010Noise Vibration Monitoring System(NVMS)No.4 Recess; repair$ - 0$ - 0$ - 0$ - 0$ - 0
112-11-011Velocity Position Reference System(VPRS) Recess Bottom STBD; repair$ - 0$ - 0$ - 0$ - 0$ - 0
112-11-012Sonar Cable Trunk; repair$ - 0$ - 0$ - 0$ - 0$ - 0
112-11-013Sonar Penetration Splice Trunk; repair$ - 0$ - 0$ - 0$ - 0$ - 0
123-16-001Main Ballast Tank (MBT) 1A; repair$ - 0$ - 0$ - 0$ - 0$ - 0
123-16-002Main Ballast Tank (MBT) 1B; repair$ - 0$ - 0$ - 0$ - 0$ - 0
123-16-003Main Ballast Tank (MBT) 2A; repair$ - 0$ - 0$ - 0$ - 0$ - 0
123-16-004Main Ballast Tank (MBT) 2B; repair$ - 0$ - 0$ - 0$ - 0$ - 0
151-11-001Group 1 Safety Track; repair$ - 0$ - 0$ - 0$ - 0$ - 0
151-11-002Group 2 Safety Track; repair$ - 0$ - 0$ - 0$ - 0$ - 0
151-11-003Group 3 Safety Track; repair$ - 0$ - 0$ - 0$ - 0$ - 0
151-11-004Group 4 Safety Track; repair$ - 0$ - 0$ - 0$ - 0$ - 0
151-11-005Group 5 Safety Track; repair$ - 0$ - 0$ - 0$ - 0$ - 0
151-11-006Group 6 Safety Track; repair$ - 0$ - 0$ - 0$ - 0$ - 0
151-11-007Bow Dome Foundation Platform; install$ - 0$ - 0$ - 0$ - 0$ - 0
191-11-001Main Ballast Tank 1A Sealed Lead Bins; convert (Non SUBSAFE Structural Repair)$ - 0$ - 0$ - 0$ - 0$ - 0
191-11-002Main Ballast Tank 1B Sealed Lead Bins; convert (Non SUBSAFE Structural Repair)$ - 0$ - 0$ - 0$ - 0$ - 0
191-11-003Main Ballast Tank 2A Sealed Lead Bins; convert (Non SUBSAFE Structural Repair)$ - 0$ - 0$ - 0$ - 0$ - 0
191-11-004Main Ballast Tank 2B Sealed Lead Bins; convert (Non SUBSAFE Structural Repair)$ - 0$ - 0$ - 0$ - 0$ - 0
191-11-005Main Ballast Tank 2A Free Flood Lead Bins; repair (Non SUBSAFE Structural Repair)$ - 0$ - 0$ - 0$ - 0$ - 0
191-11-006Main Ballast Tank 1A Free Flood Lead Bins; repair [Option] (Non SUBSAFE Structural Repair)$ - 0$ - 0$ - 0$ - 0$ - 0
191-11-007Main Ballast Tank 1B Free Flood Lead Bins; repair [Option] (Non SUBSAFE Structural Repair)$ - 0$ - 0$ - 0$ - 0$ - 0
191-11-001Main Ballast Tank 1A Sealed Lead Bins; convert (Lead Work)$ - 0$ - 0$ - 0$ - 0$ - 0
191-11-002Main Ballast Tank 1B Sealed Lead Bins; convert (Lead Work)$ - 0$ - 0$ - 0$ - 0$ - 0
191-11-003Main Ballast Tank 2A Sealed Lead Bins; convert (Lead Work)$ - 0$ - 0$ - 0$ - 0$ - 0
191-11-004Main Ballast Tank 2B Sealed Lead Bins; convert (Lead Work)$ - 0$ - 0$ - 0$ - 0$ - 0
191-11-005Main Ballast Tank 2A Free Flood Lead Bins; repair (Lead Work)$ - 0$ - 0$ - 0$ - 0$ - 0
406-00-001Sail EMI Ground Strap; Install$ - 0$ - 0$ - 0$ - 0$ - 0
631-20-001Forward Shore Power Trunk and Hatch; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-001Main Ballast Tank (MBT) 1A; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-002Main Ballast Tank (MBT) 1B; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-003Main Ballast Tank (MBT) 2A; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-004Main Ballast Tank (MBT) 2B; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-005Superstructure Group 6; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-006Superstructure Group 5 and Sail; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-007Superstructure Group 1; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-008Superstructure Group 2; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-009Superstructure Group 3; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-010Superstructure Group 4; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-011Magnetic Silencing System (MSS) Recess, Lower Port; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-012Magnetic Silencing System (MSS) Recess, Lower Starboard; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-013Magnetic Silencing System (MSS) Recess Topside; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-014Magnetic Silencing System (MSS) Recess Upper Port; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-015Magnetic Silencing System (MSS) Recess Upper Starboard; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-016Noise Vibration Monitoring System(NVMS) Recess Topside; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-017Sonar Cable and Splice Trunks; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-018Sonar Dome Free Flood; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-019Velocity Position Reference System(VPRS) Recess; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-020Active Emissions Recess; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-021Depth Sounder Recess; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-022Group C Recess; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-023Main Ballast Tank (MBT)1A; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-024Main Ballast Tank (MBT) 1B; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-025Main Ballast Tank (MBT) 2A; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-026Main Ballast Tank (MBT) 2B; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-027Superstructure Group 6; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-028Superstructure Group 5 and Sail; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-029Superstructure Group 1; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-030Superstructure Group 2; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-031Superstructure Group 3; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-032Superstructure Group 4; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-033Non-Pressure Hull (NPH) Group 7, Top; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-034Non-Pressure Hull (NPH) Group 110, Bottom; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-035Non-Pressure Hull (NPH) Group 110, Port; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-036Non-Pressure Hull (NPH) Group 110, Starboard; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-037Pressure Hull (PH) Group 120 Bottom; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-038Pressure Hull (PH) Group 120, Port; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-039Pressure Hull (PH) Group 120, Starboard; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-040Pressure Hull (PH) Group 140-1, Bottom; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-041Pressure Hull (PH) Group 140-1, Port; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-042Pressure Hull (PH) Group 140-1, Starboard; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-043Pressure Hull (PH) Group 140-2 Bottom; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-044Pressure Hull (PH) Group 140-2, Port; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-045Pressure Hull (PH) Group 140-2, Starboard; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-046Pressure Hull (PH) Group 140-3, Bottom; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-047Pressure Hull (PH) Group 140-3, Port; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-048Pressure Hull (PH) Group 140-3, Starboard; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-049Pressure Hull (PH) Group 140-4, Bottom; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-050Pressure Hull (PH) Group 140-4, Port; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-051Pressure Hull (PH) Group 140-4, Starboard; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-052Magnetic Silencing System (MSS) Recess, Lower Port; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-053Magnetic Silencing System (MSS) Recess, Lower Starboard; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-054Magnetic Silencing System (MSS) Recess, Topside; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-055Magnetic Silencing System (MSS) Recess, Upper Port; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-056Magnetic Silencing System (MSS) Recess, Upper Starboard; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-057Noise Vibration Monitoring System (NVMS) Recess Topside; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-058Sonar Cable and Splice Trunks; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-059Sonar Dome Free Flood; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-060Volicity Position Reference System (VPRS) Recess; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-061Active Emissions Recess; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-062Depth Sounder Recess; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-063Group C Recess; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-064Main Ballast Tank (MBT) 1A, Canning after install; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-065Main Ballast Tank (MBT) 1B, Canning after install; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-066Main Ballast Tank (MBT) 2A, Canning after install; preserve$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-078Non-Pressure Hull (NPH) Group 7, Top; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-067Main Ballast Tank (MBT) 2B, Canning after install; preserve$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
992-10-001Contractor Facilities; ROLLED IN FROM CFM EQUP & MAT'L SHEET$ - 0$ - 0$ - 0$ - 0
CLIN 0001 SUBTOTAL$ - 0
CLIN 0003 (OPTION) - Main Ballast Tank 1-A
191-11-006Main Ballast Tank 1A Free Flood Lead Bins; repair [Option] (Lead Work)$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-069Main Ballast Tank (MBT) 1A [OPTION] Lead Bins; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-072Main Ballast Tank (MBT) 1A, Lead Bins; preserve [OPTION]$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-075Main Ballast Tank (MBT) 1A, Canning after install; preserve [OPTION]$ - 0$ - 0$ - 0$ - 0$ - 0
CLIN 0003 SUBTOTAL$ - 0
CLIN 0004 (OPTION) - Main Ballast Tank 1B
191-11-007Main Ballast Tank 1B Free Flood Lead Bins; repair [Option] (Lead Work)$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-070Main Ballast Tank (MBT) 1B [OPTION] Lead Bins; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-073Main Ballast Tank (MBT) 1B, Lead Bins; preserve [OPTION]$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-076Main Ballast Tank (MBT) 1B, Canning after install; preserve [OPTION]$ - 0$ - 0$ - 0$ - 0$ - 0
CLIN 0004 SUBTOTAL$ - 0
CLIN 0005 (OPTION) - Main Ballast Tank 2A
631-51-071Main Ballast Tank (MBT) 2A [OPTION] Lead Bins; commercial blast$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-074Main Ballast Tank (MBT) 2A, Lead Bins; preserve [OPTION]$ - 0$ - 0$ - 0$ - 0$ - 0
631-51-077Main Ballast Tank (MBT) Canning Plates; preserve [OPTION]$ - 0$ - 0$ - 0$ - 0$ - 0
CLIN 0005 SUBTOTAL$ - 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. 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)
4. ODC-Defined as anything not directly attributable to a final cost or production objective (i.e., labor, subcontracts, and/or material). Examples include rental charges and travel etc.

CFM Equip & Mat'l

USS LOUISIANA FY19 ERO - Contractor Furnished Equipment & Material
Work Item # 992-10-001Equipment/Material RequiredQtyUnit PriceCFM/Equipment & Material Total PriceQtyUnit PriceSUB Contractor Equipment & Material Total PriceTOTAL
3.1.1Office Trailers able to fit in an area measuring no greater 12 feet X 25 feet stackable;$ - 0$ - 0$ - 0
3.1.2Materials for a 45/90 Hazardous Waste/Material Storage Area
measuring 12 feet x 16 feet,and shipboard containments$ - 0$ - 0$ - 0
3.1.3Materials for building all work site containments and
protection that meets the requirements 2.1$ - 0$ - 0$ - 0
3.1.4Blast and Recovery Equipment; ARS Trailer or equivalent$ - 0$ - 0$ - 0
3.1.5Grit$ - 0$ - 0$ - 0
3.1.6Filtered and non filtered ventilation for lead work, hot work
and general ventilation$ - 0$ - 0$ - 0
3.1.7Air Compressors$ - 0$ - 0$ - 0
3.1.8Dehumidification Equipment$ - 0$ - 0$ - 0
3.1.9Plural component paint pump and associated equipment$ - 0$ - 0$ - 0
3.1.10Inline heater$ - 0$ - 0$ - 0
3.1.11Explosion Proof Lighting$ - 0$ - 0$ - 0
3.1.12Flammable Storage Locker$ - 0$ - 0$ - 0
3.1.13Paint and Methyl Ethyl Ketone Thinner$ - 0$ - 0$ - 0
3.1.14Steel blast 50/50 grit$ - 0$ - 0$ - 0
3.1.15Paint Locker$ - 0$ - 0$ - 0
3.1.16Breathing air manifolds and associated equipment$ - 0$ - 0$ - 0
3.1.17Weld machines and welding support equipment$ - 0$ - 0$ - 0
3.1.18Portable shower facilities for lead decontamination station$ - 0$ - 0$ - 0
$ - 0
CONTRACTOR FURNISHED EQUPMENT & MATERIAL TOTAL PRICE$ - 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 NOTE: THE QUANTITY COLUMN IS FOR PRICE ANALYSIS PURPOSES ONLY. IN EXECUTION THE GOVERNMENT RESERVES THE RIGHT TO ADJUST THE QUANTITY BASED ON ACTUAL CHANGES/REQUIREMENTS. THE GOVERNMENT INTENDS TO USE THE UNIT PRICE RATE FOR MODIFICATIONS.

QTYUNITUNIT PriceTOTAL PRICE
1) Preservation ($/per sq ft)93,218SQ FT$0
2) Non-SUBSAFE Structural Repair ($/per sq in)71,397SQ IN$0
3) Lead work ($/per LBS)265,764LBS$0
TOTAL$0

PROFIT AND G&A WILL BE CALCULATED ON EACH MODIFICATION. PROFIT AND G&A SHOULD NOT BE INCLUDED IN YOUR RATES FOR THIS PAGE.

NOTE 1: With respect to Column E, "Unit Price" the following applies:

1) When calculating "Unit Price" for the Preservation Change Rate, utilize the work items beginning with 631 listed in Attachment J-1 as the basis. [Work Items highlighted in Purple on the Summary Sheet]

2) When calculating "Unit Price" for the Non-SUBSAFE Structural Repair Change Rate, utilize the work items as detailed in 3.2.1.1 of work item 042-10-001 listed in Attachment J-1 as the basis. [Work Items highlighted in Red on the Summary Sheet]

3) When calculating the "Unit Price" for the Lead Work Change Rate, utilize the work items beginning with 191 listed in Attachment J-1 as the basis. [Work Items highlighted in Orange on the Summary Sheet]

NOTE 2: DO NOT ADJUST THE NUMBERS IN THE QTY COLUMN. These are provided as an arithmetic "constant" for price analysis purposes. Only fill in the unit prices highlighted in yellow. These should be represented as fully burdened rates with the exception of profit, which will be calculated on each modification.

File details come from the government source that posted it.