Bid Pricing.AWOS Upgrade.xlsx

This is a bid pricing inventory spreadsheet for the Michigan Department of Transportation's Request for Proposal #230000002566 regarding AWOS (Automated Weather Observation System) upgrades. The document provides a comprehensive equipment inventory as of February 11, 2023, for forty-one AWOS sites located across Michigan, plus one bench unit for shop installation. The proposal requires bidders to complete pricing for system upgrades involving multiple equipment components including barometers, ceilometers, modems, display sensors, tipping bucket sensors, wind transmitters, and platform sensors across all listed sites. Each site is documented with its installation year, current equipment specifications, and available optional sensor upgrades, with particular attention to equipment that may be repurposed from existing systems.

The bid pricing template indicates that all pricing fields are to be completed by bidders, with a total salvage credit of $0 noted across all sites. The document specifies that certain equipment components may be considered for repurposing, including Vaisala WMT702, Vaisala PTB330, and Vaisala CL31 sensors, while other components such as the FD12P are present at all sites but not available for repurposing. The spreadsheet includes line items for new AWOS IIIP system installation with OEM parts only, non-Federal AWOS verification training by manufacturer, and related site infrastructure requirements. All sites currently maintain tilt-over towers unless otherwise noted in the inventory, and bidders must account for the existing equipment configurations at each location when preparing upgrade proposals.