The URL can be used to link to this page

Home My WebLink AboutCORRESPONDENCE - RFP - 9102 SUPERVISORY CONTROL AND DATA ACQUISITION (SCADA) SYSTEM SUPPORT SERVICES (4)Cttyof �s EXHIBIT A WORK ORDER FORM PURSUANT TO A MASTER AGREEMENT BETWEEN THE CITY OF FORT COLLINS AND TETRA TECH, INC. WORK ORDER NUMBER: 11-03-2020 3 PROJECT TITLE: Replacement of PLC ORIGINAL BID/RFP NUMBER & NAME: MASTER AGREEMENT EFFECTIVE DATE: June 11 2020 fficial Purchas,ng Document ,-·1 I"": J Last updated 10ll017 -..=• \-" ARCHITECT/ENGINEER: If using a 3rd party architect/engineer or City PM/Engineer Date: ___ ____ ____ _ SERVICE PRO VIDER: Tetra Tech, Inc. By: Name: ______________ _ Title: Services Agreement - Work Order Type - Utilities 9102 Supervisory Control and Data Acquisition (SCADA) System Support Services W52 & As-Built Drawings/Upgrade Planning for PLC W15 9102 SCADA System Support Services OWNER'S REPRESENTATIVE: Josh Monsrud WORK ORDER COMMENCEMENT DATE: 11-05-2020 WORK ORDER COMPLETION DATE: 06-01-2021 MAXIMUM FEE: (time and reimbursable direct costs): $33,840.00 PROJECT DESCRIPTION/SCOPE OF SERVICES: Upgrade PLC W52, which monitors Foothills Reservoir, to Modicon M340. 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 five (5) pages are hereby accepted and incorporated herein, by this reference, and Notice to Proceed is hereby given after all parties have signed this document. DocuSign Envelope ID: 51230008-CA9D-44F9-81FA-DBCBD15BFA38 Deborah Herman 11/4/2020 Project Manager Cttyof �s Official Purchasing Document ,.-·, r7 1 Last vpdatod 10/2017 ,::, t· OWNER'S ACCEPTANCE & EXECUTION: This Work Order and the attached Contract Documents are hereby accepted and incorporated herein by this reference. ACCEPTANCE: Josh Monsrud, Project Manager REVIEWED: Pat Johnson, Senior Buyer ACCEPTANCE: Mark Kempton, Interim Deputy Director Utilities Services Agreement - Work Order Type - Utilities 9102 Supervisory Control and Data Acquisition (SCADA) System Support Services Date: Date: Date: DocuSign Envelope ID: 51230008-CA9D-44F9-81FA-DBCBD15BFA38 11/4/2020 11/4/2020 11/4/2020 Tetra Tech 1560 Broadway, Suite 1400 | Denver, CO 80202 Tel 303.825.5999 | Fax 303.825.0642 | tetratech.com October 21, 2020 9102 SCADA System Support Services - Work Order #3: Replacement of PLC W52 & As-Built Drawings/Upgrade Planning for PLC W15 SCOPE OF WORK As part of Fort Collins Water Utilities (FCWU) ongoing PLC replacement project, this work will upgrade PLC W52, which monitors Foothills Reservoir, to Modicon M340: The PLC program will be revised to conform to FCWU programming standards and will be developed and tested following the workflow established for the Sidestream Pump Station and Cogeneration projects at Drake Water Reclamation Facility. All installation, testing and commissioning work will take place during WTF’s reduced flow period of January 1 to April 1, 2021. In addition to replacement of PLC W52, this work order will also provide field investigation, as-built drawings, and development of an upgrade plan for PLCW15, the Plant Data Handler PLC. Tasks 1. PLC W52 System Investigation • Kickoff meeting with ICE Team and WTF staff to coordinate work, update schedule, and develop preliminary cutover plan • Review control description • Field Investigation of PLC control panel • Field observation of existing controls of related equipment 2. PLC W52 System Confirmation and Design Documents • Update I/O list • Create Bill of Materials for PLC modules and related components o FCWU to purchase all components under existing price agreements • Update loop diagrams per standards o Water Treatment Facility I&E staff to install components and modify existing control panels as necessary • Update HMI/PLC tag list o List to conform to ICE Team’s standard format o Tags to follow FCU naming standards • Update control descriptions • I/O list, loop diagrams, tag list and control description will all be reviewed by Fort Collins project team • Meet with Project Team to resolve any questions and discrepancies 3. PLC W52 Programming and WTF I&E Assistance DocuSign Envelope ID: 51230008-CA9D-44F9-81FA-DBCBD15BFA38 Tetra Tech 2 • Convert existing PLC program o Convert to Modicon M340 o Follow FCWU programming standards o Revise as needed per updated control description and tag list • Review PLC program with project team. Revise and resubmit as needed. • Prepare detailed test plan, based on control description and tag list • Test the program on ICE Team test station per the test plan • Coordinate with WTF I&E staff on control panel modifications and provide QA/QC review and support as needed • Coordinate with ICE Team for HMI revisions, as needed 4. Cutover and Commissioning • Review the final workplan o Confirm programming is complete o Confirm new PLC hardware is installed and I/O modules are wired o Confirm final cutover plan with operations staff • Prepare detailed functional test plan to test o All I/O o Each piece of equipment o All operating modes o Startup and shutdown sequences o All alarms and interlocks • Install new PLC program • Assist in I/O checkout and functional testing • Assist in system commissioning including verification of start-up sequences, interlocks, and shut down sequences • Turn PLCs over to plant staff 5. Final Documentation, Training & Support • Update control description • Provide as-built loop drawings • Turn final PLC program over to ICE Team • Assist in operator and maintenance training that may be needed • Provide support as needed 6. As-Built Drawings and Upgrade Plan for Data Handler PLC (PLCW15) • Field investigation of PLC W15 • Develop As-Built drawings • Develop and submit upgrade plan • Review with ICE Team and WTF I&C staff and revise as necessary 7. Project Management DocuSign Envelope ID: 51230008-CA9D-44F9-81FA-DBCBD15BFA38 Tetra Tech 3 a. Meeting with ICE Team and WTF I&E staff to establish project goals and schedule. Confirm work order procedures and workflow. b. Develop project work plan and communications plan c. Ongoing coordination with project team d. Biweekly conference calls with the Tetra Tech Project Manager and Technical Lead to track progress of all ongoing and anticipated work orders. The Tetra Tech Project Manager will prepare an agenda and minutes. e. Prepare monthly status report and invoice for the overall project. DocuSign Envelope ID: 51230008-CA9D-44F9-81FA-DBCBD15BFA38 WTF PLCW52 Replacement + PLCW15 As-Builts Project Set up and Coordination Kickoff Meeting Comprehensive Project and Communications Planning Monthly Project Status Reporting System Investigation System Confirmation and Programming Control Descriptions & I/O List Loop Drawings & BOM Programming Testing and Review Installation, Testing and Support Program Installation and Testing Training Assistance and Final Documentation System Support As Needed Data Handler PLC (PLCW15) Field Investigation As-Built Drawings Prepare Upgrade Plan Mar-21 9102 SCADA System Services Work Order #3: WTF PLCW52 Replacement + PLCW15 As-Builts Foothills Reservoir & Plant Data Handler Dec-20 Jan-21 Feb-21 DocuSign Envelope ID: 51230008-CA9D-44F9-81FA-DBCBD15BFA38 Price Summary / Totals Task Pricing Totals 33,840 Bill Rate > 185.00 185.00 180.00 130.00 130.00 Specify Add'l Fees on Setup 0 Technology Use Fee Proj Area > 33,840 Submitted to: City of Fort Collins (Attn: Josh Monsrud) Contract Type: T&M Project Phases / Tasks From Thru Months 204 36 84 - 50 34 0.00% 33,120 - 720 - - 33,840 1 2 3 4 5 1 System Investigation 6 2 4 - - - 1,110 - 80 - - 1,190 Review P&IDs - - - Review Process Control Desc 2 2 - 370 370 Review Equip Submittal data - - - Field Investigation/Observation 4 4 - 740 80 820 2 System Confirmation & Design Docs 66 10 24 - 8 24 10,450 - 80 - - 10,530 Detailed Control Descriptions 2 2 - 370 370 I/O List 2 2 - 370 370 Bill of Materials 4 4 - 740 740 Loop Drawings 32 8 - 24 4,600 4,600 HMI/PLC Tag List 6 2 - 4 890 890 Cutover planning 16 4 8 - 4 2,740 80 2,820 Review meetings 4 2 2 - 740 740 Programming & WTF I&E Coord 50 4 16 - 30 - 7,600 - 240 - - 7,840 Programming 32 8 - 24 4,600 4,600 Acceptance Testing 10 2 4 - 4 1,630 160 1,790 Control Panel QC & Equipment Checkout 2 2 - 370 80 450 Review meetings 6 2 2 - 2 1,000 1,000 PLCW15 As-Built Drawings 38 4 24 - - 10 6,480 - 160 - - 6,640 Field Investigation 8 8 - 1,480 80 1,560 As-Built Drawings 18 8 - 10 2,780 2,780 Review & develop upgrade plan 12 4 8 - 2,220 80 2,300 5 Cutover & Commissioning 18 2 8 - 8 - 2,890 - 160 - - 3,050 Install & commission PLCW52 18 2 8 - 8 2,890 160 3,050 6 Final Documentation, Training, Support 8 2 4 - 2 - 1,370 - - - - 1,370 Final control descriptions 4 2 2 - 740 740 As Built Loop Drawings 2 2 - 370 370 Training 2 - 2 260 260 7 Support 2 - - - 2 - 260 - - - - 260 As-needed 2 - 2 260 260 8 Project Management & Planning 16 12 4 - - - 2,960 - - - - 2,960 Biweekly Project Status Meetings 6 4 2 - 1,110 1,110 Invoicing & Monthly Reports 4 4 - 740 740 Work Order Setup 6 4 2 - 1,110 1,110 Totals 204 36 84 - 50 34 0.00% 33,120 - 720 - - 33,840 5 Resource Fort Collins - WTF PLC W52 + As-Built W15 Price Proposal Labor Plan PLCW52 (Foothills Reservoir) Replacement & As-Built Drawings/Upgrade Plan for PLCW15 (Data Handler) Total Price Pricing by Resource Project Manager (Deb Herman) Technical Lead (Corey Lamb) Task Pricing Schedule Totals Work Days Off Work Days Total Labor Hrs Subs Travel Mat'ls & Equip ODCs Labor Rate Esc. Labor Programming QA/QC (Astrid Fleischer) Programmer II (Phong Hoang) Senior CAD Designer (Kelly Kramer) Tetra Tech - Confidential and Proprietary Page 1 of 1 Printed 10/21/2020 DocuSign Envelope ID: 51230008-CA9D-44F9-81FA-DBCBD15BFA38