HomeMy Public PortalAboutTO 2023-01 Water Utility System Hydraulic - Barge DesignsTask Order No. 2023-1
Water Utility System Hydraulic Modeling
City of Crestview, Florida
January 9, 2023
This Task Order, effective the date last signed below, by and between City of Crestview, Florida
(City) and Barge Design Solutions, Inc. (Barge) for the Water Utility System Hydraulic
Modeling (Project) is in accordance with the terms and conditions of the Professional Engineering
Continuing Services Contract dated May 11, 2021, as renewed/extended August 12, 2022, and
as amended January 9, 2023 (Agreement), all of which terms and conditions are incorporated
herein by reference.
The Project is described in Exhibit A — Scope of Services, attached.
For performance of the Project authorized under this Task Order, Client agrees to pay Barge for
time worked on the project by various personnel plus applicable outside services and other
expenses properly charged to the project in accordance with Exhibit B — Schedule of Standard
Charges. The estimated cost to complete to perform the scope of work as defined in Exhibit A
is estimated to be $128,500. The budget status will be summarized monthly in our progress report
and invoice submittal.
City of Crestview, Florida
By: 916(x/i.
Printed Name: ` � J ? W `� 1-c,k;
�
Title:
Address:
Date Signed:
ayor
let AZ ki/,` lsdn
/24;
Page 1 of 1
City of Crestview, Florida
Task Order 2023-1
Water Utility System Hydraulic Modeling
Barge Design Solutions, Inc.
By:
Printed Kevin W. Kennoy
Name:
Title: Vice President
Address:
495 Grand Boulevard, Suite 206
Miramar Beach, FL 32550
Date Signed:
GA RGo
Exhibit A, Scope of Work
Water Utility System Hydraulic Modeling
City of Crestview, FL
January 9, 2023
Barge Design Solutions, Inc. (Barge) is proposing the following scope of services for the City of
Crestview, Florida (Client) to provide hydraulic modeling and planning services for the Water Utility
System Hydraulic Modeling Project, in accordance with Task Order No. 2023-1. The scope of work
is presented in the following elements:
I. Project Description
II. Scope of Services
III. Project Schedule
I. Project Description
The City of Crestview Water Division manages and operates a water distribution system that
consists of two pressure zones and over 150 miles of water distribution mains ranging from
1-inch to 12-inches in diameter. Customers are provided water from multiple well and
elevated water storage tanks located throughout the system.
This project will provide the Client with an updated and calibrated hydraulic model that can
be used to evaluate the existing system and help the Client in planning for the future. The
updated, calibrated hydraulic model will assist the Client in:
1. Identifying water pressure and fire flow issues within the system.
2. Identifying pipe, supply capacity, and flow issues within the system.
3. Evaluating impact to existing system from new developments.
4. Determining optimal locations for future storage tanks and well sites.
5. Identifying future capital improvement projects.
Discussions with the Client and the review of the Client's existing WaterGEMS model (albeit
severely aged) have been the source of information for determining the tasks and required
level of effort for this task order. The budget status will be summarized monthly in our
progress report and invoice submittal.
II. Scope of Services
The scope of services is summarized into the following major tasks:
Task 1 — Water Data Collection and Review
Task 2 — Model Update
Task 3 — Model Calibration
Task 4 — Review/Establish Levels of Service
Task 5 — Existing System and Near -Term Evaluation for Southwestern Area
January 9, 2023
Water Utility System Hydraulic Modeling, City of Crestview, FL Page of
�4RGc
Exhibit A, Scope of Work
Water Utility System Hydraulic Modeling
City of Crestview, FL
January 9, 2023
The following sections provide a description of the purpose, activities, deliverables, and
assumptions anticipated for each of the tasks. Throughout the project, Barge will manage the
activities of our staff and subconsultants, coordinate monthly status meetings with the Client's
staff, and submit monthly invoices with updated schedules and cost projections as applicable.
Task 1 — Data Collection and Review
To begin the process of updating the water model, it is important to gain an understanding of
network layout and operational preferences and strategies.
• Barge will review received data including:
o GIS files
o Record drawings
o Water production records
o Billing records
After reviewing infrastructure and operational data, gaps impacting the development and
calibration of the model will be assessed. If additional data is required, it will be prioritized for
collection based on the data's significance to the accuracy and usefulness of the model.
Barge has included up to two days of site visits to collect this information.
Barge will facilitate one in -person meeting with operations staff to discuss operational
strategies, known or potential system performance issues, and generally gather data that will
aid in updating the model. If additional meetings are necessary, Barge will coordinate up to
two additional Microsoft Teams meetings with operations staff. Discussion topics will include:
• Typical operational parameters and operating techniques
• Pump selection and operational scenarios
• Key valve settings
• Typical hydraulic grade lines at supply locations
Meetings:
The following meetings will be conducted as part of this task:
• Kickoff -Meeting, including Data Collection Review and Model Development
• Up to two Microsoft Team Meetings will be held, as needed, during the data collection
task
Deliverables:
The following deliverables will be provided as part of this task:
January 9, 2023
Water Utility System Hydraulic Modeling, City of Crestview, FL Page of
BARGE
Exhibit A, Scope of Work
Water Utility System Hydraulic Modeling
City of Crestview, FL
January 9, 2023
• Data collection list, including missing data, potential impacts, and approach to
address the missing data
• Schematic of the existing distribution system to review the benefits and challenges of
the existing system operations with operations staff
Assumptions:
The following assumptions are applicable to the above scope of services:
• No more than two days of field reconnaissance/surveying of system components will
be required. If additional field efforts are required, Barge will prepare additional scope
and fee to collect the missing information. The additional field data collection will only
be performed with the approval of the Client.
Task 2 — Water Model Development
Barge will update the Client's water distribution system hydraulic model using information
collected and reviewed in Task 1. The existing model will be updated using Bentley
WaterGEMS software. Barge will use GIS data and discussions with the Client's staff to
confirm service area boundaries, piping connectivity, and pipe diameters. Well pump
drawings, pump curves, tank site drawings and field reconnaissance conducted in Task 1 will
be used to configure the piping layouts at the well sites and tank sites as well as develop the
pumped flow and head capacities and the geometry of the tanks.
Barge will input operating parameters obtained through discussions with the Client in Task 1
into the model to define the system's connectivity and operational controls.
Water Demands need to be accurately placed in the model to allow the model to mirror the
reactions of the distribution system. Barge has developed several methods of analyzing
billing record data commonly kept by utilities and disaggregating the demand throughout the
model network. Barge will review 24-36 months of water billing records, which will be
requested as part of Task 1. The billing records will be geographically linked using a location
reference included in the billing records, such as a Location ID, Meter ID, or service address.
Barge will use GIS methods that are custom designed for the project to assign the demands
to the nodes in the distribution model (by linking billing records to GIS spatial information and
geocoding, as necessary). Large water users will be identified and input manually into the
distribution system model.
Distribution systems contain some quantity of water pumped into the system that is not billed,
commonly referred to as non -revenue water (NRW). NRW can include either legally or
illegally obtained water such as firefighting, unmetered connections, metering errors, leaks,
line breaks, and flushing. Barge will use billing and well production records to estimate current
levels of NRW. Additionally, available blow -off and/or auto -flusher information, such as
locations, frequencies, quantities, and durations, will be included in the NRW estimations.
January 9, 2023
Water Utility System Hydraulic Modeling, City of Crestview, FL Page 3 of 7
ARG=
Exhibit A, Scope of Work
Water Utility System Hydraulic Modeling
City of Crestview, FL
January 9, 2023
Barge will allocate the NRW demand throughout the model network using an algorithm based
on pipe length and pipe diameter.
Meetings:
The following meetings will be conducted as part of this task:
• Up to two Microsoft Team Meetings will be held, as needed, during the model
development task
Assumptions:
The following assumptions are applicable to the above scope of services:
• 24-36 months of electronic customer water consumption billing data is available.
Task 3 — Water Model Calibration
Barge will use a one-time model calibration approach to achieve a representation of the
actual system conditions. Barge will deploy pressure recorders at all tank and well locations
to collect system conditions such as tank levels, system pressures, and valve and pumping
operations, to analyze the bulk movement of water throughout the system over a three-day
period. Barge will deploy one ultrasonic flow meter at a well pump location to confirm well
pump flows and will relocate this flow meter to each well site throughout the testing period.
Barge will also perform hydrant flow testing in various areas of the system, and particularly
in the southwest area, to gain localized system conditions such as elevations, pipe
roughness, and valve settings. Pitot pressure will be recorded at the flow hydrant and
converted to a flow rate using industry accepted conversion equations. Static and residual
pressures will be recorded at hydrants located upstream and downstream of the flow hydrant.
This data will be input into the model and compared to the model results. Barge anticipates
three days of monitoring/flow testing for this task.
Barge will use information collected from pressure and flow monitors to develop diurnal
patterns specific to each pressure zone, to simulate the timing of the demand during the day.
If billing records for large users include hourly consumption, custom diurnal patterns will be
developed for these users.
Additional calibration is recommended as a second phase to this project, however, the current
schedule precludes additional calibration in this scope.
Meetings:
The following meetings will be conducted as part of this task:
• Up to two Microsoft Team Meetings will be held, as needed, during the model
calibration task
January 9, 2023
Water Utility System Hydraulic Modeling, City of Crestview, FL
Page of
ROc-
Exhibit A, Scope of Work
Water Utility System Hydraulic Modeling
City of Crestview, FL
January 9, 2023
Deliverables:
The following deliverables will be provided as part of this task:
• Calibration Testing Plan
Assumptions:
The following assumptions are applicable to the above scope of services:
• SCADA is not available.
• Up to 3 days of field work for flow testing is included
Task 4 — Review/Establish Levels of Service
This task will establish levels of service (LOS) criteria to be used in the subsequent hydraulic
modeling evaluations. These criteria will be used to evaluate the southwestern area of the
distribution system to determine system deficiencies and required improvements for the area
under existing system conditions as well as with known upcoming development demands.
Barge will:
• Meet with staff to establish and refine LOS criteria (to take place during the kickoff
meeting)
• Draft summary of LOS criteria for review. the LOS criteria will be categorized based
on transmission piping, storage, operation (such as preference for tank turnover), fire
protection, and customer service.
Meetings:
The following meetings will be conducted as part of this task:
• LOS Criteria Discussion (part of kickoff meeting in Task 1)
Deliverables:
The following deliverables will be provided as part of this task:
• Levels of Service Criteria
Task 5 — Existing System and Near -Term Evaluation for Southwestern Area
The purpose of this task is to evaluate the southwestern portion of the water distribution
system under existing and future, near -term demand conditions and develop recommended
system improvements.
For this task, Barge will provide the following services:
• Develop 12 model simulations, including:
January 9, 2023
Water Utility System Hydraulic Modeling, City of Crestview, FL Page of
BARC-74,-
Exhibit A, Scope of Work
Water Utility System Hydraulic Modeling
City of Crestview, FL
January 9, 2023
O 72-hour extended period existing average day demand scenarios, before and
after recommended improvements
O 72-hour extended period existing peak day demand scenarios, before and
after recommended improvements
o Static fire flow demand scenarios (under existing peak day, average demand
conditions), before and after improvements
O 72-hour extended period near -term, future average day demand scenarios,
before and after recommended improvements
O 72-hour extended period near -term, future peak day demand scenarios,
before and after recommended improvements
o Static fire flow demand scenarios (under near -term, future peak day, average
demand conditions), before and after improvements
• Analyze the southwestern area of system under existing and near -term, future
demand conditions utilizing the model scenarios and define system deficiencies
based on the approved LOS criteria
• Analyze fire flow availability in the southwestern area of the system during the
average hour of the peak day demand scenarios (existing and near -term, future)
• Analyze the impact of abandonment or replacement of the downtown `Fire' tank with
regards to existing tank levels, as it is suspected that existing tank levels are kept low
due to the `Fire' tank. Potential system improvements will be discussed with the Client
in the system deficiency summary meeting.
• Summarize system deficiencies in the southwestern area of the system and prepare
a list of potential improvements to be evaluated for discussion with the Client in a
meeting; amend or revise based on Client's input
• Develop proposed improvements or operational modifications (up to two scenarios
per deficiency) in the southwestern area of the system to meet the LOS criteria
(assuming most deficiencies will be addressed with one improvement scenario)
• Develop a Technical Memorandum to document the model development, calibration
and evaluation process
• Present findings of system analyses in System Evaluation Workshop
Meetings:
The following meetings will be conducted as part of this task:
• System Evaluation Workshop
January 9, 2023
Water Utility System Hydraulic Modeling, City of Crestview, FL Page of
Exhibit A, Scope of Work
Water Utility System Hydraulic Modeling
City of Crestview, FL
January 9, 2023
• Up to two additional Microsoft Team Meetings will be held, as needed, during system
evaluation
Deliverables:
The following deliverables will be provided as part of this task:
• Technical Memorandum
Assumptions:
The following assumptions are applicable to the above scope of services:
• Fire flow will be evaluated only on model junctions that represent fire hydrants.
III. Project Schedule
The preliminary project schedule for the described activities is shown in the table below.
Approximate durations are shown in calendar days after Notice to Proceed, from the previous
sequential task. All dates are based on timely receipt of field and Client supplied data and
may be adjusted after data is received.
daNIW"
Tasks
Duration
(Calendar Days)
Water Distribution Modeling 90 days total
Task 1 - Data Collection and Review 20
Task 2 - Model Update 20
Task 3 - Model Calibration 30
Task 4 - Review Level of Service 20 (concurrent
with Task 1)
Task 5 - Existing System and Near -Term Evaluation for
Southwestern Area
January 9, 2023
Water Utility System Hydraulic Modeling, City of Crestview, FL
20
Page 7 of 7
8AR(51
Exhibit B, Schedule of Standard Charges
Professional Consulting Services
City of Crestview
August 12, 2022
HOURLY -RATE BASIS
The following hourly rates shall apply for personnel of Barge and its wholly owned subsidiaries for time
properly chargeable to the work:
Principal Engineer, Senior Technical Specialist, Practice Leader $200 to $260
Project Manager $150 to $220
Professional Engineer/Architect $110 to $200
Senior Designer $120 to $150
Professional Land Surveyor $110 to $195
Engineer -In -Training $90 to $130
Designer or CADD Technician $75 to $115
Project Administrator, Administrative Assistant $80 to $150
Surveyor/Survey Tech $60 to $110
Outside services contracted for a specific project, such as professional and technical consultants, laboratory
testing, reproduction, photography, etc., will be invoiced at the amount of the subconsultant's statement
plus 15 percent.
Other expenses such as travel expenses, mileage (standard IRS rates), reproduction, photography or
videography, or other direct expenses incurred by Barge and related to the work will be invoiced at the
actual cost incurred.
The hourly rates listed above are valid until September 1, 2023, after which the rates may be adjusted
annually based on average salary adjustments.