The URL can be used to link to this page

Water Department Fiscal Year 2024 Budget PresentationCopyrighted March 21, 2023 City of Dubuque Special Meeting P UBLIC HE ARINGS # 02. IT E M T I T L E:Water Department Fiscal Year 2024 B udget Presentation S UM M ARY: S UG G E S T E D D I S P O S I T I O N: AT TAC H ME N TS: Description Type Policy Budget Book Updated Supporting Documentation Presentation_Uploaded 3.21.23 Supporting Documentation Utilities and A C P Program Flyer Supporting Documentation Water Department -19- This page intentionally left blank. -20- WATER DEPARTMENT Budget Highlights FY 2022 Actual FY 2023 Budget FY 2024 Requested % Change From FY 2023 Budget Expenses Employee Expense 2,324,025 2,514,330 2,700,384 7.4 % Supplies and Services 2,872,120 2,696,808 3,548,883 31.6 % Machinery and Equipment 580,873 966,118 788,130 (18.4) % Administrative Overhead Recharges 435,271 452,767 1,369,331 202.4 % Engineering Water Maintenance Charges 40,002 42,951 50,182 16.8 % Payment in Lieu of Taxes 142,884 142,884 142,884 — % Payment to Construction Fund 400,000 1,000,000 1,000,000 — % Debt Service 7,439,736 2,692,470 2,689,548 (0.1) % Total Expenses 14,234,911 10,508,328 12,289,342 16.9 % Resources Operating Revenue 15,461,447 11,630,469 12,336,834 6.1 % General Fund - Rate Subsidy 22,352 25,000 25,000 — % Total Resources 15,483,799 11,655,469 12,361,834 6.1 % Net Operating Surplus (Deficit) 1,248,888 1,147,141 72,492 -1,074,649 Personnel - Authorized FTE 26.07 26.07 27.07 Water User Fee Rate Increase 3 % 5 % 8 % Revenue 1% Rate Increase Generates $ 94,642 Improvement Package Summary 1 of 5 This improvement package request is for the elimination of the Water Engineering Assistant position (-1.0 FTE, GE-33) and the creation of a Water Project Manager (1.0 FTE, GE-38). The needs of the department continue to grow and change in regard to the depth and breadth of knowledge, and as a result, the experience required includes: the development of the capital improvement program; knowledge of onsite construction management; working with consulting engineers; coordination with the City of Dubuque Engineering, Planning, Building, and Public Works departments; writing requests for proposals; updating standards and specifications; providing engineered solutions; reviewing designs for compliance with engineering principles, city standards, department requirements and local, state and federal regulations. The current position identified as the Water Engineering Assistant is not currently staffed to be able to perform at the Project Manager level that is necessary to meet the demands of the department. The request is that the Water Engineering Assistant position be eliminated in order to create this enhanced Water Project Manager position. This request follows the City Council Goal and Priority of Financially Responsible, High Performance City Organization: Hire, retain a highly skilled City workforce reflective of the Dubuque Community and Robust Local Economy: Have the infrastructure and amenities to support economic development and growth: industrial/business parks, streets and utilities, air service and housing, bandwidth redundancy. -21- Related Cost: $116,513 Water User Fees Recurring Recommend - No Related Savings: ($80,935) Water User Fees Recurring Net Cost: $35,578 Water Rate Impact: 0.42 % Activity: Administration 2 of 5 This improvement package request is for the creation of two additional Water Distribution Maintenance Workers (2.0 FTE, OE-09). As the distribution system continues to grow, the need for routine operation and maintenance grows also. Since 2017, the distribution system has expanded from 326 miles of water main to over 387 miles, 7,070 control valves to over 8,000 control valves, and 2,400 fire hydrants to over 3,500 fire hydrants. The addition of two FTE Distribution Maintenance Worker positions would increase the current staffing level from a six-person distribution crew and one foreman to an eight-person distribution crew working with one foreman. The additional staff would not only be able to perform work on the distribution system during both regular hours but also be available for emergency calls after hours. They would also aid in replacing meters, MIUs, registers, and better position the water department to develop and implement Iowa DNR-recommended programs (such as annual unidirectional water main flushing to ensure high quality drinking water and maintain the city’s ISO rating) and a valve turning program as recommended by the Iowa DNR. This additional work would account for over 3,000 hours per year. This work is also directly associated with the capital improvement project, "Valve Exercising and Condition Assessment Program." The additional staff would also be made available for more in-house inspection of new main installation and repairs, thereby reducing costs associated with increased outsourced construction inspectors. This request follows the City Council Goal and Priority of Financially Responsible, High Performance City Organization: Hire, retain a highly skilled City workforce reflective of the Dubuque Community and Robust Local Economy: Have the infrastructure and amenities to support economic development and growth: industrial/business parks, streets and utilities, air service and housing, bandwidth redundancy. The Water Department requested $161,862 for two positions, and the recommendation is $80,931 for one position. Related Cost: $79,201 Water User Fees Recurring Recommend - Yes Related Cost: $1,730 Water User Fees Non-Recurring Net Cost: $80,931 Water Rate Impact: 0.86 % Activity: Distribution System 3 of 5 This improvement packet would provide for the elimination of a Water Meter Repair Worker II (-1.0 FTE, OE-14) and the addition of a Water Meter Foreman (1.0 FTE, GE-31). The meter program presents daily opportunities and challenges that require in-depth problem solving and data analysis beyond the job duties as described in the Water Meter Repair Worker II job description. The current Water Meter Repair Worker II employee is currently performing supervisory duties that are typical of a foreman, such as oversight of day- to-day operations, but he is also providing necessary direction, motivation, technical guidance, project management, and budgetary preparation to assist and support the Department Manager and the Distribution Supervisor. The creation of a Water Meter Foreman in the department would not require an increase in -22- FTEs. The request is that the Water Meter Repair Worker II position be eliminated to create this enhanced position. This request follows the City Council Goal and Priority of Financially Responsible, High Performance City Organization: Hire, retain a highly skilled City workforce reflective of the Dubuque Community and Robust Local Economy: Have the infrastructure and amenities to support economic development and growth: industrial/business parks, streets and utilities, air service and housing, bandwidth redundancy. Related Cost: $87,125 Water User Fees Recurring Recommend - Yes Related Savings: ($78,444) Water User Fees Recurring Net Cost: $8,681 Water Rate Impact: 0.10 % Activity: Meters 4 of 5 This improvement request is for funding to upgrade the ruggedized cell phone to a smartphone for the Water Treatment Operator. A smartphone would enable the Operator to have access to WebQA and GIS mapping during the response to an emergency, improving the time it takes to inform distribution crews. The City operations would be improved with decreased response times to emergency sites, and the community would benefit from a shortened interruption of water service in the event of a water main break. In addition to helping to reduce downtime, the phone will allow the operations staff to have access to the Panic Button App for safety in the Eagle Point Water Treatment Plant. This request follows the City Council Goal and Priority of Sustainable Environment: Preserving and enhancing Natural Resources to readily respond to provide safe, dependable drinking water and using affordable technology for water activities. Related Cost: $686 Water User Fees Non-Recurring Recommend - Yes Related Savings: ($100) Water User Fees Non-Recurring Net Cost: $586 Water Rate Impact: 0.01 % Activity: Plant Operations & Maintenance 5 of 5 This improvement package request is for a stand-alone SureCall Cellular Distributed Antenna System (DAS) for the Water Department Staff at the City of Dubuque Eagle Point Water Treatment Plant. This system would boost the cellular signal for the areas in the Eagle Point Water Treatment Plant where cellular signal cannot be obtained. The SureCall Cellular Distributed Antenna System consists of one signal amplifier, one rooftop-mounted antenna, and up to two interior antennas that will be mounted in the affected areas. Use and benefit of the SureCall Cellular Distributed Antenna System would improve efficiency in daily operations such as: making/receiving calls from Distribution crews; receiving notifications such as two-factor identification; effective use of the Panic Button app; increased safety in case of emergencies as the Eagle Point Water Treatment Plant is staffed by one person after 5 pm on weekdays and throughout the weekend. This improvement package follows the City Council Goals and Priorities: Financially Responsible, High- Performance City Organization: Sustainable, Equitable, and Effective Service Delivery. -23- Related Cost: $68,770 Water User Fees Non-Recurring Recommend - No Net Cost: $68,770 Water Rate Impact: 0.82 % Activity: Plant Operations & Maintenance Significant Line Items Employee Expense 1.FY 2024 employee expense reflects a 5.00% wage package increase. 2.The Iowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2023. The employee contribution of 6.29% is unchanged from FY 2023. 3.The City portion of health insurance expense is unchanged from $1,119 in FY 2023 to $1,119 in FY 2024 per month, per contract, which results in an annual cost unchanged of $13,832 or —%. 4.Overtime is unchanged from $94,040 in FY 2023 to $94,040 in FY 2024 . FY 2022 actual was $129,894. 5.Five-Year Retiree Sick leave payout is unchanged from $11,094 in FY 2023 to $11,094 in FY 2024. 6.50% Sick Leave Payout increased from $1,841 in FY 2023 to $3,585 in FY 2024 based on FY 2023 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 $668,402 in FY 2023 to $969,299 in FY 2024 based on FY 2022 actual of $768,106 plus 26%. 8.Sales Tax Expense increased from $460,710 in FY 2023 to $545,649 in FY 2024 based on FY 2022 actual plus an increase in water rates in FY 2024 of 8%. This expense is directly offset by sales tax revenue. 9.Chemicals increased from $484,700 in FY 2023 to $622,500 in FY 2024. Chlorine increased from $40,675 in FY 2023 to $90,000 in FY 2024. Lime increased from $335,000 in FY 2023 to $400,000 in FY 2024. Carbon dioxide increased from $24,500 in FY 2023 to $30,000 in FY 2024. Flouride increased from $11,000 in FY 2023 to $15,000 in FY 2024. Phosphate increased from $64,150 in FY 2023 to $75,000 in FY 2024. Polymer increased from $9,375 to $12,500 in FY 2024. 10.Hauling Contract increased from $165,000 in FY 2023 to $330,000 in FY 2024 based on FY 2023 actual price per ton.The amount of hauled tons of lime sludge is highly variable from year to year and is based on hauling approximately 27,000 tons per year. FY 2022 actual expense was $267,552. 11.Other Professional Services increased from $108,600 in FY 2023 to $145,200 in FY 2024. This line item includes a leak survey ($18,000) and water storage tank inspections ($15,000). 12.Technology Services increased from $97,254 in FY 2023 to $104,832 in FY 2024. This line item includes the following: -24- Software FY 2024 Water Administration Laserfiche License 282 iPad Internet Service 720 Water Meters Tokay Software 10,000 WaterSmart 32,000 Neptune360 (50%)24,000 Water Plant Operations Scada Tech Support For Rockwell Software 4,900 Hach Wims And Access Technologies 31,000 Water Distribution AutoCAD 1,930 Total Software $104,832 13.Valves/Fittings increased from $125,472 in FY 2023 to $142,266 in FY 2024 based on FY 2022 actual. This line item represents the purchase of water pipe, special fitting and tapping material for the distribution system. There is associated revenue budgeted in taps ($33,147) and taps services ($9,246) that covers these expenses. This line item represents the material cost only for valves in the distribution system and ongoing valve replacement and maintenance internally in the plant. -25- Machinery & Equipment 1.Equipment replacement items at the maintenance level include ($788,130): Water Machinery and Equipment Water Administration Smart Phone (1)$ 350 Meters Smart Phone (2)$ 450 Plant Operation & Maintenance Smart Phone (2)$ 800 Front Entryway Chairs $ 1,500 Water Distribution System Double Axle Trailer $ 23,000 Hydrants $ 70,000 Electric Pump (2)$ 1,500 Cut Off Saw $ 1,800 Hydraulic Pump $ 3,000 Tapping Machine $ 6,500 R2 GPS $ 8,000 Smartphones (3)$ 1,750 Annual Maintenance Projects Pump Replace Vacuum Filter $ 15,000 Backup Pump Vacuum Filter $ 15,000 Annual Maintenance Programs $ 638,000 Recommended Improvement Packages $ 1,480 Total Equipment $ 788,130 Debt Service 2.Annual debt service reflects repayment to ($2,689,548): Amount Debt Series Source Purpose Final Payment Call Date $ 58,700 SRF 2007A Water Fees Clear Wells 2028 $ 218,238 SRF Series 2009 Water Fees Meter Change-Out 2031 $ 426,100 Revenue 2021C Water Fees Water Improvements 2030 2028 $ 107,104 G.O. 2018A Water Fees Water Improvements 2031 2026 $ 37,480 G.O. 2021A Water Fees Water Improvements 2032 2028 $ 140,763 G.O. 2021A Water Fees Water Improvements 2033 2026 $ 653,800 G.O. 20121A Water Fees Water Improvements 2032 2028 $ 42,288 G.O. 2016C Water Fees Water Improvements 2033 2024 $ 674,180 SRF 2017 Water Fees CIWA Purchase/Imp 2036 $ 268,920 SRF 2019 Water Fees Roosevelt Water Tower 2038 $ 61,975 SRF 2021 Water Fees Water Improvements 2041 $ 2,689,548 Total Water Annual Debt Service -26- Revenue 1.Water User Fees increased from $10,195,050 in FY 2023 to $10,996,706 in FY 2024 based on FY 2022 actual of $9,464,186 plus the FY 2024 projected rate increase of 8% from FY 2023 budget. 2.Flat Rates increased from $54,958 in FY 2023 to $57,706 in FY 2024. FY 2022 actual was $41,714. This charge is for customers purchasing bulk water. Rates are set by City ordinance. 3.Fire Protection Rates increased from $186,975 in FY 2023 to $196,324 in FY 2024 based on FY 2022 actual of $191,821. This fee is the demand charge for fire sprinkler head connection. The rates are set by City ordinance. 4.Taps decreased from $65,000 in FY 2023 to $33,147 in FY 2024. FY 2022 actual was $63,850. 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. 5.Tap Service decreased from $20,000 in FY 2023 to $9,246 in FY 2024. FY 2022 actual was $15,340. 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 the Engineering Assistant. 6.Connection Charge Front Footage is decreased from $103,000 in FY 2023 to $77,788 in FY 2024 based on FY 2022 actual. FY 2022 actual was $63,417. 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. 7.Backflow Prevention Administrative Fees decreased from $76,150 in FY 2023 to $75,832 in FY 2024 based on actual number of accounts. FY 2022 actual was $75,832. This is the $25 annual fee charged to all customers with a backflow device. 8.Penalties for late payments decreased from $95,748 in FY 2023 to $45,980 in FY 2024 based on FY 2022 actual of $45,980. 9.Tower Monthly Rental increased from $132,331 in FY 2023 to $145,557 in FY 2024 based on water lease contract amounts. FY 2022 actual was $144,393. 10.Sales Tax Collected increased from $499,458 in FY 2023 to $545,649 in FY 2024 based on the rate increase for water fees. This line item off-sets the sales tax expense. -27- -28- WATER DEPARTMENT The Water Department ensures our community has high quality, safe, reliable and affordable drinking water. SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES -29- WATER DEPARTMENT FY 2022 FY 2023 FY 2024 Full-Time Equivalent 26.07 26.07 27.07 Resources Support $15,461,447 $11,630,469 $12,336,834 FY 2022 FY 2023 FY 2024 Operating Revenue $0 $5,000,000 $10,000,000 $15,000,000 $20,000,000 The Water Department is supported by 27.07 full-time equivalent employees, which accounts for 21.97% of the department expense as seen below. Overall, the department's expenses are expected to increase by 16.95% in FY 2024 compared to FY 2023. Expenditures by Category by Fiscal Year FY 2022 FY 2023 FY 2024Employee ExpenseSupplies and ServicesEquipmentAdmin OverheadUtility BillingPILOTConstruction FundDebt ServiceEngineering Charges$0 $2,500,000 $5,000,000 $7,500,000 $10,000,000 -30- 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 64042100 FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd Expenditures $9,570,599 $5,296,426 $6,518,617 Resources $3,686,304 $—$— Water Administration Position Summary FY 2024 Water Department Manager 1.00 Water Distribution Supervisor 1.00 Water Engineering Assistant 1.00 Confidential Account Clerk 1.00 GIS Specialist 1.00 GIS Intern 0.50 Total FT Equivalent Employees 5.50 Performance Measures City Council Goal: Financially Responsible, High-Performance Organization Performance Measure (KPI)Target FY 2021 Actual FY 2022 Actual FY 2023 Estimated Performance Indicator 1 Activity Objective: Maintain a financially-viable water utility. # of hours that staff are completing annual training (hrs) to support CEUs and professional development in emergency response 20 35 35 35 Reduction of Water Quality Issues per 100 miles of Pipe <20 21 15 15 % of lost/unaccounted for water <18%16.5%17.9%18% % of projects completed within the program budget 100%100%100%100% Operating cost coverage for water (Total operational Revenue/Total Operating Cost) 1.0 1.04 1.3 1.0 -31- 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 plant operators. In addition to these tests, the Dubuque W&RRC Laboratory performs over 60 bacteriological analysis of the drinking water on a monthly basis. Other compliance- related testing is performed by the University of Iowa Hygienic Laboratory. All of these analytical measures ensure the water reaching homes is of drinking-water quality. Plant Operations and Maintenance Funding Summary 64042400 FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd Expenditures $2,655,906 $2,646,400 $3,185,155 Resources $57 $1,400 $72 Plant Operations and Maintenance Position Summary FY 2024 Industrial Electronic Technician 1.00 Equipment Mechanic 1.00 Plant Operator I 1.00 Plant Operator II 1.00 Plant Operator III & IV 1.00 Plant Operator IV 3.00 Total FT Equivalent Employees 8.00 Performance Measures City Council Goal: Sustainable Environment Performance Measure (KPI)Target FY 2021 Actual FY 2022 Actual FY 2023 Estimated Performance Indicator 1 Activity Objective: Provide water treatment and distribute high-quality, clean drinking water that meets or exceeds drinking water regulations. # of Regulatory Compliance as No Violations 0 0 0 0 Water Plant Process Efficiency measured as Water Treated vs Produced(MGD Treated/MGD Produced) 1.1 .94 .97 1.0 Cost Effectiveness of the Treatment Process (O&M Cost/MG, thousands)<or= 1.0 0.94 1.0 1.0 The 2022 Water Quality Report can be downloaded at: https://www.cityofdubuque.org/waterquality -32- WATER DEPARTMENT Water Distribution Mission & Services The function of the Water Distribution Team is to safely transport potable water from the source to point of use. Distribution is also responsible for the machinery, equipment, materials and personnel required to repair main breaks; install water mains, control valves and fire hydrants and assist other sections of the Water Department. It is our goal to operate and maintain a water distribution system consistent with established procedures recognized by the American Water Works Association for efficient management practices and to meet Federal, State and local rules and regulations. Water Distribution Funding Summary FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd Expenditures $1,124,281 $1,357,268 $1,263,173 Resources $11,661,503 $11,483,981 $12,225,628 Water Distribution Position Summary FY 2024 Equipment Operator II 1.00 Water Distribution Foreman 1.00 Water Distribution Maintenance Worker 6.00 Custodian I 0.07 Total FT Equivalent Employees 8.07 Performance Measures City Council Goal: Financially Responsible, High-Performance Organization Performance Measure (KPI)Target FY 2021 Actual FY 2022 Actual FY 2023 Estimated Performance Indicator 1 Activity Objective: Ensure the integrity of the distribution system piping system. # of breaks per 100 miles of pipe <15 27 33 30 Operation of 10% of system valves annually 775 314 215 300 Hydrant effectiveness (out of service rate) <1% or 25FH <1%0%<1%<1% O&M costs for water per 100 miles of pipe (thousands per 100 miles)<343**311 403 350 ** Based on 3year 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 330.05 miles of public water mains ranging in diameter from 4" up to 30"; 7,391 control valves; and 2,860 fire hydrants. -33- 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 64042300 FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd Expenditures $347,955 $383,977 $536,215 Resources $132,185 $158,071 $132,184 Water Meters Position Summary FY 2024 Water Meter Repair Worker I 2.00 Water Distribution Maintenance Worker 1.00 Total Full-Time Equivalent Employee’s 3.00 Performance Measures City Council Goal: Sustainable Environment Performance Measure (KPI)Target FY 2021 Actual FY 2022 Actual FY 2023 Estimated Performance Indicator 1 Activity Objective: Minimize the possibility of contamination in the distribution through the installation of backflow prevention devices. High and Low Hazard Containment Services, by definition, to participate in the backflow prevention program 100%98%99%99% City Council Goal: Financially Responsible, High-Performance Organization 1 Activity Objective: Respond to customer inquiries in a timely manner to maintain consumer confidence in the water utility. Respond to technical Meter Department service issues.100%100%100%100% Enhanced meter reading accuracy, larger users: O&M on all large meters (>3") per AWWA standards (lg meter/yr) 24/yr 10/yr*18/yr*24yr **Numbers to include partial year of 5 year MIU replacement 450 to 900 -34- Recommended Operating Revenue Budget - Department Total 42 - WATER Fund/Account/Account Title FY21 Actual Revenue FY22 Actual Revenue FY23 Adopted Budget FY24 Recomm'd Budget 600 - Water Operating 4A - Charges for Services 41380 - Water/Sewer Permit (134,615) (144,393) (132,331) (145,557) 45090 - Meter Rates (8,547,478) (9,464,186) (10,195,050) (10,996,706) 45095 - Fire Protection Rates (186,975) (191,821) (186,975) (196,324) 45100 - Flat Rates (56,559) (41,714) (54,958) (57,706) 45105 - Unapplied Credits (26,124) (23,071) (26,124) (23,071) 45125 - Meter Sales - Remotes (16,304) (13,609) (16,304) (13,609) 45126 - Meters - Sales (54,239) (28,917) (54,239) (28,917) 45127 - UFR Device - Sales (3,047) (2,938) (3,047) (2,938) 45128 - Meter Repair (8,257) (10,409) (8,257) (10,409) 45234 - UB-Water Repair Grt Temp Hold 0 200 0 0 45300 - Forfeitures/Penalties (2,798) (45,980) (95,748) (45,980) 45325 - Meter Tampering Fee (394) (741) (394) (741) 45350 - Shut Off Penalties (4,178) (9,965) (4,178) (9,965) 45400 - Connect Fees (74,406) (75,832) (76,150) (75,832) 45410 - Connect Fee Large Svc (4,943) (15,340) (20,000) (9,246) 45415 - Connect Fee Front Footage (92,811) (63,417) (103,000) (77,788) 45420 - Taps (23,302) (63,850) (65,000) (33,147) 45500 - Miscellaneous Chg for Svcs (7,191) (8,978) (7,192) (8,978) 45520 - Customer Credits 0 0 0 0 47100 - Reimbursements (14,662) (4,000) (14,663) (4,000) 47150 - Refunds 0 (57) 0 0 47200 - Insurance Settlements (6,102) (13,834) (6,102) (13,466) 47450 - Sale of Salvage (2,115) (1,771) (2,115) (1,386) 4A - Charges for Services Total (9,266,501) (10,224,623) (11,071,827) (11,755,766) 4B - Grants/Contrib 44400 - State Grants — — — — 4B - Grants/Contrib Total — — — — 4K - Unrest Invest Earn 43000 - Interest (59,184) (25,600) (59,184) (35,419) 4K - Unrest Invest Earn Total (59,184) (25,600) (59,184) (35,419) 4N - Transfers 49100 - Transfer In General Fund (21,315) (22,352) (25,000) (25,000) 4N - Transfers Total (21,315) (22,352) (25,000) (25,000) 4O - Eliminated for GW 47115 - Sales Tax Collection (461,820) (494,920) (499,458) (545,649) 48200 - Proceeds from GO Debt (7,839,768) (3,505,000) — — 48205 - Bond Discount/Premium (379,068) (181,304) — — 48250 - Proceeds from SRF (2,150,000) (1,030,000) — — 4O - Eliminated for GW Total (10,830,656) (5,211,224) (499,458) (545,649) WATER - Total (20,177,656)(15,483,799)(11,655,469)(12,361,834) -35- 6A - Salaries & Wages 600 - Water Operating 60100 - Salaries-Regular Full Time 1,379,223 1,448,555 1,645,097 1,797,372 60200 - Salaries - Regular Part Time 9,568 16,368 29,685 31,726 60300 - Hourly Wages - Temp/Seasonal 6,710 710 16,046 16,784 60400 - Overtime 105,353 129,894 94,040 94,040 60410 - Overtime - Holiday 24,662 24,050 18,600 17,000 60630 - Special Pay Sick Lv Payout Ret 31,872 31,935 11,094 11,094 60635 - Special Pay Sick Lv Payout 50% 1,841 3,055 1,841 3,585 60640 - Special Pay - Vacation Payout 12,190 8,890 0 0 60710 - Special Pay - Parental Leave 0 0 0 0 60720 - Spec Pay - Meals No Overnight 0 82 0 50 60730 - Spec Pay - Safety Equipment 17,248 3,802 4,750 5,500 60740 - Spec Pay - Meal Allowance 809 1,055 809 2,000 60780 - Spec Pay - Tank Climb Pay 165 30 1,200 1,200 6A - Salaries & Wages Total 1,589,640 1,668,427 1,823,162 1,980,351 6B - Employee Benefits 600 - Water Operating 61100 - FICA - City Contribution 114,118 120,057 138,925 149,800 61300 - IPERS - City Contribution 144,024 152,637 178,689 184,845 61510 - Health Insurance 319,780 332,464 328,864 342,696 61540 - Life Insurance 976 964 1,150 1,196 61600 - Workers' Compensation 78,771 48,369 43,398 40,389 61992 - Physicals 142 1,107 142 1,107 6B - Employee Benefits Total 657,812 655,598 691,168 720,033 6C - Staff Development 600 - Water Operating 62100 - Association Dues 2,869 2,298 4,423 5,770 62200 - Subscriptions 158 0 540 540 62325 - Mileage 1,628 1,928 3,974 4,724 62400 - Meetings & Conferences 52 473 4,850 5,350 62500 - Education Reimbursement 4,244 20,345 15,139 20,797 6C - Staff Development Total 8,950 25,044 28,926 37,181 6D - Repair/Maint/Util 600 - Water Operating 63100 - Building Maintenance 43,730 49,910 45,170 49,910 63312 - Vehicle Ops - Gasoline 26,448 38,973 22,435 29,380 63320 - Vehicle Repair - Internal 34,923 40,678 32,576 45,625 63321 - Vehicle Repair - Outsourced 9,414 3,164 4,335 6,920 63322 - Vehicle Repair - Accident 0 0 0 0 63400 - Equipment Maint/Repair 63,208 57,990 63,457 61,918 63425 - Meter Maintenance 3,494 392 8,058 2,000 63430 - Instrument Maintenance 13,520 29,704 13,520 30,298 63710 - Electricity 730,336 768,106 668,402 969,299 63711 - Natural Gas 33,216 46,462 39,992 53,580 63730 - Telecommunications 22,409 22,048 19,370 25,798 63742 - Stormwater 418 1,460 453 1,557 63790 - Other Utility Expense 0 9,779 1,500 15,000 6D - Repair/Maint/Util Total 981,115 1,068,666 919,268 1,291,285 6E - Contractual Svcs 600 - Water Operating Recommended Operating Expenditure Budget - Department Total 42 - WATER Fund/Account/Account Title FY21 Actual Expense FY22 Actual Expense FY23 Adopted Budget FY 24 Recomm'd Budget -36- 64010 - Accounting & Auditing 3,600 3,800 3,708 3,800 64020 - Advertising 3,599 2,930 3,516 2,930 64030 - Outsourced Labor 0 0 0 0 64040 - Collections 919 1,452 890 1,452 64045 - Bad Debt Expense 0 0 0 0 64062 - Refunds (6,119) 937 0 937 64080 - Insurance - Property 67,130 84,648 89,389 104,741 64081 - Insurance - Liability 21,391 25,199 29,293 28,064 64083 - Insurance - Other 0 0 0 0 64110 - Legal 1,916 27,713 0 0 64135 - Grants 3,452 795 10,000 10,000 64140 - Printing 376 1,982 1,055 1,270 64145 - Copying 2,848 1,625 3,491 3,509 64150 - Rental - Equipment 8,622 4,731 8,622 10,000 64160 - Rental - Land/Bldgs/Parking 3,942 660 3,942 660 64175 - Landfill Fees 152 67 152 152 64180 - Sales Tax Expense 460,710 488,525 460,710 545,649 64185 - License/Permit/Fees 7,209 6,860 7,209 6,860 64190 - Technology Services 56,237 48,675 97,254 104,832 64191 - IT Recharges 0 0 0 21,743 64820 - One Call 8,657 7,406 7,226 7,406 64825 - Fire Suppression 435 1,082 435 1,082 64865 - Elevator Service 2,410 2,473 2,410 2,410 64870 - HVAC Services 2,735 3,570 3,744 3,744 64880 - Custodial Services 0 0 0 0 64900 - Other Professional Service 82,067 71,132 108,600 145,200 64975 - Equip Maint Cont 1,963 1,944 1,963 1,944 64980 - Technology Equip Maint Cont 21,054 21,054 20,800 12,777 64985 - Hauling Contract 212,476 267,552 165,000 330,000 64990 - Other Contractual Service 0 0 6,000 6,000 6E - Contractual Svcs Total 967,782 1,076,811 1,035,409 1,357,162 6F - Commodities 600 - Water Operating 65010 - Chemicals 428,705 442,320 484,700 622,500 65040 - Small Tools & Equipment 15,353 10,403 17,201 14,379 65045 - Technology Equipment 436 5,541 81,312 4,830 65050 - Other Equipment 0 49,209 64,500 50,800 65054 - Safety Equipment 926 0 1,000 0 65060 - Office Supplies 4,460 1,867 7,760 3,101 65080 - Postage/Shipping 2,039 2,407 2,080 2,658 65100 - Safety Supplies 8,196 8,122 8,361 8,122 65925 - Uniform Purchase 17,962 19,687 20,070 27,000 65950 - Valves/Fittings 98,300 142,266 125,472 142,266 65960 - Repair Parts 4,230 4,730 7,136 4,829 65965 - Janitorial 3,358 4,998 3,734 5,188 65970 - Lab Supplies 13,216 21,830 13,480 21,830 65975 - Plumbing Supplies 697 67 1,235 70 65980 - Construction Supplies 2,074 817 2,037 926 65981 - Street Materials 0 0 0 0 65990 - Other Supplies 4,734 10,386 4,829 10,386 6F - Commodities Total 604,687 724,651 844,907 918,885 Recommended Operating Expenditure Budget - Department Total 42 - WATER Fund/Account/Account Title FY21 Actual Expense FY22 Actual Expense FY23 Adopted Budget FY 24 Recomm'd Budget -37- 6G - Capital Outlay 600 - Water Operating 67100 - Vehicles 92,263 0 66,000 0 67210 - Furniture/Fixtures 2,033 0 0 1,500 67230 - Heavy Equipment 141,426 0 0 23,000 67250 - Office Equipment 0 0 0 0 67270 - Other Capital Equipment 0 0 8,000 18,000 67500 - Buildings 0 0 0 0 67809 - Water - Meters 54,243 97,088 0 0 67810 - Water - Large Meters 85,640 18,886 191,306 200,000 67815 - Water - Hydrants 32,351 30,877 70,000 70,000 67990 - Other Capital Outlay 298,071 379,271 484,000 420,000 6G - Capital Outlay Total 706,026 526,122 819,306 732,500 6H - Debt Service 600 - Water Operating 68010 - Principal Payment 11,138,835 6,824,142 2,078,929 2,112,595 68020 - Interest Payments 830,372 615,593 613,541 576,953 68980 - Financial Consultant 14,139 31,250 14,139 0 68990 - Paying Agent Fees 971 447 971 0 6H - Debt Service Total 11,984,316 7,471,433 2,707,580 2,689,548 6I - Transfers 600 - Water Operating 69100 - Transfers Out To General Fund 567,194 578,155 595,651 1,512,215 69601 - Transfers Out to Water Cap 550,000 400,000 1,000,000 1,000,000 6I - Transfers Total 1,117,194 978,155 1,595,651 2,512,215 WATER - Total 18,617,522 14,194,908 10,465,377 12,239,160 Recommended Operating Expenditure Budget - Department Total 42 - WATER Fund/Account/Account Title FY21 Actual Expense FY22 Actual Expense FY23 Adopted Budget FY 24 Recomm'd Budget -38- 0000 - No Sub-Activity 600 - Water Operating 6E - Contractual Svcs ——— 6I - Transfers 978,155 1,595,651 2,512,215 0000 - No Sub-Activity Total 978,155 1,595,651 2,512,215 4201 - Administration 600 - Water Operating 6A - Salaries & Wages 388,285 319,704 523,463 6B - Employee Benefits 143,733 110,811 170,659 6C - Staff Development 6,597 9,403 15,500 6D - Repair/Maint/Util 1,189 1,872 1,872 6E - Contractual Svcs 579,595 485,655 604,534 6F - Commodities 1,612 65,750 826 6G - Capital Outlay ——— 6H - Debt Service 7,471,433 2,707,580 2,689,548 6I - Transfers ——— 4201 - Administration Total 8,592,444 3,700,775 4,006,402 4202 - Meters 600 - Water Operating 6A - Salaries & Wages 196,790 204,143 310,200 6B - Employee Benefits 78,704 81,766 111,452 6C - Staff Development 3,615 5,086 5,678 6D - Repair/Maint/Util 18,531 16,695 24,226 6E - Contractual Svcs 44,952 68,394 73,289 6F - Commodities 5,363 7,893 11,370 6G - Capital Outlay 0 0 0 4202 - Meters Total 347,955 383,977 536,215 4203 - Plant Operations and Maint 600 - Water Operating 6A - Salaries & Wages 558,249 647,892 599,276 6B - Employee Benefits 227,290 253,971 226,074 6C - Staff Development 6,064 3,501 4,567 6D - Repair/Maint/Util 926,354 799,465 1,146,637 6E - Contractual Svcs 401,443 346,655 526,904 6F - Commodities 536,506 528,916 680,197 6G - Capital Outlay 0 66,000 1,500 4203 - Plant Operations and Maint Total 2,655,906 2,646,400 3,185,155 4204 - Distribution System 600 - Water Operating 6A - Salaries & Wages 525,103 651,423 547,412 6B - Employee Benefits 205,871 244,620 211,848 6C - Staff Development 8,769 10,936 11,436 6D - Repair/Maint/Util 122,592 101,236 118,550 6E - Contractual Svcs 49,898 51,705 69,435 6F - Commodities 181,170 227,348 211,492 6G - Capital Outlay 30,877 70,000 93,000 4204 - Distribution System Total 1,124,281 1,357,268 1,263,173 4220 - Storage Tank Inspection Recommended Expenditure Budget Report by Activity & Funding Source 42 - WATER Fund/Activity FY22 Actual Expense FY23 Adopted Budget FY24 Recomm'd Budget -39- 600 - Water 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 - Water Operating 6F - Commodities 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 - Water Operating 6E - Contractual Svcs 128 0 0 4225 - GIS Maint/Updates Total 128 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 - Water Operating 6G - Capital Outlay 5,900 84,000 20,000 4227 - Valve Replacement Total 5,900 84,000 20,000 4228 - Internal Lines Loan 600 - Water Operating 6G - Capital Outlay 7,283 0 0 4228 - Internal Lines Loan Total 7,283 0 0 4229 - Main Replacements 600 - Water Operating 6A - Salaries & Wages 0 0 0 6B - Employee Benefits 0 0 0 6F - Commodities 0 0 0 6G - Capital Outlay 311,150 350,000 350,000 4229 - Main Replacements Total 311,150 350,000 350,000 4230 - Meter Exchange 600 - Water Operating 6G - Capital Outlay 115,974 191,306 200,000 4230 - Meter Exchange Total 115,974 191,306 200,000 4231 - Leak Repair Grant 600 - Water Operating 6E - Contractual Svcs 795 5,000 5,000 4231 - Leak Repair Grant Total 795 5,000 5,000 4232 - Valve Box Maintenance 600 - Water Operating 6G - Capital Outlay 47,365 25,000 25,000 Recommended Expenditure Budget Report by Activity & Funding Source 42 - WATER Fund/Activity FY22 Actual Expense FY23 Adopted Budget FY24 Recomm'd Budget -40- 4232 - Valve Box Maintenance Total 47,365 25,000 25,000 4234 - Generator Maintenance 600 - Water Operating 6G - Capital Outlay 0 8,000 18,000 4234 - Generator Maintenance Total 0 8,000 18,000 4235 - County Water Assistance 600 - Water Operating 6E - Contractual Svcs 0 5,000 5,000 4235 - County Water Assistance Total 0 5,000 5,000 4236 - Water Meter Testing 600 - Water Operating 6G - Capital Outlay 7,573 25,000 25,000 4236 - Water Meter Testing Total 7,573 25,000 25,000 4237 - Water Leak Survey 600 - Water Operating 6E - Contractual Svcs 0 18,000 18,000 4237 - Water Leak Survey Total 0 18,000 18,000 4299 - Pcard Clearing 600 - Water Operating 6F - Commodities 0 0 0 4299 - Pcard Clearing Total 0 0 0 WATER TOTAL 14,194,908 10,465,377 12,239,160 Recommended Expenditure Budget Report by Activity & Funding Source 42 - WATER Fund/Activity FY22 Actual Expense FY23 Adopted Budget FY24 Recomm'd Budget -41- C I T Y O F D U B U Q U E , I O W A DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 42 WATER DEPARTMENT FY 2022 FY 2023 FY 2024 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 $ 112,150 1.00 $ 100,347 1.00 $ 110,672 640 3200 GE-36 WATER DISTRIBUTION SUPERVISOR 1.00 $ 93,267 1.00 $ 96,307 1.00 $ 98,815 640 — GE-36 WATER OPERATIONS SUPERVISOR 1.00 $ 72,370 1.00 $ 74,730 1.00 $ 82,490 640 2950 GE-33 WATER ENGINEERING ASSISTANT 1.00 $ 77,143 1.00 $ 79,653 1.00 $ 83,315 640 2650 GE-31 WATER METER FOREMAN —$ — —$ — 1.00 $ 75,563 640 2650 GE-31 FOREPERSON - WATER DISTR.1.00 $ 69,277 1.00 $ 71,870 1.00 $ 75,563 640 2610 GE-30 GIS SPECIALIST 1.00 $ 66,299 1.00 $ 68,450 1.00 $ 71,598 640 GE-25 CONFIDENTIAL ACCOUNT CLERK 1.00 $ 50,255 1.00 $ 51,879 1.00 $ 54,716 640 2400 OE-16 ELECTRONIC TECHNICIAN 1.00 $ 66,645 1.00 $ 69,105 1.00 $ 80,844 640 2800 OE-14 EQUIPMENT MECHANIC 1.00 $ 63,616 1.00 $ 63,768 1.00 $ 66,699 640 2550 OE-16 WATER PLANT OPR CERT GR III/IV 1.00 $ 60,812 1.00 $ 65,814 1.00 $ 60,357 640 OE-11 WATER PLANT OPERATOR CRT GR I —$ — 1.00 $ 56,355 1.00 $ 61,283 640 2475 OE-12 WATER PLANT OPERATOR CRT GR II 1.00 $ 59,260 1.00 $ 61,179 1.00 $ 63,992 640 2475 OE-16 WATER PLANT OPERATOR CRT GR IV 4.00 $ 261,999 3.00 $ 202,706 3.00 $ 212,716 640 2305 OE-10 EQUIPMENT OPERATOR II 1.00 $ 58,074 1.00 $ 60,167 1.00 $ 62,933 640 1775 OE-09 WATER METER REPAIR WORKER I 2.00 $ 113,210 2.00 $ 118,098 2.00 $ 124,488 640 OE-14 WATER METER REPAIR WORKER II 1.00 $ 62,381 1.00 $ 64,537 —$ — 640 1476 OE-09 WATER DISTR MAINTENANCE WORKER 6.00 $ 322,400 6.00 $ 340,132 7.00 $ 412,309 TOTAL FULL TIME EMPLOYEES 25.00 $ 1,609,158 25.00 $ 1,645,097 26.00 $ 1,798,353 61020 Part-Time Employee Expense 640 1476 OE-09 WATER DISTR MAINTENANCE WORKER 0.50 $ 25,599 0.50 $ 26,434 0.50 $ 28,326 640 2050 OE-03 CUSTODIAN I 0.07 $ 3,461 0.07 $ 3,251 0.07 $ 3,400 TOTAL PART TIME EMPLOYEES 0.57 $ 29,060 0.57 $ 29,685 0.57 $ 31,726 61030 Seasonal Employee Expense 640 NA-37 GIS INTERN 0.50 $ 15,545 0.50 $ 16,046 0.50 $ 16,784 TOTAL SEASONAL EMPLOYEES 0.50 $ 15,545 0.50 $ 16,046 0.50 $ 16,784 TOTAL WATER DEPARTMENT 26.07 $ 1,653,763 26.07 $ 1,690,828 27.07 $ 1,846,863 -42- Water Administration-FT 64042100 61010 640 2610 GE-30 GIS SPECIALIST 1.00 $ 66,299 1.00 $ 68,450 1.00 $ 71,598 64042100 61010 640 3275 GE-40 WATER DEPARTMENT MANAGER 1.00 $ 112,150 1.00 $ 100,347 1.00 $ 110,672 64042100 61010 640 GE-25 CONFIDENTIAL ACCOUNT CLERK 1.00 $ 50,255 1.00 $ 51,879 1.00 $ 54,716 64042100 61010 640 2950 GE-33 WATER ENGINEERING ASSISTANT 1.00 $ 77,143 1.00 $ 79,653 1.00 $ 83,315 64042400 61010 640 GE-36 WATER OPERATIONS SUPERVISOR —$ — —$ — 1.00 $ 82,490 64042100 61010 640 3200 GE-37 WATER DISTRIBUTION SUPERVISOR 1.00 $ 93,267 —$ — 1.00 $ 98,815 Total 5.00 $ 399,114 4.00 $ 300,329 6.00 $ 501,606 Water Administration-SEASONAL 64042100 61030 640 NA-37 GIS INTERN 0.50 $ 15,545 0.50 $ 16,046 0.50 $ 16,784 Total 0.50 $ 15,545 0.50 $ 16,046 0.50 $ 16,784 Water Meters-FT 64042300 61010 640 1775 OE-09 WATER METER REPAIR WORKER I 2.00 $ 113,210 2.00 $ 118,098 2.00 $ 124,488 64042300 61010 640 OE-14 WATER METER FOREMAN 1.00 $ 75,563 64042300 61010 640 OE-14 WATER METER REPAIR WORKER II 1.00 $ 62,381 1.00 $ 64,537 —$ — 64042300 61010 640 1476 OE-09 WATER DISTR MAINTENANCE WORKER —$ — —1.00 $ 60,431 Total 3.00 $ 175,591 3.00 $ 182,635 4.00 $ 260,482 Water Meters-PT 64042300 61020 640 1476 OE-09 WATER DISTR MAINTENANCE WORKER —$ — —0.50 $ 28,326 Total —$ — —$ — 0.50 $ 28,326 Water Plant Operation-FT 64042400 61010 640 OE-11 WATER PLANT OPERATOR CRT GR I —$ — 1.00 $ 56,355 1.00 $ 61,283 64042400 61010 640 2475 OE-12 WATER PLANT OPERATOR CRT GR II 1.00 $ 59,260 1.00 $ 61,179 1.00 $ 63,992 64042400 61010 640 2550 OE-16 WATER PLANT OPR CERT GR III/IV 1.00 $ 60,812 1.00 $ 65,814 1.00 $ 60,357 64042400 61010 640 OE-16 WATER PLANT OPERATOR CRT GR IV 4.00 $ 261,999 3.00 $ 202,706 3.00 $ 212,716 64042400 61010 640 GE-36 WATER OPERATIONS SUPERVISOR 1.00 $ 72,370 1.00 $ 74,730 —$ — 64042400 61010 640 2800 OE-16 ELECTRONIC TECHNICIAN 1.00 $ 66,645 1.00 $ 69,105 1.00 $ 80,844 64042400 61010 640 3015 OE-14 EQUIPMENT MECHANIC 1.00 $ 63,616 1.00 $ 63,768 1.00 $ 66,699 Total 9.00 $ 584,702 9.00 $ 593,657 8.00 $ 545,891 Water Distribution-FT 64042700 61010 640 1476 OE-09 WATER DISTR MAINTENANCE WORKER 6.00 $ 322,400 6.00 $ 340,132 6.00 $ 351,878 64042700 61010 640 3200 GE-36 WATER DISTRIBUTION SUPERVISOR —$ — 1.00 $ 96,307 —$ — 64042700 61010 640 2305 OE-10 EQUIPMENT OPERATOR II 1.00 $ 58,074 1.00 $ 60,167 1.00 $ 62,933 64042700 61010 640 2650 GE-31 FOREPERSON - WATER DISTR.1.00 $ 69,277 1.00 $ 71,870 1.00 $ 75,563 Total 8.00 $ 449,751 9.00 $ 568,476 8.00 $ 490,374 Water Distribution - PT 64042700 61020 640 1476 OE-09 WATER DISTR MAINTENANCE WORKER 0.50 $ 25,599 0.50 $ 26,434 — 64042700 61020 640 2050 GD-03 CUSTODIAN I 0.07 $ 3,461 0.07 $ 3,251 0.07 $ 3,400 Total 0.57 $ 29,060 0.57 $ 29,685 0.07 $ 3,400 TOTAL WATER DEPARTMENT 26.07 $ 1,653,763 26.07 $ 1,690,828 27.07 $ 1,846,863 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2022 FY 2023 FY 2024 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -43- 4281000001 SCADA and Communications Imp Water 601 67990 1,075,000 4281000005 Water Main Replacements - Streets Water 601 67990 544,500 4281000006 Wells/Well Field Rehab Water 601 64070 20,000 4281000006 Wells/Well Field Rehab Water 601 67990 160,000 4281000013 Water Meter Replacement Water 601 64900 442,500 4281000013 Water Meter Replacement Water 601 67270 125,000 4281000015 Generator-Park hill&MtCaramel Water 601 67990 30,000 4281000018 Fire hydrant Recl/replc Water 601 67990 20,000 4281000022 Water main replc-Sewer prog Water 601 64070 12,000 4281000022 Water main replc-Sewer prog Water 601 67990 120,000 4281000024 Public lead line water replc Water 601 64070 40,000 4281000024 Public lead line water replc Water 601 67990 310,000 4281000026 Water Treatment Plant Plan Water 601 64070 200,000 4281000043 MCFADDEN WATER MAIN IMP Water 601 64070 55,800 4281000043 MCFADDEN WATER MAIN IMP Water 601 67990 497,610 4281000044 WTP Roof Repair Water 601 67990 125,000 4281000045 Green Alley Water Main Imp Water 601 64070 26,000 4281000045 Green Alley Water Main Imp Water 601 67990 280,000 4281000048 West End Annex Study & Imp Phase I Water 601 64070 100,000 4281000048 West End Annex Study & Imp Phase I Water 601 67990 600,000 4281000050 Private Lead Line Replacement Prog Water 601 64070 348,150 4281000050 Private Lead Line Replacement Prog Water 601 67990 5,000,000 4281000051 Source Water PFAS Red - Deep Water Water 601 64070 550,000 4281000051 Source Water PFAS Red - Deep Water Water 601 67990 600,000 4281000054 Water Treatment Boiler Replacements Water 601 67500 100,000 4281000055 West 32nd Dev - Water Main Water 601 64070 25,000 4281000055 West 32nd Dev - Water Main Water 601 67990 191,000 WATER TOTAL 11,597,560 Capital Improvement Projects by Department/Division WATER Project Number Capital Improvement Project Title Department Fund Account FY 24 Recomm'd Budget -44- Water Meter Replacement Program $ 567,500 $ 400,000 $ 350,000 $ — $ 130,950 $ 1,448,450 72 Water Main Upgrades during Street General Repairs $ — $ — $ — $ — $ 20,000 $ 20,000 73 Fire Hydrant Assembly Relocation/Replacement for the Sidewalk Program $ 20,000 $ — $ — $ — $ — $ 20,000 74 Water Main Replacement Consent $ 132,000 $ 212,000 $ 99,000 $ — $ 660,000 $ 1,103,000 75 Public Lead Line Water Main Replacement $ 350,000 $ — $ — $ — $ — $ 350,000 76 Wells, Well Field, & Well Transmission Piping Repair and Rehabilitation Program $ 180,000 $ — $ 110,500 $ — $ 165,000 $ 455,500 77 Water Treatment Plant Condition Assessment and Master Plan $ 200,000 $ — $ — $ — $ — $ 200,000 78 McFadden Farm Water Main $ 553,410 $ — $ — $ — $ — $ 553,410 79 SCADA & Comms Improvements $ 1,075,000 $ — $ — $ — $ — $ 1,075,000 80 Green Alley Water Main Improvements $ 306,000 $ — $ — $ — $ — $ 306,000 82 Generators-Park Hill & Mt. Carmel $ 30,000 $ — $ — $ — $ 175,000 $ 205,000 83 West End Annexation Study and Implementation Phase I $ 700,000 $ — $ — $ — $ — $ 700,000 84 Water Main Replacements - Streets $ 544,500 $ 91,790 $ 50,000 $ — $ — $ 686,290 85 North Cascade Road (from Edval Lane to Southwest Arterial) 3rd Pressure Zone $ — $ — $ — $ — $ 853,500 $ 853,500 87 Private Lead Line Replacement $ 5,348,150 $ 10,727,500 $ 10,772,200 $ 5,173,150 $ 175,000 $ 32,196,000 88 Water Treatment Boiler Replacements $ 100,000 $ — $ 236,000 $ — $ — $ 336,000 89 Water Treatment Plant Roof Replacement $ 125,000 $ — $ — $ — $ 110,000 $ 235,000 90 West 32nd Development $ 216,000 $ — $ — $ — $ — $ 216,000 91 Third Pressure Zone Connection (Tanzanite Drive to Olympic Heights)$ — $ — $ — $ 1,000,000 $ — $ 1,000,000 92 Source Water PFAS Reduction Project $ 1,150,000 $ 2,300,000 $ 750,000 $ — $ — $ 4,200,000 93 Source Water PFAS Reduction Project - Granular Activated Carbon Filter Rehabilitation $ — $ — $ — $ 1,750,000 $ 1,750,000 $ 3,500,000 94 TOTAL $ 11,597,560 $ 13,731,290 $ 12,367,700 $ 7,923,150 $ 4,039,450 $ 49,659,150 PRGRM/ DEPT PROJECT DESCRIPTION FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 TOTAL PAGE WATER DEPARTMENT Business Type -45- This page intentionally left blank. -46- WATER DEPARTMENT FISCAL YEAR 2024 BUDGET PRESENTATION MISSION STATEMENT Water Department The City of Dubuque Water Department is passionate about delivering high quality drinking water with excellent customer service, while meeting our customers’ changing needs with equitable and sustainable rates. Retirements of FY2024 Insert Image Here Insert Image Here Kerry Leppert Water Engineering Assistant 7 Years of Service Brant Schueller Water Distribution Supervisor 27 Years of Service Ken Metcalf Water Distribution Maintenance Worker 45 Years of Service Water Department FY24 (27.07 Full-Time Equivalents) Recognition of Staff for Iowa DNR Certifications Obtained Insert Image Here Insert Image Here Bob Childers -Water Distribution Grade 1 Marty Kass -Water Distribution Grade 1 Rob Blake -Water Distribution Grade 2 Jeff Mills -Water Distribution Grade 2 Darrin Homb -Water Distribution Grade 3 Marty Kearney -Water Distribution Grade 3 Steve Valentine -Water Distribution Grade 3 Luke Meadows -Water Treatment Grade 2 & Water Distribution Grade 1 Insert Image Here Insert Image Here FISCAL YEAR 2023 HIGHLIGHTS •City Well Rehabilitation Project •Well No. 8 ◦Well Pump Rebuild ◦New Motor ◦New Column Pipe •Contract Amount: $101,480 •Contractor: Peerless Well and Pump •Placed back into Service: February 2023 FISCAL YEAR 2023 HIGHLIGHTS •Water Meter Technical Upgrade Program •Water Meter Product Replacement of Meter Interface Units and Registers •5-Year Program. Initiated in FY2022. ◦In Progress •Work Performed by Water Department Meter Crew. •Total Project Cost Estimate: $1,885,000 Danny Petersen installing new MIU FISCAL YEAR 2023 HIGHLIGHTS •Kennedy Road water main extension, 4,050 lineal feet of 12” water main to Wildflower Ridge •Silver Oaks Subdivision, Phase 3 (off Elmwood Drive) •Vintage Estates Subdivision (off Kennedy Road) •Rustic Point Subdivision Phase 2 (off Kennedy Road) •Kennedy Court water main replacement, 600 lineal feet of 6” water main •Fountain Park water main replacement, 285 lineal feet of 6” water main •Stoneman Road, hydrants, valves, water main extension and sections replaced, Kennedy Mall loop connection FUTURE INITIATIVES •City Well Rehabilitation ◦Well No. 7 -Pump Replacement, Motor Replacement, and Sand/Sediment Filtration System-Cost Estimate $500,000 FUTURE INITIATIVES Drinking Water Quality Improvements: PFAS •Proposed Change to Safe Drinking Water Act (SDWA) and the National Primary Drinking Water Regulation (NPDWR) released March 14, 2023 ◦Public Comment Period to follow •Final Regulation for the SDWA: End of 2023 •Dubuque and PFAS ◦Iowa DNR Statewide Testing Initiate in 2022 ◦Detects were found in August 2022 ◦Actions taken including: ▪Taking wells off-line ▪Consulting with PFAS experts for treatment techniques and source changes ▪Development of a Capital Improvement Plan -Advancing New Deep Well(s) ▪Quarterly Testing of Dubuque’s Wells SOURCE WATER Shallow Wells No. 2, 3, 4, 9, & 10 SOURCE WATER Deep Wells No. 5, 6, 7, & 8 FUTURE INITIATIVES Lead Service Line Replacement Project •Multi Year Replacement Program for an estimated 3,257 Lead Service Lines •1st of 4 Phases Scheduled to begin in FY2024 ◦2 Year Construction period per phase ◦$0 Cost to the Owner or Tenant in Disadvantaged Communities •Funding: Bipartisan Infrastructure Law monies to Iowa State Revolving Fund Loan Program •90% Loan Forgiveness in Disadvantaged Community Areas FUTURE INITIATIVES •Emergency Response ◦Park Hill Standpipe Emergency Generator Installation Project FY 24 PROPOSED RATE INCREASE 8% Proposed Rate Increase over FY 23 $2.64 Monthly Bill Impact for Average Household* *Average Household = 6,000 Gallons/Month RATE COMPARISON FY24 Water Rate Comparison 2nd Lowest Rates:The Highest Water Rate (West Des Moines)is 19.88% Higher than Dubuque’s Rate;and the Average Rate is 5.31%Higher than Dubuque. Based Average Household = 6,000 Gallons/Month % WATER ADMINISTRATION •Employee Training and Development ◦Professional Development ◦On Boarding of New Employees ◦Continuing Education Programs •Regulatory Compliance ◦Reporting, monitoring, and working with Iowa DNR and EPA on compliance. •Capital Improvement Planning ◦Project development including budgeting, initiation, and award through construction completion. WATER TREATMENT PLANT OPERATIONS •Water Production and Treatment ◦Regulatory Compliance ◦Water Quality -Consumer Confidence •Source Water Protection ◦Wells and the Well field ◦Treatment Plant •Water Storage and Pumping Facility Operation and Maintenance •Reliable Data Access and Reporting ◦SCADA Communications WATER PLANT OPERATIONS Water Treatment Plant Condition Assessment and Plant Improvements with Strand Associates. Updated Plant Information: •Well Capacity: 14.0 to 17.5 MGD •Plant Capacity: 12.6 to 13.6 MGD •Peak Day Demand : 9.13 MGD (Routine Operations June 2021) •Peak Day Demand : 10.7 MGD* (Large Main Break November 2017) •Average Day Demand: 7.0 MGD Eagle Point Water Treatment Plant WATER PLANT OPERATIONS WATER DISTRIBUTION •Operation and Maintenance •Emergency Response •Inspection •General Construction •Service Line Main Taps •Water Main Installation •Meter Management •Backflow Prevention •Development Review WATER DISTRIBUTION WATER DISTRIBUTION *FY 2023 to date: 67 Service Taps New Connections result from community growth such as new housing, businesses, and industry. WATER DISTRIBUTION Starting in FY20, the Water Distribution Meter Crew assumed all responsibility for: •meter repairs, •testing, •change outs, and •service calls, which were originally handled by Utility Billing. Backflow Prevention Program •Administered internally. •Administrative fee $25/device. •FY2024 Revenue Forecast: ◦$79,325 ◦Based on projected 3,173 devices. Jeff Mills performs backflow recertification testing FY 2024 RECOMMENDED IMPROVEMENT REQUESTS 1.Creation of One Additional Water Distribution Maintenance Worker Position Estimated Cost: $80,931 (Recurring) 2.Elimination of Water Meter Repair Worker II and Addition of a Water Meter Foreperson (Internal Promotion) Estimated Cost : $8,681 (Recurring) 3. Upgrade Ruggedized Cell Phone to Smartphone for Eagle Point Water Treatment Plant Operator (Staffed 24/7/365) Estimated Purchase Price : $586 (Non-Recurring) Project FY 24 Cost Project Cost Water Main Replacements -Streets $544,500 $686,920 McFadden Property Water Main Extension $553,410 $553,410 Private Lead Service Line Replacement $5,348,150 $32,196,000 Green Alley Water Main Improvements $306,000 $306,000 Park Hill Pump Station Emergency Backup Generator $30,000 $205,000 Water Treatment Plant Boiler Replacements $100,000 $336,000 Fire Hydrant Assembly Relocation/Replacement for Sidewalk Program $20,000 $20,000 Water Treatment Plant Roof Replacement $125,000 $235,000 West End Annexation Study and Implementation Phase 1 $700,000 $700,000 FY 24 CAPITAL IMPROVEMENT PROJECTS (Continued) Water Department Project FY 24 Cost Total Project Cost Water Meter Replacement Program $567,500 $1,885,000 W.32nd Water Main Extension $216,000 $216,000 Source Water PFAS Reduction Project $1,150,000 $4,200,000 Wells, Well Field, and Raw Transmission Piping Repair $180,000 $455,500 Water Treatment Plant Condition Assessment and Master Plan $200,000 $200,000 Water Main Replacements -Sanitary Sewer Program - Custer & Auburn Streets $132,000 $1,103,000 SCADA & Comms Improvements $1,075,000 $1,075,000 Public Lead Line Water Main Replacement $350,000 $350,000 FY 24 CAPITAL IMPROVEMENT PROJECTS Water Department PERFORMANCE MEASURES WATER DEPARTMENT Goals that are on track: # of Regulatory Compliance Violations, Target Zero (0) # of Completed Annual Training hours to support CEUs, reported in staff hours % of Projects Completed within the Program Budget Goals Improving: # of Breaks per 100 miles of Pipe O&M Costs for Water Distribution per 100 miles of pipe Operation of 10% of Distribution System Valves Annually THANK YOU www.cityofdubuque.org/water Discounted City Utilities Program The City offers income-qualified residential customers a reduction in monthly fees for all four City utilities (water, sanitary sewer, refuse collection, and storm water) of up to 50% of the base rate. Customers must submit an application for consideration and applications are renewed on an annual basis. Learn more and fill out a short application at: www.cityofdubuque.org/utilitiesdiscount or call 563.589.4144 You may be eligible for DISCOUNTED OR FREE INTERNET through the Affordable Connectivity Program (ACP). Struggling to afford internet? How It Works ACP gives a discount on your household’s monthly internet service. Participating internet service providers will apply this discount directly to your service plan. If eligible, your household can receive: • $30 per month discount on wireless internet plans and a free phone • OR $30 per month discount on wired internet service to your home • One-time discount of up to $100 for a laptop, tablet, or desktop computer. A small fee will be required. Your household may be eligible if someone in the household: • Receives SNAP, Medicaid, or other government benefits, or • Meets income guidelines, or • Goes to a school where they receive free or reduced-price lunch and breakfast. Find out if you qualify and how to participate at acp.cityofdubuque.org If you don’t have access to a computer or internet to apply, free access is available at Carnegie-Stout Public Library.