HomeMy WebLinkAbout150670 STANTEC CONSULTING SERVICES INC - CONTRACT - SOLE SOURCE - STANTEC CONSULTING SERVICES INC (3)Page 1 of 3
AMENDMENT #01
FIRST AMENDMENT TO THE PROFESSIONAL SERVICES AGREEMENT FOR THE WATER
MODELING SYSTEM UPGRADE
This First Amendment to the Professional Service Agreement between the CITY OF FORT
COLLINS and STANTEC CONSULTING SERVICES INC., is entered into by and between
Stantec Consulting Services Inc., (the “Professional”) and the City of Fort Collins, Colorado
(the “City”).
WHEREAS, the Professional and the City have mutually entered into a Professional Services
Agreement to upgrade the City’s raw water modeling system with a commencement date of
March 29, 2017(the “Agreement”); and
WHEREAS, Professional and the City desire to amend the Agreement to continue to work
together.
NOW, THEREFORE, in consideration of the foregoing recitals and the mutual promises herein
contained, the parties agree as follows:
1. Contract Period. In accordance with the terms of the Agreement, the parties agree to
extend the Agreement for an additional three (3) month period ending November 30,
2017.
2. Exhibit A, Statement of Work and Timeline. The work to be performed by the
Professional shall be amended as follows:
A. The following tasks were either not accounted for in the original budgeting, or
required considerably more effort than anticipated.
1. Reservoir operation logic debug to match simulation of accruals in version
a. Development of a custom build of MODSIM to test results
2. Streamlining of SSD calculations, e.g., monthly factor return flow construct
3. Run-time calculation of the return flow obligations was not budgeted in the SSD
implementation
4. Implementation of the database and DMS compatible with Cloud-base DB
services
5. DMS implementation able to simulate in parallel in multiple computers
6. Enhanced GUI with graphics and full compatibility to store user preferences in
the database to run and post-processing
7. Complexity of some of the GUI variables (e.g., WSSC and PVLC), with of
ramifications and dependencies with other variables that require significant
preprocessing and runtime adjustments to be setup in MODSIM
Financial Services
Purchasing Division
215 N. Mason St. 2nd Floor
PO Box 580
Fort Collins, CO 80522
970.221.6775
970.221.6707- fax
fcgov.com/purchasing
DocuSign Envelope ID: 0FC19AFA-77D1-4B87-93A8-DD154A3CA86B
Page 2 of 3
8. Automate the use of Excel for pre-processing complex variables and leverage
current interaction with the PBN model
B. Activities in the current scope that are still to be performed include:
1. Perform tests on the FCU version 8 model to use the standard MODSIM build
instead of the custom build, simulating the reservoirs without the limitation of a
single source (i.e., storage right)
2. Complete processing of the GUI variables into the MODSIM model, i.e.,
implement WSSD and PVLC interdependencies with runtime variables, including
integrated logic to simulate the use of exchange potential
3. Develop a basic user documentation of the new features of the modeling system
4. Implement the interface to export Fort Collins model results and import them into
the PBN model
5. Write code to complete optimization module and update database
6. Test/debug optimization
C. Time & Budget
1. Professional has estimated the time and budget required to complete these
remaining tasks at 96 hours and $13,224.
2. In addition, the City has requested a supplementary task to the original contract
of a detailed demonstration and training workshop of the upgraded model and
associated tools. This supplementary task is estimated at 46 hours and $6,490.
IN WITNESS WHEREOF, the parties have executed this First Amendment the day and year
shown.
CITY OF FORT COLLINS:
By:
Gerry Paul
Purchasing Director
DATE:
STANTEC CONSULTING SERVICES INC.
By:
Printed:
Title:
CORPORATE PRESIDENT OR VICE PRESIDENT
Date:
DocuSign Envelope ID: 0FC19AFA-77D1-4B87-93A8-DD154A3CA86B
Chip Paulson
9/14/2017
Vice President
9/14/2017
Page 3 of 3
EXHIBIT A
Budget
Timeline
Task Fardal Triana Mauzy Stewart Admin Mileage Cost
$ 170.00 $ 163.00 $ 100.00 $ 120.00 $ 100.00
Complete DMS Development and Integration
(Tasks 1-3)
48 $ 7,824
Complete Model Conversion (Tasks 4-6) 4 24 16 4 40 $ 5,440
Final Model Presentation Workshop (4 hr) 30 16 $ 6,490
Total 4 48 24 16 4 40 $ 19,754
Estimated Hours
Task
Complete DMS Development and Integration (Tasks 1-3)
Complete Model Conversion (Tasks 4-6)
Final Model Presentation Workshop (4 hr)
Sep17 Oct17 Nov17
DocuSign Envelope ID: 0FC19AFA-77D1-4B87-93A8-DD154A3CA86B