===== PDF PAGE 36 ===== [Extraction: OCR (rendered-page OCR)] CITY OF WEST CHICAGO INFRASTRUCTURE COMMITTEE AGENDA ITEM SUMMARY ITEM TITLE: AGENDA ITEMNUMBER: _S-E. | Resolution No. 19-R-0049 — 2019 Sanitary Collection COMMITTEE AGENDA DATE: October 3, 2019 System Supervisory Control and Data Acquisition . (SCADA) Upgrade Project COUNCIL AGENDA DATE: October 21, 2019 STAFF REVIEW: Rocky Horvath, Utility Superintendent SIGNATURE Bee i 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 37 ===== [Extraction: OCR (rendered-page OCR)] 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 collection 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: The Infrastructure Committee voted 6-0 for approval.