Loading...
Water Fiscal Year 2025 Budget Presentation Copyrighted April 8, 2024 City of Dubuque Public Hearings # 02. Special Meeting ITEM TITLE: Water Fiscal Year 2025 Budget Presentation SUMMARY: SUGGESTED DISPOSITION: ATTACHMENTS: Description Type Policy Budget Book Staff Memo PowerPoint Presentation Supporting Documentation HOW TO USE THIS POLICY BUDGET DOCUMENT PURPOSE The Policy Budget defines goals and objectives for all City departments and activities, relates them to cost and resource requirements and attempts to establish measures for evaluating accomplishment. Specific improvement packages are developed and included in the Policy Budget for alternative funding and service levels. The Policy Budget document shows the budget by line item for each Department and provides a basis for fiscal control once the budget is adopted. The Policy Budget emphasizes objectives, accomplishments, and alternative funding and service levels and is intended to keep the attention of the City Council and public on the major policy decisions involving what services the City government will provide, who will pay for them, and the implications of such decisions. FORMAT The Policy Budget is organized by Department/Division and provides detail for all activities that make up each Department/Division. Each Department/Division tab includes the following information: 1) Department/Division Financial Summary: The budget highlights portion of the Department Summary reflects total expenses for the maintenance level budget (cost to continue at the same level of service) and approved improvement packages for all activities within the Department by expenditure category (employee expense, supplies and services, machinery and equipment, and debt service), and the funding sources that pay those expenses. The property tax portion of the funding is reflected, noting the increase or decrease from the prior years adopted budget. For Departments which are self supporting (i.e. Water, Water Resources & Recovery Center, Refuse and Salt Operations (part of Public Works), Media Service, Transit, Parking, Stormwater (part of Engineering)), the net operating surplus/deficit is reflected, noting the increase or decrease in the fund from the prior years adopted budget. This summary displays all Improvement Packages submitted by Department/Division Managers, with a notation of whether they were recommended by the City Manager, and then approved by the City Council. Those noted with a `YES' were added to the maintenance level budget and are reflected in the Department Funding Summary and those noted with a `NO' were not approved. And finally, this summary explains significant line item detail by expenditure category, notable revenue changes, and miscellaneous information regarding the maintenance level budget. These are the review notes prior to adding any improvement packages. 2) Memo Addressing Budget Issue (optional): If there is an important budget issue that needs further explanation, a memo will be provided. 3) Department's Organizational Chart (optional): Shows how a Department is structured. Usually included for larger more complex Departments. -i- 4) Department/Division's Highlights of Prior Year's Accomplishments and Future Initiatives: This is a written narrative that highlights the Department's prior year accomplishments and what Departments plan on accomplishing in the near future. 5) Department/Division's Goals and Performance Measures by Activity: This is a written activity statement and a matrix for each activity which includes activity objectives, relationship to City Council Goals & Priorities, and key performance indicators (KPIs). Performance measures are included for each activity to evaluate activities and ensure that the approved levels of funding yield the expected results. Icons for each KPI visually indicate how well an objective is doing and represent the following: Goal Met Goal in Progress Goal Not Met The goal has not This goal has not This goal has been been met but is been met and is not met. showing signs of currently showing improvement. signs of progress. 6) Recommended Operating Revenue Budget by Department/Division: This report reflects line item revenue detail at the Department/Division level (combines all activities for each line by fund). Two years actual revenues, prior year adopted revenues and the recommended revenue for the new budget year are reflected. 7) Recommended Operating Expenditure Budget by Department/Division: This report reflects line item expenditure detail at the Department/Division level (combines all activities for each line by fund). Expenses are grouped by category (employee expense, supplies and services, machinery and equipment, debt service, and transfers) and displays two years actual expenses, prior year adopted expenses and the recommended expense for the new budget year. 8) Recommended Operating Expenditure Budget by Activity and Funding Source: This report reflects expenses grouped by category (employee expense, supplies and services, machinery and equipment, debt service, and transfers) for each activity within the Department/ Division, and displays two years actual expenses, prior year adopted expenses and the recommended expense for the new budget year. 9) Personnel Complement at Department/Division and Activity Level: These reports reflect positions budgeted at the Department/Division level and the Activity level, by funding source. Total Full Time Equivalents (FTE) and wages with longevity expense are shown for each position for two years prior year adopted FTE and expenses, and the recommended FTE and related expense for the new budget year. 10) Capital Improvement Projects by Department/Division: This report lists all Capital Improvement Project totals for two years actual expenses, prior year adopted expenses and the recommended expense for the new budget year. 11) Five Year Capital Improvement Program Summary by Department/Division: This report lists all Capital Improvement Projects budgeted in the new budget year and planned for the next four years. Reference: Key Terms for Understanding Dubuque's Budget, Budget Glossary Budget Overview and Budget and Fiscal Policy Guidelines located in Citizen's Guide -ii- Water Department -3- This page intentionally left blank. -4- WATER DEPARTMENT FY 2023 FY 2024 FY 2025 %Change From Budget Highlights Actual Budget Requested FY 2024 Budget Expenses Employee Expense 2,556,045 2,700,384 2,826,257 4.7 % Supplies and Services 3,228,326 3,548,883 3,821,759 7.7 % Machinery and Equipment 605,117 788,130 776,600 (1.5)% Administrative Overhead Recharges 452,767 1,369,331 2,005,611 46.5 % Engineering Water Maintenance Charges 56,268 50,182 64,109 27.8 % Payment in Lieu of Taxes 142,884 142,884 142,884 — % Payment to Construction Fund 1,000,000 1,000,000 60,000 (94.0)% Debt Service 2,499,952 2,689,548 3,001,623 11.6 % Total Expenses 10,541,359 12,289,342 12,698,843 3.3 % Resources Operating Revenue 11,276,960 12,336,834 12,678,637 2.8 % General Fund - Rate Subsidy 21,687 25,000 24,593 (1.6)% Total Resources 11,298,647 12,361,834 12,703,230 2.8 % Net Operating Surplus (Deficit) 757,288 72,492 4,387 -68,105 Personnel -Authorized FTE 26.07 27.07 27.07 Water User Fee Rate Increase 5 % 8 % 12 % Revenue 1% Rate Increase Generates $ 98,689 Improvement Package Summary 1 of 1 This improvement level decision package request is for a vehicle for the use of the maintenance and administrative staff at the Eagle Point Water Treatment Plant. Use and benefits of the vehicle would be in maintenance at the Pump Stations, including but not limited to, delivering bulk sodium hypochlorite liquid, changing reagents for the chlorine analyzers, well sampling and measurement, distribution system sampling, safety and security inspections at the tanks, towers, and delivering parts as necessary to each of the nineteen (19) remote facilities of the treatment and pumping operations. A third vehicle will reduce the wait and response time for maintenance and administrative staff to perform their work and improve overall efficiency within the group. Based on the current prices provided by the Fleet Maintenance Supervisor, this vehicle is estimated at $78,000. This decision package directly relates to the City Council Goals: Financially Responsible, High-Performance City Organization: Sustainable, Equitable, and Effective Service Delivery. Related Cost: $78,000 Water User Fees Non-Recurring Recommend - No Net Cost: $78,000 Water Rate Impact: 0.93 % Activity: Plant Operations -5- Significant Line Items Employee Expense 1. FY 2025 employee expense reflects a 5.00°/o wage package increase. 2. The lowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2024. The employee contribution of 6.29% is unchanged from FY 2024. 3. The City portion of health insurance expense is unchanged from $1,119 in FY 2024 to $1,119 in FY 2025 per month, per contract, which results in an annual cost unchanged of$33,148 or 0.0%. 4. Overtime is unchanged from $94,040 in FY 2024 to $94,040 in FY 2025 . FY 2023 actual was $143,304. 5. Five-Year Retiree Sick leave payout is increased from $11,094 in FY 2024 to $15,928 in FY 2025. 6. 50% Sick Leave Payout increased from $3,585 in FY 2024 to $4,072 in FY 2025 based on FY 2024 actual to-date. 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 $969,299 in FY 2024 to $973,564 in FY 2025 based on FY 2023 actual of $886,670 plus 9.8%. This increase is due to rate increases for non-residential services from electrical providers.Alliant Energy has notified the City of an 11.5% rate increase that will take effect starting partway through FY 2025 in October of 2024. 8. Sales Tax Expense decreased from $545,649 in FY 2024 to $510,804 in FY 2025 based on FY 2023 actual expense of$450,444 plus an increase in water rates of 8% in FY 2024 and 12% in FY 2025. This expense is directly offset by sales tax revenue. 9. Chemicals increased from $622,500 in FY 2024 to $666,500 in FY 2025 based on expected cost increases from vendors and recent chemical contract costs. Chlorine is unchanged from $90,000 in FY 2024 to $90,000 in FY 2025. Lime increased from $400,000 in FY 2024 to $425,000 in FY 2025. Carbon dioxide increased from $30,000 in FY 2024 to $38,000 in FY 2025. Fluoride is unchanged from $15,000 in FY 2024 to $15,000 in FY 2025. Phosphate increased from $75,000 in FY 2024 to $86,000 in FY 2025. Polymer is unchanged from $12,500 to $12,500 in FY 2025. 10. Hauling Contract increased from $330,000 in FY 2024 to $350,000 in FY 2025 based on FY 2024 actual price per ton of$12.80.The FY 2023 actual price per ton was $11.60. 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 2025. The FY 2023 actual expense was $279,050. 11. Other Professional Services is unchanged from $145,200 in FY 2024 to $145,200 in FY 2025. This line item includes consulting services for staff training ($35,000), environmental testing fees ($37,200), fire hydrant painting ($5,000), service line assistance ($35,000), the water leak survey ($18,000), and water storage tank inspections ($15,000). 12. Technology Services decreased from $104,832 in FY 2024 to $104,342 in FY 2025 due to Water Distribution no longer using an AutoCAD software. In FY 2025, this line item includes the following items: -6- Software FY 2025 Water Administration Laserfiche License 282 Water Meters Tokay Software 10,000 WaterSmart 32,000 Neptune360 (50%) 24,000 Computer Tablet Internet Service (2) 720 Water Plant Operations SCADA Tech Support For Rockwell Software 4,900 Hach Wims And Access Technologies 31,000 Water Distribution Computer Tablet Internet Service (3) 1,440 Total Software $104,342 13. Valves/Fittings increased from $142,266 in FY 2024 to $225,447 in FY 2025 based on FY 2023 actual. This line item represents the purchase of water pipe, special fitting, 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 ($48,823) and Connection Fees - Large Service ($21,853) that covers 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. The FY 2023 actual expense of$225,447 reflects those cost increases. 14. Property Insurance increased from $104,741 in FY 2024 to $168,147 in FY 2025 based on information received from lowa Communities Assurance Pool (ICAP). Machinery 8� Equipment 15. Equipment replacement items at the maintenance level include ($776,600): Water Machinery and Equipment Water Distribution System Hydrants $ 96,000 Gas Generator $ 2,400 Tapping Machine $ 8,000 R2 GPS $ 8,000 Shop Vac $ 1,000 Whacker Compactor $ 4,700 Air Hammer/Drill $ 3,500 Annual Maintenance Projects Pump Replace Vacuum Filter $ 15,000 Annual Maintenance Programs $ 638,000 Total Equipment $ 776,600 -7- Debt Service 16. Annual debt service reflects repayment to ($3,001,623): Final Call Amount Debt Series Source Purpose Payment Date $ 59,640 SRF 2007A Water Fees Clear Wells 2028 $ 217,745 SRF Series 2009 Water Fees Meter Change-Out 2031 $ 428,700 Revenue 2021C Water Fees Water Improvements 2030 2028 $ 108,236 G.O. 2018A Water Fees Water Improvements 2031 2026 $ 37,899 G.O. 2021A Water Fees Water Improvements 2032 2028 $ 137,343 G.O. 2021A Water Fees Water Improvements 2033 2026 $ 653,300 G.O. 20121A Water Fees Water Improvements 2032 2028 $ 41,688 G.O. 2016C Water Fees Water Improvements 2033 2024 $ 673,960 SRF 2017 Water Fees CIWA Purchase/Imp 2036 $ 269,080 SRF 2019 Water Fees Roosevelt Water Tower 2038 $ 105,826 SRF 2021 Water Fees Water Improvements 2041 FY25 Planned $ 268,206 Debt Water Fees Water Improvements 2045 $3,001,623 Total Water Annual Debt Service Revenue 17. Water User Fees increased from $10,996,706 in FY 2024 to $11,191,345 in FY 2025 based on FY 2023 actual of$9,868,911 plus an increase in water rates of 8% in FY 2024 and 12% in FY 2025. 18. Flat Rates decreased from $57,706 in FY 2024 to $34,490 in FY 2025. FY 2023 actual was $34,490. This charge is for customers purchasing bulk water. Rates are set by City ordinance. 19. Fire Protection Rates increased from $196,324 in FY 2024 to $207,151 in FY 2025 based on FY 2023 actual of$207,151. This fee is the demand charge for fire sprinkler head connection. The rates are set by City ordinance. 20. Taps revenue is increased from $33,147 in FY 2024 to $48,823 in FY 2025. FY 2023 actual was $15,702. 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 were calculated as a three year average. 21. Tap Service increased from $9,246 in FY 2024 to $21,853 in FY 2025. FY 2023 actual was $36,082. This fee is charged to customers for 2" taps and represents the actual cost of labor and materials. The rates are set by City ordinance, and the projections are calculated by a three year average. 22. Connection Charge Front Footage is decreased from $77,788 in FY 2024 to $67,860 in FY 2025. This is based on FY 2023 actual of$67,860. 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. 23. Backflow Prevention Administrative Fees increased from $75,832 in FY 2024 to $76,643 in FY 2025 based on actual number of accounts. FY 2023 actual was $76,643. This includes the $25 annual fee charged to all customers with a backflow device. -8- 24. Penalties for late payments increased from $45,980 in FY 2024 to $98,465 in FY 2025 based on FY 2023 actual of$98,465. 25. Tower Monthly Rental increased from $145,557 in FY 2024 to $156,526 in FY 2025 based on water lease contract amounts. FY 2023 actual was $156,526. 26. Sales Tax Collected decreased from $545,649 in FY 2024 to $510,804 in FY 2025 based on the rate increase of 12°/o for water fees from FY 2023 actuals and accounting for the rate increase in FY 2024 and proposed FY 2025 rate increase. This line item off-sets the sales tax expense. -9- W�ter�epartment Drg Ch art�YZ5 (27.�7 FTF) Water�epartment airector (1.6 FTE) ConfidentialAccount I Clerk (lA FTE) �istri6ution Supervisar E�eringAssistant GIS Specialist ❑perations Supervisor (1.0 FTE) (1A FTE) (1.0 FTE) (1.0 FTE' �istributionMaintenanc2 �istributionMaintenance GI55easonallntern WaterPlant4perators 5uperuisor 5uperuisor (1.4 FTE} (1.4 FTEE (4.5 FTE} (6A FTE} EquipmentOperatorl MeterRepairWorkerl I IndustrialElectrical Technician (1.0 FTE} (1.0 FTEE (1.0 FTE) WaterOistri6ution WaterOistri6ution Maintenance Workers Maintenance Workers EquipmentMechanic (6.6 FTE) (2.5 FTE' (1.0 FTE} -10- 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 PLANNIN� The 1�Vater Department is engaged in PE�PLE �����ientious, strategic planning which allo�+vs for maintaining compliance with the Emplo�rees of the �Ilater state and federal regulatory agencies in Department are provided training order to pro�ide the highest qualit�r, safe to ensure the maintenance of the and �ost eff�c#ive drin�Cing wat�r possible. apprapriate licenses required b� the lowa Department of Natural _ _ � _�' "�'�"� ,�,�� Resources. �ther job-related � = : �' = , ._�_. . . �. educativnal training is provided .,�µ �.� ; ,� : , • �,.'t �.�. ��� -, w�_.�����+� �::�:��-���� . t❑ broaden emplo�ree s�Cills and �-. . , �.� �--�=-.� -�- '" ����� � increase praduct�vit�r. ����,��-. �,�: : � �' - � , .�;..� �- e-�' �� � � - - � � } _. �". PAF�TNEF�SHIP� The 1Nater Department is in�olved in �ommunit�r �ctivitieslPartnershipsl �utreach pra�rams such as 1�Vater Conservation Educational Program and the �marter �it�r Initiative. The VlJater Department pro�ides tours of its Eagle Point Treatment Plant to local schools and organi�ations. -11- WATER DEPARTMENT FY 2023 FY 2024 FY 2025 Full-Time Equivalent 26.07 27.07 27.07 Resources Support $15,000,000 $11,276,960 $12,336,834 $12,678,637 $10,000,000 $5,000,000 $0 Operating Revenue � FY 2023 FY 2024 FY 2025 The Water Department is supported by 27.07 full-time equivalent employees, which accounts for 22.26% of the department expense as seen below. Overall, the department's expenses are expected to increase by 3.33% in FY 2025 compared to FY 2024. Expenditures by Category by Fiscal Year $6,000,000 $4,000,000 $2,000,000 , � $0 m cn m D c � C) p m � C � Q � � o CD � � � � � � � � � `� CD � � W O C C�D C�D CD � CD � — � v G — � � Ill Q � 3 CQ. � � cQ. x � � � n Q v m �� � m cn � � FY 2023 FY 2024 FY 2025 -12- 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 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $5,033,866 $6,518,617 $6,532,435 Resources $— $— $— Water Administration Position Summary FY 2025 Water Department Manager 1.00 Water Distribution Supervisor 1.00 Water Engineering Assistant 1.00 Water Operations Supervisor 1.00 Confidential Account Clerk 1.00 GIS Specialist 1.00 GIS Intern 0.50 Total FT Equivalent Employees 6.50 Performance Measures Performance Measure(KPI) Target FY 2022 FY 2023 FY 2024 Performance Actual Actual Estimated Indicator 1 Activity Objective: Maintain a financially-viable water utility. #of hours that staff are completing annual training (hrs)to support CEUs and 20 35 37 35 Goal Met professional development in emergency response Reduction of Water Quality Issues per �20 15 16 15 Goal Met 100 miles of Pipe % of lost/unaccounted for water <18% 17.9% 25% 18% Goal In Progress % of projects completed within the 100% 100% 100% 100% Goal Met program budget Operating cost coverage for water(Total operational Revenue/Total Operating > 1 1.3 0.8 1.0 Goal Met Cost) -13- 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 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 '' - . . r . 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. - - • .• . . . . FY 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $3,029,578 $3,185,155 $3,325,166 Resources $295 $72 $— � .- . . • . . FY 2025 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 Performance Measures City Council Goal: Sustainable Environment Performance Measure (KPI) Target FY 2022 FY 2023 FY 2024 Performance Actual Actual Estimated Indicator � Activity Objective: Provide water treatment and distribute high-quality, clean drinking water that meets or exceeds drinking water regulations. #of Regulatory Compliance as No 0 0 0 0 Goal Met Violations Water Plant Process Efficiency measured as Water Treated vs Produced(MGD 1.10 0.94 1.03 1.00 Goal Not Met Treated/MGD Produced) Cost Effectiveness of the Treatment < 1.00 0.94 1.07 1.00 Goal Met Process (O&M Cost/MG, thousands) The 2023 Water Quality Report can be downloaded at: https://www.cityofdubuque.org/waterqualitX -14- WATER DEPARTMENT �ate�" Iljc�rih� �finn 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 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $1,521,671 $1,263,173 $1,460,222 Resources $11,170,268 $12,225,628 $12,518,422 � . . - . . FY 2025 Equipment Operator II 1.00 Water Distribution Maintenance Worker Supervisor 1.00 Water Distribution Maintenance Worker 6.00 Custodian I 0.07 Total FT Equivalent Employees 8.07 Performance Measures Performance Measure(KPI) Target FY 2022 FY 2023 FY 2024 Performance Actual Actual Estimated Indicator 1 Activity Objective: Ensure the integrity of the distribution system piping system. #of breaks per 100 miles of pipe <15 33 25.52 30 Goal Not Met Operation of 10% of system valves g08 215 616 808 Goal Met annually Hydrant effectiveness (out of service rate) <1% <1% <1% <1% Goal Met <1% or 25FH O&M costs for water per 100 miles of pipe <343*'` 403 457 379 Goal In (thousands per 100 miles) Progress "Based on 3 year running average 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 332.95 miles of public water mains ranging in diameter from 4" up to 30"; 8,078 control valves; and 2,646 fire hydrants. -15- 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 2023 Actual FY 2024 Budget FY 2025 Recomm'd Expenditures $374,562 $536,215 $568,343 Resources $128,084 $132,184 $184,808 Water Meters Position Summary FY 2025 Water Meter Repair Worker I 2.00 Water Distribution Maintenance Worker 1.00 Water Distribution Maintenance Worker Supervisor 1.00 Water Distribution Maintenance Worker PT 0.50 Total Full-Time Equivalent Employee's 4.50 Performance Measures Performance Measure(KPI) Target FY 2022 FY 2023 FY 2024 Performance Actual Actual Estimated Indicator � Activity Objective: Minimize the possibility of contamination in the distribution through the installation of backflow prevention devices. High and Low Hazard Containment Goal In Services, by definition, to participate in the 100% 98% 99% 99% Progress backflow prevention program City Council Goal: Financially Responsible, High-Performance Organization � Activity Objective: Respond to customer inquiries in a timely manner to maintain consumer confidence in the water utility. Respond to technical Meter Department 100% 100% 100% 100% Goal Met service issues. Enhanced meter reading accuracy, larger users: O&M on all large meters (>3") per 5% 11% 15°/o 5% Goal Met AWWA standards (Ig meter/yr) -16- � Recommended Operating Revenue Budget - Department Total � 42-WATER FY22 Actual FY23 Actual FY24 Adopted FY25 Recomm'd Fund/AccounUAccount Title Revenue Revenue Budget Budget 600-Water Operating 4A-Charges for Services 41380-Water/Sewer Permit (144,393) (156,526) (145,557) (156,526) 45090-Mctcr Ratcs (9,464,186) (9,868,911) (10,996,706) (11,191,345) 45095-Fire Protcction Rates (191,821) (207,151) (196,324) (207,151) 45100-Flat Rates (41,714) (34,490) (57,706) (34,490) 45105-Unapplied Credits (23,071) (4,620) (23,071) (4,620) 45125-Meter Sales-Remotes (13,609) (10,993) (13,609) (10,993) 45126-Melers-Sales (28,917) (26,134) (28,917) (82,858) 45127-UFR Device-Sales (2,938) (2,648) (2,938) (2,648) 45128-Meter Repair (10,409) (10,491) (10,409) (10,491) 45129-Stop Box Parts 0 0 0 0 45234-UB-Watcr Repair Grt Temp Hold 200 0 0 0 45300-Farfeitures/Penalties (45,980) (98,465) (45,980) (98,465) 45325-MeterTamperingFee (741) (631) (741) (631) 45350-Shut OffPenalties (9,965) (13,394) (9,965) (13,394) 45400-Connect Fees (75,832) (76,643) (75,832) (76,643) 45410-Connect Fee Large Svc (15,340) (36,082) (9,246) (21,853) 45415-Connect Fee Front Footage (63,417) (67,860) (77,788) (67,860) 45420-Taps (63,850) (15,702) (33,147) (48,823) 45500-Misccllaneous Chg for Svcs (8,978) (10,959) (8,978) (]0,959) 45520-C�stomer Credits 0 0 0 0 47100-Reimbursements (4,000) (2,673) (4,000) (50) 4�i so-xer�nas �s�� (a4o� o 0 47200-Tnsurance Settlements (13,834) (16,010) (13,466) 0 47450-Sale of Salvage (1,771) (23,334) (1,386) (1,314) 4A-Charges for Services Total (10,224,623) (10,684,158) (11,755,766) (12,041,114) 4B-Grants/Contrib 44400-Statc Grants - - - - 4B-Grants/Contrib Total 4K-Unrest Invest Earn 43000-Interest (25,600) (126,719) (35,419) (126,719) 4K-Unrest Invest Earn Total (25,600) (126,719) (35,419) (126,719) 4N-Transfers 49100-Transfer In General Fund (22,352) (21,687) (25,000) (24,593) 4N-Transfers Total � (22,352) (21,68'� (25,000) (24,593) 40-Eliminated for GW 47115-Sa1es Tax Collection (494,920) (466,083) (545,649) (510,804) 48200-Proceeds from GO Debt (3,505,000) 48205-Bond Discount/Premium (181,304) 48250-Proceeds from SRF (1,030,000) 40-Eliminated for GW Total (5,2ll,224) (466,083) (545,649) (510,804) WATER-Total (15,483,799) (11,298,64� (12,361,834) (12,703,230) -17- � Recommended Operating Expenditure Budget - Department Total � 42-WATER FY21 Actual FY22 Actual FY23 Adopted FY 24 Recomm'd Fund/AccounUAccountTitle Expense Expense Budget Budget 6A-Salaries&Wages 600-Water Operating 60100-Salaries-Regular Full Time 1,448,555 1,638,562 1,797,372 1,869,ll5 60200-Salarics-Rcgular Part Time 16,368 17,690 31,726 32,073 60300-Hourly Wagcs-Temp/Scasonal 710 3,438 16,784 17,693 60400-Overtime 129,894 143,304 94,040 94,040 60410-Overtime-Holiday 24,050 29,427 17,000 17,000 60630-Special Pay Sick Lv Payout Ret 31,935 12,251 11,094 15,928 60635-Special Pay Sick Lv Payout 50% 3,055 3,878 3,585 4,072 60640-Special Pay-Vacation Payout 8,R90 7,439 0 0 60710-Special Pay-Parental Leave 0 13,049 0 0 60720-Spcc Pay-Mcals No Overnight 82 33 50 0 60730-Spcc Pay-Safety Equipment 3,802 3,220 5,500 5,500 60740-Spec Pay-Meal Allowance 1,055 649 2,000 1,200 60780-Spec Pay-Tank Climb Pay 30 30 1,200 1,200 6A-Salaries&Wages Total 1,668,427 1,872,971 1,980,351 2,057,821 6B-Employee Benefits 600-Water Operating 61100-FICA-City Contribution 120,057 135,259 149,800 156,912 61300-1PERS-City Contribution 152,637 173,953 184,845 191,737 61510-Health Insurancc 332,464 328,864 342,696 375,844 61540-Life Insurance 964 1,174 1,196 1,334 61600-Workers'Compensation 48,369 43,396 40,389 42,100 61992-Physicals 1,107 428 1,107 509 6B-Employee Benefits Total 655,598 683,074 720,033 768,436 6C-Staff Development 600-Water Operating 62100-Association Ducs 2,298 3,413 5,770 4,102 62200-Subscriptions 0 484 540 300 62325-Mileage 1,928 4,012 4,724 5,124 62400-Meetings&Conferences 473 3,897 5,350 5,350 62500-Education Reimbursement 20,345 12,988 20,797 18,750 6C-Staff Development Total 25,044 24,793 37,181 33,626 6D-Repair/Maint/Util 600-Water Operating 63100-Building Maintcnance 49,910 58,089 49,910 96,773 63312-Vehicic Ops-Gasoline 38,973 37,436 29,380 35,898 63320-Vehicle Repair-Internal 40,678 30,861 45,625 44,764 63321-Vehicle Repair-Outsourced 3,164 15,348 6,920 15,655 63322-Vehicle Repair-Accident 0 0 0 0 63400-Equipment MainURepair 57,990 61,830 61,918 78,067 63425-Meter Maintenance 392 1,380 2,000 2,000 63430-[nstrument Maintenance 29,704 1,048 30,298 29,704 63710-Elcctricity 768,106 886,670 969,299 973,564 637ll-Natural Gas 46,462 59,758 53,580 59,853 63730-Telecommunications 22,048 23,398 25,798 14,352 63742-Stormwater 1,460 1,490 1,557 1,702 63790-Other Utility Expense 9,779 418 15,000 15,000 6D-Repair/MainUUtil Total 1,068,666 1,177,725 1,291,285 1,367,332 6E-Contractual Svcs 600-Water Operating -18- � Recommended Operating Expenditure Budget - Department Total � 42-WATER FY21 Actual FY22 Actual FY23 Adopted FY 24 Recomm'd Fund/AccounUAccount Title Expense Expense Budget Budget 64010-Accounting&Auditing 3,800 8,250 3,800 8,250 64020-Advertising 2,930 849 2,930 1,338 64030-Outsourced Labor 0 0 0 0 64040-Collecrions 1,452 2,197 1,452 2,197 64045-Bad Dcbt Expcnse 0 0 0 0 64062-Refunds 937 0 937 0 64080-Insurance-Property 84,648 96,628 104,741 168,147 64081 -Insurance-Liabiliry 25,199 33,169 28,064 42,422 64083-Insurance-Other 0 0 0 0 64110-Legal 27,713 0 0 0 64135-Grants 795 2,301 10,000 10,000 64140-Printing 1,982 177 1,270 1,914 64145-Copying 1,625 1,494 3,509 1,493 64150-Rental-Equipment 4,731 4,054 10,000 6,000 64160-Rental-Land/Bldgs/Parking 660 660 660 660 64175-Landfill Fees 67 7A8 152 2,2A8 64180-Sales Tax Expense 488,525 450,444 545,649 510,804 64185-License/Permit/Fees 6,860 6,921 6,860 6,921 64190-Technology Services 48,675 69,358 104,832 104,342 64191-IT Rcchargcs 0 21,172 21,743 22,658 64820-One Call 7,406 10,299 7,406 10,299 64825-Fire Suppression 1,082 242 1,082 1,700 64865-Elevator Service 2,473 2,441 2,410 2,410 64870-HVAC Services 3,570 0 3,744 3,744 64880-Custodial Services 0 0 0 0 64900-Other Professional Service 71,132 115,146 145,200 145,200 64975-Equip Maint Cont 1,944 1,823 1,944 1,823 64980-Tcchnology Equip Maint Cont 21,054 2,184 12,777 12,777 64985-Hauling Contract 267,552 279,050 330,000 350,000 64990-Other Contractual Service 0 0 6,000 6,000 6E-Contractual Svcs Total 1,076,811 1,109,648 1,357,162 1,423,387 6F-Commodities 600-Water Operating 65010-Chemicals 442,320 594,487 622,500 666,500 65040-Small Tools&F,quipment 10,403 16,595 14,379 14,679 65045-Tcchnology Equipment 5,541 16,859 4,830 0 65050-Other Equipment 49,209 22,892 50,800 138,600 65054-Safety Equipment 0 600 0 0 65060-Office Supplies L,867 7,345 3,LO1 6,819 65080-Postage/Shipping 2,407 2,429 2,658 2,621 65100-Safety Supplies 8,122 6,328 8,122 8,122 65925-Uniform Purchase 19,687 19,064 27,000 27,000 65950-Valves/Fittings 142,266 225,447 142,266 225,447 65960-Repair Parts 4,730 7,251 4,829 3,844 65965-Janitorial 4,998 4,630 5,188 5,014 65970-Lab Supplies 21,830 15,494 21,830 21,830 65975-Plumbing Supplies 67 L,220 70 70 65980-Construction Supplies 817 203 926 2,650 65981 -Street Materials 0 12,568 0 12,568 65990-Other Supplies 10,386 2,498 10,386 250 6F-Commodities Total 724,651 955,9ll 918,885 1,136,014 -19- � Recommended Operating Expenditure Budget - Department Total � 42-WATER FY21 Actual FY22 Actual FY23 Adopted FY 24 Recomm'd Fund/AccounUAccountTitle Expense Expense Budget Budget 6G-Capital Outlay 600-Water Operating 67100-Vehicles 0 133 0 0 67210-Furniturc/Fixtures 0 0 1,500 0 67230-Heavy Equipment 0 0 23,000 0 67250-Office Equipment 0 0 0 0 67270-Other Capital Equipment 0 7,898 18,000 18,000 67500-Buildings 0 0 0 0 67809-Water-Meters 97,088 22,440 0 0 67810-Water-Large Meters 18,886 50,200 200,000 200,000 67815-Water-Hydrants 30,877 91,456 70,000 0 67990-Othcr Capital Outlay 379,271 392,640 420,000 420,000 6G-Capital Outlay Total 526,122 564,767 732,500 638,000 6H-Debt Service 600-Water Operatiug 68010-Principal Payment 6,824,142 1,959,654 2,112,595 2,358,616 68020-Interest Payments 615,593 540,298 576,953 643,007 68980-Financial Consultant 31,250 0 0 0 68990-Paying Agent Fees 447 600 0 0 6H-Debt Scrvicc Total 7,471,433 2,500,552 2,689,548 3,001,623 6I-Transfers 600-Water Operating 69100-Transfers Out To C'�eneral Fund 578,l55 595,651 1,512,215 2,148,495 69601 -Transfers Out to Water Cap 400,000 1,000,000 1,000,000 60,000 6I-Transfers Total 978,155 1,595,651 2,512,215 2,208,495 WATER-Total 14,194,908 10,485,091 12,239,160 12,634,734 -2�- Recommended Expenditure Budget Report by Activity & Funding Source 42-WATER � FY25 Recomm'd Fund/Activity FY23 Actual Expense FY24 Adopted Budget Budget 0000- No Sub-Activity � 600-Water Operating 6E-Contractual Svcs 61-Transfers 1,595,651 2,512,215 2,208,495 0000- No Sub-Activity Total 1,595,651 2,512,215 2,208,495 4201- Administration 600-Watcr Operating 6A-Salarics&Wagcs 316,647 523,463 549,882 6B-Employee Benefits L07,471 170,659 174,A25 6C-Staff Development 11,760 15,500 17,000 6D-Rcpair/Maint/Util 571 1,872 3,120 6E-Contractual Svcs 500,622 604,534 577,076 6F-Commodities 592 826 414 6G-Capital Outlay - 6H-Debt Service 2,500,552 2,689,548 3,001,623 6I-Transfcrs 4201- Administration Total 3,438,215 4,006,402 4,323,940 4202- Meters 600-Water Operating 6A-Salaries&Wages 204,636 310,200 315,267 6B-Employee Benefits 79,528 ll 1,452 129,675 6C-Staff Development 3,266 5,678 5,805 6D-Rcpair/Maint/Util 28,188 24,226 31,4]5 6E-Contractual Svcs 53,026 73,289 75,761 6F-Commodities 7,256 11,370 10,420 6G-Capital Outlay 0 0 0 4202- Meters Total 375,900 536,215 568,343 4203- Plant Operations and Maint 600-Water Operating 6A-Salarics&Wages 661,756 599,276 616,222 6B-Employcc Benefits 250,075 226,074 229,006 6C-Staff Development 2,772 4,567 � 3,350 6D-Repair/Maint/Util L,014,000 1,146,637 1,15A,452 6E-Contractual Svcs 455,685 526,904 608,079 6F-Commodities 643,820 680,197 710,057 6G-Capital Outlay 133 1,500 0 4203- Plant Operations and Maint Total 3,028,241 3,185,155 3,325,166 4204- Distribution System 600-Water Operating 6A-Salaries&Wages 689,932 547,412 576,450 6B-Employee Benefits 246,000 21 1,848 234,930 6C-Staff Development 6,995 11,436 7,471 6D-Repair/Maint/Util 134,966 118,550 174,345 6E-Contractual Svcs 51,014 69,435 79,471 6F-Commodities 291,108 211,492 387,555 6G-Capital Outlay 101,655 93,000 0 4204- Distribution System Total 1,521,671 1,263,173 1,460,222 4220- Storage Tank Inspection -21- Recommended Expenditure Budget Report by Activity & Funding Source 42-WATER � FY25 Recomm'd Fund/Activity FY23 Actual Expense FY24 Adopted Budget Budget 600-Watcr Operating 6E-Contractual Svcs 0 15,000 15,000 4220- Storage Tank Inspection Total 0 15,000 15,000 4221- Meter Reading System Maint 600-Water Operating 6G-Capital Outlay 0 0 0 4221- Meter Reading System Maint Total 0 0 0 4222- Pump/Vacuum Filter Replace 600-Watcr Operating 6F-Commoditics 0 15,000 15,000 4222- Pump/Vacuum Filter Replace Total 0 15,000 15,000 4224- Fire Hydrant Painting 600-Water Operating 6E-Contractual Svcs 0 5,000 5,000 4224- Fire Hydrant Painting Total 0 5,000 5,000 4225- GIS Maint/Updates 600-Watcr Operating 6E-Contractual Svcs 0 0 0 4225- GIS Maint/Updates Total 0 0 0 4226- Service Line Assistance 600-Water Operating 6E-Contractual Svcs 0 35,000 35,000 4226- Service Line Assistance Total 0 35,000 35,000 4227- Valve Replacement 600-Watcr Operating � 6G-Capital Outlay 0 20,000 20,000 4227- Valve Replacement Total 0 20,000 20,000 4228- Internal Lines Loan 600-Water Operating 6G-Capital Outlay 0 0 0 4228- Internal Lines Loan Total 0 0 0 4229- Main Replacements 600-Watcr Operating 6A-Salarics&Wagcs � 0 � 0 0 6B-Employee Benefits 0 0 0 6F-Commodities 12,568 0 L2,568 6G-Capital Outlay 341,469 350,000 350,000 4229- Main Replacements Total 354,037 350,000 362,568 4230- Meter Exchange 600-Water Operating 6G-Capital Outlay 72,640 200,000 200,000 4230- Meter Exchange Total 72,640 200,000 200,000 4231- Leak Repair Grant 600-Water Operating 6E-Contractual Svcs 1,471 5,000 5,000 4231- Leak Repair Grant Total 1,471 5,000 5,000 4232- Valve Box Maintenance 600-Water Operating 6G-Capital Outlay 30,632 25,000 25,000 -22- Recommended Expenditure Budget Report by Activity & Funding Source 42-WATER � FY25 Recomm'd Fund/Activity FY23 Actual Expense FY24 Adopted Budget Budget 4232- Valvc Box Maintenance Total 30,632 25,000 25,000 4234- Generator Maintenance 600-Water Operating 6G-Capital Outlay 7,898 18,000 18,000 4234- Generator Maintenance Total 7,898 18,000 18,000 4235- County Water Assistance 600-Water Operating � 6E-Contractual Svcs 830 5,000 5,000 4235- County Water Assistance Total 830 5,000 5,000 4236- Water Meter Testing 600-Water Operating 6G-Capital Outlay ]0,340 25,000 25,000 4236- Water Meter Testing Total 10,340 25,000 25,000 4237- Water Leak Survey 600-Water Operating 6E-Contractual Svcs 47,000 18,000 18,000 4237- Water Leak Survey Total 47,000 18,000 18,000 4299- Pcard Clearing 600-Water Operating 6F-Commodities 566 0 0 4299- Pcard Clearing Total 566 0 0 WATER TOTAL 10,485,091 T 12,239,160 12,634,734 -23- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 42 WATER DEPARTMENT FY 2023 FY 2024 FY 2025 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61010 Full Time Employee Expense 640 3275 GE-40 WATER DEPARTMENT MANAGER 1.00 $ 100,347 1.00 $ 110,672 1.00 $ 123,030 640 3200 GE-36 WATER DISTRIBUTION SUPERVISOR 1.00 $ 96,307 1.00 $ 98,815 1.00 $ 82,390 640 - GE-36 WATER OPERATIONS SUPERVISOR 1.00 $ 74,730 1.00 $ 82,490 1.00 $ 92,084 640 2950 GE-33 WATER ENGINEERING ASSISTANT 1.00 $ 79,653 1.00 $ 83,315 1.00 $ 87,763 640 2650 GE-31 WATER METER FOREMAN - $ - 1.00 $ 75,563 1.00 $ 79,655 640 2650 GE-31 FOREPERSON -WATER DISTR. 1.00 $ 71,870 1.00 $ 75,563 1.00 $ 79,655 640 2610 GE-30 GIS SPECIALIST 1.00 $ 68,450 1.00 $ 71,598 1.00 $ 75,474 640 GE-25 CONFIDENTIALACCOUNT CLERK 1.00 $ 51,879 1.00 $ 54,716 1.00 $ 57,763 640 2400 0E-16 ELECTRONIC TECHNICIAN 1.00 $ 69,105 1.00 $ 80,844 1.00 $ 85,208 640 2800 0E-14 EQUIPMENT MECHANIC 1.00 $ 63,768 1.00 $ 66,699 1.00 $ 70,310 640 2550 0E-16 WATER PLANT OPR CERT GR III/IV 1.00 $ 65,814 1.00 $ 60,357 1.00 $ 67,131 640 0E-11 WATER PLANT OPERATOR CRT GR I 1.00 $ 56,355 1.00 $ 61,283 2.00 $ 122,081 640 2475 0E-12 WATER PLANT OPERATOR CRT GR II 1.00 $ 61,179 1.00 $ 63,992 1.00 $ 67,564 640 2475 0E-16 WATER PLANT OPERATOR CRT GR IV 3.00 $ 202,706 3.00 $ 212,716 2.00 $ 149,894 640 2305 0E-10 EQUIPMENT OPERATOR II 1.00 $ 60,167 1.00 $ 62,933 1.00 $ 66,341 640 1775 0E-09 WATER METER REPAIR WORKER I 2.00 $ 118,098 2.00 $ 124,488 2.00 $ 123,104 640 0E-14 WATER METER REPAIR WORKER II 1.00 $ 64,537 - $ - - $ - WATER DISTR MAINTENANCE 640 1476 0E-09 WORKER 6.00 $ 340,132 7.00 $ 412,309 7.00 $ 439,668 TOTAL FULL TIME EMPLOYEES 25.00 $ 1,645,097 26.00 $ 1,798,353 26.00 $ 1,869,115 61020 Part-Time Employee Expense WATER DISTR MAINTENANCE 640 1476 0E-09 WORKER 0.50 $ 26,434 0.50 $ 28,326 0.50 $ 28,490 640 2050 0E-03 CUSTODIAN I 0.07 $ 3,251 0.07 $ 3,400 0.07 $ 3,583 TOTAL PART TIME EMPLOYEES 0.57 $ 29,685 0.57 $ 31,726 0.57 $ 32,073 61030 Seasonal Employee Expense 640 NA-37 GIS INTERN 0.50 $ 16,046 0.50 $ 16,784 0.50 $ 17,693 TOTAL SEASONAL EMPLOYEES 0.50 $ 16,046 0.50 $ 16,784 0.50 $ 17,693 TOTAL WATER DEPARTMENT 26.07 $ 1,690,828 27.07 $ 1,846,863 27.07 $ 1,918,881 -24- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2023 FY 2024 FY 2025 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Water Administration-FT 64042100 61010 640 2610 GE-30 GIS SPECIALIST 1.00 $ 68,450 1.00 $ 71,598 1.00 $ 75,474 64042100 61010 640 3275 GE-40 WATER DEPARTMENT MANAGER 1.00 $ 100,347 1.00 $ 110,672 1.00 $ 123,030 64042100 61010 640 GE-25 CONFIDENTIALACCOUNTCLERK 1.00 $ 51,879 1.00 $ 54,716 1.00 $ 57,763 64042100 61010 640 2950 GE-33 WATER ENGINEERING ASSISTANT 1.00 $ 79,653 1.00 $ 83,315 1.00 $ 87,763 WATER OPERATIONS 64042400 61010 640 GE-36 SUPERVISOR - $ - 1.00 $ 82,490 1.00 $ 92,084 WATER DISTRIBUTION 64042100 61010 640 3200 GE-37 SUPERVISOR - $ - 1.00 $ 98,815 1.00 $ 82,390 Total 4.00 $ 300,329 6.00 $ 501,606 6.00 $ 518,504 Water Administration-SEASONAL 64042100 61030 640 NA-37 GIS INTERN 0.50 $ 16,046 0.50 $ 16,784 0.50 $ 17,693 Total 0.50 $ 16,046 0.50 $ 16,784 0.50 $ 17,693 Water Meters-FT 64042300 61010 640 1775 0E-09 WATER METER REPAIR WORKER I 2.00 $ 118,098 2.00 $ 124,488 2.00 $ 123,104 64042300 61010 640 0E-14 WATER METER FOREMAN 1.00 $ 75,563 1.00 $ 79,655 WATER METER REPAIR WORKER 64042300 61010 640 0E-14 II 1.00 $ 64,537 - $ - - $ - WATER DISTR MAINTENANCE 64042300 61010 640 1476 0E-09 WORKER - 1.00 $ 60,431 1.00 $ 64,326 Total 3.00 $ 182,635 4.00 $ 260,482 4.00 $ 267,085 Water Meters-PT WATER DISTR MAINTENANCE 64042300 61020 640 1476 0E-09 WORKER - 0.50 $ 28,326 0.50 $ 28,490 Total - $ - 0.50 $ 28,326 0.50 $ 28,490 Water Plant Operation-FT WATER PLANT OPERATOR CRT 64042400 61010 640 0E-11 GRI 1.00 $ 56,355 1.00 $ 61,283 2.00 $ 122,081 WATER PLANT OPERATOR CRT 64042400 61010 640 2475 0E-12 GR II 1.00 $ 61,179 1.00 $ 63,992 1.00 $ 67,564 64042400 61010 640 2550 0E-16 WATER PLANT OPR CERT GR III/IV 1.00 $ 65,814 1.00 $ 60,357 1.00 $ 67,131 WATER PLANT OPERATOR CRT 64042400 61010 640 0E-16 GRIV 3.00 $ 202,706 3.00 $ 212,716 2.00 $ 149,894 WATER OPERATIONS 64042400 61010 640 GE-36 SUPERVISOR 1.00 $ 74,730 - $ - - $ - 64042400 61010 640 2800 0E-16 ELECTRONIC TECHNICIAN 1.00 $ 69,105 1.00 $ 80,844 1.00 $ 85,208 64042400 61010 640 3015 0E-14 EQUIPMENT MECHANIC 1.00 $ 63,768 1.00 $ 66,699 1.00 $ 70,310 Total 9.00 $ 593,657 8.00 $ 545,891 8.00 $ 562,188 Water Distribution-FT WATER DISTR MAINTENANCE 64042700 61010 640 1476 0E-09 WORKER 6.00 $ 340,132 6.00 $ 351,878 6.00 $ 375,342 WATER DISTRIBUTION 64042700 61010 640 3200 GE-36 SUPERVISOR 1.00 $ 96,307 - $ - - $ - 64042700 61010 640 2305 0E-10 EQUIPMENT OPERATOR II 1.00 $ 60,167 1.00 $ 62,933 1.00 $ 66,341 64042700 61010 640 2650 GE-31 FOREPERSON-WATER DISTR. 1.00 $ 71,870 1.00 $ 75,563 1.00 $ 79,655 Total 9.00 $ 568,476 8.00 $ 490,374 8.00 $ 521,338 Water Distribution-PT WATER DISTR MAINTENANCE 64042700 61020 640 1476 0E-09 WORKER 0.50 $ 26,434 - - 64042700 61020 640 2050 GD-03 CUSTODIAN I 0.07 $ 3,251 0.07 $ 3,400 0.07 $ 3,583 Total 0.57 $ 29,685 0.07 $ 3,400 0.07 $ 3,583 TOTAL WATER DEPARTMENT 26.07 $ 1,690,828 27.07 $1,846,863 27.07 $ 1,918,881 -25- Capital Improvement Projects by Department/Division WATER Project FY 25 Recomm'd Number Capital Improvement Project Title Department Fund Account Budget 4281000001 SCADA and Communications Imp Water 601 64070 200,000 4281000013 Water Meter Replacement Water 601 65050 406,600 428 1 0000 19 Mainten Public Water Mains Water 601 67990 20,000 4281000022 Water main replc-Sewer prog Water 601 67990 190,000 428 1 0 00022 Water main replc-Sewer prog Water 601 64070 22,000 42 8 1 0 00024 Public lead line water replc Water 601 64070 50,000 4281000024 Public lead line water replc Water 601 67990 50,000 4281000026 Water Treatment Plant Plan Water 601 64070 10,000 4281000050 Private Lead Line Replacement Prog Water 601 67990 200,000 4281000050 Private Lead Line Replacement Prog Water 601 64070 267,850 428 1 00005 1 Source Water PFAS Red-Deep Water Water 601 67990 2,050,000 4281000051 Source Water PFAS Red-Deep Water Water 601 64070 250,000 Vehicle 4911 Tandem Dump Truck 4281000053 Repl Water 601 67100 174,000 4281000056 Leak Detection Correlator Replaceme Water 601 65050 25,000 4281000057 Water Treahnent Boiler Replacements Water 601 67990 225,000 SWA Main Ext-HWY20 to English 4281000058 Mil Water 601 67990 1,510,000 SWA Main Ext-HWY20 to English 4281000058 Mil Watcr 601 64070 108,527 WATER TOTAL 5,758,977 -26- PRGRM/ DEPT PROJECT DESCRIPTION FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 TOTAL PAGE WATER DEPARTMENT Business Type Water Meter Replacement Program $ 406,600 $ 406,600 $ 137,550 $ 130,950 $ 130,950 $ 1,212,650 55 Water Main Upgrades during Street General Repairs $ - $ 20,000 $ - $ 20,000 $ - $ 40,000 56 Fire Hydrant Assembly Relocation/Replacement for the Sidewalk Program $ - $ 20,000 $ - $ 20,000 $ - $ 40,000 57 Water Main Replacement Consent $ 212,000 $ 99,000 $ - $ 660,000 $ - $ 971,000 58 Public Lead Line Water Main Replacement $ 100,000 $ - $ - $ - $ - $ 100,000 59 Wells,Well Field, &Well Transmission Piping Repair and Rehabilitation Program $ - $ 110,500 $ 110,500 $ 165,000 $ 150,000 $ 536,000 60 Water Distribution Master Plan $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 50,000 61 SCADA&Comms Improvements $ 200,000 $ - $ - $ - $ - $ 200,000 62 Generators-Park Hill &Mt. Carmel $ _ $ 175,000 $ - $ - $ - $ 175,000 63 Water Main Replacements- Streets $ - $ 540,000 $ - $ - $ - $ 540,000 58 Private Lead Line Replacement $ 467,850 $ - $ - $ - $ - $ 467,850 65 Water Treatment Boiler Replacements $ 225,000 $ - $ - $ - $ - $ 225,000 66 Water Treatment Plant Roof Replacement $ - $ 21,750 $ - $ 116,200 $ 443,000 $ 580,950 67 Third Pressure Zone Connection (Tanzanite Drive to Olympic Heights) $ - $ - $2,000,000 $ - $ - $ 2,000,000 68 Source Water PFAS Reduction Project $ 2,300,000 $ 750,000 $ - $ - $ - $ 3,050,000 69 Source Water PFAS Reduction Project-GranularActivated $ _ $ - $1,750,000 $1,750,000 $ 3,000,000 $ 6,500,000 70 �(a Va��in��Vafves�ain`�enance Program for Water Distributions $ _ $ 29$$� $ - $ - $ - $ 29$$� �� Snar.ialtv\/alvas Creek Crossing Restoration � _ $ - $ - $ 134,230 $ - $ 134,230 72 Leak Detection Correlator Replacement $ 25,000 $ - $ - $ - $ - $ 25,000 73 Maintenance of Public Water Mains During Stone Retaining $ 20,000 $ - $ 20,000 $ - $ 20,000 $ 60,000 74 all RPn ir outhwest Arterial Water Main Extension- Highway 20 to English $ 1,618,527 $ - $ - $ - $ - $ 1,618,527 75 Mill Pumn Statinn Vehicle 4904 Utility Truck with Crane Replacement $ - $ - $ - $ 90,000 $ - $ 90,000 76 Vehicle 4907 Truck with Tommy Gate and Snow Plow $ _ $ _ $ - $ 85,000 $ - $ 85,000 77 Ranla�amant Vehicle 4911 Tandem Dump Truck Replacement $ 174,000 $ - $ - $ - $ - $ 174,000 78 Water Main Relocation for Sanitary Sewer Manhole Project $ - $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 80,000 79 -27- PRGRM/ DEPT PROJECT DESCRIPTION FY 2025 FY 2026 FY 2027 FY 2028 FY 2029 TOTAL PAGE WATER DEPARTMENT Business Type Water Storage Maintenance Program $ — $ — $1,204,000 $ 296,000 $ 1,000,000 $ 2,500,000 80 TOTAL $ 5,758,977 $2,202,737 $5,252,050 $3,497,380 $ 4,773,950 $ 21,485,094 -28- —� Q �� ._..__ ` � - � � _.`I ` e ' �� E�[$ �; N a-� �''�� �` � � �'*� ,�i _ ��4 ��}c,�:. �� �,��, ��Lrj9 �;L;{ y�, �-- . y� �� � � -a� M.:r „ � � .�.� ��T� 11/ �� a �-�� �Y � �k �`F�R �9LAT3! �-I :� w r :l Jr 1�� !� �J ; ` " � �`� .�.,.. � . . i :, � ' � ,.. , ' ?A r� ��� � � ��1 �I ; ; i / ., �� �S . 1 � �°` -��,��n _ 1r I i:�a.�; ; - �' ; � ���:� �►�. �%t ��_�� �� � �, � ��` � ��. "F =' _ ' "�" � � .� �- � :�r - ..� ,• � � �� - � � �''� , > � •i .. ' ` v; �� , C`1_ � �, a � � "�"� �+—, `�a � � �,/ �� i �a �. .�" j` ' A� �A ..L*`�' �.. �, i_.. � 1 � ��' � � v �oer i . I n� �r� ,�,._�' � cr 1 1 � �� .,` �' ;�. � `� �� ' - � (,3,,, � � ... � � � r 4 1 ,T . ��y `�. � , d� ,��.. (i _ `I � ^ � � �1 � � . � . ��� '� � , � � � • -� �_ +�. �_ � ~A��..., � .�� � \ ' �' � � * �i ct� ��. �.� 1, �\�•,�1��y �._-.\ `�f.y �� '� �� � - _ ��_. �� ��'a�d' ...� ,� : � � �.� -..�, -�' I . T� � . . ;�:,., , � �.�� , �;�'S. .4_ �' �- � . �r'�.� � 5-- � . �• �, �v� t� ►, � � _ '�' c $ ��` _ - -- ��. - � � �.���.f� �- ���_:. � ' - � '- - . �7� � � ,� _ �:, ` � �� „ -� � � '� �_.__.��._._ ���� 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. Water Department FY25 (27.07 Full -Time Equivalents) Water Department Oirector (1A FTE) Canfidential Account C[erk �1.Q FTE] ❑istribution 5upen+isvr Engineering Assistant G15 5pecialist DperaEions 5uper�isor (1.0 FTEy �1.0 FTE] (1.0 FTE} �1.0 FTE� I �aistribution Maintenance Distri6ution Maintenance GIS Seasonal Intern Water Rlant Operators Su�er�isor 5uper�isar (1.0 FTE] (1.0 FTE] {0.5 FTE} �6.D FTE) Industrial Electrical Equipment Operator II ; Meter Repair Worker I Technieian (1.0 FTE] [1A FTE) �1.4 FTE] . � . . Water Distribu#ion Water ❑istrihution� Maintenance Warkers � Maintenan�e Workers EquiRment Mechanic �6.D FTE] I (2.5 FTE� � �1.4 FTE] � � New Faces i n FY2024 �� �- Y - -�_ �� . . _��� _ --� �_ f.� r-f.' _ ,.�"" '� � -- � -� �r _�� �`'�s ` _ ',T ■ ■ ■ ■ ■ ^ � .Y<.�� � r' .. .. 1 • Jason Ellis, Distribution Maintenance Worker ; � , ,,�� !"yj,[� _ - -� - �' = , � � I�� .�� l�I. - � �•����i .�� ■ ■ ■ ■ ■ _ .�, �r� ��� ��� • Chris Kerf, Distribution Maintenance Worker � - ��� , �'��: . � � _�--���- ,� • Nate McLau hlin Distribution Maintenance Worker ��� :�� :�} ! - Y- � � � ��''�� � � �. � �- �i� +i '���' ..�i �. h • Andrew Butcher, Distribution Maintenance Worker ; r � � = �- �. , � '� �� �, � w�� T �� �_�F • Joe Vondran E ui ment Mechanic �, � � r5� , � ��` -- . � q p � �. � � • Bradley Winter, Water Plant Operator ;� ' ,�� �r - ;� � '�� � �``� ' � � • Charlie Gau, Water Engineering Assistant . ! -_ . �� ` '� �' .#�� '�'� - l�' .e "� s" � �� '�=� � y .':} j '� � ,��: •i t ��, �� ~ � � � � �� �� ��w � y°� Svti..� � � / ��� � � 4�_�. ; �i�'� ���� . � .�� Recognition of Staff for lowa DNR Certifications Obtained Kyle McCombs - Water Treatment Grade 1 Nate McLaughlin - Water Distribution Grade 1 ; Jason Ellis - Water Distribution Grade 2 Bob Childers - Water Distribution Grade 2 IOWA DEPARTMENT �F NATL.JRAL RES4URCE5 C REATI N G AN �k Hi h-�er#arm�n�� �r ani��ti n nd ��mrnun�t �r�th � � � �� �� Eng���d Errr�la���� ar�d ��si��nt� tl��� i� ��t�^��i�rer� �r�� EQUITABLE � - ��tc�rrreyF��u�ed ��ilt �� �he fiv� pi�l�r� �f: COMMUNITY OF CHOICE ' . i � t . - � � . � ■ ■ 1� r �` . . . _}.4 Rr � ��.� , ' ;;�- :.� � y�' � i - I � f .# . � -� �#f� �' 4 '. ��� I i T� I FISCAL YEAR 2024 HIGHLIGHTS — ' Utility Rate Reduction F2eduaed h7on#hly Fe�S FY�3 Month �€Acao�p� �Acc�u� R�fus� �lltl#� ]� �it� $�C � � � June 23 562 2,129.+�8 �5'I � A,'188.�0 �52 2t32�.9� �6A 3,3�2_3T $ �+ "� N1d�r 23 538 2,OGG.O� ��'I �* 4.Q�J,�O ��7 2r��4.$9 �41 '.1.2'.1G-GO $ � � Apf'i123 599 9,$4�.�5 �07 $ �,84?.�2 51� 7,7�4.31 5�� 3.�62.68 $ � � Mar�h �3 431 1.85�.5� 481 $ 3,674.�7 490 2.034.32 494 2.92�.58 $ � 3 February 23 482 1,822.2U 47� $ 3,598.�1 �82 2,UOD.88 48S 2,868.42 � � 3 January 23 463 '1.777.1� 453 $ 3,5�,7.62 �63 1}95D.iS 466 2,796.70 �* �* $ Decern�er �� -0.41 '1,679.63 434 � 3,3�6.71 442 '1t84�.38 444 �,6�6.10 � � � No�rernF�er 22 �38 '1,6GQ.88 43'I � 3,305.42 43� 'It831.79 �4'1 �,G�O_92 $ � � OC#017er �2 46� 9,�94.73 497 �+ 3,'I$5,75 42� '1,7��.�8 4�G �,�92.�2 $ � � sept�rnb�r z2 577 9,�59.ez �80 # 3,795.01 523 9,7o7.G5 525 2.444.�6 S � August 22 696 � 1,966_71 �90 $ 3,956.79 5�� �,202_92 534 3.946.70 $ S .lul� �2 587 � 7,681.�8 669 $ 3,924_�4 b30 7,97�_82 632 2.761.61 � � S Tota12023 6h4�i 21,736.26 �025 $ 43,679.84 �943 24,0�9.7� 5975 34,�30.26 *FY23 Individual Reduced Bills: 24,089 �r Y1� I otal Kequceq rees: �� 1�, �5�.� � � *� � � � -.i'� �A `'� � }�-' # FISCAL YEAR 2024 �,� #� � �} � * + �� ��� �� ,� #�* � � �r�� # �:ti..•' +�,ti�e� � �f r'� r+�� �,�.� t�esa � � $a�a � ��.' ;���� �* � + :, ,•`;�na. ��� - � � �1 r H I H L I H T i }} �# . . .. �� , - �..fr � �� � � ,��&s � G G S �� {�� # ����7 $* k }�� �4 � ��=6 r :�{ i�1� �� � f r f�. k k •l+ 1'f � f r •r� � c � : � . .' � * �^� �' � r.F, =t!=ri��•= * t9:: � f+l • ' -- ��4 '_I'� }f�'�JE _- �#� � • a ■ �p '+}.' ��_ti uF.= Y. � � =- �-'';L -: - . *� , � . ,f .. �� =- =_: r.- # ��,� : �� � ,�R�, .� ,, . ' . � � �#� .�. �� '.�a �� � � �l �� . � � � � (J i�EG '' +� � � '. Burlin ton Street Water Main � � � �� �k ` � ' '�4���`� g � �� . suos � ! � `k. �, •/ � sess � ° ��"a ��l ■ ■ �� � ��� •k�,` ��dp �f , �� � ��� � a f . � Im rovement Pro ect �� :�� � �* �{���#� F ��� �:� �. ., � ���� p J �� ,��.�� � � • � ��� � � �� �„ �.,f,f' � r� �'` � �f`k�' � F 298p *�f ��� ; � � ' . #28�6 � i �i �� r#� . .-� o- • Replaced 820 feet of 6-inch water . . ���`;�`��6 ��fl + ��*�•� � 4 ����,. .��� � �� � a � . � -- � main � -� � � _ � �. • Installation of 2 Air Release Valves ; � - ���� � -:T --_ . � ..:;�.�.��:.�;� • Variable Frequency Drive Motors � � � ��� �� �� � � ��� .:. _ � -� - �.. ��� �, .' ����"' r :;� '�"�d! installed at Park Hill Pump Station �r����� . - - - 5ry;�,.�. �:_.�.�-- C _ �...�._ ,� !I�� ��.� • Contract Amount: $440,300 .�� � � � . -- j; � � � _ - }_ �:. � _ - . ....�:�,. ,:_ _ '�-� -._- � =_ —'�`- — - - �- :a � , • Contractor: Tschiggfrie Excavating, �X�� �_ __ _�,..�r� � �° �'�� ��,� .�..� , _ , f �, Dubuque IA :._- �����_ _ , _ _....�� _. �. ._ ,�_�-.-. .� .. "� .+� ��r � � :�: _..F -° F I S C A L Y E A R 2 0 2 4 ��,� , �Z�Highu�c�y Rd ,� .�tt,����.���,�����_ �C��ir�tsf?t�F »,a.�.,,�..,�.�. � Lh�ater�ldici�t Lozinertiort Looy 5�2a;23 'n jY jG HIGHLIGHTS z �m iY r �rn C3TY T�CONNECTTO n E7(ISTiNG Pl1BLIC � �� WATER MWN , _ �'•' I� RO !/�J � � 4Q- CIiV TO CDHNECT TO CIiY TD INSTALL 4.670'DF ,p�Pr% E7(ISTMG Pi16LIC 72"P116E3C WATER MAIH E](15i1NGPl16LJC �,�G#� WATERMAIN WATER hfAlN V ■ ■ .,,�,�' i O l d H i g hway Road Wate r M a i n .� __ _ � " �� o�a�Q�E _��'f ++ cauNnFniR -� � i± GROUNDS }����� I ` ��t;�` _ ��Y tZ �.�� -':�.yax Connection Loop ��;m -_- ,r�,,, __ �i��. �x r---' I� �l _x==—� � E7f35i1HG P116L1C PYNE VIEW 4R I g� wasERnvuH — — �III vw � i�?'•I zl i �,I� • Installation of 4,650 feet of 12-inch water -�'� .'- , �!� /: , ��! -- main near Dubuque Co. Fairgrounds - --=_-___= N� ����,°PreFa;ed�r C 230 400 926 +-,380 1,84D ciry�cfo•h°q°e Feet �`�E aeroepammem 1902 Mant^o!^e St - - g 5835844�1 • Creates looped main in Pressure Zone 4 • Contract Amount: $751 ,663.81 � Project Completed 3.4% Under Bid Amount • Contractor: Top Grade Excavating, Farley IA FISCAL YEAR 2024 H I G H L I G H TS - -s��-ti�=--- -______ - - _: - - _._ - -- -�_-�--____ _._ __ ____ __- _�:�_ -___-_- _ -__ _ __ __- _- _ - - _ ■ ■ -__ __- _ ___ ___ __ : _ ; ___-__-_ ___ � : __- ___- _ _ - _ - - - _ _ __- __ __. = µ�Nx _ . _ _ ;,,�� _ .���w�F�:: • Water Meter Technical - - - _ - - . _ , . ,: .� � :. _- ----_ __-___ -_ -- -_ -- �.------_--,- � _ Upgrade Program � - : _ - -- -: ---_ -r: _,��,,_ � � �-- .-_ _ - , -�-. - _ _ _ __ - _ - --� . � :� �v -r- - - �4a _- +�wN i. -�s�.'� �r ] ^�.^ . y.. - — � ``��`� �.r �� . � Water Meter Product Replacement of Meter . � � -� - _ - r � . �� ; _�" , : <�,— �-�• _ r Interface Units and Registers �.��� � ,. �: r � � --- _ �- .�- -- � _ _ _ ��:� ;, �;:- . _„ • 5-Year Program. Initiated in FY2022. � `° a' � ' ,�� �, :n � ,�� c. e. �, � I n P rog ress ; � ` �.� � � �.� _�'S � �_r°'�`�����' � • Work Performed by Water Department ; -��r .:��� �� ;._�,Y �� Meter Crew � � . _ , ��;����: ������� ;� # ��:�,�. ,�._.��� � ;�;- ��,,ti-�., ',..., ��:r �. ;�.:-�• '_ • Total Pro'ect Cost Estimate: $1 885 000 ��� �-� '�tr:���"-�, �:���"��6�� ' � r J - � 91���YT .,. �-.��� ��• -... .,,.,,'� � "'���`� K � � •� ''��,,. ^�. �,. :��. r 1�'w. 7 7 '"""' : _ ;� ���`��.�h�`. � ' �- .r }t5c,- -- �:.�}n. f:�::1::;,Y..��,l. � - �{ � � 4�'Y�k:�:..- � �,'s�`, `,�;f:'x" ��:ro- � Ry�:�' 1 - s, �5!{�: r';.��ri�f"`.�" -•' z , � r,',��.`�-~,~;,� ��cL' .t�14i}�r"�4..�•.,. ,�t�" .„ �... '. g.�! ��� eY �� =v,tTM -3'•..�• :j,iL7�� �t��' :►�`'`3r. ,���ti;.,. 'r:' �+� . �" . x � - �, �.. y:s�F:�•�i :$f,i, ����:���i��f � . r..L '4.i.. '' x, • r " • � � g 'F. ��i��� i -�.�'}?- �:-- t .r � �}}Y�i�'ki,r�'y��'�-1�'.�,ri�"s��-'`�_�r�;� � �- , � _�.l� w.'S`�?Y�. ��e7y��'-�a'a.if�, .���--'�,•y •'�?' �.1fr3'i�ll��+i-:+S'r�i'��*�'¢� ..�_a:r��,�� *k�s-.r`�Aa�':��S�r'..'��3�� r . .�. �•�•��}'. Danny Pefersen installing new MIU - Private Lead Service Line Replacement Pilot Program � e caNnRr oR 5'l[AN�R � WALKER 5 Z4� G� ► � • Multi Year Replacement Program T F�M��G6dR ^ o � � ��NE� ��� a ��r�E SrAlFR�Ir'kPl.. I A�`wnR � � � for an estimated 585 Lead Service � , p ., L i n e s ° '°�5`�' i ueea-ravE� ~� * t• � � �,r� Y • • � ��. �d' '� �� oj,�`'%+ �`t I � � �s ��'s �� � • 1st of 3 Phases Scheduled to ,St r" ' N&Uy���s� 6FVI55* � ,ti�, � � . , �. - .. � 05� �r � r 7E ��.z •�cti ��r��R`r �� begin in FY2024 �,��,�� E�RHS ��� F �� �r,!: s f • lr �J IXNEILL 6S � � ��Y �� �a7 f r�." yf" ����yt @ � b ._ {, V'Y �� �; �- � � 1 Year Construction period W�,a4j ��.� s, � �,� ��'�:^ � `��� � �, � �, � �, ;- er h ase m�� �r�*. ��;��`` S�R�S� � � n� :� +� �� - � �• � � � � +*� S�E� S �r� SS, I GLE'1+E�L�R � {d4 / -0 .��_���� � � i �n� • ��� �K 5� d4 NG�9N�LC�R _ ���7� Ei ?� i. �: ` �� � �� �4 �tp� • .k4A �r �{;7 � � \` �`, O $0 Cost to the Owner or � ~ a-0 ����$��ry �$� ` � i $ � �� �srfy , � � �x's��''�s �4�°;.�� ��i� ��� �NMEP1N3i ay*�����4� �`+r � Tenant in Disadvantaged ,P����.s.W.�si � � 6tii4� � � � �_�5T _ ei i� �',y ��,��. � r �., �`T8r } p ����* a� � � 4� c�F1NAM 5f Sl • { ����'d' Y' f1 � Communities •� n r��:' • �; �'`� ��'� � �R�y.� ��'� rt_'_�xII. .i_..1 .. RAnE9i G#ya�� s � rs� �Y� �{ly'W�m,fv.,��,.,� ��i �,4�/5�05�NAL`��� d� � .p���(}.�r ��7 �' q �Sr1 O �6� • ����fqr�� k4 1 ,� • Funding: Bipartisan � . ��'��£a��:� �¢' �`;'f. � �� S � �� 4� f+ t��5 � �y a �" Infrastructure Law monies to v4�xt�¢t��`� �, ��'��� 1 `}� �� ;---T q����f �x°�� �S` +���� %E Legend - . lowa State Revolving Fund Loan s���°" �NA�❑5i gN�P�ERSi}4:�k4�s�� : ��� �'.'� ' - w �� y �C x�ya�'W'�e't�r � ��i Ery55 i� StO�}�UI{ Program a�.� � s ,a�41�ry�E�T �y� ��'�:�� �� � � ��+ . 5t Bax Status 1 �C� ti+rM i� �E* 5, �� 4: "� " ,n e + q���H�� �.�.4^'�l� � E'y* t��a i Shul0lf � � a .�uo4o sr �4r��"�� !,i�+`S � �, • 49% Loan Forgiveness to City in ������=�9i5T��+��h��'�,$ .� ��� � ���g $h City limits � �, �� ���s � � : Q City limits Disadvanta ed Communit Areas �,� ���;��', ��s5� �"'�';s�,��,€�;'��� y� T�rgetPdlvea2a24 � Y � �.s�„���� , �. � . �s " �1+�,q��i� ��'N�*���t � ���wSt nt"St Ciry of bL Kuera I�roem - � _� ,oF± '�,�"N f r"� + � � � FY25 SW Arterial Water Main Extension ■ ■ "' ��` � 5authwest Arte�ial W��er Main Extension °�' • Installation of : �[�i_��3i_ir�t_��- .l���. � � � `"'�.`� :r::l' � 4,200 feet of 16-inch, and . Y �# � R. .� � YS�� i' �� � ,_. . . .. � r.n'r:�. , . :t — +r � Fut�reCon�e�;i��r , �,' rs' ' x� .� ;� ..�,,�� , O � . . �, ,.>� -aCresc�n;Rid•��_ .�- ^w+�*&:.�� 2,900 feet of 12 inch water main � �� a'daierA4ain i �?� �i: `+�' �� . t;.�_—�� - .� — ' �^ �'��� '..T� ..�xl • .���r N, •�.�' } . � �'' T'��- f - • ��r.h ,i�_"•,;.'..�.'��`��.'� f�n �ti:�, � ;�r.. ���� �j :l� _— '��'� '�a - ' .i �.-�,+�� I • �� � � ` � -! �' '��i��`` � A � j North Cascade Rd/Edval Lane to � ., � - 1 j.�.'�� � t I F.�`•��''Ji�' r'yn: �w�.Y �•���'—,^-' i- �'1 .�-; - .��t' ��.-� ��� i �=°4����'���'- = North En lish Road � . . , . ., .���.;�.::�.:�;: _.�::�,� J „� — ..a �,�� �- �r � �,� ".,":':a-�•�:'-ii!. .. � �����,,,, ,r's _��� �ra' '��r�'-c�."7��"'L ;.-=�•.'l Ll'1Z - ��� ,+�.f � � di f � Y'; � *'�-�� — "' ��T' •V��� . - _ � ,� I IR , :� , '�� -- — ,,h �,�_ �. � ��,�� J � ���`� � �` - �� � { Part of a Phased Water Main �� y��- fi,�� - . . , �F� __ ;,�,f . :� � F -�_ ��. � -�� --- - .� ` ` � , ���� �y�'����� Extension ro'ect to: � � ,� p J , � -- �� , . � �,,;� �� _ � _ J .� ' � ��' .—�v \ ;�"'•�� 'rS1�r � � - . � `y-�'"�::. ��-- - ' �S." �� - �+� �' -.�ti�� �� ''- ., � �; l y l� � �.y�+ O _ � � ------- _.�_;� �:�'=- --� "� Promote Improved Service to �� - . . ' ' `� f� �� �� �� � ���,�; ��� Existing Customers ,�. l. _ - _ .. r�_�i4 4 •.�.1,b-�— � r �`+ = j � �. -:��}��_� � y �� < <. � �- .. _.._ •� o �� � , ��� ��� � � � i .�,_ ..... � Growth and Development along ,�� _1�� � ��-�� � � � 4� ■�� SWArterial Corridor - -- �y ' �'E},oS4C 6'j: �Ify�:'��6J:42 - 1 inch=1,400 feet l,�+ �,�^ce9rg�rol�l:� _ 4 M�E 50 kNert R:i`,�'ee� =F3(ISIING WATER VIAIti a,dd:�e.ivxa 52ro� _ _ .v�o:.00 •5 _ s�•5 �,zo� �,5cc Feet =FL`IRE WAIER MAIN ��'e�[�]�-=�''� ..�...�....�...... .._...�..�_�.�.....�.. �' Fas:(s[3J ss5-c2a5 . Drinking Water Quality Improvements : FY 25 Well No. 11 ► � ■ ■ • Dubuque and PFAS � _ - . . � _. � � . � � � �- �� ! , � �. . "� '�. �' �, � � �-:�� � Required to Complete ' � }:� ' ' f := �,� Quarterl Sam Iin � `�����'�� -�- ����� ���� v p g , � . � Since routine testing �� �� � -- �`�� --�-- �- � -%����� � � '��'�"� � � ���. �'- �� �_� � {� ,�'1 ���--� ' • a ' �I x'l�l.!� �` �`9 47��\�{�' �' f started in March 2023 =: p- - � � � r ,�. • � � � - ��� �. , ��'—� t� � ' ;'��� 1 Exceedance �{ . �1,� 4 {�s.�� � ,,v�. ;�, �Pa :� . . �r';�� W -=k = - - ..-�'S�-..-�� � �� . � . .: ` -__ �c� .. . f'` � �`. �° �"°� • Funding for New Well : ;,� ��� - _ - � � � - �� � ' � Total Project Cost: � `�- _ � �� �� �� � � �� �� � � - = � � �� } �� � � s s ,� $4.6MM �. , � � � A � a � � � :y '�/� .� � - � �_ ` . � � �� . y F � "' '.� _j ,�'�' �az- M� � ��� ,� �: .e' _ � FY25 Request $2.3MM � - ��� �, k �'� 4 ��� y � - �� � �. �� ,� � � _ � z�� � a� � � . � � � k � � � � � , � Previousl requested � - _ � � ..w. ,r�' -� w� . _ a -� r�h � . � .. _ . �. � ,f` � y �.. h. � � � � $1 .15 MM � ��fi �'�ood ��se s �in:, F� Per-or Polyfl�or�oalkyls�bstar�ces:Dverv�evu ar�dP�evcrler�ce,AUVt�11A,A�g�st 1�,�01�, � *A verage Household = 6, 000 Gallons/Month 0 • 0 � Proposed Rate Monthly Bill Impact for Increase over FY 24 Average Household* RATE COM PARISON Rate Comparison, Lime Softened Facilities 4nly �so.00 $44.21 �41.92 $41.91 $40.00 $39.07 $39.06 �37.48 �36.4� $32.44 $30.�0 � �Zo.00 $10.n0 $— West Des Des Cedar Ave. W/� Dubuque lowa City Ames Council Moines Moines Rapids Dubuque Bluffs � FY25 Water Only for A�erage Household �6,000 gallons� Based A verage Household = 6, 000 Gallons/Month 4th Lowest Rates : The Highest Water � Rate West Des Moi nes is 13 . 18% ) Higher than Dubuque's Rate ; and the Avera e Rate is $ . 01 H i her than g g Dubuque . °�jOWA Home Statistics— Resources— ManageAccount— WAT E R A D M I N I S T RAT I O N Training E�ent details � � Date 03.'10,'2021-03�14.'2021 • Employee Training and Development Location � Professional Development City 8 State CNLINE � On Boarding of New Employees Cantacls 10 WAR U RALWATER.O RG � C o n t i n u i n g E d u c at i o n P ro g ra m s More Inio IOINARURALWATER ORG Description RISIGRESILIENCE&EMERGENCY RESPONSE PLANS-MARCH • Reg u I ato ry C o m p I i a n ce MaXA��°wab�e H°°�S � � Reporting, monitoring, and working with lowa DNR and EPA on compliance. • Capital Improvement Planning � Project development including budgeting, initiation, and award through construction completion. WATER TREATMENT PLANT OPERATIONS ■ ■ � . �. � • Water Production and Treatment � i ` � �_ `� � . ' � . � � Regulatory Compliance t � j� �•� � Water Quality - Consumer Confidence � - ` � . �- 'r-=� • Source Water Protection ,� . � � � � � Wells and the Well field �,��-E� AL���' R�P �� QU � � Treatment Plant . . . . . . � . . , rt • Water Storage and Pumping Facility '� arr of aueuouf � w►�r[R o��'rr�tMr Operation and Maintenance � � -- ������,� i� �- � - � -, � } _; �- . .��_ • Reliable DataAccess and Reporting � �� � {�- .y� - y .� � , ,.,�,� . , � ��� � . -s � SCADA Communications �' - {� ��� `�`� --•rt F �,,w � • . f � ` - �y.. 7,� . _ f WATER PLANT OPERATIONS ■ ■ Water: Treated and Metered 3,000 �2,500 z,4as 2,5as � 2,273 .� 2,441 2,O17 � 2,400 '1,9'14 O 0 1,500 Jw 1� ti� 0 1,400 ca � 500 Treated Metered FY'21 � FY'22 � FY'23 WAT E R D I S T R I B U T I O N � -- -------- �- - -�------- - ■ � - - - ��� � :� - - _ - � b � �� i �r � :�P„ s — � �' f ■ ■ � l . .� !� ��' .,' ._ .. ,. Operation and Maintenance � `� -��' �� • - -....-_ _ ��4 • Emergency Response - - _ �` � = _ -- _ _ . -, _ �..� • Ins ection � - - p . .� . . ._ ,�,. • General Construction ����� _ ��- � ��� �� ��� ���������� ���--���� � ��� �` ���� � �� � _. ��,�_ � � .,� �� e.�...� r ,. i _ . ■ ■ ■ � � _ � - 1 '...' - ' ���':`���,_.r..,,���.W�.�,�x.-�.LL.��✓:�a� Service Line Main Taps , � • Water Main Installation � � .�� . • Meter Management ����' - - - � � �s�� � �� `� � • Backflow Prevention - ��� � � � � ��" ��1 � �`' � � I i� � � ,••a,;� '� � �'�,,,1k�'--� 7 - • Development Review . . _ . � - _ _ � � . - �_ , , p .-.���.. '� �... �r �� ' - - -- - - - - . _ - , .,�.,..�-.: .� ,,.. r�,. �.q� . . PS�'F��!ar� ' � • "�, '�Y-;�vy: :`T , Y�'�::.�i'�:��ti�.?�i - � � �, WATER DISTRIBUTION ■ ■ Water Main Break Response 150 13� 125 117 105 1�4 � 85 77 84 74 75 50 36 25 0 FY'14 FY'18 FY'19 FY'20 FY'21 FY'22 FY'23 FY'24 �Water Main Break Response WAT E R DISTRIBUTION ' ' � il *FY 2024 to date: ' 43 Service Taps � � New Connections result from � community growth . � ! � � such as new housing, , businesses, and � � industry. � . . � , WAT E R 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. � � � Backflow Prevention Program � - - - ■ ■ � . �_ -�� �,-� �;° � ` '1 � I� r, � 1 � :'� � , , . ' �w ��. �.� � • Administered internally. � r . ':�' ,�,, : � ��� �"� _ , � � � �� ,., � ,�- �-� ' '�_ � �' _'- �,.�! ,P � � � � � '•J�r ,'I� , � ■ ■ ■ ■ � �;'�:. � � �, ��. . y� J'�_ `�'+`�` Adm i n istrative fee $25/device. �.�, � _ - :�,� �� _ � � � � _� � � � _"� =�—� ^�"'- ' � � - � � � ' .�„`r ��.__. � � �_ ,,; j,"`�` � �- �`" . • FY2024 Revenue to Date: � ��; i �� �- '���, ���,� �_�� � '� � � �� �� �� �-� � - � � $79,450 , ., .������_ ;.. =���� �;_ � � , � � i � " �•" �r. `�, �` . O '.'� � 3 178 devices tracked. `i. � . -- T �--'-�' - - i� � - �� • �� .�� � ��, � � ? �.+�—_ � � � ��� . '-i' "'---�� �;�, _ �'y' � '+I��� ,► a! ' _ �� . � a. ��,F.=�- �.� ._" - �,,� - � . . .� ';� _ � , ', � � . �. � ` �-. ,._,�'` �, . ��. � -s,� �� � , Jeff Mills performs backflow recertification testing FY 25 CAPITAL IMPROVEMENT PROJECTS . , . , . . , . , . Source Water PFAS Reduction Project $ 2,300,000 $ 4,610,000 SW Arterial Water Main Extension $ 1 ,618,527 $ 1 ,618,527 Private Lead Service Line Replacement Pilot Program $ 467,850 $ 5,816,000 Water Meter Replacement Program $ 406,600 $ 1 ,885,000 Water Treatment Plant Boiler Replacements $ 225,000 $ 336,000 Water Main Replacements - Sanitary Sewer Program - � 212,000 $ 1 ,103,000 King & Hempstead Streets SCADA & Communication Improvements $ 200,000 $ 971 ,000 Vehicle 4911 Tandem Dump Truck Replacement $ 174,000 $ 174,000 Public Lead Line Water Main Replacement $ 100,000 $ 350,000 Leak Detection Correlator Replacement $ 25,000 $ 25,000 Water Distribution Master Plan $ 10,000 $ 10,000 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 10% of % of Projects Completed within Distribution System Valves the Program Budget Annually � � r�� ;_. -.� �� �f� www.cityofdubuque.org/water �