Loading...
HomeMy WebLinkAbout07-17-2012 c2 scada system upgrade project 2Meeting DateJuly. 17, 2012 . Item Numberry2 counci lac cn Oa R€poRt CITY OF SANLUIS OBISP O FROM : Carrie Mattingly, Utilities Directo r Prepared By :Jennifer Metz, Utilities Project Manage r SUBJECT :DESIGN SERVICES FOR SCADA SYSTEM UPGRADE PROJECT , SPECIFICATION #91062 — REQUEST FOR PROPOSAL S RECOMMENDATIO N 1.Approve the request for proposals (RFP) for professional engineering services for the desig n of SCADA System Upgrade Project, Specification #91062, and authorize its issuance, and ; 2.Authorize the City Manager to award a contract if the selected proposal is within th e approved budget of $400,000 . DISCUSSION Backgroun d Supervisory Control and Data Acquisition (SCADA) systems include elements of compute r programming, fiber optic networks, complex databases, and human-machine interface screens . Through SCADA, system equipment is remotely monitored to ensure it is operating within pre-se t ranges . Staff receives notice of equipment failures via remotely sent alarms and is able to remotely perform some operational changes through SCADA : SCADA systems improve emergency respons e time to equipment failures . In December 2007, the City contracted with DLT&V Systems Engineering to evaluate th e existing SCADA systems utilized by the Utilities Department to insure reliable and efficien t operations of the water and wastewater systems . The SCADA System Upgrade Assessmen t Report evaluated five separate SCADA systems used for operations for the Water Treatmen t Plant, Whale Rock Reservoir, Water Reclamation Facility, Wastewater Collection System, an d the Water Distribution System . While the report identifies recommended improvements for al l five systems, the most pressing needs were identified for the Whale Rock Reservoir and Wate r Distribution System . The SCADA System Upgrade Assessment Report was presented to Council at its regular meetin g of April 7, 2009 . As part of the 2009-11 Financial Planning process, in June 2009 Council approved a capital project to upgrade the SCADA systems for Whale Rock Reservoir and th e Water Distribution System . While preparing the Request for Proposals for Design Services in 2010, it became eviden t developing the proposal was more complex than anticipated . Extensive research on data no t provided in the SCADA upgrade report was necessary, time-consuming, and challenging t o complete . Significant use of resources from Finance & Information Technology and Utilitie s Departments were necessary to ensure the detailed scope of work included in the RF P (Attachment 1) accurately reflected the needs of the City . C2-1 SCADA System Need s The Whale Rock and Water Distribution SCADA systems are increasingly unreliable due to ag e and lack of available replacement parts . The current Water Distribution SCADA system i s missing key monitoring, data acquisition, and alarm capabilities at critical control valves tha t provide water into the "downtown" pressure zone that would minimize the risk of multiple wate r mains breaks such as those that have occurred several times in recent years . The SCADA System Upgrade Assessment Report recommended these two systems receive highest priority . Whale Rock Reservoir System .The Whale Rock Reservoir SCADA system is about 20 year s old and was installed and programmed by in-house staff. This system monitors and controls th e two pump stations along the 17-mile pipeline from Whale Rock Reservoir to the City's Wate r Treatment Plant. The pipeline also has turnouts along the way that provide water deliveries to th e Cayucos Water Treatment Plant (County), the Dairy Creek Golf Course, the California Men's Colony, and raw water for Cal Poly agricultural operations . The existing Whale Rock syste m utilizes a single DOS based 386 MHz computer and communicates to the remote sites vi a dedicated leased telephone lines . While this system has performed well for many years, the system is very old and staff will n o longer be able to maintain it in the future due to outdated hardware and software systems . Several SCADA failures have occurred at the main site as well as the remote pump stations . Th e leased lines are still recommended as the preferred communication method due to the unsuitabl e terrain for wireless communication, but are recommended to be upgraded to obtain the bes t performance for the new system . The SCADA System Upgrade Assessment Report recommends that all of the controllers on this system be replaced and reprogrammed and the computer syste m be upgraded to a Windows-based system . Water Distribution System .The Water Distribution System was also installed and programmed in-house, is outdated and reaching the end of its service life . Currently, this system has minima l operational oversight and data collection and no alarm capability . This system monitors wate r storage tank levels and provides this information to the Corporation Yard for use by Wate r Distribution and Treatment Plant operators . There is no control capability or data tracking for the pump stations or critical control valves i n the City water system . Most of the pump stations and the associated storage tanks operate base d on pressure switches at the pump station or tank site . A few of the pump stations communicat e via radios and the controllers at the pump stations control the pump operations based on th e water level in the tank. At the Corporation Yard there is a single DOS based computer tha t displays some of the tank water levels, however, not all tank sites are displayed on the system . Having minimal monitoring and data acquisition, and no control or alarming capability, create s operational and system reliability concerns that must be addressed. The SCADA System Upgrade Assessment Report recommends that all of the controllers be updated with the latest technolog y and that the DOS-based systems be upgraded to a Windows-based system . In addition, th e SCADA System Upgrade Assessment Report recommends that the licensed radio systems b e replaced with an unlicensed radio system and the Cuesta Peak repeater be replaced, potentiall y with a repeater at South Hill. The ongoing lease cost of the Cuesta Peak site is currently $3,30 0 annually shared between the Water and Sewer Funds . C2-2 With the SCADA System Upgrade Project, operators will be able to monitor and actuate equipment remotely by telemetry from the Water Shop at the City's Corporation Yard t o improve staffing efficiency . The project will provide measurement, storage and trending of dat a such as reservoir and tank volumes, enabling operational optimization of existing infrastructure , minimization of supply and pumping costs, and contribute valuable information related t o maximization of water quality and leak prevention . CIP Project Summar y The design for the SCADA System Upgrade Project will cost $400,000 for professiona l engineering services, including construction phase design support services, and is estimated t o cost $1,850,000 for construction and system integration services . Evaluation and Selection Proces s Proposals for these design services are due no later than August 16, 2012 . Based on th e evaluation criteria set forth in the RFP, proposals will be reviewed and finalists will be invite d for a follow-up presentation/interview before a review committee . The review committee will b e composed of staff from the City's Utilities and Finance/Information Technology departments . Reference checks will be conducted . Based on the results of the selection process,a recommendation will be made to the City Manager to award the contract . It is anticipate d contract award will be made during September and that work would begin on the project i n October 2012 . Prospective Proposer s In addition to publishing a formal notice requesting proposals, the RFP will be mailed to firm s specializing in these services . A list of prospective firms is part of the RFP . FISCAL IMPAC T A total of $400,000 is budgeted for the design phase of this project, of which $75,000 is from th e Whale Rock Fund and $325,000 is from the Water Fund . These funds were approved as part o f the 2009-11 Financial Plan, Capital Improvement Plan, Appendix B, pages 3-99 through 3-101 . CONCURRENCE S The Finance and Information Technology Department provided oversight in the development o f this report and concurs with the recommendations . ATTACHMEN T Request for Proposals, Specification #91062 city o f san Luis oBisp o 919 Palm Street ■San Luis Obispo,CA 9340 1 Notice Requesting Proposals for th e City of San Luis Obispo Utilities Department DESIGN SERVICES FOR SCADA SYSTEM UPGRADE PROJECT Specification No . 9106 2 July 201 2 The City of San Luis Obispo is requesting sealed proposals for DESIGN SERVICES FO R SCADA SYSTEM UPGRADE PROJECT pursuant to Specification No . 91062 . All proposal s must be received by the Public Works Department at 919 Palm Street, San Luis Obispo, C A 93401 by 4 :00 P .M . on August 16, 2012 . Proposals received after said time will not be considered. To guard against premature opening , each proposal shall be submitted to the Public Works Department in a sealed envelope plainly marked with the proposal title, specification number, Consultant name, and time and date of the proposal opening . Proposals shall be submitted using the forms provided in the specificatio n package . To obtain a specification package : ■ Download from the City's Web site www .slocity.org - Bids & Proposals pag e ■ Pick up a copy of the RFP at the above addres s ■Mail a request to the City of San Luis Obispo Public Works Department at the above addres s ■Fax a request to the City of San Luis Obispo at 805-781-7537 — include company name , street address, phone, fax, email and the name of the contact person . There will be a non-mandatory pre-proposal meeting on Tuesday,July 31, 2012 .Interested proposers should meet at 10:00 am at the Utilities Department Office, 879 Morro Street, Sa n Luis Obispo to ask questions of City staff regarding the project . Questions may be submitted to Jennifer Metz via e-mail at jmetz@slocity .org until August 10 , 2012 .All questions will be answered and distributed to all interested parties . The City of San Luis Obispo is committed to including disabled persons in all of our services, programs and activities . Telecommunications Device for the Deaf (805) 781-7410 . C2-4 A .Background &Scope of Work 1 Al . Backgroun d A2.Scope of Wor k A3.Schedule / Cos t B . General Terms &Conditions 1 5 B1.Proposal Requirement s B2.Contract Award and Executio n C . Proposal Content &Selection Process 1 7 Cl . Proposal Content Submittal Form s Qualification s Work Progra m Compensation Proposal Length and Copie s C2 . Proposal Evaluation & Selectio n Proposal Review Criteri a Proposal Review and Award Schedul e D . Agreement 1 9 E . Insurance Requirements 2 7 F . Proposal Submittal Forms 2 9 Fl . Acknowledgements F2.Insurance Certificate F3.Reference s F4.Statement of Past Contract Disqualification s Attachment A :SCADA Upgrade Assessment Report A DLT&V, 200 9 Attachment B :Radio Survey B Sterling Communications, 2012 C2-5 Specification No . 9106 2 TABLE OF CONTENTS City of San Luis Obisp o Specification No . 91062 Section A BACKGROUND & SCOPE OF WOR K Al .BACKGROUN D The day to day operation of the City's water supply and distribution system is managed by skilled staff that uses their experience and expert judgment to adjust control elements such as pumps and valves to insure customer demands on the systems are met, to insure regulatory compliance, an d to minimize energy costs. When an unplanned event such as a water main break occurs, operator s often have to respond in a reactive manner, with minimal information provided by customer s impacted by the event . Because the City's Utilities Department is striving to improve standards of service delivery and increase customer satisfaction, there is a need to shift from this reactiv e approach to a more proactive management strategy . Whale Rock Reservoi r Whale Rock Reservoir is a 40,662 acre-foot reservoir created by the construction an earthe n dam on Old Creek near the town of Cayucos in San Luis Obispo County. Water is delivered to th e City through over 17 miles of 30-inch pipeline an d two pumping stations . The pipeline has turnouts that provide water deliveries to the Cayucos Water Treatment Plant and the Dairy Creek Golf Cours e (both operated by San Luis Obispo County), th e California Men's Colony, raw water for Californi a Polytechnic State University's agricultural im -: operations, and the City of San Luis Obispo . Whale Rock Reservoi r The Reservoir's existing Supervisory Control and Data Acquisition (SCADA) system is about 2 0 years old and was installed and programmed by in-house staff. The SCADA system monitors and controls the two pump stations along the pipeline from the Reservoir to the City's Water Treatment Plant (WTP). The SCADA system utilizes a single DOS-based 386 MHz compute r located at the Whale Rock Dam Office and communicates to the remote sites over dedicate d leased telephone lines . Water Distribution Syste m The City has over 180 miles of water transmission and distribution piping ranging from two- t o 30-inches in diameter. The City has two main water transmission systems and 16 pressure zones . The upper service area, primarily the northern part of the City, makes up approximately half o f the overall water demand. Treated water is conveyed from the WTP to the upper area via a pump at the WTP . The remainder of the City lies in the lower service area and is fed by gravity fro m the reservoir at the WTP. Pressure reducing valves provide optimum service pressure in areas of lower elevation . 1 C2-6 City of San Luis Obisp o Specification No . 91062 System storage is provided in 12 reservoirs located throughout the City (See Figure 1) ranging i n size from 40,000 gallon to 7 .5 million gallons . The reservoirs are a combination of above grad e steel tanks and underground concrete reservoirs with a total combined storage capacity o f approximately 26 million gallons. The reservoirs range in age from three years (Bishop Tank) t o 68 years in age (Reservoir 2). The Water Distribution System's existing SCADA system includes a single computer using a DOS-based human machine interface (HMI) located in the Water Shop at the City's Corporatio n Yard at 25 Prado Road . The existing SCADA system displays information on four of the City's reservoir levels allowing limited remote monitoring of the distribution system . No information i s transmitted on the operation of the City's pump stations and pressure relief valves (PRVs). Th e existing SCADA system also has no alarming or control capability . With limited remot e monitoring capability in place, equipment failures and water main breaks cannot be detected or evaluated . Staff physically inspects each location to insure proper facility operations . The communication network for the existing SCADA system utilizes a remote, leased facility o n Cuesta Peak north of the City as a repeater site and a licensed radio network . SCADA Assessmen t In December 2007, the City of San Luis Obispo (City) contracted with DLT&V System s Engineering to prepare an assessment of the City's SCADA systems . The study recommende d improvements to the Whale Rock Reservoir and Water Distribution SCADA systems . Both o f these systems are very old, outdated and some replacement components are no longer available . As described above, much of the water distribution system is not monitored remotely and doe s not provide notification of problems which result in impacts to the City's water customers . Th e product of that effort,SCADA System Upgrade Assessment Report,is provided as Attachment A . The City is moving forward with an upgrade of th e SCADA systems serving the Whale Rock Reservoir and Water Distribution System only .These facilities ar e described in Table 1 . The project will update the City's aging SCADA system with a modern system that can b e expanded to meet future needs . With the SCAD A System Upgrade Project, operators will be able t o monitor and actuate equipment remotely by telemetr y from the Water Shop at the City's Corporation Yard t o improve staffing efficiency. The project will provid e measurement, storage and trending of data such as reservoir and tank volumes, enabling operationa l optimization of existing infrastructure, minimization o f supply and pumping costs, and contribute valuabl e information related to maximization of water quality an d leak prevention. The City is not pursuing an upgrade t o the SCADA systems at the Water Treatment Plant , Water Reclamation Facility and Wastewater Collection Serrano Tank. System as part of this project . C2-7 Ut(Bter Treat nrtlerit Piant an d Reservoir Tw'ITT' Vrrin i s.of Slac k®Tank city or SdTI lU1S OBl_S}>O gi3 Reservoir On e [PumpStatio n Bisho pTank FPurmp Statio n Terrac e TanHi kll Isl aTan Grand Ave . PR V SLO GIS FIGURE 1 : Water Distribution Facility Location s Pump Station A Pressure Regulatin g Locations Valve (PRV) Location s Source :City of San Luis Obispo Utilities Department, 2010 . C2-8 City of San Luis Obisp o Specification No . 9106 2 Table 1 : Water Distribution System and Whale Rock Facilities Site Name Location /Storage /Type I Built /Othe r 1 Reservoir 1 This facility is a 7 .5-million gallon concrete lined tank with floating cover and liner . It was built in the mid-1940's . 2 Reservoir 2 This facility is a 7 .5-million gallon concrete lined tank with floating cover and liner . It was built in 1942 . 3 Islay Tank This tank is located on Islay Hill . It is a 350,000 gallon concrete underground tank ; solar power to the existing Remote Terminal Unit (RTU). The tank site i s accessible by a dirt road . 4 Bishop Tank This facility is a 750,000 gallon steel tank built in 2007 . 5 Edna Saddle Tank This tank is located south of Bluerock Drive in the South Hills . It is a 4.0-million gallon steel tank and was built in 1974 . 6 Ferrini Tank This facility is a 0 .16-million gallon steel tank built in 198 6 7 Rosemont Tank This facility is a 0 .04-million gallon steel tank . 8 Serrano Tank This facility,a 0 .10-million gallon steel tank, was built in 1967 and is accessible b y a dirt road which requires four wheel drive vehicles . 9 Slack Tank This tank is located at the end of Slack Street . It is a 0 .077-million gallon stee l tank, was built in 1955, and is accessible by a dirt road . 10 Terrace Hill Tank This tank is located on Bishop Street west of Johnson Avenue on Terrace Hill . It is a 0 .75-million gallon steel tank and was built in 1957 . 11 Alrita Pump Station Upgraded in 2007, hydro-pneumatic pump station located at Flora Street an d Laurel Lane . 12 Bishop Pum pStation Located on Bishop Street east of Johnson Avenue, this station pumps to Bisho p Tank . 13 Bressi Pump Station Located on Bressi Street, this station pumps to Serrano Tank . 14 Ferrini Pump Station Located off of Highway 1 across from Stenner Creek Road, this station pumps to Ferrini Tank . 15 McCollum Pum p Station Located on McCollum Street off of Grand Avenue, this station pumps to Slac k Tank . 16 Rosemont Pum p Station Located on Highland Drive, this station pumps to Rosemont Tank and wa s upgraded in 2010 . 17 Foothill Blvd . PRV This PRV is located at the intersection of Foothill Boulevard and Chorro Street . 18 Grand Avenu eValve This PRV is located at the intersection of Grand Avenue and Wilson . 19 Industrial Way PRV This PRV is located east of Industrial Way and the UPRR railroad tracks . 20 Madonna Road PRVThis PRV is located at the intersection of South Higuera Street and Madonna Roa d 21 Peach Street PRV This PRV is located on Peach Street adjacent to Mission Prep School . There is no power or existing panel at this location . 22 Whale Rock Da mOffice SCADA master location at 108 13th Street in Cayuco s 23 Pump Station A Slave location at 102 Chaney off of Highway 1 in Cayucos . 24 Pump Station B Slave location at 3475 Gilardi, north of Highway I . 25 Dairy Creek Gol f Course Valve Slave location at 2990 Dairy Creek Road, north of Highway 1 . Near El Chorro Regional Park . North of Cuesta College . C2-9 City of San Luis Obisp o Specification No . 91062 Software and Hardwar e The City has preselected a standard Human Machine Interface i ; (HMI) vendor (GE Fanuc Intelligent Platforms Proficy HMI – / IFix) for its HMI. This software is already in use at the City's Water Treatment Plant and through a near term upgrade wil l be in use at the City's Water Reclamation Facility and in th e Wastewater Collection system . The City compared othe r alternative software solutions as part of the SCADA Syste m Upgrade Assessment Report .After extensive evaluation staff determined that this product will provide the most benefit t o the City . Standardization on software from one manufacturer will allow shared server use, minimize training requirements , and expedite system backups . Similarly, the City has preselected standard controller hardware (SCADA Pak by Control Microsystems) for th e Project to provide the needed functionality, expandability, an d cost effectiveness to serve the Department today and into th e future . The City evaluated other alternative hardware solutions and determined that this produc t will provide the most benefit to the City . Standardization on controllers from one manufacture r will minimize spare parts inventories, training requirements, and maintenance time . The City will supply the new computer hardware for the SCADA System Upgrade Project at th e Water Shop at the City's Corporation Yard, at Whale Rock Dam Office, and at the Wate r Treatment Plant to interface with the both the Water Distribution and Whale Rock system . Th e City is considering the use of a shared server for Water Distribution, the Water Reclamatio n Facility, and Wastewater Collection. Communication Networ k A component of the City's SCADA System Upgrade Project includes the design of a reliabl e City-wide communication network for the Water Distribution System that eliminates the use o f the existing Cuesta Peak repeater site . Also included is replacing the licensed radio system wit h an unlicensed radio system. One proposed network that utilizes the City-owned site at South Hil l would eliminate the lease costs associated with the use of the existing Cuesta Peak location, i s described in Table 2, Potential Communication Network . This network was identified as part o f the work scope for the SCADA Upgrade Assessment Report prepared by DLT&V . Since the Report was prepared, the City has upgraded its public safety radio system to includ e additional radio transmission and receiver sites throughout the City. In addition to the South Hil l site, the City now has fiber network access that can be utilized for the SCADA System Upgrad e Project at four City Fire Stations, city offices at 919 Palm Street, and several other City locations . A part of this Project will be to revisit communications options, and propose a recommende d solution to the City. A recent radio survey was completed in June 2012 and is attached to thi s RFP . 5 Slack Tank. C2-10 City of San Luis Obisp o Specification No . 91062 Table 2: Water Distribution System Potential Communication Networ k Site Name Repeater Site /End Poin t Alrita Pump Station South Hill Corporation Yard -- Bishop Pump Station Bishop Tank South Hill Corporation Yard - Bishop Tank South Hill Corporation Yard -- Bressi Pump Station Serrano Tank Bishop Tank South Hill Corporation Yard Corporation Yard South Hill Corporation Yard - Edna Saddle Tank Corporation Yard --- Ferrini Pump Station Slack Tank South Hill Corporation Yard - Ferrini Tank Slack Tank South Hill Corporation Yard - Foothill Blvd . PRV Slack Tank South Hill Corporation Yard - Grand Ave Valve Slack Tank South Hill Corporation Yard - Industrial PRV Bishop Tank South Hill Corporation Yard - Islay Tank Terrace Hill Tank South Hill Corporation Yard Madonna Road PRV South Hill Corporation Yard McCollum Pump Station Slack Tank South Hill Corporation Yar d Peach Street PRV Slack Tank South Hill Corporation Yard - Reservoir 1 Serrano Tank Bishop Tank South Hill Corporation Yard Reservoir 2 Note 1 Rosemont Pump Station Slack Tank South Hill Corporation Yard Rosemont Tank Slack Tank South Hill Corporation Yard - Serrano Tank Bishop Tank South Hill Corporation Yard - Slack Tank South Hill Corporation Yard -- Terrace Hill Tank South Hill Corporation Yard NOTE S 1.When the Cuesta Peak repeater site is eliminated, another means of communication will need to be established for Reservoir 2 .2.SOURCE : DLT&V, 2009 . City of San Luis Obisp o Specification No . 91062 A2 SCOPE OF WORK The goal of the City's SCADA System Upgrade Project is to provide a consistent interface fo r monitoring and controlling the identified Whale Rock Reservoir and Water Distribution Syste m facilities as well as enabling future expansion of the SCADA system . This scope of work describes the major tasks for the project's design phase of the project to accomplish these goals . The City anticipates that the design phase will be complete in FY 2012-13 with the constructio n phase to be completed in FY 2013-14 . Task 1 : Project Kickoff and Site Visit s The City's SCADA System Upgrade Project will replace existing out of date SCADA equipmen t with new, reliable equipment or provide new equipment where no SCADA equipment exist s currently . To kickoff the Project, the Consultant will meet with the City's project team . Th e Consultant shall also visit each of the 25 sites (Water Distribution and Whale Rock) to documen t site constraints and confirm individual SCADA upgrade requirements for the design phase of th e project. Site layout and space considerations are not detailed in this RFP . Task 2 : Stakeholder Workshop s It will be critical for the Consultant to conduct workshops with City staff (Utilities and Financ e & Information Technology departments) to confirm the requirements for each site . It is importan t the project team include the operators that will be the SCADA system's end users to insur e operational objectives are met and begin to build a sense of ownership of the system . Preliminary topics include desired system functionality, HMI architecture, historical/trend data and reporting , communications, server and security issues . Consultant should suggest a specific approach t o conducting Stakeholder Workshops with Water Distribution and Whale Rock staff in thei r proposal. The Consultant shall prepare the agendas and minutes for these workshops . Task 3 : Easement Acquisition Service s The City's SCADA System Upgrade Project will result in the need to acquire utility easements i n at least one location (Peach Street PRV) Consultants will perform services including require d easement negotiation and acquisitions . The Consultant shall demonstrate the ability to carry out th e duties associated with the right of way acquisition process . These duties may include, but are no t limited to, property appraisal, negotiations, obtaining Preliminary Title Reports and completin g necessary research where legal descriptions of property lines are involved . Task 4 : Communication Networ k The City has upgraded its public safety radio system to include additional radio transmission an d receiver sites throughout the City. As part of the SCADA System Upgrade Project, th e Consultant will revisit communications options (See Radio Survey in Attachment 1) and propos e a recommended solution to the City . As footnoted in Table 2, with the elimination of the Cuesta Peak repeater site, another means o f communication will need to be established for Reservoir 2 . Consultant shall propose a communications solution for this site . The Project also includes design services related to the upgrade of Whale Rock's communicatio n system (leased telephone lines) from the three remote sites (Pump Station A, Pump Station B , and Dairy Creek Golf Course Valve) to the Whale Rock Dam Office . 7 C2-12 City of San Luis Obispo Specification No . 91062 Task 5 : Prepare Detailed Design Plans and Specification s The Consultant shall prepare and submit for review design plans and specifications for the City's SCADA System Upgrade Project . Submittals shall be made at the 50, 90 and 100 percent desig n completion levels . Submittals are expected to include final design detail for a design package fo r construction bidding and will serve as the basis for any necessary easement acquisition o r construction permitting . They are intended to provide the City with sufficient detail to understan d and confirm the proposed architecture and functionality of the SCADA system and to review th e proposed physical layout of each of the SCADA sites . The City anticipates the following drawings will be prepared as part of these design services : • Demolition Plan, •Power Plan , •RTU Cabinet Enclosure Layout and Cabinet Subpanel Layout, Wiring Diagram s (Discrete Input and Discrete Output, Analog Input and Analog Output, as appropriate), •Terminal Block and Device Details, •Power Distribution Schematics, an d • Process and Instrumentation Diagrams . As detailed in Tables 3 and 4, desired functions include : •Ability to monitor and control of tank/reservoir water levels , • Provide high- and low-level alarms at tanks/reservoirs, RTU power failure and hig h temperature alarms, power failure alarm at each of the PRVs, and pump failure alarms , • Ability to monitor intrusion at each tank/reservoir facility, PRV and pump station , • Provide valve status (open/closed) and downstream pressure at each of the PRVs , •Ability to control and monitor run status for each pump (start/stop), an d • Provide pump flow information . Task 6 : Prepare Scope for Integration Service s The Consultant shall be responsible for working with the City to identify a specific scope of wor k for the project's integration services including designing the desired architecture of the HM I interface using IFix software . This includes the graphic interface, navigation (drilldown levels), alarm management and general characteristics of the User Interface, Object Development, as wel l as the requirements of the Historian and Data collection system including trending and reporting . Below is a preliminary list of the HMI screens the City anticipates . Water Distributio n • Distribution System SCADA home page – with links to tanks, pump stations and PRV s • Legend – indicates standard objects, colors, abbreviations, etc . •Alarm summary screen – displays current alarms and alarms not yet acknowledged . •Alarm history screen – displays all instances of alarm s System status screen – displays system components and communication statu s Totals screen – display of flow totalizers, volume total s Runtime screens – equipment runtim e •Trend screens - (quantity to be determined). • Report screens – (quantity to be determined). C2-13 City of San Luis Obisp o Specification No . 91062 Whale Roc k Whale Rock SCADA home page with links to each sit e Legend — indicates standard objects, colors, abbreviations, etc . •Alarm summary screen — displays current alarms and alarms not yet acknowledge d •Alarm history screen — displays all instances of alarm s •System status screen — displays system components and communication statu s •Runtime screens — equipment runtim e •Trend screens — (quantity to be determined ) •Report screens - (quantity to be determined ) Specification shall include details on desired commissioning, testing, start up phasing/schedule , and operator training . Task 7 : Construction and Integration Services Estimate s A detailed construction cost estimate shall accompany each design submittal (50 and 10 0 percent) described in Task 5 as well as an estimate of the cost of project integration service s described in Task 6 . The purpose of these estimates is to insure that the project can b e implemented within the City's budgetary constraints . Task 8 : Construction Phase Support Service s Construction phase support services will be critical for the efficient and successfu l implementation of the SCADA System Upgrade Project . This support will assist the City's construction manager and inspection staff to keep the project on schedule and control costs . Proposal shall include construction phase support services (estimated number of hours an d hourly rate) from the design engineer during project construction to insure the project is built t o the plans and specifications and insure any changes or issues with the construction are addresse d properly and quickly . These services would include the review of material and equipment submittals, requests from the contractor for clarification of the plans and specifications , reviewing and assisting in possible change orders to the original contract, consultation and th e preparation of the record drawings that will incorporate all changes from the original project . A3 . SCHEDULE / COST As mentioned previously, the City anticipates that the design phase of the SCADA Syste m Upgrade Project will be completed in 2012-13 with the project proceeding to construction in F Y 2013-14 . Proposal shall include a detailed project schedule for the completion of the seven task s described above in the Scope of Work with key milestones and deliverables . Project start up shal l correspond to the award schedule included in Section C . Proposal shall also include a corresponding cost breakdown with the estimated number of hour s to perform each of the tasks described in the Scope of Work and an hourly rate work sheet . A s funding for the SCADA System Upgrade Project is from two funds (Water Fund and Whal e Rock Fund), these costs shall be attributed appropriately. This cost breakdown shall be consisten t with the total provided in Section F . C2-14 City ofSan Luis Obisp o Specification No . 91062 Table 3 : Whale Rock Reservoir Facilities,Input/Outpu t Discrete Analo g iDescriptio n RTU 120 VAC Power Failure Alarm Ta g JA-500A Inpu t X Output Input Outpu t Area 30 : Whale RTU 24 VAC Power Failure Alarm JA-500B XRock Dam RTU UPS Fault Alarm JA-500C XOfficeRTU High Temp Alarm TAH-500 X Total I/O 4 U 1 0 PS Effluent Flow FI-100 X Area 31 : Pump PS Common Suction Pressure PIT-150 X Station A PS Common Discharge Pressure PIT-151 X and Pump 1 Start/Stop Command HS-410 X Pump 1 Run Status YL-410 X Area 32 : Pump Pump 2 Start/Stop Command HS-420 X Station B Pump 2 Run Status YL-420 X Pump 3 Start/Stop Command HS-430 X Pump 3 Run Status YL-430 X Pump 4 Start/Stop Command HS-440 X Pump 4 Speed Control SC-440 X Pump 4 Speed Indication SI-440 X Pump 4 Run Status YL-440 X Pump 5 Start/Stop Command HS-450 X Pump 5 Speed Control SC-450 X Pump 5 Speed Indication SI-450 X Pump 5 Run Status YL-450 X Communication Line OK CL-500 X RTU 120 VAC Power Failure Alarm JA-500A X RTU 24 VAC Power Failure Alarm JA-500B X RTU UPS Fault Alarm JA-500C X RTU High Temp Alarm TAH-500 X Total 110 8 Valve I Open Command HS-300A X Valve 1 Close Command HS-3008 X Valve I Closed Status ZSC-300 XArea 33: Dairy Valve I Open Status ZSO-300 XCreek Golf RTU 120 VAC Power Failure Alarm JA-500A XCourse Valve RTU 24 VAC Power Failure Alarm JA-500B X RTU UPS Fault Alarm JA-500C X RTU High Temp Alarm TAH-500 X Total I/O 6 2 0 NOTES : Tag = Area, Function Identification, and Loop #. DI = Digital Input . Dry contact . DO = Digital Output . Relay contact . AI = Analog Input . Signal that varies as measured value varies, typically 4 — 20mA DC . AO = Analog Output. A variable value from controller to provide commands for adjustable set points or displa y values . 10 C2-1 5 City of San Luis Obisp o Specification No . 91062 Table 4 : Water Distribution System Facilities, Input/Outpu t Pumn Stations Discrete Analo g Description Tag Input Output Input Outpu t Area 40 : Alrita Pum p Station Flow Indication FI-100 X Pump 1 Remote Status HS-410A X Pump 1 Start Command HS-410B X Pump 1 Stop Command HS-410C X Pump 1 Fail Alarm YA-410 X Pump 1 Run Status YL-410 X Pump 2 Remote Status HS-420A X Pump 2 Start Command HS-420B X Pump 2 Stop Command HS-420C X Pump 2 Fail Alarm YA-420 X Pump 2 Run Status YL-420 X Fire Pump Remote Status HS-430A X Fire Pump Start Command HS-430B X Fire Pump Stop Command HS-430C X Fire Pump Speed Control SC-430 X Fire Pump Speed Indication SI-430 X ` Fire Pump Fail Alarm YA-430 X Fire Pump Run Status YL-430 X RTU 120VAC Power Failure Alarm JA-500A X RTU 24VDC Power Failure Alarm JA-500B X RTU UPS Fault Alarm JA-500C X RTU High Temp Alarm TAH-500 X Intrusion at Entry Point(s)ZA-60 1 Total UO X 14 6 2 1 Flow Indication Fl-100 X Areas 41-45 :Pump 1 Remote Status HS-410A X Bishop,Pump 1 Start Command HS-410B X Bressi,Pump 1 Stop Command HS-410C X Ferrini,Pump 1 Fail Alarm YA-410 X McCollum,Pump 1 Run Status YL-410 X and Pump 2 Remote Status HS-420A X Rosemont Pump 2 Start Command HS-420B X Pump Pump 2 Stop Command HS-420C X Stations Pump 2 Fail Alarm YA-420 X Pump 2 Run Status YL-420 X RTU 120VAC Power Failure Alarm JA-500A X RTU 24VDC Power Failure Alarm JA-500B .X RTU UPS Fault Alarm JA-500C X RTU High Temp Alarm TAH-500 X Intrusion at Entry Point(s)ZA-601 X Total I/O 11 4 1 0 11 C2-1 6 City ofSan Luis Obisp o Specification No. 91062 Water Tanks Description Tag Discrete Analog Outpu t Area 51 :Edn a Saddle Tank High Level Alarm LAH-200 Inpu t X Output Inpu t High-High Level Alarm LAHH-200 X Low Level Alarm LAL-200 X Low-Low Level Alarm LALL-200 X Tank Level Indication LI-200A X Tank Level Local Indicator LI-200B X Chemical Tank Indicator LI-201 X Chemical Pump Auto Status HS-400A X Chemical Pump Remote Status HS-400B X Chemical Pump Start Command HS-4000 X Chemical Pump Stop Command HS-400D X Chemical Pump Speed Control SC-400 X Chemical Pump Speed Indication SI-400 X Chemical Pump Fail Alarm YA-400 X ' Chemical Pump Run Status YL-400 X RTU 120V AC Power Failure Alarm JA-500A RTU 24V DC Power Failure Alarm JA-500B X RTU UPS Fault Alarm JA-500C X RTU High Temp Alarm TAH-500 X Intrusion at Entry Point(s)ZA-60 1 Total I/O X 13 2 3 2 High Level Alarm LAH-200 X Area 50: Bishop High-High Level Alarm LAHH-200 X and Areas 52-Low Level Alarm LAL-200 X57:Fart** Islay, Rosemont, Low-low Level Alarm LALL-200 X Level Indication LI-200 X Serrano, Slack RTU 120V AC Power Failure Alarm JA-500A X and Terrace Hill RTU 24V DC Power Failure Alarm JA-5006 X Tanks RTU UPS Fault Alarm JA-5000 X RTU High Temp Alarm TAH-500 X Intrusion at Entry Point(s)ZA-601 X Total IIO 9 0 1 0 12 C2-1 7 City of San Luis Obispo Specification No. 91062 Reservoirs Discrete Analog Description Tag Input Output Input Outpu t Area 58 : Reservoir 1 High Level Alarm LAH-200 X High-High Level Alarm LAHH-200 X Low Level Alarm LAL-200 X Low-Low Level Alarm LALL-200 X Level Indication LI-200 X Chemical Pump Remote Status HS-400A X Chemical Pump Start Command HS-400B X Chemical Pump Stop Command HS-400C X Chemical Pump Speed Control SC-400 X Chemical Pump Speed Indication SI-400 X Chemical Pump Fail Alarm YA-400 X Chemical Pump Run Status YL-400 X RTU 120V AC Power Failure Alarm JA-500A X RTU 24V DC Power Failure Alarm JA-500B X RTU UPS Fault Alarm JA-500C X RTU High Temp Alarm TAH-500 X Intrusion at Entry Point(s)ZA-60 1 Total I/O X 12 2 2 1 Basin 1 Level Indication (East)LI-110 X Area 59 :Basin 2 Level Indication (West)LI-120 X Reservoir 2 Basin 1 High Level Alarm LAH-210 X Basin 1 High-High Level Alarm LAHH-210 X Basin 1 Low Level Alarm LAL-210 X Basin 1 Low-Low Level Alarm LALL-210 X Basin 2 High Level Alarm LAH-220 X Basin 2 High-High Level Alarm LAHH-220 X Basin 2 Low Level Alarm LAL-220 X Basin 2 Low-Low Level Alarm LALL-220 X Chemical Pump Remote Status HS-400A X Chemical Pump Start Command HS-400B X Chemical Pump Stop Command HS-400C X Chemical Pump Speed Control SC-400 X Chemical Pump Speed Indication Sl-400 X Chemical Pump Fail Alarm YA-400 X Chemical Pump Run Status YL-400 X RTU 120V AC Power Failure Alarm JA-500A X RTU 24V DC Power Failure Alarm JA-500B X RTU UPS Fault Alarm JA-500C X RTU High Temp Alarm TAH-500 X Intrusion at Entry Point(s)ZA-60 1 Totall/O X 16 2 3 1 13 C2-1 8 City of San Luis Obispo Specification No . 91062 Pressure Regulating Valves (PRVs) Descriptio n Valve 1 Flow Indication Ta g FI-100 Discret e Input Output Analo g Inpu t X Outpu t Area 74 :Valve 2 Flow Indication FI-110 X Peach St .Upstream Pressure Indication XPRVDownstream Pressure Indication X Valve 1 Closed Status ZSC-300 X Valve 1 Open Status ZSO-300 X Valve 2 Closed Status ZSC-310 X Valve 2 Open Status ZSO-310 X RTU 120V AC Power Failure Alarm JA-500A X RTU 24V DC Power Failure Alarm JA-500B X RTU UPS Fault Alarm JA-500C X RTU High Temp Alarm TAH-500 X Vault Flooding Alarm LAH-600 X High Pressure Alarm X Intrusion at Entry Point(s)ZA-60 1 Total I/O X 11 0 4 0 Valve 1 Flow Indication FI-100 X Areas 70 and Upstream Pressure Indication X 72 : Foothill Downstream Pressure Indication X Blvd . and Valve 1 Open Command HS-300A X Industrial Valve 1 Close Command HS-300D X Way PRVs Valve 1 Closed Status ZSC-300 X Valve 1 Open Status ZSO-300 X RTU 120V AC Power Failure Alarm JA-500A X RTU 24V DC Power Failure Alarm JA-500B X RTU UPS Fault Alarm JA-500C X RTU High Temp Alarm TAH-500 X Vault Flooding Alarm LAH-600 X High Pressure Alarm X Intrusion at Entry Point(s)ZA-60 1 Total I/O X 9 2 3 0 Valve 1 Flow Indication FI-100 X Areas 71 and Upstream Pressure Indication X 73 :Grand Downstream Pressure Indication X Ave. and Valve 1 Open Command Full HS-300A X Madonna Rd .Valve 1 Open Command 3/4 HS-300B X PRVs Valve 1 Open Command %HS-300C X Valve 1 Close Command HS-300D X Valve 1 Closed Status ZSC-300 X Valve 1 Open Status ZSO-300 X RTU 120V AC Power Failure Alarm JA-500A X RTU 24V DC Power Failure Alarm JA-500B X RTU UPS Fault Alarm JA-500C X RTU High Temp Alarm TAH-500 X Vault Flooding Alarm LAH-600 X High Pressure Alarm X Intrusion at Entry Point(s)ZA-60 1 Total IiO X 9 4 0 14 C2-1 9 City ofSan Luis Obisp o Specification No . 91062 Section B GENERAL TERMS & CONDITION S B1 . PROPOSAL REQUIREMENT S 1 .Requirement to Meet All Provisions .Each individual or firm submitting a proposa l (Consultant) shall meet all of the terms, and conditions of the Request for Proposals (RFP ) specifications package . By virtue of its proposal submittal, the Consultant acknowledge s agreement with and acceptance of all provisions of these RFP specifications . 2 .Proposal Submittal .Each proposal must be submitted on the form(s) provided in the specifications and accompanied by any other required submittals or supplemental materials . Proposal documents shall be enclosed in an envelope that shall be sealed and addressed to th e Public Works Department, City of San Luis Obispo, 919 Palm Street, San Luis Obispo, CA , 93401 . In order to guard against premature opening, the proposal should be clearly labele d with the proposal title, specification number, name of proposer, and date and time of proposa l opening . No FAX submittals will be accepted . 3 .Insurance Certificate .Each proposal must include a certificate of insurance showing : a.The insurance carrier and its A .M . Best rating . b.Scope of coverage and limits . c.Deductibles and self-insured retention . The purpose of this submittal is to generally assess the adequacy of the proposer's insuranc e coverage during proposal evaluation ; as discussed under paragraph 13 below, endorsement s are not required until contract award . The City's Insurance Requirements are detailed i n Section E of this RFP package . 4 .Submittal of References .Each proposer shall submit a statement of qualifications and references on the form provided in the RFP package . 5 .Statement of Contract Disqualifications.Each proposer shall submit a statement regarding any past governmental agency proposing or contract disqualifications on the form provided i n Section F of this RFP package . 6 .Proposal Withdrawal and Opening .A Consultant may withdraw its proposal, withou t prejudice prior to the time specified for the proposal opening, by submitting a written reques t to the City Engineer for its withdrawal, in which event the proposal will be returned to th e proposer unopened . No proposal received after the time specified or at any place other than that stated in the "Notice Inviting Proposals/Requesting Proposals" will be considered . Al l proposals will be opened and declared publicly . Consultants or their representatives are invited to be present at the opening of the proposals . 7 .Submittal of One Proposal Only .No individual or business entity of any kind shall b e allowed to make or file, or to be interested in more than one proposal, except an alternativ e proposal when specifically requested ; however, an individual or business entity that ha s submitted a sub-proposal to a Consultant submitting a proposal, or who has quoted prices o n 15 C2-20 City of San Luis Obisp o Specification No . 91062 materials to such proposer, is not thereby disqualified from submitting a sub-proposal or fro m quoting prices to other Consultant's submitting proposals . Communications .All timely requests for information submitted in writing (via e-mail t o jmetz@slocity.org) will receive a written response from the City. Telephone communication s with City staff are not encouraged. However, any such oral communication shall not b e binding on the City . 9.Alternative Proposals .The proposer may submit an alternative proposal that it believes wil l also meet the City's project objectives but in a different way . In this case, the proposer mus t provide an analysis of the advantages and disadvantages of each of the alternatives, an d discuss under what circumstances the City would prefer one alternative to the other(s). If an alternative proposal is submitted, the maximum length of the proposal may be expande d proportionately by the number of alternatives submitted . B2 . CONTRACT AWARD & EXECUTIO N 10.Proposal Retention and Award .The City reserves the right to retain all proposals for a period of 60 days for examination and comparison. The City also reserves the right to waive non-substantial irregularities in any proposal, to reject any or all proposals, to reject or delete one part of a proposal and accept the other, except to the extent that proposals are qualifie d by specific limitations . See Section C of these specifications for Proposal Evaluation an d Contract Award criteria . 11 Competency and Responsibility of Consultant .The City reserves full discretion t o determine the competence and responsibility, professionally and/or financially, o f consultants . Consultants will provide, in a timely manner, all information that the City deem s necessary to make such a decision . 12.Contract Requirement .The Consultant to whom award is made shall execute a writte n contract with the City within ten (10) calendar days after notice of the award has been sent by mail to it at the address given in its proposal : The contract shall be made in the form adopted by the City and incorporated in these specifications . 13.Insurance Requirements .The Consultant shall provide proof of insurance in the form , coverages and amounts specified in Section E of these specifications within 10 (ten) calenda r days after notice of contract award as a precondition to contract execution . 14.Business License and Tax .The Consultantmust have a valid City of San Luis Obisp o business license and tax certificate before contract execution . Additional informatio n regarding this requirement may be obtained by calling (805)781-7134 . 15.Failure to Accept Contract .The following will occur if the Consultant to whom the awar d is made fails to enter into the contract: the award will beannulled ; any bid security will b e forfeited in accordance with the special terms and conditions if a Consultant's bond o r security is required ; and an award may be made to the next highest ranked consultant wit h whom a responsible compensation is negotiated, who shall fulfill every stipulation as if it were the party to whom the first award was made . 16 C2-21 City of San Luis Obispo Specification No. 91062 Section C PROPOSAL CONTENT & SELECTION PROCES S Cl . Proposal Conten t Submittal Form s a.Proposal submittal summary . b.Certificate of Insurance . c.References from at least three Agencies for whom you have provided simila r Engineering Design services for SCADA projects . d.Statement of Past Disqualifications . Qualification s e.Experience of your firm in performing similar services, including experience with th e City's selected software (IFix) and hardware (SCADA Pak). f.Experience of the staff to be assigned to the project in performing similar services . g.Redundancy in the company of staff experienced in this type of work . h.Resumes of the individuals who would be assigned to this project, including an y sub-consultants . i Standard hourly billing rates for the assigned staff, including any sub-consultants . j.Statement and explanation of any instances where your firm has been removed from a project or disqualified from proposing on a project . Work Progra m k.Description of your approach to working with City staff to achieve their goal o f completing the work . 1 . Tentative schedule by phase and task for completing the work . m.Estimated hours for your staff in performing each phase of the work, including an y sub-consultants . n.Services or data to be provided by the City . o.Any other information that would assist us in making this contract award decision . Compensatio n p.Proposed compensation and payment schedule tied to accomplishing key tasks . Proposal Length and Copie s q.Proposals should be double sided and not exceed 50 pages, including attachments an d supplemental materials . r.Seven copies of the proposal and one electronic copy on a compact disk must b e submitted . 17 C2-22 City of San Luis Obisp o Specification No . 91062 C2 . Proposal Evaluation & Selectio n Proposals will be evaluated by a review committee based on the following criteria : a.Understanding of the work required by the City . b.Proposed approach in completing the work . c.Quality, clarity and responsiveness of the proposal . d.Recent experience in successfully performing similar services . e.Background and related experience of the specific individuals to be assigne d to this project . f.Demonstrated competence and professional qualifications necessary fo r successfully performing the work required by the City . g.References . h.Proposed compensation . As reflected above, contract award will be based on a combination of factors as determined to b e in the best interest of the City and will not be based solely on price . After evaluating th e proposals and discussing them further with the finalists or the tentatively selected contractor, th e City reserves the right to further negotiate the proposed work scope and/or method and amount o f compensation. The following is the anticipated schedule for proposal review and contract award : a .Issue Request for ProposalsWednesday, July 18, 201 2 b .Receive proposals 4 pm, Thursday, August 16, 201 2 c .Complete proposal evaluation Friday, August 24, 201 2 d .Conduct finalist interviews Week of September 3 , 201 2 e :Finalize staff recommendation Friday, September 7, 201 2 f Award and execute contract Week of September 24, 201 2 g .Start work October 1, 2012 18 C2-2 3 City of San Luis Obisp o Specification No . 91062 Section D FORM OF AGREEMENT AGREEMEN T THIS AGREEMENT is made and entered into in the City of San Luis Obispo on [day, date , year] by and between the CITY OF SAN LUIS OBISPO, a municipal corporation, hereinafter referred t o as City, and [CONSULTANT'S NAME IN CAPITAL LETTERS], hereinafter referred to as Consultant . WITNESSET H WHEREAS, on July 17, 2012, City requested proposals for Design Services for the SCAD A System Upgrade Project per Specification No . 91062 . WHEREAS, pursuant to said request, Consultant submitted a proposal that was accepted by Cit y for said services . NOW THEREFORE, in consideration of their mutual promises, obligations and covenant s hereinafter contained, the parties hereto agree as follows : 1.Term .The term of this Agreement shall be from the date this Agreement is made and entered, a s first written above, until acceptance or completion of said services . 2.Start and Completion of Work .Work on this project shall begin within five calendar days after contract execution . Individual projects shall be completed in accordance with approved projec t schedules . 3.Work Delays .Should the Consultant be obstructed or delayed in the work required to be don e hereunder by changes in the work or by any default, act, or omission of the City, or by strikes, fire , earthquake, or any other Act of God, or by the inability to obtain materials, equipment, or labor du e to federal government restrictions arising out of defense or war programs, then the time o f completion may, at the City's sole option, be extended for such periods as may be agreed upon by th e City and the Consultant . In the event that there is insufficient time to grant such extensions prior t o the completion date of the contract, the City may, at the time of acceptance of the work, waiv e liquidated damages that may have accrued for failure to complete on time, due to any of the above , after hearing evidence as to the reasons for such delay, and making a finding as to the causes o f same . Termination .If, during the term of the contract, the City determines that the Consultant is no t faithfully abiding by any term or condition contained herein, or the Consultant's work is determined to be deficient, the City may notify the Consultant in writing of such defect or failure to perform . This notice will give the Consultant a ten calendar day notice of time thereafter in which to perfor m said work or cure the deficiency . If the Consultant has not performed the work or cured the deficiency within the ten days specified i n the notice, such shall constitute a breach of the contract and the City may terminate the contrac t immediately by written notice to the Consultant to said effect . Thereafter, neither party shall hav e any further duties, obligations, responsibilities, or rights under the contract except, however, any an d all obligations of the Consultant's surety shall remain in full force and effect, and shall not b e extinguished, reduced, or in any manner waived by the termination thereof . 19 C2-24 City of San Luis Obisp o Specification No. 91062 In said event, the Consultant shall be entitled to the reasonable value of its services performed fro m the beginning date in which the breach occurs up to the day it received the City's Notice o f Termination, minus any offset from such payment representing the City's damages from such breach . "Reasonable value" includes fees or charges for goods or services as of the last milestone or tas k satisfactorily delivered or completed by the Consultant as may be set forth in the Agreement paymen t schedule ; compensation for any other work, services or goods performed or provided by th e Consultant shall be based solely on the City's assessment of the value of the work-in-progress i n completing the overall workscope . The City reserves the right to delay any such payment until completion or confirmed abandonment o f the project, as may be determined in the City's sole discretion, so as to permit a full and complet e accounting of costs . In no event, however, shall the Consultant be entitled to receive in excess of th e compensation quoted in its proposal . If, at any time during the term of the contract, the City determines that the proposed work is no t feasible due to funding shortages or unforeseen circumstances, the City reserves the right t o terminate the contract. Consultant will be paid compensation due and payable to the date o f termination . 5.Ability to Perform .The Consultant warrants that it possesses, or has arranged through subcontracts , all capital and other equipment, labor, materials, and licenses necessary to carry out and complete th e work hereunder in compliance with any and all applicable federal, state, county, city, and specia l district laws, ordinances, and regulations . 6.Sub-contract Provisions .No portion of the work pertinent to this contract shall be subcontracte d without written authorization by the City, except that which is expressly identified in th e Consultant's proposal . Any substitution of sub-consultants must be approved in writing by the City . For any sub-contract for services in excess of $25,000, the subcontract shall contain all provisions o f this agreement. 7.Contract Assignment .The Consultant shall not assign, transfer, convey or otherwise dispose of the contract, or its right, title or interest, or its power to execute such a contract to any individual o r business entity of any kind without the previous written consent of the City . Inspection .The Consultant shall furnish City with every reasonable opportunity for City to ascertain that the services of the Consultant are being performed in accordance with the requirements an d intentions of this contract . All work done and all materials furnished, if any, shall be subject to th e City's inspection and approval . The inspection of such work shall not relieve Consultant of any of it s obligations to fulfill its contract requirements . 9 . Record Retention and Audit .For the purpose of determining compliance with various laws an d regulations as well as performance of the contract, the Consultant and sub-consultants shall maintai n all books, documents, papers, accounting records and other evidence pertaining to the performance o f the contract, including but not limited to the cost of administering the contract . Materials shall b e made available at their respective offices at all reasonable times during the contract period and for three years from the date of final payment under the contract . Authorized representatives of the Cit y shall have the option of inspecting and/or auditing all records . For Federally funded projects, acces s to records shall also include authorized representatives of the State and Federal government . Copie s shall be furnished if requested . 20 C2-25 City of San Luis Obispo Specification No. 91062 10.Conflict of Interest .The Consultant shall disclose any financial, business, or other relationship wit h the City that may have an impact upon the outcome of this contract, or any ensuing City constructio n project. The Consultant shall also list current clients who may have a financial interest in th e outcome of this contract, or any ensuing City construction project which will follow . The Consultant covenants that it presently has no interest, and shall not acquire any interest—direct , indirect or otherwise-that would conflict in any manner or degree with the performance of the wor k hereunder . The Consultant further covenants that, in the performance of this work, no sub-consultan t or person having such an interest shall be employed . The Consultant certifies that no one who has o r will have any financial interest in performing this work is an officer or employee of the City. It i s hereby expressly agreed that, in the performance of the work hereunder, the Consultant shall at al l times be deemed an independent Consultant and not an agent or employee of the City . 11.Rebates, Kickbacks or Other Unlawful Consideration .The Consultant warrants that this contrac t was not obtained or secured through rebates, kickbacks or other unlawful consideration, eithe r promised or paid to any City employee . For breach or violation of the warranty, the City shall hav e the right in its discretion ; to terminate the contract without liability ; to pay only for the value of the work actually performed ; to deduct from the contract price ; or otherwise recover the full amount o f such rebate, kickback or other unlawful consideration . 12.Covenant Against Contingent Fees .The Consultant warrants by execution of this contract that n o person or selling agency has been employed, or retained, to solicit or secure this contract upon a n agreement or understanding,for a commission, percentage, brokerage, or contingent fee, excepting bona fide employees or bona fide established commercial or selling agencies maintained by th e Consultant for the purpose of securing business. For breach or violation of this warranty, the City ha s the right to annul this contract without liability ; pay only for the value of the work actuall y performed, or in its discretion, to deduct from the contract price or consideration, or otherwis e recover the full amount of such commission, percentage, brokerage, or contingent fee . 13.Compliance with Laws and Wage Rates .The Consultant shall keep itself fully informed of an d shall observe and comply with all applicable state and federal laws and county and City of San Lui s Obispo ordinances, regulations and adopted codes during its performance of the work . This includes compliance with prevailing wage rates and their payment in accordance with California Labor Code . For purposed of this paragraph, "construction" includes work performed during the design an d preconstruction phases of construction, including but not limited to, inspection and land surveyin g work . 14.Payment of Taxes .The contract prices shall include full compensation for all taxes that th e Consultant is required to pay . 15.Permits and Licenses .The Consultant shall procure all permits and licenses, pay all charges an d fees, and give all notices necessary . 16.Safety Provisions .The Consultant shall conform to the rules and regulations pertaining to safet y established by OSHA and the California Division of Industrial Safety . 17.Public and Employee Safety . Whenever the Consultant's operations create a condition hazardous t o the public or City employees, it shall, at its expense and without cost to the City, furnish, erect an d maintain such fences, temporary railings, barricades, lights, signs and other devices and take suc h 21 C2-26 City of San Luis Obispo Specification No . 91062 other protective measures as are necessary to prevent accidents or damage or injury to the public an d employees . 18.Preservation of City Property .The Consultant shall provide and install suitable safeguards , approved by the City, to protect City property from injury or damage . If City property is injured o r damaged resulting from the Consultant's operations, it shall be replaced or restored at th e Consultant's expense . The facilities shall be replaced or restored to a condition as good as when th e Consultant began work . 19.Immigration Act of 1986 .The Consultant warrants on behalf of itself and all sub-consultants engaged for the performance of this work that only persons authorized to work in the United State s pursuant to the Immigration Reform and Control Act of 1986 and other applicable laws shall b e employed in the performance of the work hereunder . 20.Consultant Non-Discrimination .In the award of subcontracts or in performance of this work, th e Consultant agrees that it will not engage in, nor permit such sub-consultants as it may employ, t o engage in discrimination in employment of persons on any basis prohibited by State or Federal law . 21.Accuracy of Specifications .The specifications for this project are believed by the City to b e accurate and to contain no affirmative misrepresentation or any concealment of fact .In preparing it s proposal, the Consultant and all sub-consultants named in its proposal shall bear sole responsibilit y for proposal preparation errors resulting from any misstatements or omissions in the specification s that could easily have been ascertained by examining either the project site or accurate test data i n the City's possession . Although the effect of ambiguities or defects in the specifications will be a s determined by law, any patent ambiguity or defect shall give rise to a duty of Consultant to inquir e prior to proposal submittal . Failure to so inquire shall cause any such ambiguity or defect to b e construed against the Consultant . An ambiguity or defect shall be considered patent if it is of such a nature that the Consultant, assuming reasonable skill, ability and diligence on its part, knew or should have known of the existence of the ambiguity or defect . Furthermore, failure of the Consultant o r sub-consultants to notify City in writing of specification defects or ambiguities prior to proposa l submittal shall waive any right to assert said defects or ambiguities subsequent to submittal of th e proposal . To the extent that these specifications constitute performance specifications, the City shall not b e liable for costs incurred by the successful Consultant to achieve the project's objective or standar d beyond the amounts provided therefor in the proposal . In the event that, after awarding the contract, any dispute arises as a result of any actual or alleged ambiguity or defect in the specifications,or any other matter whatsoever, Consultant shal l immediately notify the City in writing, and the Consultant and all sub-consultants shall continue t o perform, irrespective of whether or not the ambiguity or defect is major, material, minor or trivial , and irrespective of whether or not a change order, time extension, or additional compensation ha s been granted by City . Failure to provide the hereinbefore described written notice within one (1 ) working day of Consultant's becoming aware of the facts giving rise to the dispute shall constitutea waiver of the right to assert the causative role of the defect or ambiguity in the plans or specifications concerning the dispute . 22.Indemnification for Professional Liability .To the fullest extent permitted by law, Consultan t shall indemnify, protect, defend and hold harmless City and any and all of its officials, employee s and agents ("Indemnified Parties') from and against any and all losses, liabilities, damages, cost s 22 " C2-27 City of San Luis Obisp o Specification No. 91062 and expenses, including attorney's fees and costs which arise out of pertain to, or relate to th e negligence, recklessness, or willful misconduct of the Consultant . 23 . Standards .Documents shall conform to City Standards and City furnished templates shall be used . 24 . Consultant Endorsement .Technical reports, plans and specifications shall be stamped and signe d by the Consultant where required . 25 . Required Deliverable Products and Revisions .The Consultant will be required to provid e documents addressing all elements of the workscope . Plans shall be prepared using City's standardized title blocks and coversheets . Draft plans shall be submitted for review in full D (24x36 ) format. Specifications and bid documents shall conform to standard City formats unless authorized . The City's current Standard Specifications and Engineering Standards must be incorporated wher e applicable . City staff will review any documents or materials provided by the Consultant and, where necessary , the Consultant will respond to staff comments and make such changes as deemed appropriate . Submittals shall include the previous marked up submittal (returned to the Consultant) to assist in th e second review . Changes shall be made as requested or a notation made as to why the change is no t appropriate . 2 copies of the draft preliminary reports, technical studies and 50% plans and estimat e 1 copy of the final preliminary reports, technical studies plus markup s 2 copies of the 90% plans, specifications and estimate plus 50% markup s 2 copy of the 100% plans, specifications and estimate plus 90% markup s 1 copy of the final plans, specifications and estimates plus 100% markup s 1 copy of the final record drawings after constructio n Draft reports and plan submittals shall be submitted as paper copies. Final documents and recor d documents shall be submitted as camera-ready original, unbound, each page printed on only one side , including any original graphics in place and scaled to size, ready for reproduction AND on e electronic copy submitted in Adobe Acrobat format including all original stamps and signatures . In the event the City will be compiling the final specifications, incorporating the Consultant's work , the final specifications will also be required to be submitted in Microsoft Word format. In the event the City will be completing the Record Drawings, the final plans will also be required t o be submitted in AutoCAD . Electronic files shall be submitted on CD and all files must be compatible with the Microsoft operating system . Each CD must be clearly labeled and have a printed copy of the directory .File s may be emailed to the City in lieu of putting them on CD . 26 . Ownership of Materials .Upon completion of all work under this contract, ownership and title t o all reports, documents, plans, specifications, and estimates produced as part of this contract wil l automatically be vested in the city and no further agreement will be necessary to ,transfer ownership to the City . The Consultant shall furnish the City all necessary copies of data needed to complete the review and approval process . It is understood and agreed that all calculations, drawings and specifications, whether in hard copy o r machine readable form, are intended for one-time use in the construction of the project for which thi s contract has been entered into . 23 C2-28 City of San Luis Obispo Specification No. 91062 The Consultant is not liable for claims, liabilities, or losses arising out of, or connected with th e modification, or misuse by the City of the machine-readable information and data provided by th e Consultant under this agreement . Further, the Consultant is not liable for claims, liabilities, or losse s arising out of, or connected with any use by City of the project documentation on other projects , except such use as may be authorized in writing by the Consultant . 27.Release of Reports and Information .Any reports, information, data, or other material given to , prepared by or assembled by the Consultant as part of the work or services under these specification s shall be the property of City and shall not be made available to any individual or organization by the Consultant without the prior written approval of the City . The Consultant shall not issue any news release or public relations item of any nature, whatsoever , regarding work performed or to be performed under this contract without prior review of the content s thereof by the City and receipt of the City's written permission . 28.Copies of Reports and Information .If the City requests additional copies of reports, drawings , specifications, or any other material in addition to what the Consultant is required to furnish i n limited quantities as part of the work or services under these specifications, the Consultant shal l provide such additional copies as are requested, and City shall compensate the Consultant for the costs of duplicating of such copies at the Consultant's direct expense . 29.Attendance at Meetings and Hearings .Consultant shall attend as many "working" meetings wit h staff as necessary to accomplish the workscope tasks . Consultant shall attend workshops with th e public, and City commission, committee or Council meetings as identified in the individual projec t scoping . 30.Permit and Filing Fees .The Consultant shall procure all permits, and licenses, pay all charges an d fees and file all notices necessary as they pertain to the completion of the Consultant's work . Th e City will pay all application fees for permits required for the completion of the project work . The City requires a 10 day notice to issue a check . 31.Consultant Invoices .The Consultant shall deliver a monthly invoice to the City, itemized by projec t title . Invoice must include a breakdown of hours billed and miscellaneous charges and any sub - consultant invoices, similarly broken down, as supporting detail . 32.Payment .For providing services as specified in this Agreement, City will pay and Consultant shal l receive therefore compensation in a total sum not to exceed the individual agreed upon project fee . Should the Consultant's designs, drawings or specifications contain errors or deficiencies,th e Consultant shall be required to correct them at no increase in cost to the City . Progress payments shall be made on a monthly basis as invoiced by the Consultant for expense s incurred with cumulative monthly payments, on an individual project basis, not to exceed : 85 percent of the agreed upon project fee prior to submittal of 50 percent document s 95 percent of the agreed upon project fee prior to submittal of final documents ; an d 100 percent of the agreed upon project fee prior to completion of construction or as noted below . The five percent retention until completion of construction shall be released upon completion o f design if the City fails to authorize the advertising for construction within two months following th e acceptance of a complete final submittal by the Consultant . 24 C2-29 City of San Luis Obisp o Specification No . 91062 The Consultant shall be reimbursed for hours worked at the hourly rates attached to this agreement . Hourly rates include direct salary costs, employee benefits, overhead and fee . In addition, th e Consultant shall be reimbursed for direct costs other than salary and vehicle cost that have been identified and are attached to this agreement . The Consultant's personnel shall be reimbursed for pe r diem expenses at a rate not to exceed that currently authorized for State employees under Stat e Department of Personnel Administration niles . 33.Payment Terms .The City's payment terms are 30 days from the receipt of an original invoice an d acceptance by the City of the materials, supplies, equipment or services provided by the Consultan t (Net 30). The Consultant shall pay all sub-consultants within 10 calendar days from receipt of each paymen t made to the Consultant by the City . 34.Resolution of Disputes .Any dispute, other than audit, concerning a question of fact arising unde r this contract that is not disposed of by agreement shall be decided by a committee consisting of th e City's Project Manager and the City Director of Public Works, who may consider written or verba l information submitted by the Consultant . Not later than thirty days after completion of al l deliverables necessary to complete the plans, specifications and estimate, the Consultant may reques t review by the City Council of unresolved claims or disputes, other than audit, in accordance wit h Chapter 1 .20 Appeals Procedure of the Municipal Code . Any dispute concerning a question of fact arising under an audit of this contract that is not dispose d of by agreement, shall be reviewed by the City's Chief Fiscal Officer . Not later than 30 days afte r issuance of the final audit report, the Consultant may request a review by the City's Chief Fisca l Officer of unresolved audit issues . The request for review must be submitted in writing . Neither the pendency of a dispute, nor its consideration by the City will excuse the consultant fro m full and timely performance in accordance with the terms of this contract . 35.Agreement Parties . City : Carrie Mattingly Consultant : City of San Luis Obispo 879 Morro Street San Luis Obispo, CA 9340 1 All written notices to the parties hereto shall be sent by United States mail, postage prepaid b y registered or certified mail addressed as shown above . 36.Incorporation by Reference .City Request for Proposal Specification No . 91062 and Consultant's proposal dated are hereby incorporated in and made a part of this Agreement . 37.Amendments .Any amendment, modification or variation from the terms of this Agreement shall b e in writing and shall be effective only upon approval by the City Engineer . If, at any time during th e project, the consultant is directed to do work by persons other than the City Project Manager and th e Consultant believes that the work is outside of the scope of the original contract, the Consultant shal l inform the Project Manager immediately . If the Proj ect Manager and Consultant both agree that th e work is outside of the project scope and is necessary to the successful completion of the project, the n 25 C2-30 City of San Luis Obisp o Specification No. 91062 a fee will be established for such work based on Consultant's hourly billing rates or a lump sum pric e agreed upon between the City and the Consultant . Any extra work performed by Consultant withou t prior written approval from the City Project Manager shall be at Consultant's own expense . 38 . Complete Agreement .This written agreement, including all writings specifically incorporate d herein by reference, shall constitute the complete agreement between the parties hereto . No ora l agreement, understanding or representation not reduced to writing and specifically incorporate d herein shall be of any force or effect, nor shall any such oral agreement, understanding o r representation be binding upon the parties hereto . For and in consideration of the payments an d agreements hereinbefore mentioned to be made and performed by City, Consultant agrees with Cit y to do everything required by this Agreement, the said specification and incorporated documents . Failure by the Consultant to carry out the requirements of this Agreement is a material breach of thi s agreement which may result in the termination of this Agreement or such other remedy as the Cit y deems appropriate . Authority to Execute Agreement .Both City and Consultant do covenant that each individual executin g this agreement on behalf of each party is a person duly authorized and empowered to execute Agreements for such party . IN WITNESS WHEREOF, the parties hereto have caused this instrument to be executed the day and yea r first above written . CITY OF SAN LUIS OBISPO : Katie Lichtig, City Manage r APPROVED AS TO FORM : CONSULTANT : Christine Dietrick, City Attorney By: 26 C2-31 City of San Luis Obisp o Specification No . 91062 Section E INSURANCE REQUIREMENTS : Consultant Service s The Contractor shall procure and maintain for the duration of the contract insurance against claims fo r injuries to persons or damages to property which may arise from or in connection with the performanc e of the work hereunder by the Contractor, its agents, representatives, employees, or subcontractors . Minimum Scope of Insurance .Coverage shall be at least as broad as : 1.Insurance Services Office Commercial General Liability coverage (occurrence form CG 0001). 2.Insurance Services Office form number CA 0001 (Ed . 1/87) covering Automobile Liability, code 1 (any auto). 3.Workers' Compensation insurance as required by the State of California and Employer's Liabilit y Insurance . 4.Errors and Omissions Liability insurance as appropriate to the consultant's profession . Minimum Limits of Insurance .Contractor shall maintain limits no less than : 1.General Liability : $1,000,000 per occurrence for bodily injury, personal injury and property damage . If Commercial General Liability or other form with a general aggregate limit is used, either th e general aggregate limit shall apply separately to this project/location or the general aggregate limi t shall be twice the required occurrence limit . 2.Automobile Liability : $1,000,000 per accident for bodily injury and property damage . 3.Employer's Liability : $1,000,000 per accident for bodily injury or disease . 4.Errors and Omissions Liability : $1,000,000 per occurrence . Deductibles and Self-Insured Retentions .Any deductibles or self-insured retentions must be declare d to and approved by the City . At the option of the City, either : the insurer shall reduce or eliminate such deductibles or self-insured retentions as respects the City, its officers, officials, employees an d volunteers ; or the Contractor shall procure a bond guaranteeing payment of losses and relate d investigations, claim administration and defense expenses . Other Insurance Provisions .The general liability and automobile liability policies are to contain, or b e endorsed to contain, the following provisions : 1.The City, its officers, officials, employees, agents and volunteers are to be covered as insureds a s respects : liability arising out of activities performed by or on behalf of the Contractor ; products and completed operations of the Contractor ; premises owned, occupied or used by the Contractor ; or automobiles owned, leased, hired or borrowed by the Contractor . The coverage shall contain n o special limitations on the scope of protection afforded to the City, its officers, official, employees , agents or volunteers . 2.For any claims related to this project, the Contractor's insurance coverage shall be primary insuranc e as respects the City, its officers, officials, employees, agents and volunteers . Any insurance or self - insurance maintained by the City, its officers, officials, employees, agents or volunteers shall b e excess of the Contractor's insurance and shall not contribute with it . 3.The Contractor's insurance shall apply separately to each insured against whom claim is made or sui t is brought, except with respect to the limits of the insurer's liability . 4.Each insurance policy required by this clause shall be endorsed to state that coverage shall not b e suspended, voided, canceled by either party, reduced in coverage or in limits except after thirty (30 ) days' prior written notice by certified mail, return receipt requested, has been given to the City . 27 C2-32 City of San Luis Obispo Specification No . 9106 2 Acceptability of Insurers .Insurance is to be placed with insurers with a current A .M . Best's rating of no less than A :VII . Verification of Coverage .Contractor shall furnish the City with a certificate of insurance showin g maintenance of the required insurance coverage . Original endorsements effecting general liability and automobile liability coverage required by this clause must also be provided . The endorsements are to be signed by a person authorized by that insurer to bind coverage on its behalf. All endorsements are to be received and approved by the City before work commences . 28 C2-33 City of San Luis Obisp o Specification No. 91062 Section F PROPOSAL SUBMITTAL FORM S Ft ACKNOWLEDGEMEN T The undersigned declares that she or he has carefully examined Specification No . 91062, whic h is hereby made a part of this proposal ; is thoroughly familiar with its contents ; is authorized t o represent the proposing firm ; and agrees to perform the specified work for the following cos t quoted in full: Description Cos t Design Services for SCADA System Upgrade Projec t Task 1 :Project Kickoff and Site Visit s Task 2 : Stakeholder Workshops _ Task 3:Easement Acquisition Services _ Task 4 : Communication Network Task 5 :Prepare Detailed Design Plans and Specification s Task 6 :Prepare Scope for Integration Services _ Task 7 : Construction and Integration Services Estimate s Task 8 :Construction Phase Support Services TOTAL - $ SignatureofA uthorized Representative Date F2 . INSURANCE CERTIFICAT E q Certificate of insurance attache d Insurance Company's A .M . Best Rating 2 9 Firm Name and Address Contact Phone C2-3 4 City of San Luis Obisp o Specification No . 91062 F3 .. REFERENCE S Number of years engaged in providing the services included within the scope of the specifications unde r the present business name : Describe fully the last three contracts performed by your firm that demonstrate your ability to provide th e services included with the scope of the specifications . Attach additional pages if required . The City reserves the right to contact each of the references listed for additional information regarding your firm's qualifications . Reference No .1 Customer Name Contact Individua l Telephone &FAX numbe r Street Addres s City, State, Zip Code Description of services provide d including contract amount, whe n provided and project outcom e Reference No .2 Customer Name Contact Individua l Telephone & FAX number Street Addres s City, State, Zip Cod e Description of services provided including contract amount, whe n provided and project outcome 30 C2-3 5 City of San Luis Obisp o Specification No . 91062 Reference No .3 Customer Name Contact Individua l Telephone & FAX number Street Addres s City, State, Zip Code Description of services provide d including contract amount, whe n provided and project outcome 31 C2-3 6 City of San Luis Obisp o Specification No. 91062 F4 . STATEMENT OF PAST CONTRACT DISQUALIFICATION S The proposer shall state whether it or any of its officers or employees who have a proprietary interest i n it, has ever been disqualified, removed, or otherwise prevented from proposal on, or completing a federal , state, or local government project because of the violation of law, a safety regulation, or for any othe r reason, including but not limited to financial difficulties, project delays, or disputes regarding work o r product quality, and if so to explain the circumstances . Do you have any disqualification as described in the above paragraph to declare ? Yes q N o Ifyes, explain the circumstances . Executed on at under penalt y of perjury of the laws of the State of California, that the foregoing is true and correct . Signature of Authorized Proposer Representative 32 C2-37 City of San Luis Obisp o Specification No . 91062 PROPOSERS LIS T Design Services for SCADA System Upgrade Project - Specification No . 9106 2 Gene Heyer Tesco Controls, Inc . 3409 52'd Avenu e Sacramento, CA 95823-901 2 Amando Garz a Cannon 1050 Southwood Driv e San Luis Obispo, CA 9340 1 Brian Downing Delta Systems Engineering, Inc . 3550 North Central Avenue, Suite 190 0 Phoenix, Arizona 8501 2 Richard Haugh EMA, Inc . 437 Wyndgate Roa d Sacramento, CA 95864 Matt Barone South Coast Systems, Inc . 2110 E . First St ., Suite 11 0 Santa Ana, CA 92705-4075 Frank Potter FM Controls, LLC 10278 Fareway Ave . Hanford, CA 9323 0 Tom Niebanc k Emerson Process Management 1609 South Grove Ave ., Ste 10 6 Ontario, CA 9176 1 Phil Gaberdiel Westin Engineerin g 300 E. Magnolia Boulevard, Suite 50 3 Burbank, CA 9150 2 Bryan Smith TELESTAR 1717 Solano Way, #3 4 Concord, Ca 9452 0 Jon Hanlon AECO M 1194 Pacific Street, Suite 20 4 San Luis Obispo, CA 9340 1 33 C2-38 City of San Luis Obisp o Specification No. 91062 34 C2-39 City of San Luis Obispo Specification No . 91062 ATTACHMENT A :SCADA Upgrade Assessment Repor t DLT&V, 200 9 A C2-40 DLT&V SYSTEMS ENGINEERIN G SCADA System Upgrad e Assessment Report Client: City of San Luis Obisp o SLO Project No .: 90490A DLT&V Project No .: 1388.0 0 Issue Date : November 4, 200 8 Status : Final Submittal C2-41 SCADA System Assessment TABLE OF CONTENT S 1 .0 Executive Summary 4 2 .0 Purpose 5 3 .0 Existing SCADA System 5 3 .1 Overview 5 3 .2 Water Treatment Plant System 5 3 .3 Whale Rock System 6 3 .4 Water Reclamation Facility System 6 3 .5 Wastewater Collection System 6 3 .6 Water Distribution System 6 4 .0 New SCADA System 7 4.1 Water Treatment Plant System 7 4.2 Whale Rock System 7 43 Water Reclamation Facility System 8 4.4 Wastewater Collection System 8 4.5 Water Distribution System 9 4 .6 Input/Output (I/O) List 9 5 .0 Telemetry System 1 2 5 .1 Existing Systems 1 2 5 .1.1 Water Treatment Plant System 1 2 5 .1 .2 Whale Rock System 1 2 5 .1 .3 Wastewater Collection System 1 4 5.1 .4 Water Distribution System 1 5 5 .2 New System 1 8 5 .2 .1 Radio Survey 1 9 5 .2.2 Water Distribution System Survey 1 9 5 .2 .3 Water Collection System Survey 24 6.0 Conclusion and Recommendations 27 6 .1 Water Treatment Plant System 2 7 6 .2 Whale Rock System 2 7 6.3 Water Reclamation Facility System 29 6 .4 Wastewater Collection System 29 6 .5 Water Distribution System 2 9 6 .6 Design Phase (Plans and Specifications Development) 30 6 .7 Telemetry 30 11/4/200 8 SLO SCADA Assessment Report - Final Submittal.do c NOT FOR CONSTRUCTION Page 1 of 69 C2-42 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessmen t 6 .8 Cost Estimate 30 APPENDIX A Whale Rock System Physical I/O List 32 APPENDIX B Water Distribution Physical I/O List 37 APPENDIX C Wastewater Collection Physical I/O List 55 APPENDIX D Cost Estimate and Breakdown «•68 LIST OF TABLE S Table 5,1– Physical I/O List 1 0 Table 5 .1 - Physical I/O List (Continued):11 Table 5 .2 – Water Treatment Plant Coordinates Table 1 2 Table 5 .3 – Whale Rock System Coordinates Table 1 2 Table 5 .4 – Wastewater Collection Coordinates Table 15 Table 5 .5 – Water Distribution Sites Coordinates Table 1 7 Table 5 .6 – Slack Tank Physical Radio Acceptable Communication Paths :20 Table 5 .7 – Water Treatment Plant Physical Radio Acceptable Communication Paths 20 Table 5 .8 – Bishop Tank Physical Radio Acceptable Communication Paths 2 0 Table 5 .9 – South Hill Physical Radio Acceptable Communication Paths 2 1 Table 5 .10 - Terrace Hill Tank Physical Radio Acceptable Communication Paths 2 1 Table 5 .11 – Corporation Yard Physical Radio Acceptable Communication Paths 2 1 Table 5 .12 Serrano Tank Physical Radio Acceptable Communication Paths 22 Table 5 .13 – Reservoir 2 Physical Radio Acceptable Communication Paths 22 Table 5 .14 – Slack Tank Physical Radio Acceptable Communication Paths 24 Table 5 .15 – Bishop Tank Physical Radio Acceptable Communication Paths 2 4 Table 5 .16 – Corporation Yard Physical Radio Acceptable Communication Paths 2 5 Table 5 .17 – South . Hill Physical Radio Acceptable Communication Paths 25 Table 6 .1– HMI Software Comparisons 2 8 Table 6 .2 – RTU Hardware Comparisons 2 8 11/4/2008 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 2 of 6 9 C2-43 DLTs V SYSTEMS ENGINEERIN G SCADA System Assessment LIST OF FIGURES Figure 5 .1 – Water Treatment Plant and Existing Radio Path Map 1 3 Figure 5 .2 – Whale Rock System Facilities Map 1 4 Figure 5 .3 – Wastewater Collection Facilities and Existing Radio Path Map 1 6 Figure 5 .4 – Water Distribution Existing Radio Path Facilities Map 1 8 Figure 5 .5 Water Distribution Facilities Radio Path Map 23 Figure 5 .6 - Wastewater Collection Facilities Radio Path Map 26 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 3 of 6 9 C2-44 SCADA System Assessmen t 1 .0 Executive Summary This preliminary design report provides an assessment of the existing City of San Luis Obispo, water and wastewater facilities as related to control systems and the associated communications . The systems reviewed include the Whale Rock System, Water Treatment Plant, Water Reclamation Facility, Wastewater Collection System,and Water Distribution System . Each of the systems is operated independent of each other, with different operatin g personnel . The goal of this assessment is to be as objective as possible and ultimately to provide sufficien t information to provide a path forward for all systems over the long term . At this point we will provide some level o f priority to each of the operating sections so planning and budgets can be developed. DLT&V has paid close d attention to raise pertinent questions where necessary and to discuss alternative solutions for high priority items .Our intent is to advise rather than mandate courses of action . Particular consideration has been given in reference to the existing communications utilized. The reason for this i s that the backbone of each of the operating sections is the communications link. If the communication system i s unreliable it results in extra labor, the potential for costly repairs and disruption of service to customers . Current communication technologies allow prompt identification of malfunctions and immediate intervention which can b e accomplished remotely. The water reclamation and water treatment plants have their network communication s primarily onsite and are not currently a major concern . Both plants communication systems are functionin g efficiently and have no issues of outside interference. The wastewater collection system radio communication i s primarily through the Cuesta Peak repeater site and appears to be reliable and is not a main concern at this time . During the radio survey it was determined that all sites within the wastewater collection system could communicat e to Corporation Yard directly or using other water sites as repeaters. Whale Rock system uses leased telephon e service that is adequate but the hardware is approaching end of service life. The primary concern with th e communications network is the radio system for the Water Distribution System . An extensive investigation , including site visits and radio testing in the field, was conducted to fully identify all the concerns with the Wate r Distribution System. Consideration has been given to the future addition of field instruments, such as flow meters, level instruments, an d water quality monitoring instruments ; however, the quantity and location of these instruments must be stipulate d before final design can be initiated. During field site investigations it was revealed on the Water Distribution Syste m that most sites are currently not monitored, which will result in some electrical and instrumentation upgrades t o accommodate future instrumentation and controls . 11/4/2008 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 4 of 69 C2-45 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessment 2 .0 Purpose The purpose of this report is to provide the City of San Luis Obispo with an assessment report which identifie s preliminary findings and proposed recommendations for the Water Treatment Plant System, Whale Rock System , Water Reclamation System, Wastewater Collection System, and Water Distribution System instrumentation an d control systems. Many of these recommendations will result in some electrical, controls, and software engineerin g design which is not part of this assessment report . Design services can be provided in a follow on contract . Sufficient research and field surveys have been conducted to provide status of current systems, recommendations fo r improvements, and cost estimates for these improvements in this assessment report to the City of San Luis Obisp o for their multiple systems . 3.0 Existing SCADA System 3 .1 Overview The City of San Luis Obispo Utilities Department controls consist of five separate systems . The Whale Roc k facilities consists of a control station at Whale Rock, two pump stations, and multiple turnouts which delivers wate r from Whale Rock Dam Office to the CAWO WTP, Dairy Creek Goff Course, CMC and ultimately to the City's Water Treatment Facility . The Water Treatment Plant receives water from the Salinas Reservoir pipeline or Whale Rock. The finished water from the Water Treatment Plant is discharged to the Water Distribution System . Th e Water Distribution System then transfers the finished water to the various pressure zones in the City system by way of pump stations, reservoirs/tanks and pressure regulating stations located through out the City . The Wastewater Collection System is made up of ten sewage lift stations and Poly Vault that transfer waste water t o the Water Reclamation Facility . The Water Reclamation System includes secondary and tertiary treatment of the waste water. A portion of the tertiary treated water is then used for non-potable applications . 3 .2 Water Treatment Plant Syste m The Water Treatment Plant recently completed an upgrade to the Bristol Babcock plant Programmable Logi c Controller (PLC) distributed controls as well as the Intellution Human Machine Interface (HMI). There is one issu e with an upper basin (forebay) that is not currently included in the plant controls . The Control Room includes multiple control stations which are relatively new . The control room also has a monito r and computer for viewing the Water Distribution System for reservoir and tank levels . The control system was recently upgraded during the Water Treatment Plant Improvements Project . Part of this improvement was the installation of fiber optic and CATSe cable for the control system communications . There are no other PLC distributed controls or HMI issues identified . 11/4/2008 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 5 of 69 C2-46 DLTs V SYSTEMS ENGINEERIN G SCADA System Assessmen t 3.3 Whale Rock Syste m The Whale Rock System moves water from the Dam at Whale Rock Reservoir through the pipeline and two pump stations to the City's Water Treatment Plant . There are turnouts on the pipeline to supply water to CAWO WTP, the Dairy Creek golf course and to the correction facility . There is no monitoring at the turnouts. At the golf cours e turnout there is valve open/close control . The system is controlled through a single computer with a DOS base d HMI using leased telephone tone communications . The system functions well but is problematic in terms of servic e and parts replacement. The system can be operated manually if there is a control system failure without creating an y health or safety issues . 3 .4 Water Reclamation Facility Syste m The Water Reclamation Facility System is currently using the Bristol Babcock PLC distributed control system an d various portions of the plant are being upgraded to the current Bristol Babcock technology, which is th e ControlWave version with Ethernet ports . There is no scheduled upgrade to improve communications within the plant for at least five to seven years . In the interim a radio system internal to the Water Reclamation Facility coul d be installed to improve communications and allow operators limited remote access to the control system throughou t the facility. The existing host computer and HMI is approximately ten years old and is functional but without many of the current technology features. The computer and software are functioning but are approaching end of servic e life. 3.5 Wastewater Collection Syste m The Wastewater Collection System uses Bristol Babcock PLC's to monitor the ten lift stations . The system works well with the licensed 900 MHz radio communications system. The HMI host computer hardware and software is o f the same vintage as the Wastewater Reclamation Facility . The limitations of the existing system is the ability to provide alarm data, along with the limited amount of alarms that can in incorporated in the dial out alarming system . For the most part any alarm condition at a lift station results in a common alarm requiring operations staff to drive t o the site to determine the nature of the malfunction . The staff is requesting further investigation to determine i f individual alarms can be provided at each lift station . Based on the age of the installed equipment and th e continuous operation within the next two to three years there will start to be degradation in quality of data bein g monitored ( alarms not being transmitted, inaccurate wetwell levels being transmitted, noise causing signal accurac y to decline, etc) and component failure from reaching end of service life . Replacement of failed components coul d be very costly if models are no longer in production . 3.6 Water Distribution Syste m The Water Distribution System Controls are relatively old and running on a single computer using a DOS base d HMI. The existing communications for the Water Distribution is a variety of radio systems,which is not well documented. There are some Bristol Babcock PLC controls at various pump stations but none of the conditions at pump stations are transmitted to a central control room. The only information available remotely is the reservoir and 11/4/2008 SLO SCADA Assessment Report -Final Submittal.doc NOT FOR CONSTRUCTION Page 6 of 69 C2-47 DLT&V SYSTEMS ENGINEERING SCADA System Assessment tank levels and those are not always available or accurate . These are the same signals shown on the control station at the Water Treatment Plant. Field site visits indicated a strong possibility for developing a good current technology radio communications system for the Water Distribution System controls . 4.0 New SCADA Syste m 4 .1 Water Treatment Plant System The existing Water Treatment Plant utilizes current technology and appears to be operating efficiently and reliably . One upgrade recommended is replacing the monitor and computer system for monitoring the Water Distribution System at the Water Treatment Plant . The upgrade will be part of the Water Distribution upgrades . No other high priorities items required at this time. There are two recommended upgrades that should be considered in a future plant upgrade project. One is adding a basin level signal element at the Forebay that could be brought into the existing SCADA system via a radio link an d provides the Water Treatment Plant staff with the necessary information they need to monitor the basin to increas eprocess control ability at the plant . The second recommendation is installing a Wireless Ethernet system to tie i n with the existing plant communications network . This would give operators the advantage of checking alarms or b e able to operate equipment via laptops when away from the Operations Building . 4 .2 Whale Rock Syste m The existing Whale Rock System is utilizing a single DOS based computer and communicates to the remote sites vi a leased telephone lines . The Whale Rock control system is a legacy system and it is highly recommended that the DOS based system b e replaced first . A new computer with an updated HMI needs to be installed at Whale Rock for monitoring an d controlling the Whale Rock system and to interface with the Water Treatment Plant . Due to the distances involve d and the terrain, leased lines are still the preferred option for communication . It is recommended that the leased line s be upgraded from voice grade to DSL to get the best performance out of the new HMI software . The installed PLC's are near the end of their service life and the product line is being discontinued which will make future repair sdifficult. It is recommended that all four sites have their PLC's upgraded . The advantage this system has is that it can be operated manually if any control component fails, without an y reasonable cost, safety or health related issues while the system is down . This means as existing PLC's and th e computer are being replaced there will be no degradation in the system performance . This is a small system and will make an ideal test of the hardware and software prior to rolling out to the larger systems . The only potential issue would be additional operating cost in the form of operator overtime pay . 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 7 of 6 9 C2-48 SYSTEMS ENGINEERIN G SCADA System Assessment 4.3 Water Reclamation Facility System The existing Water Reclamation Facility System utilizes the Bristol Babcock distributed control system which ha s been expanded over the years with various technical upgrades to accommodate the plant expansions and growin g requirements for reports and data gathering . At this time the system is relatively reliable overall, but som e modifications that should be addressed in the near future are upgrading or replacing the Intellution HMI software to give them more flexibility in regards to reports, trending, etc . This upgrade would also open up the potential fo r installing a WiFi system at the plant to allow the operators to check alarms or operator equipment via laptops whe n away from the Operations Building . 4 .4 Wastewater Collection System The Wastewater Collection System utilizes a reliable radio communications system over licensed radio's from th e lift stations to the Corporation Yard via a repeater site at Cuesta Peak. The Bristol Babcock controls at the existin g ten lift stations are reliable and have served the City well over the years . At this time the system only provide s general alarm information when there is a malfunction at a site . This means the operations staff must drive to the site location to evaluate the specific cause of the problem and determine if corrective actions are required . The field investigation at Prefumo Lift Station indicated that there are additional signals available within the control )cabinet to give the operators better diagnostic capabilities at the Corporation Yard . There would be minimal modifications required (interposing relays, analog signal splitters) to connect these signals to the PLC . It is our tmderstanding that Prefunio Lift Station is typical of the other sites other than the fact the control panel is abov e ground so the signals we noted should be available at the other lift stations. It is noted however that the existin g PLC's cannot accommodate the number of signals that can be obtained at each site . The PLC's appear to b e functioning correctly but the product line is being discontinued which will make future repairs difficult . It is recommended that the PLC's be replaced with new models that have more 10 capability . The HMI host computer for the Wastewater Collections System is a legacy system which is recommended to b e upgraded in the near future . With the upgrading of the software and hardware, it will allow better data collection , alarming functions, and a more reliable system. This upgrade will allow the use of a software based system for a n unlimited amount of alarm notification and would eliminate the need for the existing dial out system which ha s limited capability. The lift stations are using licensed radios. It is recommended that these radios be replaced with unlicensed sprea d spectrum radios. This will eliminate the licensing fee and standardize the Wastewater Collections and Wate r Distribution on the same radio which will reduce cost of spare parts . The antennas will need to be realigned t o utilize the South Hill repeater site or allow communication directly with Corporation Yard . 11/4/200 8 SLO SCADA Assessment Report - Final SubmittaLdoc NOT FOR CONSTRUCTION Page 8 of 6 9 C2-49 SCADA System Assessmen t 4.5 Water Distribution Syste m The current Water Distribution System provides level monitoring for some reservoirs and tanks . There is no monitoring of pump stations and PRV's . At the Corporation Yard there is a single DOS based computer tha t displays the monitored levels. With this little monitoring and no control of the Water Distribution System it bring s up many concerns that should be addressed sooner than later. The Water Distribution System should be one of th e highest priorities for the City to address after the Whale Rock system is updated . It is highly recommended tha t RTU's with the latest model of PLC be installed at all sites and 900MHz radios be used for communication . Replace the computer with the latest technology and install a Windows based HMI . Part of this upgrade will be to replace the computer at the Water Treatment Plant that the operators use to monitor tank levels . 4.6 Input/Output (I/O) Lis t During the field investigations a count of existing I/O was conducted . Then based on interviews with SLO Utilitie s staff members discussing what the desired monitoring and control features were a future I/O count was establishe d for budgeting purposes . These counts are provided in Table 5 .1 . The I/O list that was developed for Whale Roc k System, Wastewater Collection and Water Distribution is in the Appendix . The Future count also include s approximately 25% additional spare points . DLT&V SYSTEMS ENGINEERIN G 11/4/2008 SLO SCADA Assessment Report - Final Submittal .do c NOT FOR CONSTRUCTION Page 9 of 69 C2-50 SCADA System Assessment Existing 110 Future 110 Site Name DI Qty DO Qty Al Qty AO Qty DI Qty DO Qty Al Qty AO Qty Water Treatment Plant N/ANIANIA NIA N/A N/A 1 WA Water Reclamation Facility 507 155 82 72 507 155 82 72 Whale Rock System Whale Rock Dam 00 1 0 5 0 1 0 Pump Station A 7 5 3 5 12 7 10 7 Pump Station B 7 5 3 5 12 7 10 7 Dairy Creek Golf Course Valve 22 0 0 8 3 20 Subtotal 16 12 7 10 37 17 23 1 4 Wastewater Collectio n Airport Lift Station 2 2 3 2 16 3 4 3 Foothill Lift Station 2 2 3 2 16 3 4 3 Howard Johnson Lift Station 2 2 3 2 16 3 4 3 Madonna Lift Station 2 2 3 2 16 3 4 3 Margarita Lift Station 2 2 3 2 16 3 4 3 New Laguna Lift Station 2 2 3 2 16 3 4 3 Prefumo Lift Station 2 2 3 2 16 3 4 3 Poly Vault 0 000 16 3 00_ Rockview Lift Station 2 2 3 2 16 3 4 3 Silver City Lift Station 2 2 3 2 16 3 4 3 Tank Farm Lift Station 2 2 3 2 16 3 4 3 Subtotal 2020 30 20 176 33 40 30 Table 5.1 – Physical 110 List LEGEND DI - Digital Inputs (dry contacts ) DO - Digital Outputs (relay contacts ) Al - Analog Input (signal that varies as measured value varies, typically 4-20mA DC ) AO -Analog Output (a variable value from controller to provide commands for adjustable set points ordisplay values) DLTs V~y SYSTEMS ENGINEERIN G 11/4/2008 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 10 of 69 C2-5 1 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessmen t Existing I/O Future I/O Site Name DI Qty DO Qty Al Qty AO Qty DI Qty DO Qty Al Qty AO Qty Water Distributio n Alrita Pump Station 000 0 16 8 3 2 Bishop Pump Station 000 0 14 520 Bishop Tank 00 0 0 11 0 2 0 Bressi Pump Station 000 0 15 520 Edna Saddle Tank 4 1 3 2 16 343 Ferrini Pump Station 000 0 15 52 0 Ferrini Tank 00 1 0 11 0 2 0 Foothill St. PRV 00 0 0 10 52 0 Grand Ave. Valve 0 0 0 0 10 5 20 Industrial PRV 00 1 0 10 520 Islay Tank 0 0 1 0 11 02 0 Madonna PRV 0 00 0 10 5 20 McCollum Pump Station 2 2 1 0 14 5 2 0 Peach St. PRV 000 0 1510 3 0 Reservoir 1 00 1 0 16 3 3 2 Reservoir 2 0 0 2 0 16 3 4 2 Rosemount Pump Station 00 0 0 15 5 20 Rosemount Tank 0 00 0 11 0 2 0 Serrano Tank 0000 11 020 Slack Tank 0 0 1 0 11 0 2 0 Terrace Hill Tank 0 0 1 0 11 02 0 Subtotal 6 3 122 269 72 49 9 Totals 549 190 1.31 104 989 277194 125 Table S .1-Physical I/O List (Continued ) LEGEN DDI- Digital inputs (dry contacts ) DO - Digital Outputs (relay contacts ) Al - Analog Input (signal that varies as measured value varies,typically 4-20mA DC) AO - Analog Output (a variable value from controller to provide commands for adjustable set points or display values) 11 /4/2008 Page I l of 69 SLO SCADA Assessment Report - Final Submittal.do c NOT FOR CONSTRUCTION C2-52 ) SCADA System Assessmen t 5.0 Telemetry Syste m Si. Existing System s 5.1 .1 Water Treatment Plant Syste m Based on DLT&V's site visit evaluation performed, it was identified that the Water Treatment Plant is a stand alon e system and is not monitored from any other locations in the City . The Water Treatment Plant does have th e capability to received information from the Water Distribution System via a 900 MHZ spread Spectrum radi o repeater at Cuesta Peak . In discussions with the Water Treatment Staff in the past they have had some radi o communications issues to Cuesta Peak . Refer to Table 5.2 for site coordinates and Figure 5 .1 for a map and existing radio paths of the Water Treatmen t Plant System . Site No .Site Name Latitude Longitude Elevation (ft ) Water Treatment Plant 35°19'17 .60"N 120°40'57 .88'W 44 8 2 Cuesta Peak (Water)35°21'36 .30"N 120°39'21 .25'W 2477 Table 5.2 – Water Treatment Plant Coordinates Tabl e 5.1 .2 Whale Rock Syste m Based on DLT&V's site visit evaluation performed, it was identified that the Whale Rock System originall y installed a 900 MHZ spread spectrum system, but throughout the years of trouble shooting the system, it was take n out-of-service and decided to communicate via hardwired leased telephone line back to Whale Rock . Due to the terrain and the locations of the Whale Rock System sites it is recommended to continue with the existing communications via leased line to the associated sites. The leased line is currently voice grade and it should b e upgraded to DSL or Ti . Refer to Table 5.2 for site coordinates and Figure 5.2 for a map of the sites for the Whale Rock System . Site No .Site Name Latitude LongitudeElevation (ft ) 1 Whale Rock 35°26'39 .36"N 120°53'15 .50'W 56 2 Whale Rock Pump Station A 35°25'15 .95"N 120°52'36 .07'W 68 3 Whale Rock Pump Station B 35°20'33 .86"N 120°45'24 .24"W 174 4 Dairy Creek Golf Course Valve 35°19'58.35"N 120°44'3 .10'W 308 Table 5 .3 – Whale Rock System Coordinates Tabl e 11/4/2008 Page 12 of 69 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION *DLT&V SYSTEMS ENGINEERIN G SCADA System Assessmen t Figure 5 .1 — Water Treatment Plant and Existing Radio Path Ma p 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .do o NOT FOR CONSTRUCTION Page 13 of 69 C2-54 SYSTEMS ENGINEERIN G Figure 5.2 – Whale Rock System Facilities Ma p 5.1.3 Wastewater Collection Syste m Based on DLT&V's site visit evaluation performed, it was identified that the Wastewater Collection System sites ar e communicating to the Corporation Yard via a radio repeater site located at Cuesta Peak . The sites are using a licensed 900 MHZ spread spectrum system. In review of the system and in discussions with the Wastewater Collection Staff the communications have been very reliable and they have little to no issues with the existin g communications . Based on these findings the existing Wastewater Collection telemetry system can maintai n reliable communication while Whale Rock System and Water Distribution are upgraded .Toeliminate th e requirement of using Cuesta Peak as a repeater site the licensed radios will need to be replaced with unlicense d 900MHz radios which can utilize the repeater sites established as part of the Water Distribution upgrade . 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .do c NOT FOR CONSTRUCTION Page 14 of 6 9 C2-55 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessmen t Refer to Table 5.3 for site coordinates and Figure 5 .3 for a map and existing radio paths of the Wastewate rt Collection System . Site No .Site Name Latitude Longitude Elevation (ft) 1 Airport Lift Station 35°14'40 .91"N 120°38'29.58"W 16 6 2 Corporation Yard (Wastewater)35°15'21 .21"N 120°40'29 .00"W 13 1 3 Cuesta Peak (Wastewater)35°21'36.30"N 120°39'21 .25'W 2477 4 Foothill Lift Station 35°17'35.50"N 120°41'12 .30'W 283 5 Howard Johnson Lift Station 35°14'34.60"N 120°41'1 .30'W 106 6 Madonna Lift Station 35°15'59 .97"N 120°40'25 ..58'W 160 7 Margarita Lift Station 35°15'25 .53"N 120°40'4 .45'W 14 2 8 New Laguna Lift Station 35°15'5.57"N 120°40'37 .74'W 12 3 9 Prefumo Lift Station 35°15'36 .99"N 120°42'14 .95'W 182 10 Poly Vault 35°17'47 .70"N 120°39'55 .91'W 270 11 Rockview Lift Station 35°15'29 .47"N 120°38'51 .17'W 200 12 Silver City Lift Station 35°14'59 .09"N 120°40'36 .10'W W 107 13 Tank Farm Lift Station 35°14'53.38"N 120°38'35 .39' W 172 Table 5 .4 -- Wastewater Collection Coordinates Tabl e 5 .1 .4 Water Distribution Syste m Based on DLT&V's site visit evaluation performed, it was identified that the Water Distribution System sites hav e multiple different licensed and unlicensed radio systems which operate on multiple different frequencies . It was also identified that many sites do not have means of communication back to the Corporation Yard. Due to the wide variety of radio systems installed at the Water Distribution System sites and the lack o f communication at others the following issues have arose : a)Difficulty in maintaining the telemetry system . b)Identified which sites are communicating with others site . c)Good line of communication to the associated sites . d)Communication interferences from other local radio frequencies in the area . e)Unnecessary equipment at sites that have been abandoned and are not in operation . 11/4/2008 SLO SCADA Assessment Report - Final Submittal .docNOT FOR CONSTRUCTION Page 15 of 6 9 C2-5 6 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessmen t The Water Distribution Staff does not have the ability to know the status or alarms at a site that is no t communicating back to the office .They have to physically go to the site to see if there are outstanding issues . Refer to Table 5 .4 for site coordinates . A map of these sites and the estimated existing radio communication path s are shown in Figure 5.4 – Water Distribution Existing Radio Paths Facilities Map. Figure 5.3 – Wastewater Collection Facilities and Existing Radio Path Ma p 1 1 /4/2008 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 16 of 6 9 C2-57 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessmen t Site No.Site Name Latitude Longitude Elevation (ft) 1 Alrita Pump Station 35°16'8.68"N 120°38'15 .08'W 412 2 Bishop Pump Station 35°16'28 .24"N 120°38'41 .56'W 41 3 3 Bishop Tank 35°16'35 .04"N 120°38'32 .87'W 533 Bressi Pump Station 35°1720 .88"N 120°40'26 .90'W 323 Corporation Yard (Water)35°1520 .68"N 120°40'24.41' W 130 6 Cuesta Peak (Water)35°21'36 .30"N 120°39'21.25' W247 7 7 Edna Saddle Tank 35°1529 .91"N 120°39'16 .50'W 360 8 Fel Mar Pump Station 35°17'55.26"N 120°41'13 .39'W 334 9 Ferrini Pump Station _35°18'26 .97"N 120°40'50 .76"W 323 10 Ferrini Tank 35°1817 .74"N 120°41'19.42'W 586 =Foothill St . PRV 35°17'38.13"N 120°40'13.78'W 25 1 12 Grand Ave Valve 35°17'27.77"N 120°39'11 .42"W 31 3 =Industrial PRV 35°15'12 .94"N 120°3816.67W _ 208 14 Isla Tank 35°14'50 .60"N 120°37'13 .57'W 420 ®Madonna PRV -35°16'4.36"N 120°40'14 .66' W 157 16 McCollum Pump Station 35°17'38 .57"N 120°39'13 .64' W 345 17 Peach St . PRV 35°16'55 .68"N 120°40'1 .38'W 18 7 Reservoir 1 35°17'46 .29"N 120°38'3 .43'W 439 _ Reservoir 2 35°19'41 .44"N 120°40'13 .32"W 55 8 20 Rosemount Pump Station 35°18'1 .59"N 120°41'18 .96'W 542 21 _ Rosemount Tank 35°18'10 .58"N 120°41'32 .41'W 708 ®Serrano Tank 35°17'12 .80"N _ 120°40'40 .78'W 552 =Stack Tank 35°17'45 .52"N 120°38'54.33'W 530 24 Terrace Hill Tank 35°16'18 .14"N 120 0 38'59 .93'W 394 Table 5.5 - Water Distribution Sites Coordinates Tabl e 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 17 of 69 C2-5 8 SCADA System Assessmen t Figure 5.4 – Water Distribution Existing Radio Path Facilities Map 5.2 New System During the site visit evaluation it was determined that a new 2.4 GHz radio backbone connecting Bishop Tank , South Hill,and Corporation Yard would be the preferred method for setting up communication paths. The remainin g sites would communicate over 900MHz radios to one of the three backbone sites . This backbone would allow al l the systems except Whale Rock to communicate to Corporation yard . During the original design the concept of a 2 .4GHz mesh was considered but based on the terrain and vegetation the 900MHz range is needed to provid e reliable communication . Another objective of the survey was to see if the Cuesta Peak Repeater site could be eliminated . By using the 90 0 MHz radios and installing repeaters on South Hill and Bishop Tank all sites could communicate to Corporation Yar d without going to Cuesta other than Reservoir #2 . Based on Reservoir #2's location there is no viable radio path to the south to reach Corporation Yard. However, communication to Reservoir #2 can be established using a cellula r link which would allow the use of Cuesta Peak Repeater to be discontinued . DLT&V SYSTEMS ENGINEERIN G 11/4/2008 SLO SCADA Assessment Report - Final Submittal .do c NOT FOR CONSTRUCTION Page 18 of 69 C2-59 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessmen t The use of 2 .4 GHz backbone will allow bandwidth to add future sites into the system. It will also allow the option of installing video surveillance . 5.2.1 Radio Survey A field radio communication survey was conducted on all the City sites to verify the design concept . Two Freewave 900 MHz radios, a forty foot expandable pole, one 9dB omni antenna and one 6 dB Yagi antenna were used for th e survey. For the radio survey Line of Sight (LOS)and Received Signal Strength (RSL) were the two criteria looked at t o determine a viable communication link . LOS is valid if standing at the location of the transmitting antenna th e receiving antenna can be seen with no obstructions blocking the view . If you can see it, the radio waves will ge t there . The RSL is the strength of the signal at the receiving station in dBm . The RSL value that determined a vali d radio link was -90dBm or higher . The results of the radio survey are detailed in the following tables . In some instances a radio signal had to be relayed two or three times to reach Corporation Yard . 5 .2 .2 Water Distribution System Surve y Water Distribution sites are documented in Tables 5-6 to 5-13 and Figure 5-5 . 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 19 of 69 C2-60 SYSTEMS ENGINEERIN G SCADA System Assessmen t Path Profile RSL (dBm) Test Antenna Gain (dBi) Test Antenna Height Fro m Ground(ft) Test Location Comments Ferrini Pump Station to Slack Tank -69 .0 11/8 20/35 Entrance Gate - Ferrini Tank to Bishop Tank -66.0 11/8 25/35 Entrance Gate to Tank _ Foothill St . PRV to Slack Tank _72,0 11/8 6/35 On Corner o f Intersectio n Grand Ave Valve t o Slack Tank -62 .0 11/8 10/35 On North Side o f Valve _ McCollum Pump Station t o Slack Tank ..66.0 1118 10/35 Entrance Door Peach St . PRV to Slack Tank -73.0 11/8 6/35 In Driveway o f School Near PRV Rosemount Tank to Slack Tank LOSLOS LOS LOS Antenna shall be at a height above the site trees Rosemount Pump Station t o Rose Tank LOS LOS LOS LOS Antenna shall be at a height above the site trees Note 1 : Slack Tank test antenna was located on the Tank mounted near the existing antenna enclosure . Table 5.6 – Slack Tank Physical Radio Acceptable Communication Paths Path Profile (d BRs Lm) Test AntennaGain (Mai) Test Antenna Height Fro m Ground(ft) Test Location Comments Ferrini Pump Station to Water Treatment Plant -73.0 1118 10/35 Entrance Gate - Note 1 : Water Treatment Plant test antenna was located on the top of the Control Room . Table 5.7 — Water Treatment Plant Physical Radio Acceptable Communication Path s Path Profile RS L (dBm) Tes t Antenna Gain (dBi) Test Antenna Height From Ground(ft) Test Location Comments Bishop Pump Station to Bishop Tank -62.0 11/8 15/35 Entrance Doo r Industrial PRV to Bishop Tank "62 .0 11/8 10/35 Gate Before Entering Fiel d Serrano Tank t o Bishop Tank LOSLOS LOS LOS - Note 1 : Bishop Tank test antenna was located on the Tank mounted near the existing antenna . Table 5 .8 — Bishop Tank Physical Radio Acceptable Communication Paths 11/4/2008 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 20 of 69 C2-6 1 DLT&V SYSTEMS ENGINEERIN G SCADA SystemAssessmen t Path Profile (dBm)Test Antenna Gain (dBi) Test Antenn a Height From . Ground(ft) Test Location Comments Alrita Pump Station t o South Pum p Hill LOS LOS LOS Antenna shall be at a height above the site trees Bishop Tank t o South Hill LOS LOS LOS LOS .. Corporation Yard to South Hill LOSLOS LOS LOS - Madonn a South Hill FRV to LOSLOS LOS LOS Antenna shall be at a height above the site trees Slack Tank t o South Hill LOSLOS LOS LOS - Terrace Hill Tank to South Hill LOS LOS LOS LOS - Table 5 .9 -- South Hill Physical Radio Acceptable Communication Path s Path Profile RSL (dBm) Test Antenna Gain (dBi) Test Antenn a Height Fro m Ground(ft) Test Location Comments Islay Tank to Terrace Hill Tank LOSLOS LOS LOS - Note 1 : Terrace Hill Tank test antenna was located on the Tank mounted near the existing antenna . Table 5.10 – Terrace Hill Tank Physical Radio Acceptable Communication Path s Path Profile (dBm )Test Antenna Test Antenn a Height From Test Location Comments Gain (dBi)Ground(ft ) Edna Saddle to Top of tank shootin g Corporation Yard -68 .0 11/8 30140 at gate on backside - of tank Note 1 : Corporation Yard Tank test antenna was located on the top of filters at WRF . Test height was the same a s the existing antennas located on the Corporation Yard Building. Table 5 .11 – Corporation Yard Physical Radio Acceptable Communication Path s 11/4/2008 Page 21 of 69 SLO SCADA Assessment Report - Final Submittal .do c NOT FOR CONSTRUCTION C2-6 2 LT&V SYSTEMS ENGINEERIN G SCADA System Assessment Path Profile (dBm)Test Antenn a Gain (dBi) Test Antenna Height From Ground(fit) Test Location Comments Bressi Pump Station to Serrano Tank LOSLOS LOS LOS - Reservoir 1 to Serrano Tank LOSLOS LOS LOS Reservoir Antenna shal l be mounted in a locatio n that can see Serran o Tank Table 5.12 - Serrano Tank Physical Radio Acceptable Communication Path s Path Profile Bm )Test Antenn a Gain (dBi) Test Antenna Height Fro m Ground(A ' Test Location Comment s Reservoir 2 t o Cuesta Peak LOSLOS LOS LOS Communication lin k already exists . Corporation Yard to Cuesta Peak LOSLOS LOS LOS Communication link already exists. Table 5.13 — Reservoir 2 Physical Radio Acceptable Communication Path s 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 22 of 6 9 C2-6 3 SCADA System Assessment DLT&V SYSTEMS ENS1NEERIN S Figure 5.5 — Water Distribution Facilities Radio Path Ma p -'- 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .do c NOT FOR CONSTRUCTION Page 23 of 69 C2-64 SCADA System Assessment SYSTEMS ENGINEERIN G 5.2.3 Water Collection System Surve y Water Collection sites are documented in Tables 5-14 to 5-17 and Figure 5-6 . Path Profile (dBL TestAntennaGain (dBi) Test AntennaHeight Fro mGround(ft)Test LocationComments Poly Vault to In Parking Lot Next Antenna shall be at a Poly Vault -77.0 11/8 30/35 height above the sit eSlack Tank to Vault trees Foothill Lift Station to Antenna shall be at a Slack Tank -76 .0 11/8 20/35 At Lift Station height above the sitetreesRockview Lift Station to -87.0 11/8 30/35 At Lift Station -Slack Tank Note 1 : Slack Tank test antenna was located on the Tank mounted near the existing antenna enclosure . Table 5 .14 — Slack Tank Physical Radio Acceptable Communication Path s Path Profile (dBm)TestAntennaGain (dBi) Test Antenn aHeight Fro mGround(ft)Test LocationComments Airport Lift Station t oBishop Tank -63 .0 11/8 35/35 In Parking Lot Nex tto Vault Antenna shall be at-aheight above the sit etreesTank Farm Lift Station t oSlack Tank -63.0 11/8 15/35 In Parking Lot ofGas Station - Note 1 ; Bishop Tank test antenna was located on the Tank mounted near the existing antenna. Table 5 .15 – Bishop Tank Physical Radio Acceptable Communication Paths 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 24 of 69 C2-6 5 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessmen t Path Profile (Bm ) Test Antenn a Gain (dBi) Test Antenn a Height Fro m Ground(ft) Test Location Comments Howard Johnson Lift Statio n to Corporation Yard -79 .0 11/8 15/40 At Lift Station - Madonna Lift Station t o Corporation Yard -87 .0 11/8 20/40 At Lift Station - Margarita Lift Station to Corporation Yard -80 .0 11/8 25/40 At Lift Station - New Laguna Lift Station to Corporation Yard LOS LOS LOS LOS - Silver City Lift Station t o Corporation Yard LOS LOS LOS LOS - Note 1 : Corporation Yard Tank test antenna was located on the top of filters at WRF . Test height was the same as the existing antennas located on the Corporation Yard Building . Table 5 .16 - Corporation Yard Physical Radio Acceptable Communication Path s Path Profile (dB L, Test Antenna Gain (dBi) Test Antenn a Height Fro m Ground(ft) Test Location Comment s Prefumo Lift Station t o South Hill LOS LOS LOS LOS Antenna shall be at a height above the line o f site trees near site Table 5 .17 —South Hill Physical Radio Acceptable Communication Paths Page 25 of 6 911/4/2008 SLO SCADA Assessment Report - Final Submittal .do c NOT FOR CONSTRUCTION C2-6 6 SCADA System Assessment DLTs V SYSTEMS ENGINEERIN G Figure 5.6 — Wastewater Collection Facilities Radio Path Map 11/4/200 8 SLO SCADA Assessment Report - Final Subtnittal.do c NOT FOR CONSTRUCTION Page 26 of 6 9 C2-67 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessmen t 6.0 Conclusion and Recommendation s 6.1 Water Treatment Plant Syste m The Water Treatment Plant System is currently in operation with little issues in reference to the overall syste m controls and monitoring . Add level indication at the Upper Basin (Forebay) to the Water Treatment Plant HMI to improve control at th e facility. This is not a high priority, but should be included as part of a future phase upgrade at the Plant . Install a Wireless Ethernet system to tie in with the existing plant communications network .This would give operators the advantage of checking alarms or be able to operate equipment via laptops when away from th e Operations Building . Replace the monitor, computer system, and radio system for the Water Distribution System that provides the Wate r Treatment Plant with the necessary levels for a variety of Tanks and Reservoirs throughout the Water Distributio n System . 6.2 Whale Rock Syste m The Whale Rock System is currently in operation with a system for control and monitoring that is reaching the en d of service life and reduced repair capabilities. This system should be the highest priority for upgrades . It is highly recommended to replace the entire control and monitoring system with newer technology before the system fails an d will have to be manually operated for a Iong length of time before a replacement computer system can be installed . Upgrade or install new PLC's at the Dam, Pump Stations A and B, and the Dairy Creek Golf Course Turnout whic h can provide the necessary monitoring and control at each site . The new PLC's should be able to handle the future physical IO count presented in Table 5-1 . Cost options-developed for Bristol Babcock, Allen Bradley, and SCADA Pack PLC distributed control systems are in Appendix D . Replace the HMI monitor and computer system, and software for the Whale Rock System . Recommended option s would be Wonderware, GE Proficy iFix (formally Intellution) or Control Microsystems Clear SCADA . See Tables 6 .1 and 6 .2 for comparisons of software and hardware. 11/4/2008 Page 27 of 6 9 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION C2-68 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessment Software Advantages Disadvantage s Bristol a) Existing service contract in place . b) Operators familiar with HMI appearanc e and operatio n c) Numerous installs in water / wastewater market . Customers satisfied. a) No local suppor t b) New HMI software . Requires in depth knowledge of software to effectively make all but mino r changes . Wonderware a) A lot of support, not limited to on e support contact b) Proven performer in water / wastewater . WW has developed applications specific to this market . a) High end Redundancy require s multiple server s b) IAS 3 .0/InTouch 10 relatively ne w and still going through growing pains . Requires experienced programmer to make all but minor changes . c) Integrated into Microsoft .NET . Control Microsystems ClearSCADA a) HMI software easy to modify . Extensive training not required . b) Economic pricing. c) Redundancy is extremely simple to setup . d) Operators can easily create ad hoc trends for troubleshooting system, a) Limited local support. Table 6.1- HMI Software Comparison s Hardware Advantages Disadvantage s Bristol a) Newer hardware line so will be supporte d by manufacturer for SCADA system service life b) SLO has install base at treatment plants c) RTU design offers integral radio a) No local vendo r b) Expensiv e Allen-Bradleya) ControlLogix PLC has been a prove n performer for over ten years b) Numerous vendors stock hardware . c) Most integrators are used to working with Allen-Bradley Products . a) Expensiv e b) Due to high demand for product sometimes have extended wai t times for specific parts . Contro l Microsystem s SCADAPAK a) Product has a worldwide presence . CM S has over 25 years experience buildin g hardware. b) RTU's have been successfully used in harsh oil field environment . c) Designed to work with radi o communications over long distances . a) No local vendor. Table 6.2 — RTU Hardware Comparisons 11/4/200 8 SLO SCADA Assessment Report - Final Submittai .doc NOT FOR CONSTRUCTION Page 28 of 69 C2-6 9 'DLT&V SYSTEMS ENGINEERING SCADA System Assessmen t 6.3 Water Reclamation Facility System The Water Reclamation Facility System is currently using the Bristol Babcock PLC distributed control system wit h a single host HMI computer . The following are some recommendations to the system : Continue to upgrade the existing Bristol Babcock PLC's with newer PLC's that have Ethernet communicatio n capabilities and ability to handle future physical IO needs for expanding control within the plant . This is not a hig h priority, but this should be done based on future budget . Replace the monitor and computer system for the Water Reclamation Facility . This system is over ten years old an d the plant should be updated with the newest technology that will provide reporting, trends, etc . 6.4 Wastewater Collection System The Wastewater Collection System is currently using the Bristol Babcock PLC distributed control system with a single host HMI computer . The following are some recommendations to the system : Upgrade or replace the PLC's to have the capability to handle the physical IO increase to allow increase d monitoring and control of the lift stations remotely. The new PLC's should be able to handle the future physical I O count presented in Table 5-1 . Cost opinions developed for Bristol Babcock, Allen Bradley, and SCADA Pack PL C distributed control systems are in Appendix D . Replace the HMI monitor and computer system, and software for the Wastewater Collections Systems . Recommended options would be Wonderware, GE Proficy iFix (formally Intellution) or Control Microsystem s Clear SCADA. Replace the monitor and computer system for the Wastewater Collection System. This system is over ten years old and should be updated with the newest technology that will provide additional features like unlimited alarm callouts , reporting, trends, Internet access, etc . 6.5 Water Distribution Syste m The Water Distribution System in very old and outdated . Much of the system is not monitored remotely and ha s little to no documentation to clearly identify how the system in operating . The following are some recommendations to the system : Upgrade or install new PLC's at the Pump Stations, Reservoirs/Tanks, and PRV's which can provide the necessar y monitoring and control at each site . The new PLC's should be able to handle the future physical IO count presented in Table 5-1 . Cost opinions for Bristol Babcock, Allen Bradley, and SCADA Pack PLC distributed control system s are included in the Appendix D . Refer to Tables 6 .1 and 6 .2 for pros and cons of software and hardware . 11/4/2008 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 29 of 69 C2-70 DLT&V*SYSTEMS ENEINEERIN G SCADA System Assessment Replace the HMI monitor and computer system, and software for the Water Distribution Systems . Recommended options would be Wonderware, GE Proficy iFix (formally Intellution) or Control Microsystems Clear SCADA . Although all of the City facilities have been visited and evaluated it is our recommendation that the Whale Roc k System be given the highest priority . The second system to be upgraded should be Water Distribution o r concurrently with the Whale Rock System . 6 .6 Design Phase (Plans and Specifications Development ) Upon review and acceptance of the recommendations in the final assessment report the consultant will schedule a meeting to discuss options for the City to do the design phase of the project . Once those decisions have bee n mutually agreed upon the consultant can provide a proposal for the development of the design documents, alon g with a schedule, which will include, but not limited to, procurement, test, and installation and integrations of th e recommendations provided. 6 .7 Telemetr y Based on the radio survey it is recommended that a repeater site be established at South Hill and the RTU at Bisho p Tank configured to function as a repeater site also. These two sites and Corporation Yard would be equipped wit h 2.4GHz radios to function as a backbone for the City of San Luis Obispo Water Utilities SCADA network . The radio survey indicated all the systems can utilize this backbone for relaying data from remote sites to their respectiv e control centers using 900MHz unlicensed spread spectrum radios. It is recommended that the licensed radios at th e sewer lift stations be replaced with unlicensed spread spectrum radios with antennas redirected to work with the new backbone . The only site that will be required to use Cuesta Peak as a relay point is Reservoir #2 . Due to the surrounding terrain a radio link cannot be established with any network access point to the south . A possibilit y would be a cell phone link from the PLC to Corporation Yard . A cost analysis would need to be done to see if a cel l phone link would be cost effective compared to keeping the Cuesta Peak repeater site . 6.8 Cost Estimat e See Appendix D for cost estimates . These costs are for budgetary purposes only. More detailed field investigations, design changes (hardware, software), additional 10 added to 10 Lists, and design or construction schedul e constraints can impact cost. The Design and Integration costs are based on an outside consultant not familiar wit h project and no previous knowledge of SCADA assessment report . This estimate does not include any upgrades to electric utilities, Motor Control Centers (MCC), VFD's o r instrumentation other than in Water Distribution. It does not include spare parts or potential Wireless Ethernet o r WiFi system at Water Reclamation Facility or Water Treatment Plant . The Water Reclamation Facility cost estimate is only for upgrading or replacing the HMI system . The hardware cos t associated with it is for new computers. The Labor - Construction budget shown for this site is split between th e 11/4/2008 Page 30 of 69 SLO SCADA Assessment Report - Final Submittal .do c NOT FOR CONSTRUCTION DLTs V SYSTEMS ENGINEERIN G SCA)A System Assessmen t programmers because it is labor for installing the computers and Engineer Construction Management Services . Thi s estimate does not include any cost for allowing future control of equipment at the WRF . The physical I/O is no t available at the PLC's to allow control . Expanding the WRF HMI to have control capability will need to b e addressed at a future date under another scope . The cost estimate for Whale Rock System is based on replacing the PLC in the control panels at the Pump Station A , Pump Station B, and the Dairy Creek Golf Course Turnout . There is no material or labor cost to completely replac e the existing enclosures and back panels . The cost estimate for Wastewater Collection System is based on replacing the PLC and radio in the existing enclosures . There is also coverage for panel wiring modifications to add some 10 points gathered from equipmen t in the existing enclosures . This approach was taken lbecause the motor starters appear to be working correctly an d replacing them would be a substantial cost . The Water Treatment Plant cost estimate is based on adding a total of 30 feet of conduit for routing signal cable at both ends of radio path . 11/4/2008 SLO SCADA Assessment Report -Final Submittal .doc NOT FOR CONSTRUCTION Page 31 of 6 9 C2-72 SCADA System Assessmen t APPENDIX A Whale Rock System Physical I/O Lis t 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 32 of 6 9 C2-73 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessmen t Notes : 1.All "Existing" points identified in the Descriptions column are existing instruments and points on the existin g SCADA system at the facility and will be terminated at the new RTU enclosure . 2.All "Future" points identified in the Descriptions column might need new electrical equipment to provide th e I/O point at the facility . 3.If "Existing" or "Future"is not shown after the description in the Description column,then an instrument shall be instal the field and the I/O point shall be terminated in the new RUT enclosure based on the I/O above . Areas Area No Areas Area No Loop No Descriptio n Akita Pump Station 40100-149 Flow Airport Lift Station 10 Bishop Pump Station 41 150-199Pressure Foothill Lift Station 11 Bressi Pump Station 42 200-299 Level Howard Johnson Lif t Station 12 Ferrini Pump Station 43 300-399 Valves Madonna Lift Station 13 McCollum Pump Station 44 400-499 Pumps Margarita Lift Station 14 Rosemount Pump Station 45500-599RTU/comm s New Laguna Lift Station15Bishop Tank 50600-699 Site Alarm s Poly Vault 16 Edna Saddle Tank 51 800-899 Power Prefumo Lift Station 17 Ferrini Tank 52 900-999 Syste m (HMI ) Rockview Lift Station 18 Islay Tank 53 Silver City Lift Station 19 Rosemount Tank 54 Tank Farm Lift Station20 Serrano Tank 5 5 Slack Tank 56 Terrace Hill Tank 57 Reservoir 1 5 8 Reservoir 2 59 Whale Rock Dam 30 Foothill St . PRV 70 Pump Station A 31 Grand Ave. Valve 7 1 Pump Station B 32 Industrial PRV 72 Dairy Creek Golf Cours e Vlv 33 Madonna PRV 73 Peach St. PRV 74 Tag : Area_Function tdentification Loop # Ex: 54LI20 0 Rosemount Tank Leve l 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 33 of 69 C2-7 4 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessment 30 Whale Rock Dam Offic e TAG DESCRIPTION DISCRETE ANALOG INPUT OUTPUT INPUT OUTPUT FI-100 Dam Effluent Flow (Existing)X JA 500A RTU 120VAC Power Failure Alarm X JA-500BRTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X TOTAL UO 4 0 1 33 Dairy Creek Golf Course Valv e TAG DESCRIPTION DISCRETE ANALO G INPUT OUTPUT INPUT OUTPU T Fl-100Flow to Golf Course (Future)X HS-300A Valve 1 Open Command (Existing)X HS-300B Valve 1 Close Command (Existing)X ZSC-300 Valve 1 Closed Status (Existing)X ZSO-300 Valve I Open Status (Existing)X JA 500A RTU 120VAC Power Failure Alarm X JA 500E RTU 24VDC Power Failure Alarm X JA 5000 RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X TOTAL UO 6 2 1-0 11/4/200 8 SLO SCADA Assessment Report - Final Submittal do e NOT FOR CONSTRUCTION Page 34 of 69 C2-7 5 DLTs V SYSTEMS ENGINEERIN G SCADA System Assessment 31 Pump Station A TAG DESCRIPTION DISCRETE ANALOG INPUTOUTPUTINPUTOUTPU T 00 PS Effluent Flow (Existing)X PIT-150 PS Common Suction Pressure (Existing)X PIT-151 PS Common Discharge Pressure (Existing)X HS-410 Pump 1 Start/Stop Command (Existing)X SC-410 Pump 1 Speed Control (Existing)X SI-410 Pump 1 Speed Indication _ X YL-410 Pump 1 Run Status (Existing)X _ HS-420 Pump 2 Stall/Stop Command (Existing)X SC-420 Pump 2 Speed Control (Existing)X SI-420 Pump 2 Speed Indication X YL-420Pump 2 Run Status (Existing)X HS-430 Pump 3 Start/Stop Command (Existing)X SC-430 Pump 3 Speed Control (Existing)X SI-430Pump 3 Speed Indication X YL-430 Pump 3 Run Status (Existing)X _ HS-440 Pump 4 Start/Stop Command (Existing)X SC-440 Pump 4 Speed Control (Existing) _ X SI-440Pump 4 Speed Indication X YL-440 Pump 4 Run Status (Existing)X HS-450 Pump 5 Start/Stop Command (Existing)X SC-450 Pump 5 Speed Control (Existing)X SI-450 Pump 5 Speed Indication X YL-450Pump 5 Run Status (Existing)X CL-500 Communications Line OK (Existing)X JA-500ARTU 120VAC Power Failure Alarm X JA-500BRTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X TOTAL 110 10 5 _ 8 5 11/4/2008 SLO SCADA Assessment Report - Final Submittal .do e NOT FOR CONSTRUCTION Page 35 of 6 9 'C2-7 6 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessment 32 Pump Station B TAG DESCRIPTION DISCRETE ANALOG INPUT OUTPUTINPUT OUTPUT F1-100 PS Effluent Flow (Existing)X PIT-150 PS Common Suction Pressure (Existing)X PIT-151 PS Common Discharge Pressure (Existing)X HS-410 Pump 1 Start/Stop Command (Existing)X SC-410 Pump 1 Speed Control (Existing)X S1-410 Pump 1 Speed Indication X YL-410Pump 1 Run Status (Existing)X HS-420 Pump 2 Start/Stop Command (Existing)X SC-420 Pump 2 Speed Control (Existing)X SI-420 Pump 2 Speed Indication X YL-420Pump 2 Run Status (Existing)X HS-430 Pump 3 Start/Stop Command (Existing)X SC-430 Pump 3 Speed Control ,(Existing)X SI-430 Pump 3 Speed Indication X YL-430 Pump 3 Run Status (Existing)X HS-440 Pump 4 Start/Stop Command (Existing)X SC-440 Pump 4 Speed Control (Existing)X SI-440 Pump 4 Speed Indication X YL-440Pump 4 Run Status (Existing)X HS-450 Pump 5 Start/Stop Command (Existing)X SC-450 Pump 5 Speed Control (Existing)X SI-450 Pump 5 Speed Indication X YL-450Pump 5 Run Status (Existing)X CL-500 Communications Line OK (Existing)X JA-500A RTU 12OVAC Power Failure Alarm X JA-500BRTU 24VDC Power Failure Alarm X JA-5000 RTU UPS Fault Alarm X TAR-500 RTU High Temp Alarm X TOTAL UO 105 8 5 11/4/2008 SLO SCADA Assessment Report - Final Submittal .do c NOT FOR CONSTRUCTION Page 36 of 69 C2-7 7 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessmen t APPENDIX B Water Distribution Physical I/O List Page 37 of 6 911/4/200 8 SLO SCADA Assessment Report - Final Submitta .l.doc NOT FOR CONSTRUCTION C2-78 SCADA System Assessment Notes: 1.All "Existing" points identified in the Descriptions column are existing instruments and points on the existin g SCADA system at the facility and will be terminated at the new RUT enclosure . 2.All "Future"points identified in the Descriptions column might need new electrical equipment to provide the I/O point at the facility . 3.If "Existing" or "Future" is not shown after the description in theDescription column, then an instrument shall be instal the field and the I/O point shall be terminated in the new RTU enclosure based on the I/O above . Areas Area No Areas Area No Loop No Descriptio n Alrita Pump Station40 100-149 Flow Airport Lift Station 10Bishop Pump Station41150-199Pressure Foothill Lift Station 11 Bressi Pump Station42200-299 Leve l Howard Johnson Lif t Station 12 Ferrini Pump Station 43 300-399 Valve s Madonna Lift Station 13McCollum Pump Station 44400-499 Pump s Margarita Lift Station 14 Rosemount Pum p Station 45500-599 RTU/comm s New Laguna Lift Station 15 Bishop Tank 50600-699 Site Alarm s Poly Vault 16 Edna Saddle Tank 51 800-899 Powe r Prefumo Lift Station 17 Ferrini Tank 52 900-999 Syste m (HMI) Rockview Lift Station 18 Islay Tank 53 Silver City Lift Station 19 Rosemount Tank 54 Tank Farm Lift Station 20 Serrano Tank 55 Slack Tank 56 Terrace Hill Tank 57 Reservoir 1 58 Reservoir 2 59 Whale Rock Dam 30 Foothill St . PRV 70 Pump Station A 31 Grand Ave . Valve 7 1PumpStation B 32Industrial PRV 72 Dairy Creek Golf Cours e VIv 33 Madonna PRV 73 Peach St. PRV 74 Tag : Area_Function Identification_Loop# Ex: 54LI200 Rosemount Tank Leve l 11/4/200 8SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION DLT&V SYSTEMS ENGINEERIN G Page 38 of 6 9 C2-7 9 $DLT&V SYSTEMS ENGINEERIN GERING SCADA System Assessment 50 Bishop Tan k TAG DESCRIPTION DISCRETE ANALOG INPUT OUTPUT INPUT OUTPUT LAN-200 High Level Alarm X LAHH-200 High-High Level Alarm*X LAL-200 Low Level Alarm*X LALL-200 Low-Low Level Alarm X LI-200 Level Indication (Existing)X JA-500ARTU 120VAC Power Failure Alarm X JA-500B RTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X ZA-601 Intrusion At Entry Point(s)X TOTAL I/O 9 0 1 0 * - Floats used for backup pump contro l 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 39 of 69 C2-8 0 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessment 51 Edna Saddle Tan k TAG DESCRIPTION DISCRETE ANALO G INPUT OUTPUT INPUT OUTPU T LAH-200High Level Alarm X LAHH-200High-High Level Alarm X LAL-200 Low Level Alarm X LALL-200Low-Low Level Alarm X LI-200ATank Level Indication X L1-200B Tank Level Local Indicator (Existing)X LI-201 Chem Tank Level (Existing)X HS-400A Chemical Pump Auto Status X HS-400BChemical Pump Remote Status (Future)X HS-400CChemical Pump Start Command (Future)X HS-400DChemical Pump Stop Command (Future)X SC-400 Chemical Pump Speed Control (Future)X SI-400 Chemical Pump Speed Indication (Futures X YA-400 Chemical Pump Fail Alarm (Future)X YL-400 Chemical Pump Run Status (Future)X JA-500A RTU 120VAC Power Failure Alarm K JA-500B RTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500RTU High Temp X ZA-601 Intrusion At Entry Point(s)X TOTAL 110 13`2 3 2 11 /4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 40 of 69 C2-8 1 *DLT&V SYSTEMS ENGINEERIN G SCADA System Assessment 52 Ferrini Tan k TAG DESCRIPTION DISCRETE ANALOG INPUT OUTPUT INPUT OUTPU T LAH-200 High Level Alarm X _ LAHH-200 High-High Level Alarm*X LAL-200 Low Level Alarm*X LALL-200 LowLow Level Alarm X LI-200 Level Indication X JA-500ARTU 120VAC Power Failure Alarm X JA500E RTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X ZA 601 Intrusion At Entry Point(s)X —_ TOTAL I/O 9 0 1 0 * - Floats used for backup pump contro l 53 Islay Tan k TAG DESCRIPTION DISCRETE ANALO G INPUTOUTPUT INPUT OUTPUT LAH-200High Level Alarm X LAHH-200 High-High Level Alarm *X LAL-200 Low Level Alarm *X LALL-200Low-Low Level Alarm X Li 200 Level Indication X JA-500ARTU 120VAC Power Failure Alarm X JA-500BRTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X ZA-601 Intrusion At Entry Point(s)X TOTAL I/O 9 0 1 0 * - Floats used for backup pump contro l 11/4/2008 Page 41 of 69 SLO SCADA Assessment Report - Final Submittai .doc NOT FOR CONSTRUCTION C2-8 2 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessment 54 Rosemount Tan k TAG DESCRIPTION DISCRETE ANALO G INPUT OUTPUTINPUT OUTPUT LAH-200 High Level Alarm X LAHH-200 High-High Level Alarm *X LAL-200 Low Level Alarm *X LALL-200Low-Low Level Alarm X LI-200 Level Indication X JA-500ARTU 120VAC Power Failure Alarm X JA500E RTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X ZA-601 Intrusion At Entry Point(s)X ,TOTAL 110 9 0 1 0 * - Floats used for backup pump contro l 55 Serrano Tan k TAG DESCRIPTION DISCRETE ANALO G INPUT OUTPUT INPUT OUTPU T LAH-200High Level Alarm X LAHH-200 High-High Level Alarm *X LAL-200 Low Level Alarm *X LALL-200 Low-Low Level Alarm X LI-200 Level Indication X JA 500A RTU 120VAC Power Failure Alarm X JA 500E RTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X ZA-601 Intrusion At Entry Point(s)X TOTAL 1/0 9 Q 1 0 * - Floats used for backup pump contro l 11/4/2008 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 42 of 6 9 C2-8 3 ~DLT&V SYSTEMS ENGINEERIN G SCADA System Assessment 56 Slack Tan k TAG DESCRIPTION DISCRETE ANALOG INPUT OUTPUT .INPUT OUTPUT LAH-200 High Level Alarm X LAHH-200 Highh-High Level Alarm *X _ LAL-200 Low Level Alarm *X LALL-200 Low-Low Level Alarm X L1-200 Level Indication X JA-500ARTU 120VAC Power Failure Alarm X JA-500B RTU 24VDC Power Failure Alarm _ X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X ZA-601 Intrusion At Entry Point(s)X _ TOTAL I/O 9 0 1 0 * - Floats used for backup pump contro l 57 Terrace Hill Tan k TAG DESCRIPTION DISCRETE ANALOG INPUTOUTPUTINPUTOUTPUT LAH-200 High Level Alarm X _ LAHH-200 High-High Level Alarm *X _ LAL-200 Low Level Alarm *X TLALL-200 Low-Low Level Alarm _ X LI-200 Level Indication X ~_ JA-500ARTU 120VAC Power Failure Alarm X _ JA-500B RTU 24VDC Power Failure Alarm X _ JA-500CRTU UPS Fault Alarm X _ TAH-500 RTU High Temp Alarm X _._ ZA-601 Intrusion At Entry Point(s)X _ TOTAL I/O 9 0 1 0 * - Floats used for backup pump contro l 11/4/2008 Page 43 of 6 9 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION C2-8 4 SYSTEMS ENGINEERIN G SCADA System Assessment 58 Reservoir 1 TAG DESCRIPTION DISCRETE ANALOG INPUTOUTPUTINPUT OUTPUT LAH-200 High Level Alarm X LAHH-200 High-High Level Alarm*X LAL-200 Low Level Alarm*X LALL-200 Low-Low Level Alarm X LI-200 Level Indication (Existing)X HS-400A Chemical Pump Remote Status (Future)X HS-400B Chemical Pump Start Command (Future)X HS-400C Chemical Pump Stop Command (Future)X SC-400 Chemical Pump Speed Control (Future)X SI-400 Chemical Pump Speed Indication (Future)X YA-400 Chemical Pump Fail Alarm (Future)X YL-400 Chemical Pump Run Status (Future)X JA-500A RTU 120VAC Power Failure Alarm X JA-500BRTU 24VDC Power Failure Alarm X JA 5000 RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X ZA-601 Intrusion At Entry Point(s)X TOTAL UO 122 2 1 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .do c NOT FOR CONSTRUCTION Page 44 of 69 C2-8 5 D L T&V SYSTEMS ENGINEERIN G SCADA System Assessment 59 Reservoir 2 TAG DESCRIPTION DISCRETE ANALOG INPUTOUTPUTINPUT OUTPUT LI-110 Basin I Level Indication (East) (Existing)X LI-120 Basin 2 Level Indication (West) (Existing)X !AK -210 Basin 1 High Level Alarm X LAHH-210 Basin lHigh-High Level Alarm*X LAL-210 Basin 1 Low Level Alarm*X LALL-210Basin 1 Low-Low Level Alarm X LAH-220 Basin 2 High Level Alarm X LAHH-220 Basin 2High-High Level Alarm*X LAL-220 Basin 2 Low Level Alarm*X LALL-220 Basin 2 Low-Low Level Alarm X HS-400A Chemical Pump Remote Status (Future)X HS-400B Chemical Pump Start Command (Future)X HS-400C Chemical Pump Stop Command (Future)X SC-400 Chemical Pump Speed Control (Future)X SI-400 Chemical Pump Speed Indication (Future)X YA-400 Chemical Pump Fail Alarm (Future)X YL-400Chemical Pump Run Status (Future)X JA-500A RTU 120VAC Power Failure Alarm X JA-500BRTU 24VDC Power Failure Alarm X A-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X ZA-601 Intrusion At Entry Point(s)X TOTAL 110 16 2 3 1 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR. CONSTRUCTION Page 45 of 69 C2-8 6 SCADA System Assessment 70 Foothill St, PRV TAG DESCRIPTION DISCRETE ANALO G INPUTOUTPUTINPUT OUTPU T F1-100 Valve 1 Flow Indication (Future)X HS-300A Valve 1 Open Command Full X HS-300B Valve 1 Open Command 3/4 (Future)X HS-300C Valve 1 Open Command 1/2 (Future)X HS-300DValve 1 Close Command X ZSC-300 Valve 1 Closed Status X ZSO-300 Valve I Open Status X JA 500A RTU 120VAC Power Failure Alarm X _ JA-500BRTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X LAH-600 Vault Flooding Alarm X ZA-601 Intrusion At Entry Point(s)X TOTAL UO 8 4 1 0 71 Grand Ave. PRV TAG DESCRIPTION DISCRETE ANALO G INPUT OUTPUT INPUT OUTPUT FI-100 Valve 1 Flow Indication (Future)X HS-300AValve 1 Open Command Full X HS-300B Valve 1 Open Command 3/4 (Future)X HS-300C Valve I Open Command 1/2 (Future)X HS-300D Valve 1 Close Command X ZSC-300 Valve I Closed Status X ZSO-300 Valve I Open Status X JA-500A RTU 120VAC Power Failure Alarm X JA-500B RTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X LAH-600 Vault Flooding Alarm X ZA-601 Intrusion At Entry Point(s)X TOTAL I/O 8 4 1 0 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 46 of 6 9 C2-8 7 SCADA . SystemAssessment 72 Industrial PR V TAG DESCRIPTION DISCRETE ANALO G INPUT OUTPUT INPUTOUTPUT Fl-100 Valve 1 Flow Indication (Future)X HS-300A Valve I Open Command Full X HS-300B Valve I Open Command 3/4 (Future)X HS-300C Valve 1 Open Command 1/2 (Future)X HS-300D Valve I Close Command X ZSC-300 Valve I Closed Status X ZSO-300 Valve I Open Status X JA-500ARTU 120VAC Power Failure Alarm X JA-5008 RTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X LAH-600 Vault Flooding Alarm X ZA-601 Intrusion At Entry Point(s)X TOTAL I/O 8 4 1 0 73 Madonna PRV TAG DESCRIPTION DISCRETE ANALO G INPUT OUTPUTINPUTOUTPUT Fl-100 Valve 1 Flow Indication (Future)X HS-300A Valve 1 Open Command Full X _ HS-300B Valve 1 Open Command 3/4 (Future)X HS-300C Valve I Open Command 1/2 (Future)X —_ HS-300D Valve I Close Command X _ ZSC-300 Valve I Closed Status X ZSO-300 Valve 1 Open Status X JA-500A RTU 120VAC Power Failure Alarm X _ JA-500B RTU 24VDC Power Failure Alarm JA-500C RTU UPS Fault Alarm X TAH-500RTU High Temp Alarm X LAH-600 Vault Flooding Alarm X ZA-601 Intrusion At Entry Point(s)X TOTAL I/O 8 4 1 0 DLT&V SYSTEMS ENGINEERIN G 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doe NOT FOR CONSTRUCTION Page 47 of 69 . C2-8 8 ',DLT&V SYSTEMS ENGINEERIN G SCADA System Assessment 74 Peach St PRV V . TAG DESCRIPTION DISCRETE ANALO G INPUT OUTPUT INPUT OUTPU T Fl-100 Valve 1 Flow Indication (Future)X Fl-110 Valve 2 Flow Indication (Future)X HS-300A Valve I Open Command Full X HS-300B Valve 1 Open Command 3/4 (Future)X HS-300C Valve I Open Command 1/2 (Future)X HS-300D Valve 1 Close Command X ZSC-300 Valve I Closed Status X ZSO-300 Valve 1 Open Status X HS-310A Valve 2 Open Command Full X HS-310B Valve 2 Open Command 3/4 (Future)X HS-310C Valve 2 Open Command 2/2 (Future)X. HS-310D Valve 2 Close Command X ZSC-310 Valve 2 Closed Status X ZSO-310 Valve 2 Open Status X JA-500A RTU 120VAC Power Failure Alarm X JA-500B RTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X LAH-600 Vault Flooding Alarm X ZA-601 Intrusion At Entry Point(s)X TOTAL I/O 10 8 2 0 11/4/2008 SLO SCADA Assessment Report - Final Submittal .do c NOT FOR CONSTRUCTION Page 48 of 69 C2-8 9 DLT&V,SYSTEMS ENGINEERIN G SCADA System Assessment 40 Akita Pump Statio n TAG DESCRIPTION DISCRETE .ANALOG INPUTOUTPUTINPUTOUTPUT F1-100 Flow Indication X HS-410A Pump 1 Remote Status X HS-4108 Pump I Start Command (Future)X HS-410C Pum 1 Stop Command Future X YA-410 Pump I. Fail Alarm X YL-410 Pump 1 Run Status X HS-420A Pump 2 Remote Status X HS-420B Pump 2 Start Command Future X HS-420C Pump 2 Sto Command (Future)X YA-420Pump 2 Fail Alarm X YL-420Pump 2 Run Status X HS-430A Fire Pump Remote Status X HS-430B Fire Pump Start Command (Future X HS-430C Fire Pump Stop Command (Future)X SC-430 Fire Pump Speed Control X S1-430 Fire Pump Speed Indication (Future)X YA-430 Fire Pump Fail Alarm X YL-430 Fire Pump Run Status X JA-500ARTU 120VAC Power Failure Alarm X JA-500B RTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X ZA-601 Intrusion At Entry Point(s)X TOTAL 110 14 6 2 1 11/4/2008 Page 49 of 69 SLO SCADA Assessment Report - Final Submittal .doe NOT FOR CONSTRUCTION C2-90 SCADA System Assessment 41 Bishop Pump Statio n TAG DESCRIPTION DISCRETE ANALO G INPUT OUTPUT INPUT OUTPUT FI-100 Flow indication (Future)X HS-410A Pump 1 Remote Status X HS-410B Pump 1 Start Command (Future)X HS-410C Pump I Stop Command (Future)X YA-410 Pump 1 Fail Alarm (Future)X YL-410 Pump 1 Run Status (Future)X HS-420A Pump 2 Remote Status (Future)X HS-420BPump 2 Start Command (Future)X HS-420C Pump 2 Stop Command (Future)X YA-420 Pump 2 Fail Alarm (Future)X YL-420 Pump 2Run Status (Future)X JA-500A RTU 120VAC Power Failure Alarm X JA-500B RTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X ZA-601 Intrusion At Entry Point(s)X TOTAL I/O 11 4 1 0 11/4/2008 Page 50 of 69 SLO SCADA Assessment Report - Final Submittal .do c NOT FOR CONSTRUCTIO N SCADA System Assessment 42 Bressi Pm Station TAG DESCRIPTION DISCRETE ANALO G INPUT OUTPUT INPUTOUTPUT Fl-100Flow Indication (Future)X HS-410A Pump 1 Remote Status (Future)X HS-410B Pump 1 Start Command (Future)X HS-410CPump 1 Stop Command (Future)X YA-410 Pump 1 Fail Alarm (Future)X YL-410 Pump 1 Run Status (Future)X _ HS-420APump 2 Remote Status (Future)X _ HS-420B Pump 2 Start Command (Future)_X HS-420C Pump 2 Stop Command (Future)X YA-420 Pump 2 Fail Alarm (Future)X YL-420 Pump 2 Run Status (Future)X JA-500ARTU 120VAC Power Failure Alarm X JA-500B RTU 24VDC Power Failure Alarm X JA-5000 RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X ZA-601 Intrusion At Entry Point(s)X TOTAL I/O 11 4 1 0 11/4/2008 SLO SCADA Assessment Report - Final Submittal do c NOT FOR CONSTRUCTION Page 51 of 6 9 C2-92 SYSTEMS ENGINEERIN G SCADA System Assessment 43 Ferrini Pump Station TAG DESCRIPTION DISCRETE ANALOG INPUT OUTPUT INPUT OUTPU T FI-100 Flow Indication (Future)X HS-410A Pump 1 Remote Status (Future)X HS-410B Pump 1 Start Command (Future)X HS-410C Pump 1 Stop Command (Future)X YA-410 Pump 1 Fail Alarm (Future)X YL-410 Pump 1 Run Status (Future)X HS-420A Pump 2 Remote Status (Future)X HS-420B Pump 2 Start Command (Future)X HS-420C Pump 2 Stop Command (Future)X YA-420 Pump 2 Fail Alarm (Future)X YL-420 Pump 2 Run Status (Future)X JA-500ARTU 120VAC Power Failure Alarm X JA 500E RTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X ZA-601 Intrusion At Entry Point(s)X TOTAL 110 11 4 1 0 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 52 of 69 C2-9 3 DLT&V SYSTEMS ENGINEERIN G SCADASystem Assessment 44 McCollum Pum p Statio n TAG DESCRIPTION DISCRETE ANALOG INPUT OUTPUT INPUT OUTPU T Fl-100 Flow Indication (Future)X _ HS-410A Pump 1 Remote Status (Future)X HS-410B Pump 1 Start Command (Future)X HS-410C Pump 1 Stop Command (Future)X YA-410 Pump 1 Fail Alarm (Future)X YL-410 Pump I Run Status (Future)X _ HS-420A Pump 2 Remote Status (Future)X _ _ HS-420B Pump 2 Start Command (Future)X _ HS-420C Pump 2 Stop Command (Future)X YA-420Pump 2 Fail Alarm (Future)X YL-420 Pump 2 Run. Status (Future)X — JA-500A RTU 120VAC Power Failure Alarm X JA-500BRTU 24VDC Power Failure Alarm _ X _ JA-500C -RTU UPS Fault Alarm ^X _ TAM-500 RTU High Temp Alarm X ZA-601 Intrusion At Entry Point(s)X TOTAL 110 _ 11 4 _ 1 0 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .do c NOT FOR CONSTRUCTION Page 53 of 69 C2-94 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessment 45 Rosemount Pump Statio n TAG DESCRIPTION DISCRETE ANALO G INPUT OUTPUT INPUTOUTPUT Fl-100Flow Indication (Future)X HS-410APump 1 Remote Status (Future)X HS-410B Pump I Start Command (Future)X HS-410C Pump 1 Stop Command (Future)X YA-410 Pump 1 Fail Alarm (Future)X YL-410 Pump I Run Status (Future)X HS-420A Pump 2 Remote Status (Future)X HS-420B Pump 2 Start Command (Future)X HS-420C Pump 2 Stop Command (Future)X _ YA-420 Pump 2 Fail Alarm (Future)X YL-420 Pump 2 Run Status (Future)X JA-500A RTU 120VAC Power Failure Alarm X JA 500B RTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X ZA-601 Intrusion At Entry Point(s)X TOTAL 110 11 4 1 0 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 54 of 69 C2-9 5 *DLT&V SYSTEMS ENGINEERIN G SCADA System Assessmen t APPENDIX C Wastewater Collection Physical I/O Lis t 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 55 of 69 C2-96 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessmen t Notes: 1.All "Existing" points identified in the Descriptions column are existing instruments and points on the existin g SCADA system at the facility and will be terminated at the new RTU enclosure . 2.All "Future" points identified in the Descriptions column might need new electrical equipment to provide th e I/O point at the facility . 3.If "Existing" or "Future" is not shown after the description in the Description column, then an instrument shall be insta l the field and the I/O point shall be terminated in the new RTU enclosure based on the I/O above . Areas Area No Areas Area No Loop No Descriptio n Akita Pump Station 40 100-149 Flow Airport Lift Station 10 Bishop Pump Station 41 150-199Pressure Foothill Lift Station 11 Bressi Pump Station 42 _200-299 Level Howard Johnson Lift Station 12 Ferrini Pump Station 43 300-399 Valves Madonna Lift Station 13 McCollum Pump Station44400-499 Pump s Margarita Lift Station 14 Rosemount Pump Station 45500-599RTU/comm s New Laguna Lift Station 15 Bishop Tank 50600-699 Site Alarms Poly Vault 16 Edna Saddle Tank 51 800-899 Power Prefumo Lift Station 17 Ferrini Tank 52 900-999 System (HMI) RockvtewLift Station 18 Islay Tank 53 Silver City Lift Station 19 Rosemount Tank 54 Tank Farm Lift Station 20 Serrano Tank 55 Slack Tank 56 Terrace Hill Tank 57 Reservoir 1 58 Reservoir 2 59 Whale Rock Dam 30 Foothill St. PRV 70 Pump Station A 31 Grand Ave. Valve 7 1 Pump Station B 32 Industrial PRV 72 Dairy Creek Golf Course Vlv 33 Madonna PRV 73 Peach St . PRV 74 Tag : Areaw_Function Identifrcatton_Loop # Ex : 54L1200 Rosemount Tank Leve l 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 56 of 6 9 C2-9 7 *DLTs V SYSTEMS ENGINEERIN G SCADA System Assessment 10 Airport Lift Statio n TAG DESCRIPTION DISCRETE ANALO G INPUTOUTPUTINPUTOUTPUT LI-200 Level Indication (Existing)X LAH-200 Wetwell High Level Alarm (Existing)X LAL-200 Wetwell Low Level Alar m HS-410 Pump 1 Start/Stop Command (Existing)X SC-410 Pump 1 Speed Setpoint (Existing)X SI-410 Pump 1 Speed Indication (Existing)X YA-410APump 1 Motor Seal Leak X YA-410BPump 1 Motor Overtemp X YL-410 Pump 1 Run Status X HS-420 Pump 2 Start/Stop Command (Existing)X SC-420 Pump 2 Speed Control (Existing)X SI-420 Pump 2 Speed Indication (Existing)X YA-420APump 2 Motor Seal Leak X YA-420BPump 2 Motor Overtemp X YL-420Pump 2 Run Status X JA-500A RTU 120VAC Power Failure Alarm (Existing)X JA-500BRTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X LAH-600Drywell Flooding X ZA-601 Intrusion At Entry Point(s)X TOTAL 110 142 32 11/412008 SLO SCADA Assessment Report - Final Submittal .do c NOT FOR CONSTRUCTION Page 57 of 6 9 C2-9 8 SCADA System Assessment DLT&V SYSTEMS ENGINEERIN G 11 Foothill Lift Statio n TAG DESCRIPTION DISCRETE ANALOG INPUT OUTPUT INPUT OUTPU T L1-200 Level Indication (Existing)X LAH-200 Wetwel High Level Alarm (Existing)X LAL-200 Wetwell Low Level Alarm X HS-410 Pump 1 Start/Stop Command (Existing)X SC-410 Pump 1 Speed Setpoint (Existing)X SI-410 Pump 1 Speed Indication (Existing)X YA-410APump 1 Motor Seal Leak X VA-410B Pump 1 Motor Overtemp X YL-410Pump 1 Run Status X HS-420 Pump 2 Start/Stop Command (Existing)X SC-420 Pump 2 Speed Control (Existing)X S1-420 Pump 2 Speed Indication (Existing)X YA-420APump 2 Motor Seal Leak X YA-420B Pump 2 Motor Overtemp X YL-420 Pump 2 Run Status X JA-500ARTU 120VAC Power Failure Alarm (Existing)X JA 5008 RTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X LAH-600 Drywell Flooding X ZA-601 Intrusion At Entry Point(s)X TOTAL I/O 1423 2 11/4/2008 Page 58 of 6 9 SLO SCADA Assessment Report - Final Submittal,do c NOT FOR CONSTRUCTION DLT&V SYSTEMS ENGINEERIN G SCADA System Assessment 12 Howard Johnson Lift Statio n TAG DESCRIPTION DISCRETE ANALO G INPUT OUTPUTINPUT OUTPU T LI-200 Level Indication (Existing)X LAH-200 Wetwell High Level Alarm (Existing)X LAL-200 Wetwell Low Level Alarm X HS-410 Pump 1 Start/Stop Command (Existing)X SC-410Pump 1 Speed Setpoint (Existing)X SI-410 Pump 1 Speed Indication (Existing)X YA-410APump 1 Motor Seal Leak X YA-410BPump 1 Motor Overtemp X YL-410 Pump I Run Status X HS-420 Pump 2 Start/Stop Command (Existing)X SC-420 Pump 2 Speed Control (Existing)X SI-420 Pump 2 Speed Indication (Existing)X YA-420A Pump 2 Motor Seal Leak X YA-420BPump 2 Motor Overtemp X YL-420 Pump 2 Run Status X JA-500A RTU 120VAC Power Failure Alarm (Existing)X JA-500BRTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500RTU High Temp Alarm X LAH-600Drywell Flooding X ZA-601 Intrusion At Entry Point(s)X TOTAL I/O 1423 2 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 59 of 69 C2-10 0 SCADA System Assessment 13 Madonna Lift Statio n TAG DESCRIPTION DISCRETE ANALOG INPUT OUTPUT INPUT OUTPUT L1-200 Level indication (Existing)X LAH 200 Wetwell High Level Alarm (Existing)X LAL-200 Wetwell Low Level Alarm X HS-410 Pump 1 Start/Stop Command (Existing)X _ SC-410 Pump 1 Speed Setpoint (Existing)X S1-410 Pump I Speed Indication (Existing)X YA-410APump 1 Motor Seal Leak X VA-410B Pump I Motor Overtemp X YL-410 Pump I Run Status X HS-420 Pump 2 Start/Stop Command (Existing)X SC-420 Pump 2 Speed Control (Existing)X S1-420 Pump 2 Speed Indication (Existing)X YA-420APump 2 Motor Seal Leak X VA-420BPump 2 Motor Overtemp X YL-420Pump 2 Run Status X JA-500ARTU 120VAC Power Failure Alarm (Existing)X JA-500BRTU 24VDC Power Failure Alarm _ X JA-500C RTU UPS Fault Alarm X TM-500 RTU High Temp Alarm X LAH-600 Drywall Flooding X ZA-601 Intrusion At Entry Point(s)X TOTAL I/O 1423 2 11/4/2008 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 60 of 6 9 C2-10 1 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessment 14 Maruarita Lift Statio n TAG DESCRIPTION DISCRETE ANALOG INPUT OUTPUT INPUT OUTPUT L1-200 Level Indication (Existing)X LAH-200 Wetwell High Level Alarm (Existing)X LAL-200 Wetwell Low Level Alarm X HS-410 Pump 1 Start/Stop Command (Existing)X SC-410 Pump 1 Speed Setpoint (Existing)X SI-410 Pump 1 Speed Indication (Existing)X _ YA-410A Pump 1 Motor Seal Leak X YA-410BPump 1 Motor Overtemp X YL-410Pump 1 Run Status X HS-420 Pump 2 Start/Stop Command (Existing)X SC-420 Pump 2 Speed Control (Existing)X SI-420 Pump 2 Speed Indication (Existing)X _YA-420A Pump 2 Motor Seal Leak X YA-420BPump 2 Motor Overtemp X YL-420Pump 2 Run Status X JA-500A RTU 120.VAC Power Failure Alarm (Existing)X JA-500BRTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X LAH-600 Drywell Flooding X ZA-601 Intrusion At Entry Point(s)X TOTAL I/O 142 3 2 11/4/2008 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION Page 61 of 69 C2-10 2 SCADA System Assessment 15 New Laguna Lift Statio n TAG DESCRIPTION DISCRETE ANALOG INPUTOUTPUTINPUT OUTPUT LI-200 Level Indication lExisting)X LAH-200 Wetwell High Level Alarm (Existing)X LAL-200 Wetwell Low Level Alarm X HS-410 Pump 1 StartlStop Command (Existing)X SC-410 Pump 1 Speed Setpoint (Existing)X SI-410 Pump I Speed Indication (Existing)X YA-410A Pump 1 Motor Seal Leak X YA-410BPump 1 Motor Overtemp X YL-410 Pump 1 Run Status X HS-420 Pump 2 StartlStop Command (Existing)X SC-420 Pump 2 Speed Control (Existing)X SI-420 Pump 2 Speed Indication (Existing)X YA-420APump 2 Motor Seal Leak X YA-420B Pump 2 Motor Overtemp X YL-420Pump 2 Run Status X JA-500A RTU 1.20VAC Power Failure Alarm (Existing)X JA-500BRTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X LAH-600 Drywell Flooding X ZA-601 Intrusion At Entry Point(s)X TOTAL 110 14 2 3 2 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .do c NOT FOR CONSTRUCTION Page 62 of 6 9 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessment Poly Vault TAG DESCRIPTION DISCRETE ANALOG INPUTOUTPUTINPUTOUTPUT LI-200 Level Indication {Existing)X _ LAH-200 Wetwell High Level Alarm (Existing)X LAL 200 _ Wetwell Low Level Alarm X HS-410 Pump 1 Start/Stop Command (Existing ) SC-410 Pump 1 Speed Setpoint (Existing)X _ SI-410 Pump I Speed Indication (Existing)X - YA-410APump 1 Motor Seal Leak X YA-410B Pump 1 Motor Overtemp X YL-410 Pump 1 Run Status _ X HS-420 Pump 2 Start/Stop Command (Existing)_X SC-420 Pump 2 Speed Control (Existing)X _ SI-420 Pump 2 Speed Indication (Existing),X YA-420A Pump 2 Motor Seal . Leak X YA-420B Pump 2 Motor Overtemp X —_— YL-420Pump 2 Run Status X JA-500A RTU 120VAC Power Failure Alarm (Existing)X JA-500B RTU 24VDC Power Failure Alarm X_ JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X LAH-600 Drywell Flooding X ZA-601 Intrusion At Entry Point(s)X TOTAL UO 14 23 2 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR. CONSTRUCTION Page 63 of 6 9 C2-10 4 4+SYSTEMS ENGINEERIN G SCADA System Assessment 17 Prefumo Lift Station TAG DESCRIPTION DISCRETE ANALOG INPUTOUTPUTINPUTOUTPU T LI-200 Level Indication (Existing)X LAH-200 Wetwell High Level Alarm (Existing)X _ LAL-200 Wetwell Low Level Alarm X HS-410 Pump 1 Start/Stop Command (Existing)X SC-410 Pump 1 Speed Setpoint (Existing)X SI-410 Pump 1 Speed Indication (Existing)X YA-410A Pump 1 Motor Seal Leak X _ YA-410BPump 1 Motor Overtemp X YL-410 Pump 1 Run Status X HS-420 Pump 2 Start/Stop Command (Existing)X SC-420 Pump 2 Speed Control (Existing)X SI-420 Pump 2 Speed Indication (Existing)X YA-420APump 2 Motor Seal Leak X YA-420B Pump 2 Motor Overtemp X YL-420Pump 2 Run Status X JA 500A RTU 120VAC Power Failure Alarm (Existing)X JA-500BRTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500RTU High Temp Alarm X LAH-600Drywell Flooding X ZA-601 Intrusion At Entry Point(s)X TOTAL I/O 1423 2 11/4/200 8 SLO SCADA Assessment Report -Final Submittal .doc NOT FOR CONSTRUCTION Page 64 of,69 C2-10 5 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessment 19 Silver City Lift Statio n TAG DESCRIPTION DISCRETE ANALOG .INPUT OUTPUT INPUT OUTPU T LI-200 Level Indication (Existing)X LAH-200 Wetwell High Level Alarm (Existing)X LAL-200 Wetwell Low Level Alarm X HS-410 Pump 1 Start/Sto Command (Existing)X SC-410 Pump 1 Speed Set oint (Existing)X SI-410 Pump 1 Speed Indication (Existing)X YA-410APump 1 Motor Seal Leak X YA-410BPump 1 Motor Overtemp X YL-410 Pump 1 Run Status X HS-420 Pump 2 Start/Stop Command (Existing)X SC-420Pump 2 Speed Control Existing)X SI-420 Pump 2 Speed Indication Existing)X YA-420A Pump 2 Motor Seal Leak X YA-420BPump 2 Motor Overtemp X YL-420 Pump 2 Run Status X JA-500ARTU 120VAC Power Failure Alarm (Existing)X JA-500B RTU 24VDC Power Failure Alarm X JA-500C RTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X LAH-600 Drywell Floodin X ZA-601 Intrusion At Ent Point(s) TOTAL I/O 14 2 32 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .doe NOT FOR CONSTRUCTION Page 66 of 69 C2-10 6 DLT&V SYSTEMS ENGINEERIN G SCADA System Assessment 20 Tank Farm Lift Station TAG DESCRIPTION DISCRETE ANALOG INPUT OUTPUT INPUT OUTPU T LI-200 Level Indication (Existing)X LAH-200 Wetwell High Level Alarm (Existing)X _ LAL-200 Wetwell Low Level Alarm X HS-410 Pump 1 Start/Stop Command (Existing)X SC-410 Pump 1 Speed Setpoint (Existing)X SI-410 Pump 1 Speed Indication (Existing)X YA-410A Pump 1 Motor Seal Leak X YA-410BPump 1 Motor Overtemp X YL-410 Pump I Run Status X HS-420 Pump 2 Start/Stop Command (Existing)X SC-420 Pump 2 Speed Control (Existing)._X SI-420 Pump 2 Speed Indication (Existing)X YA-420A Pump 2 Motor Seal Leak X YA-420B Pump 2 Motor Overtemp X YL-420 Pump 2 Run Status X JA 500A RTU 120VAC Power Failure Alarm (Existing)X JA-500BRTU 24VDC Power Failure Alarm X JA 500CRTU UPS Fault Alarm X TAH-500 RTU High Temp Alarm X LAH-600 Drywell Flooding X ZA-601 Intrusion At Entry Points)X TOTAL 110 14232 Page 67 of 6 911/4/200 8 SLO SCADA Assessment Report - Final Submittal .doc NOT FOR CONSTRUCTION DLT&V SYSTEMS ENGINEERIN G SCADA System Assessmen t APPENDIX D Cost Estimate and Breakdow n 11/4/2008 SLO SCADA Assessment Report - Final Submittal .do c NOT FOR CONSTRUCTION Page 68 of 6 9 C2-108 $0.00 $3,500.00 $2,000 .00 $2,000 .00 $3,500.00 $11,000.0 0 SoftwareHardware Labor-Design Labor-Programming Labor Construction Total $96,489 .00 $434,077 .00 $325,000 .00 $211,380 .00 $454,891 .00 $1,521,837 .00 $30,074 .00 $294,416.00 $325,000 .00 $177,067.00 $455,003.00 $1,281,560.0 0 $102,970 .00 $404,479.00 $325,000.00 $196,383.00 $452,000 .00 $1,480,832.0 0 Software Hardware Labor-Design Labor-Programming Labor Construction Tota l Instruments $0 .00 $95,000 .00 $0 .00 $0 .00 $0 .00 $95,000 .00 DLT&V SYSTEMS ENGINEERIN G SCADA SystemAssessmen t Water Treatment Plan t Add Forebay Level Signa l Water Distribution System Software Hardware Labor-Design Labor-Programming Labor Construction ' Tota l A-B/WW InTouch 1 0 SCADAPack/ClearSCAD A Bristol Babcoc k Whale Rock Syste m A-B/WW InTouch 1 0 SCADAPack/CIearSCAD A Bristol Babcoc k Water Reclamation Facilit y Wonderware InTouch 1 0 ClearSCAD A Bristol Babcoc k Waste Water Collection Wonderware InTouch 1 0 CIearSCAD A Bristol Babcoc k Software Hardware Labor-Design Labor: Programming Labor Construction Tota l $66,104 .00 $67,707.00 $71,309 .00 $39,503 .00 $48,075 .00 $292,698 .00 $23,258.00$32,200.00$71,309.00 $27,820.00 $48,075.00 $202,662 .00 $102,970.00$59,579.00 $71,309.00 $39,503.00 $48,075 .00$321,436 .00 Software Hardware Labor-Design Labor-Programming Labor Construction Total $96,489.00 $26,547 .00 $20,452.00 $271,823.00 $19,433 .00 $434,744 .00 $41,150.00 $14,720.00 $20,452.00 $175,852.00 $19,433 .00$271,607 .00 $102,970.00 $26,547 .00 $20,452.00 $271,823 .00 $19,433 .00$441,225 .00 Software Hardware Labor-Design Labor-Programming Labor ConstructionTotal $96,489 .00 $170,176.00 $157,298.00 $108,812.00 $75,831 .00 $608,606 .0 0 $30,073.00 8105,780.00 $157,298.00 $72,327.00 $75,831 .00$441,309 .00 $102,698.00 $150,618.00 $157,298.00 $108,812.00 $75,831 .00$595,257.00 11/4/200 8 SLO SCADA Assessment Report - Final Submittal .do c NOT FOR CONSTRUCTION Page 69 of 69 C2-110 City of San Luis Obisp o Specification No . 9106 2 ATTACHMENT B :Radio Surve y Sterling Communications, 2012 C2-111 Page intentionally lef t blank .