Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
CORRESPONDENCE - RFP - 8115 ENGINEERING SERVICES FOR WATER RECLAMATION & BIOSOLIDS FACILTY DESIGN AND CONSTRUCTION SERVICES
WORK ORDER PURSUANT TO A MASTER AGREEMENT BETWEEN THE CITY OF FORT COLLINS AND CAROLLO ENGINEERS, INC. WORK ORDER NUMBER: UC-SCADA-2019 PROJECT TITLE: USCADA Master Plan ORIGINAL BID/RFP NUMBER & NAME: U8115, Engineering Services for Water Reclamation and Biosolids Facility Design and Construction Services MASTER AGREEMENT EFFECTIVE DATE: USeptember 21, 2015 ARCHITECT/ENGINEER: UCarollo Engineers, Inc. OWNER’S REPRESENTATIVE: UJosh Monsrud WORK ORDER COMMENCEMENT DATE: USeptember 3, 2019 WORK ORDER COMPLETION DATE: UDecember 31, 2020 MAXIMUM FEE: (time and reimbursable direct costs): U$97,461.00 PROJECT DESCRIPTION/SCOPE OF SERVICES: U The City of Fort Collins (City) through the assistance of Carollo Engineers (Consultant and Engineer of Record) is providing a SCADA master plan as a guidance document for the ICE Team. The plan will encompass a utility wide approach for all plants and include asset analysis and staffing and project recommendations. The scope of work is divided into the following tasks and subtasks, summarized below for the Calendar year 2019 (tasks 1-6). A second scope of services is being provided for the calendar 2020 (task 7-13) and may be added on to the Work Order via change order, at the City`s Discretion. Completion of the scope in 2020 will include the deliverable of a comprehensive SCADA Master Plan. The purpose of this Work Order is to provide the engineering guidance for the proposed SCADA Master Plan (Project). See attached supporting documentation. Service Provider agrees to perform the services identified above and on the attached forms in accordance with the terms and conditions contained herein and in the Master Agreement between the parties. In the event of a conflict between or ambiguity in the terms of the Master Agreement and this Work Order (including the attached forms) the Master Agreement shall control. The attached forms consisting of fourteen ( 14) pages are hereby accepted and incorporated herein, U U U U by this reference, and Notice to Proceed is hereby given after all parties have signed this document. Page 1 of 20 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 SERVICE PROVIDER: Carollo Engineers, Inc. By: Date: Name: Title: OWNER’S ACCEPTANCE & EXECUTION: This Work Order and the attached Contract Documents are hereby accepted and incorporated herein by this reference. ACCEPTANCE: Date: Josh Monsrud, SCADA Systems Manager REVIEWED: Date: Pat Johnson, Senior Buyer APPROVED AS TO FORM: Date: Name,City Attorney's Title (if greater than $1,000,000) ACCEPTANCE: Date: Jason Graham, Director, Water Reclamation & Biosolids Division ACCEPTANCE: Date: Mark Kempton, Director, Water Production Division ACCEPTANCE: Date: Theresa Connor, Deputy Director, Water Engineering & Field Services ACCEPTANCE: Date: Carol Webb, Deputy Director, Water Resources & Treatment Operations ACCEPTANCE: Date: Kevin Gertig, Utilities Executive Director (if greater than $1,000,000) ACCEPTANCE: Date: Gerry Paul, Purchasing Director (if greater than $60,000) Page 2 of 20 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 August 15, 2019 Jason Garside Vice President August 15, 2019 August 15, 2019 Ron Burdick August 16, 2019 Vice President August 16, 2019 August 20, 2019 August 20, 2019 August 20, 2019 August 23, 2019 ATTACHMENT A WORK ORDER SCOPE OF SERVICES Page 3 of 20 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 Page 1 of 11 Fort Collins, Colorado Proposed Scope of Work for the SCADA Master Plan Project SCOPE OF SERVICES The City of Fort Collins (City) through the assistance of Carollo Engineers (Consultant and Engineer of Record) is providing a SCADA master plan as a guidance document for the ICE Team. The plan will encompass a utility wide approach for all plants and include asset analysis and staffing and project recommendations. The scope of work is divided into the following tasks and subtasks, summarized below for the Calendar year 2019 (tasks 1-6). A second scope of services is being provided for the calendar 2020 (task 7-13) and may be added on to the Work Order via change order, at the City`s Discretion. Completion of the scope in 2020 will include the deliverable of a comprehensive SCADA Master Plan. The purpose of this Work Order is to provide the engineering guidance for the proposed SCADA Master Plan (Project). TASK 1 – PROJECT MANAGEMENT AND STRATEGIC VISIONING Project management includes preparing a Project Management Plan, Monthly Progress Reports, budget and resource tracking, and progress reports. The CONSULTANT will facilitate a Kickoff Meeting, periodic workshops, work order administration, monthly progress status updates, coordination with the City, bi-weekly status update meetings (conference calls acceptable if approved by the City project manager) and quality control and assurance. Strategic Visioning includes development of the projects guiding mission statement, core principals, governance, and key objectives. The following subtasks will be performed as part of Task 1. Task 1.1 - Project Management, Communication, and Coordination The project manager will make staffing assignments, review work progress, coordinate quality assurance and review procedures, and communicate monthly progress reports to the City. CONSULTANT’s project manager will prepare a Project Management Plan to guide the team in executing the project and will manage the budget, schedule, and invoicing. The project manager will prepare and maintain a decision log that will record the decisions made by the City throughout the project. The decision log will contain decisions made during regular meetings, workshops, and phone conversations with City staff. The decision log will list the date the decision was made, the type of meeting in which it was made, individuals involved in making the decision, and the nature of the decision. DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 Page 2 of 11 Task 1.2 - Project Kickoff Meeting – Define Goals and Objectives The CONSULTANT will facilitate a project Kickoff Meeting with City staff to develop and define the City’s goals and objectives for the SCADA Master Plan. This will be a working meeting with participation from key City staff and stakeholders to discuss the City’s strategic vision for SCADA implementation and understand staff preferences. Additionally, the CONSULTANT will review the overall scope, schedule, and budget for preparation of the SCADA Master Plan and establish lines of communication between the CONSULTANT and City staff. The City shall indicate to the CONSULTANT specific areas of focus to include in the plan at the Kickoff Meeting. Task 1.3 – Project Status Update Meetings CONSULTANT will host bi-weekly project progress meetings to review work completed, work look ahead, project schedule review and update. UTask 1.4 Stakeholder Workshops CONSULTANT will facilitate the interviews and workshops, reviewing the common themes determined by the interviews/surveys and identify each operational group’s objectives for system wide operations Task 1.5 - Quality Control and Assurance The project manager will be responsible for coordinating quality control review of deliverables by senior CONSULTANT staff. UTask 1 Deliverables Meeting minutes. Monthly progress reports. Project Strategic Vision Statement Quality Control and Assurance Plan. TASK 2- UEVALUATION, RESEARCH, AND ASSESSMENTU The CONSULTANT will provide condition assessments for each plant and a few representative remote facilities. The evaluation will include the condition, architecture, and overall health of the system. The CONSULTANT will prepare an electronic survey to determine the capabilities, impressions of the existing SCADA system. The CONSULTANT will conduct several Staff interviews to assess the current systems strengths and faults to determine the pulse of the staff’s opinions and needs. The security evaluation will be performed simultaneously with the other activities The following subtasks will be performed as part of Task 2. DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 Page 3 of 11 UTask 2.1 – Condition Assessments (Plants and Typical remote facilities) CONSULTANT will review the condition of the current SCADA and PCS system hardware and software. UTask 2.2 – Electronic Survey (Capabilities and Impressions of current SCADA system) The CONSULTANT will prepare an electronic survey to determine the capabilities and impressions of the existing SCADA system. The survey results will be used as a basis to drive stakeholder workshops and in person staff interviews. UTask 2.3 – Staff Interviews (current system strengths and faults) The CONSULTANT will conduct several Staff interviews to assess the current systems strengths and faults to determine pulse of the staff’s opinions and needs. UTask 2 Deliverables Plant Condition Assessment Remote Site Condition Assessment Existing Evaluation Technical Memorandum Security Technical Memorandum TASK 3 UINVENTORY OF HARDWARE AND SOFTWARE The CITY’s ICE staff will perform the inventory of the current hardware and software systems for the two plants and associated remote facilities. The CONSULTANT will coordinate the effort and supply the ICE team with a digital application to capture the informationU. The following subtasks will be performed as part of Task 3. UTask 3.1 – Coordinate and provide digital inventory application Option 1 - The CONSULTANT will coordinate the collection of SCADA system inventory data to be completed by the City ICE team. The digital application inventory collection tool provided by the CONSULTANT will allow the ICE team to collect and store all of the inventory data electronically. Option 2- The CONSULTANT will collect the SCADA system inventory. The ICE team will provide a staff member to escort the Consultant to each item identified in inventory for recording and evaluation. The consultant will utilize a software tool to collect the information and generate the reports. DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 Page 4 of 11 UTask 3 Deliverables Inventory List. Location drawing for each of the treatment plants TASK 4 – EVALUATION OF PCS EQUIPMENT The CONSULTANT will Review hardware and software components of the existing Process Control System. Evaluation of the existing radios/RTUs. Provide a brief evaluation of the hardware and software. The information gained will develop priorities for hardware and software upgrade and replacement projects. The following subtasks will be performed as part of Task 4. UTask 4.1 – Existing PCS System Hardware and Software Review The CONSULTANT will analyze the PCS systems in the plants and remote facilities based on life cycle, distribution architecture, redundancy and communications. UTask 4 Deliverables Memo: Evaluation of PLCs and their programming software. Evaluate the current distribution of PLCs vs RIO. Provide recommendations for processor redundancy. Evaluation of Phoenix Radios. Vendor control Panels. Provide text for spec language for VCPs. Evaluation of the big four HMIs Platforms. TASK 5 – UCYBER SECURITY DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 Page 5 of 11 The CONSULTANT will facilitate discussion on the potential cyber security issues based on previous evaluations, architecture, equipment, activities and frequency. The CONSULTANT will also make cyber security improvement recommendations based on industry standards. The following subtasks will be performed as part of Task 5. UTask 5.1 – Discuss previous cyber security evaluations The CONSULTANT will review previous cyber security audits done for the city and meet with the city staff to ascertain what potential issues have been resolved, are currently being worked on and any outstanding issues to be addressed UTask 5.2 – Recommend architecture Discuss previous cyber security evaluations The CONSULTANT will focus on plans and policies for cyber security, incident detection and response, resiliency and disaster recovery. Based on information obtained the CONSULTANT will develop next steps for updating architectures, closing gaps, and implementation strategies following industry best practices such as the NIST Cybersecurity Framework and IEC- 62443/ISA-99 standards and DHS Best management practices.. UTask 5 Deliverables MEMO: Summarizing existing security plans and their level of implementation NIST 800-82 regulations Recommended Practices TASK 6 – UORGANIZATIONAL ASSESSMENT This task will focus on evaluating the ICE Team’s organization structure and responsibilities to operate and maintain the SCADA system. A workshop will be conducted with the SCADA staff to determine current responsibilities, training and needs. The workshop will also discuss elements the staff may wish to control or shed. The following subtasks will be performed as part of Task 6. UTask 6.1 – Organizational Assessment The CONSULTATN’s evaluation will summarize the organizational structure of the ICE team and their responsibilities. ` UTask 6.2 – Staff Workshop (Responsibilities, training and needs) DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 Page 6 of 11 The CONSULTANT will review with staff the current responsibilities to operate and maintain the SCADA and PCS systems. UTask 6 Deliverables Memo: Discuss current roles and responsibilities One SCADA systems admin Manager (manager, PLC programmer) One SR administrator (database admin, systems admin) Admin I (programming, graphic design, CAD) Apps Software One Analyst II (data Analyst) Recommendation on staffing vs other utilities Memo: Database status and connectivity Data access & retrieval Database – Management and reporting (External use) Web services and report generation Need the ability to easily publish dashboards Memo: Describe current staffing vs local peer groups Memo: Discuss sharing IT resources to cover network needs and bridge a gap between teams Meeting: Review findings and report TASK 7 – UASSET MANAGEMENT EVALUATIONS The CONSULTANT will provide a memo discussing recommended time frames of replacements for PCS hardware. The following subtasks will be performed as part of Task 7. MEMO: DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 Page 7 of 11 PCS Asset Replacement Technical Memorandum TASK 8 –NETWORK ARCHITECTURE The CONSULTANT will perform field investigations and gather documentation on the existing network architecture, protocols and communication that will support expansion of Ethernet peer communications and Ethernet connected devices. Discuss best layouts for containment and design requirements to support potential cyber requirements. The following subtasks will be performed as part of Task 8. UTask 8.1 – Current network evaluation CONSULTANT will review existing SCADA and PCS networks to determine the current system capabilities and future enhancements required for the expansion of peer to peer communications and Ethernet connected devices. UTask 8.2 – Explore architectures to support future cyber security requirements CONSULTANT will facilitate discussion about advanced network design and future cyber security planning. These discussions may include existing segmentation, routing, and connectivity. ACLs and switch configurations, where available, to determine existing network security schemes and accessibility. Network components will be reviewed with staff to determine any re-occurring failures, maintenance concerns, and accessibility issues. UTask 8 Deliverables MEMO: Summarizing existing network architecture, peer to peer communications and possible networked equipment. FIGURES: Proposed layered architecture Proposed SCADA Block Diagram DRAKE Proposed SCADA Block Diagram Mulberry Proposed SCADA Block Diagram WTP DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 Page 8 of 11 TASK 9 – TEST ENVIRONEMENT The CONSULTANT will evaluate the need and advantages of having a testing environment and the criticality of doing so with likely change of incorporation of more vendors and programmers in the future The following subtasks will be performed as part of Task 9. UTask 9.1 – Evaluate programming test environment The CONSULTANT will analyze the need and benefits of a programming test station for the city. UTask 9 Deliverables MEMO: Summarizing the importance of a test environment, simulation and 3P rd P party testing TASK 10– UCAD ENGINEERING FOR ELECTRICAL DRAWINGS The ICE team currently doesn’t have the required staff to generate and maintain all the documentation that is currently required to support the process control system. The CONSULTANT will review alternative deliveries to develop a strategy that would cover the creation of the required documents. Develop a memo to discuss various ways to accomplish this task. The following subtasks will be performed as part of Task 10. UTask 10.1 – Review Alternative drawing generation strategies The CONSULTANT will discuss with the staff alternative delivery methods that would meet their electrical drawing support and record maintenance needs. UTask 10 Deliverables Memo: Spec requirements for contractor/engineer to provide Vendor provided Drawings Engineer generated Outsourcing • Interns • Temps DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 Page 9 of 11 • CAD service Task 11 – UPROCESS CONTROL SYSTEM STANDARDSU The following subtasks will be performed as part of Task 11. UTask 11.1 – Provide Process Control Systems Standards The CONSULTANT will provide typical process control system standards and related figures. The ICE team will provide names and descriptions of the base code blocks screen shots of desired HMI standards UTask 11 Deliverables Memo: Hardware standards PLC code blocks HMI standards Tagging Instrument selection Philosophy of control PLC code blocks HMI standards Figures: Controls Panel Layouts Task 12 – USCADA PROJECTS AND GAP ANALYSIS The CONSULTANT will use the information gathered from previous tasks to develop a list of projects recommended for incorporation into the SCADA system over the next 15-20 years and identify the SCADA needs for those projects. These recommendations will include capacity needs to meet future system growth and recommendations to improve system performance. The list will include all known projects and any identified in the gap analysis. Rough costs will be provided for each of the projects. Once the CITY defines the final list of projects detailed costs will be provided The following subtasks will be performed as part of Task 12. DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 Page 10 of 11 UTask 12.1 – Recommend Project List The CONSULTANT will develop a draft list of projects recommended for implementation into the SCADA/PCS system over the next 15-20 years with rough costs. The city will review this list with the CONSULTATN to determine project priorities. A final list will be generated for including in the memo. UTask 12.2 – Cost Estimate’s The CONSULTNAT will provide cost estimates for the final project list. UTask 12 Deliverable Memo: List of projects identified through the various memos and workshops. Develop a rough cost estimate for all projects Recommendation of prioritization of the projects. CONSULTANT will develop a final detailed cost estimate for the final selected projects. UTask 13 – FINALIZED SCADA MASTER PLAN The following subtasks will be performed as part of Task 13. UTask 13.1 – Provide Finalized SCADA Master Plan The CONSULTANT will combine all previous deliverable and compile into a single document and an electronic PDF version with hyperlinks. UTask 13 Deliverable Memo: Compiled hardcopy of the SCADA Master Plan Electronic version of the SCADA Master Plan CITY RESPONSIBILITIES Because of the nature of this project, certain assumptions apply to this Scope of Services. To the extent possible, these assumptions are stated within this document and are reflected in the budget. If the project task requirements are different from the assumptions presented in this DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 Page 11 of 11 Scope of Services, or if the City desires additional services, the resultant change in scope will serve as a basis for amending this project assignment or initiating the development of a new project assignment as agreed to by both the City and CONSULTANT. The following assumptions and City responsibilities apply to this project: 1. The City will provide the existing SCADA systems documentation listed in task 2. 2. CONSULTANT shall be entitled to rely upon the accuracy of the data and information supplied by the City without independent review or evaluation. 3. The City will provide all required information within the period established in the schedule contained in this Scope of Services. The schedule is based on timely receipt of data from the City. 4. The City shall attend all meetings to maintain the progress of the project according to the schedule. 5. The City will make staff operations and maintenance staff available in a timely fashion for site visits. 6. The City shall review draft deliverables and provide comments within a 2-week period. DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 ATTACHMENT B WORK ORDER SCOPE COST DETAILS Page 15 of 20 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 CITY OF FORT COLLINS, COLORADO FORT COLLINS SCADA MASTER PLAN - 2019 Labor Hours & Cost August 6, 2019 5% Task No. Sub Task Work Performed in Calendar Year Professional Hours Senior Professional Lead Project Professional Project Professional Professional Assistant Professional Technician Document Processing/Clerical Labor Cost Travel, Subsistence, And Other Reimbursable Costs PECE Total Reimbursable Costs Total Labor Cost & Reimbursable Costs 1 2019 PROJECT MANAGEMENT QA/QC AMD KICKOFF MEETING $ 17,215 1.1 PM Staffing assignments, review work progress, and monthly progress reports 2019 18 12 4 2 $ 3,872 $ - $ 211 $ 211 $ 4,083 1.2 Kick off meeting/Strategic Visioning 22 8 8 4 2 $ 4,428 $ - $ 257 $ 257 $ 4,685 1.3 Project Status Update Meetings 5 5 $ 1,190 $ - $ 59 $ 59 $ 1,249 1.4 StakeholderWorkshops 24 8 8 4 4 $ 4,620 $ - $ 281 $ 281 $ 4,901 1.5 QA/QC 8 8 $ 1,904 $ 300 $ 94 $ 394 $ 2,298 2 EVALUATION, RESEARCH, AND ASSESSMENT $ 27,546 2.1 Condition Assessments (Plants and Typical Remote Facilities) 2019 48 24 24 $ 9,048 $ - $ 562 $ 562 $ 9,610 2.2 Electronic survey - (capabilities and impressions of current SCADA system) 12 4 8 $ 2,600 $ - $ 140 $ 140 $ 2,740 2.3 Staff Interviews - (current system strengths and faults) 16 16 $ 3,296 $ 300 $ 187 $ 487 $ 3,783 QA/QC 8 8 $ 1,904 $ - $ 94 $ 94 $ 1,998 Deliverables 44 8 24 8 4 $ 8,600 $ 300 $ 515 $ 815 $ 9,415 3 INVENTORY OF HARDWARE AND SOFTWARE $ 10,411 3.1 Coordinate and provide digital inventory application 2019 4 4 $ 824 $ - $ 47 $ 47 $ 871 Deliverables (Carollo to provide completed inventory application) - Option 2 40 16 20 4 $ 8,572 $ 500 $ 468 $ 968 $ 9,540 4 EVALUATION OF PCS EQUIPIMENT $ 12,837 4.1 Existing Hardware and Software review 2019 34 2 16 16 $ 6,508 $ - $ 398 $ 398 $ 6,906 QA/QC 6 6 $ 1,428 $ 300 $ 70 $ 370 $ 1,798 Deliverables 22 2 8 8 4 $ 3,876 $ - $ 257 $ 257 $ 4,133 5 CYBER SECURITY $ 8,273 5.1 Discuss potential issues based on previous evaluations 2019 6 4 2 $ 1,364 $ - $ 70 $ 70 $ 1,434 5.2 Recommend, architecture, discussion of equipment, activities and frequency. 6 2 4 $ 1,300 $ 300 $ 70 $ 370 $ 1,670 QA/QC 8 8 $ 1,904 $ - $ 94 $ 94 $ 1,998 Deliverables 16 4 8 4 $ 2,984 $ - $ 187 $ 187 $ 3,171 6 ORGANIZATIONAL ASSESSMENT $ 14,106 6.1 Organizational Assessment 2019 24 20 4 $ 5,584 $ - $ 281 $ 281 $ 5,865 6.2 Staff Workshop (responsibilities, training and needs) 17 8 8 1 $ 3,648 $ 300 $ 199 $ 499 $ 4,147 QA/QC 8 4 4 $ 1,828 $ - $ 94 $ 94 $ 1,922 Deliverables 12 8 4 $ 2,032 $ - $ 140 $ 140 $ 2,172 Totals Row 408 137 24 154 64 0 0 29 $ 83,314 $ 2,300 $ 4,774 $ 7,074 $ 97,461.20 Current Rate Sheet as of: 2019 $ 0.575 < Mileage Reimbursement Rate 10% < Mark Percentage E/S VIII E/S VII E/S V & VII E/S III & IV E/S I & II CAD Administrativ e/CAD Doc Processor 238.00 219.00 206.00 171.00 147.00 110.00 162.00 96.00 <-- without PECE 296.00 270.00 250.00 212.00 168.00 122.00 110.00 96.00 <-- with PECE @ 11.7 /hr 296.00 270.00 250.00 212.00 168.00 122.00 110.00 96.00 <-- Applied Rate Page 17 of 20 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 ATTACHMENT C WORK ORDER SCHEDULE DETAIL Page 18 of 20 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 City of Fort Collins - Carbon Addition Project Carollo Design Activities and Schedule last revised: 11/6/2018 FTC SCADA Master Plan W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 Task 1 - Project Coordination 2019 Kickoff Meeting Bi-Weekly Coordination Meetings Task 2 - Evaluation, Research and Assessment Condition Assessments (Plants and Typical Remote Facilities) Electronic survey - (capabilities and impressions of current SCADA system) Staff Interviews - (current system strengths and faults) Task 3 - Inventory of Hardware and Software Coordinate and provide digital inventory application Task 4 - Evaluation of PCS Equipment Existing Hardware and Software review Task 5 - Cyber Security Discuss potential issues based on previous evaluations Recommend, architecture, discussion of equipment, activities and frequency. Task 6 - Organizational Assessment Organizational Assessment Staff Workshop (responsibilities, training and needs) FTC SCADA Master Plan W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4 Task 1A - Project Coordination 2020 Bi-Weekly Coordination Meetings Task 7 - Asset Management Evaluations Memo on recommend replacement schedules for PCS hardware Task 8 - Network Architecture Evaluate current network architecture, protocols and communication Discuss best layouts for containment and design requirements to support potential cyber requirements. Workshop Task 9 - Test Environment Evaluate the need and advantages of having a testing environment Task 10 - CAD Engineering for Electrical Drawings Review alternative strategies to generate and maintain electrical drawings Task 11 - Process Control System Standards Provide control system standards Task 12 - SCADA Projects and Gap Analysis Recommended project list Cost estimates Task 13 - Finalized Scada Master Plan Compiled SMP Report January February March April May June July August September October November December January February March April May June July August September October November December October October November November December December July July August August September September March April May May June June January February ATTACHMENT D CERTIFICATE OF INSURANCE CONTRACTOR shall submit Certificate of Insurance in compliance with the Contract Documents. Page 20 of 20 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 Subject: Date: No. of Pages: Phone: Sender: URL: MAIL Certificate of Insurance DOCUMENT Delivery by ecertsonline™ THIS MESSAGE IS INTENDED FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. IF THE READER OF THE MESSAGE IS NOT THE INTENDED RECIPIENT, OR THE EMPLOYEE OR AGENT RESPONSIBLE FOR DELIVERING THE MESSAGE TO THE INTENDED RECIPIENT, YOU ARE HEREBY NOTIFIED THAT ANY DISSEMINATION, DISTRIBUTION OR COPYING OF THIS COMMUNICATION IS STRICTLY PROHIBITED. IF YOU HAVE RECEIVED THIS COMMUNICATION IN ERROR, PLEASE NOTIFY US IMEDIATELY BY TELEPHONE, AND RETURN THE ORIGINAL MESSAGE TO US AT THE ABOVE ADDRESS VIA REGULAR POSTAL SERVICE. Certificate of Insurance Delivered by ecertsonline™ Insurance Visions, Inc. All rights reserved. Risk Strategies Company 2040 Main Street, Suite 450 Irvine, CA 92614 949-242-9240 www.risk-strategies.com 12/19/2018 Attached is your renewal certificate of insurance. If you have any questions, please email Sherry Young at syoung@risk-strategies.com. City of Fort Collins P.O. Box 580 Fort Collins CO 80522 Sherry Young 10 Cert No. 46014063 - Carollo Engineers, Inc. - Renewal Certificate of Insurance DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE THE EXPIRATION DATE THEREOF, NOTICE WILL BE DELIVERED IN ACCORDANCE WITH THE POLICY PROVISIONS. INSURER(S) AFFORDING COVERAGE INSURER F : INSURER E : INSURER D : INSURER C : INSURER B : INSURER A : NAIC # NAME: CONTACT (A/C, No): FAX E-MAIL ADDRESS: PRODUCER (A/C, No, Ext): PHONE INSURED COVERAGES CERTIFICATE NUMBER:REVISION NUMBER: IMPORTANT: If the certificate holder is an ADDITIONAL INSURED, the policy(ies) must have ADDITIONAL INSURED provisions or be endorsed. If SUBROGATION IS WAIVED, subject to the terms and conditions of the policy, certain policies may require an endorsement. A statement on this certificate does not confer rights to the certificate holder in lieu of such endorsement(s). THIS CERTIFICATE IS ISSUED AS A MATTER OF INFORMATION ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE HOLDER. THIS CERTIFICATE DOES NOT AFFIRMATIVELY OR NEGATIVELY AMEND, EXTEND OR ALTER THE COVERAGE AFFORDED BY THE POLICIES BELOW. THIS CERTIFICATE OF INSURANCE DOES NOT CONSTITUTE A CONTRACT BETWEEN THE ISSUING INSURER(S), AUTHORIZED REPRESENTATIVE OR PRODUCER, AND THE CERTIFICATE HOLDER. OTHER: (Per accident) (Ea accident) $ $ N / A SUBR WVD ADDL INSD THIS IS TO CERTIFY THAT THE POLICIES OF INSURANCE LISTED BELOW HAVE BEEN ISSUED TO THE INSURED NAMED ABOVE FOR THE POLICY PERIOD INDICATED. NOTWITHSTANDING ANY REQUIREMENT, TERM OR CONDITION OF ANY CONTRACT OR OTHER DOCUMENT WITH RESPECT TO WHICH THIS CERTIFICATE MAY BE ISSUED OR MAY PERTAIN, THE INSURANCE AFFORDED BY THE POLICIES DESCRIBED HEREIN IS SUBJECT TO ALL THE TERMS, EXCLUSIONS AND CONDITIONS OF SUCH POLICIES. LIMITS SHOWN MAY HAVE BEEN REDUCED BY PAID CLAIMS. $ $ $ PROPERTY DAMAGE $ BODILY INJURY (Per accident) BODILY INJURY (Per person) COMBINED SINGLE LIMIT AUTOS ONLY AUTOS ONLY AUTOS NON-OWNED OWNED SCHEDULED ANY AUTO AUTOMOBILE LIABILITY Y / N WORKERS COMPENSATION AND EMPLOYERS' LIABILITY OFFICER/MEMBER EXCLUDED? Blanket Additional Insured - Owners, Lessees or Contractors - with Products-Completed Operations Coverage Endorsement CNA75079XX (1-15) Policy No: Page 1 of 2 Endorsement No: Effective Date: Insured Name: Copyright CNA All Rights Reserved. Includes copyrighted material of Insurance Services Office, Inc., with its permission. This endorsement modifies insurance provided under the following: COMMERCIAL GENERAL LIABILITY COVERAGE PART It is understood and agreed as follows: I. The WHO IS AN INSURED section is amended to add as an Insured any person or organization whom the Named Insured is required by written contract to add as an additional insured on this coverage part, including any such person or organization, if any, specifically set forth on the Schedule attachment to this endorsement. However, such person or organization is an Insured only with respect to such person or organization’s liability for: A. unless paragraph B. below applies, 1. bodily injury, property damage, or personal and advertising injury caused in whole or in part by the acts or omissions by or on behalf of the Named Insured and in the performance of such Named Insured’s ongoing operations as specified in such written contract; or 2. bodily injury or property damage caused in whole or in part by your work and included in the products-completed operations hazard, and only if a. the written contract requires the Named Insured to provide the additional insured such coverage; and b. this coverage part provides such coverage. B. bodily injury, property damage, or personal and advertising injury arising out of your work described in such written contract, but only if: 1. this coverage part provides coverage for bodily injury or property damage included within the products completed operations hazard; and 2. the written contract specifically requires the Named Insured to provide additional insured coverage under the 11-85 or 10-01 edition of CG2010 or the 10-01 edition of CG2037. II. Subject always to the terms and conditions of this policy, including the limits of insurance, the Insurer will not provide such additional insured with: A. coverage broader than required by the written contract; or B. a higher limit of insurance than required by the written contract. III. The insurance granted by this endorsement to the additional insured does not apply to bodily injury, property damage, or personal and advertising injury arising out of: A. the rendering of, or the failure to render, any professional architectural, engineering, or surveying services, including: 1. the preparing, approving, or failing to prepare or approve maps, shop drawings, opinions, reports, surveys, field orders, change orders or drawings and specifications; and 2. supervisory, inspection, architectural or engineering activities; or B. any premises or work for which the additional insured is specifically listed as an additional insured on another endorsement attached to this coverage part. IV. Notwithstanding anything to the contrary in the section entitled COMMERCIAL GENERAL LIABILITY CONDITIONS, the Condition entitled Other Insurance, this insurance is excess of all other insurance available to the additional insured whether on a primary, excess, contingent or any other basis. However, if this insurance Carollo Engineers, Inc. 6050490317 12/31/2018 46014063 | *18-19 GL-AL-UL-WC-PL ($1M/$1M) | Sherry Young | 12/19/2018 11:55:10 AM (PST) | Page 2 of 9 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 Blanket Additional Insured - Owners, Lessees or Contractors - with Products-Completed Operations Coverage Endorsement CNA75079XX (1-15) Policy No: Page 2 of 2 Endorsement No: Effective Date: Insured Name: Copyright CNA All Rights Reserved. Includes copyrighted material of Insurance Services Office, Inc., with its permission. is required by written contract to be primary and non-contributory, this insurance will be primary and non- contributory relative solely to insurance on which the additional insured is a named insured. V. Solely with respect to the insurance granted by this endorsement, the section entitled COMMERCIAL GENERAL LIABILITY CONDITIONS is amended as follows: The Condition entitled Duties In The Event of Occurrence, Offense, Claim or Suit is amended with the addition of the following: Any additional insured pursuant to this endorsement will as soon as practicable: 1. give the Insurer written notice of any claim, or any occurrence or offense which may result in a claim; 2. except as provided in Paragraph IV. of this endorsement, agree to make available any other insurance the additional insured has for any loss covered under this coverage part; 3. send the Insurer copies of all legal papers received, and otherwise cooperate with the Insurer in the investigation, defense, or settlement of the claim; and 4. tender the defense and indemnity of any claim to any other insurer or self insurer whose policy or program applies to a loss that the Insurer covers under this coverage part. However, if the written contract requires this insurance to be primary and non-contributory, this paragraph (4) does not apply to insurance on which the additional insured is a named insured. The Insurer has no duty to defend or indemnify an additional insured under this endorsement until the Insurer receives written notice of a claim from the additional insured. VI. Solely with respect to the insurance granted by this endorsement, the section entitled DEFINITIONS is amended to add the following definition: Written contract means a written contract or written agreement that requires the Named Insured to make a person or organization an additional insured on this coverage part, provided the contract or agreement: A. is currently in effect or becomes effective during the term of this policy; and B. was executed prior to: 1. the bodily injury or property damage; or 2. the offense that caused the personal and advertising injury for which the additional insured seeks coverage. Any coverage granted by this endorsement shall apply solely to the extent permissible by law. All other terms and conditions of the Policy remain unchanged. This endorsement, which forms a part of and is for attachment to the Policy issued by the designated Insurers, takes effect on the effective date of said Policy at the hour stated in said Policy, unless another effective date is shown below, and expires concurrently with said Policy. Carollo Engineers, Inc. 6050490317 12/31/2018 46014063 | *18-19 GL-AL-UL-WC-PL ($1M/$1M) | Sherry Young | 12/19/2018 11:55:10 AM (PST) | Page 3 of 9 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 Waiver of Transfer of Rights of Recovery Against Others to the Insurer Endorsement This endorsement modifies insurance provided under the following: COMMERICAL GENERAL LIABILITY COVERAGE PART PRODUCTS/COMPLETED OPERATIONS LIABILITY COVERAGE PART SCHEDULE Name of Person Or Organization Blanket where required by written contract. (Information required to complete this Schedule, if not shown above, will be shown in the Declarations.) Under COMMERCIAL GENERAL LIABILITY CONDITIONS, it is understood and agreed that the condition entitled Transfer Of Rights Of Recovery Against Others To Us is amended by the addition of the following: With respect to the person or organization shown in the Schedule above, the Insurer waives any right of recovery the Insurer may have against such person or organization because of payments the Insurer makes for injury or damage arising out of the Named Insured’s ongoing operations or your work included in the products-completed operations hazard. All other terms and conditions of the Policy remain unchanged. This endorsement, which forms a part of and is for attachment to the Policy issued by the designated Insurers, takes effect on the effective date of said Policy at the hour stated in said Policy, unless another effective date is shown below, and expires concurrently with said Policy. CNA75008XX (10-16) Policy No: Endorsement No: Effective Date: Insured Name: Copyright CNA All Rights Reserved. Includes copyrighted material of Insurance Services Office, Inc., with its permission. 12/19/2018 Carollo Engineers, Inc. 6050490317 46014063 | *18-19 GL-AL-UL-WC-PL ($1M/$1M) | Sherry Young | 12/19/2018 11:55:10 AM (PST) | Page 4 of 9 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 CNA68021XX (2-13) Policy No: Page 1 Endorsement No: Effective Date: Insured Name: © CNA All Rights Reserved. NOTICE OF CANCELLATION TO CERTIFICATEHOLDERS It is understood and agreed that: If you have agreed under written contract to provide notice of cancellation to a party to whom the Agent of Record has issued a Certificate of Insurance, and if we cancel a policy term described on that Certificate of Insurance for any reason other than nonpayment of premium, then notice of cancellation will be provided to such Certificateholders at least 30 days in advance of the date cancellation is effective. If notice is mailed, then proof of mailing to the last known mailing address of the Certificateholder on file with the Agent of Record will be sufficient to prove notice. Any failure by us to notify such persons or organizations will not extend or invalidate such cancellation, or impose any liability or obligation upon us or the Agent of Record. Carollo Engineers, Inc. 6050490317 12/31/2018 City of Fort Collins P.O. Box 580 Fort Collins CO 80522 46014063 | *18-19 GL-AL-UL-WC-PL ($1M/$1M) | Sherry Young | 12/19/2018 11:55:10 AM (PST) | Page 5 of 9 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 Named Insured: Policy Number: Effective Date: ADDITIONAL INSURED – PRIMARY AND NON-CONTRIBUTORY It is understood and agreed that this endorsement amends the BUSINESS AUTO COVERAGE FORM as follows: SCHEDULE Name of Additional Insured Persons Or Organizations ANY PERSON OR ORGANIZATION ON WHOSE BEHALF YOU ARE REQUIRED UNDER A WRITTEN CONTRACT OR AGREEMENT. 1. In conformance with paragraph A.1.c. of Who Is An Insured of Section II – LIABILITY COVERAGE, the person or organization scheduled above is an insured under this policy. 2. The insurance afforded to the additional insured under this policy will apply on a primary and non- contributory basis if you have committed it to be so in a written contract or written agreement executed prior to the date of the "accident" for which the additional insured seeks coverage under this policy. All other terms and conditions of the Policy remain unchanged. CNA 71527XX (Ed. 10/12) Carollo Engineers, Inc. 6050490267 12/31/2018 46014063 | *18-19 GL-AL-UL-WC-PL ($1M/$1M) | Sherry Young | 12/19/2018 11:55:10 AM (PST) | Page 6 of 9 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 CNA68021XX (2-13) Policy No: Page 1 Endorsement No: Effective Date: Insured Name: © CNA All Rights Reserved. NOTICE OF CANCELLATION TO CERTIFICATEHOLDERS It is understood and agreed that: If you have agreed under written contract to provide notice of cancellation to a party to whom the Agent of Record has issued a Certificate of Insurance, and if we cancel a policy term described on that Certificate of Insurance for any reason other than nonpayment of premium, then notice of cancellation will be provided to such Certificateholders at least 30 days in advance of the date cancellation is effective. If notice is mailed, then proof of mailing to the last known mailing address of the Certificateholder on file with the Agent of Record will be sufficient to prove notice. Any failure by us to notify such persons or organizations will not extend or invalidate such cancellation, or impose any liability or obligation upon us or the Agent of Record. Carollo Engineers, Inc. City of Fort Collins P.O. Box 580 Fort Collins CO 80522 6050490267 12/31/2018 46014063 | *18-19 GL-AL-UL-WC-PL ($1M/$1M) | Sherry Young | 12/19/2018 11:55:10 AM (PST) | Page 7 of 9 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 Carollo Engineers, Inc. 6050490270 12/31/2018 12/31/2018 6050490298 American Casualty Company of Reading, PA Valley Forge Insurance Company 46014063 | *18-19 GL-AL-UL-WC-PL ($1M/$1M) | Sherry Young | 12/19/2018 11:55:10 AM (PST) | Page 8 of 9 Workers Compensation DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 PROFESSIONAL LIABILITY AND POLLUTION For All the Commitments you Make INCIDENT LIABILITY INSURANCE POLICY INSURED: Policy Effective Endorsement Number NOTICE ENDORSEMENT – CANCELLATION OR NON-RENEWAL We agree with you that your Policy is amended to include the following additional provisions. 1. Your Policy will not be: XX Cancelled by us until we provide at least: 10 days prior written notice if we cancel your Policy for Non-payment of Premium; 30 days prior written notice if we cancel your Policy for The following reasons: Any reason other than non-payment of premium. ___ Non-renewed by us until at least ___ days prior written notice is given to the person or entity named in 2. below. 2. Person or Entity: All other terms and conditions of the Policy remain unchanged. This endorsement, which forms a part of and is for attachment to the Policy issued by the designated Insurers, takes effect on the effective date of said Policy at the hour stated in said Policy and expires concurrently with said Policy unless another effective date is shown above. By Authorized Representative __James F. Willging_____________________ (No signature is required if issued with the Policy or if it is effective on the Policy Effective Date) James F. Willging Countersigned by Authorized Representative 256423 (Ed. 10/05) Carollo Engineers, Inc. AEH288354410 7/4/2018 City of Fort Collins P.O. Box 580 Fort Collins CO 80522 46014063 | *18-19 GL-AL-UL-WC-PL ($1M/$1M) | Sherry Young | 12/19/2018 11:55:10 AM (PST) | Page 9 of 9 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 (Mandatory in NH) DESCRIPTION OF OPERATIONS below If yes, describe under ANY PROPRIETOR/PARTNER/EXECUTIVE $ $ $ E.L. DISEASE - POLICY LIMIT E.L. DISEASE - EA EMPLOYEE E.L. EACH ACCIDENT ER OTH- STATUTE PER (MM/DD/YYYY) LIMITS POLICY EXP (MM/DD/YYYY) POLICY EFF LTR TYPE OF INSURANCE POLICY NUMBER INSR DESCRIPTION OF OPERATIONS / LOCATIONS / VEHICLES (ACORD 101, Additional Remarks Schedule, may be attached if more space is required) EXCESS LIAB UMBRELLA LIAB EACH OCCURRENCE $ AGGREGATE $ $ OCCUR CLAIMS-MADE DED RETENTION $ PRODUCTS - COMP/OP AGG $ GENERAL AGGREGATE $ PERSONAL & ADV INJURY $ MED EXP (Any one person) $ EACH OCCURRENCE $ DAMAGE TO RENTED PREMISES (Ea occurrence) $ COMMERCIAL GENERAL LIABILITY CLAIMS-MADE OCCUR GEN'L AGGREGATE LIMIT APPLIES PER: POLICY PRO- JECT LOC CERTIFICATE OF LIABILITY INSURANCE DATE (MM/DD/YYYY) CANCELLATION AUTHORIZED REPRESENTATIVE ACORD 25 (2016/03) © 1988-2015 ACORD CORPORATION. All rights reserved. CERTIFICATE HOLDER The ACORD name and logo are registered marks of ACORD HIRED AUTOS ONLY 12/19/2018 Risk Strategies Company 2040 Main Street, Suite 450 Irvine, CA 92614 949-242-9240 www.risk-strategies.com CA DOI License No. 0F06675 Michael Christian Risk Strategies Company syoung@risk-strategies.com Carollo Engineers, Inc. 2700 Ygnacio Valley Road, #300 Walnut Creek CA 94598 46014063 ✓ ✓ Construction Services. Carollo Project #: 10103A.00. City of Fort Collins, its officers, agents and employees are included as additional insured as City of Fort Collins P.O. Box 580 Fort Collins CO 80522 Projects as on file with the insured including but not limited to: 8115 Engineering Services for Water Reclamation and Biosolids Facility Design & additional insureds with respects to General & Auto Liability. $1,000,000 $1,000,000 $25,000 $1,000,000 $2,000,000 $2,000,000 $1,000,000 Ded: Comp/Collision $1,000 $1,000,000 $1,000,000 $1,000,000 Each Claim: $1,000,000 Aggregate: $1,000,000 Deductible: $400,000 A ✓ 6050490317 12/31/2018 12/31/2019 ✓ ✓ Deductible $0 ✓ E 6050490267 12/31/2018 12/31/2019 ✓ ✓ ✓ B 6050490270 12/31/2018 12/31/2019 ✓ ✓ C 6050490298 12/31/2018 12/31/2019 N Deductible: $0 D Professional Liability AEH288354410 7/4/2018 7/4/2019 Unlimited Prior Acts Continental Insurance Company 35289 American Casualty Company of Reading, PA 20427 Valley Forge Insurance Company 20508 Continental Casualty Company 20443 National Fire Insurance Co of Hartford 20478 46014063 | *18-19 GL-AL-UL-WC-PL ($1M/$1M) | Sherry Young | 12/19/2018 11:55:10 AM (PST) | Page 1 of 9 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 January February March April Carollo Engineers, Inc. FTC SMP Design Schedule_Carollo Activities_07-24-2019.xlsx 8/6/2019 Page 19 of 20 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446 2019 238.00 219.00 206.00 171.00 147.00 110.00 96.00 TOTAL CONTRACT AMOUNT $ 97,461 REIMBURSABLE COSTS Carollo Engineers Confidential 8/6/2019 Page 1 Page 16 of 20 DocuSign Envelope ID: AF0E04DC-1CE8-4560-8620-A25891664446