The URL can be used to link to this page

Water Department Fiscal Year 2023 Budget Presentation Copyrighted March 23, 2022 City of Dubuque Public Hearings # 3. Special Meeting ITEM TITLE: Water Department Fiscal Year2023 Budget Presentation SUMMARY: SUGGESTED DISPOSITION: ATTACHMENTS: Description Type Water Department Policy Budget Book Supporting Documentation Presentation_Uploaded 3.23.22 Supporting Documentation Water Department -21- This page intentionally left blank. -22- WATER DEPARTMENT FY 2021 FY 2022 FY 2023 %Change From Budget Highlights Actual Budget Requested FY 2022 Budget Expenses Employee Expense 2,247,452 2,521,261 2,514,330 (0.3)% Supplies and Services 2,558,634 2,649,327 2,702,358 2.0 % Machinery and Equipment 714,163 564,750 960,568 70.1 % Administrative Overhead Recharges 424,310 435,271 452,767 4.0 % Finance Utility Billing 10,873 — — — % Engineering Water Maintenance Charges 40,306 29,673 42,951 44.7 % Payment in Lieu of Taxes 142,884 142,884 142,884 — % Payment to Construction Fund 550,000 400,000 1,000,000 150.0 % Debt Service 11,969,207 3,897,961 2,692,470 (30.9)% Total Expenses 18,657,829 10,641,127 10,508,328 (1.2)% Resources Operating Revenue 19,777,274 10,553,217 11,630,469 10.2 % General Fund - Rate Subsidy 21,315 96,126 25,000 (74.0)% Total Resources 19,798,589 10,649,343 11,655,469 9.4 % Net Operating Surplus (Deficit) 1,140,760 8,216 1,147,141 1,138,925 Personnel -Authorized FTE 26.07 26.07 26.07 Water User Fee Rate Increase — % 3 % 5 % Revenue 1% Rate Increase Generates $ 85,475 Improvement Package Summar-X 1 of 6 This improvement request is for the purchase of one new GPS Unit. This GPS unit will work wirelessly with the tablet for real time placement of water features in the field while infrastructure is being installed. City Engineering has had much success with this exact same unit over the last couple of years. The water department has eight staff members fully trained on how to operate the GPS unit and would allow us to send multiple teams into the field to perForm data collection. The existing R2 GPS unit has proved to be invaluable for on site data collection and it would be useful to have a second device when work is going on at different ends of the the city. This is a proactive, sustainable approach of being as effective and efficient with the operation in providing uninterrupted service to citizens, contractors, developers and engineering firms that are served. This follows the City Council goal of having a Sustainable Environment: Become a resilient city using sustainable and affordable technology for water, energy, transportation, health and wellness, discard, community engagement- a model community for the world. Related Cost: $880 Water User Fees Recurring Recommend -Yes Related Cost: $6,600 Water User Fees Non-Recurring Net Cost: $7,480 Water Rate Impact: 0.08 % Activity: Distribution -23- 2 of 6 This improvement request is for a Flexipro Video Camera to be used for inspection of the interior of existing water mains for evaluation of water main replacement for future street and green alley projects. This also provides means to see inside existing water mains through fire hydrants or cut outs of water main up to 400 feet in each direction. Public Works Department has a similar camera for sewer inspections, but are not able to use for sanitary reasons. This follows the Council Goals and priorities of a Sustainable Environment: Provide safe, dependable drinking water for all residents. Related Cost: $ 9,500 Water User Fees Non-Recurring Recommend -Yes Net Cost: $ 9,500 Water Rate Impact: 0.11 % Activity: Distribution 3 of 6 This improvement request is for a set of four file cabinets with table top to match Public Works File Cabinets, which will be placed in the open area of the Municipal Service Center. Per John Klostermann, Public Works Director, our filing cabinets must match their filing cabinets so everything is uniform. File Cabinets will be used to house Development Review Project Folders and Fire Sprinkler Plans that are older than five years. This was planned to be housed in the Water Distribution File room on the mezzanine in the garage, due to the amount of dust particles entering this room, it is not conducive to place file project folder records. This follows the City Council Goals and Priorities of a Financially responsible, High performance City Organization: Secure City information and data using "Best Practices". Related Cost: $ 3,300 Water User Fees Non-Recurring Recommend -Yes Net Cost: $ 3,300 Water Rate Impact: 0.04 % Activity: Distribution 4of6 This improvement request is for a vehicle for the use of the maintenance and supervisory staff at the Eagle Point Water Treatment Plant. Use and benefit of the vehicle would be used by maintenance at the pump stations including, but not limited to, delivering bulk sodium hypochlorite liquid, changing reagents for 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 operation. The vehicle will also be fitted with a plow for snow removal to aid the Public Works Department, a utility box for onsite repairs and maintenance work, and will have a spray in the bed liner for hauling materials and products to each site. This third vehicle will be used to improve situations associated with the daily challenges of four maintenance and operations staff, two operator special assignments and two maintenance staff, managing electrical and mechanical needs which are often at odds with scheduling two vehicles and ensuring work is performed in a timely manner. A third vehicle will reduce the wait and response time to perform their work and improve overall efficiency within the group. This vehicle will also provide available transportation for staff to deliver customer notices and the consumer confidence reports. It will also provide transportation for other City business, like conferences, classes, etc., which are now being done with private vehicles. The vehicle is a 3/4 ton truck with utility box and snowplow. This improvement package follows the City Council Goals and Priorities: Financially Responsible, High PerFormance City Organization: Sustainable, Equitable, and effective Service Delivery. Related Cost: $66,000 Water User Fees Non-Recurring Recommend -Yes Net Cost: $66,000 Water Rate Impact: 0.78 % Activity: Distribution -24- 5 of 6 This improvement request is for a stand alone SureCall Cellular Distributed Antenna System (DAS) for the Water Distribution Department Staff at the City of Dubuque Public Works building. This system would boost the cellular signal for the area in the Public Works Building that is isolated from any windows (Water Distribution Department) where cellular signal can be obtained. The SureCall DAS System consists of one signal amplifier, one rooftop mounted antenna, and up to two (2) interior antennas that will be mounted in the affected areas. Use and benefit of the SureCall DAS System would improve efficiency in daily operations such as: making/receiving calls from Distribution crews, contractors, receiving notifications such as two- factor identification, and effective use of the Panic Button app, in case of emergencies. This improvement package follows the City Council Goals and Priorities: Financially Responsible, High-Performance City Organization: Sustainable, Equitable, and Effective Service Delivery Related Cost: $12,632 Water User Fees Non-Recurring Recommend -Yes Net Cost: $12,632 Water Rate Impact: 0.15 % Activity: Plant Operations 6 of 6 This improvement request would provide funding for Cartegraph's programming services, training and any software add ons that are beyond the standard to help efficiently manage and report on daily operations including generation of Work Orders, Preventative and Corrective Maintenance orders, inventory management, Job Costing, Procurement Management(quotation and requisition processes) and Scheduling and Service Requests. This follows the City Council Goal of financially responsible, high performance city organization, sustainable, equitable and effective service delivery. Related Cost: $65,000 Water User Fees Non-Recurring Recommend -Yes Net Cost: $65,000 Water Rate Impact: 0.77 % Activity:Administration Significant Line Items Employee Expense 1. FY 2023 employee expense reflects a 3.25°/o wage package increase. 2. The lowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2022 The employee contribution of 6.29% is unchanged from FY 2022. 3. The City portion of health insurance expense increased from $1,086 in FY 2022 to $1,119 in FY 2023 per month per contract which results in an annual cost increase of$3,452 or 3.00%. 4. Overtime is unchanged from $94,040 in FY 2022 to $94,040 in FY 2023 . FY 2021 actual was $105,353. 5. Five-Year Retiree Sick leave payout is decreased from $31,850 in FY 2022 to $11,094 in FY 2023. 6. 50% Sick Leave Payout increased from $766 in FY 2022 to $1,841 in FY 2023 based on FY 2022 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. 7. An additional decrease in employee health insurance ($-3,452) reflects a corrected miscalculation included in prior year expense. -25- Supplies & Services 8. Property Insurance increased from $72,702 in FY 2022 to $89,389 in FY 2023 based on FY 2022 actual plus 9.5°/o. 9. Electricity Utility Expense decreased from $770,628 in FY 2022 to $668,402 in FY 2023 based on FY 2019 actual of$730,336 less 8°/o. 10. Gas Utility Expense increased from $37,210 in FY 2022 to $39,992 in FY 2023. This is based on FY 2019 actual of$36,825 plus 8.6%. 11. Sales Tax expense increased from $454,532 in FY 2022 to $460,710 in FY 2023 based on FY 2021 actual plus an increase in water rates in FY 2023 of 5%. This expense is directly offset by sales tax revenue. 12. Machinery and Equipment Maintenance decreased from $83,994 in FY 2022 to $63,457 in FY 2023 based on FY 2021 actual of$63,208. This line item represents wells, filters, pumps, generators, chemical unloading and storage, chemical feed equipment, chlorinators, lime slackers, clarifiers, air compressors and air system components, telemetry, HVAC, elevator, computer maintenance, sludge plant, electrical controls, and sensors. 13. Costs for Fluoride, Phosphate, Chlorine, Carbon Dioxide, Lime, and Polymer expense (water processing materials) decreased from $452,099 in FY 2022 to $335,000 in FY 2023. Chlorine increased from $30,744 in FY 2022 to $40,675 in FY 2023. Lime decreased from $319,000 in FY 2022 to $319,650 in FY 2023. Carbon dioxide increased from $20,679 in FY 2022 to $29,275 in FY 2023. 14. Hauling Services unchanged from $165,000 in FY 2022 to $165,000 in FY 2023 based on FY 2022 actual price per ton unchanged.The amount of hauled tons of lime sludge is highly variable from year to year and is based on hauling approximately 15,000 tons per year. FY 2021 actual expense was $212,476. 15. Consultant Services increased from $29,000 in FY 2022 to $33,000 in FY 2023. This line item includes a leak survey ($18,000) and water storage tank inspections ($15,000). 16. Software increased from $61,128 in FY 2022 to $94,610 in FY 2023. This increase is largely due to ($31,000) Hach Wims and Access Technologies expense previously charged to an equipment line item. This line item includes the following breakout costs: -26- Software FY 2023 Water Administration Laserfiche License 282 GoToMyPC (5) 720 Water Meters Tokay Software 1,500 WaterSmart 31,568 Neptune360 (50%) 23,640 Water Plant Operations Scada Tech Support For Rockwell Software 4,900 Hach Wims And Access Technologies 31,000 Water Distribution AutoCAD 1,000 Total Software $94,610 17. Property Maintenance increased from $30,311 in FY 2022 to $45,170 in FY 2023 based on FY 2021 actual. This line item represents the contract for building and grounds maintenance for Eagle Point Plant, sludge plant, storage tanks, reservoirs, booster stations, well houses. 18. Pipe Special Fittings is increased from $50,290 in FY 2022 to $75,472 in FY 2023 based on FY 2021 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 ($35,121) and taps services ($55,000) that covers these expenses. 19. Valves increased from $49,955 in FY 2022 to $64,000 in FY 2023 based on FY 2021 actual. This line item represents the material cost only for valves in the distribution system (9 valves) and ongoing valve replacement and maintenance internally in the plant. 20. Environment Testing/Monitoring unchanged from $35,600 in FY 2022 to $35,600 in FY 2023 based on FY 2022 budget. FY 2021 actual was $38,048. This line item represents the cost of samples due to boil advisories, chlorine monitoring, increased testing for expansion of system, and water quality testing using the Heterotrophic Plate Count (HPC) test. The HPC test detects the growth of pathogens beyond bacteria testing, that might be present, which is especially important after main breaks, loss of pressure, and following new connections. HPC testing is conducted twice per month or as needed following an emergency. 21. Engineering Water Maintenance Charges provides for in-house utility locates for various water distribution operations through Engineering Department ($42,951). FY 2022 was budgeted at $29,673 which is a 44.75°/o increase in FY 2023. -27- Machinery 8� Equipment 22. Equipment replacement items at the maintenance level include ($960,568): Water Administration Smart Phone (1) $ 350 Meters Smart Phone (2) $ 700 Plant Operation & Maintenance Smart Phone (2) $ 700 Water Distribution System Shop Equipment $ 250 Hydrants $ 70,000 Electric Pump (2) $ 30,000 Cut Off Saw $ 3,200 Gas Generator _ $ 2,400 Barricades/Warn Safety Signals $ 1,000 Smartphones (3) $ 13,682 Portable Parallel Analyzer Test Equipment $ 5,000 Shop Vac $ 1,000 Annual Maintenance Projects � Pump Replace Vacuum Filter $ 15,000 Generator Maintenance Program - $ 8,000 Valve Replacement $ 70,000 Water Main Replacements (Repair) $ 350,000 Large Water Meters Exchange $ 191,306 Water Valve Box Maintenance $ 25,000 Water Meter Testing $ 25,000 Recommended Improvement Packages $ 16,980 $ 960,568 Debt Service 23. Annual debt service reflects repayment to ($2,692,470): Final Call Amount Debt Series Source Purpose Payment Date $ 58,740 SRF 2007A Water Fees Clear Wells 2028 $ 218,567 SRF Series 2009 Water Fees Meter Change-Out 2031 $ 423,300 Revenue 2021C Water Fees Water Improvements 2030 2028 $ 107,115 G.O. 2018A Water Fees Water Improvements 2031 2026 $ 40,245 G.O. 2021A Water Fees Water Improvements 2032 2028 $ 137,749 G.O. 2021A Water Fees Water Improvements 2033 2026 $ 659,200 G.O. 20121A Water Fees Water Improvements 2032 2028 $ 42,888 G.O. 2016C Water Fees Water Improvements 2033 2024 -28- $ 674,200 SRF 2017 Water Fees CIWA Purchase/Imp 2036 $ 268,680 SRF 2019 Water Fees Roosevelt Water Tower 2038 � $ 59,597 SRF 2021 Water Fees Water Improvements 2041 $ 2,189 SRF 2023 Water Fees Water Improvements 2043 $2,692,470 Total Water Annual Debt Service Revenue 1. Water User Fees increased from $9,399,359 in FY 2022 to $10,195,050 in FY 2023 based on FY 2021 actual of$8,547,478 plus the FY 2023 projected rate increase of 5%. 2. Flat Rates increased from $27,242 in FY 2022 to $52,897 in FY 2023. FY 2021 actual was $54,498. This charge is for customers purchasing bulk water. Rates are set by City ordinance. 3. Fire Protection Rates increased from $181,778 in FY 2022 to $186,975 in FY 2023 based on FY 2021 actual of$186,975. This fee is the demand charge for fire sprinkler head connection. The rates are set by City ordinance. 4. Taps increased from $41,000 in FY 2022 to $65,000 in FY 2023. FY 2021 actual was $23,302. 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. 5. Tap Service decreased from $23,000 in FY 2022 to $20,000 in FY 2023. FY 2021 actual was $4,943. 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. 6. Connection Charge Front Footage is increased from $75,000 in FY 2022 to $103,000 in FY 2023 based on a three-year average. FY 2021 actual was $92,811. 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 increased from $75,675 in FY 2022 to $76,150 in FY 2023 based on actual number of accounts. FY 2021 actual was $74,406. This is the $25 annual fee charged to all customers with a backflow device. 8. Penalties for late payments increased from $63,840 in FY 2022 to $95,748 in FY 2023 based on FY 2019 actual of$95,739. 9. Tower Monthly Rental increased from $127,732 in FY 2022 to $132,331 in FY 2023 based on water lease contract amounts. FY 2021 actual was $134,615. 10. Sales Tax Collected increased from $454,532 in FY 2022 to $499,458 in FY 2023 based on the rate increase for water fees. This line item off-sets the sales tax expense. -29- � � � � � � � ��TI��V �.ART . � � ' �IS Se�asanal Intern [0.5] 1Nater Distributian ��r Depar[ment Farepersan [1] Mana�er Industrial Maintenance Equipment �perator II [1] Mechanic[1] Water Distribu�ian � . Maintenance 1�orker [6.5] 4Vater Plant �p��atar[&] Meter Repair Worker II [1] Industrial �ler�rical Me�er Repair UJarker I [2] Technician [1] -30- 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. -31- WATER DEPARTMENT FY 2021 FY 2022 FY 2023 Full-Time Equivalent 26.07 26.07 26.07 Resources Support $30,000,000 $20,000,000 $19,777,274 $10,553,217 $11,630,469 $10,000,000 $0 Operating Revenue � FY 2021 FY 2022 FY 2023 The Water Department is supported by 26.07 full-time equivalent employees, which accounts for 23.93% of the department expense as seen below. Overall, the department's expenses are expected to decrease by -1.25% in FY 2023 compared to FY 2022. Expenditures by Category by Fiscal Year $15,000,000 $10,000,000 $5,000,000 � � $0 — — m cn m D c � C� p m � � � Q � � p Cp � � � � � � � � � '-. � � � � � � � � CD CD � Cp � � C (D CD CD � � < �• h G �• X Q � � � � CQ n � � (D TI � � Q Q v c�� N (D cn � FY 2021 FY 2022 � FY 2023 -32- 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 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $12,772,117 $4,958,327 $3,684,775 Resources $— $— $— Water Administration Position Summary FY 2023 Water Department Manager 1.00 Confidential Account Clerk 1.00 Water Engineering Assistant 1.00 GIS Specialist 1.00 GIS Intern 0.50 Total FT Equivalent Employees 4.50 Performance Measures Performance Measure(KPI) Target FY 2020 FY 2021 FY 2022 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 35 35 � professional development in emergency � response Reduction of Water Quality Issues per <20 21 22 24 � 100 miles of Pipe % of IosUunaccounted for water <18% 16.5% 18% 18% C � % of projects completed within the 100% 100% 100% 100% � program budget Operating cost coverage for water(Total r�� operational Revenue/Total Operating 1.0 1.04 1.0 1.0 L Cost) # New Commercial connections/ 1/yr 3/yr 3/yr 1/yr I�f partnerships (per year) -33- 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 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $2,493,525 $2,672,673 $2,646,640 Resources $1,400 $— $1,400 � .- . . • . . FY 2023 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 Water Operations Supervisor 1.00 Total FT Equivalent Employees 9.00 Performance Measures City Council Go�l: Sustainable�m Performance Measure (KPI) Target FY 2020 FY 2021 FY 2022 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 � Violations Water Plant Process Efficiency measured as Water Treated vs Produced(MGD 1.1 .94 1.03 1.0 � Treated/MGD Produced) Cost Effectiveness of the Treatment <or- 1.0 0.94 1.07 1.0 C�� Process (O&M Cost/MG, thousands) The 2019 Water Quality Report can be downloaded at: https://www.cityofdubuque.org/waterqualitX -34- 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 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $2,396,882 $2,020,699 $2,968,919 Resources $19,628,845 $10,530,750 $11,483,981 � . . - . . FY 2023 Equipment Operator II 1.00 Water Distribution Maintenance Worker 6.50 Water Distribution Foreman 1.00 Water Distribution Supervisor 1.00 Custodian I 0.07 Total FT Equivalent Employees 9.57 Performance Measures Performance Measure(KPI) Target FY 2020 FY 2021 FY 2022 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 27 25 23 � Operation of 10% of system valves ��5 314 775 264 C � annually Hydrant effectiveness (out of service rate) <1% 0% <1% >1% C � <1% or 25FH O&M costs for water per 100 miles of pipe �343** 311 348 345 � (thousands per 100 miles) ""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.14 miles of public water mains ranging in diameter from 4" up to 30"; 8,008 control valves; and 2,606 fire hydrants. -35- 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 2021 Actual FY 2022 Budget FY 2023 Requested Expenditures $510,526 $372,755 $383,737 Resources $156,327 $112,658 $158,071 Water Meters Position Summary FY 2023 Water Meter Repair Worker I 2.00 Water Meter Repair Worker II 1.00 Total Full-Time Equivalent Employee's 3.00 Performance Measures Performance Measure(KPI) Target FY 2020 FY 2021 FY 2022 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 r�� Services, by definition, to participate in the 100% gg% 99% gg% L backflow prevention program � 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% � service issues. Enhanced meter reading accuracy, larger �� users: O&M on all large meters (>3") per 24/yr 10/yr* 0/yr* 24yr AWWA standards (Ig meter/yr) *Numbers affected by COVID **Numbers to include partial year of 5 year MIU replacement 450 to 900 -36- Recommended Operating Revenue Budget - Department Total 42-WATER FY20 Actual FY21 Actual FY22 Adopted FY23 Recomm'd Fund Account Account Title Revenue Revenue Budget Budget 640 43110 INVESTMENT EARNINGS 104,079 59,184 75,000 59,184 43 USE OF MONEY AND PROPERTY-Total 104,079 59,184 75,000 59,184 640 51105 METER RATES 8,407,944 8,547,478 9,399,359 10,195,050 640 51107 LTNAPPLIEDCREDITS 16,918 26,124 16,918 26,L24 640 51108 WATER RATE CREDIT 0 0 (96,126) 0 640 51110 FLAT RATES 42,570 54,498 27,242 52,897 640 S ll 11 FLAT RATE KEY WEST 2,053 2,061 1,095 2,061 640 Sll15 FIREPROTECTIONRATES 181,778 186,975 181,778 186,975 640 Sll25 TAPS-3/4&1 INCH 12,289 23,302 41,000 65,000 640 51130 CONNECT CHG LARGE SERVICE 7,454 4,943 23,000 20,000 640 51135 CONNECT CHG FRONT FOOTAGE 77,137 92,811 75,000 103,000 640 51140 METER SALES-REMOTES 15,414 16,304 13,500 16,304 640 51145 SALE OF METERS 29,466 54,239 12,500 54,239 640 51146 SALE OF UFR DEVICES 3,860 3,047 3,860 3,047 640 Sll65 MAINTENANCECHARGES 7,663 6,454 7,300 6,454 640 S ll 70 REPAIR OF METERS 6,314 8,257 6,314 8,257 640 Sll75 SHUTOFFPENALTIES 15,423 4,178 15,423 4,178 640 51176 METER TAMPERING FEE 400 394 400 394 640 51177 CALL OUT CHARGE 771 738 771 738 640 51180 CROSS CON.CNTL ADMIN FEE 73,771 74,406 75,675 76,150 640 51215 LATE PAYMENT PENALTY 63,853 2,798 63,840 95,748 640 51310 PERMIT 123,553 134,615 127,732 132,331 51 CHARGES FOR SERVICES -Total 9,088,631 9,243,621 9,996,581 11,048,947 640 53201 RF,FUNDS 18,875 0 0 0 640 53605 MISCELLANEOUS REVENUE 75 0 0 0 640 53615 DAMAGE CLAIMS 22,780 6,102 20,000 6,102 640 53620 REIMBURSEMENTS-GENERAL 6,055 14,662 5,935 14,663 640 53630 SALES TAX COLLECTION 428,804 461,820 454,532 499,458 53 MISCELLANEOUS -Total 476,589 482,585 480,467 520,223 640 54109 SALVAGE SALES 741 2,115 1,169 2,115 640 54210 GO BOND PROCEEDS 1,311,083 7,839,768 0 0 640 54220 BOND DISCOUNT 59,384 0 0 0 640 54230 SRF GO BOND PROCEEDS 1,120,000 2,150,000 0 0 54 OTHER FINANCING SOURCES -Total � 2,491,208 9,991,883 1,169 � 2,ll5 640 59100 FRGENERAL 0 21,315 96,126 25,000 59 TRANSFER IN AND INTERNAL -Total � 0 21,315 96,126 25,000 WATER -Total 12,160,508 19,798,589 10,649,343 11,655,469 -37- Recommended Operating Expenditure Budget - Department Total 42-WATER FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 640 61010 FULL-TIME EMPLOYEES 1,413,995 1,379,223 1,624,004 1,645,097 640 61020 PART-TIME EMPLOYEES 8,610 9,568 29,060 29,685 640 61030 SEASONAL EMPLOYEES 10,967 6,710 15,545 16,046 640 61050 OVERTIME PAY 111,927 105,353 94,040 94,040 640 61071 HOLIDAY PAY-OVERTIME 21,370 24,662 17,000 18,600 640 61072 TANK CLiMBiNG PAY 0 165 1,200 1,200 640 61083 COVIDI9 EMP NON-WORK 4,687 0 0 0 640 61091 SICK LEAVE PAYOFF 31,715 31,872 31,850 11,094 640 61092 VACATION PAYOFF 1,065 12,190 0 0 640 61095 PARENTAL LEAVE 6,910 0 0 0 640 61096 50%SICK LEAVE PAYOUT 766 1,841 766 1,841 640 61310 IPERS 148,962 144,024 176,416 178,689 640 61320 SOCIAL SECURITY 116,676 114,118 138,358 138,925 640 61410 HEALTH INSURANCE 280,934 319,780 332,316 328,864 640 61415 WORKMENS'COMPENSATION 74,335 78,771 52,387 43,398 640 61416 LIFEINSURANCE 1,029 976 1,430 1,150 640 61640 SAFETY EQUIPMENT 2,801 17,248 4,750 4,750 640 61650 MEAL ALLOWANCE 664 809 664 809 640 61660 EMPLOYEE PHYSICALS 1,474 142 1,475 142 61-WAGES AND BENEFITS 2,238,888 2,247,452 2,521,261 2,514,330 640 62010 OFFICE SUPPLIES 2,838 4,460 2,838 7,760 640 6201 1 LTNIFORM PURCHASES 27,718 17,962 20,182 20,070 640 62030 POSTAGE AND SHIPPING 2,012 2,039 2,052 2,080 640 62033 HAND TOOLS/EQUIPMENT 3,752 8,579 4,317 8,751 640 62034 REPAIRPARTS/SUPPLIES 5,610 4,230 6,989 7,136 640 62036 CONSTRUCTION SUPPLIES 670 2,074 1,113 2,037 640 62050 OFFICE EQUIPMENT MAINT 258 0 263 0 640 62061 DP EQUIP.MAINT CONTRACTS 20,560 21,054 21,054 20,800 640 62062 JANITORIAL SUPPLIES 4,382 3,358 4,469 3,734 640 62063 SAFETY RELATED SUPPLIES 7,445 8,196 4,311 8,361 640 62064 ELECTRICAL SUPPLIES 15,863 4,734 16,180 4,829 640 62065 LAB SUPPLIES 10,229 13,216 10,434 13,480 640 62066 PLUMBING MATERIALS 537 697 2,082 1,235 640 62090 PRINTING&BINDING 676 376 1,710 1,055 640 62110 COPYING/REPRODUCTION 1,679 2,848 2,204 3,491 640 62130 LEGAL NOTICES&ADS 4,104 3,599 1,180 3,516 640 62170 SUBSCRIPTIONS-BOOKS-MAPS 519 158 806 540 640 62190 DUES&MEMBERSHIPS 1,280 2,869 3,423 4,423 640 62204 REFLTNDS 74 (6,ll9) 5,786 0 640 62206 PROPERTY INSURANCE 66,465 67,130 72,702 89,389 640 62207 BOILER INSURANCE 120 0 0 0 640 62208 GENERAL LIABILITY INSURAN 20,585 21,391 22,575 29,293 640 62210 SALES TAX 426,658 460,710 454,532 460,710 640 62310 TRAVEL-CONFERENCES 10,582 52 3,680 4,000 640 62320 TRAVEL-CITY BUSINESS 337 0 700 850 640 62340 MILEAGE/LOCALTRANSP 2,265 1,628 2,794 3,974 640 62360 EDUCATION&TRAINING 17,237 4,244 22,313 15,139 640 624ll UTILITY EXP-ELECTRICITY 733,932 730,336 770,628 668,402 640 62412 UTILITY EXP-GAS 37,210 33,216 37,210 39,992 640 62414 UTILITY EXP-FUEL OIL 13 0 1,500 1,500 -38- Recommended Operating Expenditure Budget - Department Total 42-WATER FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 640 62415 UTILITY EXPENSE STORMWATR 221 418 236 453 640 62421 TELEPHONE 12,657 13,981 11,232 11,232 640 62424 RADIO/PAGERFEE 8,900 7,677 9,434 8,138 640 62431 PROPERTYMAINTENANCE 30,311 43,730 30,311 45,170 640 62433 CUSTODIAL SERVICES 0 0 700 0 640 62434 HVAC MAiNTENANCE 2,900 2,735 2,900 3,744 640 62435 ELEVATOR MAINTENANCE 2,875 2,410 2,584 2,410 640 62436 RENTAL OF SPACE 220 3,542 1,850 3,942 640 62437 BARRICADE RENTAL 3,790 8,622 7,250 8,622 640 62438 FIRE SUPPRESSION 982 435 982 435 640 62511 FUEL,MOTOR VEHICLE 24,049 24,014 19,700 22,435 640 62521 MOTOR VEHICLE MAINT. 32,288 31,457 34,133 32,576 640 62522 VEHICLE MAINT.,ACCIDENT 1,713 0 0 0 640 62528 MOTOR VEH.MAINT.OUTSOUR 8,624 5,914 948 4,335 640 62611 MACH/EQUII'MAINTENANCE 83,994 63,208 83,994 63,457 640 62613 METER MAINTENANCE 10,340 3,494 10,340 8,058 640 62614 EQUIP MA1NT CONTRACT 307 895 307 895 640 62615 MACH/EQUIP MAINT.OUTSOUR 1,444 1,068 2,044 1,068 640 62628 INSTRUMENTATION MAINT 10,467 13,520 10,467 13,520 640 62630 FLUORIDE 9,836 10,222 9,836 11,000 640 62631 LIME 270,596 297,001 319,000 335,000 640 62632 PHOSPHATE 60,862 59,900 65,000 64,150 640 62633 CHLORINE 30,744 27,529 30,744 40,675 640 62638 POLYMER 5,732 6,844 6,840 9,375 640 62639 LIQUID CO2/02 20,679 27,208 20,679 24,500 640 62663 SOFTWARELICENSEEXP 34,563 52,154 61,128 94,610 640 62664 LICENSE/PERMIT FEES 7,126 7,209 6,820 7,209 640 62667 DATA SERVICES 2,775 3,761 2,775 2,644 640 62669 PROGRAMMING 4,881 0 0 0 640 62675 VALVES 29,955 22,828 49,955 64,000 640 62676 PIPE-SPECIAL FITTINGS 50,290 75,472 50,290 75,472 640 62692 LANDFILL FEES 303 152 323 152 640 62696 OUTSIDE COLLECTOR EXPENSE 4,230 919 4,047 890 640 62710 CONTRACTOR SERVICES 0 0 0 6,000 640 62713 LEGAL SERVICES 5,196 1,916 0 0 640 62716 CONSULTANT SERVICES 38,146 1,307 29,000 33,000 640 62721 FINANCIAL CONSULTANT 0 14,139 0 14,139 640 62726 AUDIT SERVICES 3,500 3,600 0 3,708 640 62731 MISCELLANEOUS SERVICES 8,234 42,713 40,000 40,000 640 62732 TEMP HELPCONTRACT SERV. 1,316 0 0 0 640 62746 ONE CALL OPERATION 7,226 8,657 7,226 7,226 640 62765 GRANTS 5,365 3,452 15,000 10,000 640 62767 ENVIRON.TESTING/MON. 33,191 38,048 35,600 35,600 640 62780 HAULING SERVICES 174,196 212,476 165,000 165,000 62-SUPPLIES AND SERVICES 2,470,634 2,557,664 2,648,702 2,701,387 640 62724 BOND PAYiNG AGENT FEE 625 971 625 971 627-CONTRACTUAL SERVICES 625 971 625 971 640 7ll20 PERIPHERALS,COMPUTER 179 44 0 880 640 7ll23 SOFTWARE 0 0 0 65,000 640 71124 COMPUTER 0 25 0 0 -39- Recommended Operating Expenditure Budget - Department Total 42-WATER FY20 Actual FY21 Actual FY22 Adopted FY 23 Recomm'd Fund Account Account Title Expense Expense Budget Budget 640 71215 STORAGE CABINETS 0 2,033 0 0 640 71312 VAN/PICKUP/WAG REPL 36,860 75,831 0 0 640 71314 TRUCK-REPLACEMENT 90,289 16,432 0 66,000 640 71318 HEAVY EQUIP-REPLACEMENT 0 141,426 0 0 640 71410 SHOP EQUIPMENT 1,730 138 250 250 640 71413 LABORATORY EQUIPMENT 1,837 2,436 5,800 0 640 71415 SAWS 2,500 4,200 4,200 3,200 640 71420 EARTH COMPACTOR 0 0 0 1,000 640 71510 HYDRANTS 10,460 32,351 15,000 70,000 640 71511 PUMPS 0 0 18,000 45,000 640 71515 WATER METER PRODUCT 0 54,243 0 0 640 71516 LARGEWATERMETERS 64,172 85,640 55,000 191,306 640 71550 MISCELLANEOUS EQUIPMENT 1,290 0 0 11,900 640 71619 OTHER MAINT.EQUIPMENT 0 0 50,000 6,600 640 72410 PAGER/RADIO EQUIPMENT 46,555 285 0 0 640 72418 TELEPHONE RELATED 117 81 3,500 15,432 640 72515 TEST EQUIPMENT,OTHER 0 0 0 5,000 71-EQUIPMENT 255,989 415,165 151,750 481,568 640 72115 BARRICADES/WARN SIGNALS 0 926 0 1,000 72-EQUIPMENT 0 926 0 1,000 640 73211 CONST.CONTR-NOT BLDG 308,852 298,071 395,000 470,000 640 73410 EQUiP ACQUISiTION 17,461 0 18,000 8,000 73-CIP EXPENDITURES 326,313 298,071 413,000 478,000 640 74111 PRINCIPALPAYMENT 4,131,164 ll,138,835 3,040,574 2,078,929 640 74112 1NTEREST PAYMENT 839,235 830,372 857,387 613,541 74-DEBT SERVICE 4,970,399 11,969,207 3,897,961 2,692,470 640 91100 TO GENERAL 597,380 567,194 578,155 595,651 640 91740 TO WATER CONSTRUCTION 400,000 550,000 400,000 1,000,000 91-TRANSFER TO 997,380 1,ll7,194 978,155 1,595,651 42-WATER TOTAL ll,260,227 18,606,650 10,611,454 10,465,377 -40- Recommended Expenditure Budget Report by Activity & Funding Source 42-WATER UNDISTRIBUTED -10640 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget CONTRACTUAL SERVICES 971 971 SUPPLIES AND SERVICES 29,701 9,833 15,029 TRANSFER TO 1,]17,194 978,155 1,595,651 UNDISTRIBUTED 1,147,866 987,988 1,611,651 WATER ADMINSTRATION -42100 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget CONTRACTUAL SERVICES - 625 0 DEBT SERVICE 11,969,207 3,897,961 2,692,470 EQUIPMENT 20 1,050 65,350 SUPPLIES AND SERViCES 482,060 478,381 496,440 WAGES AND BENEFITS 320,831 580,310 430,515 WATER ADMINSTRATION 12,772,ll7 4,958,327 3,684,775 METERS -42300 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 24,838 700 SUPPLIES AND SERVICES 58,045 92,416 97,128 WAGES AND BENEFITS 427,643 280,339 285,909 METERS 510,526 372,755 383,737 PLANT OPER.&MAINT -42400 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 4,553 56,500 66,700 SUPPLIES AND SERVICES 1,682,278 1,707,367 1,678,077 WAGES AND BENEFITS 806,695 908,806 901,863 PLANT OPER.&MAINT 2,493,525 2,672,673 2,646,640 WATER DISTR. SYSTEM -42700 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget CIP EXPENDITURES 5,720 0 EQUIPMENT 271,326 24,200 143,512 SUPPLIES AND S6RVIC6S 280,123 256,705 317,713 WAGES AND BENEFITS 691,847 751,806 896,043 WATER DISTR.SYSTEM 1,249,O16 1,032,711 1,357,268 -41- Recommended Expenditure Budget Report by Activity & Funding Source 42-WATER STORAGE TANK INSPECT/MON-42705 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 15,000 STORAGE TANK 1NSPECT/MON 15,000 PUMP REPLC VACUUM FILTER-42713 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 15,000 15,000 PUMP REPLC VACUUM FILTER — 15,000 15,000 FIRE HYDRANT PAINTING -42720 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERViCES 5,000 5,000 FIRE HYDRANT PAINTING — 5,000 5,000 GENERATOR MAIN PROGRAM -42725 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget GP EXPENDITURES 18,000 8,000 GENERATOR MAIN PROGRAM — 18,000 8,000 SERVICE LINE ASSIST -42735 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND S6RVIC6S 22,004 35,000 35,000 SERVICE LINE ASSIST 22,004 35,000 35,000 VALVE REPLACEMENT -42745 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget C1P EXPENDITURES 70,000 SUPPLIES AND SERVICES — 20,000 14,000 VALVE REPLACEMENT — 20,000 84,000 WATER MAIN REPLACEMENTS -42755 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget -42- Recommended Expenditure Budget Report by Activity & Funding Source 42-WATER CIP EXPENDITURES 273,966 350,000 350,000 WAGES AND BENEFiTS 437 WATER MAIN REPLACEMENTS 274,403 350,000 350,000 WATER METER EXCHANGE -42760 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget EQUIPMENT 115,355 55,000 191,306 WATER METER EXCHANGE 115,355 55,000 191,306 WATER LEAK REPAIR GRANT -42765 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLiES AND SERViCES 2,242 5,000 5,000 WATER LEAK REPAIR GRANT 2,242 5,000 5,000 COUNTY WATER ASSISTANCE -42766 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES 1,210 10,000 5,000 COUNTY WATER ASSISTANCE 1,210 10,000 5,000 WATER VALVE BOX MAINT -42770 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adoptcd Budget FY23 Recomm'd Budget CIP EXPENDITURES 18,085 20,000 25,000 WATER VALVE BOX MAINT 18,085 20,000 25,000 COMPUTERIZED LEAK SURVEY-42785 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget SUPPLIES AND SERVICES - 29,000 18,000 COMPUTERIZED LEAK SURVEY - 29,000 18,000 WATER METER TESTING -42790 FUNDING SOURCE:WATER UTILITY OPERATION Account FY21 Actual Expense FY22 Adopted Budget FY23 Recomm'd Budget CIP EXPENDITURES 300 25,000 25,000 WATER METER TESTING $ 300.00 $ 25,000.00 25,000 WATER TOTAL $18,606,650 $10,611,454 $10,465,377 -43- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 42 WATER DEPARTMENT FY 2021 FY 2022 FY 2023 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 $ 110,505 1.00 $ 112,150 1.00 $ 100,347 640 3200 GE-36 WATER DISTRIBUTION SUPERVISOR 1.00 $ 91,659 1.00 $ 93,267 1.00 $ 96,307 640 - GE-36 WATER OPERATIONS SUPERVISOR - $ - 1.00 $ 72,370 1.00 $ 74,730 640 2950 GE-33 WATER ENGINEERINGASSISTANT 1.00 $ 75,252 1.00 $ 77,143 1.00 $ 79,653 640 2650 GE-31 FOREMAN -WATER DISTR. 1.00 $ 68,265 1.00 $ 69,277 1.00 $ 71,870 640 2610 GE-30 GIS SPECIALIST 1.00 $ 64,679 1.00 $ 66,299 1.00 $ 68,450 640 GE-25 CONFIDENTIALACCOUNT CLERK 1.00 $ 49,429 1.00 $ 50,255 1.00 $ 51,879 640 2400 0E-16 ELECTRONIC TECHNICIAN 1.00 $ 65,319 1.00 $ 66,645 1.00 $ 69,105 640 2800 0E-14 EQUIPMENT MECHANIC 1.00 $ 62,691 1.00 $ 63,616 1.00 $ 63,768 640 2550 0E-16 WATER PLANT OPR CERT GR III/IV - $ - 1.00 $ 60,812 1.00 $ 65,814 640 0E-11 WATER PLANT OPERATOR CRT GR I - $ - - $ - 1.00 $ 56,355 640 2475 0E-12 WATER PLANT OPERATOR CRT GR II 1.00 $ 58,395 1.00 $ 59,260 1.00 $ 61,179 640 2475 0E-16 WATER PLANT OPERATOR CRT GR IV 6.00 $ 384,585 4.00 $ 261,999 3.00 $ 202,706 640 2305 0E-10 EQUIPMENT OPERATOR II 2.00 $ 116,147 1.00 $ 58,074 1.00 $ 60,167 640 1775 0E-09 WATER METER REPAIR WORKER I 2.00 $ 110,462 2.00 $ 113,210 2.00 $ 118,098 640 0E-14 WATER METER REPAIR WORKER II 1.00 $ 61,474 1.00 $ 62,381 1.00 $ 64,537 WATER DISTR MAINTENANCE 640 1476 0E-09 WORKER 5.00 $ 266,434 6.00 $ 322,400 6.00 $ 340,132 TOTAL FULL TIME EMPLOYEES 25.00 $ 1,585,296 25.00 $ 1,609,158 25.00 $ 1,645,097 61020 Part-Time Employee Expense WATER DISTR MAINTENANCE 640 1476 0E-09 WORKER 0.50 $ 25,233 0.50 $ 25,599 0.50 $ 26,434 640 2050 0E-03 CUSTODIAN I 0.07 $ 3,401 0.07 $ 3,461 0.07 $ 3,251 TOTAL PART TIME EMPLOYEES 0.57 $ 28,634 0.57 $ 29,060 0.57 $ 29,685 61030 Seasonal Employee Expense 640 NA-37 GIS INTERN 0.50 $ 15,326 0.50 $ 15,545 0.50 $ 16,046 TOTAL SEASONAL EMPLOYEES 0.50 $ 15,326 0.50 $ 15,545 0.50 $ 16,046 TOTAL WATER DEPARTMENT 26.07 $ 1,629,256 26.07 $ 1,653,763 26.07 $ 1,690,828 -44- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2021 FY 2022 FY 2023 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 $ 64,679 1.00 $ 66,299 1.00 $ 68,450 64042100 61010 640 3275 GE-40 WATER DEPARTMENT MANAGER 1.00 $ 110,505 1.00 $ 112,150 1.00 $ 100,347 64042100 61010 640 GE-25 CONFIDENTIALACCOUNTCLERK 1.00 $ 49,429 1.00 $ 50,255 1.00 $ 51,879 64042100 61010 640 2950 GE-33 WATER ENGINEERING ASSISTANT 1.00 $ 75,252 1.00 $ 77,143 1.00 $ 79,653 WATER DISTRIBUTION 64042100 61010 640 3200 GE-37 SUPERVISOR 1.00 $ 91,659 1.00 $ 93,267 - $ - Total 5.00 $ 391,524 5.00 $ 399,114 4.00 $ 300,329 Water Administration-SEASONAL 64042100 61030 640 NA-37 GIS INTERN 0.50 $ 15,326 0.50 $ 15,545 0.50 $ 16,046 Total 0.50 $ 15,326 0.50 $ 15,545 0.50 $ 16,046 Water Meters-FT 64042300 61010 640 1775 0E-09 WATER METER REPAIR WORKER I 2.00 $ 110,462 2.00 $ 113,210 2.00 $ 118,098 VV/11 CR IVIC I CR RCrF11R VVVRf�CR 64042300 61010 640 0E-14 II 1.00 $ 61,474 1.00 $ 62,381 1.00 $ 64,537 WATER DISTR MAINTENANCE 64042300 61010 640 1476 0E-09 WORKER 1.00 $ 54,178 - $ - - Total 4.00 $ 226,114 3.00 $ 175,591 3.00 $ 182,635 Water Plant Operation-FT WATER PLANT OPERATOR CRT 64042400 61010 640 0E-11 GR I - $ - - $ - 1.00 $ 56,355 WATER PLANT OPERATOR CRT 64042400 61010 640 2475 0E-12 GR II 1.00 $ 58,395 1.00 $ 59,260 1.00 $ 61,179 64042400 61010 640 2550 0E-16 WATER PLANT OPR CERT GR III/IV - $ - 1.00 $ 60,812 1.00 $ 65,814 WATER PLANT OPERATOR CRT 64042400 61010 640 0E-16 GRIV 6.00 $ 384,585 4.00 $ 261,999 3.00 $ 202,706 WATER OPERATIONS 64042400 61010 640 GE-36 SUPERVISOR - $ - 1.00 $ 72,370 1.00 $ 74,730 64042400 61010 640 2800 0E-16 ELECTRONIC TECHNICIAN 1.00 $ 65,319 1.00 $ 66,645 1.00 $ 69,105 64042400 61010 640 3015 0E-14 EQUIPMENT MECHANIC 1.00 $ 62,691 1.00 $ 63,616 1.00 $ 63,768 Total 9.00 $ 570,990 9.00 $ 584,702 9.00 $ 593,657 Water Distribution-FT WATER DISTR MAINTENANCE 64042700 61010 640 1476 0E-09 WORKER 4.00 $ 212,256 6.00 $ 322,400 6.00 $ 340,132 WATER DISTRIBUTION 64042700 61010 640 3200 GE-36 SUPERVISOR - $ - - $ - 1.00 $ 96,307 64042700 61010 640 2305 0E-10 EQUIPMENT OPERATOR II 2.00 $ 116,147 1.00 $ 58,074 1.00 $ 60,167 64042700 61010 640 2650 GE-31 FOREMAN-WATER DISTR. 1.00 $ 68,265 1.00 $ 69,277 1.00 $ 71,870 Total 7.00 $ 396,668 8.00 $ 449,751 9.00 $ 568,476 Water Distribution-PT WATER DISTR MAINTENANCE 64042700 61020 640 1476 0E-09 WORKER 0.50 $ 25,233 0.50 $ 25,599 0.50 $ 26,434 64042700 61020 640 2050 GD-03 CUSTODIAN I 0.07 $ 3,401 0.07 $ 3,461 0.07 $ 3,251 Total 0.57 $ 28,634 0.57 $ 29,060 0.57 $ 29,685 TOTAL WATER DEPARTMENT 26.07 $ 1,629,256 26.07 $1,653,763 26.07 $ 1,690,828 -45- Capital Improvement Projects by Department/Division WATER FY 20 Actual FY 21 Actual FY 22 Adopted FY 23 Recomm'd CIP Number Capital Improvement Project Title Expense Expense Budget Budget 7401339 SCADA SYSTEM UPGRADE 38,746 23,027 250,000 150,000 7401393 EXHAUST FAN/DUCT SLAKER 67,500 7401396 CHLORINE FEED ROOM EXPL 46,500 7401397 EP OFFICE/LAB PUMP ROOM W 30,000 7401405 WATER MAIN REPLACEMENTS 260,651 146,786 97,000 7401415 SHALLOW WELL REHAB 53,491 120,000 90,000 7401418 REPLACE VACUUM PUMP-SLDG 25,000 7401422 BiJNKER HILL PUMP STATION 15,000 7401423 FOURTH PRESSURE ZONE ll5,000 7401672 ROOSEVELT RD MAIN EXT. 2,467,954 1,814,720 7401826 PAINT PUMP ROOM PIPES ll 5,000 7401827 SEAL WALLS SOUTH PLNT CO2 970,245 7401828 CLEAR WELL RESERVR-REHAB 13,000 7401829 SECURITY UPGRADES 22,800 7402030 VACUUM FILTER BACK-UP 4,916 ll,049 7402044 GREEN ALLEY PILOT PROJECT 108,000 7402052 WATER METER REPL PROGRAM 3,223 44,816 461,015 529,018 7402234 SOUTHGATE WATER 1,136 7402349 MANSON ROAD WATER MAIN 853,750 7402525 N CASCADE WATER MAIN 13,011 479,715 7402527 GENERATOR 79,214 4,121 90,000 7402594 SW ARTERiAL MAIN EXT 94,322 331,290 7402595 CREEK CROSSING RESTORE 35,550 7402596 MAIN RELOC SEWER MANHOLE 25,000 20,000 7402653 L1ME SLAKER REPLACE STUDY 7402654 FIRE HYDRNT ASSMBLY SW PG 20,000 7402655 MAINT WTR MN-RETAIN WAL 20,000 7402656 WATER STORAGE TANK COATIN - 4,800 25,000 150,000 7402657 WTR MN UPGRADES-STREET 20,000 20,000 7402658 WTR MN REPLACE-SWR CONS 10,468 8,799 310,250 7402703 WEST RURAL WATER PURCHASE 191,082 36,899 165,000 7402705 GRANDVIEW/LORAS INTER IMP 7402713 RPR/MAINT WATER LINE ISLA 5,042 7402714 BULK CO2 TANK REPLACEMENT 7402744 PUBLIC LEAD LINE WATER RE 84,500 7402745 TAMARAK FRONTAGE WATER MN 35,242 7402746 COTTINGHAM RD WATER MAIN 7,361 54,647 7402747 CHESTERFiELD DR WATER MAI 7402748 EPWP TRANSFORMER SAFETY 11,890 7402786 DAVENPORT RD EXT/PMP STAT 1,465 7402814 BRIARWOOD SUB MAIN EXT 7402821 LANDFILL WATER MAIN EXT 80,000 7402836 MAIN EXT TO NEW DEV - (19,566) 775,000 - 7402837 WATER PLANT ASSESS PLAN - 6,441 20,000 20,000 7402838 ALTHAUSER&EAGLE WTR MN 145,000 7402839 WATER PLANT iMPROVEMENTS 824 7402873 PUBLIC SAFETY WAY 7402894 WTP&PUMP STATION REHAB 20,000 200,000 7402895 MCFADDEN WATER MAIN 1MP 385,000 7402896 SUPER 20 WATER CONNECTION - - 142,000 - 7402897 BURLINGTON WATER MAIN - - 350,000 - -46- Capital Improvement Projects by Department/Division WATER FY 20 Actual FY 21 Actual FY 22 Adopted FY 23 Recomm'd CIP Number Capital Improvement Project Title Expense Expense Budget Budget 7402898 C1WA SYSTEM AGREEMENTS 125,000 65,000 7402899 OLYMPMIC HTS AUTO FLUSHER — — 37,075 — 7402902 E 16TH HYDRANT RELOCATION — — 24,000 — 7402933 E 16TH WATER MAIN REPLACE — 7 L,500 — 7402934 WTP ROOF REPAIR 200,000 WATER TOTAL 3,225,723 3,024,660 3,158,590 4,542,313 -47- PRGRM/ DEPT PROJECT DESCRIPTION FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 TOTAL PAGE WATER DEPARTMENT Business Type 8th Street Concrete Panel Replacement(Jackson to Central) Water Main Connections 20" $ - $ 166,000 $ - $ - $ - $ 166,000 127 Water Meter Replacement Program $ 529,018 $ 567,500 $ 567,500 $ 567,500 $ 130,950 $ 2,362,468 128 Westside Water System Service Line Installation/Fire Hydrant Install/Purchase $ 165,000 $ - $ - $ - $ - $ 165,000 129 Water Main Relocation for Sanitary Sewer Manhole Project $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 100,000 130 Water Main Upgrades during Street General Repairs $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 100,000 131 Maintenance of Public Water Mains during Stone Retaining Wall Repair $ 20,000 $ 20,000 $ - $ - $ 20,000 $ 60,000 132 Fire Hydrant Assembly Relocation/Replacement for the Sidewalk Program $ 20,000 $ 20,000 $ 20,000 $ - $ 20,000 $ 80,000 133 Water Main Replacement Consent $ 310,250 $ 132,000 $ - $ 99,000 $ - $ 541,250 134 Public Lead Line Water Main Replacement $ 84,500 $ 85,000 $ - $ - $ - $ 169,500 135 Wells,Well Field, &Well Transmission Piping Repair and Rehabilitation Program $ 90,000 $ 180,000 $ 110,500 $ - $ 110,000 $ 490,500 136 Water Treatment Plant Condition Assessment and Master Plan $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 100,000 138 Water Storage Maintenance Program $ 150,000 $1,350,000 $ 100,000 $ 900,000 $ 50,000 $ 2,550,000 139 Creek Crossing Restoration $ 35,550 $ 35,080 $ 48,400 $ 33,120 $ 29,900 $ 182,050 140 Southwest Arterial Water Main Extension $ - $ - $ - $ - $ 1,083,826 $ 1,083,826 141 HWY 20/Dodge St Water Main Relocation $ - $ - $ - $ - $ 996,000 $ 996,000 142 Althauser St. and Eagle St.Water Main Improvements $ 145,000 $ - $ - $ - $ - $ 145,000 143 Water Treatment Plant and Pump Station Pipe Rehabilitation $ 200,000 $ - $ - $ - $ - $ 200,000 144 Pump Station Site Drainage Improvements $ 15,000 $ - $ - $ - $ - $ 15,000 145 McFadden Farm Water Main Improvement(S. Heacock Rd from Chavenelle to Pennsylvania) $ - $ - $ 305,800 $ - $ - $ 305,800 146 SCADA&Comms Improvements $ 150,000 $ 450,000 $ - $ - $ - $ 600,000 147 Green Alley Water Main and Fittings Replacement $ - $ - $ 306,000 $ - $ 475,000 $ 781,000 149 CIWA Water System Agreements for Water Service Line Installations $ 65,000 $ 9,000 $ 25,000 $ - $ - $ 99,000 150 Generators-Park Hill &Mt. Carmel $ 90,000 $ - $ - $ 125,000 $ - $ 215,000 141 Chesterfield Drive Water Main Extension $ - $ - $ - $ - $ 497,500 $ 497,500 152 West End Annexation Study and Implementation Phase I $ - $ - $ - $ - $ 165,000 $ 165,000 153 West End Annexation Phase II $ - $ - $ - $ - $ 300,250 $ 300,250 154 -48- PRGRM/ DEPT PROJECT DESCRIPTION FY 2023 FY 2024 FY 2025 FY 2026 FY 2027 TOTAL PAGE WATER DEPARTMENT Business Type Tamarack Park Drive/Wood Gate Drive Frontage Road Water Main Extension $ - $ - $ - $ - $ 126,000 $ 126,000 155 Old Davenport Road Water Main Extension/Pump Station $ - $ - $ - $ - $ 251,500 $ 251,500 156 Airborne Road Water Main Extension (Landfill Frontage Road) $ 80,000 $ - $ - $ - $ - $ 80,000 157 IDOT Hwy 20/Dodge St. Improvements(Old Hwy Rd to Crescent Ridge) $ - $ - $ - $ - $ 156,500 $ 156,500 158 Swiss Valley/Highway 20 Interchange Multiple Phases $ - $ - $ - $ 360,310 $ 1,003,138 $ 1,363,448 159 Old Highway Road Water Main Extension-Sieppel and Radford Road Loop $ 853,750 $ - $ - $ - $ - $ 853,750 160 Water System Improvements 2022 $ - $ - $277,829 $2,613,454 $16,276,115 $ 19,167,398 161 Water Main Replacements- Streets $ 97,000 $544,500 $1,070,000 $540,000 $ - $ 2,251,500 162 Kennedy Road to Tanzanite Drive Connection (Zone 3 to 4)with Pump Station $ - $ - $340,987 $2,268,945 $ - $ 2,609,932 164 4940 Backhoe/Loader Replacement $ 67,500 $ - $ - $ - $ - $ 224,000 131 Ground Penetrating Radar $ 30,000 $ - $ - $ - $ - $ 2,049,000 132 Sludge Pump Replacement $ 25,000 $ - $ - $ - $ - $ 37,075 133 Tapping Machine Replacement $ 46,500 $ - $ - $ - $ - $ 200,000 134 Vehicle 4912 Replacement $ 115,000 $ - $ - $ - $ - $ 100,000 135 Vehicle 4913 Replacement $ 115,000 $ - $ - $ - $ - $ 71,500 136 Webber Property Phase 1 &2- Water $ 970,245 $ - $ - $ - $ - $ 24,000 137 Whacker Compactor Replacement-4919 $ 13,000 $ - $ - $ - $ - $ 215,000 138 TOTAL $ 4,542,313 $3,619,080 $3,232,016 $7,567,329 $21,751,679 $42,250,747 -49- This page left intentionally blank. -50- � r, •_Y•.•.; • � u ' '�, .�- .�� -��-- ��,;.� . � _- -- - � . -- ��I � ' � �� -� �, , � � ,�,�x��l}�� ! � �� rt � "�' �.�'��' F��'� �1 • � • � � �� - � � �� ;�� , . � - �� } � �� . - � . . . � _�� - ' �_.�:��s �� ; � � ��''�� - �r� � �- ~ " -- . . . _. F f� =-i . �� .� �� ya' � �"' 1 -y'�'�� - r ' * . ��, __ i :�- �� ,� � �� l �• - t� � .� �. �.. � . �i �y�� .� � , � { � �` ry{ � F �,)�� .'�•- �� '�� ,� ' � �r . '"�' Yr _ _r �� : ��'•''�c ,`��'� �+- .', ��_`~ �i�,�- . �� ` � � �_ : ' yti� ��f• ��.•- �• ..�� 6 �F � � � � � �!,�]'� ,�t�'�'..`.� i.� -^ .�.�} ti � - ��. � �.� _ � . � �} r �� ~� � � �� •.�'�~�� .� � �}� � �� - ��^�� r�� i i:. I' { +• ' � � � �•� �� 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. New Faces and Retirements of FY2022 ! Welcome! Welcome! Thank you! � � � -�: � �"��"� - . r�` � � 4 -� +��r: a ` . � � � �•g� � �� ` � � _ ��.� � � � , , �� , � � �;; . �� „ - `�� . �. , � � . � � r�.� . . . ,. ,.-.� � { ��_ '�� f �,�� ' � iv�arYy r�ass Benjamin Pancratz Bret Stierman Water Distribution Water Distribution Industrial Electronics Technician Maintenance Worker Maintenance Worker Water Plant - Retiring April 2022 Water Department FY23 (26.07 Full -Time Equivalents) - r : : - - : � : �� ,��r��r��r�� r�� :��r�� '��.� ��. �� 4'�a[�r D�partment f'.+la�ag�r �1-� �� nfident;a',�rrt ��ea�C ._ ��.o �} Water� V�at�r En�neering �at�.r O�-ativr� Supervisor f�ss is#a nt �15 Spet�asist SUpe rw�is�r ��.a F-rF� �1_a �� [��o �E� .��-� �� —i l.�r:, � �� . - � � �� 'I ete r Repair Wfl rk�r I I C'i IS 5eason a� Intems :'faC�r�o-ant�pera4vrs Forema n . ;�.0 F'�E� �i_4�TEI �0.5 �EI t6.0 FTE� � I �n d ustr�at El�rtrica I Equ i�m ent�pe�ator I I M�ter Fkep�air ti14'�rker� T�rhnician �i.a FTEJ {? FTEJ . ��-� �� :'ater Dis�-i�ut ion I n�ustria4 Ma'sntenarx� Maintenan{e:'.'ark�r �lle�hanit ��.5 FTE� ��.� FTE� Recognition of Staff for lowa DNR Certifications Obtained Andrew Fonck - Water Distribution Grade 1 Mike Patzner - Water ��eatment Grade 1 Danny Petersen - Water Distribution Grade 2 I�WA DEPARTIIAENT O�F Marty Kearney - Water Distribution Grade 2 NATURAL RES4URCES Chad Sharkey - Water Treatment Grade 2 & Water Distribution Grade 2 Carl Plumley - Water Distribution Grade 3 Nick Connolly - Water Treatment Grade 4 & Water Distribution Grade 4 Christopher Lester - Water Treatment Grade 4 & Water Distribution Grade 4 � F�E�TIIV � ��1 � Hi h-P�r��r�n�n�� r ar��a�i�n �a�nd �o�r�r�urri � �h�� i� � � �Y E�l� I T�� LE D�t�-Dri�r�n ��r� �u�t��r��-F�cu��d bu��t �n �h� ��ur pif��rs ��: ��IIII �I lJ 11l IT1� � � F � �I �I� E . . . � + • . t • � � . w - A � � 1'I� r � . - � � � . a.� _ _ �. — w, � .� y,� �-{ � .� �. . � � _ � - # .� - �� F' �`r "�' s � + � #*� , �," ■ ► � � �.ltili�� 6illir�g Feb 2��2 Feb ��22 Feb ��2'� Feb 202� Custamers Enralled In: # Customers °l� Cust�rx�ers # �ustomers °Io Customers Paperless Billing 3,7�5 15 °l0 3,�8� '� 3 °I� , ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,, ,,,,,,,,,,,,,,,,,,, ,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Auta Pay 5,�81 33 °/o �,805 3� �I� --- ---- --- --- --- --- --- -- ---- ---- -- -- -- --- --- ---- --- --- ---- - -- --- -- ---- ------------ --- -------- --- --- --- -- ------- ---- --- --- -- --- --- --- --- ----- --- --- -- --- -- -- --- --- -- - ---- --- ---- ---- --- --- ---- - Phone & Qnline Payments G,535 �� °l0 5,fi�2 �3 �1� ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,, ,,,,, ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, 1Nate��mart Registered Users 'I 1 ,0�4 45 °I� 8, ��9 �4 �I� . ..... .... .... ..... .�---.......---. ..... ..... ..... .---.. ..................--- .---- .---. ..---. ...................---. ..... ---- .---�--�---�--�--..--�--��---�-�---- ----. .---.. ---.. .....--�-----. ---- ----...-----�---.......---. .----. .--- .----- .---......................---. .---- .---. .---...........--�---.. .---. ----. -----�---. ............. Sfarm�rvater Reduced Base Fee" 558 � °lo �0'i � °I� - --- --- --- --- --- ---- - . Refuse Reduced Base Fee" 5�'� 2 °lo �9� 2 °I� . ..................................................................................................................................................................................................................................................................................................................................................................................................................................................... V1later Reduced Base Fee" �97 2 °I� 5�8 � °/o --- --- -- --- -- -- -- -- -- -- -- -- -- -- -- -- --- -- ---- - -- --- -- ---- --- ------------------------------ ,-..--...,,......,.---. --- --- --- --- --- ---- --- --- -- -- --- --- --- --- -- - ---- --- ---- -------- --- --- . Sanitary �e�nrer Reduced E�ase Fee" 499 � °/0 5�� I� *�otal �ustomers 24,��2 "FY2'i Ger�eral Fund Re�luced Fees $1'I �,39� FISCAL YEAR 2022 HIGHLIGHTS , � 4;� Kf'n721'L�1' �fI ��t�at�c��Mc�rsi Erc�zsfon a�zc� � SPe�.a,R�^:a�em=��,��5 ❑i_T P[_i[][.`� � xo,a nw��a w��E� — � -- EXHIBlT A ,. � . 11rlr�fl��c�z=r �.rr�;c� SirI� llrtf��r•:ti1r7i�r C.��tcrt5rs��r ',5:.,.a:.s:.� '� . i,. �Y , . •Y 9 . � . � � �.� �- � •�'-sv:e� .,, '� �� _ frs, �� •f . . .�-�$. .,�,'._ .�.�`�^4�� .._ "- :r=... + � f�.. • Kennedy Rd Water Main r ` ' 4 - F , � ' � � f� ` • ��wner To Tie Inta Existinc � � �''� r - Private Water Main � r � �i ;• � '� • � ��.: j,��+�j�., � •• k a�. ``$_ _ '+'�,i I � - N � , �. �� ` �.��,- `� . . _�., �1 � �� Extension to Wildflower Ridge .� q4 ��..�� y �. �;�,�e� :� ��.ST�.�4cn�, ��.��_ � .�F � �� :�� -- �! k f" .: X . .....�,+►' .'-�: �.. K 7 � ' I r �� .,, Water P.1a�n Exten�in To Propased �. •� �r ��;}• i t i � , ��' � :i��'S`� dY �� y�, � '-��C ■ ■ ■ � '�dater P:1�m�n Kenne Rd. • i O �� S� - _:.. - F"D+' .rk 5�. r.'�,It!T�, �,-..:i�t�,4. F4,�'_ !� .�r^�•!� • '/ � y� 'J i`I'.. J" _ u b d i v i s i o n f-.��- ;:� ::,�:�,, ti � �� - � _ r�L !+ - - • ��i��Yt '-� �7II 5 r .. �� q �X.3��' j ��W,.�: i I�. .r ;��,��} , y,��,,:� . Owner7oTielntaPropased T,,,, � ` �. �'�� Fu61ic Water Main Installed By City ~��f'�' ;x �• �i � �' Citytal��stall � :"��t. 'e+=' � � 12"Public Water Main ��}' �"�},::`�� t��• � '-I "'•'.:� ' . , ,p�a �,•�iw. A� w.� �� r ��'. . � . R �-.I .•i'�7L.�r . y .� -y} Extension an Kennedy Rd. �..__ ;��'e: _ . ,'_:,..•��_w�_:-• •_ _ - . _ • Coordination with City Engineering - . - �� d� y�� -- "- ` A � '_�-a �: ,`_ - � �� tr _L . ,»� � ��-s,• �'�, �"�.a �, � :{ ;♦ .. �I � • T��` j �,...�, . k,�/ �` � ��r1,r E�� I �iT�7o Tie Into Existi{�g �� .±� :.�, r-�- ,� � iPu6licVJaterh�lain � 1'. _ ' ,e;�+�.. , � r �� .: __ • , � ,. � :"� � �' ,� �� ' End Of City Installed Public Forest Glen Ct. to Daisy Trail II :p'� �;,�` `� . . ��%rF'',�I� �j---- - '+"daterFAainAtPropertyLine i � 1 �r:!l:.��-'� ' � � !r-'� � `+�'r � r'.�,�"ww�"-"�Ir �� . - — �-� ,- --�"��'. I� •',;. ' f_ i"'�, �il* 71� r �-� r -al�- RR' #'` ;i/ >..^'•I� -R � i}� � i • 12-inch diameter• 3 800LF �- ��. ��, �� a .. �, .�,,,� „�-,• _ �,� � � "�--- . - . ... �° �� . -,,.-; �:- �� eF'... ��' I� 7 7 ' �• � -- Y.". � .�_�..: . ''�.= ,?.�= r.�.�R a. ■-J� .'} �J_LA�a r ^.'lY r'r_.'1L..lL.� W.�r w a-Tr'+I r'1�`.'�1�:. -� .. � �.�...... jl�7f� _ yn � �,r1.r _.. . -a. . l] w } V• �+�'""Y.`e`I ,�S5 *�.� I � �v� �'1�� r.i�-.. ��. �'�W ��1 - I�. �r � MI �N'�9I'LA .`•� � .r } �4 �y. .I i �1 .i�r's .�' �. • ContractAmount: $827,687 +i�� _ � °: �,:}�• � �,T �; -�,� ��r�,: ti ,�� - �:.=.:=�' � ;:3�- �� ?: ,�;_� _ _-��,� � +,� �2� ,�. , �� ; }, �II ��:�� . . _- . �� ,`� LFr� �� '�J = �� ►,�.�� t�"` '°-F;��'�. '- �, 4:_y -� f -� -y_1�^ �" 'q � Drew Cook Excavatin /Tem erle -:-� . _— ��-.�x;;. �;- . ��,- i � `�`�� - �` - �.. :... J p Y .�� -- � .� . _� .,,P -�. � r , � �. �� L . - --- �---�. p � Y �II i,_51 �� ,� 'ti- i � �r�'"��'..,��r S"-i}.r -� . .�� fr.� 1 " r� .�.: :4�� "' �•�j'' --.,.--� ' ,. , i _ , ��,,� �; :3�`� ,- �„ � .�_ '� ��'�:Y Excavati n g . . - ; ��, '� �,�` 5�;� ��:�, � :�,�,j rF,_ __ f;�. a+'+�,n�r �. •K� ��.,� . . � 5: � ' �: � •" "��`�- ---,- �- ,�-�� 5r''- N fv1_3;� ,re��ared by: � McDermott Excavating __ - - - � �50 5Qa � ,�� G1yafC�u,��,e Feet W`�'E W�terDeparlment It�02 Haevihorne St . Estimated Completion Date: May 2022 - � �� S ��-s��-��G� FISCAL YEAR 2022 HIGHLIGHTS �- - ::� . � . , � � .,� � �,� , � � .. �+��. r,:. ► . ' , h ' ' ..�;. • t��: ' ��`;� '`i' + ��f •1`*'+- ,. �?-" '� +-�,,�' �" t �^�f�. ' i� � � r_ . ,.• . ," h � � -�� • O rc h a rd D r Wate r S ste m �� ` �� .. �.; �. k , -k,� - A �� y � s�,��:: � v � .� , �. ��,_ i `�, . � � ' , �.,�.,�.. . I m p rove m e n ts ��= � �rt�_ �, . .,n;. ��t� =_— t� �• �; ,�_ �:�e :�: - - • ' _ . t �`.`4 � ��` � � � , • Collaborations: Water De artment and - � . '' - � . . - -��""�' �' ' p .;= , t ,� �;: �_F ; �_ �,__ ��r- .. �m, _ ``' i . ..j.,'� -1,� � .. Public Works � . . � �� . '° �# - • �• . " " '��. - . � t'�Y'�.,\ , - �:A= . y _ y. � ' �� - — . ' 1 ' 1 ? Y x�'� , �".F:;�- ; � '� ,�� .��'R. Jqk � � �� .✓ � � . -�=..' i•-+. •s �_ • 6-inch diameter; 1 ,350 LF �� ,,-- �� Y," ,f .,ti 7� � . '1� � � ._ !`��'�,� . • 680' Curb and gutter :� ' `} � �F ` �'� �� y � - �.�'�"�'``� d � _ _. � � rti 'l .S 1 �n,-i� ..1..-. � ,�.^ !� � .. � �,'-� " w� / Y ��5 � _y' . • 360' sidewalk with ADA Ram � � y �`�' - �� " �� : ��r� - �v - { � . . p � -:�. � . ,� �` ��, �" ��y} , f- • _ �;�:�� '� . _ �� -�� • HMA Overlay - Spring 2022 :�: "�` r - � } � � � '► � �'� ��. � �` } � t .�``:. �_ � •� ,w� ,.�^ �°` � � Total: $432,316 v � �� ,� ��^ �� :. T � , �' � � .K. . _� ��flOC��0�1� �� 4� .�� . .. .�. •� ..:�. ;..�-�. • , - �+ � .�� . . � � .�; ,- . �, � i^"4';� "` � ` ` ��r `k 3.' , �. . �t+.� �4r � "0•M ` , 1`"�:r'p�" '.,��te�:T , •.Y��-x, . y � �� . , �r ., ��r:i. ..� �- .,, . . . a:'r.l . �.� � , . • �_ , , . ' F I SCAL YEAR 2022 HIGHLIGHTS l��- SoLrt�ligerte Da� er�id Siaiz�soz� St� SpzG"��1e��,".��_ �.nii:� iur �1 zo.�h�„�4:,,�., ,��.� �� ,�_ �� Ll'atrr:l9aiuGn��echi��rrC]P-.9fl-a'3.� —— � I �aso I� II 2375 SiMP5D3J 286 • Southgate Dr. to Simpson ' � '� � � � � r �.. � ��- � ,... _ ,-.�. �#. � � � 2865011iHGAFE DR 290 SOl1THGA7E UR � St. Water Main Connection � � -� , . � 2445 53MP50N � �{, R�p�el�a6� sMpS°�,si �eae"tlsro.�,se�e�o.am: .y5 .... cRn erMa!n __i . �� . _ .-. �.y S�rveyP�o^t � �.� Descrip `� ( � _J ti' 43 �JhD13�YP.00� • Project coordinated with City .� `�l � _ ' -��` �'�� "�h � j _ �°� . 7 �, . ��fJ Cl �'- GF E [E 'n r�� * + � 1 _.��r, ,�Eas�M_�� / 1C�F E�sarrer�t bowm Engineering --- s'�BoxS�`°= -- ._ , �:�..e � � SO�fxGAfEOR � f H{ran�z 6"ClWaterMa��:n � _ - � � VaJvez . . y� '.�—_�� ~ _ —y_ _ '�' � � Fin�n • Contractor: : - i - - -�� e= � �s-Rc.Pet7.so-% i rr� _ . — �i� i = F'��g � anua:tl?=e McDermott Excavating ' . H��d=vPe F�o�E I Warer Main 24�0 SIMPSON ST —E.�=t�np ] ��F�w�.c5ed YService Connecfions Total Cost: $58,449 2a95nUTHGATEDR S�a= � 296 5UUTHGATE�R �� Sanrtary ManM1ole � I � Sani[a ry Tap Fimng � • 6% below awarded contract. �� s.rtaryG�a��TyMa�° ..„�,.. .� _ ' h' Map Prepared by: Ciry of Dupuque - - �inch=27 feet �.��E �nacer oepanmenc _ � �_ 'aFEE� 1B02Hawthame5t - ,�^.a:,..�:�.,,.,... S 563-SBQ-0291 FISCAL YEAR 2022 North Cascade - Cottingham Rd Water Mai n Relocation HIGHLIGHTS � � (lowa DOT Swiss Valley Interchange Pro�ect) � � � 'f" f 1' r �� ? ,� py�`, %� *' s: l p r • t� J� . ti �RY7 ''' 9 P� � .� r '��w •! ' jw..,� ,.,f. . . g � � � r i ��r��i i � • Collaboration with lowa DOT Cit T� � � - �� f , y t .{ � � :s; f �.�:G:� :. � { e -, ,�•,�;`�., '� ' �',. .,x�-..,� Engineering, Water Department � � s � , ;� .#• ��. CE�ARCREST r:'s �=�'��. :-;�..= � • .�'' � �� wA�Rniair�i c�t: . SUBflIVI510N •9 �.i..'':�;�' � y� '� . � s " 'q,,, ' �, y�' i:e�';: REtDCAT14N::'� r � £ �. ''�*; �;�z;��' ,'�' i,, r , r.,.' • Benefits: �� {. :: ,. . - �,� , '� :: ....,�. x y .., �� , •q ' NEW � . f ' k� r M '' a� � r � rf INTEftCHANG�,f: � `-�r .r � New Services/Customers � . �� ,, � , i � ��.�>� � :-. r � Y , ' ,, ,/ � _.�. • � � More resilient and . � : � _ �-�� NEW G�TTWGHAM RQA� �,,,,�,�,�„ti _ _ Qm �;war�s r�ain�:. ^•r.� —'�'�"'�p8DND6h Eo �r � � ` sustainable water �. �•••••��' �� . �' ',. � ,�t distribution system. ' � - � � � �,�. �� — �............... �% �'` i WAT£R MAIN� �q = � �RELOCA7IDN� . �:I �.�..■■.a�qr.a. • c�ty cost: �752,soo � ,,.�� '�f -- �;� ' r'�� , •f S r.'.1 � • lowa DOT Cost: $498,100 WATER i ��-��" - � � r4WfR � �' ' - � ; �� .� ' � Total Project Cost: $1 ,250,700 ',� t�,' , � �"`.' � .� .4'JATER MAIN r �' , � �RELOLATION � :R; ,,,^1� � ,� ■u�,n■.nrsrs y6, '• j ��,-�. i' �� µ'. . t. � h• '� �� _�.�, � � �..'� " z � ��._..�,. --- � .:�,: . _ _,�� - - - ; - • Reduce Service Outages: . � Althauser Street and Eagle Street Water Main Replacement & Lead Service Line Replacement ■ ■ ti � r � - �� _��___� �� _ ;� . � Althauser 5t � �--�'—�.— � ---- - �----� and � �` � _. � .--�-� �---�-y__ +:� i ��:7 _ - —.�— - � �`-- cV ' ' ; --�__�—_-�-- _ --_�� --�- �� - , - -- � � Eagle St — • i � �a �",-�,,------ - - I� � � -- - - -._ ' � p 1 - , i -I � �4 � - 4- - '�.. { Re�onstrud�on Project I ---- � � YW. , , , '4� �--- �, � , . � ' __ . ` . '�� CITYaF�UBUqUE �� ❑178LqlJE C�UNTY,IOWA � . I� � �� I �- - � ,�\ � . ` � I � k,� :� I� II . � � ry .�. `' �E L@GEAJD —�, Water Distrihutipn 4 _ _ -�._� � �L�:� �f,�_� ±� -- ---�� + �Hydrants J + � + � �Valves f..l�_ � � �� ' � ' Water Maln Sreaks � �.-,� ' i , i - �` ; ��i f � -Water Main I � - _, �� ' ' j ? � 5Yorrn Water � . $ , �� _ i + 0 Storm Inlet �� ' �Storm Manhole ` �/j __._------ _ �+ � ,. , Storm WaYerGra�ity Main --J � � SanitarySewer _ � J� . �� . r � _ � �Sanitary Manhnle � ----� J� f f f � • Cleanouts ; ■Cleanout Line -� � f ��' ►Sanitary Sewer Gravity Main F� Other �I I' �+ f Water Main To 8e Repka[ed � �iTax Parcels . [ + __��-4�"� � I ' �s } •� I ��` � -_�{�,� . ; •J� �„ � -- __ — _ - . -� � . c�^Yaow,w.swrm��wn,�,�r�sawl�n�ni�;,,�m�� ma • � f _ , r.inolaw�ryi.e�Gri.�Gisdam!nipwnilr�2o2� ' � I 'f w�ww-rou,ryes — . i, . -_. •�4 Y.� A _ _ I . I = . : � ` s -� � . � � J ,.,,<..,;,,,,.,�,��,,,��,,;,,a„w��,�,�w,P�,.�r::�� y�� i f ,.� , + - -._ + � • ,,.,�,,.rar:�„��,,•�', �� _ _ �'` `" ' � ��ti�t � ' °-. _ f �' , MSA� Yx ��,�.��.:, _ .. � �_ 1 � �'� �J<«-.� � • Emergency Response . � Park Hill Standpipe Emergency Generator Installation Project ■ ■ . ------ � _ � - � _ � � � � `� � , . � Y, "��i. �`,�{� � -� " � � '. ' �` .*.. ___'� �y' 4�� rr�yy� . ?g . `,�-! y ' 3�t��,', ..:.�:.: .. � � \ _ , y �=- ry A ��:. �� _----� ' ^"a'ti��y_.._�_ ei I �:.��,,�c;,,�".s L:� : ��^yi,r� //� - �.. �ti. _ .. _' � �� Y�' �w;,�•'`�L.� f� , FILER ,-;" -``'s_ , ,:. 0 - • -��r-�r _��,�.� � _� � : .x .�,.. . r-. • .�.� -.�pj'��:- ��{,�:„ h �,`o nu�n m. ��l _ .. � - .��,itT, �r � ��n.�iu ri"'�..�,.-"�. . ' -_ -y-�- � ��. � �_'�.g'� M1�^ e��a��:n":ii:n::. i ! -^ . � • r •�-$ 1 , � . , �.li�it� -•-•__�,�•ti, ,�_--��. . .._ , . - - . . _ _ .Oa �--� �p .�� .� 'F - - _ �,,,,,_ �. :...:_ -� .� wl'��n'�.��.� �' `� �- � - ��IWI: ��wrom�n ' "_ . ' ' _" . . ,.mn��amu� ..iewnrmn � r.. r-.` . . _ " . '____ "` _" • _ _'__' �� '• ' ' � - _. .. _.__"��..�. • ' — — , ^ �_�... ., . . �•_ • _ _ _ ._....� _.s..,"+�`'""' �... c:-�,r �r • •+.r - _ _ -__ � �`�� -__ - - - ;�� . „ - - J ;.;_,. - - - - .. - - - - � ~ • _- - - --- - - -- �- �. ' ..��.;.____ _ _ -- �� . :i`,+:�!s: _ - - - - � . .'. -=- _... - -- ., ��Lw��a = _-_ _.-_... --.: _----�� '�_ �.-� _..- - . .- t �"''.. ��:+5,y�.�LLiY, �► .1 F` � }.- .- . • — .._. . ,►�- ,+��A` ''� . : - �"'... ��'��/ ;� ��,•��" r � �1 { �i�, �� r , . ...... .... _. ,-•x � _. _ •-�vyr4�i . . � - ••-....~ �_,_-_....-••�n' '... � , � __ � ..-.•�.r+�^•� E�r-r .... . . . *+• . .. J�� i}"".- ... . `._,.��. .Fjr�-.-� � , ..._ . r � . � ' Y�� _.... �� .. �� , .1�� . .... . . . � � . . _�'I� . � . . '..�� . . . .M . .. . . . Support Economic Growth and Development: � Crossroads Industrial Park: Phase 1 & 2 - Water Main � Extension ■ ■ ,�� , ;,, H�� . • :, `�, �.�r,,�.��.�, a'�9!�� .,'. �`�+ �d .....e..�.... _ _ _ �II 1 .�r�M��:��rH�KNEIv?�n.iCE� � - , . , �-_= _ '',l � w • Project Design Coordinated with ` � � � w� � Economic Development, City _ � .� .-- .-- • � ��, � on `,r ',� 7 _Ea _� , ' r -1- -- - -- , t�. � '', � Engineering. Engineer of Record � , �� FlLL � i '� II � :�� --- __ Origin Design. ET . � FlLL , � � I � , \ �� 1 _ ; � � _ __ '�� I �� a�¢ I 1. i ■ - \ �:. r � �� - �� _E _ � �� ° � f�___ _ :. • Phase 1 : 4,555 LF 16" Water Main � '/:.. .�� ' � � 'i/ � k \ c.ra� M I � � 7C � �' ` � � ~ � Phase 2: 450 LF 12" Water Main � � > ; . � E E1 LE T E f1 LE � II ii � 1 T � ' I g �d�> 1 v � .� Ef LL i FlLL � . ' .. -T E.EL -LE � _ 'I .EiLL i FlLL , , ��I�I �—J .,E�1.�a_ I I I T . i �.� m Q 'y�� i _-`___.____._.. �� FlLL . I � :�C� ` ' '� . .Ef � � i FlLL �� II �IY � X a '�o G� � � Project Cost Estimate Including �, , o � W� �� I ----'-.-__H-E___��."_ --�; r . �.. }f��I ' I' II -.-�.:'. �".-I'.: \.� . ❑ � :/•:� ..;"y._..-_'....'. :.� ,:. " _ _ _ E•�.!�::�:f!�:': i '��, �� • ' H_E '�� , -�-_ - i; __ �� U � Engineering Services: $970,245 � - , _------ -— - — �,� e � { T E EL -�LE ��. ' ' " .. . _ - � � ' . .'f, ... . _ .___- __ -�-- ._.._- �\' . � T __ - FlLL , \'t� .- �.}� -: .Ei FILL � .�. ::/.�'.• �1' � .. _ --------�- �� ` .�� g • Construction Schedule: �-- �. s� �� -__ � � � f I '�.� R r ,_ � :� �;� � ; .� �� Completion December 2023 II .n_E' I1C.. Ii r1 N 3� . . r � ,� �o� 8�_..II+ _� . � - �LL i ' - : ET T o�' ,-=�r�J I ,� S � I s t I � F� I� I r �_E •I I' J 1 � v I FlLL i / Ef T Il tl°..�.. �� _-'.:- L -ll / � e� r :��ir, , _u�: / f II r H-E' - - I /n� • rl_ r;� . �I•- { - f I - / RLL � I e� f n�E X � I rr nLL �J o ° . �Ilr l _ fy . Support Economic Growth and Development: � City-Wide Distribution System and Storage � Improvements ■ ■ }.T� - _ _ �- '�''� �'�-�-�_. .�` -. _ # �� ._ ��` :,: , . w },�. . -� . . 4• � i' � w� �,a��P5 ��E[D�hLE f?�Aa � y�i.- �� ,� '.�AT�R hl AIN E��EfvSI�N �� ,� � � • f , , . F�G46��4"T45K9f '• "�' �.1� .'. �JT CEIviRALr1'�ENUC � �:,��S� Y�n r�ri�s 6•�05TEF��fATf��I I 1 � � . _�_u.�—�� ~ Yr 7w:h`crr.rvc•r _ �� r � M1i5 � � PorK Nd t� � �,�r,T�kA� �1+'�N1�E �•or�.Nil Tark� � k`ti'ATER MAlhl ��T��Sl�hl • O'7�r�ti F�_i�h:s��L C��Ir.rp-'�try�� Aupar, � �� f'�—P"' fi�.r�e•k�i�-��, ��ip�iY��:c��i � '`��- } .� � ��Tr�,��_�- a��r�� w- �L: �.��a i tr� i s�urtr� . �} _ � -,- .. . ;-,�i aLYMRIC NEI�NTS � w:AT=R �dAiN =K—EM3�O�J � .. _ _ ..��Uar�P� r�,�Tx�� • �UL"H'�t't�:T AM I�i�IAL ' ',�'�=f� �!AI�I E`�'�N�i4N I � �}� �K�nk � hi�I�TI-I CAS^AD� R�OAD x� _,. � 1�+ATER MpJ N E�TEIr�SI�N { f�e. i�3 Pe��Tsnk � . _ — _ �Cr�fsh k1iF�3 � • Lead Service Lines . � Bipartisan Infrastructure Bill � Lead & Copper Rule Revisions December 2021 � � • Lead Service Line Inventory - October 16, 2024 � �. ��,� _ .}. s. :-,�,�s, �.y� ^ _ . . - ' . ,.`� . �'; . + ,..� .. -. . « r . .. _ _ - .. ._ f�•.ti:. � � ``�� . . ��`�..\.. � �. �� ..` ��``�-� `'",4 . ��`��\ - �. ��. � ��. ��`.\�� = . �\� ; \�� : � ��_ � �.t . > � � } a ;, � �� i�� }��"" ;i�!`fl � ji` . r ; f t � ' Y r r�� " `. r : � - � =� _;�� ^- � — .'4 l�y;�^'i �e �l ` r + !. ti;�., r . � r—�.s '� - - ' - Security, Communications, and Energy Savings ' � SCADA & Fiber Optic Communications . Upgrade Project Est: $1 ,200,000 John F Kennedy Rd to Soccer �`ank SPe�,a�A�h,e�emeR<��5 ■ ■ T!iFCfIYOF ;.. DuB F � �o,o Awa�W,�ne� ,Lf�i�;�r,ur��u flie,l1 i�N==i��,,� Ll�z��lnrrrred Uist�arice: T SbT Fecf �TO � [� � � � � � � � � `,, � � �r��r �; O " U` � � � - �( � � s . , ��- � �S JOH�F kP,y �ay0 �I � � -' _ hEdYRD� `t�� n �r �l�'.ylW _ �q !7� 5�.'� � �� I �� L „k,. �� . �_� I� j`L�L�� .e ge nd V � �Proposed Wa[er Fiher r_ -VJater Facilities 1' �(/�..- City Fiber Network i`' '��' �<all oiher values> .. � � Stahas �Ac[ive • � Inac5lve y �LlnderCons[ruc[ionl�esign ��PJ. ,� �—�Proposed �P,(;� � � �� m,� �Abandoned in Place � . . .� ��}::xa�/ . eY_. �' L�:�G�'p�� " " : nf Map Prepared by: 1 inch= 189 feet C�ty oi Dubuque � ioo so o �o0 2ooFees 1/U E Wa1er Dapartmeni �� 1902 Hawthorne 51 S 563-589-4291 - Water Meter Product Replacement Program , . - -- :::.:. _-- ,__ - � __� ._ _ . � - - -=- --_-�=�� --_-- -- - _ _ . - - ___-- ---_ - -- -- _ _ . --- -- _- - -_ . . ■ ■ __ ._-_.---_ -___ _- _- . _- ___ _ -_ . _-- __ - .:-- -- -_ - -- _ -__ _,.-�_r ,_ . _ . - - : . . -. . :- :-_ :�:��_�-r� _ . , : . : -�- _ - • Water Meter Product � =�-�---�� - _ _- -__-_ -_ -__ --_ _ . : .- .. �_____�� Replacement of Meter .� : - - - �� : � � r �� . _ �� 5� r .�� .. _ _ ' ' _ ___ - _ __ -y� - Interface Units and ---__-= ----=--- - _-----_- - :- - :=r--4��-� . . _________ _ __ _ r_�;-. _- . - -. . -- : ---_= -- -- - --=-- - - :�� - � �� . - _ -_- Registers . . -._- -_ , . - : � ___ - _- _ - �� _.` � 4 � � _ ' ' � ' � � -. �� . ��' � �� .0 � , .: :� -��'' ._ - -'� � 5-Year Program. - : � : . - ��= _ � �� • � ; � - � � � . . . ; -t� , r . I n itiated i n FY2022. - - . �: � . ,�� — r. �a;�� ' �� :, � _.`�`�� :,,�'�•y y54 '� �� Q 1 ' �r -.�aK • Work Performed by , - �° �� . � ��y��:'�i F�� h �.. �._ .t¢ � . • f 'hy��Yr� � �r7� ;'�},'9�� ,�•�� r��sti'i�_�r Y{ �."... �1 �4 ..� ..T• � ,•��.'�s�s. .�.. ?" f' Water Department ��=��,-.�� h : -:� .l:�7�: , - ��{'u ��4.ir:... 1` x,± : _�S'r'ati. �"f`�J � �'.� ti.YS ��.� R3:._"�R_�T.y�µi'}\�+'r�:V��'i�n_.' .�r. 4 " ., _.. _ � . f�.�:.:•��r;:��'�?' � � - .* � ��`F:=. �„��{-f'.=;;��*':.#�l,r�• �-. . ��-. v.��.`7.� Meter Crew. ��;� ��,{ �� =-,., . _ � �� .r�-.��. .'' r I�i�c�-�.��':., " ., � . *_ �} 4�ti_.`"., 'f' 's.�l'' Y r s".:x y fy !� :. .;�.4 . � M �}.,� *k ..�� .l y.� .�'+.r'..Si1.�l" .'d:s� �i-."�.`i-"',� � � _ ; �� ,l�`N. . , • 's�,.� 4.�'' F, s. f..F,. . ->�,: r -:.� '.�,;.. Wu, ::ia'�'� � � :�. k::�;4�: . . .,, .- �:.. u,+t� ,,� _ . - �. ��,j.,... .�;::�'} •�.; - ;.;��.�.,_ a h• „',L�+, 4�' r' �; q. ^' �� l�� '�Ct�.�ti':,i ka��i+'-r;PRKS�� ,��°- � � � r'�7yk, �``l.�!'ti�' �}rf".'�t►{+i��5:��k��T�-�€. ,�,s'r.'i' �:a►►i;,�.:�r�:'r. ,:�r'�."�'�� "ti �r�. . . . Danny Pefersen installing new MIU *Average Household = 6, 000 Gallons/Month 0 0 � Proposed Rate Monthly Bill Impact for Increase over FY 22 Average Household* RATE COMPARISON Rate Comparison, Lime Softened Facilities Only $50.00 $4I .67 $40.00 �3�•76 $3�•�� $3 5.93 $3 5.0 I $34.42 $33. 18 $30.00 $29.67 $20.00 $ I 0.00 $— West Des Des Cedar Ave.W/O lowa City Ames Dubuque Council Moines Moines Rapids Dubuque Bluffs � FY23 Water Only forAverage Household (6,000 gallons) Based Average Household = 6, 000 Gallons/Month 2 n d Lowest Rates : T h e H i g h est Wate r � Rate West Des Moines is 26% Hi her � g � , than Dubuque's Rate ; and the Average Rate is 7% Hi her than Dubuque . g ��OWJy Home Staiistics— Resources— ManageAcco��nt— WAT E R A D M I N I S T RAT I O N T�a��g E�e�t deta��s � . Employee Training and Development Date ;C310'2021-03;,4,Zo2, Location � Professional Development City&State GNLINE � On Boarding of New Employees - Contacts IDINARURALWATER 0RG � Continuing Education Programs - More Inio IDWARURALWATER DRG �escription RISK+'RESlLIENCE 8 Eh1ERGENCY RESPDNSE PLANS-Iv1ARCH • Re g u I ato ry C o m p I i a n ce MaxAllowable Hours 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 �� ■ ■ 1��11� � - �e ��t • Water Production and Treatment � �r.� .� - � Regulatory Compliance � �`� - 1 _ '"�� Water Qualit - Consumer Confidence �� +` - - - l _ _ _ Y • Source Water Protection - . ��J� �. � Wells and the Well field - � Treatment Plant � ��f� +�I.j., •F � • Water Storage and Pumping Facility ;� -��,�J�; �+ . . �` Operation and Maintenance - � � ��y�� -� ��. � ., � � � .� � . : . � _ w � • Reliable Data Access and Reporting � SCADA Communications �„ � �� WATER PLANT OPERATIONS ■ � Eagle Point Water Treatment Plant �� • Plant Capacity: 11 — 13* MGD . �� _. • Well Capacity: 16* MGD . = I � . : ��. ;�� • Peak Day Demand : 10.7* MGD � � � � �� '� - ' � �� (November 2016) - - ' N � . r - . . �� ' 1 _ +� " ' } � � . + . � � - ��4 � � K� � ` � ■ '� i - �� ' - � � �� . � .�� • Average Day Demand . 7.0* MGD � � � �� _ - f �_� _-- - ,� . ��, � � � � � - �--�.� i 1 v � .1 .*� �yy ��a - _ #��^'� + � � - � - ��r��r�� 4 �.� - �� _��' _ - - = r�i�+ - - �� . ' ' ~ - . �� WATER PLANT OPERATIONS ■ ■ Water: Treated and Metered Non Revenue Water 2,500 2�2�4 2�2�3 (Percentage� 25.00% = 2,000 1 ,898 1 ,914 I 9.8 I % ° 20.00% ' �•'�°� 0 1 ,500 o I 5.00% 0 w `� I �000 _ � �.�� O � � 500 5.00% Treated M etered � FY'20 FY'2 I � FY'20 � FY'2 I NRW Percentage WATE R D I STRI B U TI O N -___-_ _ -~�~ - --�_�_______ _ ■ R - �. _ _ �, � - _ __ � - ��- � �Y - ; �..� ' �� _-- � s. r , - .� � � � • r i n n M i n n n � ._ �.. �� - �� n� _�: Opeato ad a teace �. � ,.t ;�v � ,� __ � , �� : � • Emergency Response _ _ _ _ - _ � _ -- _ �� _ � - -� _ - �_ -. • Inspection �-�-.� _.�� - �.. • General Construction �-- � - � ��-�� x��=�� T�� , _.�: �.� - .,� ��`m� e�- +,� , + "' � � -' � Service Li ne Mai n Taps � ' -� �=�� Y �=� 4 T.-. �Y .i�.RCClf.�'S�a...:r43{%.�L�i • Water Main Installation � � , ,,� . �� . � Meter Management ��-�� - � _ `� , , � .s�� ..; i � • Backflow Prevention - �� : � � � �� . � �� ' � , f �Y � ■ ,�� ' • 1 ,,.`��V'�7. • Development Rev�ew . __ - , `'� - '�- � .-�..�.. '� _ .,�.� r �"`� - - - -- - . _ - � ; , ..�..,�..-: ,� . . ��,. �.,, . . Pf''F!��! �Nrx �; ..,�..��Y.:T� ._'�i� ��-.;'�{�,�b��W�.7� �y ' � i _ WATER DISTRIBUTION ■ ■ Water Main Break Response 125 105 100 85 83 74 �� 75 58 60 50 25 0 FY' I 6 FY' I 7 FY' I 8 FY' I 9 FY'20 FY'2 I FY'22* � Water Main Break Response WATE R DISTRIBUTION - ' ' „ , *FY 2022 to date: 128 Service Taps � � New Connections ' . result from � � community growth � � ' such as new housing, businesses, and � industry. � • • � WATE R DISTRIBUTION � ' . , , , , , , . . . - Starting in FY20, the Water Distribution Meter Crew - � � � assumed all responsibility for: � � � • meter repairs, • testing, • change outs, and ' ' ' • service calls, which were originally handled by , , � Utility Billing. � Backflow Prevention Program � _ - _ ■ ■ ` "%d ' ~ �, � \, � I� r, � 1 � _ ,� � , , . ' .�w _ �, � • Administered internally. � �= �� r :I � � �� f�"' �"� ,� �.�..�. '_ '�� "'�'i►, =�_ r �' �� J � .J�r ,'1� ■ ■ ■ ■ � 7�, ' � � � . . Y'A� �'�`�' - • Administrative fee $25/device. .�,� �� _ � � � � � �� _.�� .� ��= ��r� � � � - �:,.� � �- :�_ �j,,,�`�. � �, �;� - ,�"' • FY2023 Revenue Forecast: � ��, � - �� - '��,, ��,� � �_''� �, �( � ,� �.� ,��. _ � $76,150 , .,. :� _- ,., � �;--- � , � � . i. � _ �Y �C � � . � Based on pro�ected 3,046 �°_� Y ` . � ��9� � . r--�___ ;: � devices. � ��l _�� k , "�� ,�`./1- �k . �, � . ' .. • ,,I� j.-._�,.�� . �:�;� _- � 9/�� ► �! ' _ . \ � . �-. a ��,F,.=�- �.� ._. � � - � .� ,, , _ ,: j - �� 7 ,� �. , : ;� --� ..�:_��: .�`�` -_� � 1 � Jeff Mills performs backflow recertification testing / . 1 .New GPS Unit for Water Distribution Staff � � Estimated Purchase Price: $6,600 (Non-Recurring) ' ' • 2.Flexipro Video Camera � � Estimated Purchase Price : $9,500 (Non-Recurring) 3. Four File Cabinets with Table Top at MSC Building Estimated Purchase Price : $3,300 (Non-Recurring) 4. Maintenance Vehicle at Eagle Point Water Treatment Plant Estimated Purchase Price : $66,000 (Non-Recurring) 5. SureCall Cellular Distributed Antenna System (DAS) at MSC Estimated Purchase Price : $12,632 (Non-Recurring) 6. Cartegraph Services Estimated Purchase Price : $65,000 (Non-Recurring) FY 23 CAPITAL IMPROVEMENT PROJECTS - . - - _ . . - . - • . Water Meter Replacement Program $ 529,018 $ 2,692,533 Manhole Replacement Rehab $ 20,000 $ 75,000 Water Main Upgrades during Street General Repairs $ 20,000 $ 70,000 Wells, Well Field, and Raw Transmission Piping Repair $ 90,000 $ 500,500 Water Treatment Plant Condition Assessment and � 20,000 $ 100,000 Master Plan Water Storage Tank Coating Program $ 150,000 $ 2,525,000 WTP and Pump Station Pipe Rehabilitation $ 200,000 $ 220,000 Water Main Replacements - Sanitary Sewer Program - Custer & Auburn Streets $ 310,250 $ 927,949 SCADA & Comms Improvements $ 150,000 $ 850,000 Althauser St. & Eagle St. Water Main Improvements $ 145,000 $ 296,065 FY 23 CAPITAL IMPROVEMENT PROJECTS (Continued) . � - - - . . . • . Water Main Replacements - Streets $ 97,000 $ 2,516,787 Webber Property Phase 1 & 2 - Water Main Extension $ 970,245 $ 970,245 Old Highway Road Water Main Extension - Seippel and � 853,750 $ 853,750 Radford Rd Loop CIWA Water System Agreements for Water Service Line Installations $ 65,000 $ 224,000 Park Hill Pump Station Emergency Backup Generator $ 90,000 $ 90,000 Creek Crossing Restoration - NW Arterial East & West $ 35,550 $ 35,550 Fire Hydrant Assembly Relocation/Replacement for � 20,000 $ 100,000 Sidewalk Program Maintenance of Public Water Mains During Stone � 20,000 $ 24,000 Retaining Wall Repair Westside Water System Service Line Installation/Fire � 165,000 $ 245,983 Hydrant Install/Purchase FY 23 CAPITAL IMPROVEMENT PROJECTS (Continued) - . - . . Public Lead Line Water Main Replacement $ 84,500 $ 276,333 Airborne Road Water Main Extension - Landfill $ 80,000 $ 109,679 4940 Backhoe/Loader Replacement $ 67,500 $ 67,500 Tapping Machine Replacement $ 46,500 $ 46,500 Ground Penetrating Radar $ 30,000 $ 30,000 Sludge Pump Replacement - Lime Softening Plant $ 25,000 $ 25,000 Pump Station Drainage Improvements $ 15,000 $ 15,000 Vehicle 4912 Replacement $ 115,000 $ 115,000 Vehicle 4913 Replacement $ 115,000 $ 115,000 4919 Whacker Plate Compactor Replacement $ 13,000 $ 13,000 PERFORMANCE MEASURES Goals that need work: Goals Improving: Goals that are on track: # of Breaks per 100 miles of Operation of 10% of # of Regulatory Compliance Pipe Distribution System Valves Violations, Target Zero (0) Annually O&M Costs for Water # of Completed Annual Training Distribution per 100 miles of Hydrant effectiveness (Out hours to support CEUs, reported p�pe of Service Rate) <1% in staff hours Technical Meter Service /ssues % of Projects Completed within per 1,000 accounts the Program Budget www.cityofd u buq ue.org/water