Section L - Attachment L-4 - Preliminary Weight Estimate A00002.xlsx

76 KB Posted

Attached to
US Coast Guard Waterways Commerce Cutter Program
Solicitation number
70Z02321RPRT00300
Issued by

About this file

Written by GovTribe AI ·

This document contains a solicitation for the design and construction of Waterways Commerce Cutters for the U.S. Coast Guard. The Coast Guard is seeking to award an Indefinite Delivery Indefinite Quantity contract to a small business for the production of up to twenty-seven cutters to replace aging inland waterway vessels. Proposals are due by July 30, 2021, with award planned for one contractor. The cutters will perform missions like construction and maintenance of aids to navigation, repositioning of buoys, and positioning of floating aids. The solicitation includes line items for long lead materials, spares, training, and support. Access to technical data is restricted and requires registration under the U.S.-Canada Joint Certification Program. Questions are due by June 1, 2021. The Department of Homeland Security's Coast Guard is the contracting agency.

View the file

Other files

File Type Posted
Section L - Instructions to Offerors_A00004.docx DOCX document
70Z02321RPRT00300_A00004_KO_Signed.pdf PDF
J-2 - Design and Readiness Review Requirements and Criteria_v2.0_A00003.pdf PDF
Section L - Instructions to Offerors_A00003.docx DOCX document
WCC_RFP_Change_Log_A00003.docx DOCX document
70Z02321RPRT00300_A00003_KO_Signed1.pdf PDF
Attachment J-4 - CDRL_v2.0_A00003.pdf PDF
Section F Deliveries or Performance_WCC_A00003.docx DOCX document
Section C - WCC SOW_v3.0_A00003.pdf PDF
WCC_RFP_Industry_Responses_A00003.docx DOCX document
J-1I - GFI List_v2.0 _A00003.pdf PDF
70Z02321RPRT00300_A00002 KO signed.pdf PDF
Attachment J-1F - WCC PPD-070-1 - ABS Classification Guide A00002.pdf PDF
Attachment J-1E - FL_2602_11_1_-_1 Spud Arrangements A00002.pdf PDF
Attachment J-12 - Records Management Requirements A00002.pdf PDF
Section L Attachment L-2 Price Worksheets A00002.xlsx XLSX spreadsheet
Attachment J-1 - WCC System Specification A00002.pdf PDF
Attachment J-9 Tech Data and Computer Software Data Rights_v2.0 [A00002].pdf PDF
Attachment J-1J - Outfitting List_v2.0 [A00002].xlsx XLSX spreadsheet
WCC_RFP_Change_Log_Amendment_00002.docx DOCX document
WCC_RFP_Industry_Responses_Amendment_00002.docx DOCX document
Attachment J-1C - WCC-SK-580-002_A_ConstDeck A00002.pdf PDF
Attachment J-1B - WCC-SK-580-001-A-BuoyDeck A00002.pdf PDF
Attachment J-1G - WCC PPD-512-001 - HVAC DCM A00002.pdf PDF
Section L - Instructions to Offerors A00002.docx DOCX document
Section B - Supplies or Services and Prices_WCC_UPDATED A00002.docx DOCX document
Section C - WCC SOW_v2.0 [A00002].pdf PDF
Section B - Supplies or Services and Prices A00002.pdf PDF
Attachment J-11 - Section 508 Requirements_v1.0 [A00002].pdf PDF
Attachment J-10 - EPA Tables A00002.xlsx XLSX spreadsheet
Section J - Attachment Index_v2.0 [A00002].pdf PDF
70Z02321RPRT00300_A00001 KO signed.pdf PDF
70Z02321RPRT00300_A00001 KO signed.pdf PDF
WCC_RFP_Change_Log_Amendment_001_.docx DOCX document
WCC_RFP_Industry_Responses_Amendment_001_.docx DOCX document
Amendment A00001_Section L - Instructions to Offerors.docx DOCX document
Response to Q65 - Picture of Crane w Hammer and Lead.pdf PDF
Response to Q60 - Sketch of Bow Shapes.pdf PDF
WCC_RFP_Change_Log_22 Jun 2021.docx DOCX document
WCC_RFP_Industry_Responses_22 Jun 2021.docx DOCX document
Question Form.xlsx XLSX spreadsheet
Section B - Supplies or Services and Prices_WCC_UPDATED 051221.docx DOCX document
Section F - Deliveries or Performance_WCC 043021.docx DOCX document
Section G - Contract Administration_WCC 043021.docx DOCX document
Section D - Packaging and Marking_WCC 043021.docx DOCX document
Section K - Representations and Certifications_WCC 043021.docx DOCX document
Section L - Attachment L-2 - Price Worksheets 043021.xlsx XLSX spreadsheet
Section L - Attachment L-1 - Major Equipment List Template.xlsx XLSX spreadsheet
Section L - Attachment L-3 - Design Placemat Template.xlsx XLSX spreadsheet
Solicitation Cover Page - Sections A and B.pdf PDF
Show 40 more

Latest 50 of 62 listed here. See the rest on GovTribe.

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.

COVER

USCG Waterways Commerce Cutter
Design and Construction

Preliminary Allocated Baseline Weight Estimate

Attachment L-X
Prepared By

United States Coast Guard

70Z02321RPRT00300

&"Times New Roman,Regular"Preliminary Allocated Baseline Weight Estimate Template

&"Times New Roman,Regular"DISTRIBUTION STATEMENT A - Approved for public release; distribution is unlimited. &"Times New Roman,Regular"Page 1

Instructions-Changes

[INSERT BIDDER NAME HERE]
DEFINITIONSOn sheet "3 - Three Digit Details", E/C/V refers to whether the data is Estimate, Calculated, or Vendor Provided.
INSTRUCTIONSOn sheet "1 - Weights and Loading", the margins included in the calculation are the minimums required by Section 096 of the System Specification (J-1) and should be adjusted if necessary to properly represent the offer.

By default, sheet "1 - Weights & Loading" will automatically include the 1-digit summaries from the "2 - Three Digit Summary" sheet.

By default, sheet "2 - Three Digit Summary" does not include any automatic inclusion of items on "3 - Three Digit Details".

CHANGESSpreadsheet is provided in unlocked format as the information provided by any bidder may not perfectly dovetail into the format provided. Maintain the format of the spreadsheet as close as possible to the original configuration. Document any changes on this sheet below by stating the original sheet number, cell(s) changed, and brief description of the change.
SheetCell(s)Description of Change
USCG1C22Updated automatic calculation of CM margin from 2% to 1% in accordance with the WCC System Specification (Attachment J-1), section 096. (OLD: =(C17+C19)*0.02 NEW:=(C17+C19)*0.01)

1 - Weights & Loading

[INSERT BIDDER NAME HERE]

WEIGHTS & CENTERS

SWBSDescriptionWeightVCGLCGTCG
(LT)(ft abv BL)(ft aft FP)(ft off CL)
1HULL STRUCTURE0ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
2PROPULSION0ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3ELECTRICAL PLANT0ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
4COMMAND AND SURVEILLANCE0ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
5AUXILIARY SYSTEM0ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
6OUTFIT & FURNISHINGS0ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
7ARMAMENT0ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

F FULL LOADS (DEPARTURE CONDITION) 0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

LIGHTSHIP DISPLACEMENT (DELIVERY - NO DESIGN MARGINS) 0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

D&C MARGINS: WEIGHT0
D&C MARGINS: VCGERROR:#DIV/0!
CON MOD MARGINS: WEIGHT0
CON MOD MARGINS: VCGERROR:#DIV/0!
GFM MARGINS: WEIGHT0
GFM MARGINS: VCGERROR:#DIV/0!

LIGHTSHIP DISPLACEMENT (DELIVERY W/ MARGINS) 0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

SL ALLOWANCE: WEIGHT0
SL ALLOWANCE: VCGERROR:#DIV/0!

LIGHTSHIP DISPLACEMENT (EOSL W/ DESIGN MARGINS) 0 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!

LOADS AND LOADING CONDITIONS
FFULL LOADS (DEPARTURE CONDITION)0ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
FULL LOAD DISPLACEMENT (DELIVERY, W/ DESIGN MARGINS)0ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
FULL LOAD DISPLACEMENT (EOSL, W/ DESIGN MARGINS)0ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
MMIN OP LOADS (ARRIVAL CONDITION)0ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
MIN OP DISPLACEMENT (DELIVERY, W/ DESIGN MARGINS)0ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
MIN OP DISPLACEMENT (EOSL, W/ DESIGN MARGINS)0ERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!

2 - Three Digit Summary

[INSERT BIDDER NAME HERE]

WEIGHTS & CENTERS
VerticalLongitudinalTransverse
SWBSDescriptionWeightVCGMomentLCGMomentTCGMomentNotes: General
(LT)(ft abv BL)(ft-LT)(ft aft FP)(ft-LT)(ft off CL)(ft-LT)
111Shell Plating
113Inner Bottom
114Shell Appendages
115Stanchions
116Longitudinal Framing
117Transverse Framing
121Longitudinal Bulkheads
122Transverse Bulkheads
123Trunks and Enclosures
131Main Deck
132Second Deck
13601 Hull Deck
151Deckhouse to First Level
1521st Deckhouse Level
1532nd Deckhouse Level
161Structural Castings
162Stacks and Macks
163Sea Chests
164Ballistic Plating
165Sonar Domes
166Sponsons
167Hull Structural Closures
168Deckhouse Structural Closures
169Special Purpose Structures
171Masts, Towers, Tetrapods
172Kingposts and Supp. Frms.
181Hull Structural Fdns.
182Propulsion Fdns.
183Electrical Plant Fdns.
184Comm. & Surv. Fdns.
185Auxiliary Sys. Fdns.
186Outfit & Furn. Fdns.
187Armament Fdns.
197Welding & Mill Tolerance
198Free Flooding Liquids
199Hull Repair Parts & Tools
1Hull Structure0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00
221Propulsion Boilers
231Steam Turbines
233Internal Comb. Engines
234Gas Turbines
235Electric Propulsion
237Auxiliary Propulsion
241Reduction Gears
242Clutches and Couplings
243Propulsion Shafting
244Shaft Bearings
245Propulsors
251Combustion Air Sys.
252Prop. Control Sys.
253Main Steam Piping
254Condensers
255Feed & Condensate Sys.
256Circ. & Cooling Water
258HP Steam Drain Sys.
259Uptakes
261Fuel Service System
262Main Prop. Lube Oil Sys.
264Lube Oil Fill & Xfer.
298Prop. Operating Fluids
299Prop. Repair Parts
2Propulsion Plant0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00
311S. S. Power Generation
312Emergency Generators
313Batteries & Service Facil.
314Power Conversion Equipment
321Ship Service Power Cable
322Emergency Power Cable
323Casualty Power Cable
324Switchgear and Panels
331Lighting Distribution
332Lighting Fixtures
341SSTG Lube Oil
342Diesel Support Systems
343Turbine Support Systems
398Electric Plant Op. Fluids
399Electric Plant Repair Parts
3Electric Plant0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00
411Data Display Group
412Data Processing Group
413Digital Data Swbds.
414Interface Equipment
415Digital Data Comm.
417Analog Switchboards
421Non-Elect. Nav. Aids
422Electrical Nav. Aids
423Nav. Sys., Radio
424Nav. Sys., Acoustical
426Electrical Nav. Sys.
427Inertial Nav. Sys.
428Nav. Cntl. Monitoring
431Swbds. For IC Sys.
432Telephone Systems
433Announcing Systems
434Entertainment Sys.
435Voice Tubes
436Alarm & Warning Sys.
437Indic. Order & Meter
438Integrated Control Sys.
439Recording & TV Sys.
441Radio Systems
442Underwater Systems
443Visual & Audible Sys.
444Telemetry Systems
445TTY & Facsimile Sys.
446Security Equipment
451Surface Search Radar
452Air Search Radar (2D)
453Air Search Radar (3D)
454Aircraft Control Radar
455Identification Systems
456Multiple Mode Radar
457IR/EO Surveill. & Tracking Sys.
461Active Sonar
462Passive Sonar
463Multiple Mode Sonar
464Classification Sonar
465Bathythermograph
471Active ECM
472Passive ECM
473Torpedo Decoys
474Decoys
475Degaussing
476Mine Countermeasures
481Gun Fire Control Sys.
482Missile Fire Control
483Underwater Fire Control
484Integrated Fire Control
491Elex. Test & Monit. Eqpt.
492Flight Cntl & Inst. Lndg.
493Non Combat Data Processing
494Meteorological Systems
495Special Purpose Intel. Sys.
498Command & Cntl. Op. Fluids
499Command & Cntl. Repai Parts
4Command and Surveillance0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00
511Compartment Heating Sys.
512Ventilation System
513Machinery Space Vent.
514Air Conditioning Sys.
516Refrigeration System
517Auxiliary Boilers
521Firemain & Flushing
522Sprinkler System
523Washdown System
524Auxiliary Seawater Sys.
526Scuppers & Deck Drains
527Firemain Actuated Sys.
528Plumbing Drainage
529Drainage & Ballasting
531Distilling Plant
532Cooling Water
533Potable Water
534Steam Drns. In Machy. Box
535Steam Drns. Out Machy. Box
536Aux. Fresh Water Cooling
541Ship Fuel System
542Aviation Fuels
543Aviation Lube Oil
544Liquid Cargo
545Tank Heating
549Special Fuel & Lube Handling
551Compressed Air Systems
552Compressed Gases
553O2 N2 Systems
555Fire Extinguishing Sys.
556Hydraulic Fluid Systems
558Special Piping Systems
561Steering & Diving Cntl.
562Rudder
565Trim & Heel Systems
568Maneuvering Systems
571Replenishment at Sea Sys.
572Ship Stores Handling Eqpt.
573Cargo Handling Systems
575Vertical Handling Sys.
581Anchor Handling Sys.
582Mooring & Towing Sys.
583Boats & Boat Handling Sys.
584Landing Craft Handling Sys.
585Elevating & Retracting Gr.
586Aircraft Recovery Systems
587Aircraft Launch Systems
588Aircraft Handling Systems
589Misc. Mech. Handling Sys.
591Scientific & Ocean Systems
592Swimmer & Diver Support
593Pollution Control Systems
594Submarine Rescue Systems
595Underwater Vehicle Handling
596Diver Handling Systems
597Salvage Support Systems
598Aux Sys. Operating Fluids
599Aux Sys. Repair Parts
5Auxiliary System0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00
611Hull Fittings
612Rails, Stan. & Lifelines
613Rigging & Canvas
621Non-Structural Bulkheads
622Fllor Plates & Gratings
623Ladders
624Non-Structural Closures
625Airports & Windows
631Painting
632Zinc Coating
633Cathodic Protection
634Deck Covering
635Hull Insulation
636Hull Damping
637Sheathing
638Refrigerated Spaces
639Radiation Shielding
641Officer Berthing
642Noncomm Officer Berthing
643Enlisted Berthing
644Sanitary Spaces
645Leisure & Comm. Spaces
651Commissary Spaces
652Medical Spaces
653Dental Spaces
654Utility Spaces
655Laundry Spaces
656Trash Disposal Spaces
661Offices
662Machy. Cntl. Ctr. Furn.
663Elex. Cntl. Ctr. Furn.
664Damage Control Stations
665Workshops & Labs
671Lockers & Special Stow.
672Storerooms & Issue Rooms
673Cargo Stowage
698Outfit & Furn. Op. Fluids
699Outfit & Furn. Rep. Parts
6Outfit & Furnishings0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00
711Guns
712Ammunition Handling
713Ammunition Stowage
721Missile Launchers
722Missile Handling
723Missile Stowage
724Missile Hydraulics
725Missile Gas
726Missile Compensating
727Missile Launcher Control
728Missile Temperature Control
729Missile Monitoring
731Mine Launching Devices
732Mine Handling
733Mine Stowage
741Depth Charge Launchers
742Depth Charge Handling
743Depth Charge Stowage
751Torpedo Tubes
752Torpedo Handling
753Torpedo Stowage
761Small Arms & Pyrotechnics
762Small Arms & Pyro. Hndlg.
763Small Arms & Pyro. Stow.
772Cargo Munitions Handling
773Cargo Munitions Stowage
782Aircraft Weapons Handling
783Aircraft Weapons Stowage
792Special Weapons Handling
793Special Weapons Stowage
797Misc. Ordnance Spaces
798Armament Operating Fluids
799Armament Repair Parts
7Armament0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00
F11Ship's Officers
F12Ship's Noncomm Off.
F13Ship's Enlisted Men
F14Marines
F15Troops
F16Air Wing Personnel
F19Other Personnel
F21Ship Ammunition
F22Ord. Del. Sys. Ammo
F23Ordnance Delivery Sys.
F24Ordnance Repair Parts
F25Repair Parts Ord. Del. Sys.
F26Ord. Del. Sys. Support Eqpt.
F29Special mission Sys.
F31Provisions & Pers. Stores
F32General Stores
F33Marine's Stores
F39Special Stores
F41Diesel Fuel
F42JP-5
F43Gasoline
F44Distillate Fuel
F45N.S.F.O.
F46Lubricating Oil
F49Special Fuels & Lubes
F51Sea Water
F52Fresh Water
F53Reserve Feed Water
F54Hydraulic Fluid
F55Sanitary Tank Liquid
F56Gas
F59Miscellaneous Liquids
F61Cargo Ordnance
F62Cargo Stores
F63Cargo Fuels & Lubes
F64Cargo Liquids
F65Cargo, Liquid Gases
F66Cargo, Amphib. Assault Sys.
F67Cargo Gases
F69Miscellaneous Cargo
FFull Load0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00
A11Ship's Officers
A12Ship's Noncomm Off.
A13Ship's Enlisted Men
A14Marines
A15Troops
A16Air Wing Personnel
A19Other Personnel
A21Ship Ammunition
A22Ord. Del. Sys. Ammo
A23Ordnance Delivery Sys.
A24Ordnance Repair Parts
A25Repair Parts Ord. Del. Sys.
A26Ord. Del. Sys. Support Eqpt.
A29Special mission Sys.
A31Provisions & Pers. Stores
A32General Stores
A33Marine's Stores
A39Special Stores
A41Diesel Fuel
A42JP-5
A43Gasoline
A44Distillate Fuel
A45N.S.F.O.
A46Lubricating Oil
A49Special Fuels & Lubes
A51Sea Water
A52Fresh Water
A53Reserve Feed Water
A54Hydraulic Fluid
A55Sanitary Tank Liquid
A56Gas
A59Miscellaneous Liquids
A61Cargo Ordnance
A62Cargo Stores
A63Cargo Fuels & Lubes
A64Cargo Liquids
A65Cargo, Liquid Gases
A66Cargo, Amphib. Assault Sys.
A67Cargo Gases
A69Miscellaneous Cargo
AMin Op Loads0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00ERROR:#DIV/0!0.00

3 - Three Digit Details

[INSERT BIDDER NAME HERE]

WEIGHTS & CENTERS
VerticalLongitudinalTransverse
SWBSESWBSDescriptionWeightE/C/VVCGMomentLCGMomentTCGMomentRemarks / Rationale
(LT)(ft abv BL)(ft-LT)(ft aft FP)(ft-LT)(ft off CL)(ft-LT)

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