HomeMy WebLinkAboutCORRESPONDENCE - RFP - 8553 WATER VULNERABILITY STUDY (5)
1VSDIBTJOHBMSFBEZIBTUIJT$0
NX
Change Order Form (for Work Orders)
Official Purchasing Form
Last updated 10/2017
CHANGE ORDER
NO. 02
PROJECT TITLE: Water Supply Vulnerability Study Work Order 01
CONTRACTOR: Stantec Consulting Services, Inc.
WORK ORDER NUMBER:02
PO NUMBER: 9175434
DESCRIPTION:
1. Reason for Change: Task 2. Fort Collins Utilities requested adjustments to the approach
developed by the consultant. Task 5. The consultant is developing new functionality to process input
timeseries to the PBN model.
2. Description of Change: See attached Scope of Work
3. Change in Work Order Price: $21,097.00
4. Completion Date (if changed): June 30, 2018
ORIGINAL WORK ORDER PRICE $ 250,000.00
TOTAL APPROVED CHANGE ORDER 16,469.00
TOTAL PENDING CHANGE ORDER .00
TOTAL THIS CHANGE ORDER 21,097.00
TOTAL % OF THIS CHANGE ORDER %
TOTAL C.O.% OF ORIGINAL WORK ORDER %
ADJUSTED WORK ORDER COST $ 287,566.00
CONTRACTOR: Stantec Consulting Services, Inc.
By: Date:
Name: Chip Paulson Title: Project Manager
ACCEPTANCE: Date:
Meagan Smith, Project Manager
REVIEWED: Date:
Pat Johnson, Buyer or Senior Buyer
ACCEPTANCE: Date:
Donnie Dustin, Water Resources Manager
ACCEPTANCE: Date:
DocuSign Envelope ID: 5EC484AA-4769-4765-9665-4820143F49E3
Change Order Form (for Work Orders)
Official Purchasing Form
Last updated 10/2017
Gerry Paul, Purchasing Director
(if greater than $60,000)
DocuSign Envelope ID: 5EC484AA-4769-4765-9665-4820143F49E3
Memo
fl g:\fort_collins\vulnerability study\1.0 proposals and contracts\2017 work order\change order_02.docx
To: Meagan Smith From: Lisa Fardal
City of Fort Collins – Utilities Fort Collins CO Office
File: Change Order 02 Date: May 25, 2018
Reference: Fort Collins Utilities Vulnerability Study 2017 Work Order
Introduction
The initial prototype of the Demand Estimation tool developed by RTI International (RTI) is a planning zone-
based model and is composed of several models of indoor and outdoor water use, including separated
models for residential and non-residential users. The Fort Collins Utilities (FCU) requested adjustments to the
approach including reducing the number of models and the using revised explanatory variables for future
prediction. RTI will use the GIS-based Master Table and other tools to process the data and develop the
demand estimation model with the direction provided by FCU.
This Change Order includes additional scope of work and estimated budget to support these two activities.
Changes from Original Scope of Work
Task 2 - FUTURE WATER DEMAND CONSIDERATIONS (Additional Scope)
RTI will process the water use data and explanatory variables selected by FCU for the revised version of the
demand estimation tool. RTI will use the GIS-based Master Table and other tools to process the data and
develop the demand estimation model. RTI will work with FCU through the process of processing the data
and model development to assure the revised version provides the staff confidence to move forward with
generating the demand scenarios for the Water Supply Vulnerability Study. For the revised version of the tool,
RTI will perform the following tasks:
• Gathering and processing model data into the database. This includes the new data suggested and
new groups (models).
• Adjusting the queries to include new info, including county data linked with master table.
• Developing the new models based on FCU direction provided (i.e., multi-regression analysis with new
variables)
• Implementing the new model structure and coefficients in the database/dashboard
• Implementing the demand estimation tool for building scenarios, including revising data feeds, model
knobs and calculations.
• Presenting the preliminary results and beta tool to FCU.
• Performing one iteration of revisions.
• Revised the documentation/user manual (or TM) with the new models, development approach and
application.
DocuSign Envelope ID: 5EC484AA-4769-4765-9665-4820143F49E3
May 25, 2018
Meagan Smith
Page 2 of 3
Reference: Fort Collins Utilities Vulnerability Study 2017 Work Order
fl g:\fort_collins\vulnerability study\1.0 proposals and contracts\2017 work order\change order_02.docx
Task 5 - DEVELOP POTENTIAL YIELD CHANGES (Additional Scope)
RTI will implement new functionality in the PBN import time series to process input time series to the PBN
model based on the simulated flows in the Poudre and Colorado River basins. A ‘like year’ approach will be
implemented to re-sequence the historical values into new model input time series that reflect demands and
inflows for the new simulated conditions.
Budget
Table 1 shows the additional required hours and the budget for the additional tasks. Additional project
management time to process the change order and the subconsultant markup are included in the budget. The
total of the requested change order is $21,097.
Table 1- Budget for the Additional Tasks
Task Description
Labor Hours Totals
Stantec
Supervising
Professional
RTI Senior
Engineer 1
Computer
Prog/
Scientist
Environ.
Engineer 1
Environ.
Engineer 2
Stantec
FRD
Total
Hours
US DOLLARS
w/markup
$170 $155.39 $104.50 $132.01 $107.25 $11/hr
Task 1
Project
Management
2 $22 2 $ 362
Task 2
Revised
Demand
Estimation
Model
60 8 45 113 $ 17,235
Task 5
PBN Model
Inputs
Processing
6 16 22 $ 3,500
TOTALS 2 66 8 16 45 $22 137 $ 21,097
DocuSign Envelope ID: 5EC484AA-4769-4765-9665-4820143F49E3
May 25, 2018
Meagan Smith
Page 3 of 3
Reference: Fort Collins Utilities Vulnerability Study 2017 Work Order
fl g:\fort_collins\vulnerability study\1.0 proposals and contracts\2017 work order\change order_02.docx
Schedule
The proposed tasks in this change order will be complete by June 30, 2018.
Thank you for your consideration. Please reach out to me or Chip Paulson (303-291-2132) with any questions
or concerns.
Lisa Fardal
3325 S. Timberline Rd.
Suite 150
Ft Collins, CO 80525
Phone: (970) 212-2773
DocuSign Envelope ID: 5EC484AA-4769-4765-9665-4820143F49E3