The URL can be used to link to this page

Water Fiscal Year 2026 Budget Presentation Copyrighted April 22, 2025 City of Dubuque PUBLIC HEARINGS # 2. City Council ITEM TITLE: Water Fiscal Year 2026 Budget Presentation SUMMARY: SUGGUESTED DISPOSITION: ATTACHMENTS: 1. 26 Policy Book Volume 6 - Water 2. Presentation - Uploaded 4.22.25 Page 818 of 1184 Water Department 21 Page 819 of 1184 This page intentionally left blank. 22 Page 820 of 1184 WATER DEPARTMENT Budget Highlights FY 2024 Actual FY 2025 Budget FY 2026 Requested % Change From FY 2025 Budget Expenses Employee Expense 2,534,901 2,802,456 2,834,815 1.2 % Supplies and Services 2,695,162 3,821,759 3,623,677 (5.2) % Machinery and Equipment 438,574 776,600 476,450 (38.6) % Administrative Overhead Recharges 1,369,331 2,005,611 2,215,201 10.5 % Engineering Water Maintenance Charges 61,194 64,109 65,658 2.4 % Payment in Lieu of Taxes 142,884 142,884 142,884 — % Payment to Construction Fund 1,000,000 60,000 1,500,000 2,400.0 % Debt Service 2,496,949 3,001,623 3,321,456 10.7 % Total Expenses 10,738,995 12,675,042 14,180,141 11.9 % Resources Operating Revenue 11,663,383 12,678,637 13,944,172 10.0 % General Fund - Rate Subsidy 30,257 24,593 36,000 46.4 % Total Resources 11,693,640 12,703,230 13,980,172 10.1 % Net Operating Surplus (Deficit) 954,645 28,188 (199,969) (228,157) Personnel - Authorized FTE 27.07 27.07 27.07 Water User Fee Rate Increase 8.0 % 12.0 % 9.0 % Revenue 1% Rate Increase Generates $ 106,028 Improvement Package Summary 1 of 1 This improvement package request supports the DNR's recommended Valve Turning Program. Regular valve exercising, as outlined by the DNR, ensures proper functionality and system reliability. The additional funding request is intended to address maintenance needs and issues that may arise from extended periods without a formal valve exercise program. This request support the City Council Goal Vibrant Community Healthy and Safe. Ensuring water infrastructure is adequate and well maintained helps contributes to a healthy and safe community. Related Cost: $80,000 Water User Fees Recurring Recommend - Yes Total Cost: $80,000 Sanitary User Fee Impact 0.791 % Activity: 23 Page 821 of 1184 Significant Line Items Employee Expense 1.FY 2026 employee expense reflects a 3.00% wage package increase. 2.The Iowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2025. The employee contribution of 6.29% is unchanged from FY 2025. 3.The City portion of health insurance expense is unchanged from $1,119 in FY 2025 to $1,119 in FY 2026 per month, per contract, which results in an annual cost unchanged of $0 or 0%. 4.Overtime is unchanged from $94,040 in FY 2025 to $94,040 in FY 2026 . FY 2024 actual was $126,792. 5.Five-Year Retiree Sick leave payout is decreased from $15,928 in FY 2025 to $14,960 in FY 2026. 6.50% Sick Leave Payout decreased from $4,072 in FY 2025 to $3,066 in FY 2026 based on FY 2024 actual + 3% + an expected employee addition. Effective July 1, 2019, employees over the sick leave cap can convert 50% of the sick leave over the cap to vacation or be paid out. Supplies & Services 7.Electricity increased from $973,564 in FY 2025 to $1,005,598 in FY 2026 based on FY 2024 actual of 836,634 plus 20% in planned utility company rate increases. There is a slight increase in cost in the Distribution line item due to the Water Department paying a portion of the Municipal Services Center electricity. 8.Chemicals decreased from $666,500 in FY 2025 to $629,500 in FY 2026. Chlorine decreased from $90,000 in FY 2025 to $75,000 in FY 2026. Lime decreased from $425,000 in FY 2025 to $423,000 in FY 2026. Carbon dioxide decreased from $38,000 in FY 2025 to $31,000 in FY 2026. Fluoride decreased from $15,000 in FY 2025 to $10,500 in FY 2026. Phosphate decreased from $86,000 in FY 2025 to $83,000 in FY 2026. Polymer decreased from $12,500 to $7,000 in FY 2026. 9.Hauling Contract increased from $350,000 in FY 2025 to $363,000 in FY 2026 based on FY 2025 actual price per ton of $13.44. The FY 2024 actual price per ton was $12.80.The amount of hauled tons of lime sludge is highly variable from year to year and is estimated to be approximately 27,000 tons in FY 2026. FY 2024 actual expense was $211,201. 10.Other Professional Services is increased from $145,200 in FY 2025 to $146,100 in FY 2026. This line item includes consulting services for staff training ($35,900), environmental testing fees ($37,200), fire hydrant painting ($5,000), service line assistance ($35,000), and water storage tank inspections ($33,000). 11.Technology Services increased from $104,342 in FY 2025 to $110,547 in FY 2026. The increase is due to an expected increase in cost for tablet monthly service fees, a net increase in the Meters line item due to a small increase to Tokay Software, elimination of WaterSmart, and large increase to Neptune 360, as well as a net increase in cost to the Distribution line item due to a new, shared cost with the Engineering Department for the IRTH Solutions software. 24 Page 822 of 1184 Water Administration Tablet Internet Service 2,180 Water Meters Tokay Software 14,400 WaterSmart Neptune360 (50%)54,000 Water Plant Operations Scada Tech Support For Rockwell Software 4,900 Hach Wims And Access Technologies 31,000 Water Distribution IRTH Solutions (Charge from Engineering Department)3,280 AutoCAD 787 Total Software $110,547 Software FY 2026 12.Valves/Fittings decreased from $225,447 in FY 2025 to $214,447 in FY 2026 based on FY 2024 actual of $204,235 and an expected 5% cost increase. This line item represents the purchase of water pipe, special fittings, and tapping materials for the water distribution system. This line item varies each year due to uncontrollable factors such as the number of emergency water main repairs. There is associated revenue budgeted in Taps ($36,555) and Connection Fees - Large Service ($41,135) that covers some of these expenses. This line item represents the material costs only for valves in the distribution system and ongoing valve replacement and maintenance internally in the plant. The overall increase is due in part to industry-wide price increases for supplies and parts. 13.Property Insurance increased from $168,147 in FY 2025 to $171,046 in FY 2026 based on information received from Iowa Communities Assurance Pool (ICAP). FY 2024 was $119,688 and FY 2023 was $96,628. 14.Street Materials increased from $12,568 in FY 2025 to $350,000 in FY 2026. This is for stone, gravel, cement, and rock for water main and street repairs that Public Works charges to the Water department. This increase is due to moving funding from the Other Capital Outlay expense line item in FY 2026 to better organize the budget. 15.Other Capital Outlay decreased from $420,000 in FY 2025 to $226,250 in FY 2026. This decrease is due to moving funding to the Street Materials expense line item in FY 2026 to better organize the budget. Machinery & Equipment 16.Equipment replacement items at the maintenance level include ($476,450): Water Machinery and Equipment Water Administration Laserfiche Scanning $ 300 Meters Water Meters $ 200,000 25 Page 823 of 1184 Water Distribution System Gas Generator $ 2,400 Tapping Machine $ 8,000 R2 GPS $ 8,000 Shop Vac $ 1,000 Hydrant Pressure Recorder $ 9,000 Air Hammer/Drill $ 3,500 Annual Maintenance Projects Generator Maintenance Program $ 18,000 Valve Replacement $ 26,250 Water Main Replacements (Repair)$ 75,000 Water Meter Testing $ 25,000 Valve Turning Program $ 20,000 Recommended Improvement Packages $ 80,000 Total Equipment $ 476,450 Debt Service 17.Annual debt service reflects repayment to ($3,321,456): Amount Debt Series Source Purpose Final Payment Call Date $ 60,540 SRF 2007A Water Fees Clear Wells 2028 218,090 SRF Series 2009 Water Fees Meter Change-Out 2031 431,100 Revenue 2021C Water Fees Water Improvements 2030 2028 109,260 G.O. 2018A Water Fees Water Improvements 2031 2026 38,297 G.O. 2021A Water Fees Water Improvements 2032 2028 140,170 G.O. 2021A Water Fees Water Improvements 2033 2026 657,600 G.O. 20121A Water Fees Water Improvements 2032 2028 46,088 G.O. 2016C Water Fees Water Improvements 2033 2024 673,540 SRF 2017 Water Fees CIWA Purchase/Imp 2036 269,160 SRF 2019 Water Fees Roosevelt Water Tower 2038 105,826 SRF 2021 Water Fees Water Improvements 2041 268,206 FY24 Projects Water Fees Water Improvements 2042 303,579 FY25 Projects Water Fees Water Improvements 2043 $ 3,321,456 Total Water Annual Debt Service 26 Page 824 of 1184 Revenue 18.Water User Fees increased from $11,191,345 in FY 2025 to $12,765,755 in FY 2026 based on FY 2024 actual of $10,602,787 plus and increased in water rates of 12% in FY 2025 and 9.0% in FY 2026. 19.Flat Rates decreased from $34,490 in FY 2025 to $20,713 in FY 2026. FY 2024 actual was $20,713. This charge is for customers purchasing bulk water. Rates are set by City ordinance. 20.Fire Protection Rates increased from $207,151 in FY 2025 to $226,105 in FY 2026 based on FY 2024 actual of $226,105. This fee is the demand charge for fire sprinkler head connection. The rates are set by City ordinance. 21.Tap revenue decreased from $48,823 in FY 2025 to $36,555 in FY 2026 based on FY 2024 actual of $5,957 and projected FY 2025 revenue. This fee is charged to customers for 3/4" to 1" taps and represents the cost of labor and materials. The rates are set by City ordinance, and the projections are calculated by the Engineering Assistant. 22.Tap Service increased from $21,853 in FY 2025 to $41,135 in FY 2026 based on the FY 2024 actual of $13,393 and projected FY 2025 revenue. This fee is charged to customers for 2" and larger taps and represents the actual cost of labor and materials. The rates are set by City ordinance, and the projections are calculated by the Engineering Assistant. 23.Connection Charge Front Footage is decreased from $67,860 in FY 2025 to $52,678 in FY 2026 based on FY 2024 actual of $17,192 and projected FY 2025 revenue. This fee is charged to a new user when a connection is made to the City water supply. This represents the user share of the cost of the installation of the water main. Rates are set by City ordinance. 24.Backflow Prevention Administrative Fees increased from $76,643 in FY 2025 to $77,156 in FY 2026 based on FY 2024 actual of $77,156. This is the $25 annual fee charged to all customers with a backflow device. 25.Penalties for late payments decreased from $98,465 in FY 2025 to $65,360 in FY 2026 based on FY 2024 actual of $65,375. 26.Tower Monthly Rental increased from 156,526 in FY 2025 to $160,800 in FY 2026 based on water lease contract amounts. FY 2024 actual was $156,359. 27 Page 825 of 1184 28 Page 826 of 1184 WATER DEPARTMENT The Water Department ensures our community has high-quality, safe, reliable and affordable drinking water. SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES 29 Page 827 of 1184 WATER DEPARTMENT FY 2024 FY 2025 FY 2026 Full-Time Equivalent 27.07 27.07 27.07 Resources Support FY 2024 Actual FY 2025 Budget FY 2026 Recomm'd Operating Revenue $0 $5,000,000 $10,000,000 $15,000,000 The Water Department is supported by 27.07 full-time equivalent employees, which accounts for 19.99% of the department expense as seen below. Overall, the department's expenses are expected to increase by 11.87% in FY 2026 compared to FY 2025. Expenditures by Category by Fiscal Year FY 2024 Actual FY 2025 Budget FY 2026 Requested Em p l o y e e E x p e n s e Su p p l i e s a n d S e r v i c e s Eq u i p m e n t Ad m i n O v e r h e a d Ut i l i t y B i l l i n g PI L O T Co n s t r u c t i o n F u n d De b t S e r v i c e En g i n e e r i n g C h a r g e s $0 $2,000,000 $4,000,000 $6,000,000 30 Page 828 of 1184 WATER DEPARTMENT Administration Mission & Services The City of Dubuque Water Department is dedicated to producing and delivering drinking water that is in compliance with all state and federal drinking water standards. We continually strive to adopt new and better methods of delivering the best quality drinking water to the citizens of Dubuque in the most cost-effective manner. Water Department Administration is responsible for the preparation of operating and capital budgets, interacting with the state and federal regulatory agencies, evaluation and coordination of treatment facility operations and the water distribution system functions. Water Administration Funding Summary FY 2024 Actual FY 2025 Budget FY 2026 Recomm'd Expenditures $5,758,422 $6,532,435 $8,012,057 Resources $—$—$— Water Administration Position Summary FY 2026 Water Department Director 1.00 Water Distribution Supervisor 1.00 Water Operations Supervisor 1.00 Water Engineering Assistant 1.00 Confidential Account Clerk 1.00 GIS Specialist 1.00 GIS Intern 0.50 Total FT Equivalent Employees 6.50 31 Page 829 of 1184 Performance Measures City Council Goal: Financially Responsible, High-Performance Organization: Sustainable, Equitable and Effective Service Delivery Performance Measure (KPI)Target FY 2023 Actual FY 2024 Actual FY 2025 Estimated Performance Indicator 1 Activity Objective: Maintain a financially-viable water utility. # of staff hours completing annual training to support CEUs/professional development in emergency response 20 37 35 35 Goal Met Reduction of Water Quality Issues per 100 miles of Pipe <20 16 19 15 Goal Met % of lost/unaccounted for water <18%17.1%17.2%18%Goal Met % of projects completed within the program budget 100%100%80%100%Goal Met Operating cost coverage for water (Total Operational Revenue/Total Operating Cost) 1.0 0.8 0.91 1.0 Goal Met 32 Page 830 of 1184 WATER DEPARTMENT Plant Operations and Maintenance Overview Plant Operations and Maintenance ensures that water used for domestic, commercial and industrial purposes is high quality and is supplied to meet the needs of our community. We are responsible for the management of equipment and treatment process of the City's drinking water in compliance with all federal and state water quality standards. Over 200 tests per day are performed by water treatment plant operators. In addition to these tests, the Dubuque W&RRC Laboratory performs over 60 bacteriological analysis of the drinking water on a monthly basis. Other compliance-related testing is performed by the University of Iowa Hygienic Laboratory. All of these analytical measures ensure the water reaching homes is of drinking-water quality. Plant Operations and Maintenance Funding Summary FY 2024 Actual FY 2025 Budget FY 2026 Requested Expenditures $2,626,020 $3,314,195 $3,320,867 Resources $1,072 $—$— Plant Operations and Maintenance Position Summary FY 2026 Industrial Electronic Technician 1.00 Equipment Mechanic 1.00 Plant Operator I 2.00 Plant Operator II 1.00 Plant Operator III & IV 1.00 Plant Operator IV 2.00 Total FT Equivalent Employees 8.00 33 Page 831 of 1184 Performance Measures City Council Goal: Sustainable Environment: Preserving & Enhancing Natural Resources Performance Measure (KPI)Target FY 2023 Actual FY 2024 Actual FY 2025 Estimated Performance Indicator 1 Activity Objective: Provide water treatment and distribute high-quality, clean drinking water that meets or exceeds drinking water regulations. # of Water Regulatory Compliance as No Violations 0 0 0 0 Goal Met Water Plant Process Efficiency Measured as Water Treated vs Produced (MGD Treated/MGD Produced) 1.1 .94 .97 .97 Goal in Progress Cost Effectiveness of the Treatment Process (O&M Cost/MG, thousands)<or= 1.0 0.94 1.0 1.05 Goal Not Met The 2024 Water Quality Report can be downloaded at: https://www.cityofdubuque.org/waterquality 34 Page 832 of 1184 WATER DEPARTMENT Water Distribution Mission & Services The function of the Water Distribution Team is to safely transport potable water from the source to point of use. Distribution is also responsible for the machinery, equipment, materials and personnel required to repair main breaks, install water mains, control valves and fire hydrants, and assist other sections of the Water Department. It is our goal to operate and maintain a water distribution system consistent with established procedures recognized by the American Water Works Association for efficient management practices and to meet Federal, State and local rules and regulations. Water Distribution Funding Summary FY 2024 Actual FY 2025 Budget FY 2026 Recomm'd Expenditures $1,324,890 $1,451,604 $1,328,923 Resources $11,563,338 $12,518,422 $13,850,941 Water Distribution Position Summary FY 2026 Lead Distribution Maintenance Worker 1.00 Water Distribution Maintenance Worker 6.00 Custodian I 0.07 Total FT Equivalent Employees 8.07 Performance Measures City Council Goal: Financially Responsible, High-Performance Organization: Sustainable, Equitable and Effective Service Delivery Performance Measure (KPI)Target FY 2023 Actual FY 2024 Actual FY 2025 Estimated Performance Indicator 1 Activity Objective: Ensure the integrity of the distribution system piping system. # of breaks per 100 miles of pipe <15 25.2 15.91 17 Goal Not Met Operation of 10% of system valves annually 775 808 798 775 Goal Met Hydrant effectiveness (out of service rate) <1% or 25FH <1%0%<1%<1%Goal Met O&M costs for water per 100 miles of pipe (thousands per 100 miles)<440 457 461 465 Goal Not Met The Water Department's Distribution Crew is available 24/7/365 to repair water mains and reduce service outages, minimizing the time customers are without water. DID YOU KNOW? The water distribution system is composed of 333.01 miles of public water mains ranging in diameter from 4" up to 30", 8,081 control valves, and 2,650 fire hydrants. 35 Page 833 of 1184 WATER DEPARTMENT Water Meters & Backflow Prevention Mission & Services The Water Meter Team provides dependable meter operations and maintenance. The work performed includes installation, testing, cleaning, repairing and and reassembling meters as required. The Meter Team also addresses pressure issues, performs water use investigations and manages the Backflow Prevention Program. The work is conducted in compliance with local, state and federal requirements. Water Meters Funding Summary FY 2024 Actual FY 2025 Budget FY 2026 Recomm'd Expenditures $605,236 $564,131 $575,386 Resources $118,537 $184,808 $118,538 Water Meters Position Summary FY 2026 Lead Distribution Maintenance Worker 1.00 Water Distribution Maintenance Worker 3.00 Water Distribution Maintenance Worker PT 0.50 Total Full-Time Equivalent Employees 4.50 Performance Measures City Council Goal: Sustainable Environment: Preserving & Enhancing Natural Resources Performance Measure (KPI)Target FY 2023 Actual FY 2024 Actual FY 2025 Estimated Performance Indicator 1 Activity Objective: Minimize the possibility of contamination in the distribution through the installation of backflow prevention devices. High and low hazard containment services, by definition, to participate in the backflow prevention program 100%98%99%99%Goal in Progress City Council Goal: Financially Responsible, High-Performance Organization: Sustainable, Equitable and Effective Service Delivery 1 Activity Objective: Respond to customer inquiries in a timely manner to maintain consumer confidence in the water utility. Respond to technical Meter Department service issues.100%100%100%100%Goal Met Enhanced meter reading accuracy, larger users: O&M on all large meters (>3") per AWWA standards (lg meter/ yr) 12/yr 24 13 12 Goal Met 36 Page 834 of 1184 600 - Water Operating 4A - Charges for Services 41380 - Water/Sewer Permit (156,526) (156,359) (156,526) (160,800) 45090 - Meter Rates (9,868,911) (10,602,787) (11,191,345) (12,765,755) 45095 - Fire Protection Rates (207,151) (226,105) (207,151) (226,105) 45100 - Flat Rates (34,490) (20,713) (34,490) (20,713) 45105 - Unapplied Credits (4,620) 6,079 (4,620) 0 45125 - Meter Sales - Remotes (10,993) (7,134) (10,993) (7,134) 45126 - Meters - Sales (26,134) (26,818) (82,858) (26,818) 45127 - UFR Device - Sales (2,648) (1,334) (2,648) (1,334) 45128 - Meter Repair (10,491) (5,993) (10,491) (5,993) 45129 - Stop Box Parts 0 (15) 0 0 45234 - UB-Water Repair Grt Temp Hold 0 0 0 0 45300 - Forfeitures/Penalties (98,465) (65,375) (98,465) (65,360) 45325 - Meter Tampering Fee (631) 0 (631) 0 45350 - Shut Off Penalties (13,394) (12,017) (13,394) (12,017) 45400 - Connect Fees (76,643) (77,156) (76,643) (77,156) 45410 - Connect Fee Large Svc (36,082) (13,393) (21,853) (41,135) 45415 - Connect Fee Front Footage (67,860) (17,192) (67,860) (52,678) 45420 - Taps (15,702) (5,957) (48,823) (36,555) 45500 - Miscellaneous Chg for Svcs (10,959) (6,249) (10,959) (6,249) 45520 - Customer Credits 0 0 0 0 47100 - Reimbursements (2,673) (10,693) (50) (10,693) 47150 - Refunds (440) (2,154) 0 0 47200 - Insurance Settlements (16,010) (14,697) 0 0 47450 - Sale of Salvage (23,334) (632) (1,314) (632) 4A - Charges for Services Total (10,684,158) (11,266,692) (12,041,114) (13,517,127) 4B - Grants/Contrib 44400 - State Grants 0 0 0 0 4B - Grants/Contrib Total 0 0 0 0 4K - Unrest Invest Earn 43000 - Interest (126,719) (358,736) (126,719) (427,045) 4K - Unrest Invest Earn Total (126,719) (358,736) (126,719) (427,045) 4N - Transfers 49100 - Transfer In General Fund (21,687) (30,257) (24,593) (36,000) 4N - Transfers Total (21,687) (30,257) (24,593) (36,000) 4O - Eliminated for GW 47115 - Sales Tax Collection (466,083) (37,955) (510,804) 0 48200 - Proceeds from GO Debt 0 0 0 0 Recommended Operating Revenue Budget - Department Total 42 - WATER Fund/Account/Account Title FY23 Actual Revenue FY24 Actual Revenue FY25 Adopted Budget FY26 Recomm'd Budget 37 Page 835 of 1184 48205 - Bond Discount/Premium 0 0 0 0 48250 - Proceeds from SRF 0 0 0 0 4O - Eliminated for GW Total (466,083) (37,955) (510,804) 0 WATER - Total (11,298,647)(11,693,640)(12,703,230)(13,980,172) Recommended Operating Revenue Budget - Department Total 42 - WATER Fund/Account/Account Title FY23 Actual Revenue FY24 Actual Revenue FY25 Adopted Budget FY26 Recomm'd Budget 38 Page 836 of 1184 6A - Salaries & Wages 600 - Water Operating 60100 - Salaries-Regular Full Time 1,638,562 1,606,095 1,849,257 1,885,129 60200 - Salaries - Regular Part Time 17,690 11,663 31,598 29,389 60300 - Hourly Wages - Temp/Seasonal 3,438 7,613 17,693 15,837 60400 - Overtime 143,304 126,792 94,040 94,040 60410 - Overtime - Holiday 29,427 27,734 17,000 17,000 60630 - Special Pay Sick Lv Payout Ret 12,251 12,983 15,928 14,960 60635 - Special Pay Sick Lv Payout 50% 3,878 2,977 4,072 3,066 60640 - Special Pay - Vacation Payout 7,439 26,942 0 0 60710 - Special Pay - Parental Leave 13,049 7,578 0 0 60720 - Spec Pay - Meals No Overnight 33 12 0 0 60730 - Spec Pay - Safety Equipment 3,220 2,323 5,500 5,500 60740 - Spec Pay - Meal Allowance 649 246 1,200 0 60780 - Spec Pay - Tank Climb Pay 30 0 1,200 1,200 6A - Salaries & Wages Total 1,872,971 1,832,956 2,037,488 2,066,121 6B - Employee Benefits 600 - Water Operating 61100 - FICA - City Contribution 135,259 133,237 155,361 157,547 61300 - IPERS - City Contribution 173,953 168,915 189,820 192,708 61510 - Health Insurance 328,864 349,751 375,844 375,844 61540 - Life Insurance 1,174 1,115 1,334 1,334 61600 - Workers' Compensation 43,396 41,899 42,100 40,857 61992 - Physicals 428 974 509 404 6B - Employee Benefits Total 683,074 695,890 764,968 768,694 6C - Staff Development 600 - Water Operating 62100 - Association Dues 3,413 2,247 4,102 3,500 62200 - Subscriptions 484 21 300 22 62325 - Mileage 4,012 3,793 5,124 5,200 62400 - Meetings & Conferences 3,897 5,648 5,350 7,340 62500 - Education Reimbursement 12,988 13,421 18,750 18,750 6C - Staff Development Total 24,793 25,130 33,626 34,812 6D - Repair/Maint/Util 600 - Water Operating 63100 - Building Maintenance 58,089 74,761 96,773 78,131 63311 - Vehicle Ops - Diesel 0 0 0 0 63312 - Vehicle Ops - Gasoline 37,436 31,215 35,898 31,215 63320 - Vehicle Repair - Internal 30,861 52,165 44,764 32,403 63321 - Vehicle Repair - Outsourced 15,348 29,878 15,655 30,476 Recommended Operating Expenditure Budget - Department Total 42 - WATER Fund/Account/Account Title FY23 Actual Expense FY24 Actual Expense FY25 Adopted Budget FY26 Recomm'd Budget 39 Page 837 of 1184 63322 - Vehicle Repair - Accident 0 0 0 0 63400 - Equipment Maint/Repair 61,830 58,964 78,067 81,741 63425 - Meter Maintenance 1,380 (261) 2,000 2,000 63430 - Instrument Maintenance 1,048 0 29,704 30,000 63710 - Electricity 886,670 836,634 973,564 1,005,598 63711 - Natural Gas 59,758 44,059 59,853 49,214 63730 - Telecommunications 23,398 19,879 14,352 22,475 63742 - Stormwater 1,490 1,647 1,702 1,730 63790 - Other Utility Expense 418 2,985 15,000 4,000 6D - Repair/Maint/Util Total 1,177,725 1,151,927 1,367,332 1,368,983 6E - Contractual Svcs 600 - Water Operating 64010 - Accounting & Auditing 8,250 6,891 8,250 8,250 64020 - Advertising 849 2,126 1,338 2,127 64030 - Outsourced Labor 0 0 0 0 64040 - Collections 2,197 2,213 2,197 2,213 64045 - Bad Debt Expense 0 864 0 0 64062 - Refunds 0 0 0 0 64080 - Insurance - Property 96,628 119,688 168,147 10,187 64081 - Insurance - Liability 33,169 32,877 42,422 42,118 64083 - Insurance - Other 0 0 0 0 64110 - Legal 0 0 0 0 64135 - Grants 2,301 2,652 10,000 10,000 64140 - Printing 177 1,308 1,914 4,192 64145 - Copying 1,494 643 1,493 548 64150 - Rental - Equipment 4,054 2,483 6,000 2,483 64160 - Rental - Land/Bldgs/Parking 660 720 660 720 64175 - Landfill Fees 788 0 2,288 1,500 64180 - Sales Tax Expense 450,444 94,968 510,804 0 64185 - License/Permit/Fees 6,921 6,710 6,921 6,710 64190 - Technology Services 69,358 60,964 104,342 110,547 64191 - IT Recharges 21,172 21,743 22,658 23,824 64820 - One Call 10,299 7,544 10,299 10,500 64825 - Fire Suppression 242 371 1,700 371 64865 - Elevator Service 2,441 2,169 2,410 2,410 64870 - HVAC Services 0 0 3,744 3,744 64880 - Custodial Services 0 0 0 0 64900 - Other Professional Service 115,146 83,780 145,200 146,100 64975 - Equip Maint Cont 1,823 2,194 1,823 2,194 64980 - Technology Equip Maint Cont 2,184 900 12,777 900 Recommended Operating Expenditure Budget - Department Total 42 - WATER Fund/Account/Account Title FY23 Actual Expense FY24 Actual Expense FY25 Adopted Budget FY26 Recomm'd Budget 40 Page 838 of 1184 64985 - Hauling Contract 279,050 211,201 350,000 363,000 64990 - Other Contractual Service 0 42 6,000 6,000 6E - Contractual Svcs Total 1,109,648 665,051 1,423,387 760,638 6F - Commodities 600 - Water Operating 65010 - Chemicals 594,487 547,331 666,500 629,500 65040 - Small Tools & Equipment 16,595 9,541 14,679 20,200 65045 - Technology Equipment 16,859 547 0 300 65050 - Other Equipment 22,892 11,729 138,600 31,900 65054 - Safety Equipment 600 0 0 0 65060 - Office Supplies 7,345 3,129 6,819 3,716 65080 - Postage/Shipping 2,429 3,064 2,621 3,296 65100 - Safety Supplies 6,328 5,193 8,122 5,193 65925 - Uniform Purchase 19,064 21,921 27,000 27,000 65950 - Valves/Fittings 225,447 204,235 225,447 214,447 65960 - Repair Parts 7,251 13,487 3,844 1,482 65965 - Janitorial 4,630 4,559 5,014 4,559 65970 - Lab Supplies 15,494 24,747 21,830 24,747 65975 - Plumbing Supplies 1,220 1,376 70 2,376 65980 - Construction Supplies 203 567 2,650 3,500 65981 - Street Materials 12,568 5,036 12,568 350,000 65990 - Other Supplies 2,498 8,369 250 8,369 6F - Commodities Total 955,911 864,831 1,136,014 1,330,585 6G - Capital Outlay 600 - Water Operating 67100 - Vehicles 133 0 0 0 67210 - Furniture/Fixtures 0 0 0 0 67230 - Heavy Equipment 0 0 0 0 67250 - Office Equipment 0 0 0 0 67270 - Other Capital Equipment 7,898 23,278 18,000 18,000 67500 - Buildings 0 0 0 0 67809 - Water - Meters 22,440 0 0 0 67810 - Water - Large Meters 50,200 81,795 200,000 200,000 67815 - Water - Hydrants 91,456 76,552 0 0 67990 - Other Capital Outlay 392,640 244,673 420,000 226,250 6G - Capital Outlay Total 564,767 426,298 638,000 444,250 6H - Debt Service 600 - Water Operating 68010 - Principal Payment 1,959,654 1,995,897 2,358,616 2,604,651 68020 - Interest Payments 540,298 501,052 643,007 716,805 Recommended Operating Expenditure Budget - Department Total 42 - WATER Fund/Account/Account Title FY23 Actual Expense FY24 Actual Expense FY25 Adopted Budget FY26 Recomm'd Budget 41 Page 839 of 1184 68980 - Financial Consultant 0 500 0 0 68990 - Paying Agent Fees 600 0 0 0 6H - Debt Service Total 2,500,552 2,497,449 3,001,623 3,321,456 6I - Transfers 600 - Water Operating 69100 - Transfers Out To General Fund 595,651 1,512,215 2,148,495 2,358,085 69601 - Transfers Out to Water Cap 1,000,000 1,000,000 60,000 1,500,000 6I - Transfers Total 1,595,651 2,512,215 2,208,495 3,858,085 WATER - Total 10,485,091 10,677,800 12,610,933 13,953,624 Recommended Operating Expenditure Budget - Department Total 42 - WATER Fund/Account/Account Title FY23 Actual Expense FY24 Actual Expense FY25 Adopted Budget FY26 Recomm'd Budget 42 Page 840 of 1184 600 - Water Operating 6E - Contractual Svcs ——— 6I - Transfers 2,512,215 2,208,495 3,858,085 0000 - No Sub-Activity Total 2,512,215 2,208,495 3,858,085 4201 - Administration 600 - Water Operating 6A - Salaries & Wages 436,788 549,882 566,430 6B - Employee Benefits 152,169 174,825 177,549 6C - Staff Development 13,284 17,000 17,000 6D - Repair/Maint/Util 687 3,120 2,400 6E - Contractual Svcs 144,331 577,076 67,478 6F - Commodities 1,499 414 1,659 6G - Capital Outlay ——— 6H - Debt Service 2,497,449 3,001,623 3,321,456 6I - Transfers ——— 4201 - Administration Total 3,246,207 4,323,940 4,153,972 4202 - Meters 600 - Water Operating 6A - Salaries & Wages 379,678 311,668 312,891 6B - Employee Benefits 125,713 129,062 128,883 6C - Staff Development 4,441 5,805 5,550 6D - Repair/Maint/Util 29,527 31,415 34,425 6E - Contractual Svcs 59,233 75,761 79,137 6F - Commodities 6,361 10,420 14,500 6G - Capital Outlay 283 —— 4202 - Meters Total 605,236 564,131 575,386 4203 - Plant Operations and Maint 600 - Water Operating 6A - Salaries & Wages 452,589 606,850 614,198 6B - Employee Benefits 200,702 227,407 227,677 6C - Staff Development 3,022 3,350 3,500 6D - Repair/Maint/Util 950,155 1,158,452 1,168,880 6E - Contractual Svcs 409,609 608,079 469,757 6F - Commodities 609,942 710,057 682,055 6G - Capital Outlay ——— 4203 - Plant Operations and Maint Total 2,626,020 3,314,195 3,166,067 4204 - Distribution System 600 - Water Operating Recommended Expenditure Budget Report by Activity & Funding Source 42 - WATER Fund/Activity FY24 Actual Expense FY25 Adopted Budget FY26 Recomm'd Budget 0000 - No Sub-Activity 43 Page 841 of 1184 6A - Salaries & Wages 563,901 569,088 572,602 6B - Employee Benefits 217,307 233,674 234,585 6C - Staff Development 4,383 7,471 8,762 6D - Repair/Maint/Util 171,558 174,345 163,278 6E - Contractual Svcs 49,198 79,471 61,266 6F - Commodities 241,992 387,555 282,371 6G - Capital Outlay 76,552 —— 4204 - Distribution System Total 1,324,890 1,451,604 1,322,864 4215 - Snow Plowing 110 - Road Use Tax 6A - Salaries & Wages 4,521 —— 6B - Employee Benefits 1,534 —— 4215 - Snow Plowing Total 6,055 0 0 4220 - Storage Tank Inspection 600 - Water Operating 6E - Contractual Svcs —15,000 33,000 4220 - Storage Tank Inspection Total 0 15,000 33,000 4221 - Meter Reading System Maint 600 - Water Operating 6G - Capital Outlay ——— 4221 - Meter Reading System Maint Total 0 0 0 4222 - Pump/Vacuum Filter Replace 600 - Water Operating 6F - Commodities —15,000 — 4222 - Pump/Vacuum Filter Replace Total 0 15,000 0 4224 - Fire Hydrant Painting 600 - Water Operating 6E - Contractual Svcs 27 5,000 5,000 4224 - Fire Hydrant Painting Total 27 5,000 5,000 4225 - GIS Maint/Updates 600 - Water Operating 6E - Contractual Svcs ——— 4225 - GIS Maint/Updates Total 0 0 0 4226 - Service Line Assistance 600 - Water Operating 6E - Contractual Svcs —35,000 35,000 4226 - Service Line Assistance Total 0 35,000 35,000 Recommended Expenditure Budget Report by Activity & Funding Source 42 - WATER Fund/Activity FY24 Actual Expense FY25 Adopted Budget FY26 Recomm'd Budget 0000 - No Sub-Activity 44 Page 842 of 1184 4227 - Valve Replacement 600 - Water Operating 6G - Capital Outlay 3,450 20,000 100,000 4227 - Valve Replacement Total 3,450 20,000 100,000 4228 - Internal Lines Loan 600 - Water Operating 6G - Capital Outlay ——— 4228 - Internal Lines Loan Total 0 0 0 4229 - Main Replacements 600 - Water Operating 6A - Salaries & Wages ——— 6B - Employee Benefits ——— 6F - Commodities 5,036 12,568 350,000 6G - Capital Outlay 225,840 350,000 75,000 4229 - Main Replacements Total 230,876 362,568 425,000 4230 - Meter Exchange 600 - Water Operating 6G - Capital Outlay 81,512 200,000 200,000 4230 - Meter Exchange Total 81,512 200,000 200,000 4231 - Leak Repair Grant 600 - Water Operating 6E - Contractual Svcs 1,152 5,000 5,000 4231 - Leak Repair Grant Total 1,152 5,000 5,000 4232 - Valve Box Maintenance 600 - Water Operating 6G - Capital Outlay 12,280 25,000 26,250 4232 - Valve Box Maintenance Total 12,280 25,000 26,250 4234 - Generator Maintenance 600 - Water Operating 6G - Capital Outlay 23,278 18,000 18,000 4234 - Generator Maintenance Total 23,278 18,000 18,000 4235 - County Water Assistance 600 - Water Operating 6E - Contractual Svcs 1,500 5,000 5,000 4235 - County Water Assistance Total 1,500 5,000 5,000 4236 - Water Meter Testing 600 - Water Operating 6G - Capital Outlay 3,103 25,000 25,000 4236 - Water Meter Testing Total 3,103 25,000 25,000 Recommended Expenditure Budget Report by Activity & Funding Source 42 - WATER Fund/Activity FY24 Actual Expense FY25 Adopted Budget FY26 Recomm'd Budget 0000 - No Sub-Activity 45 Page 843 of 1184 4237 - Water Leak Survey 600 - Water Operating 6E - Contractual Svcs —18,000 — 4237 - Water Leak Survey Total 0 18,000 0 4299 - Pcard Clearing 600 - Water Operating 6F - Commodities ——— 4299 - Pcard Clearing Total 0 0 0 WATER TOTAL 10,677,800 12,610,933 13,953,624 Recommended Expenditure Budget Report by Activity & Funding Source 42 - WATER Fund/Activity FY24 Actual Expense FY25 Adopted Budget FY26 Recomm'd Budget 0000 - No Sub-Activity 46 Page 844 of 1184 C I T Y O F D U B U Q U E , I O W A DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 42 WATER DEPARTMENT FY 2026 FD JC WP-GR JOB CLASS FTE BUDGET 61010 Full Time Employee Expense 600 3885 GE-18 WATER DEPARTMENT DIRECTOR 1.00 $ 134,136 600 3975 GE-14 WATER DISTRIBUTION SUPERVISOR 1.00 $ 95,637 600 3965 GE-14 WATER OPERATIONS SUPERVISOR 1.00 $ 100,671 600 3815 GE-12 WATER ENGINEERING ASSISTANT 1.00 $ 66,607 600 7887 OE-09 LEAD WATER DISTR MAINT WORKER 2.00 $ 162,659 600 7980 GE-12 GIS SPECIALIST 1.00 $ 78,369 600 5010 GE-07 ADMIN SUPPORT PROF 1.00 $ 60,159 600 7990 OE-16 INDUSTRIAL ELECTRICAL TECH 1.00 $ 85,532 600 8875 OE-14 EQUIPMENT MECHANIC 1.00 $ 68,869 600 8025 OE-16 PLANT OPERATOR GRADE III 1.00 $ 63,179 600 8005 OE-11 PLANT OPERATOR GRADE I 2.00 $ 123,871 600 8015 OE-12 PLANT OPERATOR GRADE II 1.00 $ 65,912 600 8035 OE-16 PLANT OPERATOR GRADE IV 2.00 $ 153,776 600 7890 OE-10 EQUIPMENT OPERATOR II 1.00 $ 59,214 600 8175 OE-09 WATER DISTR MAINT WORKER 9.00 $ 563,134 600 7830 GE-06 CUSTODIAN 0.07 $ 3,404 TOTAL FULL TIME EMPLOYEES 26.07 $ 1,885,129 61020 Part-Time Employee Expense 600 8,175 OE-09 WATER DISTR MAINT WORKER 0.50 $ 29,389 TOTAL PART TIME EMPLOYEES 0.50 $ 29,389 61030 Seasonal Employee Expense 600 GE-03 GIS INTERN 0.50 $ 15,837 TOTAL SEASONAL EMPLOYEES 0.50 $ 15,837 TOTAL WATER DEPARTMENT 27.07 $ 1,930,355 47 Page 845 of 1184 Water Administration-FT 4201 60100 600 7980 GE-12 GIS SPECIALIST 1.00 $ 78,369 4201 60100 600 3885 GE-18 WATER DEPARTMENT DIRECTOR 1.00 $ 134,136 4201 60100 600 GE-07 ADMIN SUPPORT PROF 1.00 $ 60,159 4201 60100 600 3815 GE-12 WATER ENGINEERING ASSISTANT 1.00 $ 66,607 4201 60100 600 GE-14 WATER OPERATIONS SUPERVISOR 1.00 $ 100,671 4201 60100 600 3975 GE-14 WATER DISTRIBUTION SUPERVISOR 1.00 $ 95,637 Total 6.00 $ 535,579 Water Administration-Temporary 4201 60300 600 GE-03 GIS INTERN 0.50 $ 15,837 Total 0.50 $ 15,837 Water Meters-FT 4202 60100 600 8175 OE-09 WATER DISTR MAINT WORKER 3.00 $ 185,437 4202 60100 600 7887 OE-09 LEAD WATER DISTR MAINT WORKER 1.00 $ 78,372 Total 4.00 $ 263,809 Water Meters-PT 4202 60200 600 8175 OE-09 WATER DISTR MAINT WORKER 0.50 $ 29,389 Total 0.50 $ 29,389 Water Plant Operation-FT 4203 60100 600 OE-11 PLANT OPERATOR GRADE I 2.00 $ 123,871 4203 60100 600 801 5 OE-12 PLANT OPERATOR GRADE II 1.00 $ 65,912 4203 60100 600 8025 OE-16 PLANT OPERATOR GRADE III 1.00 $ 63,179 4203 60100 600 OE-16 PLANT OPERATOR GRADE IV 2.00 $ 153,776 4203 60100 600 7990 OE-16 INDUSTRIAL ELECTRICAL TECH 1.00 $ 85,532 4203 60100 600 8875 OE-14 EQUIPMENT MECHANIC 1.00 $ 68,869 Total 8.00 $ 561,139 Water Distribution-FT 4204 60100 600 8175 OE-09 WATER DISTR MAINT WORKER 6.00 $ 377,697 4204 60100 600 7890 OE-10 EQUIPMENT OPERATOR II 1.00 $ 59,214 4204 60100 600 7887 OE-19 LEAD WATER DISTR MAINT WORKER 1.00 $ 84,287 4204 60100 600 7830 GE-06 CUSTODIAN 0.07 $ 3,404 Total 8.07 $ 524,602 TOTAL WATER DEPARTMENT 27.07 $ 1,930,355 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2026 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET 48 Page 846 of 1184 4281000001 SCADA and Communications Imp Water 601 64070 200,000 4281000005 Water Main Replacements - Streets Water 601 67990 540,000 4281000006 Wells/Well Field Rehab Water 601 67990 110,500 4281000013 Water Meter Replacement Water 601 65050 406,600 4281000017 Water Main Reloc Manhole proj Water 601 67100 50,000 4281000018 Fire hydrant Recl/replc Water 601 67990 20,000 4281000019 Mainten Public Water Mains Water 601 67990 20,000 4281000021 Water main upgrades Water 601 67990 30,000 4281000022 Water main replc-Sewer prog Water 601 67990 309,000 4281000026 Water Treatment Plant Plan Water 601 64070 10,000 4281000044 WTP Roof Repair Water 601 67990 590,000 4281000045 Green Alley Water Main Imp Water 601 67990 306,000 4281000053 Vehicle 4911 Tandem Dump Truck Repl Water 601 67100 81,000 4281000060 Water Treatment Plant Pipe Rehabili Water 601 67990 30,000 4281000061 Cla-Val Link2Valves Maintenance Pro Water 601 67990 37,800 4281000062 Deere X738 Water 601 67100 38,000 4281000063 Vehicle 4907 Replacement Water 601 67100 90,000 4281000064 WTP Third Floor Conference Room Water 601 67990 114,000 4281000065 Vehicle 4904 Replacement Water 601 67100 115,000 4281000066 Greyhound Park Rd Water Main Loop Water 601 67990 120,000 4281000067 Fire Hydrant Stock Water 601 67990 123,000 4281000068 Vehicle 4901 Replacement Water 601 67100 130,000 4281000069 Municipal Service Center Roof Repla Water 601 67990 187,380 WATER TOTAL 3,658,280 Capital Improvement Projects by Department/Division WATER Project Number Capital Improvement Project Title Department Fund Account FY26 Recomm'd Budget 49 Page 847 of 1184 8th Street 20" Transmission Water Main Connection (Jackson to Central)$ — $ — $ — $ 166,000 $ — $ 166,000 33 Admiral Sheehy Drive Water Main Loop $ — $ — $ — $ — $ 686,400 $ 686,400 34 Cla-Val Link2Valves Maintenance Program for Water Distributions Specialty Valves $ 37,800 $ — $ 27,300 $ — $ 27,300 $ 92,400 35 Enterprise Asset Management System Software-Water $ — $ 50,000 $ 50,000 $ 50,000 $ — $ 150,000 36 Fire Hydrant Stock $ 123,000 $ 123,000 $ 123,000 $ 123,000 $ 123,000 $ 615,000 37 Fire Hydrant Assembly Relocation/Replacement for the Sidewalk Program $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 100,000 38 Generators-Park Hill & Mt. Carmel $ — $ 175,000 $ — $ — $ — $ 175,000 39 Green Alley Water Main Improvements $ 306,000 $ — $ — $ — $ — $ 306,000 40 Greyhound Park Rd Water Main Loop $ 120,000 $ — $ — $ — $ — $ 120,000 41 Highway 20/Dodge St Water Main Relocation - Devon Drive to Concord St $ — $ — $ — $ — $ 199,000 $ 199,000 42 Leak Detection Correlator Replacement $ — $ 35,000 $ — $ — $ 35,000 $ 70,000 43 Maintenance of Public Water Mains During Stone Retaining Wall Repair $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 100,000 44 Municipal Services Center Roof Mounted HVAC Replacement Unit $ — $ 94,500 $ — $ — $ — $ 94,500 45 Municipal Service Center Roof Replacement $ 187,380 $ — $ — $ — $ — $ 187,380 46 Public Lead Line Water Main Replacement $ — $ — $ — $ 45,000 $ — $ 45,000 47 SCADA & Comms Improvements $ 200,000 $ — $ — $ — $ — $ 200,000 48 Source Water PFAS Reduction Project - Granular Activated Carbon Filter Rehabilitation $ — $ — $ 6,400,000 $ 3,200,000 $ — $ 9,600,000 49 Source Water PFAS Reduction Project $ — $ — $ 371,199 $ 750,000 $ — $ 1,121,199 50 South Algona 12" Water Main Replacement $ — $ — $ — $ 729,103 $ — $ 729,103 51 Third Pressure Zone Connection (Tanzanite Drive to Olympic Heights)$ — $ — $ 2,000,000 $ — $ — $ 2,000,000 52 PRGRM/ DEPT PROJECT DESCRIPTION FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 TOTAL PAGE WATER DEPARTMENT Business Type 50 Page 848 of 1184 Vehicle 4901 Replacement $ 130,000 $ — $ — $ — $ — $ 130,000 53 Vehicle 4904 Replacement $ 115,000 $ — $ — $ — $ — $ 115,000 54 Vehicle 4907 Replacement $ 90,000 $ — $ — $ — $ — $ 90,000 55 Vehicle 4908 Replacement $ — $ 115,000 $ — $ — $ — $ 115,000 56 Deere X738 $ 38,000 $ — $ — $ — $ — $ 38,000 57 Water Distribution Master Plan $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 50,000 58 Water Main Relocation for Sanitary Sewer Manhole Project $ 50,000 $ — $ 50,000 $ — $ 50,000 $ 150,000 59 Water Main Replacement Consent $ 309,000 $ 311,000 $ — $ 660,000 $ — $ 1,280,000 60 Water Main Replacements - Streets $ 540,000 $ — $ — $ — $ — $ 540,000 61 Water Main Upgrades during Street General Repairs $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 150,000 62 Water Meter Replacement Program $ 406,600 $ 137,550 $ 130,950 $ 130,950 $ 130,950 $ 937,000 63 Water Storage Maintenance Program $ — $ 1,204,000 $ 296,000 $ 1,000,000 $ 500,000 $ 3,000,000 64 Water Treatment Boiler Replacements $ — $ 300,000 $ — $ — $ — $ 300,000 65 Water Treatment Plant Roof Replacement $ 590,000 $ — $ 110,000 $ 350,000 $ — $ 1,050,000 66 Wells, Well Field, & Well Transmission Piping Repair and Rehabilitation Program $ 110,500 $ 110,500 $ 165,000 $ 150,000 $ 162,000 $ 698,000 67 West End Annexation Phase II $ — $ 300,000 $ 1,694,598 $ — $ — $ 1,994,598 68 Water Treatment Plant and Pump Station Pipe Rehabilitation $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 150,000 69 Water Treatment Plant Third Floor Conference Room $ 114,000 $ — $ — $ — $ — $ 114,000 70 Vehicle 4911 Tandem Dump Truck Replacement $ 81,000 $ — $ — $ — $ — $ 81,000 71 TOTAL $ 3,658,280 $ 3,065,550 $ 11,528,047 $ 7,464,053 $ 2,023,650 $ 27,739,580 PRGRM/ DEPT PROJECT DESCRIPTION FY 2026 FY 2027 FY 2028 FY 2029 FY 2030 TOTAL PAGE WATER DEPARTMENT Business Type 51 Page 849 of 1184 This page intentionally left blank. 52 Page 850 of 1184 WATER DEPARTMENT FISCAL YEAR 2026 BUDGET PRESENTATION Page 851 of 1184 MISSION STATEMENT Water Department The City of Dubuque Water Department is passionate about delivering high quality drinking water with excellent customer service, while meeting our customers’ changing needs with equitable and sustainable rates. Page 852 of 1184 Water Department FY 26 (27.07 Full -Time Equivalents) Page 853 of 1184 New Faces in FY2025 Ken Huseman, Water Distribution Maintenance Worker (Part-Time) Tom Kearney, Water Distribution Maintenance Worker Nick Kunde, Water Plant Operator Jordan Lamey, Water Distribution Maintenance Worker Page 854 of 1184 Recognition of Staff for Certifications Obtained Insert Image Here Insert Image Here Tom Kearney -Water Distribution Grade 1 Mike Reinert -Water Treatment Grade 1 Nick Kunde -Water Treatment Grade 1 & 2 Brad Winter -Water Treatment Grade 1 Water Distribution Grade 1 Marty Kass -Water Distribution Grade 2 Nate McLaughlin -Water Distribution Grade 2 Darrin Homb -Water Distribution Grade 4 Tom Kearney -IDPH Backflow Prevention Tester Chris Kerf -IDPH Backflow Prevention Tester Page 855 of 1184 2024 SPIRIT Awards -Water Insert Image Here Insert Image Here Page 856 of 1184 FISCAL YEAR 2025 HIGHLIGHTS Utility Rate Reduction Page 857 of 1184 FISCAL YEAR 2025 HIGHLIGHTS •Lead Service Line Inventory Completed - Regulatory Compliance ◦Under the Lead and Copper Rule Revisions, water systems were required to prepare and maintain an inventory of service line materials by October 16, 2024. ◦The information must be publicly accessible, for systems with a population >50,000. The inventory can viewed at https://www.cityofdubuque.org/494/Water-Department under the “Lead Service Line Inventory Map” heading. ◦All persons served by the water system at the service connection with a lead, GRR, or lead “status unknown” service line, received a customer notification of known or potential service line containing lead within 30 days of completion of the inventory (initial) and will receive a repeat notification on an annual basis until the service is no longer lead. ◦The City of Dubuque Water Department completed this requirement by the October 16, 2024 deadline. Page 858 of 1184 FISCAL YEAR 2025 HIGHLIGHTS •Water Meter Technical Upgrade Program •Water Meter Product Replacement of Meter Interface Units and Registers •5-Year Program. Initiated in FY2022. ◦In Progress •Work Performed by Water Department Meter Crew •Total Project Cost Estimate: $1,885,000 Danny Petersen installing new MIU Page 859 of 1184 FISCAL YEAR 2025 HIGHLIGHTS •Well No. 2 pump was experiencing issues and required repair and rehabilitation. •Repair work included: well televising, brush and bailing, air shock, acidizing, setting a temporary pump for flushing sediment and reinstalling the permanent pump. •Contract Amount: $76,742 ◦Project Completed March 2025 •Contractor: Peerless Well & Pump Well No. 2 Repair & Rehabilitation Page 860 of 1184 FISCAL YEAR 2025 HIGHLIGHTS •The current SCADA system has been in place since 1993 and the programming and operating system, RSLogix 500, is outdated and the hardware is no longer supported by the manufacture/vendor. •Replace outdated and obsolete equipment, hardware and software, and provide an opportunity to make operational efficiency and security improvements both at the Water Treatment Plant and also at the remote sites. •Contract Amount: $1,345,000 ◦Project In Progress: Est. Completion June 2026 •Contractor: Westphal & Company, Dubuque, Iowa Eagle Point Water Plant Supervisory Control and Data Acquisition (SCADA) Upgrade Page 861 of 1184 FUTURE INITIATIVES Private Lead Service Line Replacement Pilot Program •Multi Year Replacement Program for an estimated 585 Lead Service Lines •1st of 3 Phases Scheduled to begin in FY2025 ◦1 Year Construction period per phase ◦$0 Cost to the Owner or Tenant in Disadvantaged Communities •Phases 2 & 3 to begin in 2026 •Funding: Bipartisan Infrastructure Law monies to Iowa State Revolving Fund Loan Program •49% Loan Forgiveness to City in Disadvantaged Community Areas Page 862 of 1184 FUTURE INITIATIVES FY25 SW Arterial Water Main Extension •Installation of : ◦4,200 feet of 16-inch, and ◦2,900 feet of 12-inch water main •North Cascade Rd/Edval Lane to North English Road •Part of a Phased Water Main Extension project to: ◦Promote Improved Service to Existing Customers ◦Growth and Development along SW Arterial Corridor Page 863 of 1184 FUTURE INITIATIVES Drinking Water Quality Improvements: FY 25 Well No. 11 •Dubuque and PFAS ◦Required to Complete Quarterly Sampling ◦Since routine testing started in March 2023: 1 Exceedance •Funding for New Well: ◦Total Project Cost: $4.435MM plus contingency Page 864 of 1184 Page 865 of 1184 Page 866 of 1184 Page 867 of 1184 Page 868 of 1184 FY 26 PROPOSED RATE INCREASE 9.00% Proposed Rate Increase over FY 25 $3.60 Monthly Bill Impact for Average Household* *Average Household = 6,000 Gallons/Month Page 869 of 1184 RATE COMPARISON Page 870 of 1184 FY 26 Water Rate Comparison 4th Lowest Rates:The Highest Water Rate (Des Moines)is 8.03%Higher than Dubuque’s Rate;and the Average Rate is 2.20%Lower than Dubuque. Based Average Household = 6,000 Gallons/Month Page 871 of 1184 PUBLIC SAFETY WATER DEPARTMENT IMPACT ON PUBLIC SAFETY •Promotes overall public health •Supports Other City Departments •Emergency Preparedness Page 872 of 1184 NEED FOR INFRASTRUCTURE INVESTMENT The projected gap between drinking water infrastructure needs and investments in 2024 stood at $309 billion and is expected to grow to $620 billion by 2043 Source: American Society of Civil Engineers, Value of Water Campaign, “Bridging the Gap: The Power of Investment in Water,” 2 024.Page 873 of 1184 NEED FOR INFRASTRUCTURE INVESTMENT Challenges in Dubuque •Infrastructure ◦Aging/Fatigued ▪Water Main ▪Pumping & Storage Facilities *Leading Contributor to Water Loss •Topography ◦9 Pressure Zones ◦Distribution System Pressure Management •Emerging Contaminants ◦PFAS •Regulatory Compliance ◦Lead and Copper Rule Improvements Page 874 of 1184 WATER ADMINISTRATION •Employee Training and Development ◦Professional Development ◦On Boarding of New Employees ◦Continuing Education Programs •Regulatory Compliance ◦Reporting, monitoring, and working with Iowa DNR and EPA on compliance. •Capital Improvement Planning ◦Project development including budgeting, initiation, and award through construction completion. Page 875 of 1184 WATER TREATMENT PLANT OPERATIONS •Water Production and Treatment ◦Regulatory Compliance ◦Water Quality -Consumer Confidence •Source Water Protection ◦Wells and the Well field ◦Treatment Plant •Water Storage and Pumping Facility Operation and Maintenance •Reliable Data Access and Reporting ◦SCADA Communications Page 876 of 1184 WATER PLANT OPERATIONS Page 877 of 1184 WATER DISTRIBUTION •Operation and Maintenance •Emergency Response •Inspection •General Construction •Service Line Main Taps •Water Main Installation •Meter Management •Backflow Prevention •Development Review Page 878 of 1184 WATER DISTRIBUTION Page 879 of 1184 WATER DISTRIBUTION *FY 2025 to date: 67 Service Taps New Connections result from community growth such as new housing, businesses, and industry. Page 880 of 1184 WATER DISTRIBUTION Starting in FY20, the Water Distribution Meter Crew assumed all responsibility for: •meter repairs, •testing, •change outs, and •service calls, which were originally handled by Utility Billing. Page 881 of 1184 Backflow Prevention Program •Administered internally. •Administrative fee $25/device. •FY2025 Revenue to Date: ◦$80,100 ◦3,289 devices tracked Jeff Mills performs backflow recertification testing Page 882 of 1184 FY 2026 RECOMMENDED IMPROVEMENT REQUESTS 1.Additional Operating Funds to support a formal Valve Turning Program recommended by the Iowa DNR. This additional funding addresses maintenance needs and issues that may arise from extended periods without a formal valve exercise program. Estimated Cost: $80,000 (Recurring) Page 883 of 1184 Project FY 26 Cost Project Cost Eagle Point Water Plant Roof Repair $590,000 $590,000 Water Main Replacements -Streets $540,000 $540,000 Water Meter Replacement Program $406,600 $1,885,000 Water Main Replacements -Sewer Program $309,000 $309,000 Green Alley Water Main Improvements $306,000 $306,000 SCADA & Communication Improvements $200,000 $1,345,000 Municipal Service Center Roof Replacement $187,380 $739,110 Greyhound Park Rd Water Main Loop $120,000 $120,000 Eagle Point Water Plant Conference Room Addition $114,000 $114,000 Wells/Well Field Rehab $110,500 $110,500 Water Treatment Plant Pipe Rehabilitation $30,000 $30,000 FY 26 CAPITAL IMPROVEMENT PROJECTS Water Department Page 884 of 1184 Project FY 26 Cost Project Cost Fire Hydrant Stock/Replacement $150,000 $150,000 Vehicle 4901 Replacement $130,000 $130,000 Vehicle 4904 Replacement $115,000 $115,000 Vehicle 4907 Replacement $90,000 $90,000 Vehicle 4911 Tandem Dump Truck Replacement $81,000 $266,000 Deere X738 w/ Snowblower & Dual Purpose Trailer $38,000 $38,000 Cla-Val Link2Valves Maintenance Program Training for Distribution and Water Plant Maintenance Crews $37,800 $37,800 Water Main Relocation Manhole Project $50,000 $50,000 Water Main Upgrades $30,000 $30,000 Maintain Public Water Mains $20,000 $20,000 Water Distribution Master Plan $10,000 $10,000 FY 26 CAPITAL IMPROVEMENT PROJECTS Water Department Page 885 of 1184 WATER TOWER DECONSTRUCTION EAGLE POINT PARK •Deconstruction to be completed by 12/31/2025 •Estimated cost $97,500 •No additional funding requested for FY2026 •Funds to be pulled from CIP 4281000011 Crossroads Property Phase 1 & 2 Page 886 of 1184 PERFORMANCE MEASURES WATER DEPARTMENT Goals that are on track: # of Regulatory Compliance Violations, Target Zero (0) # of Completed Annual Training hours to support CEUs, reported in staff hours % of Projects Completed within the Program Budget Goals Improving: # of Breaks per 100 miles of Pipe O&M Costs for Water Distribution per 100 miles of pipe Operation of 25% of Distribution System Valves Annually Page 887 of 1184 THANK YOU www.cityofdubuque.org/water Page 888 of 1184