09-245 Resolution No. 09-245
RESOLUTION
AUTHORIZING EXECUTION OF AMENDMENT NO. 1 TO THE
ENGINEERING SERVICES AGREEMENT WITH B & W CONTROL SYSTEMS
INTEGRATION, INC. FOR WATER PLANT SUPERVISORY CONTROL AND
DATA ACQUISTION SYSTEM UPGRADE
BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF ELGIN, ILLINOIS,that
Sean R. Stegall, City Manager, and Diane Robertson, City Clerk, be and are hereby authorized and
directed to execute Amendment No. 1 to the Engineering Services Agreement on behalf of the City
of Elgin with B& W Control Systems Integration,Inc. for the Water Plant Supervisory Control and
Data Acquisition System Upgrade, a copy of which is attached hereto and made a part hereof by
reference.
s/Ed Schock
Ed Schock, Mayor
Presented: November 18, 2009
Adopted: November 18, 2009
Vote: Yeas: 7 Nays: 0
Attest:
s/Diane Robertson
Diane Robertson, City Clerk
FIRST AMENDMENT AGREEMENT
This Amendment Agreement No. 1 is hereby made and entered into this I g' day
of 411Ange 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. Phase 2.
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. 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 47(e/iota. By
y Manager Engine•r
Attest:
City Clerk
- 2 -
, A Tr4 oHMEivr •A
AGREEMENT
THIS AGREEMENT is made and entered into this /O7ay 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.
I. 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 Alarms.
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 of Elgin, Illinois
Water Department SCADA Upgrade - I - May2009
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 bi-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
1. July 24, 2009 $10,250
2. August 21, 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 Department SCAM: 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
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 ofhis 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, Illinois
Water Department SCADA 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 of any 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
tennination of this Agreement.
11. 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 $1,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 $500,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 $1,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 of Elgin, Illinois
Water Department SCADA 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 of 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
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 assiWument,
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 Elgin, 11 .inois
Water Department SCADA Upgrade - 5 -
19. 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 he 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
The ENGINEER may not issue any news releases without prior approval from 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;
City of Elgin, Illinois
Water Department SCADA Upgrade - 6 -
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 be 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
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
Water Department SC@t)A. upgrade - 7 -
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:
City anal:, (
Attest:
City Clerk
City of Elgin, Illinois
Water Department SCA.DA 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:
I. 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:
• 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
• CoIlisions
• TCP/IP setup
• Fiber Optic Lines
• Microwave
5. Alarms:
• Annunciation/Responses
• Levels/Categories of alarms
• Nuisance alarms
Water Department SCADA Upgrade
2009
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 UPS'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.
Water Depaiiment SCADA Upgrade
2009 2
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.
•
Water Department SCADA Upgrade
2(109
ATTACHMENT C
•
rS&W Control Systems Integration
8678 Ridgefield Road•Crystal Lake,IL 60012
815.788.3600 office . 815 455.0450 fax v: .t:_bwcsi.con)
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
Project Management
• Manage project activities, such as schedule and budget to ensure project is
complete on time and meets the City's expectations.
• 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.
•
rB&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 Visit)),
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
l WD
Michael D. Klein, P.E.
Operations Manager
MDK
M.EL GNNQbg3341•SCADAAS SESSMENT:10-INITIATIOa1MGREER!ENTIATT C-SCOPE AND FEE LETTER.DOCX
•
ATTACHMENT B
City of Elgin, Illinois
Water Department SCADA System Upgrade
October 12, 2009
Scope of Services - Phase 1 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.
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
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 iFIX 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
•
ATTACHMENT B
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
RAID5.
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'FIX 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.
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®Xeon,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/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 WTP
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 OITs
30. Provide two (2) Allen-Bradley PanelView Plus 1250 color touch-screen operator
interface terminals (OITs).
31. Provide two(2)wall-mount enclosures for the OITs.
32. Install OITs 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.
Page 3 of 5
•
ATTACHMENT B
October 12,2009
34. Develop graphics for the OITs to allow operations staff to control filter operations.
Scope of Services - Phase H 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 Install Software-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
Page 4 of 5
•
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:V£LGNC1090341-SCADA ASSESSMENT110-INITIATIONUMPL£MENTATION1090341 IMPL-ATT B-SCOPE.DOCX
Page 5 of 5
•
ATTACHMENT C
City of Elgin, Illinois
Water Department SCADA System Upgrade
•
October 12, 2009
Fee
Phase 1 Improvements
Recommendation Labor Software SI, Hardware : Line Total
Replace SCADA Servers t"Riverside $18,000 $9,000 $14,000 $41,000
(hardware and software upgrade)."
Replace "SCADA.Servers".at Airlite . $14,000 ' $7,000 , . $14,000 $35,000
(hardware and software upgrade}
install SCADA germinal Sewer anal $6,000 $7,000 $4,500 $17,500
,
related thin-client software
Separate SCADA PLC network from $2,000 $0 $6,500 ` $8,500
Admin network at Airlite
Separate SCADA PLC network from $4,000 $0 $9,500 $13,500
Adrrtin network at Riverside
Reconfigure SCADA System Security '' '.6,000,.. $0 $0 - $9,000
Develop and testa Simple SCADA $7,000 $0 $0 $7,000
Disaster Recovery Plan
Sub Totals $60,000 ,. $23,000 $48,500
31,500
Phase 2 Improvements .
Recommendation Labor Software Hardware : Line Total
Replace SCADA Clients in Filter $10,000 $0 $11,500 $21,500
Room at Riverside ;WTP with two` ,-
OIT51
Redevelop SCADA`; screens for $21,000 $500 $0. '-.•• $21,500
Riverside
Redevelop SCADA screens forAirlite $17 000 $500
,..,s; � .,�. $0 $17,500
Install, configure, and implement a' $12,000 " $5,000 , $300 $17,300
Software-based Alarm System
Design,configure,anew Web used; $22,000 $1,000 $fl $23,000
SCADA Reporting System
Implement a SCADA secure remote' $4,000 : $0 $300 $4,300
access system
Sub Totals $91,500 $7,000 $12,100 $120,000
Previously included as a Priority Two improvement,this is recommended to be performed at the same time as the SCADA Server
Upgrade at the Riverside WTP.
•
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,
holiday and overtime.
L There is no minimum call-out charge during regular business hours. There is a one
hour minimum charge for after-hours service.
➢ 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
Backup 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, BWCSI 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.
•
I ATTACHMENT D
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 Consulting& 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.
M:IELGNC1090341•SCADA ASSESSMENT110-INITIATIONIIMPLEMENTATION1090341 IMPLEMENTATION-ATTACHEMENT O-SUPP SVC.DOCX
Page 2 of 2
•
V 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.
• •
•
Fra) ATTACHMENT F
City of Elgin, Illinois
Water Department SCADA System Upgrade
October 12, 2009
Schedule Milestones
Phase 1 Improvements
Recommendation Projected
Completion Date
SCADA Server Physical Replacement, Terminal Server
Installation,Offs,and Network 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&Applications 11/12/09
Network Equipment(not servers)Install&Testing 11/13/09
Network Separation Test Cutover 11/20/09
In-Office Application Server Development 11/27/09
Physical Server&OIT Installation 12/4/09
Soft Server Startup(leav a old servers
_., in place) 12/10/09
Test&Confirm Operation 12/24/09
Decommission Old Servers January,2010
Reconfigure SCADA System Security
Start Date 1/6/10
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 Recovery Plan 4/23/10
Final Disaster Recovery Plan 5/27/10
First Amendment
ATTACHMENT F
•
ra)
Phase 2 Improvements
Recommendation Projected
Completion Date
Redevelopment of Screens 1/6/10
Screen&Security Development Workshop 1/6/10
Preliminary Security&Screen Templates Submittal 1/20/10
Final Screen Submittal 2/12/10
Install,Configure Software Alarming
Develop Preliminary Alarm List&Groups 2/19/10
Install Software,Hardware,and Configure 3/5/10
Startup,testing,and Training 3/10/10
Design,Configure,Web-based SCADA Reporting
Develop Report List,Field List,and Data Sources 3/5/10
Install Database and Reporting Software Configure 3/12/10
Configure&Deploy one Test Report 3/19/10
Configure&Deploy Other Reports 4/23/10
Complete Reports 5/20/10
Implement Secure Remote Access
Define access&security permissions 3/5/10
Configure Remote Access 3/19/10
Provide Training 3/19/10
First Amendment
Page 2 of 2
ii
¢`_ .% City of Elgin Agenda Item No. fr►
t
0
J 0 ,,,,..„„...„,.,z,„, ,: ,,_, ,,
0) i 4,_)_ , , _ --------
October 29,2009 G _
TO: Mayor and Members of the City Council
,I f I ct uA I2rs�urtr
FROM: Sean R. Stegall, City Manager �A.
Kyla Jacobsen, Water System perintendent
SUBJECT: First Amendment to Engineering Services Agreement with Baxter and Woodman
for the Water Plant Supervisory Control and Data Acquisition System Upgrade
PURPOSE
The purpose of this memorandum is to provide the Mayor and members of the City Council with
information to consider adopting the First Amendment to the engineering services agreement
with Baxter & Woodman Control System Integration for the implementation of the upgrades to
the Water Department Supervisory Control and Data Acquisition system.
RECOMMENDATION
rIt is recommended that the City Council approve the First Amendment to the engineering
services agreement with Baxter & Woodman Control Systems Integration (BWCSI) for the
implementation of the upgrades to the Water Department Supervisory Control and Data
Acquisition(SCADA) System in the amount of$252,100.
BACKGROUND
In June 10, 2009, the City entered into an agreement with BWCSI for the evaluation of the
SCADA system and developing a plan for upgrading the SCADA system that controls the water
operations. That agreement contemplated later amendments to BWSCI's scope of services
depending on the findings derived from the SCADA evaluation.
The attached first amendment consists of two phases, phase one includes the replacement of
SCADA servers at Riverside and Airlite Water Treatment Plants (WTP); provide and install the
updated software (Proficy iFIX software); install SCADA Terminal Server and related thin-client
software; separate SCADA PLC network from administration network at Riverside and Airlite
WTP; and reconfigure SCADA System security and develop and test a SCADA Disaster
Recovery Plan. Phase two includes replacing the SCADA clients in Filter area at Riverside WTP
with two Operator Interface Terminals; redeveloping SCADA screens for Riverside and Airlite
WTP; installing, configuring and implementing a software based alarm system; and designing
and configuring a new SCADA reporting system. The agreement includes some supplemental
rio■ items that are available to the City if they become necessary. The first amendment identifies the
First Amendment with BWCSI, SCADA Upgrade - • ' i.
October 29, 2009
Page 2
City's responsibilities as described in attachment E to the amendment. A copy of the first
amendment is attached. The cost of phase one is $131,500 and the cost of phase two is
$120,600. The total cost of both phases of the first amendment is $252,100.
COMMUNITY GROUPS/INTERESTED PERSONS CONTACTED
None
i f„ FINANCIAL IMPACT
The cost of the first amendment with BWCSI is $252,100. There are sufficient funds budgeted
($350,000) and available ($350,000) in the water portion of the 2008 General Obligation Bond
Fund,account number 368-4000-795.92-46,project number 429500, "SCADA System Upgrade"
to fund the first amendment to the engineering services agreement.
L GAL IMPACT
None
ALTERNATIVES
1. The City Council may choose to approve the First Amendment to the Engineering
Services Agreement with Baxter&Woodman Control Systems Integration.
2. The City Council may choose not to approve First Amendment to the Engineering
Services Agreement with Baxter&Woodman Control Systems Integration.
Respectfully submitted for Council consideration.
KBJ
Attachment
1
�.4 OF EtC
(.0 ,, •�'ti Memorandum
o City of Elgin
.... ,
--RA TED0,��r.
Date: December 4, 2009
To: Peter Bityou, Water Operations Engineer
From: Jennifer Quinton, Deputy City Clerk
Subject: Resolution No. 09-245, Adopted at the November 18, 2009, Council Meeting
Enclosed you will find the agreement listed below. Please retain a copy for your records. If you
have any questions please feel free to contact our office 847-931-5660 and we will do our best to
assist you. Thank you.
• Amendment No. 1 to the Engineering Services Agreement with B & W Control
Systems Integration, Inc. for Water Plant Supervisory Control and Data
Acquisition System Upgrade