Att 1. On-Site Equipment Inventory.xlsx

XLSX spreadsheet 48 KB Posted

Attached to
Michigan AWOS Weather Station Upgrade Project 2023
Solicitation number
RFP 591 230000002566 3
Issued by
Michigan

About this file

This is an on-site equipment inventory spreadsheet for Automated Weather Observation System (AWOS) sites operated by the State of Michigan Department of Transportation (MDOT). The document provides a comprehensive inventory of equipment installed at 41 AWOS locations across Michigan airports as of February 11, 2023, detailing the installation and upgrade years, specific sensor and equipment configurations (barometers, ceilometers, modems, displays, temperature sensors, tipping bucket sensors, wind sensors, and transmitters), and platform types. The inventory includes an associated upgrade and replacement schedule with projected completion dates ranging from 2014 through 2031, identifying equipment that requires modernization based on useful life expectations and current operational needs.

The upgrade list provides detailed cost estimates for replacing or upgrading equipment at each site, with total phased upgrade costs by MDOT calculated at $2,238,580, total Vaisala replacement costs by MDOT at $4,430,600, total Vaisala replacement costs by contract at $4,840,200, and total All Weather INC replacement costs by contract at $6,291,000. Component-level pricing is provided for individual equipment items, with labor costs estimated at hourly rates and travel costs set at $250 per person per day. Funding is designated as state/local sources for completed and planned upgrades. The document notes that all sites currently have FD12P equipment and tilt-over towers unless otherwise noted, with salvage value credit of $0 specified for all locations and special site considerations such as non-standard layouts, tower leans, remote wind sensors, and snow platforms documented for individual locations.

View the file

Other files

File Type Posted
RFP.AERO.AWOS Upgrade.docx DOCX document
Att 2. AWOS Task Force Recommendations.docx DOCX document
Bid Pricing.AWOS Upgrade.xlsx XLSX spreadsheet
Michigan Automated Weather Observation System.Q.A..pdf PDF

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

Inventory

Inventory of AWOS Site Equipmentas of:2/11/23
Year InstallCellTempTippingWindVC/VDUpgrade
/ upgradeBarometerCeilometerModemDisplaySensorBucketSensorXmtrPriority
Alma1995/2011PTB330CL31AYesWthr NexHMP 45AWS425Park Air4
Bad Axe1996/2010PTB330CL31AWthr NexHMP 155WS425Val 7604
Beaver Island2001blueCT25KWthr NexHMP 45AmechanicalVal 7601a
Bellaire1995/2010PTB330CL31AWthr NexHMP 45AWS425Park Air4
Big Rapids1997/2010PTB330CL31AWthr NexHMP 45ATR-525I-HTWS425Park Air4
Cadillac2000PTB330CL31AWthr NexHMP 155mechanicalAWOS20001b
Caro2004PTB220CT25KWthr NexHMP 155mechanicalVal 7602
Charlevoix2001blueCT25KWthr NexHMP155mechanicalPark Air1a
Charlotte2001blueCL31AWthr NexHMP 45ATR-525I-HTmechanicalVal 7601a
Cheboygan2001blueCT25KWthr NexHMP 45AmechanicalVal 7601a
Coldwater1996/2011PTB330CL31AWthr NexHMP 45AWMT702Park Air4
Drummond Island2005PTB220CT25KWthr NexHMP 45DTR525HTmechanicalVal 7602
Frankfort2004PTB220CT25KWthr NexHMP 45AmechanicalVal 7602
Fremont2007PTB220CL31YesWthr NexHMP155WS425AWOS20003
Grosse Ile1995/2016PTB330CL31AWthr NexHMP 155TR-525I-HTWMT702AWOS2000Split4
Harbor Springs2001blueCT25KWthr NexHMP 155mechanicalVal 7601a
Hillsdale1997/2016PTB330CL31AWthr NexHMP 155TR-525I-HTWS425AWOS20004
Howell2005PTB220CL31AWthr NexHMP 45DTR-525I-HTmechanicalVal 7602
Ionia2009PTB330CL31Wthr NexHMP 45ATR-525I-HTWS425, remoteVal 7603
Lambertville2001blueCT25KWthr NexHMP 45AmechanicalVal 7601a
Lapeer2012PTB330CL31AWthr NexHMP 45ATR-525I-HTWS425Val 7604
Ludington1999PTB330CL31AWthr NexHMP 155TR-525I-HTmechanicalAWOS20001b
Mackinac Island1990/2010PTB330CL31AWthr NexHMP 45ATI-525-HTWS425, remotePark Air4
Manistique1997/2013PTB330CL31AWthr NexHMP 155TR-525I-HTWMT702AWOS20004
Marquette2000PTB330CL31ATstormAv/Av/WnHMP 45ATR-525I-HTmechanicalAWOS2000ACU/UHF1b
Marshall1996/2013PTB330CL31AWthr NexHMP 155TR-525I-HTWMT702Park Air4
Mason1995/2010PTB330CL31AWthr NexHMP155WS425Val 7604
Midland2008PTB220CL31Wthr NexHMP 45ATR-525I-HTWS425AWOS20003
Monroe1995/2015PTB330CL31AYesWthr NexHMP 155TR-525I-HTWS425AWOS2000Split4
Mt Pleasant1999blueCT25KWthr NexHMP 45ATR-525-HTmechanicalAWOS20001a
Newberry1996/2013PTB330CL31AWthr NexHMP 155TR-525I-HTWS425AWOS20004
Oscoda1994/2011PTB330CL31AWthr NexHMP 45ATR-525I-HTWMT702Val 760Split4
Owosso2004PTB220CT25KWthr NexHMP 45AmechanicalVal 7602
Port Huron2001blueCL31AWthr NexHMP 45AmechanicalPark Air1a
Rogers City2004PTB220CL31AWthr NexHMP 45AmechanicalVal 7602
Saginaw2000blueCT25KWthr NexHMP 45AmechanicalPark Air1a
South Haven2004PTB220CT25KWthr NexHMP155mechanicalVal 7602
Sturgis1995/2015PTB330CL31AWthr NexHMP 155TR-525I-HTWMT702AWOS20004
Three Rivers2005PTB220CT25KWthr NexHMP 45AmechanicalVal 7602
Troy2004PTB220CT25KWthr NexHMP 155mech, remoteVal 7602
West Branch2016PTB330CL31AWthr NexHMP 155TR-525I-HTultrasonicAWOS20004
File at: Etronics/AWOS/On-Site Equipment Inventory.xlsx1a-9
1b3
* all sites have FD12P currently29
33
417
total41

ReplaceUpgrade

AWOS Replacement Items & Schedule
ProjectedCompletionFunding
Upgrade NeedsYearDateMeans
AlmaPark Air
Bad Axenone------------------------
Beaver IslandCT25K
BellairePark Air
Big RapidsPark Air
CadillacCT25K & Park Air2018state/local
CaroCT25K
CharlevoixCT25K & Park Air
CharlotteCT25K20174/18/17state/local
CheboyganCT25K2018state/local
ColdwaterPark Air
Drummond IslandCT25K
FrankfortCT25K
Fremontnone------------------------
GraylingCT25K
Grosse IleVB system20166/28/16state/local
Harbor SpringsCT25K2017state/local
HillsdaleVB system20167/28/16state/local
HowellCT25K201610/4/16state/local
Ionianone------------------------
LambertvilleCT25K
Lapeernone------------------------
LudingtonCT25K & Park Air20167/28/16state/local
Mackinac IslandPark Air
Manistiquenone------------------------
MarquetteCT25K & Park Air2017state/local
MarshallPark Air
Masonnone------------------------
Midlandnone------------------------
Monroenone------------------------
Mt PleasantCT25K2018state/local
Newberrynone------------------------
Oscodanone------------------------
OwossoCT25K
Port HuronPark Air
Rogers CityCT25K20168/17/16state/local
SaginawCT25K & Park Air
South HavenCT25K
Sturgisnone------------------------
Three RiversCT25K
TroyCT25K
West Branchnone------------------------
CT25K = ceilometer
Park Air = VHF transmitter
File at:Etronics/AWOS/On-Site Equipment Inventory.xlsx

Upgrade List as of: 8/17/21

AIRPORTIDOriginal Install/UpgradeMake/ModelEnd of Useful LifeSensor/ Peripheral NeedsUpgrade CostUpgrade Labor CostTravel CostsAncillary CostTOTAL UPGRADEReplace Cost - Vaisala by MDOTReplace Cost - Vaisala contractReplace Cost - All Weather INCNotesRecommend Upgrade/Replacement
Mackinac IslandMCD1990 / 2010VB / VC2025T/DP, radio, UPS, ultra winds, Viz34,200.003,190.002,000.00210041,490.0094,400104,400151,000remote winds, snow plat
OscodaOCS1994 / 2011VB Split / VD2026T/DP, radio, UPS, Viz, Tip Bkt29,700.002,300.001,500.00210035,600.0095,000105,000151,000split/UHF
AlmaAMN1995 / 2011VB / VC2026T/DP, radio, UPS, ultra winds, Viz, Tip Bkt35,400.003,520.00500.00210041,520.0094,400104,400151,000
BellaireACB1995 / 2010VB / VC2025T/DP, radio, UPS, ultra winds, Viz, Tip Bkt35,400.003,520.001,500.00210042,520.0094,400104,400151,000
Grosse IleONZ1995 / 2016VB Split / VD2031UPS, Viz21,500.001,430.001,000.00210026,030.0095,000105,000151,000split/UHF
MasonTEW1995 / 2010VB / VC2026radio, UPS, ultra winds, Viz, Tip Bkt32,900.003,190.00500.00210038,690.0094,400104,000151,000
MonroeTTF1995 / 2015VB / VD2030ultra winds, UPS, Viz28,500.002,530.001,000.00210034,130.0095,000105,000151,000split/UHF, site leans
SturgisIRS1995 / 2015VB / VC2030UPS, Viz21,500.001,430.001,000.00210026,030.0091,600101,600151,000
Bad AxeBAX1996 / 2010VB / VC2025T/DP, radio, UPS, ultra winds, Viz, Tip Bkt35,400.003,520.001,500.00210042,520.0094,400104,400151,000
ColdwaterOEB1996 / 2011VB / VC2026T/DP, radio, UPS, Viz, Tip Bkt29,700.002,300.00500.00210034,600.0091,600101,600151,000
MarshallRMY1996 / 2013VB / VC2028radio, UPS, Viz24,700.001,760.00500.00210029,060.0091,600101,600151,000
NewberryERY1996 / 2013VB / VC2028ultra winds, UPS, Viz28,500.002,530.002,500.00210035,630.0094,400104,400151,000
Big RapidsRQB1997 / 2010VB / VC2026T/DP, radio, UPS, ultra winds, Viz34,200.003,190.001,000.00210040,490.0094,400104,400151,000twr leans, relocated in 2012
HillsdaleJYM1997 / 2016VB / VC2031ultra winds, UPS, Viz28,500.002,530.005,000.00210038,130.0094,400104,400151,000
ManistiqueISQ1997 / 2013VB / VC2028UPS, Viz21,500.001,430.002,500.00210027,530.0091,600101,600151,000
LudingtonLDM1999VC2014ultra winds, UPS, Viz28,500.002,530.001,500.00210034,630.0094,400104,400151,000
Mount PleasantMOP1999VC2014Baro, Ceilo, T/DP, ultra winds, UPS, Viz65,000.003,520.00500.00210071,120.00122,000132,000151,000
CadillacCAD2000VC2015ultra winds, UPS, Viz, Tip Bkt31,000.002,860.001,000.00210036,960.0094,400104,400151,000
MarquetteSAW2000VC2015T/DP, ultra winds, UPS, Viz31,000.002,860.003,000.00210038,960.00100,400110,400151,000ACU, UG and UHF, snow plat
SaginawHYX2000VC2015Baro, Ceilo, T/DP, radio, ultra winds, UPS, Viz, Tip Bkt70,700.004,180.001,000.00210077,980.00122,000132,000151,000
Beaver IslandSJX2001VC2016Baro, Ceilo, T/DP, radio, ultra winds, UPS, Viz, Tip Bkt70,700.004,180.002,500.00210079,480.00122,000132,000151,000
CharlevoixCVX2001VC2016Baro, Ceilo, radio, ultra winds, UPS, Viz, Tip Bkt68,200.003,850.002,000.00210076,150.00122,000132,000151,000
CharlotteFPK2001VC2016Baro, T/DP, radio, ultra winds, UPS, Viz38,200.003,520.00500.00210044,320.0094,400104,400151,000
CheboyganSLH2001VC2016Baro, Ceilo, T/DP, radio, ultra winds, UPS, Viz, Tip Bkt70,700.004,180.001,500.00210078,480.00122,000132,000151,000
Harbor SpringsMGN2001VC2016Baro, Ceilo, radio, ultra winds, UPS, Viz, Tip Bkt68,200.003,850.002,000.00210076,150.00122,000132,000151,000
LambertvilleDUH2001VC2016Baro, Ceilo, T/DP, radio, ultra winds, UPS, Viz, Tip Bkt70,700.004,180.001,000.00210077,980.00122,000132,000151,000
Port HuronPHN2001VC2016Baro, T/DP, radio, ultra winds, UPS, Viz, Tip Bkt40,700.003,850.001,000.00210047,650.0094,400104,400151,000remote comm bridge
CaroCFS2004VC2019Baro, Ceilo, radio, ultra winds, UPS, Viz, Tip Bkt68,200.003,850.001,000.00210075,150.00122,000132,000151,000
FrankfortFKS2004VC2019Baro, Ceilo, T/DP, radio, ultra winds, UPS, Viz, Tip Bkt70,700.004,180.001,500.00210078,480.00122,000132,000151,000
OwossoRNP2004VC2019Baro, Ceilo, T/DP, radio, ultra winds, UPS, Viz, Tip Bkt70,700.004,180.00500.00210077,480.00122,000132,000151,000
Rogers CityPZQ2004VC2019Baro, T/DP, radio, ultra winds, UPS, Viz, Tip Bkt40,700.003,850.002,000.00210048,650.0094,400104,400151,000
South HavenLWA2004VC2019Baro, Ceilo, radio, ultra winds, UPS, Viz, Tip Bkt68,200.003,850.001,500.00210075,650.00122,000132,000151,000
TroyVLL2004VC2019Baro, Ceilo, T/DP, radio, ultra winds, UPS, Viz, Tip Bkt70,700.004,180.001,000.00210077,980.00122,000132,000151,000remote winds
Drummond IslandDRM2005VC2020Baro, Ceilo, T/DP, radio, ultra winds, UPS, Viz68,200.003,850.002,000.00210076,150.00122,000132,000151,000
HowellOZW2005VC2020Baro, T/DP, radio, ultra winds, UPS, Viz38,200.003,520.00500.00210044,320.0094,400104,400151,000non-std site plan, site leans
Three RiversHAI2005VC2020Baro, Ceilo, T/DP, radio, ultra winds, UPS, Viz, Tip Bkt70,700.004,180.001,000.00210077,980.00122,000132,000151,000
FremontFFX2007VC2022Baro, Ceilo, ultra winds, UPS, Viz, Tip Bkt65,000.003,520.001,000.00210071,620.00122,000132,000151,000
MidlandIKW2008VC2023Baro, Ceilo, T/DP, radio, ultra winds, UPS, Viz68,200.003,850.001,000.00210075,150.00122,000132,000151,000
IoniaY702009VC2024Ceilo, T/DP, radio, ultra winds, UPS, Viz64,200.003,520.00500.00210070,320.00122,000132,000151,000remote winds
LapeerD952012VC2027T/DP, radio, ultra winds, UPS, Viz34,200.003,190.001,000.00210040,490.0094,400104,400151,000
West BranchY312016VC2031ultra winds, UPS, Viz28,500.002,530.001,500.00210034,630.0094,400104,400151,000
AERO WorkbenchEFUall timeVCanytimeBaro, T/DP, radio, ultra winds, UPS, Viz, Tip Bkt40,700.00N/CN/C40,700.009440094400100000
OLD Processor - Short Lifespan remaining®TOTAL PHASED UPGRADE by MDOT2,238,580.00
Ancillary equipment to replacecostNEW Processor - Long Lifespan remaining®®TOTAL VAISALA Replacment by MDOT4,430,600
Cabinet door seals,$200
Battery Box$700NEW Processor - Long Lifespan remaining®®TOTAL VAISALA Replacement by Contract4,840,200
D/N sensors/mounts$200
Aspirators?$1,000NEW Processor - Long Lifespan remaining®®®®TOTAL All Weather INC replacement by Contract6,291,000
TOTAL$2,100
ComponentsCostLabor hrsLabor CostContract Labor
Baro, inc vent, iSi$4,0003330
Ceilo, inc iSi$30,0003330
Temp/Dewpoint (T/DP), inc harness, iSi$2,5003330
Radio - AWOS2000 inc backplane/mount, harness, antenna/coax$3,2003330
Ultrasonic Winds - WMT702 inc harness, iSi, mount/crossarm$7,000101100
UPS -Triplite inc harness, battery harness$1,5003330
Visibility/Pres Wx (Viz) - inc Harness, mount, iSi$20,000101100
Tipping Bucket - TR-525 inc harness, ancillary, iSi, mount$2,5003330
0
Whole site Vaisala upgrade, new processor - Est only -$85,0006066009600
Whole site All Weather INC upgrade, earthwork, new processor - Est only-$130,0001201320021000
Travel costs - $250/person/day/hr away1234456
500100015002000200025003000

Etronics/AWOS/Airport_List_Chronlogic.xls

Bid Pricing

Inventory of AWOS Site Equipmentas of:2/11/23
AWOS IIIPRequired
Year InstallCellTempTippingWindVC/VDPlatformSensorsOptionalSalvageSite
/ upgradeBarometerCeilometerModemDisplaySensorBucketSensorXmtrSite PlanNOTESUpgradeUpgradeT-STORMS+HCreditTOTAL
Alma1995/2011PTB330CL31AYesWthr NexHMP 45AWS425Park AirMulti-Pad$0
Bad Axe1996/2010PTB330CL31AWthr NexHMP 155WS425Val 760Multi-Pad$0
Beaver Island2001blueCT25KWthr NexHMP 45AmechanicalVal 760Bi-Pad$0
Bellaire1995/2010PTB330CL31AWthr NexHMP 45AWS425Park Airnon-std multi-pad$0
Big Rapids1997/2010PTB330CL31AWthr NexHMP 45ATR-525I-HTWS425Park AirBi-Pad$0
Cadillac2000PTB330CL31AWthr NexHMP 155mechanicalAWOS2000Bi-Pad$0
Caro2004PTB220CT25KWthr NexHMP 155mechanicalVal 760Bi-Pad$0
Charlevoix2001blueCT25KWthr NexHMP155mechanicalPark AirBi-Pad$0
Charlotte2001blueCL31AWthr NexHMP 45ATR-525I-HTmechanicalVal 760Bi-Pad$0
Cheboygan2001blueCT25KWthr NexHMP 45AmechanicalVal 760Bi-Pad$0
Coldwater1996/2011PTB330CL31AWthr NexHMP 45AWMT702Park AirMulti-Pad$0
Drummond Island2005PTB220CT25KWthr NexHMP 45DTR525HTmechanicalVal 760Bi-Pad$0
Frankfort2004PTB220CT25KWthr NexHMP 45AmechanicalVal 760Bi-Pad$0
Fremont2007PTB220CL31YesWthr NexHMP155WS425AWOS2000Bi-Pad$0
Grosse Ile1995/2016PTB330CL31AWthr NexHMP 155TR-525I-HTWMT702AWOS2000Multi-PadSplit$0
Harbor Springs2001blueCT25KWthr NexHMP 155mechanicalVal 760Bi-Pad$0
Hillsdale1997/2016PTB330CL31AWthr NexHMP 155TR-525I-HTWS425AWOS2000Multi-Pad$0
Howell2005PTB220CL31AWthr NexHMP 45DTR-525I-HTmechanicalVal 760non-standard site layout$0
Ionia2009PTB330CL31Wthr NexHMP 45ATR-525I-HTWS425, remoteVal 760no tower$0
Lambertville2001blueCT25KWthr NexHMP 45AmechanicalVal 760Bi-Pad$0
Lapeer2012PTB330CL31AWthr NexHMP 45ATR-525I-HTWS425Val 760Bi-Pad$0
Ludington1999PTB330CL31AWthr NexHMP 155TR-525I-HTmechanicalAWOS2000Bi-Pad$0
Mackinac Island1990/2010PTB330CL31AWthr NexHMP 45ATI-525-HTWS425, remotePark Airno towerSnow Platform, remote winds$0
Manistique1997/2013PTB330CL31AWthr NexHMP 155TR-525I-HTWMT702AWOS2000Multi-Pad$0
Marquette2000PTB330CL31ATstormAv/Av/WnHMP 45ATR-525I-HTmechanicalAWOS2000ACU/UHF/UGSnow Platform, Tstorm$0
Marshall1996/2013PTB330CL31AWthr NexHMP 155TR-525I-HTWMT702Park AirMulti-Pad$0
Mason1995/2010PTB330CL31AWthr NexHMP155WS425Val 760Multi-Pad$0
Midland2008PTB220CL31Wthr NexHMP 45ATR-525I-HTWS425AWOS2000Bi-Pad$0
Monroe1995/2015PTB330CL31AYesWthr NexHMP 155TR-525I-HTWS425AWOS2000Multi-PadSplit$0
Mt Pleasant1999blueCT25KWthr NexHMP 45ATR-525-HTmechanicalAWOS2000Bi-Pad$0
Newberry1996/2013PTB330CL31AWthr NexHMP 155TR-525I-HTWS425AWOS2000Multi-Pad$0
Oscoda1994/2011PTB330CL31AWthr NexHMP 45ATR-525I-HTWMT702Val 760Bi-PadSplit$0
Owosso2004PTB220CT25KWthr NexHMP 45AmechanicalVal 760Bi-Pad$0
Port Huron2001blueCL31AWthr NexHMP 45AmechanicalPark AirBi-Pad$0
Rogers City2004PTB220CL31AWthr NexHMP 45AmechanicalVal 760Bi-Pad$0
Saginaw2000blueCT25KWthr NexHMP 45AmechanicalPark AirBi-Pad$0
South Haven2004PTB220CT25KWthr NexHMP155mechanicalVal 760Bi-Pad$0
Sturgis1995/2015PTB330CL31AWthr NexHMP 155TR-525I-HTWMT702AWOS2000Multi-Pad$0
Three Rivers2005PTB220CT25KWthr NexHMP 45AmechanicalVal 760Bi-Pad$0
Troy2004PTB220CT25KWthr NexHMP 155mech, remoteVal 760no tower$0
West Branch2016PTB330CL31AWthr NexHMP 155TR-525I-HTultrasonicAWOS2000Bi-Pad$0
File at: Etronics/AWOS/On-Site Equipment Inventory.xlsx
TOTALS$0$0$0$0$0
* all sites have FD12P currentlyGrand total$0
** all sites have tilt-over tower unless notedchecks$0

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