Attachment 0002 - Pricing Workbook.xlsx

XLSX spreadsheet 33 KB Posted

Attached to
Ship-To-Shore Container Cranes
Solicitation number
W56HZV-20-R-0025
Issued by

About this file

This document contains a pricing workbook attachment and details of a federal contract opportunity for ship-to-shore container cranes. The pricing workbook attachment provides instructions and templates for offerors to propose pricing for the design, fabrication, transportation, erection and acceptance, training, and essential spare parts for two ship-to-shore container cranes to be delivered to the Military Ocean Terminal Concord in California. The federal contract opportunity is solicitation number W56HZV-20-R-0025 from the U.S. Army Contracting Command - Detroit Arsenal seeking proposals for two ship-to-shore container cranes capable of lifting a variety of container sizes and servicing Panamax vessels with 13 containers abeam, to be delivered within 36 months of award of a single-award firm fixed price contract.

View the file

Other files

File Type Posted
Attachment 0002 - Pricing Workbook (revised 06 JUN 2021).xlsx XLSX spreadsheet
W56HZV-20-R-0025 0006.pdf PDF
Attachment 0001 - STS Crane Specification (revised 26 MAY 2021).DOCX DOCX document
MOTCO STS Container Crane QA Log 5-26-21.pdf PDF
W56HZV-20-R-0025 0005.pdf PDF
W56HZV-20-R-0025 0004.pdf PDF
MOTCO STS Container Crane QA Log 5-14-21.pdf PDF
Attachment 0013 Site Visit Information (revised 29 APR 2021).docx DOCX document
W56HZV-20-R-0025 0004.pdf PDF
MOTCO STS Container Crane QA Log 4-29-21.xlsx XLSX spreadsheet
Attachment 0001 - STS Crane Specification (revised 26 APR 2021).DOCX DOCX document
MOTCO Crane Site Visit Sign-in Sheet (beta.sam).pdf PDF
W56HZV-20-R-0025 0003.pdf PDF
Attachment 0013 Site Visit Information (revised 26 APR 2021).docx DOCX document
Attachment 0016 - Structural Drawings.pdf PDF
Attachment 0011 - Appendix E (Revised 09 APR 2021).pdf PDF
W56HZV-20-R-0025 0002.pdf PDF
Attachment 0001 - STS Crane Specification (revised 09 APR 2021).DOCX DOCX document
MOTCO STS Container Crane QA Log 4-8-21.pdf PDF
MOTCO STS Container Crane QA Log 3-25-21.pdf PDF
Attachment 0013 - Site Visit Information (revised 23 MAR 2021).docx DOCX document
W56HZV-20-R-0025 0001.pdf PDF
MOTCO STS Container Crane QA Log 3-18-21.pdf PDF
MOTCO STS Container Crane QA Log 3-11-21.pdf PDF
MOTCO STS Container Crane QA Log 3-4-21.pdf PDF
Attachment 0013 - Site Visit Information.docx DOCX document
Attachment 0007 - Appendix A.pdf PDF
Attachment 0011 - Appendix E.pdf PDF
Attachment 0010 - Appendix D.pdf PDF
Attachment 0001 - STS Crane Specification.DOCX DOCX document
Attachment 0014 - NCIC CONSENT FORM.pdf PDF
Attachment 0008 - Appendix B.pdf PDF
Attachment 0005 - SBP Certification - Subcontractor.docx DOCX document
W56HZV20R0025.pdf PDF
Attachment 0006 - Use of Existing Government-Furnished Property.xlsx XLSX spreadsheet
Attachment 0015 - MOTCO SITE VISIT SPREADSHEET.xlsx XLSX spreadsheet
Attachment 0003 - SBP Workbook.xlsx XLSX spreadsheet
Attachment 0012 - Appendix F.pdf PDF
Attachment 0009 - Appendix C.pdf PDF
Attachment 0004 - SBP Workbook Instructions.docx DOCX document
Show all 40

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Instructions

W56HZV-20-R-0025 - Ship-to-Shore (STS) Container Cranes for Military Ocean Terminal Concord (MOTCO) at Concord, CA
Attachment 0002 - Pricing Workbook
Instructions
1)Cells that require inputs are highlighted in yellow.
2)All cells that are highlighted in yellow must be completed in Summary and CLIN tabs.
3)Do not adjust formulas or otherwise manipulate any of the other (non-yellow highlighted) cells.
4)The required inputs are used to calculate the Total Proposed Price on the "Summary" Worksheet
5)Do not make any changes or modifications to this attachment except for those cells highlighted in yellow
6)Do not add Worksheets to this Attachment

Summary

W56HZV-20-R-0025 - Ship-to-Shore (STS) Container Cranes for Military Ocean Terminal Concord (MOTCO) at Concord, CA
Attachment 0002 - Pricing Workbook
Summary
OFFEROR NAME:

FFP CLINs:

CLINItemContract TypeProposed Price
0001STS CRANE DESIGNFFP$0.00
0002FABRICATION OF TWO STS CRANESFFP$0.00
0003TRANSPORTATION OF TWO STS CRANESFFP$0.00
0004FIELD ERECTION AND ACCEPTANCEFFP$0.00
0005CRANE OPERATION AND MAINTENANCE TRAININGFFP$0.00
0006ESSENTIAL SPARE PARTSFFP$0.00
Total Proposed Price:$0.00

CLIN 0001

W56HZV-20-R-0025 - Ship-to-Shore (STS) Container Cranes for Military Ocean Terminal Concord (MOTCO) at Concord, CA
Attachment 0002 - Pricing Workbook
CLIN 0001 -STS CRANE DESIGN

Offeror Name: 0

CLINDesign Phases per Section C.2.3.2Contract TypeTotal Estimate Phase Cost
Phase 1 - Preliminary Design (C.2.3.2.1)
Phase 2 - 90% Design Submittal (C.2.3.2.2)
Phase 3 - Final 100% Design Submittal (C.2.3.2.3)
0001Total STS Crane DesignFFP$0.00

CLIN 0002

W56HZV-20-R-0025 - Ship-to-Shore (STS) Container Cranes for Military Ocean Terminal Concord (MOTCO) at Concord, CA
Attachment 0002 - Pricing Workbook
CLIN 0002 -FABRICATION OF TWO STS CRANES

Offeror Name: 0

CLINItemContract TypeProposed Price
0002Fabrication of Two (2) STS CranesFFP

CLIN 0003

W56HZV-20-R-0025 - Ship-to-Shore (STS) Container Cranes for Military Ocean Terminal Concord (MOTCO) at Concord, CA
Attachment 0002 - Pricing Workbook
CLIN 0003 -TRANSPORTATION OF TWO STS CRANES

Offeror Name: 0

CLINItemContract TypeProposed Price
0003Transportation for Two (2) STS CranesFFP

CLIN 0004

W56HZV-20-R-0025 - Ship-to-Shore (STS) Container Cranes for Military Ocean Terminal Concord (MOTCO) at Concord, CA
Attachment 0002 - Pricing Workbook
CLIN 0004 -FIELD ERECTION AND ACCEPTANCE

Offeror Name: 0

CLINItemContract TypeProposed Price
0004Field Erection and Acceptance of Two (2) Cranes at MOTCOFFP

CLIN 0005

W56HZV-20-R-0025 - Ship-to-Shore (STS) Container Cranes for Military Ocean Terminal Concord (MOTCO) at Concord, CA
Attachment 0002 - Pricing Workbook
CLIN 0005 -CRANE OPERATION AND MAINTENANCE TRAINING

Offeror Name: 0

CLIN Item Requirement per Attachment 0001 - Specification File

Section 3.7Contract TypeProposed Price
Operator TrainingTwo (2) 8-hour Training Sessions for total of 16 hours required
Maintenance Training - Structural16 hours of training required
Maintenance Training - Mechanical40 hours of training required
Maintenance Training - Electrical80 hours of training required
Crane Drive Training80 hours of training required
Manuals and DrawingsQty to support training of 10 people
0005TOTAL CRANE OPERATION and MAINTENANCE TRAININGFFP$0.00

CLIN 0006

W56HZV-20-R-0025 - Ship-to-Shore (STS) Container Cranes for Military Ocean Terminal Concord (MOTCO) at Concord, CA
Attachment 0002 - Pricing Workbook
CLIN 0006 -ESSENTIAL SPARE PARTS

Offeror Name: 0

SPARE PARTS LIST

Spare Parts DescriptionQtyProposed
Unit PriceProposed

Extended Price

Crane Application Software2$0.00
Main PLC System Protector Circuit Breaker4$0.00
Encoders ‐
Main Hoist2$0.00
Trolley2$0.00
Boom2$0.00
Gantry2$0.00
Encorder cable2$0.00
Communication Card2$0.00
Ethernet Cable2$0.00
Ethernet Connector2$0.00
Ethernet Switch2$0.00
Ethernet Interface2$0.00
fiber optic transmitter /receiver2$0.00
PC Processor Panel (Operator Cab)2$0.00
Total Encoders24$0.00
Motors
Trolley Motor2$0.00
Hoist Motor2$0.00
Gantry Motor2$0.00
Brake Caliper2$0.00
Total Motors8$0.00
Gantry brake assemblies and limit switches4$0.00
480 volt load center breakers2$0.00
Circuit Breakers [240VAC]‐ of all Types used
Single Pole4$0.00
Two Pole4$0.00
Three Pole4$0.00
Four Pole4$0.00
Total Circuit Breakers16$0.00
Switches & Pilot Devices‐ of all Types used4$0.00
Push Buttons4$0.00
flood light bulbs6$0.00
Pilot Lights4$0.00
e‐stop switch assemblies2$0.00
General Purpose relays‐ all Types used4$0.00
aircraft warning light assemblies1$0.00
gantry flashing light beacon module and bulb2$0.00
UPS 120V‐2000A2$0.00
RFI Power Line2$0.00
Filter2$0.00
Resisters4$0.00
Compact Module3$0.00
Power Supply Modules2$0.00
Fuses‐all Types used10$0.00
Sensors‐ all types used10$0.00
Position Switch2$0.00
Magnetic Switch2$0.00
Load Cells4$0.00
Operator Joy Stick assembly for hoist, gantry, trolley2$0.00
Hydraulic cylinder repair seal kits for:
spreader twistlocks4$0.00
spreader cylinders4$0.00
flippers4$0.00
Total Hydraulic Cylinder Repair Seal Kits12$0.00
Spreaders
Twist locks, locking arms, bushings, travel brackets2$0.00
Locking cylinder2$0.00
Hydraulic motor and pump assembly1$0.00
Lock, unlock flipper solenoids2$0.00
Total Spreaders7$0.00
Hydraulic pressure gauges for spreader, brakes, TLS.2$0.00
Cable reel limit switches, rollers, motor, 4160 volt slip ring parts1$0.00
Rail brake limit switches, brake shoes, pressure switch and solenoid4$0.00
Elevator main contactor, aux contactors, peanut brake pads and button2$0.00
Bologna cable pin connector assembly1$0.00
Festoon cable roller wheels and side wheels10$0.00
Boom hook solenoid, cylinder and relief valve2$0.00
Anemometer assembly2$0.00

CLIN 0006 - Total Extended Price for Essential Spare Parts: $0.00

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