HomeMy WebLinkAboutCORRESPONDENCE - RFP - 8553 WATER VULNERABILITY STUDY (6)WORK ORDER
PURSUANT TO A MASTER AGREEMENT BETWEEN
THE CITY OF FORT COLLINS
AND
STANTEC CONSULTING SERVICES, INC.
WORK ORDER NUMBER: 02
PROJECT TITLE: Water Supply Vulnerability Study
ORIGINAL BID/RFP NUMBER & NAME: 8553 Water Supply Vulnerability Study
MASTER AGREEMENT EFFECTIVE DATE: August 15, 2017
ARCHITECT/ENGINEER: Stantec Consulting Services, Inc.
OWNER’S REPRESENTATIVE: Meagan Smith
WORK ORDER COMMENCEMENT DATE: June 4, 2018
WORK ORDER COMPLETION DATE: December 31, 2018
MAXIMUM FEE: (time and reimbursable direct costs): $100,000
PROJECT DESCRIPTION/SCOPE OF SERVICES: Tasks associated with modeling identified
water supply and demand vulnerabilities. See attached scope of work.
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 nine (9) pages are hereby accepted and incorporated herein, by
this reference, and Notice to Proceed is hereby given after all parties have signed this document.
SERVICE PROVIDER: Stantec Consulting Services, Inc.
By: Date:
Name: Chip Paulson Title: Project Manager
DocuSign Envelope ID: EFAD6D4D-3567-4550-8906-F1F034A8EC86
Fort Collins Water Vulnerability Study
2018 Work Order Scope of Work
2
OWNER’S ACCEPTANCE & EXECUTION:
This Work Order and the attached Contract Documents are hereby accepted and incorporated
herein by this reference.
ACCEPTANCE: Date:
Meagan Smith, Project Manager
REVIEWED: Date:
Pat Johnson, Buyer or Senior Buyer
APPROVED AS TO FORM: Date:
Name,City Attorney's Title
(if greater than $1,000,000)
ACCEPTANCE: Date:
Carol Webb, WR&T Operations Manager
ACCEPTANCE: Date:
Kevin Gertig, Utilities Executive Director
(if greater than $1,000,000)
ACCEPTANCE: Date:
Gerry Paul, Purchasing Director
(if greater than $60,000)
ACCEPTANCE: Date:
Darin Atteberry, City Manager
(if greater than $1,000,000)
ATTEST: Date:
City Clerk
(if greater than $1,000,000)
DocuSign Envelope ID: EFAD6D4D-3567-4550-8906-F1F034A8EC86
Fort Collins Water Vulnerability Study
2018 Work Order Scope of Work
3
ATTACHMENT A
WORK ORDER SCOPE OF SERVICES
Introduction
This Scope of Work describes the Consultant work tasks to be performed for the 2018
Task Order for the Fort Collins Water Vulnerability Study. The overall scope is based on
the Consultant scope provided in the project proposal. However, modifications have
been made to the scope and associated budget based on the results of the work
performed under the 2017 Task Order and new information on required analytical
methods.
Note: All draft technical memoranda and report deliverables will be submitted in Word
format to allow for editing; all final written deliverables will be submitted in Word and
PDF format. FCU will collect comments on draft deliverables from FCU and Northern
Water staff and submit a single consolidated set of comments to the Consultant.
Task 1 - Project Management
Objective:
Apply project management strategies/tools to assure Utilities’ objectives for the Water
Vulnerability Study are met.
DELIVERABLES:
• Updated Project Management Plan: updated plan for managing scope,
budget, schedule, deliverables, and roles and responsibilities incorporating
changes based on this Task Order
• Monthly Invoices: project name, personnel/work type category, including the number of
hours and rate for each; task description and 3rd party supporting documentation with the
same detail. Monthly Progress Reports: status of scope (competed and upcoming
work) and budget; issues to be addressed
Task 1.1 – Project Management Plan
The Consultant will update the current Project Management Plan (PMP) with the
technical scope, budget, schedule, deliverables, and roles and responsibilities of Fort
Collins, Northern Water, and the Consultant team for this new Task Order. The
Consultant will track project performance versus cost and schedule on at least a
monthly basis.
DocuSign Envelope ID: EFAD6D4D-3567-4550-8906-F1F034A8EC86
Fort Collins Water Vulnerability Study
2018 Work Order Scope of Work
4
Task 1.2 – Meetings
The Consultant will conduct weekly coordination conference calls with the FCU project
manager to discuss ongoing work, issues to be addressed, and upcoming activities.
The consultant will conduct bi-weekly coordination conference calls with the internal
team to discuss progress, ongoing work, issues and upcoming activities.
Task 1.3 – Monthly Progress Reports and Invoices
The Consultant will update the WSVS_ProjectStatusReport.xlsx spreadsheet on the FCU
Sharepoint site to reflect monthly progress prior to the submittal of the monthly invoice.
The progress reports will briefly document work performed during the past month, work
anticipated in the coming month, and a summary of the budget status.
Task 1.4 – Subcontractor Management
The Consultant will manage its subcontractor using accepted project management
principles. Subcontractors will be responsible for assigning adequate resources to the
project; managing against their scopes, budgets and schedules; and assuring quality of
deliverables and work performed. The Consultant will incorporate subcontractor costs
and progress into its monthly progress reports.
Task 6 – Scenario Analysis
Objective
Conduct the vulnerability modeling analysis to determine future conditions
(combinations of risks and uncertainties) that would result in failure to meet level of
service goals.
Deliverables
• Notes from Workshop #6 – Scenario Identification: summary of discussion of
potential scenarios
• TM #7 – Scenarios for Vulnerability Analysis: summary of recommendations for
preparing scenarios for use in the vulnerability assessment modeling analysis,
including baseline assumptions
The Consultant will integrate the demands developed in Task 3, the risks and impacts
developed in Task 4, and the yield changes due to climate change developed in Task
5 to assess the vulnerability of Utilities’ water supply system and develop future scenarios
based on that assessment.
DocuSign Envelope ID: EFAD6D4D-3567-4550-8906-F1F034A8EC86
Fort Collins Water Vulnerability Study
2018 Work Order Scope of Work
5
Task 6.1 - Vulnerability Baseline Modeling
The Consultant will create the necessary functionality in the Fort Collins water resources
modeling DMS to simultaneously run the FC System Model, the PBN Model, and the CBT
Quota Model for combinations of demands, hydrologies and system risks. Experience
gained during execution of the model development portion of the 2017 Work Order
and parallel tasks to upgrade the Fort Collins modeling system demonstrated that the
model system complexity needed for the Vulnerability Study is greater than originally
anticipated. The additional level of effort required to complete this task is reflected in
the proposed budget. It is assumed for this task that model upgrades to MODSIM
version 8 and additional model improvements identified in the 2017 Work Order will
have been completed.
The first scenario to be analyzed will be a baseline scenario, or a future with status quo.
This will essentially replicate the past firm yield analysis with the improved modeling
system and assumptions for future conditions that represent an “accepted” or “most
likely” forecast. This will allow FCU to compare results with the upgraded modeling
system to the current firm yield estimate for the existing water supply system. Baseline
assumptions will include: system demand assuming current growth projections and
climate; original model hydrology (historical plus synthetic hydrology); current water
rights; current system operations; and reasonably foreseeable projects and operations
by others in the basin. Utilities will have to decide if Halligan Reservoir Enlargement and
other projects currently being considered are included in baseline. The selected
baseline assumptions will be documented in TM#7 – Scenarios for Vulnerability Analysis.
The Consultant will coordinate with FCU modeling staff to verify that the combined
modeling system is generating reasonable results under the baseline scenario. A
meeting will be held to present preliminary results.
Task 6.2 – Identify Scenarios to be Simulated
Scenarios used to assess vulnerability will be based on a combination of model inputs to
reflect potential variability in future demands, climate and hydrology, and other
identified risks as developed in Tasks 3 through 5. To model all combinations of climate,
demands, and risks is unrealistic both from a computational perspective and from an
ability to use results in a meaningful way. Therefore, the Consultant will conduct
Workshop #6 – Scenario Identification with FCU and Northern Water’s staff to select the
future scenarios to model.
In order to help define which risks and vulnerabilities are the most impactful to the
system, the Consultant will begin by applying a range of demands to the baseline
scenario for simulation and testing performance against the level of service metrics.
The range of demands will be based on different demand forecasts for 2030, 2050 and
2070 from the demand model. This will help isolate the influence of demand on system
performance.
DocuSign Envelope ID: EFAD6D4D-3567-4550-8906-F1F034A8EC86
Fort Collins Water Vulnerability Study
2018 Work Order Scope of Work
6
Each of the six test hydrologic sequences will then be run under baseline conditions to
evaluate the effect of hydrology alone on system performance. Simulations will be run
at demands based on the baseline demand forecast at 2030, 2050 and 2070.
Finally, baseline conditions for demand and hydrology will be simulated with all the key
system risks applied individually. These simulations will use demands from the baseline
demand forecast at 2030, 2050 and 2070, and the six test hydrologic sequences.
The Consultant will prepare Tableau visualizations of model output to allow for efficient
review of data and identification of critical vulnerabilities. Results from these runs will
help inform the formation of scenarios and will be completed prior to Workshop #6.
Several strategies for developing vulnerability scenarios will be considered:
1. Test all combinations of key risks varied over a specified range. For example, vary
demand between the 10th and 90th percentiles and combine that with the six
hydrologic ensembles selected in Task 5.
2. Narrative future conditions or storylines (e.g., significantly hotter and drier future,
greater environmental regulations, denser future land use).
3. Systematic combinations, e.g., combine all short-term risks with all long-term risks.
The goal will be to model a variety of different impacts over a range that FCU feels is
reasonable. To help facilitate communication of scenario results to stakeholders, the
total number of scenarios will be limited and will be determined at Workshop #6. The
scenario selection process will be documented in TM#7 – Scenarios for Vulnerability
Analysis.
Task 6.3 – Modeling of Vulnerability Scenarios
The Consultant will apply the DMS to simulate performance of the FCU water supply
system under the selected scenarios. The first step will be to run all scenarios against
the six hydrologic traces selected in Task 5 at demand levels for 2030, 2050 and 2070.
This will be used to identify the scenarios that FCU feels deserve further study, e.g.,
because they significantly stress the system or include combinations of future
conditions that are particularly relevant to FCU water supply planning.
These selected scenarios will then be simulated for all 100 hydrologic traces
developed in Task 5 and for each decade between 2020 and 2070 to provide a more
robust and comprehensive view of potential future performance under a broad
range of possible future conditions.
Regular check-in meetings will be held with FCU staff while this task is being
completed. During these meetings, the Consultant will provide FCU with modeling
results, and FCU staff will be asked to evaluate the results critically and provide
feedback. The coordination process is assumed to involve 3 model output review
meetings and 3 conference calls with the modeling team.
DocuSign Envelope ID: EFAD6D4D-3567-4550-8906-F1F034A8EC86
Fort Collins Water Vulnerability Study
2018 Work Order Scope of Work
7
The outcome of this subtask will be the determination of future conditions to which
the baseline water supply system (i.e., no infrastructure improvements or policy
changes) is vulnerable. The Consultant will determine the specific combinations of
demand, hydrology and system risks that make it impossible to meet FCU’s level of
service goals. The Consultant will develop visualizations (charts and graphs) to
summarize results in a format accessible to decision-makers. The exact form of the
visualization tools will be tailored to the metrics, level of service goals and risks
selected for the Vulnerability Study.
Task 7 – Final Report
Objective
Document study methods and results in a final project report.
Deliverables
• Notes from Workshop #8 – Preliminary Draft Report Review: summary of
comments on preliminary draft report
• Draft Vulnerability Study Report: submit to Fort Collins and Northern Water for
review
• Final Vulnerability Study Report: incorporate review comments and provide all
final technical memoranda in an appendix
Task 7.1 – Report Preparation
The Consultant will prepare a Fort Collins Water Vulnerability Study Report to summarize
the research, methods and results of the study. The report will include the previously
prepared technical memoranda in an appendix. It will provide the documentation
necessary to serve as a foundation for a later integrated water supply plan for Fort
Collins Utilities if desired.
A Preliminary Draft Report will be prepared and presented at a workshop get input on content
and layout from the FCU and Northern Water project teams. A Draft Report will be submitted for
broader circulation and review within those organizations.
A Final Report will be prepared to incorporate all comments. The Consultant will provide the
Final Report in Word format as well as an electronic copy in PDF format.
Approximate Schedule of Workshops
Workshop Task Approximate Date
Workshop #7 – Scenario Identification Task 6 July 24, 2018
Workshop #8 – Preliminary Draft Report Review Task 7 November 15, 2018
DocuSign Envelope ID: EFAD6D4D-3567-4550-8906-F1F034A8EC86
Fort Collins Water Vulnerability Study
2018 Work Order Scope of Work
8
Approximate Schedule of Deliverables
Deliverable Task Approximate Date
TM #7 – Scenarios for Vulnerability Analysis Task 6 August 20, 2018
Draft Vulnerability Study Report Task 7 November 20, 2018
Final Vulnerability Study Report Task 7 December 20, 2018
DocuSign Envelope ID: EFAD6D4D-3567-4550-8906-F1F034A8EC86
Fort Collins Water Vulnerability Study
2018 Work Order Scope of Work
Utilities Work Order Form
Official Purchasing Form
Last updated 10/2017
Schedule
Task A S O N D J F M A M J J A S O N D
Draft Report or Technical Memorandum
Final Report or Technical Memorandum
Formal Meeting or Workshop
5. Develop Potential Yield Changes
6. Scenario Analysis
7. Project Report
2017 2018
1. Project Management
2. Background and Literature Review
3. Future Water Demand Considerations
4. Identify Water Supply and Demand
Vulnerabilities
DevelopTools Apply
DocuSign Envelope ID: EFAD6D4D-3567-4550-8906-F1F034A8EC86
Fort Collins Water Vulnerability Study
2018 Work Order Scope of Work
Utilities Work Order Form
Official Purchasing Form
Last updated 10/2017
ATTACHMENT B
WORK ORDER COST DETAIL
Budget
Stantec RTI
Chip Paulson
Principal Professional
Lisa Fardal
Senior Professional
Neil Stewart
Professional
Samantha Mauzy
Professional
Daniela Machado
Supervising Professional
Patrick VanBuren
Senior Professional
Project Controls
Senior Administrator
Enrique Triana
Senior Env. Scientist 1
Task Total Cost Labor Cost
Direct
Cost
Task 1 – Project Management $20,666 $20,666
24 31 5 5 3 6 16 22
Task 6 – Scenario Analysis $60,179 $59,328 $851 12 33 142 200 30
Task 7 – Final Report $18,344 $16,688 $1,656 16 10 60 15
TOTAL FOR 2018 WORK ORDER $99,190 $96,683 $2,507 52 74 207 205 3 6 16 67
DocuSign Envelope ID: EFAD6D4D-3567-4550-8906-F1F034A8EC86
Fort Collins Water Vulnerability Study
2018 Work Order Scope of Work
Utilities Work Order Form
Official Purchasing Form
Last updated 10/2017
ATTACHMENT C
CERTIFICATE OF INSURANCE
CONTRACTOR shall submit Certificate of Insurance in compliance with the Contract Documents.
DocuSign Envelope ID: EFAD6D4D-3567-4550-8906-F1F034A8EC86