Loading...
Water Fiscal Year 2027 Budget Presentation Copyrighted April 7, 2026 City of Dubuque BUDGET PRESENTATIONS # 3. City Council ITEM TITLE: Water Fiscal Year 2027 Budget Presentation SUMMARY: SUGGUESTED DISPOSITION: ATTACHMENTS: 1. 27 Policy Book Volume I - Water Updated 4-15-26 2. Presentation-Uploaded 4.7.26 Page 1074 of 1264 Water Department 139 Page 1075 of 1264 This page intentionally left blank. 140 Page 1076 of 1264 WATER DEPARTMENT % Change From FY FY 2025 FY 2026 FY 2027 2026 Budget Highlights Actual Budget Requested Budget Expenses Employee Expense $ 2,783,103 $ 2,834,815 $ 2,999,568 5.8 % Supplies and Services $ 2,833,085 $ 3,623,677 $ 3,246,445 (10.4)% Machinery and Equipment $ 414,513 $ 476,450 $ 290,926 (38.9)% Administrative Overhead Recharges $ 2,005,611 $ 2,215,201 $ 2,325,789 5.0 % Engineering Water Maintenance Charges $ 73,909 $ 65,658 $ 59,157 (9.9)% Payment in Lieu of Taxes $ 142,884 $ 142,884 $ 142,884 — % Payment to Construction Fund $ 6,953,161 $ 1,500,000 $ 2,445,586 63.0 % Debt Service $ 2,495,306 $ 3,321,456 $ 2,512,976 (24.3)% Total Expenses $17,701,572 $14,180,141 $14,023,331 (1.1)% Resources Operating Revenue $13,235,604 $13,944,172 $13,985,608 0.3 % General Fund - Rate Subsidy $ 32,192 $ 36,000 $ 37,723 4.8 % Total Resources $13,267,796 $13,980,172 $14,023,331 0.3 % Net Operating Surplus (Deficit) $ (4,433,776) $ (199,969) $ — 199,969 Personnel -Authorized FTE 27.07 27.07 27.07 Water User Fee Rate Increase 12.0 % 8.0 % 3.0 % Revenue 1% Rate Increase Generates $ 118,242 Improvement Package SummarX 1 of 3 This improvement package request covers the printing and mailing of the annual EPA-required Public Notice to customers with service lines identified as Unknown, Lead, or Galvanized Requiring Replacement. Under the EPA's Lead and Copper Rule Revisions (LCRR) and Lead and Copper Rule Improvements (LCRI), community and non-transient, non-community water systems must notify affected customers within 30 days after October 16, 2024, and annually thereafter until all service lines are fully classified and replaced as needed. This required expense was not previously budgeted and has been covered using other operating accounts to meet the initial compliance deadlines. Funding this improvement package ensures ongoing compliance while supporting the City Council's Healthy and Safe Community goal. Related Cost: $4,000 Water User Fees Recurring Recommend -Yes Total Cost: $4,000 Sanitary User Fee Impact 0.040 % Activity: Distribution System 141 Page 1077 of 1264 2of3 This improvement package request provides cold-weather and high-visibility safety gear for staff who must perform outdoor tasks or respond to incidents in inclement weather or high-traffic areas, including water main breaks, construction site visits, and other job-related field activities. Ensuring staff safety while working outside the office directly supports the City of Dubuque's Healthy and Safe Community goal. Related Cost: $850 Water User Fees Recurring Recommend -Yes Total Cost: $850 Sanitary User Fee Impact 0.008 % Activity: Distribution System 3of3 This improvement package request includes the addition of a next-generation GPS antenna, and a tablet to support reliable and accurate mapping of the Water Department's underground infrastructure. The upgraded GPS equipment will significantly improve the DepartmenYs operational efficiency by allowing field staff to collect high-accuracy location data more quickly and with greater precision. This enhanced capability supports better asset management and ensures infrastructure data remains up to date and easily accessible across departments. By improving the accuracy and accessibility of underground infrastructure information, this investment directly benefits the community through more efficient service delivery, reduced disruptions during utility work, and better planning for future system improvements. This project advances the City Council goal of maintaining a Financially Responsible, High-Performance City Organization: Sustainable and Effective Service Delivery by increasing the Department's capacity for on-site data collection and improving overall service reliability and responsiveness. Related Cost: $9,626 Water User Fees Non-recurring Recommend -Yes Total Cost: $9,626 Sanitary User Fee Impact 0.095 % Activity: Distribution System Significant Line Items Employee Expense 1. FY 2027 employee expense reflects a 3% wage package increase for non-bargaining employees and a 3.25% wage package increase for operating engineers as per the collective bargaining agreement between the City of Dubuque and the International Union of Operating Engineers which is in place from July 1, 2024 through June 30, 2029. 2. The lowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2026. The employee contribution of 6.29% is unchanged from FY 2026. 3. The City portion of health insurance expense per contract is increased from $1,119 in FY 2026 to $1,175 in FY 2027 and there is an annual cost decrease of $(15,460.00) or (4)%. The increase per contract is due to the city contribution increasing 5.00% because of increasing health costs and the decrease in annual cost is due to the decreased number of contracts. 4. Overtime is unchanged from $94,040 in FY 2026 to $94,040 in FY 2027. FY 2025 actual was $116,688. 5. Five-Year Retiree Sick leave payout is decreased from $14,960 in FY 2026 to $10,889 in FY 2027. 142 Page 1078 of 1264 6. 50% Sick Leave Payout increased from $3,066 in FY 2026 to $3,459 in FY 2027 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 decreased from $1,005,598 in FY 2026 to $826,693 in FY 2027 based on FY 2025 actual of $826,692. 8. Chemicals decreased from $629,500 in FY 2026 to $604,530 in FY 2027 based on estimated annual usage and recent bid prices. Actual pricing is variable and fluctuates annually based on market conditions and contract solicitations. FY 2025 actual expense was $639,785. FY 2026 FY 2027 Percent Chemical Budget Requested Change Fluoride $ 10,500 $ 10,350 (1.4)% Phosphate $ 83,000 $ 100,000 20.5 % Chlorine $ 75,000 $ 65,280 (13.0)% Carbon Dioxide $ 31,000 $ 35,000 12.9 % Polymer $ 7,000 $ 7,000 - % Lime Softening $ 423,000 $ 386,900 (8.5)% Total $629,500 $604,530 (4.0)% 9. Hauling Contract decreased from $363,000 in FY 2026 to $285,000 in FY 2027 based on FY 2026 actual price per ton of$14.21. The FY 2025 actual price per ton was $12.79. The amount of hauled tons of lime sludge is highly variable from year to year and is estimated to be approximately 20,000 tons in FY 2027 based on a 3-year average. FY 2025 actual expense was $237,783. 10. Other Professional Services decreased from $146,100 in FY 2026 to $143,309 in FY 2027. This line item includes consulting services for staff training ($27,309), environmental testing fees ($60,000), fire hydrant painting ($10,000), service line assistance ($5,000), water storage tank inspections ($15,000) and water leak surveys ($26,000). 11. Technology Services decreased from $110,547 in FY 2026 to $100,722 in FY 2027. The decrease is due to a decrease in Tablet Internet Service fees and Water Plant Operations software fees. Software FY 2027 Water Meters Tokay Software 14,400 Tablet Internet Service 1,981 Verizon 1,932 Neptune360 (50%) 54,000 Water Plant Operations Tablet Internet Service 990 TechConnect Software 17,950 Water Distribution IRTH Solutions (Charge from Engineering Department) 3,280 AutoCAD 787 143 Page 1079 of 1264 Software FY 2027 Tablet Internet Service 5,402 Total Software $100,722 12. Valves/Fittings increased from $214,447 in FY 2026 to $250,000 in FY 2027 based on FY 2025 actual of $219,108 and anticipated price increases. 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 $171,046 in FY 2026 to $176,765 in FY 2027 based on information received from lowa Communities Assurance Pool (ICAP). FY 2025 was $141,782. 14. Street Materials decreased from $350,000 in FY 2026 to $250,000 in FY 2027. FY 2025 actual was $58,805. This is for stone, gravel, cement, and rock for water main and street repairs that Public Works department charges to the Water department. This decrease from FY 2026 to FY 2027 is due to aligning the street materials budget to a more accurate number. 15. Other Capital Outlay decreased from $226,250 in FY 2026 to $136,250 in FY 2027. This line includes the valve turning program and meter testing. This decrease is due to reclassifying street repairs to a more appropriate account. Machinery & Equipment 16. Equipment replacement items at the maintenance level include ($290,926): Water Machinery and Equipment Water Administration Laserfiche Scanning $ 300 Smart Phone (5) $ 2,000 Meters Smart Phone (5) $ 2,000 Water Meters $ 99,750 Plant Operation & Maintenance Smart Phone (5) $ 2,000 Water Distribution System Electric Pump (1) $ 1,500 Cut Off Saw $ 1,800 Tapping Machine $ 6,500 R2 GPS $ 8,000 Smartphones (8) $ 3,200 Annual Maintenance Projects Generator Maintenance Program $ 18,000 Valve Replacement $ 26,250 144 Page 1080 of 1264 Water Meter Testing $ 10,000 Valve Turning Program $ 100,000 Recommended Improvement Packages GPS Antenna $ 9,626 Total Equipment $ 290,926 Debt Service 17. FY 2027 annual debt service is as follows ($2,512,976): Final Call Amount Debt Series Source Purpose Payment Date $ 61,400 SRF 2007A Water Fees Clear Wells 2028 433,300 Revenue 2021 C Water Fees Water Improvements 2030 2028 205,840 SRF Series 2009 Water Fees Meter Change-Out 2031 110,159 G.O. 2018A Water Fees Water Improvements 2031 2026 695,274 G.O. 2021A Water Fees Water Improvements 2032 2028 136,562 G.O. 2021A Water Fees Water Improvements 2033 2026 45,300 G.O. 2016C Water Fees Water Improvements 2033 2024 554,301 SRF 2017 Water Fees CIWA Purchase/Imp 2036 270,840 SRF 2019 Water Fees Roosevelt Water Tower 2038 $2,512,976 Total Water Annual Debt Service Revenue 18. Water User Fees increased from $12,765,755 in FY 2026 to $12,970,943 in FY 2027 based on FY 2025 actual of$11,824,210 plus increased water rates of 8% in FY 2026 and 3.0% in FY 2027. 19. Flat Rates are unchanged from $20,713 in FY 2026 to $20,713 in FY 2027. FY 2025 actual was $56,897. This charge is for customers purchasing bulk water. Rates are set by City ordinance. 20. Fire Protection Rates increased from $226,105 in FY 2026 to $280,693 in FY 2027 based on FY 2025 actual of$252,331 plus anticipated rate increases. This fee is the demand charge for fire sprinkler head connection. The rates are set by City ordinance. 21. Tap revenue is unchanged from $36,555 in FY 2026 to $36,555 in FY 2027 based on historical averages and anticipated projects. FY 2025 actual was $33,372. 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 is unchanged from $41,135 in FY 2026 to $41,135 in FY 2027 based on historical averages and anticipated project needs. FY 2025 actual was $63,406. 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 unchanged from $52,678 in FY 2026 to $52,678 in FY 2027 based on historical averages and anticipated project needs. FY 2025 actual was $46,281. 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. 145 Page 1081 of 1264 24. Backflow Prevention Administrative Fees increased from $77,156 in FY 2026 to $77,331 in FY 2027 based on a 3-year average. FY 2025 actual was $77,507. This is the $25 annual fee charged to all customers with a backflow device. 25. Penalties for late payments decreased from $65,360 in FY 2026 to $65,257 in FY 2027. FY 2025 actual was $141,292. 26. Tower Monthly Rental increased from $160,800 in FY 2026 to $168,747 in FY 2027 based on water lease contract amounts. FY 2025 actual was $165,574. 146 Page 1082 of 1264 WATER DEPARTMENT The Water Department ensures our community has high-quality, safe, reliable and affordable drinking water. Water Department � Director I (1.0 FTE) � Administrative Support Professional (1.0 FTE) Di�bution Supervisor Water Project GIS Specialist Operations Supervisor Supervisor (1.0 FTE) (1.0 FTE) (1.0 FTE) (1.0 FTE) Lead Distribution Lead Distribution GIS Seasonal lntern �ater Plant Operators Maintenance Worker Maintenance Worker �1.0 FTE) (1.0 FTE) (0.5 FTE) (6.0 FTE) Water Distribution Water Distribution Industrial Electrical Maintenance Workers Maintenance Workers Technician (7.0 FTE) (3.5 FTE) (1.0 FTE) MSC Custodian Equipment Mechanic (0.07 FTE) (1.0 FTE) 147 Page 1083 of 1264 SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES PLANNING The Water Department is engaged in PEOPLE conscientious, strategic planning which allows for maintaining compliance with the Employees of the Water state and federal regulatory agencies in Department are provided training order to provide the highest quality, safe to ensure the maintenance of the and cost effective drinking water possible. appropriate licenses required by the lowa Department of Natural _ _ �- ,� - ""� J Resources. Other job-related � j - _� � , ��- ..,., educational training is provided � ,�,� ��.; ,,� � - ,� � ' —.��- .:._�- — � to broaden employee skills and �� `'' ���":::� � �r'-. �.--�L _�-_ ��'.. . increase productivity. � .:��,_ � ►` .�_ _ �, �_ ./ � � � � - � PARTNERSHIPS The Water Department is involved in Community Activities/Partnerships/ Outreach programs such as Water Conservation Educational Program and the Smarter City Initiative. The Water Department provides tours of its Eagle Point Treatment Plant to local schools and organizations. 148 Page 1084 of 1264 WATER DEPARTMENT FY 2025 FY 2026 FY 2027 Full-Time Equivalent 27.07 27.07 27.07 Resources Support $15,000,000 $10,000,000 $5,000,000 $0 Operating Revenue � FY 2025 Actual FY 2026 Budget FY 2027 Recomm'd The Water Department is supported by 27.07 full-time equivalent employees, which accounts for 21.39% of the department expense as seen below. Overall, the department's expenses are expected to decrease by (1.13)% in FY 2027 compared to FY 2026. Expenditures by Category by Fiscal Year $7,500,000 $5,000,000 $2,500,000 � $0 ��� ,��5 �.�'� ��a �� ��a \°e o,�5 �-�Q� a��� o'J�Q� J�r Q��. o\o t� 'p���� Gr�c O '� ���� 5�� � ��� ���� �� e���� �.�� J�Q��� Pa G�� ���� 5 � � FY 2025 Actual FY 2026 Budget FY 2027 Recomm'd 149 Page 1085 of 1264 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 2025 FY 2026 FY 2027 Actual Budget Recomm'd Expenditures $12,521,609 $8,012,057 $8,355,537 Resources $— $— $— Water Administration Position Summary FY 2027 Water Department Director 1.00 Water Distribution Supervisor 1.00 Water Operations Supervisor 1.00 Water Project Supervisor 1.00 Administrative Support Professional 1.00 GIS Specialist 1.00 GIS Intern 0.50 Total FT Equivalent Employees 6.50 150 Page 1086 of 1264 Performance Measures City Council Goal: Financially Responsible, High Performance City Organization: Sustainable and Effective Service Delive 1 Activity Objective: Maintain a financially-viable water utility. Performance Measure (KPI) Target FY 2024 FY 2025 FY 2026 Performance Actual Actual Estimated Indicator # of staff hours completing annual training to support CEUs/professional 20 35 30 35 Goal Met development in emergency response Reduction of Water Quality Issues per �20 16 7 15 Goal Met 100 miles of Pipe °/o of lost/unaccounted for water <18% 17.2% 19.2% 19.5% Goal Not Met % of projects completed within the 100% 80% 100% 100% Goal Met program budget Operating cost coverage for water Goalln (Total Operational Revenue/Total 1.0 1.0 1.1 1.1 progress Operating Cost) 151 Page 1087 of 1264 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 lowa Hygienic Laboratory. __ All of these analytical measures ensure the water reaching homes � is of drinking-water quality. Plant Operations and Maintenance Funding Summary FY 2025 FY 2026 FY 2027 Actual Budget Requested Expenditures $3,094,640 $3,320,867 $3,075,207 Resources $71 $— $— Plant Operations and Maintenance Position Summary FY 2027 Industrial Electrical Technician 1.00 Equipment Mechanic 1.00 Total FT Equivalent 2.00 Employees 152 Page 1088 of 1264 Performance Measures City Council Goal: Sustainable Environment: Preserving and Enhancing Natural Resources � Activity Objective: Provide water treatment and distribute high-quality, clean drinking water that meets or exceeds drinking water regulations. Performance Measure (KPI) Target FY 2024 FY 2025 FY 2026 Performance Actual Actual Estimated Indicator # of Water Regulatory Compliance as 0 0 0 0 Goal Met No Violations Water Plant Process Efficiency Measured as Water Treated vs 1.1 .97 .97 1.0 Goal in Produced (MGD Treated/MGD Progress Produced) Cost Effectiveness of the Treatment �or- 1.0 1.0 1.19 1.0 Goal Met Process (O&M Cost/MG, thousands) The 2025 Water Quality Report can be downloaded at: https://www.cityofdubuque.org/waterquality 153 Page 1089 of 1264 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. FY 2025 FY 2026 FY 2027 Actual Budget Recomm'd Expenditures $1,291,240 $1,328,923 $1,389,656 Resources $13,074,101 $13,850,941 $13,905,227 FY 2027 Lead Distribution Maintenance Worker 1.00 Water Distribution Maintenance Worker 7.00 Custodian I 0.07 Total FT Equivalent Employees 8.07 Performance Measures City Council Goal: Financially Responsible, High PerFormance City Organization: Sustainable and Effective Service Delivery 1 Activity Objective: Ensure the integrity of the distribution system piping system. Performance Measure (KPI) Target FY 2024 FY 2025 FY 2026 Performance Actual Actual Estimated Indicator # of breaks per 100 miles of pipe <15 17 22 20 Goal Not Met Operation of 10% of system valves 775 775 376 775 Goal in annually Progress Hydrant effectiveness (out of service �1% <1% 0% 0% Goal Met rate) <1% or 25FH O&M costs for water per 100 miles of �440 461 449 428 Goal Met pipe (thousands per 100 miles) 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 334 miles of public water mains ranging in diameterfrom 4" up to 30", 8,118 control valves, and 2,661 fire hydrants. 154 Page 1090 of 1264 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 2025 FY 2026 FY 2027 Actual Budget Recomm'd Expenditures $360,923 $575,386 $583,774 Resources $188,945 $118,538 $118,104 Water Meters Position Summary FY 2027 Lead Distribution Maintenance Worker 1.00 Water Distribution Maintenance Worker 3.50 Total Full-Time Equivalent Employees 4.50 PerFormance Measures City Council Goal: Sustainable Environment: Preserving and Enhancing Natural Resources � Activity Objective: Minimize the possibility of contamination in the distribution through the installation of backflow prevention devices. Performance Measure (KPI) Target FY 2024 FY 2025 FY 2026 Performance Actual Actual Estimated Indicator High and low hazard containment Goal in services, by definition, to participate in 100% 99% 99% 99% progress the backflow prevention program City Council Goal: Financially Responsible, High Performance City Organization: Sustainable and Effective Service Delivery � Activity Objective: Respond to customer inquiries in a timely manner to maintain consumer confidence in the water utility. Respond to technical Meter 100% 100% 100% 100% Goal Met Department service issues. Enhanced meter reading accuracy, larger users: O&M on all large meters 12/yr 13 13 12 Goal Met (>3 ) per AWWA standards (Ig meter/ yr) 155 Page 1091 of 1264 Recommended Operating Revenue Budget - Department Total 42 -WATER FY26 FY27 FY24 Actual FY25 Actual Adopted Recomm'd Fund/Account/Account Title Revenue Revenue Budget Budget 600 -Water Operating 4A - Charges for Services 41380 - Water/Sewer Permit (156,359) (165,574) (160,800) (168,747) 45090 - Meter Rates (10,602,787) (11,824,210) (12,765,755) (12,970,943) 45095 - Fire Protection Rates (226,105) (252,331) (226,105) (280,693) 45100 - Flat Rates (20,713) (56,897) (20,713) (20,713) 45105 - Unapplied Credits 6,079 - - - 45125 - Meter Sales - Remotes (7,134) (16,923) (7,134) (7,134) 45126 - Meters - Sales (26,818) (78,868) (26,818) (26,818) 45127 - UFR Device - Sales (1,334) (884) (1,334) (828) 45128 - Meter Repair (5,993) (14,764) (5,993) (5,993) 45129 - Stop Box Parts (15) - - - 45234 - UB-Water Repair Grt Temp Hold - 200 - - 45300 - Forfeitures/Penalties (65,375) (141,292) (65,360) (65,257) 45325 - Meter Tampering Fee - (437) - - 45350 - Shut Off Penalties (12,017) (18,784) (12,017) (12,017) 45400 - Connect Fees (77,156) (77,507) (77,156) (77,331) 45410 - Connect Fee Large Svc (13,393) (63,406) (41,135) (41,135) 45415 - Connect Fee Front Footage (17,192) (46,281) (52,678) (52,678) 45420 - Taps (5,957) (33,372) (36,555) (36,555) 45500 - Miscellaneous Chg for Svcs (6,249) (10,965) (6,249) (6,249) 47100 - Reimbursements (10,693) (5,812) (10,693) - 47150 - Refunds (2,154) (338) - - 47200 - Insurance Settlements (14,697) 5,997 - - 47450 - Sale of Salvage (632) - (632) - 4A - Charges for Services Total (11,266,694) (12,802,448) (13,517,127) (13,773,091) 4K - Unrest Invest Earn 43000 - Interest (358,736) (433,213) (427,045) (212,517) 4K - Unrest Invest Earn Total (358,736) (433,213) (427,045) (212,517) 4N - Transfers 49100 - Transfer In General Fund (30,257) (32,192) (36,000) (37,723) 4N -Transfers Total (30,257) (32,192) (36,000) (37,723) 40 - Eliminated for GW 47115 - Sales Tax Collection (37,955) 54 - - 40 - Eliminated for GW Total (37,955) 54 - - WATER -Total (11,693,642) (13,267,799) (13,980,172) (14,023,331) 156 Page 1092 of 1264 Recommended Operating Expenditure Budget - Department Total 42 -WATER FY 2024 FY 2025 FY 2026 FY 2027 Fund/Account/Account Title Actual Actual Budget Recomm'd 6A - Salaries &Wages 110 - Road Use Tax 60100 - Salaries-Regular Full Time 1,547 - - - 60400 - Overtime 2,683 - - - 60410 - Overtime - Holiday 291 - - - 600 -Water Operating 60100 - Salaries-Regular Full Time 1,606,095 1,828,514 1,885,129 2,039,028 60200 - Salaries - Regular Part Time 11,663 15,161 29,389 31,095 60300 - Hourly Wages -Temp/Seasonal 7,613 - 15,837 18,886 60400 - Overtime 126,792 116,688 94,040 94,040 60410 - Overtime - Holiday 27,734 29,683 17,000 17,000 60630 - Special Pay Sick Lv Payout Ret 12,983 12,383 14,960 10,889 60635 - Special Pay Sick Lv Payout 50% 2,977 3,358 3,066 3,459 60640 - Special Pay - Vacation Payout 26,942 4,708 - - 60710 - Special Pay - Parental Leave 7,578 13,113 - - 60720 - Spec Pay - Meals No Overnight 12 - - - 60730 - Spec Pay - Safety Equipment 2,323 5,981 5,500 16,957 60740 - Spec Pay - Meal Allowance 246 53 - - 60780 - Spec Pay -Tank Climb Pay - 15 1,200 - 6A - Salaries & Wages Total 1,837,479 2,029,657 2,066,121 2,231,354 6B - Employee Benefits 110 - Road Use Tax 61100 - FICA- City Contribution 332 - - - 61300 - IPERS - City Contribution 427 - - - 61510 - Health Insurance 770 - - - 61540 - Life Insurance 5 - - - 600 -Water Operating 61100 - FICA- City Contribution 133,237 146,596 157,547 169,407 61300 - IPERS - City Contribution 168,915 188,547 192,708 208,010 61510 - Health Insurance 349,751 376,116 375,844 360,384 61540 - Life Insurance 1,115 1,173 1,334 1,199 61600 - Workers' Compensation 41,899 39,895 40,857 28,097 61992 - Physicals 974 1,117 404 1,117 6B - Employee Benefits Total 697,425 753,444 768,694 768,214 6C - Staff Development 600 -Water Operating 62100 -Association Dues 2,247 2,933 3,500 3,850 62200 - Subscriptions 21 - 22 - 62325 - Mileage 3,793 3,126 5,200 4,450 62400 - Meetings & Conferences 5,648 3,474 7,340 6,340 62500 - Education Reimbursement 13,421 21,253 18,750 22,000 157 Page 1093 of 1264 Recommended Operating Expenditure Budget - Department Total 42 -WATER FY 2024 FY 2025 FY 2026 FY 2027 Fund/Account/Account Title Actual Actual Budget Recomm'd 6C - Staff Development Total 25,130 30,786 34,812 36,640 6D - Repair/Maint/Util 600 -Water Operating 63100 - Building Maintenance 74,761 74,116 78,131 74,115 63311 - Vehicle Ops - Diesel - 3,941 - 3,007 63312 -Vehicle Ops - Gasoline 31,215 31,607 31,215 21,044 63320 -Vehicle Repair- Internal 52,165 44,912 32,403 51,874 63321 -Vehicle Repair- Outsourced 29,878 21,735 30,476 22,387 63400 - Equipment Maint/Repair 58,964 79,443 81,741 83,532 63425 - Meter Maintenance (261) 198 2,000 198 63430 - Instrument Maintenance - 18,486 30,000 30,000 63710 - Electricity 836,634 826,692 1,005,598 826,693 63711 - Natural Gas 44,059 44,839 49,214 44,839 63730 -Telecommunications 19,879 23,966 22,475 28,259 63742 - Stormwater 1,647 1,745 1,730 2,007 63790 - Other Utility Expense 2,985 3,988 4,000 3,988 6D - Repair/Maint/Util Total 1,151,926 1,175,668 1,368,983 1,191,943 6E - Contractual Svcs 600 -Water Operating 64010 -Accounting &Auditing 6,891 6,000 8,250 - 64020 -Advertising 2,126 1,069 2,127 1,000 64040 - Collections 2,213 - 2,213 - 64045 - Bad Debt Expense 864 35,054 - - 64062 - Refunds - 605 - 605 64080 - Insurance - Property 119,688 141,782 171,046 176,765 64081 - Insurance - Liability 32,877 36,636 42,118 39,104 64135 - Grants 2,652 3,359 10,000 - 64140 - Printing 1,308 1,811 4,192 3,196 64145 - Copying 643 1,474 548 1,474 64150 - Rental - Equipment 2,483 2,245 2,483 4,000 64160 - Rental - Land/Bldgs/Parking 720 720 720 720 64175 - Landfill Fees - 412 1,500 412 64180 - Sales Tax Expense 94,968 - - - 64185 - License/Permit/Fees 6,710 6,786 6,710 6,786 64190 -Technology Services 60,964 64,842 110,547 100,722 64191 - IT Recharges 21,743 22,658 23,824 24,162 64820 - One Call 7,544 10,153 10,500 10,153 64825 - Fire Suppression 371 86 371 86 64865 - Elevator Service 2,169 2,312 2,410 2,313 64870 - HVAC Services - - 3,744 3,744 64900 - Other Professional Service 83,780 52,282 146,100 143,309 158 Page 1094 of 1264 Recommended Operating Expenditure Budget - Department Total 42 -WATER FY 2024 FY 2025 FY 2026 FY 2027 Fund/Account/Account Title Actual Actual Budget Recomm'd 64975 - Equip Maint Cont 2,194 1,758 2,194 2,000 64980 -Technology Equip Maint Cont 900 900 900 900 64985 - Hauling Contract 211,201 237,783 363,000 285,000 64990 - Other Contractual Service 42 271 6,000 - 6E - Contractual Svcs Total 665,051 630,998 921,497 806,451 6F - Commodities 600 -Water Operating 65010 - Chemicals 547,331 639,785 629,500 604,530 65040 - Small Tools & Equipment 9,541 20,511 20,200 22,100 65045 -Technology Equipment 547 - 300 10,600 65050 - Other Equipment 11,729 122,507 31,900 26,326 65060 - Office Supplies 3,129 4,293 3,716 4,657 65080 - Postage/Shipping 3,064 3,510 3,296 8,668 65100 - Safety Supplies 5,193 4,878 5,193 5,005 65925 - Uniform Purchase 21,921 23,539 27,000 27,850 65950 -Valves/Fittings 204,235 219,108 214,447 250,000 65960 - Repair Parts 13,487 - 1,482 5,000 65965 - Janitorial 4,559 4,503 4,559 5,921 65970 - Lab Supplies 24,747 13,811 24,747 13,811 65975 - Plumbing Supplies 1,376 1,071 2,376 1,000 65980 - Construction Supplies 567 1,468 3,500 4,500 65981 - Street Materials 5,036 58,805 350,000 250,000 65990 - Other Supplies 8,369 348 8,369 8,369 6F - Commodities Total 864,831 1,118,137 1,330,585 1,248,337 6G - Capital Outlay 600 -Water Operating 67270 - Other Capital Equipment 23,278 16,531 18,000 18,000 67810 - Water- Large Meters 81,795 92,334 200,000 99,750 67815 - Water- Hydrants 76,552 - - - 67990 - Other Capital Outlay 244,673 183,140 226,250 136,250 6G - Capital Outlay Total 426,298 292,005 444,250 254,000 6H - Debt Service 600 -Water Operating 68010 - Principal Payment 1,995,897 2,038,183 2,604,651 2,600,608 68020 - Interest Payments 501,052 457,123 716,805 713,720 68980 - Financial Consultant 500 - - - 6H - Debt Service Total 2,497,449 2,495,306 3,321,456 3,314,328 61 -Transfers 600 -Water Operating 69100 -Transfers Out To General Fund 1,512,215 2,148,495 2,358,085 2,468,673 69601 -Transfers Out to Water Cap 1,000,000 6,953,161 1,500,000 1,644,234 159 Page 1095 of 1264 Recommended Operating Expenditure Budget - Department Total 42 -WATER FY 2024 FY 2025 FY 2026 FY 2027 Fund/Account/Account Title Actual Actual Budget Recomm'd 61 -Transfers Total 2,512,215 9,101,656 3,858,085 4,112,907 WATER -Total 10,677,804 17,627,657 14,114,483 13,964,174 160 Page 1096 of 1264 Recommended Expenditure Budget Report by Activity & Funding Source 42 -WATER FY 2025 FY 2026 FY 2027 Fund/Activity Actual Budget Recomm'd 0000 - No Sub-Activity 600 -Water Operating 61 - Transfers 5,148,495 3,858,085 4,112,907 0000 - No Sub-Activity Total 5,148,495 3,858,085 4,112,907 4201 - Administration 600 -Water Operating 6A- Salaries &Wages 628,750 566,430 666,120 6B - Employee Benefits 187,101 177,549 198,518 6C - Staff Development 13,471 17,000 15,100 6D - Repair/Maint/Util 2,931 2,400 2,698 6E - Contractual Svcs 91,725 67,478 42,896 6F - Commodities 670 1,659 2,970 6H - Debt Service 2,495,306 3,321,456 3,314,328 61 - Transfers 3,953,161 - - 4201 - Administration Total 7,373,115 4,153,972 4,242,630 4202 - Meters 600 -Water Operating 6A- Salaries &Wages 165,292 312,891 328,660 6B - Employee Benefits 100,892 128,883 118,390 6C - Staff Development 3,015 5,550 7,100 6D - Repair/Maint/Util 23,922 34,425 23,663 6E - Contractual Svcs 60,451 79,137 80,461 6F - Commodities 7,173 14,500 25,500 6G - Capital Outlay 178 - - 4202 - Meters Total 360,923 575,386 583,774 4203 - Plant Operations and Maint 600 -Water Operating 6A- Salaries &Wages 742,898 614,198 625,746 6B - Employee Benefits 249,587 227,677 230,396 6C - Staff Development 5,256 3,500 3,500 6D - Repair/Maint/Util 1,000,396 1,168,880 1,012,345 6E - Contractual Svcs 413,451 624,557 553,922 6F - Commodities 683,052 682,055 649,298 4203 - Plant Operations and Maint Total 3,094,640 3,320,867 3,075,207 4204 - Distribution System 600 -Water Operating 6A- Salaries &Wages 492,718 572,602 610,828 6B - Employee Benefits 215,865 234,585 220,910 6C - Staff Development 9,045 8,762 10,940 6D - Repair/Maint/Util 148,419 163,278 153,237 161 Page 1097 of 1264 Recommended Expenditure Budget Report by Activity & Funding Source 42 -WATER FY 2025 FY 2026 FY 2027 Fund/Activity Actual Budget Recomm'd 6E - Contractual Svcs 56,160 67,325 73,172 6F - Commodities 368,438 282,371 320,569 6G - Capital Outlay 595 - - 4204 - Distribution System Total 1,291,240 1,328,923 1,389,656 4220 - Storage Tank Inspection 600 -Water Operating 6E - Contractual Svcs - 33,000 41,000 4220 - Storage Tank Inspection Total - 33,000 41,000 4224 - Fire Hydrant Painting 600 -Water Operating 6E - Contractual Svcs 853 5,000 10,000 4224 - Fire Hydrant Painting Total 853 5,000 10,000 4226 - Service Line Assistance 600 -Water Operating 6E - Contractual Svcs - 35,000 5,000 4226 - Service Line Assistance Total - 35,000 5,000 4227 - Valve Replacement 600 -Water Operating 6G - Capital Outlay 10,026 100,000 100,000 4227 - Valve Replacement Total 10,026 100,000 100,000 4229 - Main Replacements 600 -Water Operating 6F - Commodities 58,805 350,000 250,000 6G - Capital Outlay 151,095 75,000 - 4229 - Main Replacements Total 209,900 425,000 250,000 4230 - Meter Exchange 600 -Water Operating 6G - Capital Outlay 92,156 200,000 99,750 4230 - Meter Exchange Total 92,156 200,000 99,750 4231 - Leak Repair Grant 600 -Water Operating 6E - Contractual Svcs 1,859 5,000 - 4231 - Leak Repair Grant Total 1,859 5,000 - 4232 - Valve Box Maintenance 600 -Water Operating 6G - Capital Outlay 16,581 26,250 26,250 4232 - Valve Box Maintenance Total 16,581 26,250 26,250 4234 - Generator Maintenance 600 -Water Operating 6G - Capital Outlay 16,531 18,000 18,000 4234 - Generator Maintenance Total 16,531 18,000 18,000 162 Page 1098 of 1264 Recommended Expenditure Budget Report by Activity & Funding Source 42 -WATER FY 2025 FY 2026 FY 2027 Fund/Activity Actual Budget Recomm'd 4235 - County Water Assistance 600 -Water Operating 6E - Contractual Svcs 1,500 5,000 — 4235 - County Water Assistance Total 1,500 5,000 — 4236 - Water Meter Testing 600 -Water Operating 6G - Capital Outlay 4,842 25,000 10,000 4236 - Water Meter Testing Total 4,842 25,000 10,000 4237 - Water Leak Survey 600 -Water Operating 6E - Contractual Svcs 5,000 — — 4237 - Water Leak Survey Total 5,000 — — WATER TOTAL 17,627,661 14,114,483 13,964,174 163 Page 1099 of 1264 CITY OF DUBUQUE , IOWA DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 42 WATER DEPARTMENT FY 2025 FY 2026 FY 2027 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61010 Full Time Employee Expense 600 5010 NB-07 ADMIN SUPPORT PROF 1.00 $ 57,763 1.00 $ 60,159 1.00 $ 66,481 600 7830 NB-06 CUSTODIAN 0.07 $ 3,583 0.07 $ 3,404 0.07 $ 3,484 600 8875 0E-14 EQUIPMENT MECHANIC 1.00 $ 70,310 1.00 $ 68,869 1.00 $ 75,042 600 7890 0E-10 EQUIPMENT OPERATOR II 1.00 $ 66,341 1.00 $ 59,214 - $ - 600 7980 NB-12 GIS SPECIALIST 1.00 $ 75,474 1.00 $ 78,369 1.00 $ 86,827 600 7990 0E-16 INDUSTRIAL ELECTRICALTECH 1.00 $ 85,208 1.00 $ 85,532 1.00 $ 89,160 600 7887 0E-09 LEAD WATER DISTR MAINT WORKER 2.00 $ 143,981 2.00 $ 162,659 2.00 $ 174,064 600 8000 0E-11 PLANT OPERATOR - $ - - $ - 6.00 $ 411,549 600 8005 0E-11 PLANT OPERATOR GRADE I 2.00 $ 122,081 2.00 $ 123,871 - $ - 600 8015 0E-12 PLANT OPERATOR GRADE II 1.00 $ 67,564 1.00 $ 65,912 - $ - 600 8025 0E-16 PLANT OPERATOR GRADE III 1.00 $ 67,131 1.00 $ 63,179 - $ - 600 8035 0E-16 PLANT OPERATOR GRADE IV 2.00 $ 149,894 2.00 $ 153,776 - $ - 600 3885 NB-18 WATER DEPARTMENT DIRECTOR 1.00 $ 123,030 1.00 $ 134,136 1.00 $ 148,202 600 8175 0E-09 WATER DISTR MAINT WORKER 8.00 $ 498,446 9.00 $ 563,134 10.00 $ 653,902 600 3975 NB-14 WATER DISTRIBUTION SUPERVISOR 1.00 $ 82,390 1.00 $ 95,637 1.00 $ 109,986 600 2120 NB-15 PROJECT SUPERVISOR 1.00 $ 87,763 1.00 $ 66,607 1.00 $ 112,502 600 8185 0E-14 WATER METER FOREMAN 1.00 $ 79,655 - $ - - $ - 600 3965 NB-14 WATER OPERATIONS SUPERVISOR 1.00 $ 92,084 1.00 $ 100,671 1.00 $ 107,829 TOTAL FULL TIME EMPLOYEES 26.07 $ 1,872,698 26.07 $ 1,885,129 26.07 $ 2,039,028 61020 Part-Time Employee Expense 600 8,175 0E-09 WATER DISTR MAINT WORKER 0.50 $ 28,490 0.50 $ 29,389 0.50 $ 31,095 TOTAL PART TIME EMPLOYEES 0.50 $ 28,490 0.50 $ 29,389 0.50 $ 31,095 61030 Temporary Employee Expense 600 7,000 NB-03 GIS INTERN 0.50 $ 17,693 0.50 $ 15,837 0.50 $ 18,886 TOTAL TEMPORARY EMPLOYEES 0.50 $ 17,693 0.50 $ 15,837 0.50 $ 18,886 TOTAL WATER DEPARTMENT 27.07 $ 1,918,881 27.07 $ 1,930,355 27.07 $ 2,089,009 164 Page 1100 of 1264 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2025 FY 2026 FY 2027 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Water Administration-FT 4201 60100 600 5010 NB-07 ADMIN SUPPORT PROF 1.00 $ 57,763 1.00 $ 60,159 1.00 $ 66,481 4201 60100 600 7980 NB-12 GIS SPECIALIST 1.00 $ 75,474 1.00 $ 78,369 1.00 $ 86,827 WATER DEPARTMENT 4201 60100 600 3885 NB-18 DIRECTOR 1.00 $ 123,030 1.00 $ 134,136 1.00 $ 148,202 WATER DISTRIBUTION 4201 60100 600 3975 NB-14 SUPERVISOR 1.00 $ 82,390 1.00 $ 95,637 1.00 $ 109,986 4201 60100 600 2120 NB-15 PROJECT SUPERVISOR 1.00 $ 87,763 1.00 $ 66,607 1.00 $ 112,502 WATER OPERATIONS 4201 60100 600 3965 NB-14 SUPERVISOR 1.00 $ 92,084 1.00 $ 100,671 1.00 $ 107,829 Total 6.00 $ 518,504 6.00 $ 535,579 6.00 $ 631,827 Water Administration-Temporary 4201 60300 600 7000 NB-03 GIS INTERN 0.50 $ 17,693 0.50 $ 15,837 0.50 $ 18,886 Total 0.50 $ 17,693 0.50 $ 15,837 0.50 $ 18,886 Water Meters-FT LEAD WATER DISTR 4202 60100 600 7887 0E-09 MAINT WORKER 1.00 $ 64,326 1.00 $ 78,372 1.00 $ 84,666 WATER DISTR MAINT 4202 60100 600 8175 0E-09 WORKER 2.00 $ 123,104 3.00 $ 185,437 3.00 $ 192,956 WATER METER 4202 60100 600 8185 0E-14 FOREMAN 1.00 $ 79,655 - $ - - $ - Total 4.00 $ 267,085 4.00 $ 263,809 4.00 $ 277,622 Water Meters-PT WATER DISTR MAINT 4202 60200 600 8175 0E-09 WORKER 0.50 $ 28,490 0.50 $ 29,389 0.50 $ 31,095 Total 0.50 $ 28,490 0.50 $ 29,389 0.50 $ 31,095 Water Plant Operation-FT 4203 60100 600 8875 0E-14 EQUIPMENT MECHANIC 1.00 $ 70,310 1.00 $ 68,869 1.00 $ 75,042 INDUSTRIAL 4203 60100 600 7990 0E-16 ELECTRICAL TECH 1.00 $ 85,208 1.00 $ 85,532 1.00 $ 89,160 4203 60100 600 8000 0E-11 PLANT OPERATOR - $ - - $ - 6.00 $ 411,549 PLANT OPERATOR 4203 60100 600 8005 0E-11 GRADE I 2.00 $ 122,081 2.00 $ 123,871 - $ - PLANT OPERATOR 4203 60100 600 8015 0E-12 GRADE II 1.00 $ 67,564 1.00 $ 65,912 - $ - PLANT OPERATOR 4203 60100 600 8025 0E-16 GRADE III 1.00 $ 67,131 1.00 $ 63,179 - $ - PLANT OPERATOR 4203 60100 600 8035 0E-16 GRADE IV 2.00 $ 149,894 2.00 $ 153,776 - $ - Total 8.00 $ 562,188 8.00 $ 561,139 8.00 $ 575,751 Water Distribution-FT 4204 60100 600 7830 NB-06 CUSTODIAN 0.07 $ 3,583 0.07 $ 3,404 0.07 $ 3,484 EQUIPMENT OPERATOR 4204 60100 600 7890 0E-10 II 1.00 $ 66,341 1.00 $ 59,214 - $ - LEAD WATER DISTR 4204 60100 600 7887 0E-19 MAINT WORKER 1.00 $ 79,655 1.00 $ 84,287 1.00 $ 89,398 165 Page 1101 of 1264 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2025 FY 2026 FY 2027 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET WATER DISTR MAINT 4204 60100 600 8175 0E-09 WORKER 6.00 $ 375,342 6.00 $ 377,697 7.00 $ 460,946 Total 8.07 $ 524,921 8.07 $ 524,602 8.07 $ 553,828 TOTAL WATER DEPARTMENT 27.07 $1,918,881 27.07 $1,930,355 27.07 $2,089,009 166 Page 1102 of 1264 Capital Improvement Projects by Department/Division WATER Project FY27 Recomm'd Number Capital Improvement Project Title Department Fund Account Budget Wells, Well Field, & Well Transmission Piping Repair and Rehabilitation 4281000006 Program Water 601 67990 10,500 Wells, Well Field, & Well Transmission Piping Repair and Rehabilitation 4281000006 Program Water 601 64075 100,000 4281000013 Water Meter Replacement Program Water 601 67270 137,550 4281000015 Generators-Park Hill & Mt. Carmel Water 601 67990 175,000 4281000015 Generators-Park Hill & Mt. Carmel Water 601 67400 10,000 4281000015 Generators-Park Hill & Mt. Carmel Water 601 64070 15,000 4281000016 Creek Crossing Water Main Restoration Water 601 67990 85,000 4281000016 Creek Crossing Water Main Restoration Water 601 64075 6,500 Fire Hydrant Assembly Relocation/ 4281000018 Replacement for the Sidewalk Program Water 601 67990 20,000 Maintenance of Public Water Mains 4281000019 During Stone Retaining Wall Repair Water 601 64075 20,000 4281000020 Water Storage Rehabilitation Program Water 601 64900 250,000 4281000020 Water Storage Rehabilitation Program Water 601 64070 25,000 Water Main Upgrades during Street 4281000021 General Repairs Water 601 64075 30,000 Public Lead Line Water Main 4281000024 Replacement Water 601 64075 300,000 Public Lead Line Water Main 4281000024 Replacement Water 601 64070 30,000 4281000050 Private Lead Line Replacement Program Water 601 64070 1,050,000 4281000056 Leak Detection Correlator Replacement Water 601 65050 35,000 4281000057 Water Tower Mixer Replacement Water 601 67990 45,000 Water Treatment Plant and Pump Station 4281000060 Pipe Rehabilitation Water 601 67990 20,000 Water Treatment Plant and Pump Station 4281000060 Pipe Rehabilitation Water 601 64075 10,000 Cla-Val Link2Valves Maintenance Program for Water Distributions 4281000061 Specialty Valves Water 601 67990 27,300 4281000067 Fire Hydrant Stock Water 601 67990 140,250 Municipal Services Center Roof 4281000069 Replacement Water 601 67990 113,201 Central Ave and White St Water Utility Improvements for the Traffic Study 4281000072 Implementation Plan Water 601 67990 75,000 4281000073 Water Distribution System Master Plan Water 601 64900 200,000 167 Page 1103 of 1264 Capital Improvement Projects by Department/Division WATER Project FY27 Recomm'd Number Capital Improvement Project Title Department Fund Account Budget Distribution System Regulatory 4281000074 Monitoring/Flushing Stations Water 601 67270 150,000 4281000075 Water District Metered Zone (DMZ) Pilot Water 601 67990 150,000 4281000075 Water District Metered Zone (DMZ) Pilot Water 601 64075 30,000 Eagle Point WTP Lime Sludge Drain 4281000076 Sediment Trap Water 601 67500 50,000 4281000077 Eagle Point WTP Railroad Building Study Water 601 64900 20,000 Enterprise Asset Management System 4281000078 Software-Water Water 601 64900 50,000 Water Distribution System Hydraulic 4281000079 Modeling Water 601 64900 10,000 JFK Tower Interior Piping & Expansion 4281000080 Joint Replacement Water 601 67990 50,000 4281000081 Leak Detection Survey Water 601 64900 26,000 4281000082 North Grandview Ave Water Repairs Water 601 67990 80,000 4281000083 Water Main Extension Pennsylvania Ave Water 601 67990 80,000 Private Lead Service Line Replacement 4281000084 Program Water 601 64900 50,000 4281000085 Vehicle 4903 Replacement Water 601 67100 130,000 4281000086 Vehicle 4908 Replacement Water 601 67100 130,000 4281000087 Vehicle 4920 Replacement Water 601 67100 80,000 Safety Equipment for Water Distribution 4281000088 Staff Water 601 65050 37,600 Water Treatment Plant South Plant Flow 4281000089 Meter Replacement Water 601 67990 60,000 WATER TOTAL 4,113,901 168 Page 1104 of 1264 PRGRM/ DEPT PROJECT DESCRIPTION FY 2027 FY 2028 FY 2029 FY 2030 FY 2031 TOTAL PAGE WATER DEPARTMENT Business Type 8th Street 20" Transmission Water Main Connection (Jackson to Central) $ - $ 65,000 $ 212,000 $ - $ - $ 277,000 47 17th/Locust Street Reconstruction Phase 4 $ - $ 555,000 $ 555,000 $ - $ - $1,110,000 48 Admiral Sheehy Drive Water Main Loop $ - $ - $ - $ 686,400 $ - $ 686,400 49 Central Ave Booster Station � _ � _ � - $1,020,000 $ - $1,020,000 50 Central Ave and White St Water Utility Improvements for the Traffic Study Implementation Plan $ 75,000 $ 50,000 $ 50,000 $ 50,000 $ 20,000 $ 245,000 51 Water Main Extension Central Ave $ - $ - $ 965,000 $ - $ - $ 965,000 52 Cla-Val Link2Valves Maintenance Program for Water Distributions Specialty Valves $ 27,300 $ 27,300 $ 27,300 $ 27,300 $ 27,300 $ 136,500 54 Creek Crossing Water Main Restoration $ 91,500 $ - $ - $ - $ 200,000 $ 291,500 55 Water Distribution System Master Plan $ 200,000 $ - $ - $ - $ - $ 200,000 56 Distribution System Regulatory Monitoring/ Flushing Stations $ 150,000 $ - $ - $ - $ - $ 150,000 58 Water District Metered Zone(DMZ) Pilot $ 180,000 $ - $ - $ - $ - $ 180,000 59 Eagle Point WTP Lime Sludge Drain Sediment Trap $ 50,000 $ - $ - $ - $ - $ 50,000 60 Eagle Point WTP Railroad Building Study $ 20,000 $ - $ - $ - $ - $ 20,000 61 Enterprise Asset Management System Software-Water $ 50,000 $ 50,000 $ - $ - $ - $ 100,000 62 Fire Hydrant Assembly Relocation/Replacement for the Sidewalk Program $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 100,000 63 Fire Hydrant Stock $ 140,250 $ 154,275 $ 169,702 $ 186,672 $ 205,339 $ 856,238 64 Generators-Park Hill &Mt. Carmel $ 200,000 $ - $ - $ - $ - $ 200,000 65 Grove Terrace Sanitary Sewer Reconstruction (Consent Decree) $ - $ 130,000 $ - $ - $ - $ 130,000 66 Harvard St Sanitary Sewer Reconstruction (Consent Decree) $ - $ 140,000 $ - $ - $ - $ 140,000 67 169 Page 1105 of 1264 PRGRM/ DEPT PROJECT DESCRIPTION FY 2027 FY 2028 FY 2029 FY 2030 FY 2031 TOTAL PAGE WATER DEPARTMENT Business Type Hempstead St Sanitary Sewer Reconstruction (Consent Decree) $ - $ 320,000 $ - $ - $ - $ 320,000 68 Highway 20/Dodge St Water Main Relocation- Devon Drive to Concord St $ - $ - $ - $ 120,000 $ 880,000 $1,000,000 69 Water Distribution System Hydraulic Modeling $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 50,000 70 JFK Tower Interior Piping & Expansion Joint Replacement $ 50,000 $ - $ - $ - $ - $ 50,000 71 Leak Detection Correlator Replacement $ 35,000 $ - $ - $ 35,000 $ - $ 70,000 72 Leak Detection Survey $ 26,000 $ 26,000 $ 26,000 $ 26,000 $ 26,000 $ 130,000 73 Maintenance of Public Water Mains During Stone Retaining Wall Repair $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 100,000 74 Municipal Services Center Roof Replacement $ 113,201 $ - $ - $ - $ - $ 113,201 75 North Grandview Ave Water Repairs $ 80,000 $ - $ - $ - $ - $ 80,000 76 Water Main Extension Olympic Heights Rd $ - $ - $ 617,000 $ - $ - $ 617,000 77 Water Main Extension Pennsylvania Ave $ 80,000 $ 465,000 $ - $ - $ - $ 545,000 78 Private Lead Line Replacement Program $ 1,050,000 $ - $ - $ - $ - $1,050,000 79 Private Lead Service Line ReplacementProgram $ 50,000 $ 1,000,000 $ 1,000,000 $1,000,000 $1,000,000 $4,050,000 81 Public Lead Line Water Main Replacement $ 330,000 $ - $ - $ - $ - $ 330,000 83 Rockdale Road Reconstruction $ - $ - $ - $ 400,000 $ - $ 400,000 84 Water Main Extension Seippel Rd and Pennsylvania Ave $ - $ - $ - $ - $ 585,000 $ 585,000 85 Source Water PFAS Reduction Project- Granular Activated Carbon Filter Rehabilitation $ - $3,400,000 $4,000,000 $3,500,000 $ - $10,900,000 86 Source Water PFAS Reduction Project $ - $ 371,199 $ 750,000 $ - $ - $1,121,199 87 South Algona 12"Water Main Replacement $ - $ - $ 793,000 $ - $ - $ 793,000 88 Water Repairs Sunnyslope Street Project $ - $ 90,000 $ 110,000 $ 80,000 $ 110,000 $ 390,000 89 Vehicle 4903 Replacement $ 130,000 $ - $ - $ - $ - $ 130,000 90 Vehicle 4908 Replacement $ 130,000 $ - $ - $ - $ - $ 130,000 91 Vehicle 4920 Replacement $ 80,000 $ - $ - $ - $ - $ 80,000 92 170 Page 1106 of 1264 PRGRM/ DEPT PROJECT DESCRIPTION FY 2027 FY 2028 FY 2029 FY 2030 FY 2031 TOTAL PAGE WATER DEPARTMENT Business Type Water Main Replacement W 8th St $ - $ 60,000 $ 335,000 $ - $ - $ 395,000 93 Safety Equipment for Water Distribution Staff $ 37,600 $ - $ - $ - $ 20,000 $ 57,600 94 Water Main Upgrades during Street General Repairs $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 150,000 95 Water Meter Replacement Program $ 137,550 $ 137,550 $ 137,550 $ 137,550 $ 137,550 $ 687,750 96 Water Storage Rehabilitation Program $ 275,000 $ 1,425,000 $ 175,000 $1,286,000 $ 175,000 $3,336,000 997 Water Tower Mixer Replacement $ 45,000 $ 45,000 $ 45,000 $ 45,000 $ 45,000 $ 225,000 98 Water Treatment Plant Roof Replacement $ - $ 110,000 $ 350,000 $ - $ - $ 460,000 99 Wells, Well Field, &Well Transmission Piping Repair and Rehabilitation Program $ 110,500 $ 165,000 $ 150,000 $ 162,000 $ 162,000 $ 749,500 100 West End Annexation Phase II $ - $2,000,000 $ - $ - $ - $2,000,000 101 Water Treatment Plant and Pump Station Pipe Rehabilitation $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 150,000 102 Water Treatment Plant South Plant Flow Meter Replacement $ 60,000 $ - $ - $ - $ - $ 60,000 103 Southwest Arterial 16" Water Main Extension $ - $ - $2,475,000 $ - $ - $2,475,000 104 TOTAL $4,113,901 $10,896,324 $13,052,552 $8,871,922 $3,703,189 $40,637,888 171 Page 1107 of 1264 This page intentionally left blank �72 Page 1108 of 1264 !,' �'- • i�r� �'- -+ -' � ti. , ��'� _'�S �s •y.� � � I ` _ ��� �; ,.�` �• � �� �•�''•�1, , �,` � �� a. .,. - ` • !�i'i� � � � , •.� � �'` ` ���t`., �"r - ����� , �� � ', ' � '�x�:- . , . � : � � � � , � _�� � ; ����,. � � ,� , . �i' 1 �'.�;r.,�, � � l � . � ���� � � .� � �, �` . � x � �� - �~� �� e. � � _.� - . -.,�,�- i ' 4,►?;i J � �'''�; , �'` � , / .,. - - , � � �� �.- .� - . ., _ - - .�, : - I � . � �-� , ,� '� ,-. . � � ���� '- �� Page 1109 of 1264 Water Department The City of Dubuque INater 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 1110 of 1264 Water Department FY 27 (27.07 Full -Time Equivalents) Water Department Org Chart FY27 (27.07 FTE) Water Department Di rector (1.0 FTE) Administrative Support Professional (1.0 FTE) Distribution Supervisor Water Project GIS Specialist Operations Supervisor Su pervisor (1.0 FTE) (1.0 FTE) (1.0 FTE) (1.0 FTE) _ _ � �Lead Distribution � Lead Distribution GIS Seasonal Intern Water Plant Operators Maintenance Worker Maintenance Worker �(1.0 FTE) (1.0 FTE) � (0.5 FTE) (6.0 FTE) Water Distribution Water Distribution Industrial Electrical Maintenance Workers Maintenance Workers Technician (7.0 FTE) (3.5 FTE) (1.0 FTE) MSC Custodian Equipment Mechanic (0.07 FTE) (1.0 FTE) Page 1111 of 1264 New Faces in FY2026 _ I�. �_� ` � � - . _ .,�,...�=� � -; '�� • .� .��=i ;��� y � ,� - _ _.,., ,�; .� �.� �, . ; -� �: , .,� - � � � -� � � . � � � � �. _ ' ' ` `,� � L � .,� .a . , ` _ , '��=�',� _�� ,. _ t � _ �- . _ ,�,. i, • � ' '�i� t � ��,'�'i► `�•+�w�;; , ��i��� . {"�= e p��+� . •�' ;' � � . � _ � � �— �,., � . / ,._ � �1 •r �Y r� � '� �r' _ ,1 , , �},,� �. , � ";�'f, _ - � � , �� : �. _ Jade Griesinger, Mitch Hammel, Eldon Schneider, Bradin Steil, Water Distribution Water Distribution Water Project Water Maintenance Maintenance Supervisor Distribution Worker Worker Maintenance Worker Page 1112 of 1264 Recognition of Staff for Certifications Obtained Mitch Hammel - Water Distribution Grade 1 Chris Kerf - Water Distribution Grade 2 Kyle McCombs - Water Distribution Grade 1 Danny Petersen - Water Distribution Grade 3 IOWA DEPARTMEI�IT OF Eldon Schneider - Water Distribution Grade 1 NATURAL RESOURCES - Water Treatment Grade 1 Nick Kunde - Water Treatment Grade 3 �� Jordan Lamey - IDPH Backflow Prevention Tester �� ,� Nate McLaughlin - IDPH Backflow Prevention Tester o°u B�icHEa�Tii Page 1113 of 1264 FISCAL YEAR 2026 HIGHLIGHTS — ' Uti I ity Base Rate 50% Low I ncome Reduction Accounts by Month FY'25 Jah- �ug Sept Oct �o� Dec Jan Feb I�Iarch �pril liar June Storwn-ater �79 430 �40 �19 �37 ��l? ��9 �?0 �3� 603 632 632 R'ater �7S 4?9 497 �16 �34 �41 ��9 �69 �34 602 630 632 Sanitar�- Sen-er �30 �31 �99 �13 �36 �41 ��9 �?0 �3� 603 631 633 Refuse �63 462 480 493 �1� �23 �40 ��1 �67 �36 612 61� Page 1114 of 1264 FISCAL YEAR 2026 HIGHLIGHTS — ' Uti I ity Base Rate 50% Low I ncome Reduction Totals FY'25 Juh- �ug Sept Oct 10� Dec Jan Feb �tarch �lpril �ta�- June 1'TD Total Stoi•m�atei• S 2,529.83 S 2,107.63 S 2,181.00 S 2,291.21 S 2,3�2.93 S 2,331.99 S 2,445.83 S 2,490.47 S 2,�66.51 S 2,63�.39 S 2,743.52 S 2,7�1.43 S29,478.39 Watei• S 2,733.45 S 2,323.9� �2,433.58 S 2,�43.�6 S 2,640.01 S 2,657.?1 �2,713.11 S 2,?63.?3 $2,343.17 S 2,943.55 �3,U64.90 S 3,063.40 532,689.77 Sanitai�� Se�ei• S 3,623.�6 S 3,233.39 S 3,4�3.32 S 3,616.06 S 3,633.02 S 3,i�6.02 S 3,332.23 S 3,911.24 S 4,022.74 S 4,163.92 S 4,323.44 S 4,333.36 S�6,012.85 Refuse S 4,630.49 S 3,956.30 S 4,140.36 S 4,33�.51 S 4,417.63 S 4,532.22 S 4,622.73 S 4,?21.44 S 4,372.16 S�,049.?� S�,243.97 S�,2�4.21 555,831.82 *FY'25 Individual Reduced Bills: 26,707 � FY'25 Total Recluced Fees: $ �64,012.83 Page 1115 of 1264 FISCAL YEAR 2026 HIGHLIGHTS = -_ _ - _ __ _� _ ■ ■ ___ _ _ _ � :. • Water Meter Technical Upgrade _ � �, :��. � . _ _- - - � Program . _ - - �. :��\ _- � . _ _ � ; ., � � ._ _ _ - -- .�.�... ,: - %._ . ,_ �. • Water Meter Component. Replacement of Meter �-"���' _ - � ° �;� �� _ - _ � . l � ° . �•� Interface Units and Registers - � , , �,'-�.4 _ ,4 :��- =;�.�� �� . . - _� . , , • 5-Year Program. Initiated in FY2022 � � ` -' ?�' � ,f�� � � � �� � . • Total Pro�ect Cost Estimate: $1 ,885,000 � ' f� . �- �,� , � � I n Pro ress '��'�'��� � � �. . g � . .� , ,� ��:. .,. ,�► � 5,000 M I U's replaced each year � � , f��- �_.,�,��a� '�' f �.���,�: ,� -x;.-� . ' R;� _, ,,,,d�_ �--c y��4�, �' � .,� ���r �• � 1� "� �,�r'+�. s�" ,� t- ► � C�^ `� �� R.�,r te� �<'LR��. i. ► ' �.��V`..f.'. • Work Performed by Water Department Meter Crew "�;�.�, -Y s� ���;�;r�����`<<: � ,�"�` ``����`'.'�' � �.- 9L _y t � .�.'�, _.y.� � ,,,t .� ; �2". �:.r� e.� .w' �� �'. ,� �; r r � � • FY2027 Final Year of Upgrades , ,�� x �� �r,�, ,,; ,� y - •.�, � ..� 9 - i��`�� �'� � J � '`. r �'��s�,.';�a�;v � 1 l�f R ` f.�! � a'� �� .� ���{ � ��.�w►�a6..�,�:�c ��� '�'..r�t�t�' ��w� �� + :�c Danny Petersen installing new MIU Page 1116 of 1264 � �''Br��, �� �� -� . ,4 O I � FISCAL YEAR 2026 H IG H LIG HTS ry , , __, � ,��� _ 11 � W� �� i-���i � � ���' �—�e � o � � .� � :� _ � ■ ■ �! ��. � �� �-- �__ s '�I �.[ � _ - � � -�.'f t � � .,I__--I. _ � �. � I � _ �IyIY� - Eagle Point Water Plant Supervisory Control ;�� ; �� � � ,� , - . . . t �" , and Data Acquisition (SCADA) Upgrade � � ._ � � � � a . • Replace the existing Supervisory Control and Data Acquisition •� , -' Li - �, (SCADA) equipment, including hardware and software �'� L �`" r I �I • ,� , , components, while enhancing operational efficiency and �� ;x �, _ � security at the Eagle Point Water Treatment Plant and remote ,�, �'� �- sites. ��� � � �� , �� -�- ,,�-- • Contractor: Westphal & Company, Dubuque, lowa ; � , ��' � � C � � ��' ' � Amount: $1 ,345,000 � ;,,� � .... . .. ..... ..1.� ... � In Progress: Est. Completion September 2026 �� - � �� �� � R*; � • As part of this project, fiber optic connections are being installed '� � � . �` � � at 17 sites, including pump stations, water towers, and storage ,' ' _ � � tanks. ,� �,.:� _ .� p�� '� ,� __,�. - 0 1264 FISCAL YEAR 2026 HIGHLIGHTS � � N En lish Road Water Main Extension Pro'ect J J • I nstallation of a 12-inch water main from current ,�..�.� N En lish Rd Water Main Extension I�I�R terminus at Edval Lane to the Southwest Arterial. ��UL g WaferDistribution System Map - �; ,,a., , . - ,, _ ,�,p,; . �� :' 'b � q��!*�,�;'.,f'�`, _ ��`r ' . �^ �r', '. .� . f 7f: -- ` , .� . .�.w. �. "t' ���. • Includes extension of a 16-inch main to North �„T ��TENs,��,�� ,t��;, � ��,�� ., � � �: � .A � � ����� � ;�'� � English Mill Road North to support system _ y���r,,� � FY; �� .��� �� ,,�,:�x � ,�� ����� `. � �.�` . ,,� expansion and future development. . � �Y;� ��,, ����, . � . �. �� �, ��,:. ���k. �� , E..- <' { ti %! ';,,..•• *�•,�`�� • �� '�: .,: : , t... '� „ •� iri i;a� ^G �-�' ���,- • Contractor: Top Grade Excavating �� �-�`� .�,-��� �-� � � � �; 9�� 4 - ��r�- ''°��FRs O � �, ����� l �� .�= , � m� ���' �'� (H Amount: $1 ,487,135 13 /o below estimate _ .d t,;��: � ..� .,j.�� �m,����� ti .. :,-. � ) - ai�� � j .z , �,`;�. � Project Completion: August 2026 = a _ � �� ��'' ��`:� " �.(� ! ln � •,j �PDf R� ..� �/ N� .� �'- , '~ . : �y''�•',fNpR�N�pS �8 , �� / � � � .� � � 3 � � ���{i ' ' c7 \ a �...p �. '.t �� - � z��. .Zr ;:1�._u�7 . . • • .jiA�� � i'�""!� �¢ m ,) • Facilitate a future loop connecting Pressure = r• �:��� � , .; ' � ��-� � ? __ _.__ -� � io -�. ��, �. .. . .__ . _ __. z _ o�� Zones 3 and 4, with a planned extension to the � ,» � s ;;t:. �a., wq<,F p��► English Mill Pump Station. � _ . v ,. ` . '��:��, R`" ` . � � �� ' .i , i .,. " �` �.'. . M J r N�5? i. � ����; ��. � � �.f" �\, � /�. ' _.. - _ — �\ V �����-���� N Map Prepared by: 0 6U0 1,200 2,400 City of Dubuque � ' �� �� 1/�1�E Water Department Prepared by eschneid Feet 1902 Hawthome Sf Prinled on 3?31i2026 3:09 PM sPage 11'1�3���'f'�4 F I ���� ���� �0�� -_ � Dubu��ue Lcad Semice Line ReYlace�ncnt Pilot Pro jei t L)i�I;l't?t'F � �� �- Progress A:Ot 10+_9,_0��(1331 Full Col�f�rr S�mim Li�tc. �� pAV1551 .� + .. , . . i M �.. l_. � , . ,_ '-EOITN St�'�'�m� ���:K �� . y � ` i � ' ,d,o9 �.e-�-i-arw-�L�"•';s''�°Eucuosr t~' `�! "k� ����s�;1.� � � +'-•y �. � ', . „m �, .. ,. y� .• �� l ��i '�,�� H I G H L I G H T S � , ,,o.NE�«5T�.� _. . �e ��� .. ���.�.. �. ,::.� �..: • �` �1 r.HOVELANOPLACE. O .r�� ��nr.1�.tb� � 'r't����.1 .?ni� � + Q , - :Q� ` �n. *.:- � GOETHE ST Q�{��'�' � i' . r. g� :1 �l �9 ' � �?:. .;•-..��wt�A 'RlY�� . f f'y y Z' •'�'�'6' ,:•I/�,V/ \� ��'J��q� � •.,LAWTNER ST �� , � . t� / .� Z Ct ■ ■ �h :.� j��U y'- � � .:aT}}F '�,y�t�l�'r� � a.� �t,�� -ft �,� i}� � � '�t. F� ��• s�`�i `ti,`a�� ;��e�f tr ti��t. . � ... � �-J' q g � �r �„R� y"t � � 9 • •��fJ9���^�.� {�• ��CIEWELL�,'�r� . � " !� �l ^`'�� ;��:.�5'}i� 3'' ►��..�� ; 't��^� . _ , � rf4 •'fi` �����Ar MCOON:iD UN �� �� � Private Lead Service Line Re lacement �� ��r���� o"'"'.�g� '������*�� • � Legend � 1 . � ' � . . TOHST��,lo /.� • �_' . � Main to Stop I `.'�l .'��r, . .,,�z�T�1,�,•'' .t•d� w_'- i • .�' Stop to Meter �• , � Pilot Program Phase 1 - Completed � � .� . E..Ng. s � � � vi •� � HENN ' •:..aii.., �"y�. �'p�� t �. c _�. .���-F r H� � .• • Oi.N -,p�E`'S i. y �» rn��. it�.�•y�•. �tr!I GM�n+W r _9� �� ,�� � 1 y. 3 (�` �on+�a�.,..�. T�' �`:�� ' 9�f. � �, :..�•� ` - � 1_�• v. W �'!'R!' . a � � � •:..ai�en.�..e �t ='1 .. � 7 � .Y� �1`� 1' MFit757�r`W. � �C.�;. �''� .• � � . �. .c �, . ?, ,�n i... ,J ?,� �pW� � � Funding Source: Bipartisan Infrastructure Law •��� ���:�:a'� �% . - �y� � �-� ., = <.�� �,��Y � /.eAY�j�� .� � . s •r 1 v . .'' v'.� �'_' � . funding through the lowa State Revolving Fund ��` � 5� �• ~� � -i,•,5� • ry,� = � �-�r r*� '� �:r.�.s,�w�V '1�1�Gl �G�-'j�OIAG�NAL::i� ' S �; p^ �P ;. , � �• �j...a: .�l �r�f�N� A;1y s�,' � �' �v ..uu�� y�' 7� ���. (SRF Loan Program a:�`� �' ^ �.} -�g�� � �m�� � .r.�,� � �.�a Os -4. � .. .�. ,� c+..re.,,��., k�' •'1'<,.--r� jn��• '�- ��o""`�`'�.....o.. � ,.: �r,,'; � � ul - y (� � 0 •"°"""�i"° �• � �'� `,ssf .`� � Fi nancial I mpact: 49% loan forgiveness for �.�:,�. .�, �-����._� � � -� 4� � ` � , �� � A� 1,a� , - 0 . ro'ects servin desi nated disadvanta ed •�"'°'�'�° �.� �` �°° :}��s����� `� � � + p J 9 9 9 °-� - w , y�� � ��� we.�..a I ir� W . r-�.hN` r v • �q��IiAPER Si � '��h4�fi�" 1F' 1r�� �,>��,E-. community areas •�I� i �.a�Rm�Gf���ER�q�'iyv e�,�-`1,� 1H5`'= �rP�+V�� Z C ,O ��N'El.(r'. .�CTE,���j,•�j+ � ;Et0 `'�e �L1� 'An ,� .S7�'1+�'_ Z.�� �' �. .�f � �} ,�� •:w��t urnu�e Y•� o ;�:b�.��.t .:���• Sf,,��F �1',� � . 1 A�• �o-m� *�w�.,." � ,.-�M"�':;��aj r^ ,- . - 'v � Contractor: JQ Construction o�`� � ����'+ ° �, � ����'� g�`��'9 .�~ �(-` � 5� H �Y ��N Nr F�p- ^ '•� „4 'E�z1H�`: 5� ou,. • z . ��_///��� � . , t �� �^.� �I...q�MONDSr W�: ���,1!.19 �� � '`1:'� E�6 ��+S�Hgt ■ WLOCUST5T ���1�1„ " . , . _ '•.��7• � . d+�, - . • �•� . - E - Amount. $1 ,735,494.78 � MapPreparedby - . - _ N CRy o1 DubuGuc. W�E Water Departmen! 1902 Hawttwme S. � 133 Lead service lines replaced in Phase 1 S 5��9��' Page 1119 of 1264 - • Private Lead Service Line Replacement Pilot Program P����� � � � ' `' � Eligible Candi�lates For Phase 2 and 3(63G) � � 1�U13Uf)l_'F� ;���ary A�E °a t � �. _\NPJ� . p 1'��\ . ' �y�fi ♦ O`-��. � � • Project Timeline P� � �`��• - --,� k��� '�:�;� � .,. . ���a � � Bid and award: Summer 2026 � � _ u ` • �°"$5T `'t�`: sl �J � �4 r' p�YMPIC NEK+„TS � � .L: � � `� � �� ��� .` �� �� 'VSj`~`„ e '� F� . .( � , �h'� 'c�F� � : gr � °ti _ ve.�ae � �;` - - � � - � � - � • Cost to Residents �a - �- ,�� s, � - r� ���o�� io � � M ., .' � �v . •�.P_•. �LS • �,� W, 'E c.��"+ .� ..._YQG�''(M,crqE3l F�,. � Y M � � $0 cost to owner or tenant in �,-. :. . , Q ._ .1q��Sr��ys, g -, � V,. ' pYEp . 'G . y ' / �� � disadvantaged communities �- KP"`51 V� ��r � ��� •° .. - � � . . ;. Fl ��NG_. ` .KAtIF �-�!� MFNryqyF r' . \`;i�� � .. �. ` . s �' - �!R � �.-. ��j' �• � \ ". � l.t ' �q�.Fk�qs., eaPf0.c` ,. �I- ~� • �/� Op�^ yOp � / Funding Source .�,sPSQ��.��SP�t � � • � .� �� � Bipartisan Infrastructure Law via . x "a:�aKE���� b � E`�SNS� � b,�o9 �'�'�_'3 µ "�,��.• . � '.i `,1`NSt �a�HS`��'W lowa State Revolving Fund , $ E K�� �R �� `V- � � E��S~gt Cr . (SRF) Program = : - , . ; N • • � � 49% loan forgiveness for ��:R.� �� q��S° � �,MS:��o�; . . a� �+ ,. .rR projects in disadvantaged ��.��[���:�ge��° �ss,�S� � �.� °F�R;�`sr '�+`I`OM .L. . P ��5�`St '�% E \Sl�.sr '. SOR community areas 4�AR`$T, D ` ' � , �N • J^F3ROST � � � :�� ^E�Hi 'wsrH � : otN , � :e!� �..SI. F 5� r .�MP 0 �� .�f OCNNCTTS� �� � Q , i.n ���VS\�' ��. , y , o E,s � �-Ha�Esr -Q ��-� o° i ' ,;.�. , : .. � . rST. .' - �S �oaEssr r��N-� 1 z E' '2'v MER`y pp �t i1.s . • Project Cost _ �ROg� ;�:r� - .� p =a pppGEST .� ' Phase 2. �� .99M - - N MapPreparedby � __ _ Gty of Dubuque o t.t0o 2.z00 3.300 W�E WaterDepartment Feet 1902 Hawlhome St � Phase 3: $1 .90M �-��----� S 5�.�9�z9, Page 1120 of 1264 . Drinking Water Quality Improvements : New Deep Wel l (No. 11 ) � �� � � � - � - � , _� � � " �, " >= f,.r� f - , � �^� •` `� ' `�-`-1 � �'� . � � � �i' �,�` "�-`-� ' f�r I�I '__ � ■ • Dubu ue and PFAS � �=��h � '�� `� �'- ,� '� - - q �. � x. - r , �, � U dated Iowa DN R . _ \ � \ _ � � "-'�-`�- � � ' - f'�� � ', ' I � ti � _�, i operating permit received in : � � � � ,�,� � �-� � - � �� .,- , September 2025. ,� � ' � � ' � � � � , � ; � � � � � PFAS sam lin fre uenc � �� �'� '� '� : �' ' - - p g q Y �� , � r ,, ���. , � , �� � � reduced to annual r ` �r� monitoring due to continued �'= `� � ' --�'� �°° �"'� compliance. .,.�. , _ ;:, . - � {,� �,� i �a ;�.fi.�� "'*I�.�: , � � . s+� _ . �-4y�'^ •r e �; � „t,.,r `--�_ I:- ,o .��,"i `` �; �`._. � � �_ _ � �, ,,�(� • Estimated Total Project Cost: . ' � � • �' . --- �� , � ' 6.5 million based on final � �F - . - � , � , � �� � , � location . "� ` � � � � � � � � �,��� `g� k �, , � �'w�. .__-� - - �Ood Fire�� �a in�, Foa ! , ' �___ ,� �� . ..t t.� �. _ . ..,r „ .., ./. -ir..�_. . Per-or Polyfluoroalkyl sututances:Overview and Pre valence,AWWA,August 1 Z, 2019. Page 1121 of 1264 . Drinking Water Quality Improvements : ► � Granular Activated Carbon Filter Rehabilitation � ■ • Rehabilitation of 17 existing gravity sand filters (constructed in the 1950s-1970s) • Integration of Granular Activated Carbon (GAC) treatment for P FAS re m ova I • Estimated Total Project Cost: $ 11 million ..a�d �:�c ;�`�9� ` , ��� �F ~� � �, � � � � Mon blohlma aCcut�ulilvQ • Mo�e bio�onic 1Nn01 deposhod IMrqne^a 6A�C IMo .00�.f. • --....._ . . "`""'""n. . . •and f�e.r � � aot� `. �•�. � \ - � � !0� �i � �� ,x,-, , r I i� — a. — ! �t x fo • s0 M T1�p� s�wd FIlK GAiC�anO i� 25%�i�A+C-T5%sar►c1• 1009�GA�:- • . _ . , , ._ Page 1122 of 1264 � ► � Environmental Protection Agency MANDATORY ■ ■ Lead & Copper Rule (LCRI) Improvements • EPA-Driven Requirement: The project responds to the USEPA Lead and Copper Rule Improvements (LCRI), requiring all lead service lines (LSLs) be replaced within 10 years (by November 1 , 2037). • Scope of Work: Replace approximately 3,900 remaining LSLs in the City of � � Dubuque's water system, building on the prior Private Lead Service Line Replacement Pilot Program. • Ownership: All service lines from main to meter are privately owned, � located on both right-of-way and private property. • Implementation Timeline: Plan development in FY27, multi-year construction from FY28—FY37, with annual progress tracking and adjustments as needed. • Funding & Program Structure: Early years use voluntary participation with low-interest SRF loans (�67 lines/year); later years transition to mandatory replacements (�605 lines/year), funded through state loans and property assessments. • Total Project Cost: Estimated at $60 million, including planning, design, construction, program administration, and communication. Page 1123 of 1264 *A verage Household = 3, 200 Gallons/Month 0 • 0 ■ Proposed Rate Monthly Bill Impact for Increase over FY 26 Average Household* Page 1124 of 1264 RATE COM PARISON Rate Comparison, Lime Softened Facilities Only $40.00 $34.05 $30.00 $27.97 $27.36 $27.07 $26.93 $23.52 $23.40 21.59 $ $20.00 r $10.00 $— - — Cedar Ames Des West Des Ave. W/O lowa City Dubuque Council Rapids Moines Moines Dubuque Bluffs � FY27 Water Only for Average Household (3,200 gallons) Page 1125 of 1264 Based Average Household = 3, 200 Gallons/Month 2 n d Lowest Rates : Th e H i g h est Wate r � Rate (Cedar Rapids) is 45. 51 % Higher than Dubuque's Rate ; and the Average Rate is 12 .92% Hi her than Dubuque. g Page 1126 of 1264 Public Safe Im act p ■ ■ Protects Public Health .�� �: � � � , . . r Supports City Services _ -�, . . - �,i� r - � � 'v ' F ' � �� T i _ �t- ' ' -�� , � y 4��` " , +I ', 1 �, ' `s- y�': � ^ '� �* ,�'•� , ��_ � '.jj i_ � �� �..-��► r, • R�} � ;� /� � � 'J_' .� - • , � __ � '� � - "` �,'�� 11 � , � O ,� �l 1�,, 4 �''� : ' �,� �. ..�'����"-� . ��:�'`� .� �; �_` � � Ensures Emergency t � ,� �' � � 1 - - �� $�� � !i �- �' . . - � � � �� - - Read i ness ...," -� ,� , `� -- -- - �ai�--� � L -- � �a �-�' � � � " � +� - _ - __��. Reliable water systems are essential to _ - � =_� -- community safety and emergency response. �� � ML.I"w.�_. ..� Page 1127 of 1264 �I O WA Home Statistics— Resources— Manage Account� WAT E R A D M I N I S T RAT I O N T�a;n;ng E�ent deta;,S ■ ■ • Employee Training and Development Date 03l10l2021-03J1012021 � Professional Development Location � On Boarding of New Employees CityBState ONLINE 0 C o n t i n u i n g E d u ca t i o n P ro g ra m s Contacts OWARURALWATER ORG More Info OWARURALWATER ORG Description RISIURESILIENCE 8 EMERGENCY RESPONSE PLANS-MARCH • Regulatory Compliance Max Allowable Hours � Ongoing reporting , monitoring , and coordination with lowa DNR and EPA to ensure regulatory compliance. • Capital Improvement Planning � Project development including budgeting , initiation , and award through construction completion . Page 1128 of 1264 WATER TREATMENT PLANT OPERATIONS ■ ■ � . �. , . �- • Water Production and Treatment ' � ' _ �--�='_` . ,,, : I � Regulatory Compliance . � �: �� � Water Quality - Consumer Confidence � - " � T ' . I/ '� • Source Water Protection _ ,� 2023 � Wells and the Well field P WATER QUALITY RE ORT � Treatment Plant . . . . . . � . � - • Water Storage and Pumping Facility 'r arr oF�uauouE � WATER DEPARTMEMT Operation and Maintenance � � � �p���;� � � . . 'r / . .� Y ��� • Reliable Data Access and Reporting r. a �.`�� ' � �� '�� � =- � . ,,�:. , � SCADA Communications �� � � '��`� � -.`'f � ' " � r, � �, � 129 of 1264 . _ WATER PLANT OPERATIONS ■ ■ Water: Treated and Metered 3,000 2,48g 2,506 2,497 2�599 = 2,5�� 2,273 •� 2,00o I 2,041 2,077 2,067 2,091 � 1,914 O 0 1,500 r' � � v � 1,000 0 �7 500 0 Treated Metered ❑ FY'21 FY'22 � FY'23 � FY'24 � FY'25 Page 1130 of 1264 +r ^.!G Y$ � ��C�` ylC��'� � f � 4 �i ��.� ✓t''�.. ���,. ��3 ,�y{. � �'� �, 5�,. ' " '� �. ,p +yj� f. 1 1 a0.�' r r �...t �'�' „�„�r ,��� ] Y�`.A . .. �'� y����+� i ■��� . < `a 7 'r�' iI+ 4 i� y�a� . �h�y`'' -0-S "�`�� 'f � H'a1 �"-> r'�,�,"'���`,` ,f';s�. ` •� a � �► � . �� �! � o ����. .��J����,4 � �' �,���'�i'�; ���� 4 WATER DISTRIBUTION � �� � { ��� �d ��9 R � � � � � �Y �. J,.d�j� r� �� � �.,�1�. ,� � �� d._t.. 7 4 � ,+. ,�F� ���'r'P� r �� w{ � ..� �l�,�, �s1 .• � �,��� �. ����.'�A� '� �i 9 �1 �;,la�'���+� t i e... . w w��`J� . � �_� l�'�-�:w ■ ■ ... �� � a.b'rf�,�A� ,. z Y,. � i -'t�p, Z � �� � j Jt ' � �!~ rys �" �`p�� � r� :i� s^ �"'P 1� .. ' � ; .�� � � � h �„„� R'�� . �� p{ "�`':a �`�` ;:. '�� ��, �' �,����NK f � +�'.`e •, �'_ � \ ,� .�t �c/ fi��{ � �`:� Px � � �.�,,�-. }�qq.� ^`. �'#� ��r� , � � ��� waA'. '"V?��� ':''R {'.v.$9 "��' p. � �AR ", � � . C� � ., i F y):� .. j �`:: �Y. "�-ia � �. �". rMZ)q ��. I� `° '��" � p'.* a�.�,. + i+' �� s , ^ �� �� ,� — � ,'' v , - �' r �'� �, y' �� '^f�- • O eration and Maintenance � � ' - ' �� ' :� � � �au �( ,� j �s � � . �,�i ti6 r �` "r,..�-��,' F� .�9 i d/_. , � .n � � y '�,�`a /iR'! ;�at 4�. �- , ���1�' � '� ;�',�� q a ,.�,h t � r �`�x 4 Q 1�.-- ,''�" ``� a ,.R� S \� �'�'' '��..-, �,�+;;} `� � -.,� r. _�✓���,��� �'3,�'�', ,.� .�y .���'�i t �,- c��p3:�$.,-'�" .i� • Emergency Response � �- . � _� _ - 1 � ��,� -:�� -�� 1� r,� ���a��� � : '� , �_ �� st ' �� _ -� '� �- ti_-' ..�, ,� � lwi�a�r�-; �..- ,�r��, , � • I nspection � - ��� � � � r �� � � � '� � � � µ�� ,� � �.� � ���� , �.� ��� � d �� / � C y �� � *� �i'��� �=r yf � i'� J �'aL \ _ � 'Y ` t S �.�`y' V �:,� �'l 4 �y� • General Construction � �== =� ` ` Y ' �'� ���� h �` '� � � ' �� 4w�:� -y �� iil�� „�� �u ;,���' ,�� �, , .� , ��Y;��,�� � � ,=�. ,� �� ��:- . ��; . ��� � _,.��. �=� �,�� ���.,��;<�-�� ����� r � ��.�` � � _._ � • Service Line Main Taps ►`�l,�2 Tf �e-s�{ _ ;�F:��; , ,��;� ,,:,,���� . . • Water Main Installation � - ����� r� � , � � � Q � '�.�'i.L: �, � ;��, �,�r'�tk -f����X��'; <�-.._ ' ___- . ,.-,� . .'x i.I -�� . . .� -c:.._:�. � ...._., , • Meter Management �� �� � ��=� _ t � ^ � � �. � 3 ' '�' , ,;:- .` �, • Backflow Prevention ' �� � ���� � �� � � ,��� � � � ,� .4Sr Y��� * �;r ���� � • ��,� �% � �'�`\,"'� ~ Develo ment Review �.:Y� ,.�.:. � :; , � �� ► � � x�: � x��._, 1 K, �����` � _ / ���� �;.* ' � � � i ,�,�r,� J�°� � �,� .. x � .. � _ 'r4 _ � . �� � � x,.�� � 6„�i � ... � �� •h � }}�� � 4 � ��«�� � k �'`Cs �����'�' � � `�'�° ��:� Mt. �,°_ �,� - " q�XS�:'1 E�'�`�� }w��' ��' � _���,,- x t.�. 4 t ye yk° � -;�. '�S�r'�� , � , 'c... . .�.a, u ,._. ��� �1 •`��. ���4 . . � `. _ _.— _ _-_ Page 1131 of 1264 WATER DISTRIBUTION ■ ■ Water Main Break Response 150 137 125 117 105 100 85 84 75 74 �� 75 53 54 50 25 0 � FY'14 FY'18 FY'19 FY'20 FY'21 FY'22 FY'23 FY'24 FY'25 FY'26 YTD �Water Main Break Response Page 1132 of 1264 EMERGENCY NOTIFICATIONS ■ ■ A � �RT Alert lowa The City of Dubuque uses Alert lowa; a free emergency notification service that allows local emergency officials to notify IOWADubuque County residents and businesses by telephone, cell phone, text message, email, social media, and the Smart 911 mobile alert app of emergency situations and time-sensitive news. This is in addition to traditional means of communication used by the City of Dubuque and Dubuque County. Alert lowa is used to notify residents and stakeholders of important issues, including: • Emergency Evacuation Notices • Natural Disaster Response • Boil Water Advisories � Public Health Crisis � Smart 911 t Smart911 is a free, optional service to Dubuque and Dubuque County residents_ It allows residents to create a S m a�911 TM "safety profile" for their household or business that can include information they may want 9-1-1 dispatchers and first responders to have in the event of an emergency Page 1133 of 1264 WAT E R DISTRIBUTION � � � � � *FY 2026 to date: ' 180 Service Taps � � • � New Connections result from � community growth '"� � � — � � • such as new housing, , businesses, and � � industry. � . � , -..- - . .- WATE R DISTRIBUTION � • � „ . , . : � � � . . • . � � � � , � � Starting in FY20, the . � � � � Water Distribution Meter Crew assumed full " ' - - • . responsibility for: , „ � • Meter repairs � � � • Testing � � � • Change-outs � � � • Service calls � . . -..- . .- Backflow Prevention Program ■ � _ _ I � , _ . - ,�,. � . 'i . �t�7�- r � _ � � • �. V!. I. Administered internally. ��� �Wn� , � ,- /7 r ��, .�~�� � �� � ��-- �R • Administrative fee $25/device. � °�{ �� co � -��- � * ( ; ��-:-�=c: � j� , ,� � �]�� .r �"` ' 1 ' -■ ;'� �: �o� �',..� , � �� ( J� • FY2026 Revenue to Date: i"�-- ��� - ���_ ���r1; I ,,� �; - � � $81 ,975 � � . - � � � '� .����` � \ y ..,� ��.\ ` ^� � - � � 3,364 devices tracked � �' � j �.��`- � �i , �_�- ;-_ � _ ,�. , '� ^ „�� F.�., ,•�. , ♦ �-; , - / ,\ _a � . ` ��l � � . ;=-��;: - _ � �, . � _ �. l -�, - , , i :4:. . ��^��,' /d. . ..� y� \ +�. a Jeff Mills performs backflow recertification testing Page 1136 of 1264 � 1 . Additional Operating Funds for the addition of a next-generation GPS � • , , antenna and tablet to support reliable and accurate mapping of underground Water Department infrastructure. This enhanced capability . . � improves asset management and ensures infrastructure data remains up to date and easily accessible across departments. . � Estimated Cost: $9,626 (Recurring) 2. Additional Operating Funds for the printing and mailing of the annual EPA- required Public Notice to customers with service lines identified as Unknown, Lead, or Galvanized Requiring Replacement under the EPA's Lead and Copper Rule Improvements (LCRI).. Estimated Cost: $4,000 (Recurring) 3. Additional Operating Funds for Cold-weather and high-visibility safety gear for staff who must perform outdoor tasks or respond to incidents in inclement weather or high-traffic areas, including water main breaks, construction site visits, and other field-related job activities. Estimated Cost: $850 (Recurring) Page 1137 of 1264 FY 27 CAPITAL IMPROVEMENT PROJECTS - . . . - , . . Private Lead Service Line Replacement Program $ 1 ,100,000 $ 5,000,000 Public Lead Main Replacement Program $ 330,000 $ 540,000 Water Storage Rehabilitation Program $ 275,000 $ 275,000 Water Distribution System Master Plan $ 200,000 $ 200,000 Emergency Generators - Park Hill & Mt. Carmel $ 200,000 $ 200,000 Water District Metered Zone (DMZ) Pilot Program $ 180,000 $ 180,000 Distribution System Monitoring/Flushing Stations $ 150,000 $ 150,000 Fire Hydrant Stock $ 140,250 $ 140,250 Water Meter Replacement Program $ 137,550 $ 137,500 Vehicle 4903 Replacement $ 130,000 $ 130,000 Page 1138 of 1264 FY 27 CAPITAL IMPROVEMENT PROJECTS - . - . . - . - . . Vehicle 4908 Replacement $ 130,000 $ 130,000 Municipal Services Center Roof Replacement $ 113,201 $ 115,000 Wells, Well Field, & Well Transmission Piping Repair & � 110,500 $ 110,500 Rehabilitation Program Creek Crossing Water Main Restoration $ 91 ,500 $ 91 ,500 Water Main Extension Pennsylvania Ave $ 80,000 $ 80,000 N Grandview Ave Water Main Repairs $ 80,000 $ 80,000 Vehicle 4920 Replacement $ 80,000 $ 80,000 Central Ave/White St Water Utility Improvements for the � 75,000 $ 75,000 Traffic Study Implementation Plan WTP South Plant Flow Meter Replacement $ 60,000 $ 60,000 Leak Detection Correlator Replacement $ 35,000 $ 35,000 Page 1139 of 1264 PERFORMANCE MEASURES Goals Improving: Goals that are on track: # of Breaks per 100 miles of # of Regulatory Compliance Pipe Violations, Target Zero (0) O&M Costs for Water # of Completed Annual Training Distribution per 100 miles of hours to support CEUs, reported p�pe in staff hours Operation of 25% of % of Projects Completed within Distribution System Valves the Program Budget Annually Page 1140 of 1264 TELEGRAPH HERALD a` 1 � =°- ,.. .. . ,y,J4�'\yf.''l`�!,l� Q YI� Duties after dark: Dubuque overnight workers n� share varied ex eriences .T :�w`�� � � � p � � � ; � . .. N� ��: .� .-:.�..: ++- .. . �. �. . ..� .�, .�, , ,�.. .. � . . ., � . .�f• ' �' k(;��,�,�i`:•_ ,.. i .r. � r , . ... +".;..,. ��� �„fybi��,�.wl ;,• '� �y .�' s� '�� �y. �.. q %a . . ""�; � �"`R��-'�' � .�.. R.•g. � - :.y �\ Y�. ."� ._�f''�y' � 'R�r �� �,_ ^ S �I ��4� R'1� �"''. 1 � � �{'"" �'i� '~i��'��_N� F � �'.�' ` -t �' tR. . .��(� �""� '� t: � +f, �, ?�� �� f.,; �� r �'..�� `!�'� � -� r �� .. r� ,t ��. ►��,, ..:w,.. ,.,:.� ,.. �. . , ' � ` I � � �j� '�t'4wf '9 . r' I ( � �Q , Y : .`.•. ' , � �� � '�l , .. � . _ � Y�� � �`�.� �: � .,,� ,�, ;". „�' �:M1 V +�� � ��. rt�'k :�.,,�. i�,r ' x : .�?r +� r� ��„��1(('',�� � �,`�, �� � �� ��Y �� " I � •I�i�� , � ; .r ,� A,�� �.. � , , . i�} � � • y �: ,�.' � .��. , ., t!.t. �,i�.,. ` '� �,��� ,''_ _ � �� .•� . p. � ` ^ ► :� � i - � ,?+rt,'"'" ; � '� �•� :� ` • � � � ,5.� w .t ;'" . �� ` �, 'i I � w�: ,�� '�AI:��"'' /R"� ti:' '.� ��'� � �� *�`�� � r~ 1 ��� �, �,��, _ .� �.. !!�: �,, �,., � ti�� �` , - , , �, �� ' `� � � h.1 , � "1'i.,. ...:�_4is._�• �"�.�. �� i � � �1 �; •aY'4 � .f.� , � �' "Water treatment plant operators such as Stelken perform more than 200 tests each day to - � _ .1 ,�- , ..�.�f`, monitor water quality and verify that treatment processes are functioning properly." - � , � ��� ,�„�� � ' � __ � �• i�� !��- i 1f ,` -� Courtesy of the Telegraph Herald, Erik Hogstrom. ��,�, � �. I �- � "' „� Permission to use this content has been ranted b the Tele ra h Herald. �:���� " � J Y 9' P t ,� . � � .� , � � � , � H y ` =� a � � ` f f ���` _'�' • . ' , � _ ��' � Page 1141 of 1264 �-a�" _��.�r�l+. •t .�,�`� � '.��,. . � . '�i� ,.. � `� r; www.cityofdubuque.org/water e� � � Page 1142 of 1264