The URL can be used to link to this page

Home My WebLink AboutITEM II-BCITY OF AGENDA BILL APPROVAL FORM * 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, Map 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 RTUs. 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 Reviewed by Council & Committees: Reviewed by Departments & Divisions: ❑ Arts Commission COUNCIL COMMITTEES: ❑ Building ❑ M&0 ❑ 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 I l Referred to Until I l Tabled Until I I Councilmember: Wa ner Staff: Dowd Meeting Date:: February 2011 Item Number: k t + •1~ BUDGET STATUS SHEET Project No: C524A Project Title: SCADA System Improvements Project Manager: Robert Lee Project Initiation Initiation Date: _31512007 ~ Permision to Advertise Date: February 2, 2011 Advertisement Date: nla ~ Contract Award Award Date: 0 Change Order Approval Contract Final Acceptance The "Future Years" column indicates the projected amount to be requested in future budgets. Funds Budgeted (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 5,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 (wlo 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 4,609,048 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 0 0 (85,133) 430 Funds Required 0 0 736,315 0 0 431 Sewer 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 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 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 H:IPROJ1C524A-SCADAImplBudgetlC524A BudgetStatusSheet.xls Page 1 of 1 C524A -SCADA System Improvement Project City of Auburn Scope forTechnology 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 wi11 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 (M8~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 Proj ect/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 (M8~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, Bi11 of Materials, Functional Descriptions, Transition Plan, SAT Procedures, Documentation Requirements, Rack Layout Diagram, and Application Software Design Guide • 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 Maintenance 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 W0207-3B PAGE 10F 2 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/0, 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 OB~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 W0207-3B PAGE 2 OF 2 T AUBURN r l r e ♦ FIBER AND WIR ELESS a ~ NETWORKS WITH SCADA i T oN - I MI -D urv °M' T, L PUMP RANK N iI ~ 9 I aKauM R J I b " Ir -D IT T ,E EOR RE, E= 0 R~oR,a R.lE uM PnA.~o~ - -IT I LLI IT R~~E =TAno~ - ~l° RA ump PEE 1=DE DoEPUMP IT1 um unuTI IMIR PUMP F11 11F IT11- l E RIIIRIIIR r 1" J III/\\I nA.je -UR WAY r ITIIIN oo - Igo ~ F .P ACADEMY -.1 ~jl AD I PUMP AC+~R Ek - - - PTAMTPIN t R 11-1 R IA WELL -E -EMYREIE-IR IA _ ; s lIED) G'NT-IN 'T 'p R N - CoALEE' EULMNPGION - IT-ON ER ooD MP PUMP T RE=E_R 1 Tllr'~lll . 'oR wELoL A 1 SCADA CIRCUITS CITY AND STATE OWNED FIBER PUMP IT11A o SEWER - COAAERIAL TERRAC~ SEWER PUMP STATIONS COA UNDERGROUND - SEWER PUMP STATIONS PROPOSED ITS AERIAL \ y -11B T'RpT'lpUMp STORM PUMP STATIONS ITS UNDERGROUND IT-ON o WATER s PROPOSED ITS FIBER WATER PUMP STATIONS WSDOT FIBER 4 J V WATER PUMP STATIONS PROPOSED CONDUIT - ' WATER RESERVOIRS O PRIMARY WIFI COVERAGE COMMERCIAL FIBER AND CABLE O SECONDARY WIFI COVERAGE -All 360 NETWORKS O PTAMTPON WIFI ACCESS POINT ABOVENET CITY LIMITS AT&T O FAA- - 1 i COMCAST CABLE LEVEL3 _ MCI WORLDCOM OWEST SPRINT