Loading...
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.