Attachment_J4_Pricing_Volume_for_Solicitation.xlsx

XLSX spreadsheet 29 KB Posted

Attached to
USS Michigan FY19 ERP Federal contract opportunity
Solicitation number
N4523A19R0801
Issued by
Department of the Navy Naval Sea Systems Command

About this file

From the source

Attachment J-4: Pricing Volume Spreadsheet

View the file

Other files for this federal contract opportunity

Other files attached to USS Michigan FY19 ERP, newest first.
File Type Posted
N4523A19R0801__Amendment_7_Summary.pdf PDF
N4523A19R0801_Revised_Solicitation_11-30.pdf PDF
N4523A19R0801_Solicitation_Amendment_11-28.pdf PDF
N4523A19R0801__Amendment_6_Summary.pdf PDF
USS_MICHIGAN_FY19_ERP_-_ERRATA_2.pdf PDF
N4523A19R0801__Amendment_5.pdf PDF
N4523A19R0801__Amendment_4_Answer_To_Bidder's_Questions.pdf PDF
N4523A19R0801__Amendment_3.pdf PDF
N4523A19R0801_Solicitation_Amendment_11-17.pdf PDF
USS_MICHIGAN_FY19_ERP-_ERRATA_1.pdf PDF
DI-MISC-81940_Welding_Qualification_and_Training_Program.pdf PDF
A031_CDRL__Weld_Qualification_and_Training_Program-signed.pdf PDF
Revised_N4523A19R0801.pdf PDF
Attachment_J3_Request_for_Clarification_Revised_10-31.docx DOCX document
N4523A19R0801__Amendment_2_Answer_To_Bidder's_Questions.docx DOCX document
N4523A19R0801__Amendment_1_Answer_To_Bidder's_Questions.docx DOCX document
Attachment_J2_Badging.pdf PDF
Attachment_J3_Request_for_Clarification.pdf PDF
Combined_DIDs_Package.pdf PDF
Attachment_J6_Government_Property.pdf PDF
Attachment_J1_USS_Michigan_FY19_ERP-_Contract_Package.pdf PDF
Combined_CDRL_Package.pdf PDF
Attachment_J5_Previous_Efforts_Form.doc DOC document
N4523A19R0801.pdf PDF
Show all 24

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.

Summary Sheet

USS MICHIGAN FY19 ERP
Work Item #TitleSq FtDirect Man Hours*Direct Labor Total PriceCFM/Equipment & Material Total PriceSub Contractor Direct Man Hours**Sub Contractor Direct Labor Total PriceSUB Contractor Equipment & Material Total PriceODCPrime G&APrime ProfitWork Item Total
631-10-001Depth Control Tank 1 (DCT-1); commercial blast2,575$ - 0
631-10-002Depth Control Tank 2 (DCT-2); commercial blast2,568$ - 0
631-10-003Sanitary Tank 4 (SAN-4); commercial blast134$ - 0
631-10-004Sanitary Tank 5 (SAN-5); commercial blast209$ - 0
631-10-005Sanitary Tank 6 (SAN-6); commercial blast201$ - 0
631-10-006Auxiliary Tank 1 (AUX-1); commercial blast1,246$ - 0
631-10-007Auxiliary Tank 4 (AUX-4); commercial blast1,521$ - 0
631-11-001Main Ballast Tank (MBT) 1A; commercial blast5,089$ - 0
631-11-002Main Ballast Tank (MBT) 2A; commercial blast6,360$ - 0
631-11-003Main Ballast Tank (MBT) 3A; commercial blast11,065$ - 0
631-51-001Superstructure Group 1; commercial blast2,500$ - 0
631-51-002Superstructure Group 2; commercial blast2,500$ - 0
631-51-003Group 10 Superstructure; commercial blast5,391$ - 0
631-10-008Depth Control Tank 1 (DCT-1); preserve2,575$ - 0
631-10-009Depth Control Tank 2 (DCT-2); preserve2,568$ - 0
631-10-010Sanitary Tank 4 (SAN-4); preserve134$ - 0
631-10-011Sanitary Tank 5 (SAN-5); preserve209$ - 0
631-10-012Sanitary Tank 6 (SAN-6); preserve201$ - 0
631-10-013Auxiliary Tank 1 (AUX-1); preserve1,246$ - 0
631-10-014Auxiliary Tank 4 (AUX-4); preserve1,521$ - 0
631-11-004Main Ballast Tank (MBT) 1A; preserve5,089$ - 0
631-11-005Main Ballast Tank (MBT) 2A; preserve6,360$ - 0
631-11-006Main Ballast Tank (MBT) 3A; preserve11,065$ - 0
631-51-010Group 1 Superstructure; preserve2,500$ - 0
631-51-011Group 2 Superstructure; preserve2,500$ - 0
631-51-012Group 10 Superstructure; preserve5,391$ - 0
631-51-004Group 3 Superstructure; preserve Touch-up$ - 0
631-51-005Group 4 Superstructure; preserve Touch-up$ - 0
631-51-006Group 5 Superstructure; preserve Touch-up$ - 0
631-51-007Group 8 Superstructure; preserve Touch-up$ - 0
631-51-008Group 11 Superstructure; preserve Touch-up$ - 0
631-51-009Sail; preserve Touch-up$ - 0
631-51-013Group 6 Superstructure; preserve Touch-up$ - 0
631-51-014Group 9 Superstructure; preserve Touch-up$ - 0
111-11-001Superstructure Group 2, Frame 62 t0 71$ - 0
111-11-002Superstructure Group 10; repair$ - 0
123-11-001Main Ballast Tank (MBT) 1A; repair$ - 0
123-11-002Main Ballast Tank (MBT) 2A; repair$ - 0
123-11-003Main Ballast Tank (MBT) 3A; repair$ - 0
151-11-001Group 2 Safety Track; repair$ - 0
151-11-002Group 10 Safety Track; repair$ - 0
524-10-001Auxiliary Tank 1 (AUX-1); repair$ - 0
524-10-002Auxiliary Tank 4 (AUX-4); repair$ - 0
528-10-001Sanitary Tank 4 (SAN-4); repair$ - 0
528-10-002Sanitary Tank 5 (SAN-5); repair$ - 0
633-11-001Cathodic Protection; remove$ - 0
636-11-001Main Ballast tank 1A Damping Tile; remove$ - 0
636-11-002Main Ballast tank 2A Damping Tile; remove$ - 0
636-11-003Main Ballast tank 3A Damping Tile; remove$ - 0
636-51-001Group 2 Superstructure Damping Tile; remove$ - 0
636-51-002Group 10 Superstructure Damping Tile; remove$ - 0
991-11-001Temporary Staging; provide$ - 0
992-10-001Contractor Facilities$ - 0
042-01-001Workplace Requirements (Paragraph 3.3.1.1)4,148$ - 0
042-01-001Workplace Requirements (Paragraph 3.3.2.1)56,720 (sq In)$ - 0
042-01-001Workplace Requirements (Paragraph 3.3.3.1)4,400$ - 0
042-01-001Workplace Requirements (All Remaining Requirements)$ - 0
077-11-001Hazardous Waste Produced on Naval Vessels; control$ - 0
PROPOSAL 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.Rates for Growth Work
2. WORK ITEM TOTAL COLUMN is a FORMULA. DO NOT ENTER INFORMATION OR ALTER THIS FORMULA.Touch Up:(Priced per Square Foot)
3. Total Price, gray shaded at bottom of sheet, is also a FORMULA - DO NOT ENTER INFORMATION or ALTER THIS FORMULA.Blast/Paint:(Price per Square Foot)
4. Enter data to TWO DECIMAL POINTS.Weld Repair:(Priced per Square Inch)
Consumable Rate:(Price per Hour)
* Direct Man Hours (PRIME) should be same total on TAB Labor Hours Per Work Package
** Sub Contractor Direct Man Hours should be same total on TAB Labor Hours Per Work PackageNote: The offeror shall propose fully burdened production rates, as well as a fully burndened consumable rate that will be used for Request for Contract Changes (RCCs) during contract administration. The proposed fully burdened labor and consumable rates shall be inclusive of G&A and Profit.

Labor Rates PRIME Contractor Labor Category/Position Base Hourly Rate Fringe Overhead G&A Profit Other (Specify) Composite Fully Burdended Regular Hourly Rate OT Hourly Rate Sub Contractor Labor Category/Position (as appropriate) Base Hourly Rate Fringe Overhead G&A Profit Composite Fully Burdened Regular Hourly Rate OT Hourly Rate

1. Enter Labor Category/Position Description (ie, welder, painter, engineer, helper, supervisor, etc)
2. Enter Regular Hourly Rate, G&A, and Profit for each labor category/position.
3. Enter OT Hourly Rate for each labor category/position.
4. Complete the above items 1-3 for both Prime Contractor and Subcontractor (as appropriate).
5. Additional lines are available but do not reflect anticipated required positions.

Labor Hours Per Work Package

Work Item #Title*Hours per Prime Labor Category "X"*Hours per Prime Labor Category "X"*Hours per Prime Labor Category "X"*Hours per Prime Labor Category "X"*Hours per Prime Labor Category "X"*Hours per Prime Labor Category "X"*Hours per Prime Labor Category "X"*Hours per Prime Labor Category "X"*Hours per Prime Labor Category "X"*Hours per Prime Labor Category "X"Sub Contractor Labor Categories (COPIED from Labor Rates TAB)Sub Contractor Labor Categories (COPIED from Labor Rates TAB)Sub Contractor Labor Categories (COPIED from Labor Rates TAB)Sub Contractor Labor Categories (COPIED from Labor Rates TAB)Sub Contractor Labor Categories (COPIED from Labor Rates TAB)Sub Contractor Labor Categories (COPIED from Labor Rates TAB)Sub Contractor Labor Categories (COPIED from Labor Rates TAB)TOTAL LABOR
631-10-001Depth Control Tank 1 (DCT-1); commercial blast- 0
631-10-002Depth Control Tank 2 (DCT-2); commercial blast- 0
631-10-003Sanitary Tank 4 (SAN-4); commercial blast- 0
631-10-004Sanitary Tank 5 (SAN-5); commercial blast- 0
631-10-005Sanitary Tank 6 (SAN-6); commercial blast- 0
631-10-006Auxiliary Tank 1 (AUX-1); commercial blast- 0
631-10-007Auxiliary Tank 4 (AUX-4); commercial blast- 0
631-11-001Main Ballast Tank (MBT) 1A; commercial blast- 0
631-11-002Main Ballast Tank (MBT) 2A; commercial blast- 0
631-11-003Main Ballast Tank (MBT) 3A; commercial blast- 0
631-51-001Superstructure Group 1; commercial blast- 0
631-51-002Superstructure Group 2; commercial blast- 0
631-51-003Group 10 Superstructure; commercial blast- 0
631-10-008Depth Control Tank 1 (DCT-1); preserve- 0
631-10-009Depth Control Tank 2 (DCT-2); preserve- 0
631-10-010Sanitary Tank 4 (SAN-4); preserve- 0
631-10-011Sanitary Tank 5 (SAN-5); preserve- 0
631-10-012Sanitary Tank 6 (SAN-6); preserve- 0
631-10-013Auxiliary Tank 1 (AUX-1); preserve- 0
631-10-014Auxiliary Tank 4 (AUX-4); preserve- 0
631-11-004Main Ballast Tank (MBT) 1A; preserve- 0
631-11-005Main Ballast Tank (MBT) 2A; preserve- 0
631-11-006Main Ballast Tank (MBT) 3A; preserve- 0
631-51-010Group 1 Superstructure; preserve- 0
631-51-011631-51-011 Group 2 Superstructure; preserve- 0
631-51-012Group 10 Superstructure; preserve- 0
631-51-004Group 3 Superstructure; preserve Touch-up- 0
631-51-005Group 4 Superstructure; preserve Touch-up- 0
631-51-006Group 5 Superstructure; preserve Touch-up- 0
631-51-007Group 8 Superstructure; preserve Touch-up- 0
631-51-008Group 11 Superstructure; preserve Touch-up- 0
631-51-009Sail; preserve Touch-up- 0
631-51-013Group 6 Superstructure; preserve Touch-up- 0
631-51-014Group 9 Superstructure; preserve Touch-up- 0
111-11-001Superstructure Group 2, Frame 62 t0 71- 0
111-11-002Superstructure Group 10; repair- 0
123-11-001Main Ballast Tank (MBT) 1A; repair- 0
123-11-002Main Ballast Tank (MBT) 2A; repair- 0
123-11-003Main Ballast Tank (MBT) 3A; repair- 0
151-11-001Group 2 Safety Track; repair- 0
151-11-002Group 10 Safety Track; repair- 0
524-10-001Auxiliary Tank 1 (AUX-1); repair- 0
524-10-002Auxiliary Tank 4 (AUX-4); repair- 0
528-10-001Sanitary Tank 4 (SAN-4); repair- 0
528-10-002Sanitary Tank 5 (SAN-5); repair- 0
633-11-001Cathodic Protection; remove- 0
636-11-001Main Ballast tank 1A Damping Tile; remove- 0
636-11-002Main Ballast tank 2A Damping Tile; remove- 0
636-11-003Main Ballast tank 3A Damping Tile; remove- 0
636-51-001Group 2 Superstructure Damping Tile; remove- 0
636-51-002Group 10 Superstructure Damping Tile; remove- 0
991-11-001Temporary Staging; provide- 0
992-10-001Contractor Facilities- 0
042-01-001Workplace Requirements (Paragraph 3.3.1.1)- 0
042-01-001Workplace Requirements (Paragraph 3.3.2.1)
042-01-001Workplace Requirements (Paragraph 3.3.3.1)
042-01-001Workplace Requirements (All Remaining Requirements)
077-11-001Hazardous Waste Produced on Naval Vessels; control- 0
* COPY the Prime Labor Categories from the Labor Rates TAB and insert/past per work item.
** Copy the Sub Contractor Labor Categories (as appropriate) from the Labor Rates TAB and insert/past per work item

File details come from the government source that posted it.