The URL can be used to link to this page

Home My WebLink AboutITEM V-C-4 CITY OF -.1' AGENDA BILL APPROVAL FORM - - 00 WASHINGTON Agenda Subject: Consultant Agreement No. AG-C-401 Date: February 1, 2011 Department: Attachments: Budget Impact: Public Works Scope of Work Summary, Budget $ 0.00 Status Sheet, Ma Administrative Recommendation: City Council grant permission to enter into Consultant and Technology Services Agreement No. AG-C- 401 with Technical Systems, Inc. for Technology Improvements for Project No. C524A, SCADA System Improvements. Background Summary: This scope includes Professional and Technology Installation Services for the upgrade of the City of Auburn's Supervisory Control and Data Acquisition (SCADA) System, this work includes the design of the physical site improvements (construction to be bid as a separate construction contract), the design and installation of electronic security and lighting improvements identified for selected sites, and the replacement of the existing telemetry system with new PLC based RTLls. See the attached Scope of Work Summary for additional details. The not-to-exceed amount for this agreement is $4,099,621.43 For all funding sources, a budget adjustment to carry forward the unexpended funds from 2010 to 2011 will be required. A project budget contingency of $85,133 remains in the 430 fund; A project budget contingency of $565,695 remains in the 431 fund; A project budget contingency of $414,824 remains in the 432 fund. W0207-3 A3.16.9, 04.8.1 C524A Reviewed by Council & Committees: Reviewed by Departments & Divisions: ❑ Arts Commission COUNCIL COMMITTEES: ❑ Building ❑ M&O ❑ Airport ❑ Finance ❑ Cemetery ❑ Mayor ❑ Hearing Examiner ❑ Municipal Serv. ❑ Finance ❑ Parks ❑ Human Services ❑ Planning & CD ❑ Fire ❑ Planning ❑ Park Board ®Public Works ❑ Legal ❑ Police ❑ Planning Comm. ❑ Other ® Public Works ❑ Human Resources Action: Committee Approval: ❑Yes ❑No Council Approval: ❑Yes ❑No Call for Public Hearing Referred to Until Tabled Until Councilmember: Wagner Staff: Dowd Meeting Date: February 7, 2011 Item Number: V.C.4 AUBURN* MORE THAN YOU IMAGINED BUDGET STATUS SHEET Project No: C524A Project Title: SCADA System Improvements Project Manager: Robert Lee O Project Initiation Initiation Date: _3/5/2007 O Permision to Advertise Date: February 2, 2011 Advertisement Date: _n/a @) Contract Award Award Date: O Change Order Approval Q Contract Final Acceptance The "Future Years" column indicates the projected amount to be requested in future budgets. Funds Bud eted Funds Available Funding 2010 2011 2012 Future Years Total 430 Fund - Water 281,300 2,034,900 350,000 0 2,666,200 431 Fund-Sewer 794,500 1,000,000 200,000 0 1,994,500 432 Fund - Storm 356,000 458,000 200,000 0 1,014,000 Total 1,431,800 3,492,900 750,000 0 775,674,700 Estimated Cost Funds Needed Activity 2010 2011 2012 Future Years Total Design Engineering - City Costs 20,737 0 0 0 20,737 Design Engineering - Consultant Costs 158,689 0 0 0 158,689 Technology Imp. Contract (w/o Physical Imp.) 0 2,459,773 1,639,849 0 4,099,621 Physical Security Imp. Estimate 0 0 250,000 0 250,000 Physical Security Imp. Contingency (10%) 0 0 25,000 0 25,000 Other - (Indicate what it is) 0 0 0 0 0 Construction Engineering - City Costs 0 30,000 25,000 0 55,000 Construction Engineering - Consultant Costs 0 0 0 0 0 Total 179,426 2,489,773 1,939,849 0 1774 430 Water Budget Status 2010 2011 2012 Future Years Total *430 Funds Budgeted (281,300) (2,034,900) (350,000) 0 (2,666,200) 430 Funds Needed 100,479 1,394,273 1,086,315 0 2,581,067 *430 Fund Project Contingency (1803821) (640,627 0 0 85,133 430 Funds Required 0 0 736,315 0 0 431S wer Budget Status 2010 2011 2012 Future Years Total *431 Funds Budgeted (794,500) (1,000,000) (200,000) 0 (1,994,500) 431 Funds Needed 55,622 771,830 601,353 0 1,428,805 *431 Fund Project Contingency (738,878) 228,170) 0 0 565,695 431 Funds Required 0 0 401,353 0 0 432 Storm Budget Status 2010 2011 2012 Future Years Total '432 Funds Budgeted (356,000) (458,000) (200,000) 0 (1,014,000) 432 Funds Needed 23,325 323,670 252,180 0 599,176 *432 Fund Project Contingency (332,675) (134,330) 0 0 414,824 432 Funds Required 0 0 52,180 0 0 ( # ) in the Budget Status Sections indicates Money the City has available. W0207-3A Page 1 of 1 H:\PROJ\C524A-SCADAImp\Budget\C524A BudgetStatusSheet.xls C524A - SCA®A System Improvement Project City of Auburn Scope for Technology Improvements - Summary This Scope of Work is for the C524A Project. This scope includes Professional and Technology Installation Services for the upgrade of the City of Auburn's Supervisory Control and Data Acquisition (SCADA) System. Project Description The City's SCADA System Improvement project will provide for a Computer based Master Telemetry Unit (MTU) and Programmable Logic Control (PLC) based Remote Telemetry Units (RTUs) to monitor and control the City's utility facilities. The project, whose Master Control Station is located at the Maintenance and Operations Center (M&O), will be based on the recommendations in the Preliminary Design Report_(The Report). The engineering design and technology installation will include written. standards; plan schematics, SCADA hardware,' and programming and transition plan for the water, sanitary sewer'and storm drainage systems; also included is the design of physical site security recommendations from The Report. Technology Design and Installation Task 1 Project/Management Administration The Design Team for the project will consist of TSI, who will be the Prime Contractor, and its Subcontractor Tetra Tech. The Electrical Subcontractor, will be Totem Electric. The Design Team will manage and coordinate all engineering and architecture disciplines and related services required for project completion: Deliverables include: Meeting minutes; Action item list, Historic register, Monthly progress reports, QA/QC Task 2 Master Control Station Upgrade Design the Maintenance and Operations Center (M&O) SCADA communications network, including modems, radios, computer, and network equipment. The Design Team will work with the City's Information Services Department (IS) to refine the computer detailed system network depicted in The Report list of required equipment. Deliverables include: • SCADA Block Diagram, Bill of Materials, Functional Descriptions, Transition Plan, SAT Procedures, Documentation Requirements, Rack Layout Diagram, and Application Software Design Guide o SCADA Master Station- equipment installation and application software, including HMI database, 94 graphic displays, alarm management system, communication drivers, access privileges, historian, and 5 reports. • Master Station Mainienance-'Procedures • Standardized Specifications of the Master Station. Task 3 Remote Site SCADA-Design and Upgrade Review current control and diagnostic strategies and propose any improvements based on current industry protocols or greater capabilities of the upgraded system-as opposed to existing system. The Design Team will review previous data of the radio path' assessment completed by TSI and prepare. radio-,path profiles for entire radio network to support conversion of the leased lines connections to,-the proposed Ethernet radio system. Utilize the information gathered in the Site Visits, Radio Path Profiles; and Design Workshop to develop the Technical Memorandum (TM) for Communications Upgrade. Develop a ,technical memorandum that outlines the design requirements for the remote site hardware improvements. Develop Remote Site Programming Design Guide` to define the Remote Site programming and configuration for the PLC controls and radio communications. C524A, SCADA SYSTEM IMPROVEMENT PROJECT CONSULTANT SCOPE OF WORK SUMMARY PAGE 10F 2 W0207-3B Develop an Implementation Plan based on the Communication System Design TM, the Remote Site Design TM, and the Remote Site Programming Design Guide. The Consultant will develop a Remote Site Implementation Plan to include prioritization criteria for sequencing of remote sites for upgrades and schedule to upgrade each site. Configure and Test Remote Site Controls; the Consultant will setup SCADA equipment in its shop and test all control functions, display, alarm, and OPC server functionality as well as PLC I/O, control and programming; test SCADA, RTUs, and communications equipment for end to end data transmission integrity and accuracy; test all SCADA screens, including data monitor screens, and trend screens, for connectivity, completeness, and accuracy of information displayed; test SCADA control, alarm, navigation, and security configurations and functions. Develop Remote Site Controls O&M Manual; the Design Team will prepare the Operations and Maintenance Manual (Part 2) for the upgraded Remote Site Controls. Deliverables include: • Memorandum of Site Control Strategies Improvements. • RTU Platform Report. • Radio Path Profiles for entire network. • Communication System Design TM • Remote Site Hardware Design TM • Remote Site Programming Guide • Remote Site Implementation Plan • As-built of the Process & Instrumentation Diagram • As-built of the configuration of the RTU Operator Interface Terminal • As-built Remote Site Programming Guide • Operations and Maintenance Manual (Part 2). • As-built Remote Site Technical Specification. Task 4 Training and Post Commissioning Services Provide training during startup of all processes and up to 80 hours of on-gong support for City requested, post-Final Acceptance changes. Develop a training plan for City staff using and maintaining the SCADA system to achieve the City objectives as well as to provide training for software and computer hardware to operate the system according to the training plan Deliverables include: • Training Plan • Staff training for operation of the Master Control Station operation • Staff training for Remote Site system operation Task 5 Physical Site Improvements Design Provide design site plans for physical elements of remote site security. These improvements include modifications and/or replacement of existing fencing, bollards, windows, doors, shelters, vegetation management, clearing, grubbing, and landscaping elements on identified sites. Deliverables include Final Physical Site Security plans and specifications. Total Primary Consultant Services = $4,099,621.43 C524A, SCADA SYSTEM IMPROVEMENT PROJECT CONSULTANT SCOPE OF WORK SUMMARY PAGE 2 OF 2 W0207-3B ~ t - . , r . N BERR A D WIRELESS NETWORKS KS WITH SCADA FI r I 1ff 1 1 i• I s... 4 - r l I I I L 1 < ~ ~ -~1 two . . I p gE I e.. 1 I w i r j i i I r _ _ rr~ ~I R f s 1;A~ ~E r r Ilii 4 ; ~ i ~ .err _ f - 41 a uM I 6 s JL • 4 rf - - - - - - - - SCADACIRCUIT9 CITY AND STATE OWNED FIBER o SEWER - COAAERIAL v+c., - SEWER PUMP STATIONS COA UNDERGROUND - - b rv"vn wsm y ~4a } a SEWER PUMP STATIONS PROPOSED- ITS AERIAL T~ l li STORM PUMP STATIONS -w--- ITS UNDERGROUND ' , a WATER eg° PROPOSED ITS FIBER 1~ ^ e WATER PUMP STATIONS WSDOT FIBER WATER PUMP STATIONS PROPOSED - CONDUIT - - t O PRIMARY WIR COVERAGE WATER RESERVOIRS - "$a COMMERCIAL FIBER AND CABLE OSECONDARY WIFI COVERAGE 360 NETWORKS WIFI ACCESS POINT ABOVENET :CITY LIMITS i AT&T PAA ,I , - COMCAST CABLE - ~ LEVELS U - ~ ' 1 1 MCI WORLDCOM - OWEST SPRINT A - .