J-14_Pricing_Workbook_111517_(ECN).xlsx

XLSX spreadsheet 39 KB Posted

Attached to
USS SAMPSON 8C1 DSRA Federal contract opportunity
Solicitation number
N4523A-18-R-0550
Issued by
Department of the Navy Naval Sea Systems Command

View the file

Other files for this federal contract opportunity

Other files attached to USS SAMPSON 8C1 DSRA, newest first.
File Type Posted
N4523A-18-R-0550_Amendment_0019.pdf PDF
N4523A-18-R-0550_Amendment_0017.pdf PDF
N4523A-18-R-0550_Amendment_0016.pdf PDF
N4523A-18-R-0550_Amendment_0012.pdf PDF
N4523A-18-R-0550_Amendment_0011.pdf PDF
BQ_027_4720_request_Redacted.pdf PDF
DDG_102_DSRA_A-7_4720_Report_dtd_18_DEC_17.pdf PDF
512-8718347-VENT12_REV-A_SANITARY_VENT_MODS.pdf PDF
640-8718343-ARR01_REV-A_BERTHING_ARR_MODS.pdf PDF
331-8718349-ELEC32_REV-A_SANITARY_ELEC_MODS.pdf PDF
N4523A-18-R-0550_J-12_PPI_Q_010_Redacted.pdf PDF
BQ_015_588-21-001_-_Redacted.pdf PDF
N4523A-18-R-0550_Amendment_0007.pdf PDF
BQ_022_980-90-007_References-Redacted.pdf PDF
BQ_007_437-012-001_Para_3.2_-_Redacted.pdf PDF
BQ_011_Clarification_-_Answered_1-16-18_Redacted.pdf PDF
BQ_013_462-11-001_Missing_Ref_-_Answered_1-12-18_Redacted.pdf PDF
BQ_008_Extension_Request_-_Answered_01-16-18_Redacted.pdf PDF
N4523A-18-R-0550_Amendment_0004.pdf PDF
J-18_Access_and_User_Agreement_rev_002_01102018.pdf PDF
N4523A-18-R-0550_Amendment_0003.pdf PDF
N4523A-18-R-0550_J-12_Pre-Proposal_Information_(PPI)_Form_Q_002_Redacted.pdf PDF
N4523A-18-R-0550_J-12_Pre-Proposal_Information_(PPI)_Form_Q_017_Redacted.pdf PDF
N4523A-18-R-0550_J-12_Pre-Proposal_Information_(PPI)_Form_Q_007_Redacted.pdf PDF
N4523A-18-R-0550_J-12_Pre-Proposal_Information_(PPI)_Form_Q_016_Redacted.pdf PDF
N4523A-18-R-0550_J-12_Pre-Proposal_Information_(PPI)_Form_Q_015_Map_1.pdf PDF
N4523A-18-R-0550_J-12_Pre-Proposal_Information_(PPI)_Form_Q_006_Redacted.pdf PDF
N4523A-18-R-0550_Amendment_0001.pdf PDF
BODY_OF_PAGE_LEFT_INTENTIONALLY_BLANK.pdf PDF
BODY_OF_PAGE_LEFT_INTENTIONALLY_BLANK.pdf PDF
J-16_CDRL_A021_Heavy_Weather_Plan.pdf PDF
MIL-STD-1310.pdf PDF
J-16_CDRL_A004_CFM_Report.pdf PDF
J-13_NSE_Pier_Load_Limit_Summary.pdf PDF
J-1_Work_Package_ERRATA_3.pdf PDF
J-16_CDRL_A036_Certification_Data_Report.pdf PDF
J-16_CDRL_A027_Equal_Component_Rprt.pdf PDF
J-21_ALO_Compt_Release_Sched_Memo.docx DOCX document
J-16_CDRL_C001_COTS_Equip_Manual_Support.pdf PDF
J-10_Local_Standard_Item_099-01NW.pdf PDF
VLS_INSTR_86-2D_US_NAVY_MK_41_VERTICAL_LAUNCHING_SYSTEM_PERSONNEL_CERTIFICATION_PROGRAM.pdf PDF
J-16_CDRL_A024_Incident_Report.pdf PDF
J-16_CDRL_A014_Asbestos_Containing_Material.pdf PDF
SAMPSON_DDG-102_SRA15_-_SDI.pdf PDF
MIL-STD-1689.pdf PDF
J-4_Planning_Event_Readiness_List_-_PERL.pdf PDF
J-19_FRP_Reference_List_Document.xlsx XLSX spreadsheet
J-16_CDRL_A022_Contractor's_Safety_Plan.pdf PDF
MIL-STD-2035.pdf PDF
MIL-STD-2199.pdf PDF
Show all 50

USS SAMPSON 8C1 DSRA has more files on GovTribe.

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

DDG102 CLIN 0001 Pricing

USS SAMPSON DSRA CONTRACTOR PRICING SPREADSHEET Solicitation N4523A-18-R-0550
Notice: this work sheet contains embedded cells; only enter data in the yellow highlighted cells.PrimeSubcontractor
Work SpecCOARTitleLabor HoursTotal Labor ($)Material ($)PriceLabor HoursTotal Labor ($)Material ($)PriceWork Item Price
042-11-00116Accountability of Man-hour and Material Reservation; accomplish$ - 0$ - 0$ - 0
042-11-00216Work Completion Certification; accomplish$ - 0$ - 0$ - 0
042-11-00316Schedule and Associated Reports; provide and manage$ - 0$ - 0$ - 0
042-11-00416Work Package Execution Review; accomplish$ - 0$ - 0$ - 0
077-10-00116Environmental Protection and Hazardous Waste Management Program; provide$ - 0$ - 0$ - 0
077-11-00116Contractor Hazardous Waste Produced on Naval Vessels; control$ - 0$ - 0$ - 0
110-11-00116Underwater Hull; inspect and repair$ - 0$ - 0$ - 0
110-11-00216Hull and Support Structure Inspection; accomplish$ - 0$ - 0$ - 0
113-11-00116Machinery Space Bilge Drain Well; repair$ - 0$ - 0$ - 0
121-11-00116Structural Framing; repair$ - 0$ - 0$ - 0
121-11-00216Structural Framing; repair$ - 0$ - 0$ - 0
123-00-00116Tank and Void Open, Pump, Clean and Gas Free; accomplish$ - 0$ - 0$ - 0
123-11-00116Compensated Fuel Tank; preserve$ - 0$ - 0$ - 0
123-11-00216Compensated Fuel Tank; repair$ - 0$ - 0$ - 0
123-11-00316Compensated Fuel Tank; repair$ - 0$ - 0$ - 0
123-11-00416Compensated Fuel Tank; repair$ - 0$ - 0$ - 0
123-11-00516Compensated Fuel Tank; preserve$ - 0$ - 0$ - 0
123-11-00616Compensated Fuel Tank; preserve$ - 0$ - 0$ - 0
123-11-00716Compensated Fuel Tank; repair$ - 0$ - 0$ - 0
123-11-00816Fuel Service Tank and Gravity Head Tank; preserve$ - 0$ - 0$ - 0
123-11-00916Compensated Fuel Tank; repair$ - 0$ - 0$ - 0
123-11-01016Compensated Fuel Tank; preserve$ - 0$ - 0$ - 0
123-11-01116Compensated Fuel Tank; preserve$ - 0$ - 0$ - 0
123-11-01216Compensated Fuel Tank; preserve$ - 0$ - 0$ - 0
123-11-01316Compensated Fuel Tank; preserve$ - 0$ - 0$ - 0
123-11-01416Compensated Fuel Tank; preserve$ - 0$ - 0$ - 0
123-11-01516Compensated Fuel Tank; preserve$ - 0$ - 0$ - 0
123-11-01616Compensated Fuel Tank; repair$ - 0$ - 0$ - 0
123-11-01716Fuel Oil Service and Gravity Head Tank; repair$ - 0$ - 0$ - 0
123-11-01816Fuel Service Tank; repair$ - 0$ - 0$ - 0
123-11-01916Fuel Service Tank; preserve$ - 0$ - 0$ - 0
123-12-00116JP-5 Tank; preserve$ - 0$ - 0$ - 0
123-14-00116Potable Water Tank; repair$ - 0$ - 0$ - 0
123-14-00216Potable Water Tank; preserve$ - 0$ - 0$ - 0
123-17-00116Contaminated Oil Tank; repair$ - 0$ - 0$ - 0
123-17-00216Contaminated Oil Tank; preserve$ - 0$ - 0$ - 0
123-19-00116Waste Water Tank; repair$ - 0$ - 0$ - 0
123-19-00216Waste Water Tank; preserve$ - 0$ - 0$ - 0
123-19-00316Vacuum Collection Holding Tank; repair$ - 0$ - 0$ - 0
123-19-00416Vacuum Collection Holding Tank; preserve$ - 0$ - 0$ - 0
123-21-00116Accessible Void; repair$ - 0$ - 0$ - 0
123-21-00216Fueling At Sea Accessible Void; repair$ - 0$ - 0$ - 0
123-21-00316Bulkhead Structure; repair$ - 0$ - 0$ - 0
123-22-00116Chain Locker and Chain Locker Sump; preserve$ - 0$ - 0$ - 0
123-22-00216Accessible Void; preserve$ - 0$ - 0$ - 0
123-22-00316Chain Locker and Chain Locker Sump; repair$ - 0$ - 0$ - 0
130-11-00116Aircraft Securing Fitting; replace$ - 0$ - 0$ - 0
150-11-00116Deck Structural Repair; accomplish$ - 0$ - 0$ - 0
150-11-00216Aqueous Film Forming Foam (AFFF) Stations Deck; preserve$ - 0$ - 0$ - 0
150-80-00116AER DDG51-83007D, Increase Deck Plate Thickness (Partial); accomplish$ - 0$ - 0$ - 0
165-11-00116Lower Sonar Dome Access Scuttle; repair$ - 0$ - 0$ - 0
165-11-00216Sonar Dome Rubber Window (SDRW); inspect and repair$ - 0$ - 0$ - 0
165-11-00316Sonar Dome Rubber Window (SDRW) Radiographic Evaluation; accomplish$ - 0$ - 0$ - 0
167-11-00116Bolted Equipment Removal Plate (BERP) Repair; accomplish$ - 0$ - 0$ - 0
167-11-00216Hatch; repair$ - 0$ - 0$ - 0
167-11-00316Watertight Scuttle; replace$ - 0$ - 0$ - 0
167-80-00116ShipAlt DDG51-77228D, CRES Individually Dogged Watertight Door Replacement; accomplish$ - 0$ - 0$ - 0
241-11-00116Number One Main Reduction Gear (MRG) Turning Gear; repair$ - 0$ - 0$ - 0
243-11-00116Starboard Propulsion Shafting; inspect and repair$ - 0$ - 0$ - 0
243-11-00216Starboard Stern Tube Shaft Seal; overhaul$ - 0$ - 0$ - 0
243-12-00116Port Propulsion Shafting; inspect and repair$ - 0$ - 0$ - 0
243-12-00216Port Stern Tube Shaft Seal; overhaul$ - 0$ - 0$ - 0
245-11-00116Starboard Controllable Pitch Propeller (CPP) System; repair$ - 0$ - 0$ - 0
245-12-00116Port Controllable Pitch Propeller (CPP) System; repair$ - 0$ - 0$ - 0
251-30-00116Gas Turbine Intake; repair and preserve$ - 0$ - 0$ - 0
251-30-00216Gas Turbine Intake; repair and preserve$ - 0$ - 0$ - 0
251-31-00116Ships Service Gas Turbine Generator (SSGTG) Intake Trunk; preserve$ - 0$ - 0$ - 0
251-31-00216Air Intake and Exhaust Louver; clean and preserve$ - 0$ - 0$ - 0
259-10-00116Number 2 Gas Turbine Mixing Room, Uptake; repair$ - 0$ - 0$ - 0
259-10-00216Number One Gas Turbine Mixing Room, Uptake; repair$ - 0$ - 0$ - 0
259-11-00116Gas Turbine (GTRB) Exhaust Duct Collector; repair$ - 0$ - 0$ - 0
261-11-00116Fuel Oil Service Heater; clean and inspect$ - 0$ - 0$ - 0
262-11-00216Main Reduction Gear (MRG) Lube Oil Cooler; clean and inspect$ - 0$ - 0$ - 0
262-80-00116ShipAlt DDG51-75044D Main Reduction Gear (MRG) Shaft Lock Piping Interference Modification; accomplish$ - 0$ - 0$ - 0
262-80-00216ShipAlt DDG51-76501D, Main Reduction Gear Lube Oil Flexible Hose; accomplish$ - 0$ - 0$ - 0
300-11-00116Cable and Cableway Inspection; accomplish$ - 0$ - 0$ - 0
437-21-00116Tank Level Indicator (TLI) Bushing; install$ - 0$ - 0$ - 0
462-11-00116TR-232B/WQC-2A and TR-233B/WQC-2A, Transducer Cables and DT-513B/BQA-8 Hydrophones; replace$ - 0$ - 0$ - 0
463-80-00116ShipAlt DDG51-76231D, Sonar Stave Cable Connectorization and Transducer Element Replacement; accomplish$ - 0$ - 0$ - 0
472-90-00116ShipAlt's DDG51-80156K and 81382K, AN/SLQ-32(V)6 SEWIP Block 2 Upgrade; accomplish$ - 0$ - 0$ - 0
508-11-00116Machinery Space Insulation; replace$ - 0$ - 0$ - 0
512-11-00116Galley and Laundry Exhaust Ventilation; clean$ - 0$ - 0$ - 0
512-11-00216Ventilation Ducting and Vaneaxial Fan Unit; replace$ - 0$ - 0$ - 0
512-11-00316Cooling Coil; repair$ - 0$ - 0$ - 0
512-11-00416Supply Ventilation; clean and repair$ - 0$ - 0$ - 0
512-11-00516Collective Protection System Louvers; preserve$ - 0$ - 0$ - 0
512-11-00616Ventilation Spool; replace$ - 0$ - 0$ - 0
514-11-00116Chilled Water Isolation Valves; replace$ - 0$ - 0$ - 0
514-21-00116Air Conditioning (AC) Plant Condenser; clean$ - 0$ - 0$ - 0
520-11-00116Sea Valve; repair and replace$ - 0$ - 0$ - 0
523-11-00116Countermeasure Washdown (CMWD) System Zone 2 and 4; repair$ - 0$ - 0$ - 0
526-80-00116AER DDG51-64085D, Weather Deck Drain Modification; accomplish$ - 0$ - 0$ - 0
526-80-00216AER DDG51-64244D, Weather Deck Drain; install$ - 0$ - 0$ - 0
526-80-00316AER DDG51-64270D, 02 Level Weather Deck Drain Installation; accomplish$ - 0$ - 0$ - 0
541-11-00116Fuel Oil Butterfly Valve; replace$ - 0$ - 0$ - 0
541-12-00116Fuel Oil Transfer Piping; repair$ - 0$ - 0$ - 0
551-11-00116Anti-Icing and Bleed Air Pipe Hanger Liner; replace$ - 0$ - 0$ - 0
551-21-00116Low Pressure Air Receiver; repair$ - 0$ - 0$ - 0
551-60-00116Spring Hanger; replace$ - 0$ - 0$ - 0
551-62-00116Masker and Prairie Air Cooler; clean and inspect$ - 0$ - 0$ - 0
562-11-00116Port and Starboard Rudder Bearing Seal and Rudderstock Seal; repair$ - 0$ - 0$ - 0
562-11-00216Rudder; inspect and repair$ - 0$ - 0$ - 0
562-11-00316Rudder; inspect and repair$ - 0$ - 0$ - 0
571-11-00116Sliding Padeye, Tilting; preserve$ - 0$ - 0$ - 0
581-11-00116Ground Tackle; inspect and preserve$ - 0$ - 0$ - 0
582-11-00116Retractable Chock and Drain; repair$ - 0$ - 0$ - 0
583-11-00116Slewing Arm Davit (SLAD); overhaul$ - 0$ - 0$ - 0
588-21-00116Recovery Assist, Securing and Traversing (RAST) System Track and Plate; clean and preserve$ - 0$ - 0$ - 0
593-11-00116Vacuum, Collection, Holding and Transfer (VCHT) Piping System chemical cleaning; accomplish$ - 0$ - 0$ - 0
611-80-00116AER DDG51-64185D, Anchor Chain Chafing Plate Installation; accomplish$ - 0$ - 0$ - 0
612-11-00116Stanchion Deck Socket; repair$ - 0$ - 0$ - 0
623-21-00116Starboard Bail Bracket; repair$ - 0$ - 0$ - 0
624-11-00116Balanced Joiner Door; remove, store and install$ - 0$ - 0$ - 0
631-11-00116Forward Machinery Rooms Bilge; preserve$ - 0$ - 0$ - 0
631-11-00216Aft Machinery Room Bilge; preserve$ - 0$ - 0$ - 0
631-21-00116Mast Preservation; accomplish$ - 0$ - 0$ - 0
631-31-00116Underwater Hull; preserve$ - 0$ - 0$ - 0
631-41-00116Freeboard Preservation; accomplish$ - 0$ - 0$ - 0
633-21-00116Impressed Current Cathodic Protection (ICCP) System Reference Electrode; replace$ - 0$ - 0$ - 0
634-11-00116Deck Covering System; replace$ - 0$ - 0$ - 0
634-11-00216Carpet; install$ - 0$ - 0$ - 0
634-11-00316Recovery Assist Securing and Traversing System (RAST) Machinery Room Nonskid; replace$ - 0$ - 0$ - 0
634-11-00416Magazine Nonskid; replace$ - 0$ - 0$ - 0
634-21-00116Flight Deck Nonskid; replace$ - 0$ - 0$ - 0
635-11-00116Number 2 Main Engine Room Uptake Insulation; replace$ - 0$ - 0$ - 0
643-11-00133Berthing Habitability Projects BENL-S5356 and HENL-S5354 Installation; accomplish$ - 0$ - 0$ - 0
644-11-00116Washroom Shower Stall and Deck; repair$ - 0$ - 0$ - 0
651-11-00116Crew/Chief Petty Officer Galley Griddle; replace$ - 0$ - 0$ - 0
651-80-00116ShipAlt DDG51-70015D, Scullery Dishwasher Installation; accomplish$ - 0$ - 0$ - 0
655-80-00116ShipAlt DDG51-00429D, Self Service Laundry Installation; accomplish$ - 0$ - 0$ - 0
721-31-00116Vertical Launch System (VLS) flush; accomplish$ - 0$ - 0$ - 0
721-31-00216Vertical Launch System (VLS); preserve$ - 0$ - 0$ - 0
721-31-00316Vertical Launching System (VLS), Cell Hatch; replace$ - 0$ - 0$ - 0
837-11-00116Antenna Photographs; provide$ - 0$ - 0$ - 0
844-31-00116Combat Systems Discrepancy Correction; accomplish$ - 0$ - 0$ - 0
864-11-00116Light-Off Discrepancy Correction Assistance; provide$ - 0$ - 0$ - 0
980-90-00146OrdAlt DDG102-74603K, Sidewall Capacitor Monitor, Alteration Installation Team (AIT) Support Service; provide$ - 0$ - 0$ - 0
980-90-00230DDG51 Class OrdAlt 83135, Close In Weapons System (CIWS) BLK-1B, Alteration Installation Team (AIT)Support Service; provide$ - 0$ - 0$ - 0
980-90-00330DDG51 Class OrdAlt OA 70078, OA 70920, OA 70921, OA 77862, and OA 83489 Alteration Installation Team (AIT) Support Service; provide$ - 0$ - 0$ - 0
980-90-00435ShipAlt DDG51-81798K, NAVMACS Technical Refresh Alteration Installation Team (AIT) Support Service; provide$ - 0$ - 0$ - 0
980-90-00535ShipAlt DDG51-87402K, SSEE INC F AS4293A UPG, Alteration Installation Team (AIT) Support Service; provide$ - 0$ - 0$ - 0
980-90-00635ShipAlt DDG51-88045K, CANES Mod 01, Alteration Installation Team (AIT) Support Service; provide$ - 0$ - 0$ - 0
980-90-00830ShipAlt DDG51-00288K, Convert Bosin Storeroom No. 2 to Hazardous Materials Minimization Center; accomplish$ - 0$ - 0$ - 0
982-31-00116Dock Trial, Fast Cruise, and Sea Trial; accomplish$ - 0$ - 0$ - 0
991-12-00116Staging for Ship's Force Use; provide$ - 0$ - 0$ - 0
992-10-00116Wharf and Pier Laydown Area; utilize and manage$ - 0$ - 0$ - 0
992-11-00116Temporary Service at Contractor's Facility; provide$ - 0$ - 0$ - 0
992-11-00316Temporary Refrigerated Storage Facility, provide$ - 0$ - 0$ - 0
992-11-00416Temporary Air Conditioning; provide$ - 0$ - 0$ - 0
992-11-00616Demineralized Water; provide$ - 0$ - 0$ - 0
992-11-00716Temporary Flammable Liquid Storage and Hazardous Material Storage Unit; provide.$ - 0$ - 0$ - 0
992-11-00816Temporary Services at Naval Station Everett; provide$ - 0$ - 0$ - 0
992-31-00116Cleaning and Pumping; accomplish$ - 0$ - 0$ - 0
993-11-00116Ship's Force Warehouse Storage Space; provide$ - 0$ - 0$ - 0
993-31-00116Temporary Main Reduction Gear (MRG) Dehumidifier System; provide$ - 0$ - 0$ - 0
993-31-00216AN/SPY-1D Antenna Protective Cover; install$ - 0$ - 0$ - 0
993-31-00316Temporary Deck Covering; install$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
Total Price of All Work Items0$ - 0$ - 0$ - 000000
Notice: this work sheet contains embedded cells; only enter data in the yellow highlighted cells.
Note: this "Total Price of All Work Items" value will auto-populate from above; do not manually enter this number. Offeror shall enter this number as "AMOUNT" for their CLIN 0001 price of Section B of the solicitation.0

&"Times New Roman,Bold"In Process Work Spec List &"Times New Roman,Bold"&D-&T

DDG 102 CLIN 0003 Option item

USS SAMPSON DSRA CONTRACTOR PRICING SPREADSHEET Solicitation N4523A-18-R-0550
Notice: this work sheet contains embedded cells; only enter data in the yellow highlighted cells.PrimeSubcontractor
Work SpecCOARTitleLabor HoursTotal Labor ($)Material ($)PriceLabor HoursTotal Labor ($)Material ($)PriceWork Item Price
980-90-00730ShipAlt DDG51-82710K Hybrid Electric Drive (HED), Alteration Installation Team (AIT) Support Service$ - 0$ - 0$ - 0
Total Price of All Work Items0$ - 0$ - 0$ - 000000
Notice: this work sheet contains embedded cells; only enter data in the yellow highlighted cells.
Note: this "Total Price of All Work Items" value will auto-populate from above; do not manually enter this number. Offeror shall enter this number as "AMOUNT" for their CLIN 0003 price of Section B of the solicitation.0

&"Times New Roman,Bold"In Process Work Spec List &"Times New Roman,Bold"&D-&T

DDG102Labor&Matl Burden Rates

USS SAMPSON DSRA CONTRACTOR PRICING SPREADSHEET Solicitation N4523A-18-R-0550
Notice: only enter data on this worksheet in the yellow highlighted cells below.
Insert rate belowPrice
HoursRate $($ * hours)
Direct Production (See Section B Note A)35,000$0.00$0
Material$750,000
Material Burden RateInsert Rate ---->
Total Material Price =Material * (1+ Material Burden Rate)$750,000

Proposed Labor & Material Burden Rate Growth Price $750,000

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

Notice: The 35,000 hours and $750,000.00 material dollar values are for evaluation only. While the hour and material dollar values are based on historical data and are indicative of the number of hours and the dollar value of material typically required for growth on an average SRA on a DDG 51 class ship, the Contractor's proposed labor and material burden rates inserted on the worksheet will be incorproated into the contract and will be the fully burdened fixed labor and material fully burden rates for contract changes regardless of how many hours and how much material are procured as detailed in Section B Note A.

Sheet1

File details come from the government source that posted it.