J-4_Pricing_Workbook_(Ramage)_3.7.xlsx

XLSX spreadsheet 46 KB Posted

Attached to
USS RAMAGE (DDG 61) Extended Selected Restricted Availability (ESRA) Federal contract opportunity
Solicitation number
N00024-16-R-4402
Issued by
Department of the Navy Naval Sea Systems Command

About this file

J-4 Pricing Workbook (Ramage) 3.7

View the file

Other files for this federal contract opportunity

Other files attached to USS RAMAGE (DDG 61) Extended Selected Restricted Availability (ESRA), newest first.
File Type Posted
J-4_Pricing_Workbook_(Ramage)_Amendment_0009.xlsx XLSX spreadsheet
N00024-16-R-4402_(USS_RAMAGE_DDG_61)_Amendment_0009.pdf PDF
N00024-16-R-4402_Conformed_Amendment_0009.docx DOCX document
Amendment_0005.pdf PDF
N00024-16-R-4402_Conformed_Amendment_0004.docx DOCX document
RAMAGE-4402_QA_3_Final_4.14.pdf PDF
Amendment_0004_(4.12).pdf PDF
1)_N00024-16-R-4402-0003.pdf PDF
2)_RAMAGE-4402_QA__2___4.4.16.pdf PDF
1)_Amendment_0002.pdf PDF
1)_J-4_Pricing_Workbook_(Ramage)_Amendment_0002.xlsx XLSX spreadsheet
1)_N00024 _8208 16 _8208 R _8208 4402_Amendment_0001_3.28.16.pdf PDF
3)_J A_41 218_Redacted.pdf PDF
4)_RAMAGE-4402_QA_1_28_March_Final.pdf PDF
2)_CDRLS_A.pdf PDF
2)_CDRLS_B C.pdf PDF
1)_J-4_Pricing_Workbook_(Ramage)_Amendment_0001.xlsx XLSX spreadsheet
S-5_Eligibility_Criteria_Data_Sheet.docx DOCX document
S-3_PPI_Form.docx DOCX document
N00024-16-R-4402_Released_3.7.docx DOCX document
S-4_PP_Reference_List.docx DOCX document
J-5_QASP_3.7.docx DOCX document
S-2_Past_Performance_Questionnaire.docx DOCX document
S-1_Technical_Capabilities_Data_Sheet.docx DOCX document
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

Text version

Work Item Index

PrimeSubcontractor
Work ItemBase/OptionCOARCLINSubCLINItem DescriptionLabor HoursTotal Labor ($)Material ($)PriceLabor Hours SubTotal Labor ($) SubMaterial ($) SubPrice subWork Item Price
042-00-001Base160001001WPER Conference; Conduct$0$0$0
110-11-001Base160001001Structural Repair: Engine Room No.2$0$0$0
110-11-003Base160001001Bilge: Engine Room Number One Structural repair$0$0$0
113-11-005Base160001001Bilge: Engine Room Number Two Structural repair$0$0$0
120-11-001Base160001001Fan Room Structural Repair; accomplish$0$0$0
120-11-002Base160001001Structural Repair: Fan Rm 01-126-3-Q$0$0$0
120-11-003Base160001001Structural Repair: Fan Rm 1-300-1-Q$0$0$0
120-11-004Base160001001Structural Repair: Fan Rm 01-200-2-Q$0$0$0
120-11-005Base160001001Structural Repair: Generator Room No.3$0$0$0
123-11-001Base160001001Compensated Fuel Oil Tank; repair and preserve$0$0$0
123-11-002Base160001001Fuel Oil Service Tank; repair and preserve$0$0$0
123-11-003Base160001001Structural Repair: Vacuum Collecting Holding Tank No.1$0$0$0
123-15-001Base160001001Lube Oil Tank Bolted Plate Manhole Cover; replace$0$0$0
123-15-002Base160001001Lube Oil Storage Tank; repair$0$0$0
123-17-001Base260001001Structural Repair: Contaminated Oil Tk TWDT 4-370-2-F$0$0$0
150-11-001Base160001001Flight Deck Bulkhead; repair$0$0$0
150-11-002Base160001001Structural Repair: 06 LEVEL DECK, FRAME 131 TO 165$0$0$0
150-11-003Base160001001Structural Repair: Decks, 03, 04, 05 Lvl WD 01, 02 Lvl$0$0$0
150-11-004Base160001001Structural Repair: WD Stack (Aft) 02 Lvl$0$0$0
150-11-005Base160001001Structural Repair: Aft Stack Cap Deck FR 246-272$0$0$0
150-11-006Base160001001Structural Repair: Weather Deck 06 Level$0$0$0
150-11-007Base160001001Structural Repair: Weather Deck 01 Level, FR 202 (PORT), Midship$0$0$0
150-11-008Base160001001Structural Repair: Superstructure, Weather Deck Level$0$0$0
150-11-009Base160001001Structural Repair: 5th Deckhouse Level$0$0$0
150-11-010Base160001001Structural Repair, 01 Level Deck; accomplish$0$0$0
165-80-001Base160001001ShipAlt DDG51-76227D, Sonar Dome Relief Valve and Flange Modification; accomplish$0$0$0
167-11-001Base160001001Bolted Equipment Removal Plate (BERP) Repair; accomplish$0$0$0
167-80-001Base160001001SHIPALT DDG51-79662 1A and 1B Gas Turbine Module (GTM) Access Manhole Relocation Partial; accomplish$0$0$0
168-80-001Base160001001ShipAlt DDG51-78049D, Install Bridge Wing Void Manholes; accomplish$0$0$0
185-11-001Base160001001RO DEMIN Foundation; accomplish$0$0$0
185-11-002Base160001001Structural Repair, AUX-1; accomplish$0$0$0
185-11-003Base160001001Structural Repair; accomplish$0$0$0
234-13-001Base160001001Main Propulsion Gas Turbine Module (GTM) Vibration Damping Tile; replace$0$0$0
234-14-001Base160001001Main Propulsion Gas Turbine Module (GTM) Vibration Damping Plates; replace$0$0$0
245-11-001Base160001001Controllable Pitch Propeller (CPP) Oil Sump Tank Heater; inspect and clean$0$0$0
245-11-002Base160001001Leaking Mech Seal Standby Hydraulic Pump, CPP No.1$0$0$0
245-12-001Base160001001Controllable Pitch Propeller (CPP) Oil Sump Tank Heater; inspect and clean$0$0$0
251-31-001Base160001001Structural Repair: Engine Rm No.1 Intake 01-174-0-Q$0$0$0
251-31-002Base160001001Structural Repair: Engine Rm No.1 Uptake 02-186-0-Q$0$0$0
251-31-003Base160001001Structural Repair: Engine Rm No.2 Uptake 02-242-0-Q$0$0$0
251-32-001Base160001001Structural Repair: Engine Rm No.2, Intake trunks A & B, 2A/B GTM Inlet Plenum Corroded$0$0$0
256-61-001Base160001001SW-V-216, Isolation, Sea Water Cooling Main.$0$0$0
259-11-001Base160001001Gas Turbine (GTRB) Exhaust Duct Collector; repair$0$0$0
259-11-002Base160001001Bliss Cap Preservation: FWD and AFT Stacks$0$0$0
259-11-003Base160001001Structual Repair: Uptake 01-248-0-Q, Engine Rm No.2$0$0$0
259-11-004Base160001001Structural Repair, Corrosion in Uptake 2-166-2-Q$0$0$0
259-11-005Base160001001Degraded Insulation and Coating; accomplish$0$0$0
262-10-001Base160001001Main Reduction Gear (MRG) Lube Oil Cooler; clean and inspect$0$0$0
262-11-001Base160001001Flexible Hose Assembly; replace$0$0$0
262-11-002Base160001001L/O Inlet Header Drain Hose, MRG 1$0$0$0
262-21-001Base160001001Lube Oil Settling Tank Heater; inspect and clean$0$0$0
262-21-002Base160001001Lube Oil Settling Tank Heater; inspect and clean$0$0$0
262-22-001Base160001001Lube Oil Settling Tank Heater; inspect and clean$0$0$0
262-22-002Base160001001Lube Oil Settling Tank Heater; inspect and clean$0$0$0
262-80-001Base160001001SHIPALT DDG51-76501D, Main Reduction Gear Lube Oil Flexible Hoses; Accomplish$0$0$0
264-10-001Base160001001L/O Purifier Heaters No.1 & No.2; Calibrate$0$0$0
311-32-001Base260001001Cracked Exhaust Shroud, Enclosure Ship Service Gas Turbine Gen$0$0$0
313-80-001Base160001001Batteries and Service Facilities$0$0$0
321-80-001Base160001001DDG51 Class AER 64201D, Stuffing Tube Replacement; accomplish$0$0$0
432-11-001Base160001001Harpoon Launcher Stuffing Tubes; replace$0$0$0
436-80-001Base160001001ShipAlt DDG-51-83419D, Removal Halocarbon Monitoring System; Accomplish$0$0$0
441-11-001Base160001001AN/SRQ-4 Coax Jack Panel; replace$0$0$0
441-71-001Base160001001AM-6691A/WSC-1 Amplifier Box Foundation; replace$0$0$0
472-11-001Base160001001Special Lagging, Vent Duct; install$0$0$0
472-11-002Base160001001Special Lagging, Bridge Wing Mounting Panel, Passive Countermeasures (PCMS) Material; install$0$0$0
472-11-003Base160001001Special Lagging, Forward and After Stack; install$0$0$0
472-11-004Base160001001Special Lagging, Accommodation Ladder Yoke Trackway; install$0$0$0
472-11-005Base160001001Signal Bridge, Passive Countermeasures (PCMS) Material; repair$0$0$0
472-11-007Base160001001Windlass Ctrl Shield Tile/Trnvrs Blkhd FR 385 Tile MSSG; Special Purpose Coverings$0$0$0
482-11-001Base160001001MK 82 Mod 0 #2 & #3, Director Foundation Repair and Refurbish; accomplish$0$0$0
505-11-001Base160001001Silicon Aluminum Bronze (SAB) Union Fittings; replace$0$0$0
512-11-002Base160001001Supply Ventilation; replace$0$0$0
512-11-003Base160001001Galley and Laundry Exhaust Ventilation; clean$0$0$0
521-11-001Base160001001Firemain Piping Repair$0$0$0
522-80-001Base160001001ShipAlt DDG51-82474D, Relocation of CIWS, Torpedo and DLS Magazine Gauges: accomplish$0$0$0
526-11-001Base160001001Deck Drain; replace$0$0$0
528-80-001Base160001001ShipAlt DDG51-77691D, Weather Deck Drain and Trough Modifications; Accomplish$0$0$0
541-11-001Base160001001Tank Top Repair; accomplish$0$0$0
551-12-001Base160001001Generator Regulator Valve; Replace$0$0$0
551-51-001Base160001001High Pressure Air Compressor (HPAC) Class B Overhaul; accomplish$0$0$0
551-80-001Base160001001ShipAlt DDG51-73738, Installation of Additional Bulkhead Cutout Valves (partial); accomplish$0$0$0
571-80-001Base160001001SA 76201D RPNSM-AT-SEA XFER HDS,SLD BLOCKS, & SLD PADEYES; Remove$0$0$0
583-11-001Base160001001Boat Handling and Stowage System; repair$0$0$0
583-11-002Base160001001MK6 Encapsulated Lifeboat Cradles; replace$0$0$0
583-11-003Base160001001Single Liferaft, FR197 (S) Lower, Cradle / Incorrect Hardware Installed FR170 (P); Replace$0$0$0
583-11-004Base160001001Dual Lifeboat, FR296 (P) Outboard, Cradle Tie Downs/Banding; Accomplish$0$0$0
588-21-001Base160001001NAWC/ASIR Aviation Inspection Discrepancy; correct$0$0$0
593-11-001Base160001001Vacuum, Collection, Holding and Transfer (VCHT) Piping System; chemical cleaning$0$0$0
602-11-001Base160001001Main Reduction Gear Lube Oil Storage Tank Placard; replace$0$0$0
612-21-001Base160001001Helo Safety Net and Frame; repair$0$0$0
613-11-001Base160001001Darken Ship Curtain Assembly; repair$0$0$0
622-12-001Base160001001Nomex Deck Panel; replace$0$0$0
631-11-001Base160001001Underwater Log Trunk; repair and preserve$0$0$0
633-11-001Base160001001Zinc Anode; replace$0$0$0
634-11-001Base160001001Cosmetic Polymeric Deck Covering System; install$0$0$0
634-11-002Base160001001Cosmetic Polymeric Deck Covering System; install$0$0$0
634-11-003Base160001001Structural Repair, Scullery Deck; accomplish$0$0$0
634-21-001Base160001001Flight Deck Nonskid; replace$0$0$0
651-80-001Base160001001SA 70015D, REPL, Commissary Spaces$0$0$0
663-11-001Base160001001Chart Table; replace$0$0$0
663-11-002Base160001001Chart Table Top; replace$0$0$0
711-11-001Base160001001MK38/25MM Gun Mounts Removal/Installation; accomplish$0$0$0
813-11-001Base160001001AEGIS Light-Off Sched Availability Analysis and Report; Provide$0$0$0
980-11-001Base160001001Forward and AFT VLS Launcher Deck Preservation Support Service; Provide$0$0$0
980-11-002Base160001001Light-Off Discrepancy Correction Assistance; provide$0$0$0
982-11-001Base160001001Machinery Trial Discrepancy Correction; accomplish$0$0$0
982-31-001Base160001001Dock Trial, Fast Cruise, and Sea Trial; accomplish$0$0$0
982-31-002Base160001001MCHRY SP-COMPL/LOA DEFIC-CORR$0$0$0
992-11-001Base160001001Messing and Berthing Barge Tow Service; provide$0$0$0
992-11-002Base160001001Personnel Berthing Barge Support; provide$0$0$0
992-11-003Base160001001Pierside T-1 Line; provide$0$0$0
992-11-004Base160001001Ship's Force Parking; provide$0$0$0
992-11-005Base160001001Temporary Flammable Liquid Storage and Hazardous Material Storage Unit, 640 Square Feet; provide$0$0$0
992-11-008Base160001001Temporary Refrigerated Storage Facility, 3500 Cubic Feet; provide$0$0$0
992-11-010Base160001001Demineralized WTR; accomplish$0$0$0
992-11-011Base160001001RMC Office Space; Provide$0$0$0
992-31-001Base160001001Cleaning, Pumping, Defueling; accomplish$0$0$0
993-11-001Base160001001Ship's Force Warehouse Storage Space; provide$0$0$0
993-11-002Base160001001Rigging, Crane, Forklift and Transportation Service; provide$0$0$0
993-31-002Base160001001Dry Air Lay-Up; accomplish$0$0$0
993-31-003Base160001001Temporary Main Reduction Gear (MRG) Dehumidifier System; provide$0$0$0
993-31-004Base160001001SPY-1 ANT COVERS -PROV/INSTALL$0$0$0
993-90-004Base160001001GFM WAREHOUSE SPACE - provide$0$0$0
994-11-001Base160001001Temporary Ship Systems, General Housekeeping Svce$0$0$0
992-11-001Base160001002Messing and Berthing Barge Tow Service; provide
992-11-002Base160001002Personnel Berthing Barge Support; provide
314-90-001Base300001003ShipAlt DDG51-84931K, ENGINE CONTROLLER ISOLATION TR; Accomplish$0$0$0
411-90-001Base300001003ShipAlt DDG51-78511K, AWS:ACB12/TI12 CIC Display Upgrade for DDGS; accomplish$0$0$0
415-90-001Base300001003ShipAlt DDG51-79256K, AN/USG-2B Installation; Accomplish$0$0$0
456-90-001Base300001003ShipAlt DDG-51-77615K, ACB12/TI12 OA Computing Plant Upgrade for DDG; Accomplish$0$0$0
456-90-002Base300001003ShipAlt DDG51-78512K, AWS:ACB12/TI12 MMSP Upgrade for DDGS; Accomplish$0$0$0
456-90-003Base300001003ShipAlt DDG51-78513K, AWS: ACB12/TI12 KAS WDRC UPGRA; Accomplish$0$0$0
512-90-001Base300001003ShipAlt DDG51-74012K, BMD VLS Magazine Ventilation Upgrade; Accomplish$0$0$0
651-90-001Base300001003SA 82455 K DDGM CM Management (Garbage Grinder only)$0$0$0
721-90-001Base300001003ShipAlt DDG51-79584K, MK41- ACB 12 DDG SHIPALT; Accomplish$0$0$0
837-11-001Base160001003Antenna Photographs; provide$0$0$0
980-00-002Base300001003OrdAlt 74435, 79353, 80611; MK 41 VLS CRN & ELV RMVLST2; (Support Service Request)$0$0$0
980-90-001Base300001003ShipAlts 77052K, 76829K, 76869K, 78819K, 81728K, 82635K ; (Support Services Request)$0$0$0
980-90-009Base300001003NAVSEA Office Space; Provide$0$0$0
264-90-001Base300001004ShipAlt DDG-51-85973K, Lube Oil Purifier Heat Exchanger Modifications; Accomplish$0$0$0
042-27-001Base160004MH&MATL RSV ACCT-ACCOMP$0$0$0
077-10-001Base160004Hazardous Waste Produced on Naval Vessels; control$0$0$0
991-11-001Base160004Mast Staging for Ship's Force Use; provide$0$0$0
992-11-007Base160004Temporary Air Conditioning; provide$0$0$0
992-11-009Base160004Temporary Service; provide$0$0$0
993-31-001Base160004Temporary Deck Covering; install$0$0$0
980-11-004Option920005ShipAlt DDG51-80934K, PEOC4I KMI AN/GYK-72(V); (Support Services Request)$0$0$0
980-31-001Option920005SPAWAR Office Space; Provide$0$0$0
643-80-001Option940006BCPO-S1205 CPO Berthing BENL-S7319; Renew$0$0$0
644-80-001Option940006HCPO-S1207 CPO / HENL-S7320 ENL Sanitary SP; Renew$0$0$0
980-90-008Option930007ShipAlt DDG51-70430K, MARK XIIA MODE 5 IFF SYSTEM; (Support Services Request)$0$0$0
980-00-003Option910008001OrdAlts 78778, 79024, 74603, 70699 - AN/SPY-1 Series: Support Services Provide$0$0$0
980-11-003Option930008002OrdAlt 20353, ELEC CNTRL VLVS ON C&D WTR CLR ; (Support Services Request)$0$0$0
980-00-001Option930009OrdAlt 80831, BMD - MK99 KAS DDG ILLUMINATOR ; (Support Services Request)$0$0$0
980-11-005Option930009OrdAlt 74588, MK 99 FCS KAS ; (Support Services Request)$0$0$0
980-90-007Option930010ShipAlt DDG51-79362K, AWS SEAWATER FLOW METER FOR SP; (Support Services Request)$0$0$0
462-11-001Option930011ShipAlt DDG51- 86644K, USW-DSS AN/UYQ-100(V)3; Accomplish$0$0$0
495-90-001Option930011SAs 86574K, USW-DSS AN/UYQ-100(V)3 INFRAST; Accomplish$0$0$0
980-90-002Option930012ShipAlt DDG51-79686K and 78221K CIWS BLOCK 1B NEXT GENERATION; (Support Services Request)$0$0$0
980-90-003Option930013ShipAlt DDG51-00151.02K, AMR1& AC MACH R-114 A/C UPGRAD; (Support Service Request)$0$0$0
980-90-006Option930014ShipAlt DDG51-80315K, REPLACE AFFF AND CMWD SOPVS; (Support Services Request)$0$0$0
472-90-001Option930015Shipalt 80156K AN/SLQ-32(V)6 SEWIP Block 2 Upgrade With Shipalt 81382K; accomplish$0$0$0
980-90-005Option930016ShipAlt DDG51-79975K, BFTT HARDWARE BUILD 4.1 RACK 2; (Support Services Request)$0$0$0
980-04-001Option930017ShipAlt DDG51-86206K, AN/SQQ-89A(V)15 CHANGES TO SUP; (Support Services Request)$0$0$0
Total:000000000

Labor&Material Burden Rate

RatePrice
Hours$($ * hours)
Direct Production83,188$0
Material$1,305,253
Material Burden RateInsert Rate ->
Total Material Price =Material * (1+ Material Burden Rate)$1,305,253

Proposed Labor & Material Burden Rate Growth Price $1,305,253

The excel file has imbedded formulas. Offeror shall insert proposed rates in the highlighted cells in the format provided, with the formulas maintained.

The number of hours and material dollar values are for evaluation purposes only. While the hour and material dollar values are based on historical data and are indicative of the typical requirements for growth/new work on an average ESRA on a DDG 51 class ship, the proposed labor and material burden rates will be the fixed rates for the entire availability regardless of how many hours and how much material are procured.

Total Proposed-Evaluated Price

Total Proposed/Evaluated Price
Total Work Item Price$0
Proposed Labor & Material Burden Rate Growth Price$1,305,253
Interport Differential (if applicable as stated in Section L)
Total Evaluated Price$1,305,253

File details come from the government source that posted it. Updated .