===== PDF PAGE 11 ===== [Extraction: embedded PDF text] CITY OF WEST CHICAGO INFRASTRUCTURE COMMITTEE AGENDA ITEM SUMMARY ITEM TITLE: AGENDA ITEM NUMBER: Y- .. ~ Resolution No. 19-R-0049 - 2019 Sanitary Collection COMMITTEE AGENDA DATE: October 3, 2019System Supervisory Control and Data Acquisition COUNCIL AGENDA DATE: October 21, 2019 (SCADA) Upgrade Project - STAFF REVIEW: Rocky Horvath, Utility Superintendent SIGNATURE APPROVED BY CITY ADMINISTRATOR: Michael L. Guttman SIGNATURE _________ _ ITEM SUMMARY: In September 2013, City Council approved contracts with Clark Dietz and Dynamic Electric for the 2013 Lift Station Automation Improvement Design-Build Project. Said project consisted of furnishing all labor, materials, and equipment necessary to upgrade the Supervisory Control and Data Acquisition (SCADA) system (i.e., Programmable Logic Controller (PLC), communication equipment, security equipment, etc.) at twelve of the City's thirteen sanitary sewer lift stations. SCADA is a computer-controlled system that monitors and controls the operations of the lift station's pumps with the assistance of level transducers and/or floats to monitor real time sanitary waste flows in and out of the each lift station. SCADA systems are typically application specific. In any computerized system, hardware and software upgrades are a required part of routine maintenance. After a thorough review of our current SCADA system staff have identified several modifications and maintenance upgrades that are required to keep the current system in good operational order. A general review of these required upgrades follows: 1. Upgrade Control Software: Each lift station is controlled by a PLC (i.e., a miniature computer). Each lift station PLC communicates with a master PLC housed at the City's Water Treatment Plant that then transmits operational data and alarms to City staff. All PLC's need software upgrades. As a part of this upgrade process, the code that operates the units will be reviewed and revised to more efficiently communicate data. Since the SCADA system communicates using bandwidth from the City's internet service provider, this upgrade will have the added benefit of reducing costs associated with data collection. 2. Establish a Master PLC Backup System: Our current master PLC has no backup system and it has failed in the past with no warning. When a failure of the master PLC occurs all communications fail rendering the alarms and monitors inoperable. When it fails, we can no longer automatically monitor and operate the sanitary collection system lift stations. As part of this project, a secondary control PLC will be installed at the Water Treatment Plant providing total system redundancy. 3. Add Reporting Software: Currently the system does not have a reporting function and staff must manually record data. Part of this project will be the addition of a Microsoft Excel based program, known as XL Reporter, which will track data in a digital format. This data will be used to improve lift station efficiency by identifying possible issues before failures occur. ===== PDF PAGE 12 ===== [Extraction: embedded PDF text] CITY OF WEST CHICAGO 4. Integrate SCADA Systems: Recently the West Chicago/Winfield Regional Wastewater Treatment Plant completed a significant upgrade of its SCADA system. With upgrades to the City's lift Station SCADA system, both systems can be integrated allowing for the sharing of data, thereby improving operational efficiency. Currently the City uses Advanced Automation and Controls of McHenry, Illinois to maintain its sanitary ~ollection and water production SCADA Systems. At staff's request, Advanced Automation and Controls furnished a proposal to upgrade the City's sanitary collection system SCADA for $49,660.00 (see attached). Advanced Automation and Controls proposal is summarized below: 1. Upgrade Control Software = $25,000 a. Updating Existing Displays = $2,800 2. Establish a Master PLC Backup System = $15,000 3. Add Reporting Software= $4,860 4. Integrate SCADA Systems= $2,000 $60,000.00 has been budgeted in the Sanitary Sewer Fund (05-34-43-4402) for sanitary lift station upgrades in FY 2019. Staff recommends approval of a Professional Services Agreement with Advanced Automation and Controls, in the amount of $60,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 some additional issues will need to be addressed due to the fact this is a complete system upgrade with outdated software. Advanced Automationn and Controls is familiar with the City's current SCADA system and operational needs, and they have recently successfully completed SCADA system installations associated with the City's Booster Station #4 and Sanitary Lift Station #1 Rehabilitation Projects. As indicated above, the SCADA system is a vital component of the operation of the City's sanitary sewer collection system. These proposed upgrades will ensure the system remains operational for the next several years. ACTIONS PROPOSED: Approve Resolution No. 19-R-0049 authorizing the Mayor to execute a Professional Services Agreement with Advanced Automation and Controls, Inc., for an amount not to exceed $60,000.00, to provide services related to the 2019 Sanitary Collection System Supervisory Control and Data Acquisition (SCADA) Upgrade Project. COMMITTEE RECOMMENDATION: ===== PDF PAGE 13 ===== [Extraction: embedded PDF text] RESOLUTION NO. 19-R-0049 A RESOLUTION AUTHORIZING THE MAYOR TO EXECUTE A PROFESSIONAL SERVICES AGREEMENT WITH ADV AN CED AUTOMATION & CONTROLS, INC. FOR SERVICES RELATED TO THE 2019 SANITARY COLLECTION SYSTEM SUPERVISORY CONTROL AND DATA ACQUISITION (SCADA) 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 2019 Sanitary Collection System Supervisory Control and Data Acquisition (SCADA) Upgrade Project, between the City of West Chicago and Advanced Automation & Controls, Inc., for an amount not to exceed $60,000.00, in substantially the form attached hereto and incorporated herein as Exhibit "A". APPROVED this 2P1 day of October, 2019. AYES: NAYES: ABSTAIN: ABSENT: Mayor Ruben Pineda ATTEST: City Clerk Nancy M. Smith ===== PDF PAGE 14 ===== [Extraction: embedded PDF text] QUOTATION Phone 815.578.0655 Fax 815.578.0677 Advanced Automation & Controls, Inc.A 780 Ridgeview Drive McHenry, IL 60050 Name Rocky Horvath JOB NUMBER: NA Company City of West Chicago Address REFERENCE: SCADA Upgrades and Modifications Phone Number LOCATION: West Chicago, IL Fax Number PROPOSAL DATE: September 20, 2019 • AS SPEOFIED DAS EQUAL D F.O.B. FACTORY PRICES DO NOT INCLUDE SALES OR USES TAXES DAS ALTERNATIVE D TRSP. PREPAID TERMS: NET -30 DAYS PER ATTACHED TERMS AND CONDITTONS ITEM OUAN DESCRIPTION TOTAL PRICE Advanced Automation and Controls, Inc. is pleased to provide the Total Cost Based on following Quotation for SCADA modifications and upgrades for the Time and Material City of West Chicago Water and Wastewater facilities. The following NOT TO EXCEED: services including the primary material and labor tasks, included in this quotation are as follows: $60,000.00 Tasks: Cost ESTIMATES Breakdown: (1) Upgndc SCADA Reporting Software Task #1 Material: $4,860.00 • Sytech XLReporter Version 12, Professional Edition w/ Historical Labor: • Installation and setup of software into existing Rockwell Factory View SE SCADA computer located at the WTP. (2)Upgrade of the MASTER PLC located at the WTP Task #2 $15,000.00 Material: • Allen Bradley CompactLogix PLC CPU - 1769-L30ER • Allen Bradley Power Supply - 1769-PA2 • Allen Bradley EtherNet Card - 1769-ECR • SixNet Cell Modem - SN-6921-AM • Antenna, Polyphaser, Cable, Connectors • PULs 24VDC Power Supply for Modem • NEMA 1 Enclosure ' ===== PDF PAGE 15 ===== [Extraction: embedded PDF text] Labor: • Write a new PLC program for lift station • Program Master PLC for polling and initial handshaking • SCADA database and screen modifications per site • OIT programming modifications per site • Master Modem configuration • Master PLC handshaking per site • Enclosure Fabrication and Installation**(See Note Below) (3) Modifications to the existini:; SCA DA dis(!la)'.s and Alarming Task #3 $ 2,800.00Labor: • Cleanup and Modifications to the existing Factory View SCADA displays and trending. • Mapping and modification of existing WIN911 alarming software. Develop alarming STANDARD for the system. Notes: • AAC will work closely with the West Chicago staff to improve or create the appropriate displays and alarming structure that will best fit the operation needs of the system. (4)Modilkatio11 to the Remote Access into SCADA Task#4 $ 2,000.00 Labor: • System evaluation is required to try and improve the remote accessibility of the SCADA system. Item such as network connections, VCN Viewer Rev Level, Etc. will be reviewed and or modified. (S)Rewrite of the Lift Station PLC (!rograms Task #5 Labor: $ 25,000.00 • Write I Modify a new PLC program for lift stations for new operations as well as communications logic. • SCADA database and screen modifications • Local OIT programming modifications • Master PLC handshaking to lift station ===== PDF PAGE 16 ===== [Extraction: embedded PDF text] Please do not hesitate to contact us of you have any questions or require any further information. ACCEPTED THIS ___ DAY OF September, 2019 PRICE FIRM FOR 30 DAYS SUBMITTED THIS: Advanced Automation & Controls, Inc. BY: www .aacontrolsinc.com