J-14_Pricing_Workbook_111517_rev001_(ECN).xlsx

XLSX spreadsheet 40 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_0015.pdf PDF
N4523A-18-R-0550_Amendment_0013.pdf PDF
USS_Sampson_IMO_IMS_J._Fagnant_2017-12-12.pdf PDF
BQ_028_PPT_HED_Informational_Brief_for_DDG_102.pptx PPTX presentation
N4523A-18-R-0550_Amendment_0010.pdf PDF
182-8749113_Rev_A,_HYBRID_ELEC_DRIVE_HULL_OUTFIT,_STRUCT_&_FDN_MODS_&_ML.pdf PDF
BQ_028_980-90-007_clarification_Redacted.pdf PDF
N4523A-18-R-0550_Amendment_0009.pdf PDF
644-8718346-ARR03_REV-A_SANITARY_ARR_MODS.pdf PDF
512-8718344-VENT10_REV-A_BERTHING_VENT_MODS.pdf PDF
331-8718345-ELEC30_REV-A_BERTHING_ELEC_MODS.pdf PDF
BQ_005_437-012-001_Missing_Drawings_-_Redacted.pdf PDF
BQ_016_588-21-001_-_Redacted.pdf PDF
BQ_019_123-10-001_-_Redacted.pdf PDF
BQ_009_Clarification_-_Redacted.pdf PDF
BQ_21_123-21-001_-_Redacted.pdf PDF
N4523A-18-R-0550_Amendment_0006.pdf PDF
N4523A-18-R-0550_Amendment_0005.pdf PDF
BQ_012_123-00-001_-_Answered_1-11-18_Redacted.pdf PDF
J-1_Work_Package_Errata_5_-_Addendum_1.pdf PDF
BQ_002_J-2_Drawings_-_Answered_1-5-18_Redacted.pdf PDF
N4523A-18-R-0550_J-12_Pre-Proposal_Information_(PPI)_Form_Q_008_-_Answered_09JAN18_Redacted.pdf PDF
N4523A-18-R-0550_J-12_Pre-Proposal_Information_(PPI)_Form_Q_015_Map_2.pdf PDF
N4523A-18-R-0550_J-12_Pre-Proposal_Information_(PPI)_Form_Q_013_Map.pdf PDF
N4523A-18-R-0550_J-12_Pre-Proposal_Information_(PPI)_Form_Q_015_Map_3.pdf PDF
J-16_CDRL_A025_Compt_Closeout_Sched_Rprt.pdf PDF
Resource_Conservation_and_Recovery_Act,_(RCRA).pdf PDF
NFPA_30,_Flammable_and_Combustible_Liquids_Code.pdf PDF
J-15_PPQ.doc DOC document
J-16_CDRL_A007_Quality_System_Plan.pdf PDF
NFPA_701_Rev_15,_Fire_Tests_for_Flame_Propagation_of_Textiles_and_Films.pdf PDF
J-16_CDRL_A002_Condition_Found_Report.pdf PDF
59312-3-010A_VCHT_System_Operational_Test.pdf PDF
J-16_CDRL_A001_Production_or_Delivery_Problem(s).pdf PDF
J-16_CDRL_A017_Accountability_of_Temp_Blanks.pdf PDF
J-16_CDRL_A003_GFM_CFR.pdf PDF
NAVMED_P-5010-1_Manual_of_Naval_Preventive_Medicine,_Chapter_1,_Food_Safety.pdf PDF
UFC-4-152-01,_Unified_Facilities_Criteria_(UFC),_Design_Piers_and_Wharves.pdf PDF
DDG_102_SRA_3-2015_Final.pdf PDF
J-18_Access_and_User_Agreement.docx DOCX document
J-16_CDRL_A033_Logistics_Mgmt_-_Process_Memo.pdf PDF
MIL-STD-419E.pdf PDF
NFPA_70,_National_Electrical_Code.pdf PDF
J-16_CDRL_A034_Technical_Report_-_Configuration.pdf PDF
J-16_CDRL_A009_Work_Completion_Certification.pdf PDF
J-8_Contractor_Proposal_Guide.pdf PDF
J-16_DIDs_Package.pdf PDF
59312-3-005_Rev_A,_VCHT_Tank_Level_Indicator_Sensor_Test.pdf PDF
J-9_Env_Guide_For_Contractors_at_NSE_-_May16.pdf PDF
J-19_Contractor_FRP_Matrix.xlsx XLSX spreadsheet
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
541-12-00116Fuel Oil Transfer Piping; repair
551-11-00116Anti-Icing and Bleed Air Pipe Hanger Liner; replace
551-21-00116Low Pressure Air Receiver; repair
551-60-00116Spring Hanger; replace
551-62-00116Masker and Prairie Air Cooler; clean and inspect
562-11-00116Port and Starboard Rudder Bearing Seal and Rudderstock Seal; repair
562-11-00216Rudder; inspect and repair
562-11-00316Rudder; inspect and repair
571-11-00116Sliding Padeye, Tilting; preserve
581-11-00116Ground Tackle; inspect and preserve
582-11-00116Retractable Chock and Drain; repair
583-11-00116Slewing Arm Davit (SLAD); overhaul
588-21-00116Recovery Assist, Securing and Traversing (RAST) System Track and Plate; clean and preserve
593-11-00116Vacuum, Collection, Holding and Transfer (VCHT) Piping System chemical cleaning; accomplish
611-80-00116AER DDG51-64185D, Anchor Chain Chafing Plate Installation; accomplish
612-11-00116Stanchion Deck Socket; repair
623-21-00116Starboard Bail Bracket; repair
624-11-00116Balanced Joiner Door; remove, store and install
631-11-00116Forward Machinery Rooms Bilge; preserve
631-11-00216Aft Machinery Room Bilge; preserve
631-21-00116Mast Preservation; accomplish
631-31-00116Underwater Hull; preserve
631-41-00116Freeboard Preservation; accomplish
633-21-00116Impressed Current Cathodic Protection (ICCP) System Reference Electrode; replace
634-11-00116Deck Covering System; replace
634-11-00216Carpet; install
634-11-00316Recovery Assist Securing and Traversing System (RAST) Machinery Room Nonskid; replace
634-11-00416Magazine Nonskid; replace
634-21-00116Flight Deck Nonskid; replace
635-11-00116Number 2 Main Engine Room Uptake Insulation; replace
643-11-00133Berthing Habitability Projects BENL-S5356 and HENL-S5354 Installation; accomplish
644-11-00116Washroom Shower Stall and Deck; repair
651-11-00116Crew/Chief Petty Officer Galley Griddle; replace
651-80-00116ShipAlt DDG51-70015D, Scullery Dishwasher Installation; accomplish
655-80-00116ShipAlt DDG51-00429D, Self Service Laundry Installation; accomplish
721-31-00116Vertical Launch System (VLS) flush; accomplish
721-31-00216Vertical Launch System (VLS); preserve
721-31-00316Vertical Launching System (VLS), Cell Hatch; replace
837-11-00116Antenna Photographs; provide
844-31-00116Combat Systems Discrepancy Correction; accomplish
864-11-00116Light-Off Discrepancy Correction Assistance; provide
980-90-00146OrdAlt DDG102-74603K, Sidewall Capacitor Monitor, Alteration Installation Team (AIT) Support Service; provide
980-90-00230DDG51 Class OrdAlt 83135, Close In Weapons System (CIWS) BLK-1B, Alteration Installation Team (AIT)Support Service; provide
980-90-00330DDG51 Class OrdAlt OA 70078, OA 70920, OA 70921, OA 77862, and OA 83489 Alteration Installation Team (AIT) Support Service; provide
980-90-00435ShipAlt DDG51-81798K, NAVMACS Technical Refresh Alteration Installation Team (AIT) Support Service; provide
980-90-00535ShipAlt DDG51-87402K, SSEE INC F AS4293A UPG, Alteration Installation Team (AIT) Support Service; provide
980-90-00635ShipAlt DDG51-88045K, CANES Mod 01, Alteration Installation Team (AIT) Support Service; provide
980-90-00830ShipAlt DDG51-00288K, Convert Bosin Storeroom No. 2 to Hazardous Materials Minimization Center; accomplish
982-31-00116Dock Trial, Fast Cruise, and Sea Trial; accomplish
991-12-00116Staging for Ship's Force Use; provide
992-10-00116Wharf and Pier Laydown Area; utilize and manage
992-11-00116Temporary Service at Contractor's Facility; provide
992-11-00316Temporary Refrigerated Storage Facility, provide
992-11-00416Temporary Air Conditioning; provide
992-11-00616Demineralized Water; provide
992-11-00716Temporary Flammable Liquid Storage and Hazardous Material Storage Unit; provide.
992-11-00816Temporary Services at Naval Station Everett; provide
992-31-00116Cleaning and Pumping; accomplish
993-11-00116Ship's Force Warehouse Storage Space; provide
993-31-00116Temporary Main Reduction Gear (MRG) Dehumidifier System; provide
993-31-00216AN/SPY-1D Antenna Protective Cover; install
993-31-00316Temporary Deck Covering; install
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0
$ - 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.

DDG102 Change Rate for Delay

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
DaysRate $($ * days)
Direct Production (See Section B Note A)30$0.00$0

Proposed Daily Change Rate Price $0

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 30 days of Government Caused Delay value is for evaluation only. Contractor's proposed rate on the worksheet will be incorporated into the contract and will be the fully burdened change rate for contract changes regardless of how many days are procured as detailed in Section B Note A.

File details come from the government source that posted it.