The URL can be used to link to this page

11-168 lk I Resolution No. 11-168 RESOLUTION AUTHORIZING EXECUTION OF A SECOND AMENDMENT AGREEMENT WITH B & W CONTROL SYSTEMS INTEGRATION, LLC FOR WATER DEPARTMENT SUPERVISORY CONTROL AND DATA ACQUISITION SYSTEM UPGRADES PROJECT BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF ELGIN,ILLINOIS,that Sean R. Stegall,City Manager,and Kimberly A.Dewis,City Clerk,be and are hereby authorized and directed to execute a second amendment agreement on behalf of the City of Elgin with B & W Control Systems Integration,LLC for Water Department Supervisory Control and Data Acquisition System Upgrades Project, a copy of which is attached hereto and made a part hereof by reference. s/David J. Kaptain David J. Kaptain, Mayor Presented: September 28, 2011 Adopted: September 28, 2011 Vote: Yeas: 7 Nays: 0 Attest: s/Kimberly Dewis Kimberly Dewis, City Clerk SECOND AMENDMENT AGREEMENT This Second Amendment Agreement is hereby made and entered into this 28th day of September 2011, by and between the City of Elgin, an Illinois Municipal Corporation (hereinafter referred to as "CITY") and B&W Control Systems Integration, LLC, an Illinois limited liability company (hereinafter referred to as "ENGINEER"). WHEREAS, the parties hereto have previously entered into an Agreement dated June 10, 2009, relating to the City of Elgin's Water Department SCADA system upgrades (hereinafter referred to as "ORIGINAL AGREEMENT" and such SCADA System Upgrades Project hereinafter referred to as the "Project"); and WHEREAS, ORIGINAL AGREEMENT provided for a maximum payment of $13,650; and WHEREAS, the parties hereto have previously entered into an amendment to such ORIGINAL AGREEMENT, such amendment constituting First Amendment Agreement dated November 18, 2009 (hereinafter referred to as the "First Amendment Agreement"); and WHEREAS, the CITY has determined that it requires further additional services from the ENGINEER for the Project relating to tying the CITY'S existing nine lift stations into the existing water SCADA system, and providing a monitoring system for three of the CITY'S combined sewer overflow sites; and WHEREAS, the circumstances necessitating these changes in performance contemplated by this amendment were not reasonably foreseeable at the time ORIGINAL AGREEMENT was signed; the changes contemplated by this Amendment Agreement are germane to the ORIGINAL AGREEMENT as signed; and this Second Amendment Agreement is in the best interests of CITY and is authorized by law. NOW, THEREFORE, in consideration of the mutual promises and covenants contained herein, and other good and valuable consideration, the sufficiency of which is hereby mutually acknowledged, the parties hereto hereby agree as follows: 1. Section 1 of the ORIGINAL AGREEMENT, as amended by the First Amendment Agreement, relating to Scope of Services, is hereby further amended by adding thereto the additional services to be provided by the ENGINEER as set forth in the ENGINEER'S letter dated August 23, 2011, consisting of three (3) pages, a copy of which is attached hereto as Attachment B-2 and made a part hereof by this reference. 2. Section 4 of the ORIGINAL AGREEMENT, as amended by the First Amendment Agreement, relating to payments to the ENGINEER, be and is hereby amended by adding the following additional provisions thereto: "The CITY shall pay the ENGINEER for services rendered pursuant to this Second Amendment Agreement a lump sum of $190,400 regardless of the actual costs incurred by the ENGINEER unless substantial modifications to the scope of work are authorized in writing by the CITY and incorporated into this agreement by way of further amendment to this agreement. The CITY shall make periodic payments to the ENGINEER based upon actual progress within thirty (30) days after receipt and approval of an invoice. Said periodic payments shall not exceed the amount for the various tasks as set forth in Attachment B-2 hereto. Full payment for each task shall not be made until the task is completed and accepted by the CITY. ENGINEER shall commence the work to be performed pursuant to this Second Amendment Agreement upon written notice to the CITY to proceed and shall complete all of the services to be performed pursuant to this Second Amendment Agreement within 210 days thereafter." 3. Except as amended by this Second Amendment Agreement, the ORIGINAL AGREEMENT, as previously amended by the First Amendment Agreement, shall remain in full force and effect. 4. In the event of any conflict between the terms of this Second Amendment Agreement, and the terms of the ORIGINAL AGREEMENT, as previously amended by the First Amendment Agreement, the terms of this Second Amendment Agreement shall supersede and control. CITY OF ELGIN B&W Control Systems Integration / By: �/ � ri By: city Manager / Engineer Attest: City Clerk F:\Legal Dept\Agreement\B&W Control SystemsIntegration-2nd Amendment Agr.docx - 2 - Upcoming Bridge Projects Client Job N Bridge SN Scope Bridge Type Phase 1 start Phase 1 finish Phase 2 start Phase 2 finish Notes KANCH 110358.30 Tanner Road over Lake Run Creek 045-3032 Replacement TBD August-11 November-11 November-11 April-12 KANCH 110358.30 Thatcher Road over Virgil Ditch No.1 045-5529 Replacement TBD August-11 November-11 November-11 April-12 ITASV 071648.40 Maple Street over Spring Brook Creek 022-6602 Replacement 3-sided precast August-11 December-11 June-12 Sheet pile wingwalls PRKFT 080286.40 Thorn Creek Drive over Thorn Creek 099-6753 Replacement 3-cell box culvert August-11 December-11 June-12 Staged ROULK 100730.30 MacGillis Drive over Squaw Creek 049-7700 Replacement TBD June-11 February-12 May-12 November-12 BFGVV 101120.30 Raupp Blvd over Buffalo Creek 016-6325 TBD TBD July-11 March-12 June-12 December-12 Verify footings,HWE WHELV 110071.30 Jeffery Avenue over Buffalo Creek 016-8211 Replacement TBD Jan-12 Aug-12 Nov-12 May-13 KIRKL Hortense Drive over Bull Run Creek 019-4002 TBD TBD September-11 April-12 April-12 July-12 Need shortcuts,agreement to be prepared for County SELGV 110405.10 McDonald Road over Otter Creek 045-3050 TBD TBD February-12 September-12 December-12 June-13 ISLKV 110406.10 Lake View Drive over Island Lake 056-6350 Replacement TBD February-12 September-12 December-12 June-13 WAUKC 110511.10 Grand Avenue over RR 049-2050 TBD 4-span steel funding request letter sent • ATTACHMENT B-2 • B&W Control Systems Integration 8678 Ridgefield Road•Crystal Lake,IL 60012 815.788.3600 office • 815.455.0450 fax•www.bwcsi.com Kyla Jacobsen August 23, 2011 Water Director City of Elgin 150 Dexter Ct. Elgin, IL 60120 Subject: Lift Station and CSO Monitoring-2011 BWCSI Job No. 090341.51 -Rev4 Dear Kyla: Based on our previous discussions and meetings, following is our proposal for providing tying the City's existing nine lift stations into the existing water SCADA system, and providing a monitoring system for three of the City's Combined Sewer Overflow (CSO) sites: Bluff City Blvd (Outfall 003), Lord Street (Outfall 006), and Highland Ave (Outfall 013). Scope of Services Equipment • Provide a Remote Telemetry Unit (RTU) at three (3) Lift Stations (Oaks Club, South St, and Chicago St) with the following components mounted and prewired in a NEMA 4 enclosure: • Allen-Bradley MicroLogix 1400 Programmable Logic Controller (PLC) with additional input module(s) as required to accommodate the existing input signals(pump run, pump fail, high water level, etc) as available. • Modbus ASCII to DF-1 protocol converter to interface with the existing Modicon polling PLC. • MDS radio compatible with existing SCADA system. • Heater. • UPS, power supplies, terminal blocks, fuses, wire, and other miscellaneous components as required for a complete panel. • Provide the following equipment for installation into the existing panels at five lift stations(Amberside, Bowes Creek, Country Knolls, Red Barn, and Comstock): • Modicon Momentum Programmable Logic Controller (PLC) with additional input module(s) as required to accommodate the existing input signals (pump run, pump fail, high water level, etc) as available. • MDS radio compatible with existing SCADA system. • UPS to power the PLC and radio. • a B&W Control Systems Integration Page 2 of 3 City of Elgin •090341.51 - Rev4—Rev4 • Provide the following equipment for installation into the existing panel at Hopps pump station: • Modbus ASCII to DF-1 protocol converter to interface with the existing Modicon polling PLC. • MDS radio compatible with existing SCADA system. • NOTE: The existing Allen-Bradley PLC will be utilized to tie into the SCADA system. • Provide a level monitoring system at each of three CSO monitoring manhole locations(CSO 003, CSO 006, and CSO 013) consisting of the following: • Hadronex Smart Cover system consisting of ultrasonic level sensor and radio transceiver. • One year of web-based monitoring and data collection service. • Provide a river level monitoring system consisting of the following: • Hadronex Smart Cover system consisting of ultrasonic level sensor and radio transceiver. • PVC stilling well for installation of Smart Cover system. • One year of web-based monitoring and data collection service Labor Project Management • Plan, schedule, and coordinate the activities that must be performed to complete the project. Programming • Configure SmartCover system to transmit level data to the Hadronex web-based monitoring and historical data collection site. • Integrate historical data from web-site into the SCADA reporting system. • Program the PLC and radio at each lift station to communicate status and alarms back to the SCADA Servers at Airlite and Riverside WTPs. • Program the master polling PLC at Airlite to collect data from all but the Chicago St. Lift Station. • Program the master polling PLC at Riverside to collect data from the Chicago St. Lift Station. • Program the SCADA Servers at Riverside and Airlite to display lift station status and alarms, including pump run, pump runtime totals, pump fail, pump seal fail, high wet well level, wet well level value, generator run, and generator fail, as they are • B&W Control Systems Integration Page 3 of 3 City of Elgin •090341.51- Rev4—Rev4 available at each station (new status or alarm signals not currently available at the existing lift station control panels will not be added as part of this project). • Create one monthly report to display lift station pump daily runtimes and start cycles. Installation • Install new RTU panels at each lift station where provided, including power wiring and signal wiring to the existing lift station control panel. RTU to be installed inside existing electrical enclosure if space allows, or on outside of existing electrical enclosure. • Install PLC and radio equipment inside the existing lift station control panels at the other lift stations where RTU panels are not required. • Install SmartCover system in monitoring manhole locations and river level monitoring location. Start-up/Testing • Test system programming to ensure status and alarm signals are properly transmitted to the SCADA master sites. • Test system programming to ensure status and alarm signals are properly transmitted to the SCADA master sites. Training • Train City staff on the procedure for logging onto the web site to view real-time level data and download historical data. Subcontractor • Provide the services of a qualified antenna subcontractor to install antennas at each lift station site as follows: • Provide mast attached to side of building or on pole attached to outdoor electrical enclosure to allow installation of antenna at minimum of 14 feet above grade. Provide 9 dB gain yagi antenna. Provide 1/2" foam dielectric antenna cable to connect the antenna to the SCADA RTU panel. • Provide the services of a qualified subcontractor to install the river level monitoring stilling well. I:\CRYSTAL LAKE\ELGNC\101049-C50 INSTALLATION\10 PROPOSAL\090341 51 PROPOSAL-LIFT STATION AND 050 MONITORING.DOCX ill a (SPORT TO MAYOR & MEMBERS OF CITY C:f UNCIL E LG I N �J THE CITY IN THE SUBURBS' AGENDA ITEM: H MEETING DATE: September 14, 2011 ITEM: Second Amendment to Engineering Services Agreement with Baxter & Woodman Control Sys- tems Integrators for additional Supervisory Control and Data Acquisition System ($190,400) OBJECTIVE: To comply with the terms of the city's submitted Illinois Environmental Protection Agency Long Term Control Plan. RECOMMENDATION: Authorize staff to execute a second amendment to the engineering services agreement with Baxter & Woodman Control Systems Integrators to include monitoring for the combined sewer overflows and lift stations in the amount of$190,400. BACKGROUND In June 10, 2009, the city entered into an agreement with Baxter & Woodman Control Systems Integrators (BWCSI) for the evaluation of the city's ten-year-old water department "Supervisory Control and Data Acquisition" (SCADA) system. The agreement also included developing a plan for upgrading the SCADA system controlling the water operations. In November 2009, the city amended the agreement to include actual replacement of the SCADA servers and other neces- sary hardware, as well as providing, installing and reconfiguring updated software. The new servers and software enabled operators to have more control, a more reliable data storage sys- tem and the ability to report to the Illinois Environmental Protection Agency (IEPA). During the same period (fall of 2009), the city completed and submitted to the IEPA its long term control plan (LTCP) for the monitoring and eventual remediation of combined sewer over- flows (CSOs). An aspect of the LTCP includes monitoring the discharges to the Fox River by the CSOs. The LTCP requires the city to install flow monitoring at all of the sewer outfalls so that the information can be easily reported to the IEPA. rib's The city's ongoing compliance with the National Pollution Discharge Elimination System (NPDES) and development of the LTCP involves work with another engineering firm—Carroll Engineering. The city originally intended to work with Carroll Engineering to devise a system for complying with the monitoring portion of the LTCP. The city received a proposal from Carroll Engineering's subcontractor in excess of $500,000 for new servers, software, remote reading equipment and the like. Staff was reluctant to spend a half-million dollars in creating a new monitoring system and be- gan searching for alternatives. Staff analyzed the upgraded the SCADA servers at the Riverside Water Treatment Plant and determined there is sufficient capacity to include the monitoring capability for the CSOs with that new system. As such, the city can avoid spending additional money for new computer hardware. And because BWCSI performed that SCADA upgrade, its consultants are familiar with the hardware and software on the city's network servers and are well-poised to expedite the completion of this work. OPERATIONAL ANALYSIS Because BWCSI has been working with the water department to upgrade the current water plant operations SCADA, staff contacted the firm to inquire about the feasibility of adding CSO and lift station monitoring to the city's existing system. This is a necessary component to the CSOs commitment to the EPA in the LTCP. Staff determined that the city can save time and money by utilizing hardware and software it already owns and has licensed, by incorporating Al) the new monitoring within the city's existing system. The second amendment to the agreement will add remote monitoring to all eight of the city's sanitary lift stations and level monitoring at three of the CSOs at this time. Additional CSO mon- itoring will be added in the future as funds permit. Future compliance upgrades will only re- quire adding a level sensor and radio transceiver at the remaining CSOs since the framework for the SCADA is now in place. INTERESTED PERSONS CONTACTED None. FINANCIAL ANALYSIS Staff recommends executing a second amendment to the engineering services agreement with Baxter & Woodman Control Systems Integration in the amount of$190,400. The amended ser- vice agreement will add remote monitoring at all eight of the city's sanitary lift stations and lev- el monitoring at three of the CSOs. I h 2 BUDGET IMPACT FUND(S) ACCOUNT(S) PROJECT#(S) AMOUNT AMOUNT BUDGETED AVAILABLE 2011 G.O. Bond 371-4200-795.92-41 339568 $190,400 $190,400 LEGAL IMPACT None. ALTERNATIVES The city council may choose not to authorize staff to execute an amendment to the agreement with BWCSI for the services necessary to implement the required CSO and lift station SCADA and could solicit other engineering firms for a proposal to complete this project. NEXT STEPS 1. Execute agreement with BWCSI. 2. Installation of equipment. Originators: Kyla B. Jacobsen, Water Director Final Review: Colleen Lavery, Chief Financial Officer William A. Cogley, Corporation Counsel/Chief Development Officer Richard G. Kozal,Assistant City Manager/Chief Operating Officer Sean R. Stegall, City Manager ATTACHMENTS A: Second Amendment Agreement B: BWCSI Scope of Work for Second Amendment C: First Amendment Agreement and Attachments D: Original Agreement and Attachments 3 ATTACHMENT A A) SECOND AMENDMENT AGREEMENT This Amendment Agreement No. 2 is hereby made and entered into this day of 2011, by and between the City of Elgin, an Illinois Municipal Corporation (hereinafter referred to as "CITY") and B&W Control Systems Integration, LLC, an Illinois limited liability company (hereinafter referred to as "ENGINEER"). WHEREAS, the parties hereto have previously entered into an Agreement dated June 10, 2009, attached hereto as Attachment "A" (hereinafter referred to as "ORIGINAL AGREEMENT"); and WHEREAS, ORIGINAL AGREEMENT provided for a maximum payment of $13,650; and WHEREAS, after completion of the evaluation of the Water Department Supervisory Control and Data Acquisition (hereinafter referred to as "SCADA") System and based on the final SCADA System Master Plan submitted to the City's Water Department in September 2009 it was determined that the Water Department SCADA System shall be upgraded as described in the scope of the services, attached hereto and made a part hereof as Attachment `B-2". WHEREAS, the parties hereto have each determined it to be in their best interest to again amend ORIGINAL AGREEMENT; and WHEREAS, the circumstances necessitating these changes in performance contemplated by this amendment were not reasonably foreseeable at the time ORIGINAL AGREEMENT was signed; the changes contemplated by this Amendment Agreement are germane to the ORIGINAL AGREEMENT as signed; and this Second Amendment Agreement is in the best interests of CITY and is authorized by law. NOW, THEREFORE, in consideration of the mutual promises and covenants contained herein, and other good and valuable consideration, the sufficiency of which is hereby mutually acknowledged, the parties hereto hereby agree as follows: 1. CITY shall pay the ENGINEER for services under this Second Amendment Agreement a lump sum of$190,400.00, regardless of the actual costs incurred by the ENGINEER unless substantial modifications to the scope of the work are authorized in writing by the CITY. 2. WHEREAS, the parties hereto have previously entered into an agreement dated June 10, 2009, and a First Amendment Agreement to the A") - 1 - aforementioned agreement of June 10, 2009 attached hereto and made a part hereof as Attachment A and Attachment C, respectively (hereinafter collectively referred to as "ORIGINAL AGREEMENT"); and 3. Except as amended by this Second Amendment Agreement, the ORIGINAL AGREEMENT between the parties shall remain in full force and effect. CITY OF ELGIN B&W Control Systems Integration zdy By: By: L 45: ‘, .-- City Manager Engineer Attest: City Clerk r - 2 - ATTACHMENT B - BWCSI Scope of work for Second Amendment • B&W Control Systems Integration 411) 8678 Ridgefield Road-Crystal Lake,IL 60012 815.788.3600 office - 815.455.0450 fax-www.bwcsl.com Kyla Jacobsen August 23,2011 Water Director City of Elgin 150 Dexter Ct. Elgin, IL 60120 Subject: Lift Station and CSO Monitoring-2011 BWCSI Job No. 090341.51 -Rev4 Dear Kyla: Based on our previous discussions and meetings, following is our proposal for providing • tying the City's existing nine lift stations into the existing water SCADA system, and providing a monitoring system for three of the City's Combined Sewer Overflow (CSO) sites: Bluff City Blvd (Outfall 003), Lord Street(Outfall 006), and Highland Ave(Outfall 013). Scope of Services Equipment • Provide a Remote Telemetry Unit (RTU) at three (3) Lift Stations (Oaks Club, South St, and Chicago St) with the following components mounted and prewired in a NEMA 4 enclosure: • Allen-Bradley MicroLogix 1400 Programmable Logic Controller (PLC) with additional input module(s) as required to accommodate the existing input signals(pump run, pump fail, high water level,etc)as available. • Modbus ASCII to DF-1 protocol converter to interface with the existing Modicon polling PLC. • MDS radio compatible with existing SCADA system. • Heater. • UPS, power supplies, terminal blocks, fuses, wire, and other miscellaneous components as required for a complete panel. • Provide the following equipment for installation into the existing panels at five lift stations (Amberside, Bowes Creek, Country Knolls, Red Barn,and Comstock): • Modicon Momentum Programmable Logic Controller (PLC) with additional input module(s) as required to accommodate the existing input signals (pump run, pump fail, high water level, etc) as available. • MDS radio compatible with existing SCADA system. • UPS to power the PLC and radio. , . , . rB&W Control Systems Integration Page 2 of 3 City of Elgin •090341.51- Rev4—Rev4 • Provide the following equipment for installation into the existing panel at Hopps pump station: • Modbus ASCII to DF-1 protocol converter to interface with the existing Modicon polling PLC. • MDS radio compatible with existing SCADA system. • NOTE: The existing Allen-Bradley PLC will be utilized to tie into the SCADA system. • Provide a level monitoring system at each of three CSO monitoring manhole locations(CSO 003,CSO 006, and CSO 013)consisting of the following: • Hadronex SmartCover system consisting of ultrasonic level sensor and radio transceiver. • One year of web-based monitoring and data collection service. • Provide a river level monitoring system consisting of the following: • Hadronex SmartCover system consisting of ultrasonic level sensor and radio transceiver. • PVC stilling well for installation of SmartCover system. • One year of web-based monitoring and data collection service r Labor Project Management • Plan, schedule, and coordinate the activities that must be performed to complete the project. Programming • Configure SmartCover system to transmit level data to the Hadronex web-based monitoring and historical data collection site. • Integrate historical data from web-site into the SCADA reporting system. • Program the PLC and radio at each lift station to communicate status and alarms back to the SCADA Servers at Airlite and Riverside WTPs. • Program the master polling PLC at Airlite to collect data from all but the Chicago St. Lift Station. • Program the master polling PLC at Riverside to collect data from the Chicago St. Lift Station. • Program the SCADA Servers at Riverside and Airlite to display lift station status and alarms, including pump run, pump runtime totals, pump fail, pump seal fail, high wet well level, wet well level value, generator run, and generator fail, as they are rib' , . • r B&W Control Systems Integration Page 3 of 3 City of Elgin •090341.51- Rev4—Rev4 el available at each station (new status or alarm signals not currently available at the existing lift station control panels will not be added as part of this project). • Create one monthly report to display lift station pump daily runtimes and start cycles. Installation • Install new RTU panels at each lift station where provided, including power wiring and signal wiring to the existing lift station control panel. RTU to be installed inside existing electrical enclosure if space allows, or on outside of existing electrical enclosure. • Install PLC and radio equipment inside the existing lift station control panels at the other lift stations where RTU panels are not required. • Install SmartCover system in monitoring manhole locations and river level monitoring location. Start-up/Testing • Test system programming to ensure status and alarm signals are properly 44) transmitted to the SCADA master sites. • Test system programming to ensure status and alarm signals are properly transmitted to the SCADA master sites. Training • Train City staff on the procedure for logging onto the web site to view real-time level data and download historical data. Subcontractor • Provide the services of a qualified antenna subcontractor to install antennas at each lift station site as follows: • Provide mast attached to side of building or on pole attached to outdoor electrical enclosure to allow installation of antenna at minimum of 14 feet above grade. Provide 9 dB gain yagi antenna. Provide %1" foam dielectric antenna cable to connect the antenna to the SCADA RTU panel. • Provide the services of a qualified subcontractor to install the river level monitoring stilling well. I:\CRYSTAL LAKE\ELGNC\101049.CSO INSTALLATION\10-PROPOSAL\090341.51 PROPOSAL-UFT STATION AND C50 MONIT0RING.00IX 1 ATTACHMENT C- First Amendment Agreement FIRST AMENDMENT AGREEMENT This Amendment Agreement No. 1 is hereby made and entered into this day of 2009, by and between the City of Elgin, an Illinois Municipal Corporation (hereinafter referred to as "CITY") and B&W Control Systems Integration, an Illinois Corporation (hereinafter referred to as"ENGINEER"). WHEREAS, the parties hereto have previously entered into an Agreement dated June 10, 2009, attached hereto as Attachment "A" (hereinafter referred to as "ORIGINAL AGREEMENT"); and, WHEREAS, ORIGINAL AGREEMENT provided for a maximum payment of$13,650; and WHEREAS, after completion of the evaluation of the Water Department SCADA System and based on the final SCADA System Master Plan submitted to the City of Elgin Water Department in September 2009 it was determined that the Water Department SCADA System shall be upgraded as described in the scope of the services, attached hereto as Attachment `B". WHEREAS, the parties hereto have each determined it to be in their best interest to again amend ORIGINAL AGREEMENT; and WHEREAS, the circumstances necessitating these changes in performance contemplated by this amendment were not reasonably foreseeable at the time ORIGINAL AGREEMENT was signed; the changes contemplated by this Amendment Agreement are germane to the ORIGINAL AGREEMENT as signed; and this First Amendment Agreement is in the best interests of CITY and is authorized by law. NOW, THEREFORE, in consideration of the mutual promises and covenants contained herein, and other good and valuable consideration, the sufficiency of which is hereby mutually acknowledged, the parties hereto hereby agree as follows: 1. The scope of services outlined in Attachment "B" of the ORIGINAL AGREEMENT is hereby amended to include the following: A. Phase 1. 1. Replace SCADA Servers at Riverside WTP (Hardware and Software Upgrade) 2. Replace SCADA Servers at Airlite WTP (Hardware and Software Upgrade) 3. Install SCADA Terminal Server and related thin-client software. 4. Separate SCADA PLC network from Administration Network at Airlite WTP. 5. Separate SCADA PLC network from Administration Network at Riverside WTP. 6. Reconfigure SCADA System Security. 7. Develop and Test a Simple SCADA Disaster Recovery Plan. - 1 - _ • B. Phas 2. A, 1. Replace SCADA Clients in Filter Room at Riverside WTP with two Operator Interface Terminals (OITs). 2. Redevelop SCADA screens for Riverside WTP. 3. Redevelop SCADA screens for Airlite WTP. 4. Install, configure, and implement a Software-based Alarm System 5. Design configure, a new Web-based SCADA Reporting System 6. Implement a SCADA secure remote access system. 2. Paragraph 4(A)of the ORIGINAL AGREEMENT is hereby amended to read: "For Services provided by the ENGINEER shall not-to-exceed the limit of each phase as follows: A. Cost of Phase 1 of the SCADA System Improvements which includes the labor, software and hardware as outlined in Attachment "C", shall not exceed $131,500 (One Hundred Thirty One Thousands Five Hundred Dollars). B. Cost of Phase 2 of the SCADA System Improvements which includes the labor, software and hardware as outlined in Attachment "C", shall not exceed $120,000 (One Hundred Twenty Thousand Dollars). C. Cost of the Supplemental Services items of the SCADA System Improvements shall based on actual time and based on the prices listed on Attachment"D". D. No additional payment shall be made to the Engineer regardless of the actual costs incurred by the ENGINEER unless substantial modifications to the scope of the work are authorized in writing by the CITY. 3. The City's responsibilities are listed in attachment"E" "4") 4. The Schedule of Work Chart is shown in Attachment"F". 5. Except as amended by this First Amendment Agreement, the ORIGINAL AGREEMENT between the parties shall remain in full force and effect. CITY OF ELGIN B&W Control Systems Integration By: By: City Manager y g Engine r Attest: City Clerk 4.11) - 2 - • row • r' ATTACHMENT B City of Elgin, Illinois Water Department SCADA System Upgrade October 12,2009 Scope of Services — Phase I Improvements Project Administration 1. BWCSI will provide the coordination, oversight, and management necessary to perform the recommended SCADA server upgrades. Replace SCADA Servers at Riverside WTP 2. Provide two (2) HP Proliant DL380 G5 servers (or equal) with the following requirements: a) Processor:Quad Core Intel®Xeon,2.5 GHz minimum b) Memory:8 GB c) Tower or Rack Chassis Orientation(depending on if existing enclosures can be modified for rack mounting the servers). d) Power Supply:Redundant Power Supplies. e) Hard Drive Configuration: Three (3) redundant 146 GB, with integrated hardware RAID5. 1) Network Adapter:(2)integrated Gigabit Ethernet NICs. g) CD/DVD Drive:Combo CDRW/DVD Drive,SATA COMBO h) Hardware Support Services:3 Year 4HR 7x24 Onsite manufacturer support 3. Provide one (1) license of GE Proficy iFIX Unlimited Developer Ver 5.0, one (1) license of GE Proficy Unlimited Runtime Ver 5.0, and redundant failover license, with one year of GlobalCare support. 4. Provide two (2) licenses of Modicon Modbus Ethernet Drivers, with one year of Global Care support,for communication between FIX and the PLCs, 5. Provide two (2) licenses of GE Proficy IFIX Unlimited Runtime Ver 5.0, with one year of GlobalCare support,and install on City computers. 6. Configure the two replacement servers with GE iFIX 5.0 SCADA software running on Windows Server 2003 R2. Configuration will include the loading of the Operating Systems, SCADA software, PLC drivers, and other software necessary to replace the City's existing SCADA servers. 7. Install the SCADA servers in the existing enclosure where the existing SCADA servers are currently located. 8. Fully test operation of the SCADA servers to ensure proper operation. Set up the servers to ensure a smooth transition between the servers and to provide annunciation during a server fail-over. Replace SCADA Servers at Airlite WTP 9. Provide two (2) HP Proliant DL380 G5 servers (or equal) with the following requirements: a) Processor:Quad Core Intel®Xeon,2.5 GHz minimum b) Memory:8 GB (1°' ATTACHMENT 8 October 12,2009 c) Tower or Rack Chassis Orientation(depending on If existing enclosures can be modified for rack mounting the servers). d) Power Supply:Redundant Power Supplies. e) Hard Drive Configuration: Three (3) redundant 146 GB, with integrated hardware RAIDS. f) Network Adapter:(2)Integrated Gigabit Ethernet NICs. g) CD/DVD Drive:Combo CDRW/DVD Drive,SATA COMBO h) Hardware Support Services:3 Year 4HR 7x24 Onsite manufacturer support 10. Provide one (1) license of GE Proficy iFIX Unlimited Developer Ver 5.0, one (1) license of GE Proficy Unlimited Runtime Ver 5.0, and redundant failover license, with one year of GlobalCare support. 11.Provide two (2) licenses of Modicon Modbus Ethernet Drivers, with one year of Global Care support, for communication between iFIX and the PLCs. 12.Provide one(1)license of GE Proficy IFIX Unlimited Runtime Ver 5.0,with one year of GlobalCare support,and install on City-provided workstatation. 13.Configure the two replacement servers with GE iFIX 5.0 SCADA software running on Windows Server 2003 R2. Configuration will include the loading of the Operating Systems, SCADA software, PLC drivers,and other software necessary to replace the City's existing SCADA servers. 14. Install the SCADA servers in the existing enclosure where the existing SCADA servers are currently located. 4111)15. Fully test operation of the SCADA servers to ensure proper operation. Install Terminal Server and Thin Client Software 16.Provide one (1) HP Proliant DL380 G5 servers (or equal) with the following requirements: a) Processor:Quad Core Intel®Xeen,2.5 GHz minimum b) Memory:16 GB c) Tower or Rack Chassis Orientation(depending on If existing enclosures can be modified for rack mounting the servers). d) Power Supply:Redundant Power Supplies. e) Hard Drive Configuration:Two(2)redundant 146 GB,with Integrated hardware RAID1. f) Network Adapter:(2)Integrated Gigabit Ethernet NICs. g) CD/DVD Drive:Combo CDRW 1 DVD Drive,SATA COMBO h) Hardware Support Services:3 Year 4HR 7x24 Onsite manufacturer support 17. Provide one (1) license of GE Proficy iClientTS user base support, with five (5) additional thin client licenses, all with one year of GlobalCare support. 18.Configure the terminal server with GE iClientTS SCADA software running on Windows Server 2003 R2. Configuration will include the loading of the Operating Systems, SCADA software, and other software as necessary to allow the server to act as a SCADA terminal server. 19. Install the terminal server in the existing enclosure at the Riverside WTP where the existing SCADA servers are currently located. If standard rack hardware can be purchased for the existing enclosures,the server will be rack-mounted. Page 2 of 5 • ATTACHMENT B October 12,2009 20.Configure Terminal Server shortcuts on up to ten (10) computers that will need access to the SCADA system. BWCSI still sill show City Water Department and MIS staff how to configure a new connection, which is approximately a one-minute task. 21.Fully test operation of the SCADA servers to ensure proper operation. Network Separation at Airlite WTi? 22.Configure existing security appliance and switch to separate the administration network from the control network using access control list rules in the security appliance. Existing IP addresses on PLCs will be maintained. 23.Provide and install one (1) Moxa Modular 4-bay industrial switch with two (2) eight- port Ethernet 100 Mbps modules and one (1)two-port multimode ST Fiber module. Network Separation at Riverside WTP 24.Provide one (1) Cisco ASA5505 security appliance with one (1) year of 24x7x365- 4hr manufacturer support. 25.Provide and install one(1) Moxa Modular 4-bay industrial switch with two (2) eight- port Ethernet 100 Mbps modules and one(1)two-port multimode ST Fiber module. 26.Configure security appliance and switch to separate the administration network from the control network using access control list rules in the security appliance. Existing IP addresses on PLCs will be maintained. • Reconfigure SCADA System Security 27.Provide SCADA Software development and configuration to set up user security based on Input from City staff. a) A user account with specific security rights will be configured for each SCADA user. b) SCADA Graphics will be modified to allow specific functions to be accessed based on the security credentials of the logged in user. Disaster Recovery Plan 28.Review the City's existing disaster recovery plan and modify the plan based on the hardware and software improvements made as part of this project. 29.Test the plan to ensure the plan is sound and provides the level of backup required to allow recovery from a server failure. Replace SCADA Clients in Riverside WTP Filter Room with 01 's 30.Provide two (2) Allen-Bradley PanelView Plus 1250 color touch-screen operator interface terminals(Offs), 31.Provide two(2)wall-mount enclosures for the OlTs. 32. Install OlTs in the enclosures and mount the enclosures in the Riverside WTP Filter Room(one on each side of the room)midway between the two filters. 33.Terminate power and network cabling inside of the OIT's enclosures. rk Page 3 of 5 • ATTACHMENT B October 12.2009 34.Develop graphics for the OlTs to allow operations staff to control filter operations. Scope of Services -Phase II Improvements Redevelop Screens for Riverside WTP and Airlite WTP 35.Provide SCADA graphical screen development to replace the existing screen graphics at both the Riverside WTP and Airlite WTP SCADA Servers. 36.Graphic development will be achieved with input from City staff, and will provide a more user friendly,easier to navigate system,with consistent graphics to represent similar functions. Provide and lnsta)l_oftware-based Alarm System 37.Provide and install two (2) redundant copies of Software-based alarm dialing software to be installed on the two servers at Riverside (they can be configured to alarm on any City-wide SCADA alarms). Include one (1) year of manufacturer support. 38.Provide and install two (2) TAPI-compliant modems on the two Riverside SCADA servers. Configure the modems and software to communicate directly with the SCADA servers. 39.Configure up to 100 alarms to locally annunciate and optionally dial out to up to three separate groups. Test alarm operation. 40.Provide a quick-help electronic document on the SCADA servers on the top requested features and configuration of the alarm dialing software. Provide Web-Based Reporting System 41.Create and provide a data collection and reporting system consisting of a SQL based database to collect and store data, and web-based front-end interface to allow staff to view and print reports,and also enter manual data not collected by the SCADA system. Reports will be created using the non-proprietary SQL Reporting Services such that future MIS (or other technical staff)can create or modify existing reports. 42.Create up to four(4)water system reports and test for operation. Provide SCADA Remote Access System 43.Work with City MIS staff to bridge existing City VPN solution into the new SCADA Terminal Server. Configure remote access options to all SCADA servers. Training 44.Operators and Staff: Provide operator training to include: SCADA System overview (where do you go to do what), navigation, new screens, alarms acknowledgement • Page4of5 Al) • r ATTACHMENT B October 12.2009 and configuration, appropriate actions for typical software and hardware errors, reporting configuration,operations,and usage. 45.Programming Training: Provided programming training to the Operations Engineer and Instrumentation Technicians on SCADA software and hardware installation and configuration; database design, modification, and editing; diagnostic and troubleshooting routines; screen graphics modifications; report configuration, display/formatting; historical data collection and access; disaster recovery plan implementation,system backup procedures and reloading from backup files. M'1ELGNo cS03l1-SCADAASSESSMENT\10.1NSTV.TIONYMPLEMENTAT IOM09014 1 IMPL-ATT B-SCOPE.bOCX Page 5 of 5 . . . . . . ,,... , „_... . ... • - . _ ....... ....„.. ,.....„, • -._.,.--,.,,,:::::,. '-.;,--::•••ti-2,.',.:*::,t1.-j-,•;;:=-.:-•=1` eli' -•: .- -.•;:.*:, ,,::;.;:.;;', 7,-;,.....-.,-, ,••'•=:‘,-.','....*.•---,-- - -- 411 :1.' -i'i--:,•:-.:•:: -.•: ,;-..:::;..: .-.•':;.-..-.... -,: :::,i-•::-.:'----'i,:':'''-'-'''''.':-.'-'-''"---.....'• o ATTACHMENT C raj Water DepartCmitYanotfSECIgAinDliis AilSnyostem Upgrade October 12,2009 . . . ---- Fee Phase 1 Improvements .------------7-!..----7.7414..:;;ate.:i. Hardware. i:Line Total . 7.7-7:41:-.a.•:„...57. .•. •*;.'.::1-.•:•••-:.:.La or--:::: .. .-P,'.-72-1.,i-;..4.. ..‘..:-.. -- '''..:::7.--i.,V.$44;61:i0'. RecortiMe.tik-loL!,'. ..,'!- ' „., ,-766,,VA,7,: 49-1)15p.:4V- .i.: $14,..M.9.9j,,,.. ..inz.„,,..., atTpt , -it.:.--;,.::::c.:..::....-:.:..,-,:', ',,.:4...::::.•-:i.,.fi:?::-:...c,,:',-,m.:::.:?2;.:,',..-,,,...-....,.:: 41 ,,,:-A::t.:,....-.,:-...F:-. i: •::z.:..-:-..,....,-,::::,-,--.:•-,-..--, .. •:-:.i, t j5-0bo u ) -t .I-,0.3!..4"..:e4..),141Z''....."•;F.'..:•••'-'....'''''-"' -.! ,'. $14.000.- ..: :-. kii;11!:.1:-75:cA70!A...P.,,.14.4;,",e-e-'44;7_,.,;:r...d.....'ictiir:ii.,.,.:-': ':;' ..:. '.,--;....°°° ',..... ':'!..:...-i.,',....,-.:.;-,' ',..7! ,..:,....'„1.,.',1;,...'...,..i.::',......1,'....6.-::.,,:„.:,::::;,,,..,:;ei..,.-.1.: 66......7,.'.,..- i'...(ii.arci.ikfai.e.anaSOftWa%ciggit .t7,..7.... .1661.)7.7.; :,!..:-. ..$770.ppc:.1 : ,yi9 ,..,.-.,., . iiiat---,'-..--"--0:--v."T6w,:kiivet-argi...:.:.!..;:,-eT.-0,..,„.,,,,,,,,,:. ...,:,..4. ..,41::;:...;•.',..:::.-.;::.:..:,..:.,;-:.::f...i.0"..i..,:4,..3.:1,,z..,:..• i-StAt) Yiertn.„.•,:,.,..,:-...'..:,.--`.-..1f...;-'4,,-,$.:-1:!,..pki.,,,L::1;,:..::';'-','-'4:7,.S--.....,-.'t!';:5-::-.I.:•';',:'::-:7;-.7-. :.... -,:-:•-•..--. 4-.1-':-,•,- .''''' 00 r-..,:,.......„,, ._:.cilt.,‘.--.41..--:.-.;c•-,:14---,::,,,,,..,41,..:.::.5.:±:..,-.1'..`..;.:!.1,-,1„.1-:....e.,.•;?'-';,-'21.- -Zzi..'::.:.-4•..:....:-.....:-,.:;..,;-,-,-....-1•7r.:-. :•,,,.,-,,,, ,: ,•:: -:..$8,5 !*:::"14tedlbitv.,Ehept.$,Q,TrytIP! ,;.at-,1.•::•4.?4•-• .-.,„,t•-,'7-----, --1 ..,, •:,.::::, ,.;•-•:%-,•;*$01 ;••••-.-.,•:- :??,?!.Y; 'i.I.,_.,,,„,"";-..,IPnetwork from :$?•,(4?9Af.-,..•.:•-••.::•:,::-.....:•-..-:::-::•::::-.4 :''.':i...,-''.,:f--•:'' .i...:-.-.:.1..-.-..-.'. 1:: '.. :..--.:..i..::= Separate SCADA••'-'.-7'' P-,:•••••:::-.-..:'...".--•.::,'::•:-•,!:•'::.-:::::':':!-:.:*.:.T.':••.:,:•-: t'-:::".-... .:'";.: kA' bi'-n'.. .—tn llre i--,-,ti„.-6r.,'k.„.--.:-..-..a,..''".—.t-Air ct...•e ?e304 , (41*R4 '••:;.•,..':4-,...'..'4:',.:•:,•-.`;', A:.„.:,..:,,.-,••:-...,•:i;:-%60:;.•.,:,,::',s•,••,-,•1;:F•,.:..:.•,:.-•:•.4,•.=,t.:,,.y7.',,i,,,:f;-1-•,-:.•':•-.•1•:•!*,?,:.-,.:-A,r:,-...§.:`4,."-;,i........n,,::y::z.,....:':;:: :1.:...::,-.:4:.•,-,,(,...,:,q.,.:,':c':*:i,-w,.'.l.-,7.i-,'.,-:7*..:f'_:',e-Y..-.F,:k...j?.:.:.'..:A.:-.11zv.,.-.•:,!::!.:,:;„:;;,,,.:.,:-::-;-.::•f•3,4.•.I:;•1.„.;.:,'.,..:--4......-.-......-;',;;.,:•-=-t,:t;*i:...-..f',..--$,4,,:.-,:,'..4:9.,.„,...,:...;,.:.:..:•5.,.,........:„:.,.::.,.%0:,,..:.:5.:.,.,;-,::-.:-'•:.,.•...:-:;•..•''...,-.:.:;!.7.'•,.::--',-::4..::'..-.7'A.:.f,.,•;I,--,.-.7, i-.T,.,, g.-.......,.•„:.,::b., y ettcat1er1 1 Reconfigure System 9'°°Q1 $0 $0 $9 000.•:.::.:.,i._7..- .:.,. .:.--'11,*,:....'•i..--.......,. .;,t.'•::-.",*.l.-,:r.,-;:,„:„:_,:k.:•,4.:.:;.4.):.;:2..Afoiftm'S'..1::.1-..e.:.::.:;;•:.r.-4:,,,,.::,:*;•,:ii.c$9.45,..g.-:,-,.:,.:?;;;;••::?,e•jy;y.!:.,1 -1.-.:,,,;,..,;k:.::::.. .-.:.•,...;,:4,........,,,:if,,-..&,,,,_•*-..4=0:--:„.4';',.1-6I:4*...4kgzfrj,..p40,1;,.)tifif;-ri..,i,ro.tvii:)•2;tr.:::trtii.,:kt... .,1:•;•11-- -;4!:i.;i:-.,gn:: ..i:-,,,:.:i1;,::::?.. .,::::: ::.3 '0a6.•:..ryiiteiii-fit4t)-(ii=.1.,ega.,?1,9P,TA,,v,,,•MaAgi;,,,,,ot•;%414:1; 11A-4-.I:4:::,:i.-v ,?6-i:-.A-isir,,,:',6';'''''' '''''''''''''..:'-..:--•-• -' „i,..,,,,„1:.?..,....:,,-4h.,:..:,-;,,-1, ,'•564,-,ii:::1455a,.4411zNe:=..*. fi'!',...'47.'...,.., 4,a'z,..::::_r4,,:,.:,......, f.4 ..-7s7.,.,,, -.-,: ,1: '::::..,,.;,;t, .... ,-. . ...et:ftC°Ver›,.'r.4.arkatel-44.• ..'s,''.‘i."-!/"?-'!'s ,, ..-,;;,■'=.1:..--.:-.:,..:t:.....:•..-,•...':':;`[:::,',":.:-r., • ,_: ,‘,..,:,,,,,,.., j..' •:'!"---"--'..,--.. -.`::::"'''4'1;- m,..:-... -,--g:tody:-::::=: 131,.i.500 '...s'!r :q":75v-sb-- iitlk,k.46,0;Q Poi-.1.:PI::: '..-.4:;:..i.7:: : :;..q...i..:72Y.,2 ::...:, , :.:;. '::.71.:.:6:4.rg.i.,:i....4 r..2 ,..,..r.t:4'sg:::':4*. 1%..l ... . ."- 1'.3 ''"'"'x's'''''- --- -.. -' : 1" ,..,..1.. ,.... ..„Ii2 ":•,•'•-1.:r'. .•:7.1.:iiine7:4*-1•citat.i Phase 2 Improvements . -,,i'-,-,c- t-ftre..,:4:,-,Hardware-:.:-:- .,..........-,,,4 ,.,..........,---,,,,,,,, .....T.Ti:,,:::,::::,::t6bt,x:::,..,:rf-',..?P-IA.:, r,-••. '-.1..,..„•..--,i, ,-;i.:,;:,,.-.:',•.-'.' .(=:i... i' .001;71 •,'.'-'.:-'• --'''•-• ' a .thrt:.:!..:.5-4';,,;....,,k"..-i::,-...;:.7.: . .,...1-1,:t1-./:..!-,:i..,*,!-■-•...-:5. :•Z:- S., .„,.,..,..,:erch.„.,-.::::1.,:?...Z.,: . ...%; pRecornrne.nd., ,,.., . . ,,.„..„,...„.:,F:-..,.4.,:$0.1..',.:i.. J -,-,■e:. ...:.: S•',. '•-•'''''''-44-'''''..' .' trien.rs.;fttv,.-F1 LPrii•-:-,1;...,D,-c.:....-.11:::.:-..*.!:-.•):: :•., : :.•:-..,-!•,:..1.-,.......:.,..:::,• --d,%.1 . ,:,:::.• •:. .•--, eillte;Sttk0IV-'i;...-...,,,.....,.:(:,.- v1.•• •ii..-..,.•;••••.--,.,,,,,-,....ill.*,*'• -.4..:'.i;q:•'.- '-'0;-€V.:','Zikii.pV• It .1.-twoi.;-.f.stal...'''.\''''.;4:P.''-r,3 '•'•''.•,';'•''''..-'-'-';'' :;•::';';:ia-•':''''r't '•'•':.-':';.,'•".”''..,''.'-,:i ... ;:.-,i., ,.: ,;:, :•':f'4).`,c;rrA. .Ar.,',"RiYff-',... ..Ti 1/4.44.t..,f,.ii:,''''.:Z .::::iii0,...i.);:rgi.,:: :.isq,.. . i:.;:..i.:..: . ::..7-......, 500...: i:-OkIf:-,1'.:1-1.1:."4ics±-1,:..:IPI'M':•tI.'..:4‘i),:.a:.:** 11"'-'''''''''' '.1';•;, :.: 7,. , 0 6).s.4:-',•: :.i'1- :'': '.P?,.1-..: 1:-.' ..- ,,,,,,,--:-;i,.-..',:',.4:-. .','''''' • ...:1-•'"' --ni-f.••••foe $21 000,. .%•‘-- .,:,,:,.-•::..?-.!•,:il....-:,, ';'--,.::::.::....•-•:,:,... :••.:;. ---:,•:.....: :" ,.•",-... Kc4e),00p:Ec:SCADA::..:.-.:)-.r.,..:. ,•-•:-.4..':::'••Z''•,-''''.-:'''.:.-".;''-:'''''''''''''''' ''.- it..,.%" '. :" ....' '"'' '''$17.5P'Ci -...:..scree....,.,,_.,....1.,,.,..„.,.......:•;,. ;., :„.. ...c . , !..,,,, .,:.,: .. ..: •„. .....,;..,„:„. ..., !2!. . • Riverside ,::::',...,:...:4;....f.,:,-.;.:•„,7,,iii.c ..i:;.:‘,?.*:::....i7q.7,t00;:;-..:•-:.,,;7;.;...i,,.-1 v.,?...p.,....:fr' ".,.i ;-:,-;t1,-k...-,',::::`•-.-.,i_;,.:7..:,-,,.;;,:i:,...-.:,--r-., :.-:=11;i :kria. dfl516f;Aliilitg; --,.Z.-;.!..?-','',.:.Y.:,..A.-. *;..•;.:';:;!:..4'....4.4..-f-,..."--::4- t'-?''-'''.•'''-'-,........-:, , :•:.:.:.:-$17 300 .: . .r:ReUetfe.,,p;!..,:•.,,,,,..-.,;,,:,.i.:.:.i.i.:-:::^..!..A.,..14•.,V.fit'ag-4.;-',:fz,,4, 31-:'h"-''.,`.-'.... : 5 000-: ..:•. ;..:*„:,-..;$300,,-. : --• !'.„.. .;..........;,.7,....;,,t4..4....(-,:i.t. :4:;::--. 4-t;t*-t..--.t....,•:--.:,4,•..... ::.$12000,•:::--,i5i::.-;-,-+._,f :•,,•••'•••-'•:-•:.*:,,,..t.-.,i'.:-•:.,•:.,z',--.*:•:: .... -:a tithitijp.1 erm0t,a-,:i:- T.... -,,,,•,.- -::,,,..-.,fr,•:,.--::.::'•• .-...:,-.: ..-•:: ..::...:;:,-.:,,, . .:'-....,....- 4,-. I,I6stapi:corf149T,...,.•:„........(,.....,:o..;;;;?:,;,::,.. ..::-..:ft.,,..:i....:::::,.1,..„•:.,:!;.3.*-;',:-.?.:::•-•'-::i••, ‘•-:.•,•. -- '•-•••,•.•:,:,,,+:-;•-th•••t.--:,-•%;..:1•-•,7*.::;....!.,...23i:000 Software-based:P(1rr9SrI.Sirk; .Virdik.H..:.. .:...--;'$.1-;00P2::::••,:,:,:: .-,,.:::{1.:::,: ,.t..A,::..., '..-,..•:.•-i.:,T-..•.,,x5.:::.-4 :'- FeiPg.irgfi4reV 140 0';','q, '.}:t,•34.,.f..i:.,:,,i.-1-i.i.t::.'.'i:i: : :...--:-ili0:"''•-•,V'-1. ,'::';':t.:;',:..sa,'V l:-.2,1••:.-:•:::'. .P.'-'-'fr'-'1.. DAqr..vicPO4tt.....,;,..-.4',I,oeK>:.:0:..i.i..,,--,0..:..:k.... .,A,:::;,:gf..4.::::•&-.:,,,.: .:s....•,..P.--ji..'1.•::".:.- -,.:!:..,:,:.2.'-.‘.• .. ...::.:: :.;:,$4-, 00;•,. c--"'•'.:.".'..--'....-.4,1igs.i.Ae.rivt,s•-•w;.wv...=';-tf,::..-,..,,:it---•=.3....f fr,,,,,,,-•'.. .,:.:: :.:.::;::$0:,-:‘.. ..::::.,,.7:-:.:.:.:;$300-:.:•-..:......., -....,.:.......-,-., . z•-.. .•. :..:$4(901','.:•.;. ':-•?7,'•:,!.•'-',.:::1',..::i .,'',:.:':-::'';'..6v::,:r.,:::-A.:"•"-'''','''"'-'i.i.••': •--:".'''-'•'''tsuliDA'-Se-tX1re':•,-temotp;',:•):.•.:-.•:. .:,::.....:::....!... ........:-..ii -: :. i-':•-:•••:•:.i!:.4:•-•:•....1 :•?::-.. ..,:•?. :-..-.:,::,...-:::::: ::*:-=:I,...:4::,:::•;4eg;.;;k.;.;.;,,:ii,,:ti,,*; !Tf?)...rr.1?...r.. ....v-t....:.;;!..::*,.--,:;.. ::::-.;!,:ik,::::::Aii:f.3.•;..j...algi.:?.:..: .-..1'...'-.::• •-k!.Ni',"Ii.:::,44.:•::!4',;h::.:ii...i.g I.:.-::‘,14z.-r.=A..,.:=$.1626%-m):16.60 en ''''1acCesP4.;:q. .4.4.-iii45.1'44;ik-te*titg:'141ifiFol!DIKOZ";TP9-[..-1114:00:4 -git ffS.1.ghtg..11..1#,I :-..-41g'i';IM'AtOi.;.tStibA;Rt4itf.'.44:410.:::..rt•tegfstAii:1-41...L .•,,,x,,,,,,.--.----. --• -- i :,:::':'r:::=I!';::a4P1:'.,Pj,:;!-!!:g'k,,.:?,:„=A,s4=.,,set;:;:‘o;:v::,4•ek,;•.s.-.0;,,,-.a3i.,,,,....,. ...,—• . ,,i5,•:t.,:-:v..3:,.,..:. ....... Upgrade ausl:,:h included Riverside as wTaPrioprity Two improvement,this is recommended to be performed at the same time as the SCADA Server 1 E (0,1„ ,' ATTACHMENT D City of Elgin, Illinois Water Department SCADA System Upgrade October 12, 2009 Supplemental Services Billing Information Following are a list of services associated with the SCADA System Upgrade project that the City may wish to pursue as optional services. B&W Control Systems integration's price to perform the additional services is based on the following information Hourly Billing Rate for BWCSI personnel • Project Manager $130-$150 • Senior Integrator $90-$120 • Integrator $80-$90 • Junior Integrator $70-$80 • Administrative Staff $50-$60 > Hourly rate is the same for regular hours, after hours, emergency service, weekend, rik holiday and overtime. Y There is no minimum call-out charge during regular business hours. There is a one hour minimum charge for after-hours service. Y Mileage for travel is billed at$0.55 per mile(round trip) as calculated from our Crystal Lake office to site visited during normal business hours, or from deployment location to the site visited for emergency service. Y Travel time Is charged at the same hourly billing rate indicated above. Optional/Supplemental Scope Items 13acicup Power Improvements ■ Provide uninterruptible power supplies (UPSs), as-needed, for each control panel currently not backed up by a UPS. Additional Information Technology(IT) Consulting ■ If the Water Department elects, BWCSt can perform additional IT services related to the separation of networks at Airlite and Riverside. City MIS staff may elect to make additional Virtual Local Area Network (VLAN), Internet Protocol (IP), Ethernet cabling, or fiber changes while the networks are being separated. BWCSI is available to assist during these changes. r • ATTACHMENT 0 October 12.2009 • If the City does not have RADIUS-based authentication for centralized authorization and accounting of remote access, BWCSI can assist City MIS staff with RADIUS configuration and setup. Additional SCADA C_Qnsulting& Development ■ BWCSI has created hundreds of different SCADA screens and dozens of reporting and automated process alarming systems for many different municipalities. We have found that many of our clients develop preferences and recommend changes after a new SCADA system has been configured and installed just because they don't know exactly what to expect or articulate needs before they know what they can get. if the City elects, BWCSI can be available to perform additional SCADA, Terminal Server, alarming, or general SCADA-related consulting, configuration, or development to modify the SCADA, dialing, or reporting applications after the system has been upgraded and installed (after staff have a chance to get used to the new system). • Many times during installation, we may discover non-optimal Programmable Logic Controller(PLC) code or controls. While PLC reprogramming is not included in the base proposal and fee for this project, our staff is able to assist Water Department staff with optional reprogramming of PLC code to improve Department operations. Optional PLC Redundancy Removal • BWCSI is confident that by separating the control from the administrative network (which is included in the Base Scope of Services), the control network will operate with less traffic, collisions, and network errors. However, the PLC redundancy modules themselves may still not function correctly at all times,so we have included as a Supplemental Service, the optional removal of the redundant PLCs to simplify the Water Department's operation and possibly reduce the number of false alarms associated with PLC failovers. We estimate this supplemental service will be not more than$11,000($10,000 labor and$1,000 materials)to complete. MAELGNC1090341•SCADA ASSESSMENT\10-INf'IATIONtIMPLEMENTATI0NW9C341 IMPLEMENTATION-ATTACHEMENT 0•SUPA SVC,DOCX Page 2 of 2 • r" ATTACHMENT E City of Elgin, Illinois Water Department SCADA System Upgrade October 12, 2009 City Responsibilities 1. Provide (existing)workstations to BWCSI configure SCADA Terminal Server access through. 2. Provide computer design criteria and assistance with server installation for all server replacements and existing workstation reconfigurations, Including any Active Directory/DNS/Domain configuration, as well as to provide the necessary Microsoft licenses and license activation keys. 3. BWCSI recommends that rack-mounted SCADA servers be used, if possible. City is to provide and install physical mounting hardware for the five rack-mounted servers,if rack mounting is preferred at Riverside or Airlite. 4. BWCSI will be providing rack-mountable industrial Ethernet switches (one for Riverside and one for Airlite). It is the City's responsibility to provide the necessary physical provisions inside the existing enclosure to rack mount the switches. 5. Provide network and Virtual Private Network design criteria and assistance with network reconfiguration at Riverside and Airlite, as well as remote access configuration details. 6. Provide administrative development access to a new Windows SQL 2005 or 2008 server database (BWCSI-created), as well as access to a Microsoft Windows IIS 6.0 or 7.0 website to create and develop the open-architecture SCADA reporting database and front-end. All SQL and IIS services should be better than 99.9% accessible from the SCADA servers. 7. 120 VAC power and network cabling is currently available at the four existing filter workstation locations,but City staff is responsible to extend and/or provide 120 VAC power and CAT5e (or fiber) network cabling as-required for the two (2) new Operator Interface Terminal enclosures in the filter gallery. City staff will also be responsible for deciding where the enclosures should be mounted, as well as physically mounting the enclosures. 8. Provide, in writing (email is fine) general input, feedback, and correspondence during screen,reporting,alarming,and general SCADA development. • r ATTACHMENT F City of Elgin, Illinois Water Department SCADA System Upgrade • October 12, 2009 Schedule Milestones Phase 1 Improvements Recommendation Projected Completion Date scAok Server Physical-Replacement, Terminat.Server Installation,OFR,and Netv-iock Separation Assumed Start Date 10/23/09 Finalize,design,&complete ordering all equipment _ 10/30/09 - Receive Equipment • 11/6/09 "Prep Servers:Base OS,84`14pplicatibn`s 11/12/09 Network Equipment(not servers)Install&Testing 11/13/09 41111) Networlt SeparatEon Test C toner • 11/20/09` s In-Office Application Server.Development • 11/27/09 Physicat Server`&Oil Installation 12/4/09. Soft Server Startup(leave old servers in place) 12/10/09 Test&Confirm Operation 17/24/09. Decommission Old Servers • January,2010 Reconfigure SCADA System Security: , Start Date 1/6/10 i . Define.Security Parameters 1/20/10 • Implement Security Concurrently w/New Screens 1/20/10 Lock Old Screens to read only-.; 2/19/10 Modify and Test SCADA Disaster Recovery Plan Start Date' 12/10/10 Develop Disaster Recovery Plan Outline 12/17/09 Draft:Disaster-Recgvery,Plan 4/23/10 Final Disaster Recovery Plan • 5/27/10 First Amendment ATTACHMENT F e al- Phase 2 Improvements ';.Recommendation __. __--..---.-.--------._-__-. _ Projected-_--- . _• - Comp)et'ior Date -; f Redevelopment of Screens 1/6/10 r s }........v ..eta.. j.L.._,I...L.:-„,,,. ..._..._ .__--_...... __.._.41”_-u=... _ .ii).....`..... Screen&Security Development Workshop . 1(6/10. 'fr e-tirninary Security&•Screen TemplatesSubm+ttal: . :1/20/10.. �J�..=�i_ "_ate.... .v ....•_ ' Final-Screen Submittal . 2/12/10 i Ins tall,-ConflgureS ftvuare"Alarning•^ Develop Preliminary Alarm List&Groups 2/19/10 Instaf;Software,Hardware,and Configure 3/5/10 i • Startup;testing,and Training . ' . ' 1 3/10/10 . Design Configure;Web-basediSCAF1A.Reporting' Develop Report List,Field List,and Data Sources I 3/5/10`- Install'Database•and Reporting Software Configure; 3/12/10 // Configure&Deploy one Test Report 3/19/10•(Mk. _... Coi-figure&Deploy�Other Reports, : _ ._ - 4/23110 '_: _ Complete Reports 5/20/10 • Impler>7ent Secure Remote Access R f Define access&security permissions 3/5/10 i i configure Remote Access.. 3/19/10. Provide Training 3/19/10 • First Amendment Page 2 of 2 ATTACHMENT D - Original Agreement 41111) AGREEMENT THIS AGREEMENT is made and entered into this /O'ay o ,2009,by and between the CITY OF ELGIN,an Illinois municipal corporation(hereinaft referred to as"CITY")andB&W Control Systems Integration, an Illinois Corporation(hereinafter referred to as"ENGINEER"). WHEREAS,the CITY desires to engage the ENGINEER to furnish certain professional services in connection with Water Department SCADA System Upgrades (hereinafter referred to as the PROJECT);and WHEREAS, the ENGINEER represents that he is in compliance with Illinois Statutes relating to professional registration of individuals and has the necessary expertise and experience to furnish such services upon the terms and conditions set forth herein below. NOW,THEREFORE, it is hereby agreed by and between the CITY and the ENGINEER that the CITY does hereby retain the ENGINEER for and in consideration of the mutual promises and covenants contained herein,the sufficiency of which is hereby acknowledged to act for and represent it in the engineering matters involved in the PROJECT as described herein,subject to the following • terms and conditions and stipulations,to-wit: 1. SCOPE OF SERVICES Phase I A. All work hereunder shall be performed under the direction of the Water System Superintendent of the CITY,herein after referred to as the"SUPERINTENDENT" B. Outline of the services to be provided by the Engineer is: ENGINEER shall provide the services to the CITY for the PROJECT as outlined herein and as detailed in Attachment A hereto. 1. Meet with the City staff to discuss the SCADA System and layout of the project goals and objectives. 2. Review the current SCADA System. 3. Evaluate PLC data links,Ethernet and Radio System. 4. Evaluate Networking and bandwidth issues. 5. Evaluate Alanns. 6. Evaluate Reporting,collection of data and data storage. 7. Evaluate Security and backups. S. Evaluate Power Reliability. 9. Evaluate Computer Hardware and Operating Systems. 10. Evaluate the upgrade of the FIX 32 software to the current version of iFIX platform. 11. Review the software packages including the bulk water software, XLReporter software and Concept 2.2 software for compatibility with future computers operating system. 12. Formulate a plan of action to achieve the goals of the upgrade and submit 5 copies of the final SCADA evaluation report. C. A detailed Scope of Services for phase I is attached hereto as Attachment A. D. Phase II of the project will include the installation of the hardware and software and the system integration based on the final report and recommendation from the City oC Elgin, Illinois Water Department SCP.DA Upgrade - 1 - May2009 Al) • • ENGINEER and accepted by the City. A detailed scope of the services will be developed based on the final findings. 2. • PROGRESS REPORTS A. An outline project milestone schedule is provided hereinunder. Project Kick-off Meeting • June 15,2009 SCADA System Evaluation and Design July 27, 2009 Final Report August 4, 2009 B. A detailed project schedule for the Project is included as Attachment B, attached hereto. Progress will be recorded on the project schedule and submitted hi-monthly as a component of the Status Report described in C below. C. The ENGINEER will submit to the SUPERINTENDENT attached to the payreqest a monthly status report keyed to the project schedule.A brief narrative will be provided identifying progress, findings and outstanding issues. 3. WORK PRODUCTS All work products prepared by the ENGINEER pursuant hereto including,but not limited to, reports, designs, calculations, work drawings, studies, photographs, models and recommendations shall be the property of the CITY and shall be delivered to the CITY upon request of the SUPERINTENDENT provided, however, that the ENGINEER may retain copies of such work products for its records. Such work products are not intended or represented to be suitable for reuse by the CITY on any extension to the PROJECT or on any other project, and such reuse shall be at the sole risk of the CITY without liability or legal exposure to the ENGINEER. 4. PAYMENTS TO THE ENGINEER(Lump Sum Method) A. • The CITY shall reimburse the ENGINEER for services under this Agreement a lump •sum of Thirteen Thousands and Six Hundred Fifty Dollars($13,650),regardless of actual Costs incurred by the ENGINEER unless substantial modifications to the project are authorized in writing by the SUPERINTENDENT. B. The CITY shall make periodic payments to the ENGINEER based upon actual progress within 30 days after receipt and approval of invoice. Said periodic payments to the ENGINEER shall not exceed the amounts shown in the following schedule, and full payments for each task shall not be made until the task is completed and accepted by the SUPERINTENDENT. Payment Schedule Payment Invoice Date Value I. July 24,2009 $10,250 2. -August 2I,2009 $3,400 Total Contract: $13,650.00 A detailed Level of Effort and Associated Cost is attached hereto as Attachment C. City of Elgin, Illinois Water Deport:%nt SCADA Upgrade - 2 - • • 5. INVOICES A. The ENGINEER shall submit invoices in a format approved by the CITY. Progress reports_(2C above)will be included with all payment requests. B. The ENGINEER shall maintain records showing actual time devoted and cost incurred. The ENGINEER shall permit the authorized representative of the CITY to inspect and audit all data and records of the ENGINEER for work done under this Agreement. The ENGINEER shall make these records available at reasonable times during the Agreement period, and for a year after termination of this Agreement. 6. TERMINATION OF AGREEMENT Notwithstanding any other provision hereof,the CITY may terminate this Agreement at any time upon fifteen (15) days prior written notice to the ENGINEER. In the event that this Agreement is so terminated,the ENGINEER shall be paid for services actually performed and reimbursable expenses actually incurred prior to termination,except that reimbursement shall not exceed the task amounts set forth under Paragraph 4 above. 7. TERM This Agreement shall become effective as of the date the ENGINEER is given a notice to proceed and,unless terminated for cause or pursuant to Article 5,shall be deemed concluded on the date the CITY determines that all of the ENGINEER's work under this Agreement is completed. A determination of completion shall not constitute a waiver of any rights or claims which the CITY may have or thereafter acquire with respect to any term or provision of the Agreement. 8. NOTICE OF CLAIM 411) If the ENGINEER wishes to make a claim for additional compensation as a result of action taken by the CITY,the ENGINEER shall give written notice of his claim within 15 days after occurrence of such action. No claim for additional compensation shall be valid unless so made. Any changes in the ENGINEER's fee shall be valid only to the extent that such changes are included in writing signed by the CITY and the ENGINEER. Regardless of the decision of the SUPERINTENDENT relative to a claim submitted by the ENGINEER, all work required under this Agreement as determined by the SUPERINTENDENT shall • proceed without interruption. 9. BREACH OF CONTRACT If either party violates or breaches any term of this Agreement,such violation or breach shall be deemed to constitute a default, and the other party has the right to seek such administrative,contractual or legal remedies as may be suitable to the violation or breach; and,in addition, if either party,by reason of any default,fails within fifteen(15) days after notice thereof by the other party to comply with the conditions of the Agreement,the other party may terminate this Agreement. 10. INDEMNIFICATION • To the fullest extent permitted by law,ENGINEER agrees to and shall indemnify,defend and hold harmless the CITY,its officers,employees,agents,boards and commissions from and against any and all claims, suits,judgments, costs, attorneys fees, damages or other relief,• including but not limited to workers compensation claims, in any way resulting from or City of Elgin, rl3inois Bate. Department SCT.1A upgrade -3 arising out of negligent actions or omissions of the ENGINEER in connection herewith, including negligence or omissions of employees or agents of the ENGINEER arising out of the performance of this Agreement. In the event ofany action against the CITY,its officers, employees, agents, boards or commissions, covered by the foregoing duty to indemnify, defend and hold harmless such action shall be defended by legal counsel of the CITY's choosing. The provisions of this paragraph shall survive any expiration,completion and/or • termination of this Agreement. I1. NO PERSONAL LIABILITY No official,director, officer,agent or employee of the CITY shall be charged personally or held contractually liable under any term or provision of this Agreement or because of their execution,approval or attempted execution of this Agreement. 12. INSURANCE A. • Comprehensive Liability. The ENGINEER shall provide,pay for and maintain in effect,during the term of this Agreement,a policy of comprehensive general liability insurance with limits of at least SI,000,000 aggregate for bodily injury and $1,000,000 aggregate for property damage. The ENGINEER shall deliver to the SUPERINTENDENT a Certification of Insurance naming the CITY as additional insured. The policy shall not be modified or terminated without thirty (30) days prior written notice to the SUPERINTENDENT. The Certificate of Insurance which shall include Contractual obligation assumed by the ENGINEER under Article 10 entitled"Indemnification"shall be provided. This insurance shall apply as primary insurance with respect to any other insurance or . self-insurance programs afforded to the CITY. There shall be no endorsement or modification of this insurance to make it excess over other available insurance; • alternatively,if the insurance states that it is excess or prorated,it shall be endorsed to be primary with respect to the CITY. B. Comprehensive Automobile Liability. Comprehensive Automobile Liability Insurance covering all owned,non-owned and hired motor vehicles with limits of not less than S500,000 per occurrence for damage to property. C. Combined Single Limit Policy. The requirements for insurance coverage for the general liability and auto exposures may be met with a combined single limit of $1,000,000 per occurrence subject to a S I,000,000 aggregate. D. Professional Liability. The ENGINEER shall carry Engineers Professional Liability Insurance Covering claims resulting from error,omissions or negligent acts with a combined single limit of not less than $1,000,000 per occurrence. A Certificate of Insurance shall be submitted to the SUPERINTENDENT as evidence of insurance protection. The policy shall not be modified or terminated without thirty(30) days prior written notice to the SUPERINTENDENT. City oC Elgin, Illinois t:a:er Department SCAPA Upgrade -4 - 13. CONSTRUCTION MEANS,METHODS,TECHNIQUES,SEQUENCES, • PROCEDURES AND SAFETY The ENGINEER shall not have control over or charge of and shall not be responsible for construction means,methods,techniques,sequences or procedures,or for safety precautions • • and programs in connection with the construction,unless specifically identified in the Scope of Services. 14. NONDISCRIMINATION • In all hiring or employment made possible or resulting from this Agreement,there shall be no discrimination against any employee or applicant for employment because of sex,age,race, color,creed,national origin,marital status,of the presence o f any sensory,mental or physical handicap, unless based upon a bona fide occupational qualification, and this requirement shall apply to, but not be limited to, the following: employment advertising, layoff or -termination,rates of pay or other forms of compensation and selection for training,including apprenticeship. No person shall be denied or subjected to discrimination in receipt of the benefit of any services or activities made possible by or resulting from this Agreement on the grounds of sex;race,color,creed,national origin,age except minimum age and retirement provisions, marital status or the presence of any sensory,mental or physical handicap. Any violation of this provision shall be considered a violation of a material provision of this Agreement and shall be grounds for cancellation, termination or suspension, in whole or in part, of the Agreement by the CITY. 15. ASSIGNMENT AND SUCCESSORS This Agreement and each and every portion thereof shall be binding upon the successors and 4111) the assigns of the parties hereto; provided, however, that no assignment shall be made without the prior written consent of the CITY. 16. DELEGATIONS AND SUBCONTRACTORS Any assignment,delegation or subcontracting shall be subject to all the terms,conditions and other provisions of this Agreement and the ENGINEER shall remain liable to the CITY with respect to each and every item,condition and other provision hereof to the same extent that the ENGINEER would have been obligated if it had done the work itself and no assignment, delegation or subcontract had been made. Any proposed subcontractor shall require the CITY's advanced written approval. 17: NO CO-PARTNERSHIP OR AGENCY This Agreement shall not be construed so as to create a partnership, joint venture, employment or other agency relationship between the parties hereto. 18. SEVERABILITY The parties intend and agreed that,if any paragraph,sub-paragraph,phrase,clause or other provision of this Agreement, or any portion thereof, shall be held to be void or otherwise unenforceable,all other portions of this Agreement shall remain in full force and effect. City of C)gin, i1.incie Water Department SCA.DA Upgrade - 5 - r O. HEADINGS The headings of the several paragraphs of this Agreement are inserted only as a matter of convenience and for reference and in no way are they intended to define,limit or describe the scope of intent of any provision of this Agreement,nor shall they be construed to affect in any manner the terms and provisions hereof or the interpretation or construction thereof 20. MODIFICATION OR AMENDMENT This Agreement and its attachments constitutes the entire Agreement of the parties on the subject matter hereof and may not be changed,modified,discharged or extended except by written amendment duly executed by the parties. Each party agrees that no representations or - warranties shall be binding upon the other party unless expressed in writing herein or in a duly executed amendment hereof,or change order as herein provided. 21. APPLICABLE LAW This Agreement shall be deemed to have been made in,and shall be construed in accordance with the laws of the State of Illinois. Venue for the resolution of any disputes or the enforcement of any rights pursuant to this Agreement shall be in the Circuit Court of Kane County,Illinois. • 22. NEWS RELEASES rilk The ENGINEER may not issue any news releases without prior• approval froth the SUPERINTENDENT,nor will the ENGINEER make public proposals developed under this Agreement without prior written approval from the SUPERINTENDENT prior to said documentation becoming matters of public record. 23. COOPERATION WITH OTHER CONSULTANTS The ENGINEER shall cooperate with any other consultants in the CITY's employ or any work associated with the PROJECT. 24. INTERFERENCE WITH PUBLIC CONTRACTING The ENGINEER certifies hereby that it is not barred from bidding on this contract as a result of a violation of 720 ILCS 5/33E et seq. or any similar state or federal statute regarding bid rigging. 25. SEXUAL HARASSMENT As a condition of this contract,the ENGINEER shall have written sexual harassment policies that include, at a minimum, the following information: A. the illegality of sexual harassment; B. the definition of sexual harassment under state law; C. a description of sexual harassment,utilizing examples; D. the vendor's internal complaint.process including penalties; r City of Clair, 11.linoSs Hater Department SCADA Upgrade - 6- r • • • E. the legal recourse,investigative and complaint process available through the Illinois Department of Human Rights,and the Illinois Human Rights Commission; F. directions on how to contact the department and commission; G. protection against retaliation as provided by Section 6-101 of the Human Rights Act. A copy of the policies shall he provided by ENGINEER to the Department of Human Rights upon request 775 ILCS 5/2-105. 26. WRITTEN COMMUNICATIONS All recommendations and other communications by the ENGINEER to the SUPERINTENDENT and to other participants which may affect cost or time of completion shall be made or confirmed in writing. The SUPERINTENDENT may also require other recommendations and communications by the ENGINEER be made or confirmed in writing. 27. NOTICES All notices, reports and documents required under this Agreement'shall be in writing and shall be mailed by First Class Mail,postage prepaid,addressed as follows: A. As to CITY: Kyla Jacobsen Water System Superintendent 4411)City of Elgin 150 Dexter Court Elgin, Illinois 60120-5555 B. As to ENGINEER: Christopher T. Sosnowski,PE, MCP General Manager/Project Manager B&W Control Systems Integration 8678 Ridgefield Road Crystal Lake, IL 60012• • City of Elgin, Illinois 4111) Water !)apartment SCACJ Upgrade - 7- r 28. COMPLIANCE WITH LAWS Notwithstanding any other provision of this AGREEMENT it is expressly agreed and understood that in connection with the performance of this AGREEMENT that the ENGINEER shall comply with all applicable Federal,State,City and other requirements of law,including,but not limited to,any applicable requirements regarding prevailing wages, • minimum wage, workplace safety and legal status of employees. Without limiting the foregoing, ENGINEER hereby certifies, represents and warrants to the CITY that all ENGINEER'S employees and/or agents who will be providing products and/or services with respect to this AGREEMENT shall be legal residents of the United States. ENGINEER shall also at its expense secure all permits and licenses, pay all charges and fees and give all notices necessary and incident to the due and lawful prosecution of the work, and/or the products and/or services to be provided for in this AGREEMENT. The CITY shall have the right to audit any records in the possession or control of the ENGINEER to determine ENGINEER'S compliance with the provisions of this section. In the event the CITY proceeds with such an audit the ENGINEER shall make available to the CITY the ENGINEER'S relevant records at no cost to the CITY. IN WITNESS WHEREOF,the parties hereto have entered into and executed this agreement • effective as of the date and year first written above. FOR THE CITY: • FOR THE ENGINEER: r — By Y City t arrab F (,- ,. Attest: City Clerk (ilk City of Elgin, I11i.noio Dater Department SC7 AA Upgrade - 8 - Attachment A • City of Elgin, Illinois • Water Department SCADA System Upgrade 2009 Phase I for the Water Department SCADA System upgrade shall consist of the following: Current System Evaluation: The System Evaluation shall include but not limited to the following tasks: 1. Meet with the City staff to discuss the SCADA and layout of the project goals and objectives. 2. Review the current SCADA system. This includes the following tasks: • database design • tagging • node names • window setup • redundancy setup • remote nodes • graphic screens • Standards • Screen Layouts 3, PLC data links, Ethernet, Radio System: Al) • Driver setup • PLC data table • Routing • Functionality and capability of the existing Modicon PLC's. • Spread Spectrum Radio communication 4. Networking, Bandwidth issues: • Switches,Routers and hubs • Wire to fiber connectors • Bottlenecks • Collisions • TCP/IP setup • Fiber Optic Lines • Microwave 5. Alarms: • Annunciation/Responses • • Levels/Categories of alarms • Nuisance alarms Water Department SCADA Upgrade 2009 1 • . 6. Reporting,Collection of Data, Storage: • Database type • Amount of data • Historian 7. Security and backups • Cyber security • Data integrity 8. Power Reliability • State of current UI'S's • Common points of failures 9. Computer Hardware, Operating Systems • Domain Controllers • Time Synching • Servers Setup • Redundancy of the servers 10. Evaluate the upgrade of the FIX 32 software to the current version of iFIX platform, or any other recommended software packages. 11. Review the software packages including the bulk water software, XLReporter reporting software and Concept 2.2 for compatibility with the future computers operating system. 12. Formulate a plan of action to achieve the goals of the upgrade and Submit 5 copies of the report that shall include the evaluation findings, recommendation,plan of action,and the upgrade implementation steps taken to ensure continuous operation of the existing system. 1Vaicr Depailinenl SCADA Upgrade 2OU') 2 411) • Attachment B • City of Elgin, Illinois • Water Department SCADA System Upgrade 2009 Following is the proposed schedule for Phase I of the Water Department SCADA System upgrade(all dates are 2009): Date(s) Action 6/15 Kickoff Meeting 6/22 —7/10 Make assessment visits and meet with.City staff to obtain SCADA system information. 7/13—7/20 Assess data and develop draft report. • 7/20 Submit draft report to City for review. 7/27—7/31 Revise report based on review comments from City. 8/4 Submit Final Report. I wait,Depaitment SCADA Upgrade 2009 1 '41111) s 1 hit.'?r: _.. L. .: �i: -r. S:1 t. , t,-, -r- x any r $ .; ..i. ATTACHMENT C • 6&W Control Systems Integration 8678 Ridgefield Road Crystal Lake.IL 60012 _�_ _ ._" _�� 815-788.3600 oIIite 815.455.0450 tar. };, si doe Peter Bityou May 18,2009 Water Operations Engineer City of Elgin 150 Dexter Ct. Elgin, IL 60120 Subject: SCADA System Upgrades BWCSI Job No. 090341 Dear Peter: Following is our Scope of Services and associated Fee to provide a thorough evaluation and analysis of the City's water Supervisory Control and Data Acquisition (SCADA)system. Scope of Services Proiecr Management rib' . • Manage project activities, such as schedule and budget to ensure project is complete on time and meets the City's expectations. a Attend kickoff meeting to confirm scope details of the project, discuss functionality of the existing SCADA system and known areas for improvement. ■ Attend report comments meeting to discuss the draft report and respond to comments and questions that the County may have regarding the report before finalizing. Site Visits • Visit the Riverside WTP and Airlite WTP to gather data on the existing SCADA system as required to evaluate and assess the SCADA system as defined in the City's RFP. • Work with City Staff to analyze the City's existing SCADA Ethernet network. • Label SCADA-related networking cable that is not labeled. • Document SCADA-related Layer 3 (IP addressing) information. Preliminary Design • Evaluate and assess the information obtained during the site visit and develop recommendations and a preliminary design for SCADA system improvements. ellPhk • • f • v F 7 :T � _ ._. � v ov.. C t ) fit ' -*1 4: /K�.. K.CG �C.4'�� J' . 1, • . I B&W Control Systems Integration Page 2 of 2 City of Elgin •090341 Report • Organize the data and recommendations in a report that will include the following: • Summary and assessment of the existing SCADA system hardware and software. • SCADA system preliminary design information. • Data collecting and reporting system process analysis and recommended improvements. • SCADA network diagram using object oriented software (Microsoft Visio), including Layer 3 network documentation. • Budgetary cost estimate for recommended improvements, • Prioritization of improvements. • Fee Our fee for the above scope of services is a lump sum of$13,650. Very truly yours, B&W CONTROL SYSTEMS INTEGRATION, LLC Nth,,,,$)D vb,,_, Michael D. Klein, P.E. Operations Manager MDK IdAELCINCO9934 I. CAOAhSSCSSIAENT10.1NITIN' MGAEEFILI:TLVT C•5CC1P1 ANDF&E i CrTEfi.DOCY. ■