===== PDF PAGE 26 ===== [Extraction: embedded PDF text] CITY OF WEST CHICAGO INFRASTRUCTURE COMMITTEE AGENDA ITEM SUMMARY ITEM TITLE: AGENDA ITEM NUMBER: _. b---............+____._± .......__ Resolution No. 21-R-0033 - Professional Services COMMITTEE AGENDA DATE: May 6, 2021Agreement-Advanced Automation and Controls, Inc. for COUNCIL AGENDA DATE: May 17, 2021 Services Related to the 2021 Water Distribution System Supervisory Control and Data Acquisition (SCADA) System Upgrade Project STAFF REVIEW: Rocky HoNath, Utility Superintendent SIGNATURE ~ 4 APPROVED BY CITY ADMINISTRATOR: Michael L. Guttman SIGNATURE _________ _ ITEM SUMMARY: In June 2004, prior the construction of the City's Water Treatment Plant, City Council approved a contract with Utility Automation Services, Inc. for installation of a Supervisory Control and Data Acquisition (SCADA) System at all City Well Stations and Booster Stations to communicate with the Water Treatment Plant via a spread spectrum radio communications system. In the water system, SCADA is a computer-controlled system that monitors and controls the operations of the well pumps and booster stations with the assistance of level transducers; operations are based on actual system demand. The SCADA system also provides the Water Treatment Plant Operators with real time system data such as water pressure and chemical residuals. SCADA systems are typically application specific. In any computerized system, hardware and software upgrades are a required part of routine maintenance. After 17 years of operation, our current SCADA system is beginning to exhibit signs of failure. All of the existing equipment and components are no longer manufactured and are considered technologically obsolete. At this time, staff recommends a complete upgrade of the SCADA system for the City's water distribution system, including, but not limited to, installation of the following equipment: I. New Allen Bradley PLCs: A PLC is a programmable logic controller. These are industrial computers used to control different electro-mechanical processes for use in manufacturing, plants, or other automation environments. This is the brain of the system. 2. New 1O" Touch Screens: These screens enable programming and access to the PLC. They also provide real time data to operators in the field. Our current system does not have the capability for staff to access the system on site. 3. Two New Pressure Transmitters (Raw and Finished Water System at Each Site): These transmitters will monitor water system pressures at each site. Current equipment is not standardized and is obsolete. 4. Complete Integration of Well Controls: As we have updated wells and other distribution, system components the existing SCADA system has been limited in the information it can provide back to the Water Treatment Plant or be controlled at the Water Treatment Plant. This new system will bring back all alarm tags and associated data. ===== PDF PAGE 27 ===== [Extraction: embedded PDF text] CITY OF WEST CHICAGO 5. Intrusion Alarms with Video Camera System with DVR (Wireless): This proposal will enhance existing security systems by installing wireless cameras and entry alarms at all sites. These will be monitored through the SCADA System. 6. Installation of Pressure Sensors at Fremont Tower: This proposal will replace the existing pressure monitoring system by installing wireless monitoring at the site. This will be monitored through the SCADA System. 7. Mapping of Controls: During the upgrade all controls and alarm set points will be verified and their functions checked. When completed schematics will be provided of the control wiring. Currently the City uses Advanced Automation and Controls of McHenry, Illinois to maintain its sanitary collection and water distribution SCADA Systems. At staff's request, Advanced Automation and Controls furnished a proposal to upgrade the City's Water Distribution System SCADA System for an amount not to exceed $82,650.00 (see proposal attached). Staff recommends approval of a Professional Services Agreement with Advanced Automation and Controls, Inc., for an amount not to exceed $90,000.00, for all proposed upgrades and any additional improvements found necessary during the upgrade process. Any other issues found during the upgrades will be addressed/repaired on a time and materials basis. Staff does anticipate that there will be some transitional issues to address during the project as this is a complete hardware and software system upgrade project, and only one well station will be allowed to taken off-line at a time. Each site will be completed individually to not cause impact to the overall system. It is estimated to take two weeks to complete each site. Advanced Automation and Controls, Inc. anticipates completion of this project by December 2021. It is anticipated that the City will get 10-15 years of service life from the hardware component of the upgrade. The software will be regularly updated as updates become available; however, at the ten year mark the operating program will need to evaluated and most likely replaced by a new operational version. These proposed upgrades will ensure the system remains operational for at least the next decade. Advanced Automation and Controls is familiar with the City's current SCADA system and operational needs, they have successfully completed the 2019 Sanitary Collection System SCADA Upgrade Project, and other system installations associated with the City's 2019 Well #4 Pump Station Improvements Project and the 2018 Sanitary Lift Station #1 Replacement Project. $100,000.00 has been budgeted in the Water Fund (06-34-47-4806) for the 2021 Water Distribution System SCADA System Upgrade Project. ACTIONS PROPOSED: Approve Resolution No. 21-R-0033 authorizing the Mayor to execute a Professional Services Agreement with Advanced Automation and Controls, Inc., for an amount not to exceed $90,000.00, for services related to the 2021 Water Distribution System SCADA System Upgrade Project. ===== PDF PAGE 28 ===== [Extraction: embedded PDF text] RESOLUTION NO. 21-R-0033 A RESOLUTION AUTHORIZING THE MAYOR TO EXECUTE A PROFESSIONAL SERVICES AGREEMENT WITH ADV AN CED AUTOMATION & CONTROLS, INC. FOR SERVICES RELATED TO THE 2021 WATER DISTRIBUTION SYSTEM SUPERVISORY CONTROL AND DATA ACQUISITION (SCADA) SYSTEM UPGRADE PROJECT BE IT RESOLVED by the City Council of the City of West Chicago, in regular session assembled, that the Mayor is hereby authorized to execute a Professional Services Agreement for services related to the 2021 Water Distribution System Supervisory Control and Data Acquisition (SCAD A) System Upgrade Project, between the City of West Chicago and Advanced Automation & Controls, Inc., for an amount not to exceed $90,000.00, in substantially the form attached hereto and incorporated herein as Exhibit "A". APPROVED this 17th day of May 2021. AYES: NAYES: ABSTAIN: ABSENT: Mayor Ruben Pineda ATTEST: City Clerk Nancy M. Smith ===== PDF PAGE 29 ===== [Extraction: embedded PDF text] QUOTATION Phone 815.578.0655 Fax 815.578.0677 A.Advanced Automation & Controls, Inc. 780 Ridgeview Drive McHenry, IL 60050 Name Mr. Rocky Horvath JOB NUMBER: N/A Company City of West Chicago Address REFERENCE: Well House Modicon to Allen West Chicago, IL Bradley Upgrades Phone Number (630)768-8875 LOCATION: Wells Various Locations Fax Number PROPOSAL DATE: April 23, 2021 • AS SPECIFIED DAS EQUAL D F.O.B. FACTORY PRICES DO NOT INCLUDE SALES OR USES TAXES D AS ALTERNATIVE D TRSP. PREPAID TERMS: NET -30 DAYS PER ATTACHED TERMS AND CONDmONS ITEM QUAN DESCRIPTION TOTAL PRICE Advanced Automation and Controls, Inc. is pleased to provide the following Quotation for upgrading the Modicon PLCs to Allen Bradley PLCs at the required well and tower sites. The locations of the PLC and control panel upgrades are as follows: > Well #3 > Well #5/#6 > Well #7 > Well #8/#9 > Well #10/#11 > Well #12 > Booster #4 > Freemont Tower Panel Breakdown of each location with material and services is listed below. ===== PDF PAGE 30 ===== [Extraction: embedded PDF text] Pricing Breakdown Well3 Well 3 • Replace the existing Modicon PLC with an Allen Bradley MicroLogix 1400 PLC (The existing PLC has 16 $10,900.00 AC Digital Inputs, 8 Relay Digital Outputs and 4 Analog Inputs; the proposed new PLC shall have 20 AC Digital Inputs, 12 Relay Digital Outputs, 4 Analog Inputs, and 2 Analog Outputs) • 10 "Beijer Touchscreen (OIT) • Installation and wiring • Creating a new PLC and OIT programs with input from the Water Department • Developing new SCADA screens • PLC Wiring Drawings • 24VDC Power Supply 5 port Ethernet Switch• • Raw Line Transmitter • Finish Line Transmitter • Door Switches (Main door and overhead door) • Security Camera System ( 4 Cameras, 1 DVR, 1 TB) Wells 5&6 Wells 5&6 • Replace the existing Modicon PLC with an Allen $11,080.00 Bradley MicroLogix 1400 PLC (The existing PLC has 16 AC Digital Inputs, 8 AC Digital Outputs and 4 Analog Inputs; the proposed new PLC shall have 20 AC Digital Inputs, 12 Relay Digital Outputs, 4 Analog Inputs, and 2 Analog Outputs and an 8 Channel AC Digital Output Module) • 10 "Beijer Touchscreen (OIT) Installation and wiring• • Creating a new PLC and OIT programs with input from the Water Department • Developing new SCADA screens • PLC Wiring Drawings • 24VDC Power Supply 5 port Ethernet Switch• • Raw Line Transmitter • Finish Line Transmitter • Door Switches (Main door and overhead door) • Security Camera System ( 4 Cameras, 1 DVR, 1 TB) Well 7 Well 7 • Replace the existing Modicon PLC with an Allen $10,900.00 Bradley MicroLogix 1400 PLC (The existing PLC has 16 AC Digital Inputs, 8 Relay Digital Outputs and 4 Analog Inputs; the proposed new PLC shall have 20 AC Digital Inputs, 12 Relay Digital Outputs, 4 Analog Inputs, and 2 Analog Outputs) • 10" Beijer Touchscreen (OIT) • Installation and wiring • Creating a new PLC and OIT programs with input from the Water Department • Developing new SCADA screens • PLC Wiring Drawings • 24VDC Power Supply ===== PDF PAGE 31 ===== [Extraction: embedded PDF text] • 5 port Ethernet Switch • Raw Line Transmitter • Finish Line Transmitter • Door Switches (Main door and overhead door) • Security Camera System ( 4 Cameras, 1 DVR, 1 TB) Wells 8&9 Wells 8&9 • Replace the existing Modicon PLC with an Allen $11,820.00 Bradley MicroLogix 1400 PLC (The existing PLC has 24 AC Digital Inputs, 16 AC Digital Outputs and 8 Analog Inputs; the proposed new PLC shall have 20 AC Digital Inputs, 12 Relay Digital Outputs, 4 Analog Inputs, and 2 Analog Outputs and the following additional I/O modules: (1) 8 Channel AC Digital Output Module, (1) 8 Channel Relay Digital Output Module, and (1) 4 Channel Analog Input Module) • 10 "Beijer Touchscreen (OIT) • Installation and wiring • Creating a new PLC and OIT programs with input from the Water Department • Developing new SCADA screens • PLC Wiring Drawings • 24VDC Power Supply • 5 port Ethernet Switch • Raw Line Transmitter • Finish Line Transmitter • Door Switches (Main door and overhead door) • Security Camera System ( 4 Cameras, 1 DVR, 1 TB) Wells 10&11 Wells 10&11 • Replace the existing Modicon PLC with an Allen Bradley MicroLogix 1400 PLC (The existing PLC has 16 $11,250.00 AC Digital Inputs, 4 Relay Digital Outputs and 8 Analog Inputs; the proposed new PLC shall have 20 AC Digital Inputs, 12 Relay Digital Outputs, 4 Analog Inputs, and 2 Analog Outputs) • 10 "Beijer Touchscreen (OIT) • Installation and wiring • Creating a new PLC and OIT programs with input from the Water Department • Developing new SCADA screens • PLC Wiring Drawings • 24VDC Power Supply • 5 port Ethernet Switch • Raw Line Transmitter • Finish Line Transmitter • Door Switches (Main door and overhead door) • Security Camera System ( 4 Cameras, 1 DVR, 1 TB) ===== PDF PAGE 32 ===== [Extraction: embedded PDF text] Wells 12 Well 12 • Installation and wiring $6,900.00 • 10 "Beijer Touchscreen (OIT) • Creating a new PLC and OIT programs with input from the Water Department • Developing new SCADA screens • PLC Wiring Drawings • 24VDC Power Supply • 5 port Ethernet Switch • Raw Line Transmitter • Finish Line Transmitter • Door Switches (Main door and overhead door) • Security Camera System ( 4 Cameras, 1 DVR, 1 TB) Booster 4 Booster #4 • Installation and wiring • Modification of PLC and OIT programs to show door $2,650.00 status indication • Door Switches (Main door and overhead door) • Security Camera System ( 4 Cameras, 1 DVR, 1 TB) Freemont Water Tower Freemont Tower • Design, Fabricate and Install New INS ULA TED 36"x30"xl2" NEMA4x Stainless Steel Enclosure with $17,150.00 Swingout Door. Panel includes: • Allen Bradley MicroLogix 1400 PLC • 7 "Beijer Touchscreen (OIT) • MOS TransNet 900 Radio • Ntron 5 port unmanaged ethernet switch • PULs 24vdc Power Supply, 5A • Hoffman 400w Panel Heater w/Thermostat • Transtector Lighting Surge Protection • Installation and wiring • PLC Programming I OIT Programming • SCADA screen development • Radio Setup and Programming • Panel Drawings • WIKA or Equal Tower Level Transmitter • Jude Vicor - Tower antenna and cable installation Total Cost for all Sites: $82,650.00 ===== PDF PAGE 33 ===== [Extraction: embedded PDF text] Notes: )' AAC Will install the Door Switches and Security cameras. Cabling for the switches will be cleanly tie- wrapped to existing structure such as conduit or strut. )' City staff will install the new pressure transmitters at wels and tower. AAC will provide technical support if required. )' City will assist in installation of NEW outdoor panel at Freemont Tower. AAC will work with City for installation ACCEPTED THIS ___ DAY OF May, 2021 PRICE FIRM FOR 30 DAYS SUBMITTED THIS: BY: _____________ _ Advanced Automation & Thomas C Otto Controls, Inc. BY: Principal I COO www.aacontrolsinc.com