HomeMy WebLinkAboutCORRESPONDENCE - RFP - 9102 SUPERVISORY CONTROL AND DATA ACQUISITION (SCADA) SYSTEM SUPPORT SERVICES (5)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 5
PROJECT TITLE:
ORIGINAL BID/RFP NUMBER & NAME:
MASTER AGREEMENT EFFECTIVE DATE: June 11 2020
Official 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
Replacement of PLC W40
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): $36,080.00
PROJECT DESCRIPTION/SCOPE OF SERVICES: Upgrade PLC W40, which controls the
Backwash Pump Station, 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: 4B8D0022-116A-438D-98D3-6D70A663A956
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: 4B8D0022-116A-438D-98D3-6D70A663A956
11/4/2020
11/4/2020
11/4/2020
October 21, 2020
9102 SCADA System Support Services - Work Order #5:
Replacement of PLC W40
SCOPE OF WORK
As part of Fort Collins Water Utilities (FCWU) ongoing PLC replacement project, this work will upgrade
PLC W40, which controls the Backwash Pump Station, 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.
Tasks
1. PLC W40 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 W40 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 W40 Programming and WTF I&E Assistance
• Convert existing PLC program
o Convert to Modicon M340
o Follow FCWU programming standards
DocuSign Envelope ID: 4B8D0022-116A-438D-98D3-6D70A663A956
o Revise as needed per updated control description and tag list
• Review PLC program with project team at two stages:
o Review logic for equipment controls
o Review logic for integrated program
o 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. Project Management
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
DocuSign Envelope ID: 4B8D0022-116A-438D-98D3-6D70A663A956
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: 4B8D0022-116A-438D-98D3-6D70A663A956
WTF PLC W40 Replacement
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
Mar-21
9102 SCADA System Services Work Order #5: WTF PLC W40 Replacement
Backwash Pump Station
Dec-20 Jan-21 Feb-21
DocuSign Envelope ID: 4B8D0022-116A-438D-98D3-6D70A663A956
Price Summary / Totals
Task Pricing Totals 36,080
Bill Rate > 185.00 185.00 180.00 130.00 130.00 Specify Add'l Fees on Setup 0
Technology Use Fee
Proj Area > 36,080
Submitted to: City of Fort Collins (Attn: Josh Monsrud)
Contract Type: T&M
Project Phases / Tasks From Thru Months 232 32 64 - 106 30 0.00% 35,440 - 640 - - 36,080
1 2 3 4 5
1 System Investigation 10 2 4 - 4 - 1,630 - 80 - - 1,710
Review P&IDs - - -
Review Process Control Desc 2 2 - 370 370
Review Equip Submittal data - - -
Field Investigation/Observation 8 4 - 4 1,260 80 1,340
2 System Confirmation & Design Docs 80 10 18 - 22 30 11,940 - 80 - - 12,020
Detailed Control Descriptions 2 2 - 370 370
I/O List 2 - 2 260 260
Bill of Materials 4 2 - 2 630 630
Loop Drawings 44 6 - 8 30 6,050 6,050
HMI/PLC Tag List 6 2 - 4 890 890
Cutover planning 16 4 8 - 4 2,740 80 2,820
Review meetings 6 2 2 - 2 1,000 1,000
Programming & WTF I&E Coord 88 4 26 - 58 - 13,090 - 240 - - 13,330
Equipment Programming 28 4 - 24 3,860 3,860
Interconnections Programming 34 10 - 24 4,970 4,970
Acceptance Testing 18 2 8 - 8 2,890 160 3,050
Control Panel QC & Equipment Checkout 2 2 - 370 80 450
Review meetings 6 2 2 - 2 1,000 1,000
5 Cutover & Commissioning 26 2 8 - 16 - 3,930 - 240 - - 4,170
Install & commission PLC 26 2 8 - 16 3,930 240 4,170
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 4 - - - 4 - 520 - - - - 520
As-needed 4 - 4 520 520
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 232 32 64 - 106 30 0.00% 35,440 - 640 - - 36,080
5 Resource
Fort Collins - WTF PLCW40
Price Proposal Labor Plan
PLCW40 (Backwash Pump Station) Replacement 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: 4B8D0022-116A-438D-98D3-6D70A663A956