HomeMy WebLinkAbout21- Amendment 1 - PSA Advanced Engineering Services - Water System Optimization Management ToolEngineer’s P#: P05097-2019-004 Page 1 of 2
Amendment No. 1 to Professional Services Agreement
for: Water Supply Optimization and Management Tool – Phase 1
THIS AGREEMENT is made as of this ________ day of ____________________, 20 ,
between THE CITY OF BOZEMAN, a Municipal Corporation, Bozeman, Montana, herein referred
to as CITY and Advanced Engineering and Environmental Services, LLC an Engineering Consulting
Firm of Bozeman, Montana, herein referred to as Consultant.
WHEREAS, the parties have entered into a Professional Services Agreement dated December
8, 2020, herein referred to as Original Agreement for professional engineering services; and
WHEREAS, the parties desire to further amend the provisions of this Agreement.
NOW, THEREFORE, IN CONSIDERATION OF THE MUTUAL COVENANTS
CONTAINED HEREIN, the parties agree as follows:
Amend Section 1. Purpose: of the Original Agreement to add a new paragraph to read: City and
Consultant agree to incorporate and Consultant agrees to perform additional Scope of Services attached
hereto as “Attachment A – Water Supply Optimization and Management Tool – Phase 2”.
Amend Section 4. Payment for Scope of Services: of the Original Agreement to add a new
paragraph to read: City agrees to pay Consultant for the completion of the additional Scope of Services
attached hereto as “Attachment A – Water Supply Optimization and Management Tool – Phase 2” a
lump sum amount of $11,633.00. The Consultant’s billing rates in $/hr for its employees and lump sum
costs for each task are included with this Attachment A as Table 1 and Table 2 respectively.
Amend Section 5. Reimbursable Expenses: of the Original Agreement to add a new paragraph to
read: For completion of the additional Scope of Services attached hereto as “Attachment A – Water
Supply Optimization and Management Tool – Phase 2”, reimbursable expenses shall be paid to the
Consultant by the City in the actual amount of the costs incurred up to an amount not to exceed
$58,275.00 which includes $58,275.00 for Sub-consultants hired by the Consultant and $0.00 for all
other reimbursable expenses.
Except as specifically amended herein, the Original Agreement shall remain in full force and effect and
the Parties shall be bound by all terms and conditions therein.
IN WITNESS WHEREOF, the parties hereto do make and execute this Agreement on the day
and year first above written.
CITY OF BOZEMAN
___________________________________
Jeff Mihelich
City Manager
ATTEST:
________________________________________
Mike Maas
City Clerk
DocuSign Envelope ID: 39B02B44-11F3-4A63-9436-EFD963AB8A6E
2114thSeptember
Engineer’s P#: P05097-2019-004 Page 2 of 2
APPROVED AS TO FORM
____________________________________
Greg Sullivan
City Attorney
CONSULTANT
By:_______________________________________
Its:______________________________________
ATTEST:
By:___________________________________
Operations Manager
DocuSign Envelope ID: 39B02B44-11F3-4A63-9436-EFD963AB8A6E
Attachment A of Amendment No. 1 to Professional Services Agreement for:
Water Supply Optimization and Management Tool – Phase I.
Page 1 of 2
ATTACHMENT A – Water Supply Optimization and Management Tool – Phase 2
SCOPE OF SERVICES
Task 1: Phase 1 Tool Add-On:
Task 1a: Hyalite Dam Groundwater Data Analysis
· Review and characterize piezometer and vibrating wire data provided by MT DNRC.
· Evaluate possible relationship of groundwater data to the reservoir mass balance unknown.
· Revise Hyalite reservoir operating tool to reflect additional data.
Task 1b: Reliable Yield Model Updates
· Incorporate water right “abandonment” scenario. Functionality will be added to the reliable
yield tools to simulate the elimination of non-City direct diversion rights.
Task 2: Climate Change Analysis
· Development of two alternative physical hydrologic availability timeseries for the City’s
water sources (Sourdough, Hyalite (direct flow and reservoir), and Lyman). This will use
a ratio-based approach similar in detail as presented in the technical memorandum
“Climate Change Adjustment to Firm Yield and Demand for Bozeman, MT” (CH2M,
2013) but revised to be consistent with most recent climate models (CMIP5).
· Modification of the recently developed reliable yield models will include user selectable
scenarios (e.g. historical, climate change scenario 1, climate change scenario 2).
· Documentation of the climate change scenarios and adjustment methodology.
Task 3: Supply and Demand Tool Integration
· Combine spreadsheet tools into single Excel file and program relationships between each.
Draft relationship programming will be presented to City for review prior to finalizing.
Scope includes draft programming, one revision-cycle per City review, and final version.
· Create a custom dashboard within Excel to provide a user-interface
o Draft dashboard will be presented to City for review prior to finalization.
o Scope includes draft dashboard, one revision-cycle per City review, and resulting
final version.
o Dashboard will provide functionality to evaluate water supply and demand gap
under various growth, climate change, infrastructure, and legal rights scenarios.
o Up to three pre-set scenarios will be developed in collaboration with the City and
pre-programmed into the dashboard.
· Develop user manual for tool and dashboard to enable Owner updating when future data
become available.
DocuSign Envelope ID: 39B02B44-11F3-4A63-9436-EFD963AB8A6E
Attachment A of Amendment No. 1 to Professional Services Agreement for:
Water Supply Optimization and Management Tool – Phase I.
Page 2 of 2
Table 1: Hourly Billing Rates for Personnel Utilized on Amendment No. 1
Personnel, Classification Hourly Labor Rate
Scott Buecker, Engineer VI $223.00
Zach Magdol, Engineer III $168.00
Drew Stock, Engineer I $119.00
Table 2: Task Fee Breakdown
Task Consultants Fee Reimbursable Expenses
Task 1 – Phase 1 Tool Add-On $2,070 $4,200
Task 2 – Climate Change Analysis $1,288 $22,575
Task 3 – Tool Integration $8,275 $31,500
Total $11,633 $58,275
TOTAL FEE $69,908
DocuSign Envelope ID: 39B02B44-11F3-4A63-9436-EFD963AB8A6E