The URL can be used to link to this page

Water Department FY22 Budget Presentation Copyrig hted March 22, 2021 City of Dubuque Public Hearings # 1. Special Meeting ITEM TITLE: Water Department FY22 Budget Presentation SUMMARY: SUGGESTED DISPOSITION: ATTACHMENTS: Description Type Water Department FY22 Policy Budget Outline Supporting Documentation Budget Presentation_UPDATED 3/22/21 Supporting Documentation Water Department -1- This page intentionally left blank. -2- WATER DEPARTMENT FY 2020 FY 2021 FY 2022 %Change From Budget Highlights Actual Budget Requested FY 2021 Budget Expenses Employee Expense 2,238,888 2,442,257 2,521,261 3.2 % Supplies and Services 2,471,259 2,616,484 2,649,327 1.3 % Machinery and Equipment 582,302 1,339,511 564,750 (57.8)% Administrative Overhead Recharges 454,496 424,310 435,271 2.6 % Finance Utility Billing 5,915 — — — % Engineering Water Maintenance Charges 46,087 20,399 29,673 45.5 % Payment in Lieu of Taxes 142,884 142,884 142,884 — % Payment to Construction Fund 400,000 550,000 400,000 (27.3)% Debt Service 4,970,399 3,861,392 3,897,961 0.9 % Total Expenses 11,312,230 11,397,237 10,641,127 (6.6)% Resources Operating Revenue 12,160,508 11,014,984 10,553,217 (4.2)% General Fund - Rate Subsidy — 90,685 96,126 6.0 % Total Resources 12,160,508 11,105,669 10,649,343 (4.1)% Net Operating Surplus (Deficit) 848,278 (291,568) 8,216 299,784 Personnel -Authorized FTE 26.37 26.07 26.07 Water User Fee Rate Increase 3 % — % 3 % Revenue 1% Rate Increase Generates $ 84,079 Improvement Package SummarX 1 of 2 This improvement package would provide funding for the purchase of a portable generator to serve as auxiliary power to the Olympic Heights Pump Station in the event of an emergency power outage. The United States Environment Protection Agency states that, "Power loss can have devastating impacts on drinking water and wastewater utilities and the communities they serve". The Olympic Heights Pumping Station does not currently have standby auxiliary power and those water customers would be impacted by a power outage at the pump station. After the 2020 lowa derecho, several lowa communities experienced power loss in excess of two weeks. In order to ensure uninterrupted service to our customers, it is recommended a portable generator plus trailer be purchased to serve Olympic Heights. This request supports the City Council Goal and Priority of a Financially Responsible, High Performance City Organization: Sustainable, Equitable, and Effective Service Delivery. Related Cost: $50,000 Water User Fees Non-Recurring Recommend -Yes Water Rate Impact: 0.59 °/o Activity:Administration 2of2 This improvement package would provide for the elimination of a full-time Water Plant Operator (0E-16B) and the addition of a full-time Water Operations Supervisor (GE-36B). The plant presents daily opportunities and challenges that require in depth problem solving and data analysis beyond oversight management from the department manager. The current practice of having all plant responsibilities from day to day operations to regulatory mandates handled solely by the department manager has led to inefficiencies. The need to -3- create a position that can provide necessary support to oversee day to day operations of the plant providing direction, motivation, technical guidance, and attention to the operators and maintenance staff while at the same time provide opportunity for the department manager to lead the department through capital projects, customer service, master planning, etc, will have greater necessity for the overall success of the employees, the department, and continued compliance with state and federal regulations including the Operating Permit. Until recently the water treatment plant was staffed with a plant manager, seven operators, one sludge plant operator, and two maintenance staff. Staffing levels were reduced by one, presenting both challenges and opportunities. The work of the plant manager has been absorbed by the Department Manager, unfortunately as work demands change due to upcoming regulatory changes in the Lead and Copper Rule; study and evaluate source water protection and water quality, specifically the impact ammonia has on chlorine demand leading to increased Disinfectant Byproduct monitoring; maintaining aging facilities, DNR Operating Permit compliance, and preparing for work that will come from the Water Treatment Plant Condition Assessment, the work load is reaching a critical point where it needs to be shared with suitable support staff. Further, the remote facilities have increased from sixteen to nineteen, the distribution system has expanded beyond the City limits further west and south increasing times for daily sampling and testing, and additional growth opportunities present themselves on annual basis adding to the workload taken on by the operations staff. The creation of a Water Operations Supervisor in the department would not require an increase in FTEs, maintaining the reduced staffing level of nine (9), of which one (1) is currently vacant. The request is that the vacant water operator position be eliminated in order to create this enhanced position, the employee in this position will also possess the ability to operate the plant. 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: $97,825 Water User Fees Recurring Recommend -Yes Related Savings: $80,442 Water User Fees Non-Recurring Net Cost: $17,383 Water Rate Impact: 0.21 % Activity: Plant Operations Significant Line Items Employee Expense 1. FY 2022 employee expense reflects a 3.0% wage package increase. 2. The lowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2021 The employee contribution of 6.29% is unchanged from FY 2021. 3. The City portion of health insurance expense increased from $1,025 in FY 2021 to $1,086 in FY 2022 per month per contract which results in an annual cost increase of$12,620 or 5.99%. 4. Overtime is unchanged from $94,040 in FY 2021 to $94,040 in FY 2022 . FY 2020 actual was $111,927. 5. Five-Year Retiree Sick leave payout is increased from $29,299 in FY 2021 to $31,850 in FY 2022. 6. 50% Sick Leave Payout is decreased from $2,097 in FY 2021 to $766 in FY 2022 based on FY 2021 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. -4- Supplies & Services 7. Property Insurance increased from $59,548 in FY 2021 to $72,702 in FY 2022 based on FY 2020 actual plus 9%. 8. Electricity Utility Expense increased from $678,511 in FY 2021 to $770,628 in FY 2022 based on FY 2020 actual of$733,932 plus 5%. 9. Sales Tax expense decreased from $461,701 in FY 2021 to $454,532 in FY 2022 based on FY 2020 actual plus an increase in water rates in FY 2022 of 3%. This expense is directly offset by sales tax revenue. 10. Machinery and Equipment Maintenance increased from $83,952 in FY 2021 to $83,994 in FY 2022 based on FY 2020 actual of$83,994. 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. 11. Costs for Fluoride, Phosphate, Chlorine, Lime, and Polymer expense (water processing materials) increased from $430,663 in FY 2021 to $431,420 in FY 2022. FY 2020 actual was $377,770. Chlorine decreased from $37,480 in FY 2021 to 30,744 in FY 2022. Lime increased from $310,503 in FY 2021 to $319,000 in FY 2022. 12. Hauling Services increased from $157,815 in FY 2021 to $165,000 in FY 2022 based on FY 2021 actual price per ton plus 5%.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 2020 actual expense was $174,196. 13. Consultant Services decreased from $62,464 in FY 2021 to $29,000 in FY 2022. FY 2020 actual was $38,146. The decrease is due to eliminating the budget for special plant operating services and consultant services (-$33,464). This line item includes a leak survey ($29,000). 14. Software decreased from $64,701 in FY 2021 to $61,128 in FY 2022. This line item includes software uprades for meters/backflow ($890), WaterSmart Portal annual fee ($30,949), Neptune 360 software split 50% with Sanitary Sewer ($23,640), SCADA tech support ($4,900), and Water Distribution software ($749). 15. Property Maintenance decreased from $36,995 in FY 2021 to $30,311 in FY 2022 based on FY 2020 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. 16. Pipe Special Fittings is decreased from $79,332 in FY 2021 to $50,290 in FY 2022 based onFY 2020 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 ($41,000) and taps services ($23,000). 17. Valves increased from $44,192 in FY 2021 to $49,955 in FY 2022 based on FY 2020 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. 18. Environment Testing/Monitoring decreased from $41,604 in FY 2021 to $35,600 in FY 2022 based on FY 2020 actual of$33,191 plus 7°/o. This line item represents the cost of samples due to boil advisories, chlorine monitoring, increased testing for expansion of system, and water quality testing -5- 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. Machinery 8� Equipment 19. Equipment replacement items at the maintenance level include ($564,750): Administration Smartphones (3) $ 1,050 Plant Operation & Maintenance Laboratory Equipment $ 5,800 Smartphone (2) $ 700 Water Distribution System Hydrants $ 15,000 Shop Equipment $ 250 Electric Pump (2) $ 3,000 Cut Off Saw $ 4,200 Smartphones (3) $ 1,750 Annual Maintenance Projects Pump Replace Vacuum Filter $ 15,000 Generator Maintenance Program $ 18,000 Water Main Replacements (Repair of 70 mains) $ 350,000 Large Water Meters $ 55,000 Water Valve Box Maintenance (Public Works) $ 20,000 Water Meter Testing $ 25,000 Recommended Improvement Packages $ 50,000 Total $ 564,750 -6- Debt Service 20. Annual debt service reflects repayment to ($3,897,961): Final Call Amount Debt Series Source Purpose Payment Date $ 57,739 SRF 2007A Water Fees Clear Wells 2028 $ 115,698 Revenue 2008D Water Fees Water Improvements 2023 2019 $ 217,703 SRF Series 2009 Water Fees Meter Change-Out 2031 $ 387,250 Revenue 2010D Water Fees Water Improvements 2030 2019 $ 106,262 G.O. 2018A Water Fees Water Improvements 2031 2026 $ 43,884 G.O. 2012E Water Fees Water Improvements 2032 2019 $ 145,809 G.O. 2019C Water Fees Water Improvements 2033 2026 $ 747,231 G.O. 2014B Water Fees Water Improvements 2032 2021 $ 43,488 G.O. 2016C Water Fees Water Improvements 2033 2024 $ 673,920 SRF 2017 Water Fees CIWA Purchase/Imp 2036 $1,030,000 CIWA Contract Water Fees CIWA Purchase 2022 $ 269,380 SRF 2019 Water Fees Roosevelt Water Tower 2038 $ 59,597 SRF 2021 Water Fees Water Improvements 2041 $3,897,961 Total Water Annual Debt Service Revenue 21. Water User Fees increased from $8,761,909 in FY 2021 to $9,399,359 in FY 2022 based on FY 2020 actual of$8,407,944 plus the FY 2022 projected rate increase of 3%. 22. Flat Rates increased from $20,769 in FY 2021 to $27,242 in FY 2022. FY 2020 actual was $42,570. This charge is for customers purchasing bulk water. Rates are set by City ordinance. 23. Fire Protection Rates increased from $174,459 in FY 2021 to $181,778 in FY 2022 based on FY 2020 actual of$181,778. This fee is the demand charge for fire sprinkler head connection. The rates are set by City ordinance. 24. Taps increased from $26,591 in FY 2021 to $41,000 in FY 2022. FY 2020 actual was $12,289. 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. 25. Tap Service decreased from $35,121 in FY 2021 to $23,000 in FY 2022. FY 2020 actual was $7,454. 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. 26. Connection Charge Front Footage is increased from $55,000 in FY 2021 to $75,000 in FY 2022 based on a three-year average. FY 2020 actual was $77,137. 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. 27. Backflow Prevention Administrative Fees decreased from $76,025 in FY 2021 to $75,675 in FY 2022 based on actual number of accounts. FY 2020 actual was $73,771. This is the $25 annual fee charged to all customers with a backflow device. 28. Penalties for late payments decreased from $95,739 in FY 2021 to $63,840 in FY 2022 based on FY 2020 actual of$63,853. -7- 29. Tower Monthly Rental increased from $103,795 in FY 2021 to $127,732 in FY 2022 based on water lease contract amounts. FY 2020 actual was $123,553. 30. Sales Tax Collected decreased from $461,701 in FY 2021 to $454,532 in FY 2022 based on the rate increase for water fees. This line item off-sets the sales tax expense. -8- r•, � �- .� •- � . i�- . . , , . . , , = � . �• � I r � � � - - ..�. . � . � - . � • � • t M � � •�. ��• � . � � � . � -9- This page intentionally left blank. -10- WATER DEPARTMENT The Water Department ensures our community has high quality, safe, reliable and affordable drinking water. � � " • . • ■ � � _ ' � � • . . - . - SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES PLANNING The Water Department is engaged in PEDPLE conscientious, strategic planning which allows for maintaining compliance with the Employees of the Water state and federal regulatory agencies in Department are provided training order to provide the highest quality, safe to ensure the maintenance of the and cost effective drinking water possible. appropriate licenses required by the Iowa Department of Natural '� Resources. atherjob-related :�, �'� �,� _��.� ':�. �` educational training is provided � .�;:�-.';�;,� ,'�� . � to broaden employee skills and �f "��•-�_ �i:::�R�;�q�a increase producti�ity. ��';��•� �� :. ' ' f` " .,. �_�Yy �.�:._. � - . � PARTNERSHIPS The Water Department is inWol�ed in Community ActivitieslPartnershipsl Outreach programs such as Water Gonservation Educational Program and the Smarter City Initiative. The 1Nater De�artment provides tours of its Eagle Point Treatment Plant to local schools and organizations. -11- WATER DEPARTMENT FY 2020 FY 2021 FY 2022 Full-Time Equivalent 26.37 26.07 26.07 Resources Support $15,000,000 $12,160,508 $11,014,984 $10,553,217 $10,000,000 $5,000,000 $0 Operating Revenue � FY 2020 FY 2021 FY 2022 The Water Department is supported by 26.07 full-time equivalent employees, which accounts for 23.69% of the department expense as seen below. Overall, the department's expenses are expected to decrease by -6.63% in FY 2022 compared to FY 2021. Expenditures by Category by Fiscal Year $6,000,000 $4,000,000 $2,000,000 $0 � � � � c � Q C � o � � � � � c � � 0 � � c� o �• �, � � m v m O 0° � � � �. m m m � � < �� m Q � c� � �� c� x � � � � Q � m � �� m m v� � FY 2020 FY 2021 � FY 2022 -12- WATER DEPARTMENT Administration Mission & Services The City of Dubuque Water Department is dedicated to producing and delivering drinking water that is in compliance with all state and federal drinking water standards. We continually strive to adopt new and better methods of delivering the best quality drinking water to the citizens of Dubuque in the most cost-effective manner. Water Department Administration is responsible for the preparation of operating and capital budgets, interacting with the state and federal regulatory agencies, evaluation and coordination of treatment facility operations and the water distribution system functions. Water Administration Funding Summary FY 2020 Actual FY 2021 Budget FY 2022 Requested Expenditures $5,781,112 $4,767,476 $4,958,327 Resources $1,371,640 $— $— Water Administration Position Summary FY 2022 Water Department Manager 1.00 Confidential Account Clerk 1.00 GIS Specialist 1.00 GIS Intern 0.50 Total FT Equivalent Employees 3.50 Performance Measures City Council Goal: Financially Responsible, High-Performance Organization Performance Measure(KPI) Target FY 2019 FY 2020 FY 2021 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 15 35 35 � professional development in emergency _ response Reduction of Water Quality Issues per �20 22 21 22 � 100 miles of Pipe % of lost/unaccounted for water <18% 18.9% 16.5% 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.14 1.04 1.0 L Cost) # New Commercial connections/ 1/yr 3/yr 3/yr 3/yr � partnerships (per year) -13- WATER DEPARTMENT Plant Operations and Maintenance Overview \ Plant Operations and Maintenance ensures that water used ' for domestic, commercial and industrial purposes is high - quality and is supplied to meet the needs our community. We � are responsible for the management of equipment and treatment process of the City's drinking water in compliance � � : � with all federal and state water quality standards. �,,� . ' r Over 200 tests per day are performed by water treatment ' � ��, � - plant operators. In addition to these tests, the Dubuque . . r . 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 2020 Actual FY 2021 Budget FY 2022 Requested Expenditures $2,439,770 $2,496,634 $2,672,673 Resources $17,893 $— $— � .- . . • . . FY 2022 Electronic Technician 1.00 Equipment Mechanic 1.00 Plant Operator II 1.00 Plant Operator IV 4.00 Water Operations Supervisor 1.00 Total FT Equivalent Employees 9.00 Performance Measures Performance Measure(KPI) Target FY 2019 FY 2020 FY 2021 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 � Treated/MGD Produced) Cost Effectiveness of the Treatment <or- 1.0 0.94 1.07 1.03 C�� Process (O&M Cost/MG, thousands) - The 2019 Water Quality Report can be downloaded at: https://www.cityofdubuque.org/waterqualit� -14- WATER DEPARTMENT �#er Distribution Mission & Services The function of the Water Distribution Team is to safely transport potable water from the source to point of use. Distribution is also responsible for the machinery, equipment, materials and personnel required to repair main breaks; install water mains, control valves and fire hydrants and assist other sections of the Water Department. It is our goal to operate and maintain a water distribution system consistent with established procedures recognized by the American Water Works Association for efficient management practices and to meet Federal, State and local rules and regulations. � . . . . FY 2020 Actual FY 2021 Budget FY 2022 Requested Expenditures $2,138,457 $2,772,368 $2,020,699 Resources $10,635,404 $10,964,390 $10,530,750 � . . - . . FY 2022 Equipment Operator II 1.00 Water Distribution Maintenance Worker 6.00 Water Distribution Maintenance Worker 0.50 Water Distribution Foreman 1.00 Water Distribution Supervisor 1.00 Water Engineering Assistant 1.00 Custodian I 0.07 Total FT Equivalent Employees 10.57 Performance Measures Performance Measure(KPI) Target FY 2019 FY 2020 FY 2021 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 19 27 25 � Operation of 10% of system valves ��5 128* 314 775 C � annually Hydrant effectiveness (out of service rate) <1% <1% 0% <1% C � <1% or 25FH O&M costs for water per 100 miles of pipe �343** 311 348 352 � (thousands per 100 miles) "Insufficient data recorded during the reporting period. "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 distribution system is composed of 327.6 miles of water mains ranging in diameter from 4" up to 30"; 7,788 control valves; and 2,591 fire hydrants -15- WATER DEPARTMENT Water Meters & Backflow Prevention Mission & Services The Water Meter Team provides dependable meter operations and maintenance. The work performed includes installation, testing, cleaning, repairing and and reassembling meters as required. The Meter Team also addresses pressure issues, performs water use investigations and manages the Backflow Prevention Program. The work is conducted in compliance with local, state and federal requirements. Water Meters Funding Summary FY 2020 Actual FY 2021 Budget FY 2022 Requested Expenditures $520,764 $533,699 $372,755 Resources $129,635 $141,279 $112,658 Water Meters Position Summary FY 2022 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 2019 FY 2020 FY 2021 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 service issues <150 137 241 269** � per 1,000 accounts Enhanced meter reading accuracy, larger �� users: O&M on all large meters (>3") per 24/yr N/A 10/yr* 8/yr" AWWA standards (Ig meter/yr) *Numbers affected by COVID **Numbers to include partial year of 5 year MIU replacement 450 to 900 -16- Recommended Operating Revenue Budget - Department Total 42-WATER FY19 Actual FY20 Actual FY21 Adopted FY22 Recomm'd Fund Account Account Title Revenue Revenue Budget Budget 640 43110 INVESTMENT EARNINGS 82,505 104,079 74,254 75,000 43 USE OF MONEY AND PROPERTY-Total 82,505 104,079 74,254 75,000 640 45701 STATE GRANTS 327 0 0 0 � 45 STATE GRANTS -Total 327 0 0 0 640 51105 METER RATES 8,063,877 8,407,944 8,761,909 9,399,359 640 51107 LTNAPPLiED CREDITS 24,104 16,918 24,104 16,918 640 Sll08 WATER RATE CREDIT 0 0 (90,685) (96,126) 640 Sll 10 FLAT RATES 20,769 42,570 20,769 27,242 640 Sll 11 FLAT RATE KEY WEST 13,233 2,053 0 1,095 640 51115 FIRE PROTECTION RATES 174,459 181,778 174,459 181,778 640 51125 TAPS-3/4&1 INCH 26,591 12,289 26,591 41,000 640 51130 CONNECT CHG LARGE SERVICE 35,121 7,454 35,121 23,000 640 51135 CONNECT CHG FRONT FOOTAGE 144,708 77,137 55,000 75,000 640 51140 METER SALES-REMOTES 16,283 15,414 16,000 13,500 640 S ll45 SALE OF METERS 21,7ll 29,466 22,000 12,500 640 Sll46 SALE OF UFR DEVICES 9,506 3,860 9,500 3,860 640 Sll65 MAINTENANCE CHARGES 6,757 7,663 7,300 7,300 640 51170 REPAIR OF METERS 17,123 6,314 17,000 6,314 640 51175 SHUT OFF PENALTIES 19,368 15,423 18,660 15,423 640 51176 METER TAMPERING FEE 628 400 628 400 640 51177 CALL OUT CHARGE 750 771 750 771 640 51180 CROSS CON.CNTL ADMIN FEE 73,578 73,771 76,025 75,675 640 51215 LATE PAYMENT PENALTY 95,739 63,853 95,739 63,840 640 51310 PF,RMIT 141,804 123,553 103,795 127,732 51 CHARGES FOR SERVICES -Total 8,906,111 9,088,631 9,374,665 9,996,581 640 53201 REFUNDS 4,294 18,875 0 0 640 53605 MISCELLANEOUS REVENUE 75 75 0 0 640 53615 DAMAGECLAIMS 29,125 22,780 12,500 20,000 640 53620 REIMBURSEMENTS-GENERAL 16,878 6,055 364 5,935 640 53630 SALES TAX COLLECTION 418,776 428,804 461,701 454,532 53 MISCELLANEOUS -Total 469,148 476,589 474,565 480,467 640 54109 SALVAGF,SALES 1,606 741 1,500 1,169 640 54210 GO BOND PROCEEDS 13,3ll 1,311,083 0 0 640 54220 BOND DISCOUNT 603 59,384 0 0 640 54230 SRF GO BOND PROCEEDS 0 1,120,000 1,090,000 0 54 OTHER FINANCING SOURCES -Total 15,520 2,491,208 1,091,500 1,169 640 59100 FR GENERAL 0 0 90,685 96,126 59 TRANSFER IN AND INTERNAL -Total � 0 0 90,685 96,126 WATER -Total 9,473,611 12,160,508 11,105,669 70,649,343 -17- Recommended Operating Expenditure Budget - Department Total 42-WATER FY19 Actual FY20 Actual FY21 Adopted FY 22 Recomm'd Fund Account Account Title Expense Expense Budget Budget 640 61010 FULL-TIME EMPLOYEES 1,280,652 1,413,995 1,561,963 1,624,004 640 61020 PART-TIME EMPLOYEES 39,623 8,610 28,209 29,060 640 61030 SEASONAL EMPLOYEES 18,960 10,967 15,096 15,545 640 61050 OVERTIME PAY 108,641 111,927 94,040 94,040 640 61071 HOLIDAY PAY-OVERTIME 21,298 21,370 17,000 17,000 640 61072 TANK CLiMBiNG PAY 420 0 1,200 1,200 640 61083 COVIDI9 EMP NON-WORK 0 4,687 0 0 640 61091 SICK LEAVE PAYOFF 36,346 31,715 29,299 31,850 640 61092 VACATION PAYOFF 587 1,065 0 0 640 61095 PARENTAL LEAVE 0 6,910 0 0 640 61096 50%SICK LEAVE PAYOUT 0 766 2,097 766 640 61310 IPERS 137,603 148,962 162,136 176,416 640 61320 SOCIAL SECURITY 108,449 116,676 133,789 138,358 640 61410 HEALTH INSURANCE 357,750 280,934 319,696 332,316 640 61415 WORKMENS'COMPENSATION 87,466 74,335 69,748 52,387 640 61416 LIFE INSURANCE 928 1,029 1,430 1,430 640 61640 SAFETY EQUIPMENT 1,427 2,801 4,750 4,750 640 61650 MEAL ALLOWANCE 758 664 0 664 640 61660 EMPLOYEE PHYSICALS 1,802 1,474 1,804 1,475 61-WAGES AND BENEFITS 2,202,709 2,238,888 2,442,257 2,521,261 640 62010 OFFICE SUPPLIES 3,793 2,838 3,306 2,838 640 62011 LTNIFORM PURCHASES 19,828 27,718 17,152 20,182 640 62030 POSTAGE AND SHIPPING 2,022 2,012 2,721 2,052 640 62033 HAND TOOLS/EQUIPMENT 4,517 3,752 8,809 4,317 640 62034 REPAIR PARTS/SUPPLIES 7,954 5,610 5,363 6,989 640 62036 CONSTRUCTION SUPPLIES 4,774 670 4,093 1,113 640 62050 OFFICE EQUIPMENT MAINT 0 258 0 263 640 62061 DP EQUIP.MAINT CONTRACTS 20,268 20,560 19,858 21,054 640 62062 JANITORIAL SUPPLIES 3,942 4,382 4,953 4,469 640 62063 SAFETY RELATED SUPPLIES 3,199 7,445 3,111 4,311 640 62064 ELECTRICAL SUPPLIES 17,727 15,863 10,664 16,180 640 62065 LAB SUPPLIES 11,430 10,229 16,075 10,434 640 62066 PLUMBING MATERIALS 2,746 537 2,465 2,082 640 62090 PRINTING&BINDING 2,017 676 1,677 1,710 640 62110 COPYING/REPRODUCTION 2,568 1,679 4,023 2,204 640 62130 LEGAL NOTICES&ADS 1,953 4,104 1,362 1,180 640 62170 SUBSCRIPTIONS-BOOKS-MAPS 218 519 2,256 806 640 62190 DUES&MEMBERSHIPS 3,770 1,280 4,953 3,423 640 62204 REFLTNDS 5,786 74 5,911 5,786 640 62206 PROPERTY INSURANCE 56,713 66,465 59,548 72,702 640 62207 BOILER INSURANCE 0 120 0 0 640 62208 GENERAL LIABILITY INSURAN 19,377 20,585 20,346 22,575 640 62210 SALES TAX 410,251 426,658 461,701 454,532 640 62310 TRAVEL-CONFERENCES 83 10,582 6,000 3,680 640 62320 TRAVEL-CITY BUSINESS 0 337 1,135 700 640 62340 MILEAGE/LOCAL TRANSP 2,366 2,265 4,674 2,794 640 62360 EDUCATION&TRAINING 12,778 17,237 22,213 22,313 640 624ll UTILITY EXP-ELECTRICITY 668,403 733,932 678,511 770,628 640 62412 UTILITY EXP-GAS 36,825 37,210 37,467 37,210 640 62414 UTILITY EXP-FUEL OIL 0 13 1,500 1,500 -18- Recommended Operating Expenditure Budget - Department Total 42-WATER FY19 Actual FY20 Actual FY21 Adopted FY 22 Recomm'd Fund Account Account Title Expense Expense Budget Budget 640 62415 UTILITY EXPENSE STORMWATR 314 221 220 236 640 62421 TELEPHONE ll,421 12,657 12,480 11,232 640 62423 TELECOMMUNICATION CG 8,180 0 8,180 0 640 62424 RADIO/PAGER FEE 2,667 8,900 6,680 9,434 640 62431 PROPERTY MAINTENANCE 54,390 30,311 36,995 30,311 640 62433 CUSTODIAL SERVICES 0 0 0 700 640 62434 HVAC MAINTENANCE 5,688 2,900 0 2,900 640 62435 ELEVATOR MAINTENANCE 439 2,875 2,000 2,584 640 62436 RENTAL OF SPACE 2,119 220 1,819 1,850 640 62437 BARRICADE RENTAL 9,034 3,790 8,927 7,250 640 62438 FIRE SUPPRESSION 1,020 982 0 982 640 62511 FUEL,MOTOR VEHICLE 33,593 24,049 19,700 19,700 640 62521 MOTOR VEHICLE MAINT. 32,596 32,288 31,381 34,133 640 62522 VEHICLE MAINT.,ACCIDENT 182 1,713 0 0 640 62528 MOTOR VEH.MAINT.OUTSOUR 856 8,624 726 948 640 626ll MACH/EQUIP MAINTENANCE 87,994 83,994 83,952 83,994 640 62613 METER MAINTENANCE 6,891 10,340 10,000 10,340 640 62614 EQUIP MAINT CONTRACT 306 307 0 307 640 62615 MACH/EQUIP MAINT.OUTSOUR (93) 1,444 1,450 2,044 640 62628 INSTRUMENTATION MAINT 12,544 10,467 0 10,467 640 62630 FLUORIDE 9,736 9,836 9,500 9,836 640 62631 LiME 266,839 270,596 310,503 319,000 640 62632 PHOSPHATE 61,893 60,862 65,000 65,000 640 62633 CHLORINE 34,661 30,744 37,480 30,744 640 62638 POLYMER 5,984 5,732 8,180 6,840 640 62639 LIQUID CO2/02 19,079 20,679 17,325 20,679 640 62663 SOFTWARE LICENSE EXP 1,647 34,563 64,701 61,128 640 62664 LICENSE/PERMITFEES 7,151 7,126 7,159 6,820 640 62667 DATA SERVICES 2,502 2,775 120 2,775 640 62669 PROGRAMMiNG 5,219 4,881 0 0 640 62675 VALVES 64,236 29,955 44,192 49,955 640 62676 PIPE-SPECIAL FITTINGS 89,509 50,290 79,332 50,290 640 62692 LANDFILL FEES 990 303 70 323 640 62696 OUTSIDE COLLECTOR EXPENSE 3,192 4,230 3,192 4,047 640 62713 LEGAL SERVICES 891 5,196 0 0 640 62716 CONSULTANT SERVICES 47,769 38,146 62,464 29,000 640 62726 AUDIT SERVICES 3,200 3,500 3,200 0 640 62731 MISCELLANEOUS SERVICES 26,291 8,234 47,932 40,000 640 62732 TEMP HELPCONTRACT SERV. 13,531 1,316 0 0 640 62746 ONE CALL OPERATION 5,807 7,226 5,358 7,226 640 62765 GRANTS 2,868 5,365 15,000 15,000 640 62767 ENVIRON.TESTING/MON. 39,892 33,191 41,604 35,600 640 62780 HAULING SERVICES 151,610 174,196 157,815 165,000 62-SUPPLIES AND SERVICES 2,459,947 2,470,634 2,616,484 2,648,702 640 62724 BOND PAYING AGENT FEE 0 625 0 625 627-CONTRACTUAL SERVICES 0 625 0 625 640 7ll20 PERIPHERALS,COMPUTER 3,079 179 0 0 640 7ll23 SOFTWARE 24,239 0 45,000 0 640 71124 COMPUTER 125 0 950 0 640 71225 SHELVING 144 0 0 0 -19- Recommended Operating Expenditure Budget - Department Total 42-WATER FY19 Actual FY20 Actual FY21 Adopted FY 22 Recomm'd Fund Account Account Title Expense Expense Budget Budget 640 71312 VAN/PICKUP/WAG REPL 81,369 36,860 0 0 640 71314 TRUCK-REPLACEMENT 0 90,289 290,000 0 640 71318 HEAVY EQUIP-REPLACEMENT 0 0 220,000 0 640 71329 VEHICLE ACCESSORIES 19,012 0 0 0 640 71410 SHOP EQUIPMENT 1,464 1,730 0 250 640 71413 LABORATORY EQUIPMENT 366 1,837 5,800 5,800 640 71415 SAWS 0 2,500 4,200 4,200 640 71419 TAPPING MACHINE 8,550 0 0 0 640 71510 HYDRANTS 32,054 10,460 31,500 15,000 640 71511 PUMPS 828 0 15,000 18,000 640 71515 WATER METER PRODUCT 0 0 176,661 0 640 71516 LARGEWATERMETERS 100,705 64,172 102,000 55,000 640 71520 HVAC 878 0 0 0 640 71550 MISCELLANEOUS EQUiPMENT 45,525 1,290 30,000 0 640 71619 OTHER MAINT.EQUIPMENT 0 0 0 50,000 640 72111 GAS SAFETY MONITOR 1,853 0 950 0 640 72410 PAGER/RADIO EQUIPMENT 414 46,555 0 0 640 72415 ELECTRONIC DATA COLLECTOR 6,095 0 0 0 640 72418 TELEPHONE RELATED 269 117 2,450 3,500 71-EQUIPMENT 326,969 255,989 924,511 151,750 640 73211 CONST.CONTR-NOT BLDG 586,373 308,852 415,000 395,000 640 73410 EQUiP ACQUISiTION 0 17,461 0 18,000 73-CIP EXPENDITURES 586,373 326,313 415,000 413,000 640 74111 PRINCIPALPAYMENT 2,192,687 4,131,164 2,967,689 3,040,574 640 74112 1NTEREST PAYMENT 867,092 839,235 893,703 857,387 74-DEBT SERVICE 3,059,778 4,970,399 3,861,392 3,897,961 640 91100 TO GENERAL 548,056 597,380 567,194 578,155 640 91740 TO WATER CONSTRUCTION 935,000 400,000 550,000 400,000 91-TRANSFER TO 1,483,056 997,380 1,ll7,194 978,155 42-WATER TOTAL 10,118,832 11,260,227 11,376,838 10,611,454 -2�- Recommended Expenditure Budget Report by Activity & Funding Source 42-WATER UNDISTRIBUTED -10640 FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget SUPPLIES AND SERVICES 3,965 9,888 9,833 TRANSFER TO 997,380 1,ll7,194 978,155 UNDISTRIBUTED 1,001,345 1,127,082 987,988 WATER ADMINSTRATION -42100 FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adoptcd Budget FY22 Recomm'd Budget CONTRACTUAL SERVICES 625 - 625 DEBT SERVICE 4,970,399 3,861,392 3,897,961 EQUIPMENT - 45,350 1,050 SUPPLIES AND SERVICES 508,565 532,554 478,381 WAGES AND BENEFiTS 301,524 328,180 580,310 WATER ADMINSTRATION 5,781,ll2 4,767,476 4,958,327 METERS -42300 FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget EQUIPMENT 26,817 ll 7,350 0 SUPPLIES AND SERVICES 62,351 67,174 92,416 WAGES AND BENEFITS 431,596 349,175 280,339 METERS 520,764 533,699 372,755 PLANT OPER.&MAINT -42400 FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget EQUIPMENT 38,836 47,450 56,500 SUPPLIES AND SERVICES 1,626,980 1,589,814 1,707,367 WAGES AND BENEFITS 773,954 859,370 908,806 PLANT OPER.&MAINT 2,439,770 2,496,634 2,672,673 WATER DISTR. SYSTEM -42700 FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget CIP EXPENDITURES 1,920 0 EQUIPMENT 139,971 447,700 24,200 SUPPLIES AND SERVICES 263,408 292,054 256,705 WAGF,S AND BFNF,FITS 731,813 905,532 751,806 WATER DISTR.SYSTEM 1,137,ll2 1,645,286 1,032,7ll AUTO MTR RD SYS MNT PROG-42710 -21- Recommended Expenditure Budget Report by Activity & Funding Source 42-WATER FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget CIP EXPENDITURES 0 AUTO MTR RD SYS MNT PROG 0 PUMP REPLC VACUUM FILTER-42713 FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 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 FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget SUPPLiES AND SERViCES 1,000 5,000 FIRE HYDRANT PAINTING 1,000 5,000 GENERATOR MAIN PROGRAM -42725 FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget CIP 6XPENDITURF.S 17,461 18,000 GENERATOR MAIN PROGRAM 17,461 — 18,000 GIS MAINT/UPDATES -42730 FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget SUPPLIES AND SERVICES 25,000 0 GIS MAINT/UPDATES — 25,000 0 SERVICE LINE ASSIST -42735 FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adoptcd Budget FY22 Recomm'd Budget SUPPLIES AND SERVICES 35,000 35,000 SERVICE LINE ASSIST — 35,000 35,000 VALVE REPLACEMENT -42745 FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget CIP EXPENDITURES 1,992 20,000 0 SUPPLIES AND SERVICES — 20,000 20,000 -22- Recommended Expenditure Budget Report by Activity & Funding Source 42-WATER VALVE REPLACEMENT 1,992 40,000 20,000 WATER MAIN REPLACEMENTS -42755 FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget CIP EXPENDITURES 273,410 350,000 350,000 WATER MAIN REPLACEMENTS 273,410 350,000 350,000 WATER METER EXCHANGE -42760 FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget EQUIPMENT 50,365 251,661 55,000 WATER METER EXCHANGE 50,365 251,661 55,000 WATER LEAK REPAIR GRANT -42765 FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget SUPPLI�S AND SERVICES 3,397 5,000 5,000 WATER LEAK REPAIR GRANT 3,397 5,000 5,000 COUNTY WATER ASSISTANCE -42766 FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget SUPPLiES AND SF.RViCES 1,969 10,000 10,000 COUNTY WATER ASSISTANCE 1,969 10,000 10,000 WATER VALVE BOX MAINT -42770 FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget CIP EXPENDITURES 17,672 20,000 20,000 WATER VALVE BOX MAINT 17,672 20,000 20,000 COMPUTERIZED LEAK SURVEY-42785 FUNDING SOURCE:WATER UTILITY OPERATION Account FY20 Actual Expense FY21 Adoptcd Budget FY22 Recomm'd Budget SUPPLIES AND SERVICES 29,000 29,000 COMPUTERIZED LEAK SURVEY - 29,000 29,000 WATER METER TESTING -42790 FUNDING SOURCE:WATER UTILITY OPERATION -23- Recommended Expenditure Budget Report by Activity & Funding Source 42-WATER Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget CIP EXPENDITURES 13,859 25,000 25,000 WATER METER TESTING $ 13,859.00 $ 25,000.00 25,000 WATER TOTAL $11,260,227 $ll,376,838 $10,611,454 -24- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 42 WATER DEPARTMENT FY 2020 FY 2021 FY 2022 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 $ 109,298 1.00 $ 110,505 1.00 $ 112,150 640 3200 GE-37 WATER DISTRIBUTION SUPERVISOR 1.00 $ 90,025 1.00 $ 91,659 1.00 $ 93,267 640 2950 GE-33 WATER ENGINEERINGASSISTANT 1.00 $ 74,429 1.00 $ 75,252 1.00 $ 77,143 640 2650 GE-31 FOREMAN -WATER DISTR. 1.00 $ 67,509 1.00 $ 68,265 1.00 $ 69,277 640 2610 GE-30 GIS SPECIALIST 1.00 $ 64,050 1.00 $ 64,679 1.00 $ 66,299 640 GE-25 CONFIDENTIALACCOUNT CLERK 1.00 $ 39,153 1.00 $ 49,429 1.00 $ 50,255 640 NA-49 WATER METER INSPECTOR - $ - - $ - - $ - 640 2400 0E-16 ELECTRONIC TECHNICIAN 1.00 $ 64,610 1.00 $ 65,319 1.00 $ 66,645 640 2800 0E-14 EQUIPMENT MECHANIC 1.00 $ 61,862 1.00 $ 62,691 1.00 $ 63,616 640 2550 0E-13 WATER PLANT OPR CERT GR III/IV - $ - - $ - 1.00 $ 60,812 640 2475 0E-12 WATER PLANT OPERATOR CRT GR II 1.00 $ 57,751 1.00 $ 58,395 1.00 $ 59,260 640 2475 0E-12 WATER PLANT OPERATOR CRT GR IV 6.00 $ 380,552 6.00 $ 384,585 4.00 $ 261,999 640 2305 0E-10 EQUIPMENT OPERATOR II 2.00 $ 110,767 2.00 $ 116,147 1.00 $ 58,074 640 1775 0E-09 WATER METER REPAIRWORKER I 3.00 $ 163,136 2.00 $ 110,462 2.00 $ 113,210 640 0E-14 WATER METER REPAIRWORKER II - $ - 1.00 $ 61,474 1.00 $ 62,381 WATER DISTR MAINTENANCE 640 1476 0E-09 WORKER 5.00 $ 256,303 5.00 $ 266,434 6.00 $ 322,400 TOTAL FULL TIME EMPLOYEES 25.00 $ 1,539,445 25.00 $ 1,585,296 25.00 $ 1,609,158 61020 Part-Time Employee Expense 640 225 GE-25 SECRETARY - $ - - $ - - $ - 640 1476 0E-09 WORKER - $ - 0.50 $ 25,233 0.50 $ 25,599 640 0E-07 WATER METER SERVICE WORKER I 0.80 $ 42,954 - $ - - $ - 640 2050 0E-06 CUSTODIAN I 0.07 $ 3,364 0.07 $ 3,401 0.07 $ 3,461 TOTAL PART TIME EMPLOYEES 0.87 $ 46,318 0.57 $ 28,634 0.57 $ 29,060 61030 Seasonal Employee Expense 640 NA-34 GIS INTERN 0.50 $ 15,154 0.50 $ 15,326 0.50 $ 15,545 TOTAL SEASONAL EMPLOYEES 0.50 $ 15,154 0.50 $ 15,326 0.50 $ 15,545 TOTAL WATER DEPARTMENT 26.37 $ 1,600,917 26.07 $ 1,629,256 26.07 $ 1,653,763 -25- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2020 FY 2021 FY 2022 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,050 1.00 $ 64,679 1.00 $ 66,299 64042100 61010 640 3275 GE-40 WATER DEPARTMENT MANAGER 1.00 $ 109,298 1.00 $ 110,505 1.00 $ 112,150 64042100 61010 640 GE-25 CONFIDENTIALACCOUNTCLERK 1.00 $ 39,153 1.00 $ 49,429 1.00 $ 50,255 64042700 61010 640 2950 GE-33 WATER ENGINEERING ASSISTANT 1.00 $ 74,429 1.00 $ 75,252 1.00 $ 77,143 WATER DISTRIBUTION 64042700 61010 640 3200 GE-37 SUPERVISOR 1.00 $ 90,025 1.00 $ 91,659 1.00 $ 93,267 Total 5.00 $ 376,955 5.00 $ 391,524 5.00 $ 399,114 Water Administration-SEASONAL 64042100 61030 640 NA-34 GIS INTERN 0.50 $ 15,154 0.50 $ 15,326 0.50 $ 15,545 Total 0.50 $ 15,154 0.50 $ 15,326 0.50 $ 15,545 Water Meters-FT 64042300 61010 640 1775 0E-09 WATER METER REPAIRWORKER I 3.00 $ 163,136 2.00 $ 110,462 2.00 $ 113,210 64042300 61010 640 0E-14 WATER METER REPAIRWORKER II - $ - 1.00 $ 61,474 1.00 $ 62,381 WATER DISTR MAINTENANCE 64042300 61010 640 WORKER 1.00 $ 52,691 1.00 $ 54,178 - 64042300 61010 640 NA-49 WATER METER INSPECTOR - $ - - $ - - Total 4.00 $ 215,827 4.00 $ 226,114 3.00 $ 175,591 Water Meters-PT WATER METER SERVICE 64042300 61020 640 1775 0E-07 WORKER I 0.80 $ 42,954 - $ - - Total 0.80 $ 42,954 - $ - - $ - Water Plant Operation-FT WATER PLANT OPERATOR CRT 64042400 61010 640 2475 0E-12 GRII 1.00 $ 57,751 1.00 $ 58,395 1.00 $ 59,260 64042400 61010 640 2550 0E-13 WATER PLANT OPR CERT GR III/IV - $ - - $ - 1.00 $ 60,812 WATER PLANT OPERATOR CRT 64042400 61010 640 0E-13 GRIV 6.00 $ 380,552 6.00 $ 384,585 4.00 $ 261,999 64042400 61010 640 2800 0E-16 ELECTRONIC TECHNICIAN 1.00 $ 64,610 1.00 $ 65,319 1.00 $ 66,645 64042400 61010 640 3015 0E-14 EQUIPMENT MECHANIC 1.00 $ 61,862 1.00 $ 62,691 1.00 $ 63,616 Total 9.00 $ 564,775 9.00 $ 570,990 9.00 $ 584,702 Water Distribution-FT WATER DISTR MAINTENANCE 64042700 61010 640 1476 0E-09 WORKER 4.00 $ 203,612 4.00 $ 212,256 6.00 $ 322,400 64042700 61010 640 2305 0E-10 EQUIPMENT OPERATOR II 2.00 $ 110,767 2.00 $ 116,147 1.00 $ 58,074 64042700 61010 640 2650 GE-31 FOREMAN-WATER DISTR. 1.00 $ 67,509 1.00 $ 68,265 1.00 $ 69,277 Total 7.00 $ 381,888 7.00 $ 396,668 8.00 $ 449,751 Water Distribution-PT WATER DISTR MAINTENANCE 64042700 61020 640 1476 0E-09 WORKER - $ - 0.50 $ 25,233 0.50 $ 25,599 64042700 61020 640 2050 GD-03 CUSTODIAN I 0.07 $ 3,364 0.07 $ 3,401 0.07 $ 3,461 Total 0.07 $ 3,364 0.57 $ 28,634 0.57 $ 29,060 TOTAL WATER DEPARTMENT 26.37 $ 1,600,917 26.07 $1,629,256 26.07 $ 1,653,763 -26- Capital Improvement Projects by Department/Division WATER FY 19 Actual FY 20 Actual FY 21 Adopted FY 22 Recomm'd CIP Number Capital Improvement Project Title Expense Expense Budget Budget 7401339 SCADA SYSTEM UPGRADE 38,746 495,000 250,000 7401405 WATER MAIN REPLACEMENTS 161,707 260,651 271,375 - 7401415 SHALLOW WELL REHAB 250,000 120,000 7401672 ROOSEVELT RD MAIN EXT. 297,740 2,450,571 7402030 VACUUM FILTER BACK-UP 4,916 7402044 GREEN ALLEY PILOT PROJECT 108,000 7402052 WATER METER REPL PROGRAM 7,080 3,223 176,661 461,015 7402234 SOUTHGATE WATER 7402395 WATER EXT-AIRPORT (1) 7402524 ONLINE PROCESS ANALYZER 42,577 - 7402525 N CASCADE WATER MAIN 41,537 2,283 7402527 GENERATOR 5,612 79,214 7402594 SW ARTERIAL MAIN EXT 3,548 94,322 7402595 CREEK CROSSING RESTORE 35,000 7402596 MAIN RELOC SEWER MANHOLE 1,734 25,000 7402654 FIRE HYDRNT ASSMBLY SW PG 20,000 7402655 MAINT WTR MN-RETAIN WAL 20,000 7402656 WATER STORAGE TANK COATIN - - 25,000 25,000 7402657 WTR MN UPGRADES-STREET 20,000 7402658 WTR MN REPLACE-SWR CONS 206,045 10,468 7402703 WEST RURAL WATER PURCHASE 370,918 191,082 65,000 7402704 TIMBER RiDGE WATER MAIN 44,252 7402705 GRANDVIEW/LORAS INTER IMP 7402713 RPR/MAINT WATER LINE ISLA 3,495 5,042 7402734 RURAL WATER ENGLISH PUMP 102,752 7402744 PUBLIC LEAD LINE WATER RE - - 122,470 - 7402745 TAMARAK FRONTAGE WATER MN 478,287 35,242 362,500 - 7402746 COTTINGHAM RD WATER MAIN 35,206 620 187,813 - 7402748 EPWP TRANSFORMER SAFETY 22,230 11,890 7402786 DAVENPORT RD EXT/PMP STAT 1,465 7402821 LANDFILL WATER MAIN EXT 121,500 7402836 MAIN EXT TO NEW DEV 307,500 775,000 7402837 WATER PLANT ASSESS PLAN 115,000 20,000 7402838 ALTHAUSER&EAGLE WTR MN - - 151,065 - 7402839 WATER PLANT IMPROVEMENTS - - 20,000 - 7402894 WTP&PUMP STATION REHAB 20,000 7402895 MCFADDEN WATER MAIN IMP 385,000 7402896 SUPER 20 WATER CONNECTION 142,000 7402897 BURLINGTON WATER MAIN 350,000 7402898 CIWA SYSTEM AGREEMENTS 125,000 7402899 OLYMPMIC HTS AUTO FLUSHER 37,075 7402902 E 16TH HYDRANT RELOCATION 24,000 7402933 E 16TH WATER MAIN REPLACE 71,500 7402934 WTP ROOF REPAIR 200,000 WATER TOTAL 1,824,719 3,189,735 2,745,884 3,158,590 -2�- PRGRM/ DEPT PROJECT DESCRIPTION FY 2022 FY 2023 FY 2024 FY 2025 FY 2026 TOTAL PAGE WATER DEPARTMENT Business Type Water Meter Replacement Program $ 461,015 $ 529,018 $ 567,500 $ 567,500 $ 567,500 $ 2,692,533 105 Manhole Replacement Rehab $ 25,000 $ - $ 25,000 $ - $ 25,000 $ 75,000 106 Water Main Upgrades during Street General Repairs $ 20,000 $ - $ 25,000 $ - $ 25,000 $ 70,000 107 Maintenance of Public Water Mains during Stone Retaining Wall Repair $ - $ 22,550 $ - $ 22,550 $ - $ 45,100 108 Fire Hydrant Assembly Relocation/Replacement for the Sidewalk Program $ - $ 20,000 $ - $ 20,400 $ - $ 40,400 109 Water Main Replacement Consent $ - $ 105,000 $ 132,000 $ - $ 99,000 $ 336,000 110 Southwest Arterial Water Main Extension $ - $ 936,250 $ - $ - $ - $ 936,250 112 HWY 20/Dodge St Water Main Relocation $ - $ - $ - $ - $ 996,000 $ 996,000 114 Public Lead Line Water Replacement $ - $ 84,500 $ 85,000 $ - $ - $ 169,500 115 Water Line Extensions to New Developments $ 775,000 $ - $ - $ - $ - $ 775,000 116 Wells,Well Field, and Raw Transmission Piping Repair $ 120,000 $ 90,000 $ 180,000 $ 110,500 $ - $ 500,500 117 Water Treatment Plant Condition Assessment and Master Plan $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 100,000 119 Water Storage Tank Coating Program $ 25,000 $ 150,000 $1,350,000 $ 100,000 $ 900,000 $ 2,525,000 120 Creek Crossing Restoration $ - $ - $ 35,550 $ 35,080 $ 48,400 $ 119,030 121 Althauser St. &Eagle St.Water Main Improvements $ - $ 145,000 $ - $ - $ - $ 145,000 122 WTP and Pump Station Pipe Rehabilitation $ 20,000 $ 200,000 $ - $ - $ - $ 220,000 123 Pump Station Site Drainage Improvements $ - $ 15,000 $ - $ - $ - $ 15,000 124 McFadden Farm Water Main Improvement(S. Heacock Rd from Chavenelle to Pennsylvania) $ 385,000 $ - $ - $ 270,000 $ - $ 655,000 125 SCADA&Comms Improvements $ 250,000 $ 150,000 $ - $ 450,000 $ - $ 850,000 126 Super 20 Mobile Home Park Water Connection to City Water $ 142,000 $- $- $- $- $ 142,000 128 Green Alley Water Main and Fittings Replacement $ 108,000 $- $- $- $- $ 108,000 129 Burlington Street Water Main Replacement $ 350,000 $- $- $- $- $ 350,000 130 CIWA Water System Agreements for Water Service Line Installations $ 125,000 $9,000 $25,000 $65,000 $- $ 224,000 131 Third Pressure Zone Connection (from Tanzanite Drive to Davenport St.) $ - $- $1,110,250 $938,750 $- $ 2,049,000 132 Olympic Heights(Pressure Zone 5)Auto Flusher and CL2 Analyzer $ 37,075 $- $- $- $- $ 37,075 133 WTP Roof Repair $ 200,000 $- $- $- $- $ 200,000 134 Water and Sewer Rate Analysis $ - $100,000 $- $- $- $ 100,000 135 -28- PRGRM/ DEPT PROJECT DESCRIPTION FY 2022 FY 2023 FY 2024 FY 2025 FY 2026 TOTAL PAGE WATER DEPARTMENT Business Type E. 16th St Water Main Replacement(White St. to Alley Between White and Jackson St) $ 71,500 $ — $ — $ — $ — $ 71,500 136 E.16 Street(White St. and Alley East of White St.) Hydrant Relocation Project $ 24,000 $ — $— $— $— $ 24,000 137 Generators-Park Hill& Mt. Carmel $ — $— $90,000 $— $125,000 $ 215,000 138 TOTAL $ 3,158,590 $2,576,318 $3,645,300 $2,599,780 $2,805,900 $ 14,785,888 -29- � wy��r`-.� • .�•� ' � .�� - - -��c: ' �� , — ' . . i -�� . � � ,' ;,�I�I t�� e '� . , � � +�� , F . '� �;j' � � � • 4 r�.l I ' � � � ' '�� , ' � , �� 1�w1�1�■11� � '. `�.� � f � . . . � 3��i!�� . � • .�- � �i�� . -_ �� -. � -- �. ��JiA. ,' ` � �� 'f�� - -. ^.y .F � �i �'- • '_- �$ +� � ,i y �." �� +� vJi•��T.r a � " �* �•�' � M1�. } � •�rS,+ -�+ � t ,�* ' rt�. . � Y�`j+ •�{ M �'� �r . r �� ,�}�'�� -o- �' ¢ �� , � '•,j�'�'��:,• . �, � {� �� "�� ,��,�"�,}�{�� • . ,� i'� � { ��ti ti � � �. r M�� • +`} � - �'� •~ � �� :, �"�! l� � � � � R��.." � � � � � � � �� r y'�i�' � . � � -� �� 7ti � 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 & Retirements of FY2021 ! � �� ', �4 Y , , � "i i ` � 'R � � � - � r ��. � �� - . - . �_ ��,��q .. - � A�� !� Welcome! f Y.� �� `� - Welcome! � � � � �. � ;. � ,� � ' �"` ._.� ;, � �__ �� ,,, �, —� - � ,,� _ � r ` --- - _ � �' �- . �_ . , � _� — '�. �, ��..�� '°�`�. ��,rl�-� � � _ � .r � �1 4� � � � � ,�,. l�y �� =� ' ,�,:��. ,. �i ,'1 +��` , o., � ' ,��,.�� ° ' � :�I �x�." 5�Y}�,. �,_a- _ • :jI � ' /�`'� . ... . � ,�� . . -� . __:..:: . �.:�. Rick Grothe , � - r� Steve Horch = Industrial Maintenance � Water Treatment Plant � � � ��;n, .��;�:.�, - Mechanic - Ret. Jan 2021 � � Operator - Ret Jan. 2021 � , ,� ,�,��, � ��, �„� ;.�� .� Mike Patzner Chad Sharkey Industrial Maintenance Water Treatment Plant Mechanic Operator Water Department (26.07 Full -Time Equivalents) w�t�� o��,��,t Manager �1.� FTE) Canfidential Accaunt Clerk i {1.�FTE) Water ❑istributian Water Engineering �I��pecialist Water Plant Operatars � Equipment Mechanic Electronic Technician 5upervisar Assistant � � {1.�FrE� {1.�FrE� �1.oFrE� ��.oFrF� {1.oFrE� {1.��rF} � � . . INater Distribution h'leter Repair Worker � Foreman II �IS Seasanal Interns (1.� �rE� {1.� �r�� o.� �rF� Equipment Operatar II �Meter Repair� (1.4 FTE� �2 FTE) Water Distribution Maintenance 1Norl�er �6.5 FTE} Water Department FY22 Proposed (26.07 Full -Time Equivalents) l�vater oepartrrrent Manager �1.4 FTE) Confidential Account � �lerk �1.�FT�E� i — V�ater Distribution INater Engineering � UUater Operations � 5upervisor Assistant GI�Specialist Supervisor � �1.�Fr�} �1.�FrE� �1.�FrE} �1.�FrE� � i . . 1Nater Distribution ��ter Repair 1Nor4aer II I � GI5 Seasanal Interns Water Plant Operatars Foreman I I �1.0 FTE� � � {1.�FTE� I . {�.5 FTE� {6.a FTE� � Industrial Electrical Equipment Operator II i Meter Repair 1fUorker I Technician {�.��rE� �z �rF} {�.a�rE� � 1►�`ater Distribution Industrial Maintenance M�intenance 4�Uorker Mechanic (6.5 FTE) (1.a FTE) "�_i. aa ro � 4%.: � � . Y� j ��..+� \`I j . � i .�t�i a.. . �� r—��`�y #"r'I�ff ,',.�'��r�� .�" � .`I � _.w wz�` "� ,,,4`��y- �. * ! F �scal Year 2021 �� _ �-� �� , � �� , � _ : , t � . E _ _ _ � . � __� � . _�: � � A S ec � al Than k You . �, , � �,� .:; ;�, ; _ � �.� , .- p � � � �._ � _ � � ■ � '� r��_ ` '�„ ��F .��i_ I ,- ��. z�� - ��... - __�_��., _ __ _ � - __ '�Yu �I - �19A;� � \ ..._r .�s5r� 5 4I l __ �. � _ b .�. .. A � , . �� _1i ,_ - 7� ' "'�/1 j e 1 ;�+ll�,�•-��r T.�- ^r ^f� 1 �' . � t-a �'1► _ _ ___ , �� , ,�- � �f ,� � r_ , �� _ � + ___ - � � , r __ - � ;I � . � 1 � , , . �+ �� - .. :=p -..�,.; � , __ _ _ � �,�- , �� . ; � � � � . - - . �:'. � �� ..�,�..1 �, � � . _ �— - �—— � .^� � �,�' �' � _ �� J); � � � '`� _ �"i�Ml., e � � . , '`� 1 �f�r ✓s— �/ `-��i--�� `�e '�"�; :��,'��„��, � I � �� ` _ �� ""�Y � :;: ,s�. � ��%ir./ii��__ . `„�' Z� �^- � _ _ � i v , ` � , - �'� '� �1�:��1 � ■ �` � Outstanding COVID- 19 ,� � � � _ � -� � __-___-- .��___._�.,-�-� - � - g � Response! � _ �� _ __ �. __ _ _ _ . � . k - - - �. -=- - - . : -_ � , � . , r ��„�.,.� �`, _ �,- , _ r � r �� ; �� ..,, _ -}- . � - =_ • Re s u I t: � � - � � - �� __ � � ��„F�� __ - - � ::_.:.: - �. � �� Lf " `�.�L �i! ��: �� =_ � � Zero da s lost �� - !1 ! �� _ y � � ,� � �_ � .� � . , � .. _ � � N o I nte rru pted ' � �� 1 � �'�� - - i _ — . � c • � . : Service _ - - ,- ; �� - �- � � - ��t ;.� _.- . t� _ � ��` ��.,�.� � �e*�.'s ��i:+�.. � * - ■�, —--- �,�`�- ��! � , - rr -- � n. � -' -- - F 'f�, _ . FISCAL YEAR 2021 _ _-�� - - -- �--- :_ _ _�_ . .. ___._ _ L . '.4 HIGHLIGHTS �� r � ■ • Roosevelt Street Elevated Water Tower - -- Completed _ �� Tower Overall Height: 120 feet � - Ca acit . 1 .25 million allons :�� `� ��-` . i4�#��} ° p Y' J � �� :,-:-f-��; ��-�'` '}'d � � �� . '{.��- _ ��' �.i�7rt��:.,_;: ' ' � Increase in Zone 2 Pressure: 15psi at low water level . � Tower Contractor: MCDERMOTT INT CB&I $2 928 600 � �-- ' � ) � , i � � Infrastructure Contactor: Portzen Construction $986,620 , � � . �; .�::-; :{�.�t� _., :�"- ,�r„��- ;� r;-,i;-�;,t,�k . .�,r�:-�i, • , : � h �`� ' .�E-��.�''��'� � Total Project Cost Est: $5,227,672 (SRF & Local Funds) -�-�� -=��-�� . - . ��.�.�-� -� , -, _ ; � �,��;-. _�.� � . a � �---� � 1-�� Actual Current Ex enditure 4 614 628 - - �- - � �� h_�- �: --.�-- p � � , ; . ,�_.� __ -_. ,�t}.�..� �s � � Online: December 2020 - On Schedule and Bud et �� N� ! F � �� .;� 9 .- . . ; , _ .�� . - . -- � + �,.=� ' � 1 Drone photo of Roosevelt Water Tower Courtesy of Troy Kress, City Engineering ' � �� . `'r� � -� 4 .� FISCAL YEAR 2021 HIGHLIGHTS pUY Bt�� North Cascade Road � SpecialAchievementinGlS 2018 Award Winner M��k,,,;��„�,,�,M;�s,=�,,,�,; WaterMain Extension CIP 740-2525 Y C , „ � � .. � . ��.y. '_ q. . ' � 1!.�:{ k.t�'�O ✓ Jy�. L@ @I1C� �'�•T� �' � �� '�� "` � � �� '� "�� Connect to "�''� s';�_ g . �' z ��„ f � ;. ��' � Existing Water Main :� � �l. y �`"L l �f� /d'/ �� d✓ X`M', T - ; . t�ii. y�j � �.�5�T i i . . Water Main �. �� ,f�� , , .;_ dd �i"` � N . Cascade Road Water Ma�n ` r � �� ° . �-� � StatUS a �f � �i ,� ;!. p (R�� rt�k�t ��„� , �'" � x, � '� � �l, � ( �. .�� '�� Installation N . Cascade Road �� ' � „� �� 4�� ` `� �� j � _ . � y � , Abandoned j r� �� .�f�,,,�� 5a�. F�� i ! ,y '$ �r ,� /1' a �� o AI Shut Off �`�� 1�i� � y, a�F a r�' �a"; ,�r' y' � ,� fi��;.:,p �� Realianment Pro'ect) � � "� � �� ' � ��` �� `�� V � / Removed �r� ��' �« � .� .> a�;.. s i � � ' '�_ '�' � �� South Fork `� �� Unknown �` �r r�,y., ,� 1��1 * � � ,", �, � �� ` Catfish Creek � � �„' �■ Proposed �`.,� `�a ,+trE., `� ;�� ,,��`�� - �� '' >.� �� i � .�� ,�.�� - �'. � � � �r> �:n � �� .��` �/�L t� ` �,r �� ° 1[VaterMainCasing � Coordination with City Engineering �� ; , J �p,� � ,. � , ,/ � - � ` "`; � c: : .= >x �d r r xr / � ':� �� F'�. . .�L. ,�� ,+" �: � � � r ��d �; �'"". and lowa Department of � � ��_ j�,�� , , �� A� � �`. ., w x ��w.5 �`� � ��y ':-.�� I � � ss. '�l�: `" �- , . y f ;.. � .�� . , Transportation �` � �� ,a. :�: , . m.. � . . �� ° � ��,�►��.�� o � �� ,. � � ` ,__ - � . �� South Fork Catfish Creek to Edval � g � -� � � * �� .�F�� Connectto Existin � " � �",f , ±� Water Main on ,� �,�� '� '''�^ , -w Creekwood Dr �x�*!� � .� � 12' Water Main Extension � � �� . ,,, J � ? � R^" "ht� � � � ��r � y�ai'"a.� . ` L�� End of � �, �� ,� �� f�'�*r ro, � s �� ?e�� "�' �'' �v'"i�r y�� Water Main �µC OOD .y�� . r �„.,K.. � '� . Y y f A �t'�- � ,�" °'�y� +!� _' x��t, � �h �` �',�� }' S �=• �; # ,r � � 12-inch diameter• 2 700LF N MapPreparedby: � � 0 150 300 600 City of Dubuque W E Water Department Feet � 1902 Hawthorne St � $674,000 - 19% below budget -� S 563-589-4291 FISCAL YEAR 2021 H I G H L I G H TS �� . �� 4 �- :� �: �� ..4- : ��.,-f � t � � � f � .f ' `..� �."�a # �.�� A � `- � � 'j°'�'':'�'�- �. � � ,�= { ,� i{ .� �� .� . � � � _ _ t��.� �- ��:. � �, r.r�aRr,R[5T '� ;�.,. �f;.;�,": � � '' sue�iv�sioN :� , f : , - ti�'.� . 4 b� { ~ � r �'±�: � ` � �. : ''� � � �' ■ ■ •� i T�;, r� � :r�""�. .' ,�� . r �, • Cottingham Road Water Ma�n . , �: �:; ` :� a;��-� � 4ti }�. � :- � � �, ,..,,�_,.,��_., � � ...f : ' �'. . � . ��, , �vEw � �� ,� US20 Swiss Valle Interchan e _ � ._�, ��ITEFtCHAH��.: ,, ,. � Y J � t . . . � `�: � . � ' � . � f ■f1��41�\�� 1' . Improvements) . , �EWCDTTINGHAMROAD w�,�;;,�,�,�� . _ � -�1 WAT@RMkIN • �,y `� '� ---�RBONpONEO� . �: r ��u��i�� t� .�, � �„{_ r, 1k1 � y r � ' � � "4�� Collaborations: City Engineering and lowa � � o ,`� � r..............: .- r,: 'Q'' : WATER�tAiN � : r� ' �. � RELOCATI�N � � �� Department of Transportation _ � •.."""""""r -- , � .�.` y�t ;.��, .• � � � , ',l� � 12-inch diameter; 6,000 LF -�� i f�� r : �; WATER `.� �': �+ TOW ER 3 ' � . � US20 Swiss Valley Interchange ��r � 4� ,��;;'��' � � � • �� .� �`' � �y.� �.,� � City Expense: $334,600 :�� f � ,� ° � � +��,:�� ` � �.� " , ��, lowa DOT Expense $502,400 ��`� ��, . ��F. ��-��.: t� TOTAL �837�� Map courtesy of Bob Schiesl, Assistant City Engineer i �1, � a� i�F_. ��'� � l�7 `�/�'�� '�-�.c �: � i--i �Y ��1�..r,, ,,�� \� F�� 1\�p:�� y ��, �l ��; II .j' �,% � .� h� ��*{�� 1s,S�, .� � f/ �;�f � �1.� 4 // N . .. A �J '.'.�_�� F I S C A L Y E A R 2 0 21 --� � C� �� , � �. �, ��$��_-_ � 1:� ��e��, � .�,r��` x ,- � �;,��.� ,., � �� , , � , � � �� ,�� ° ; a ��.� �� , , �� , � � , - �" �, �� '°� ,�A � � �'"` � H I G H L I G H TS '�� _�� F�� - � � �, , ,' � �':�.,��'� '�'' �,� ,: �, :ir � `,� .; � ,� � �'��C'��,•''-�`��. ' � � � _ �� '�r�� , � �. �� , �- � �� _ _ �e�t �. ��F.�� k ��r i�i�'.'U '� � , � f '��!/�� . ;�� '' �� "`L'�. �,... " ;� .r�/� �� . � � . ��. • �� ,_ . s y � � �„ � , �, ��4- � a ¢ � r �", ti��," � �'il c �i �.��'��5 � n G�&� � i �� `� —. �� w i � �, '�' ��' . �•ti �,J�1r��E�'�'S�?t ��,-ih�.� �.1. - \ J/�.'�_ . �;� 1� �-��.� �. - ' . ' .� t f � � � �'�. ::.i,;,�� /� � '.�� -� � _ 'ti � ��-��'� � �� 1 �- -�� '�� WeII Rehabilitation '� � ��`,�� 3�;'s� �� ` _ ��'- --:•:.��: �:�'w�.: . ' �� , � , �'�i .. y��Y y�4 �,{ �':;Fj,�,l \�l��j�F�� .*'�S"�,,`�"g l� � MI �i ! v .. . - ., .� _ . : � ��` - �`�� ( e I I s a n d ) �� , , . . .. _ , x- .. � __ . , . . . , - - . - -_. �.-, . . .� W 3, 6, 8 r,�� ;��, � " �� . � - . � �� _��`� � �\\~ � - _ `� °�� ,,� �� .�� ,�� 1 � .� � : .��-- � - �� ; _ ' _ -:-_ ;' I " �a. - .. � '�''� �� _ 'i �`�� _ � � � • Contractor: � �,� '� �, ,=.:,� , ' �, - ��4 �I� di.Ji -__ �i� .. . . _ - - -"A i v . .i . � � � Peerless Well & Pump � � • �,$�x'�:, . ��. -�� "� _,� _�` -.`�:.:; � ��` �� "-�� ---� -.�. ` �'- -�-�4�..� - , �.- � ' -�,. x�� °;�� f � • Estimated Project Cost. Yz � �=� _ �' � � �� °� �45� `4 Y��,i�.� $93,191 � r _ - � lA � �� - � � �� i � - 4< _ _' - '1� ~�. � �� ' d `},�'� 9� � t " ' � .Y -4 r�l.:.! ""�5 '! ,� '„SF '� t,__ � ':« $ �a-��(� 5.'�� '7� Y �` �p� �'-- - ��{ .�� - • Schedule: March 31 , 2021 �� a�� y � � 4� � �� { . _ � . . . .*�e,�� ' {�f � ` z`°,x. <• 1 T • s Y J :� a e> '7 � ; { .' ' ,�,-.. ',.'� � a y '�4€ x u *� '�, � : ' . 'e , �,t r,' �� r js �w ,'`r �; ,,, � 'e t» f�b� �"sy, ,. t � ��.�� a _ ,.,, _.'� .�.�.. k.. . =�a��i .. _.�.,.v � � ��- � - -- Well No. 6 Column Pipe Removal �.� - ;: - �r. -��''� - ..�, Well No. 3 Temporary Pump Bowl Assembly .�� .. ,;._. FISCAL YEAR 2021 Auxiliary Emergency Power Improvements : Zone 5 Olympic Heights HIGHLIGHTS , «�„ ■ ■ �/ Zone 5 Olympic Heights Pump Station ;- ;� Remote Generator Switch �,: � t � � � � � � --_` � r � i rd;� : ' �— W. 3rd St. Reservoir Pump Station Generator ��--�� N�,'" £' , — �= � � — f p� x u�`� x �.''` � G ; � - . � , , �� ' �� _--- . = , . � � ; - � �:- . ��' �� .� ' f/ ` , � - --_ �.--�-.. � ..__�;��. _ ; �� _� _ „_ �� ' " �� - � �- _ _<y _ k. y' � � ` - _ , - _ __ - .. : �� ' z.�.� , , ��`� � • � . � - � �� , �f l -r- -r- . � . � , i -_' .,... . � , ; .- _ . .- , - � , - �� _ _- _ � . . � . � �l��Y a• � , ICOH� - - � �� "�� ER �.� � �� „-d - � --, , �� - W. � �; �_ � � �ER :::'� ,,. � �.. -_ � � , _ u�nrn�un � �„ _ � - �`; �„.� `-��` �� ,� ��'.- � yn nu�n�w I � f i ` � _ vi 1� ,' � , . _. m� � � nn�rnu��.nmu ■ �■ � ■�...�.......,...�� ' � , � I ¢ I , .�, . i �,,� , t � �.� _ - __ _. ` . _ @F �■' . ' � - "� � �Iliiiiiiii111�� Yk.a ... ..�. . '- � ...�� —_ �. � � - � "[A . � '�_�� ,`� � V`�� _ _ �� a�\.\:.. -°�' Rm��,",;; �nnumniiiiii ._� �-. ^ ... _ _. , S: ' nq11n111111q1�1 . . ' ' . ... ____—_— 3�9 ' _'_._nrnii��. �� ., -. r r .. � � � ��. � te-*' -- � � �f� � Rxt S� "�: r�� - k _ � , -�* '' __- f �7;� �,� a�,�� ' ° ` ;j �i:—�. �• ��,r� ` ', � � —� ' _�� _ . . Y � . f �.. -�' �y I :,.!{. � r� �. - ,&... � � . . � . , ' - �.� � . �`-�� ,� _ , - - � _ � - — - � � i . . _ -�� ,� , ; � -:w :: � .. - _ .�:�. � . . � _ a: � ��-��-- �.�._; _ , : �. � �_� : ; � - --� �� '` _ _ _, � _ � , � � . �_ . �.. .� ,.?a at�, . . .r+"'t . .'-._� \ - . , s , .: ��•� � � � _ : � _� _ ; _ / �.. � .�1v� .� . . _ ' ' �� Eagle Point Water Treatment Plant Generator - • Reduce Service Outages : . � Burlington and National Water Main � Replacement - Est. 1000LF ; 8-inch Diameter � � ��=� Ft��°ris�gtasz St Natiaszal St ctnc� Staltz St :,,��a.h��,�.,��s UtJR L. IR r r � 2G18 Rward 1Ynner .� ..�. . . � ... . , 1�1'tlr�tl�t'I� 1'1':�tL'I':ti'�f7f71 llt'k�lfiC['1!fE'I[t ' � zs5o i 2saa - - '��oa •-z-xsoz ' z � ' � L� � �11 * Legend ' � �.. . - ----��.M�s�Ar�EST� - I WaterMain i 1 . � � . i Status � i 2s7� � zss7� � _ � A�1ive � • �. zsa5 I �I - 1 _ � � I 2s5i � zsaz � �st5 �soy �s1o� 5 �2sss^�� r �� I � J .2945 � � �z��5 � 2sot I �� Propase�l �JJ �_� � ''" � � � �� Main Breaks _-� , N �., n l J � � , �: � # hlain Break e.. /II�II � � �N � �` �� 5J Y ..� �� .—J .� � i❑ — a r N � 2840 ti �� .467—I $ . .} � .402 I ■ L —i a � i �� d0=d02 � �I .380 � �: � •- J ■ � . � � ,407 f 285a1 �— �'`�M — — ■ 2960 2940 2938 2934 � 30d� � I � • � .475 � � �.�� I - I 2.2 � I 4 ��J f.. a.: k �s�.r� +�1 � �_ � . J . J F ► • �' ? � � r � �% Bt�RLINGTON 57 � I . �' • • . i;��. . • w..M r . a�){'.:r . r�t��#�� . . �.� ■ ay ;. . a:. . .�-r .�. .� � � � • � � � � � r1 30951 � 3�09 2965 � � �3� 2933 " ,l `"�� 28 5 .3035 �. I � �� ^ �.�945 � r .2855 I � ' L i l� '�J �925 � I L. Is � � �� ❑ �ity cf Cu:wc�e.la..d� _ . I inch-7G f�et � � F+lap Prepared by. - _ Ciry of Dubuq�3e - - ,5 3,.� o zs Feet Water Department � 1902 Hawthome St .,...:.,.a.,>>. ..,.�„ � 5 563-58;1�291 - • Water Quality Monitoring : . � Pressure Zone 5: Olympic Heights Auto � Flushin and Sam lin S stem � g p g v ■ Du°B� i_,E Olymipic Heights � SpecialAchieveme��5 2018 Award Win "°'`"� '� `"""' '�'� Zone 5 Auto Flushing Wnter Quadity Monitoriny Unit Loc�rtion 489 495 O • • � � • � , / ��, � ,h„" . �_ . . - . �„ — ;: ,_. . -'"�1t,.. -_� �-.��. . \�� ' ,.� � e� - ��1�i PATENT O - � ' PENDING O 3�9 485 o a �� ez� � �333 �az� • � � '` � ' W � fl� i _ � �...,..., �, 12,. W _G � } • ' OLYMPIC HTS �, AUTO FLUSHER �'�� LOCATION � �-' ��;:. �� _ � .- • • . . . _ . . • : a�o . 500 484 �..� �� W ^��t _.a m� �" . • • 442 � � O N u � � � ❑ O � City of Dubuque.IA.Kucera In'tematlonal SCL�,MEp 1 inch=71 feet N Map Prepared by: City of Dubuque ioo so o �oo Feet W�E Water Department 1902 Hawthorne St S 563-589-4291 . Support Economic Growth and Development: � Tamarack Park Phase 2 Water Main Extension Project ► � • Collaborative Project Design, ��=�_ Tamarack Park Phase 2 � 2018A��dw��e°"°"= DUsvc�UE � � Bid, and Inspection with City '��°��`°��'°�� . Engineering °,,// /y � ST�N�wooO V ', OR • Initiated per 2016 Agreement with 0 � Jon Luckstead of Tamarack Park 0 � k.�=�� o y O 0 • Phase 2 of 3. First phase was p� � completed in 2019: Water Main �� BR�NZFwooQ��o� op oR`r �P Crossing HWY 151/61 . Phase2lnstallation` �P�P �� • Project Length: Approximately � 1 ,300 LF � � � �� 3 �a w � � I� = I • Project Cost Estimate Including Legend � . Engineering Services: $360,000 Water Main � Q Active %' � � i � �a ---- Proposed � Jy • Construction Schedule: ��Fa N MapPreparedby Completion Late Fall 2021 ° ,°° Z°° °°° 60Feet W�$E ,021HawlhoneSt S 563-589-4291 Security, Communications, and Energy Savings ' • SCADA & Fiber Optic Communications � . Upgrade Project Est: $1 ,200,000 ■ ■ Du� John F Kennedy Rd to Soccer Tank � SpecialAchievementinGlS 2018 Award Winner �,r,�.��•,,,;��«��,��r,.�M;=�;�=r�,v, Unpinruied UiSlrrriee:IS61 Feel �° ° � `� � C� � � ,, �� O � f� U\ � � � 9 � O �,a�. � � �_, . � �� I � -_' � ��kFiyN ��o �R.3iD � ��'�'' ��YnO �•� ��r , 3;'4i'; - �� '_ � �-� �L�� Legend r� �Proposed Water Fiber � _VJater Facilities City Fiber Network � _ �<all other values> Status �r� �Ac[ive Inactive / �Under ConstructionlDesign ��P,�. � /� �Proposed P,�� - � �� Abandoned in Place N� �� . ' '�^' ��'..�� . 1 inch=189 feet N Map Prepared by: City of Dubuque �oo so o �o0 2ooFeec W�E WaterDepartment 1902 Hawthorne St S 563-589-4291 . Meter Technology Upgrade • Water Meter Product Replacement of Meter Interface ` � Units and Registers ■ ■ • 5-Year Program • Project Est. $2,970,000 with Projected Savings $737,130 in total project costs over 5 Years • R900 Infrastructure installation by Ferguson Water Works I Neptune R450 MIU � ,_ � � � ;-.�'"_��_� �I� .E Neptune R900 MIU °�jOWA Home Statistics— Resources— ManageAccount— WAT E R A D M I N I S T RAT I O N Training E�ent details ■ ■ • Employee Training and Development Date 03.'10,'2021-03�14.'2021 � Professional Development Location � On Boarding of New Employees City 8 State CNLINE � Continuing Education Programs Cantacls 10 WAR U RALWATER.O RG • Re g u I ato ry C o m p I i a n ce More Inio IOINARURALWATER ORG � Reporting, monitoring, and working with lowa Description RISIGRESILIENCE&EMERGENCYRESPONSEPLANSMARCH DNR and EPA on compliance■ MaxAllowableHours � • Ordinance and Rates • Water Use Ordinance Recommendations • Water Rate Analysis & Recommendations • Capital Improvement Planning � Project development including budgeting, initiation, and award through construction completion. Local Assistance • Implementation of 50% base fee reduction for income qualified � Water and Sewer Customers � • 437 Customers or 2% of Residential Customers � � Source: City of Dubuque Finance Department I State Program Assistance • State of lowa Disruption Prevention Program managed by the lowa Finance Authority • $17,942 • 47 Accounts Source: City of Dubuque Finance Department Other Program Assistance • Community Development Block Grant (CDBG-CV) CARES Act & Community Foundation of Greater Dubuque • $6,324.45 • 27Households Source: City of Dubuque Housing and Community Development *Average Household = 6, 000 Gallons/Month 0 0 � Proposed Rate Monthly Bill Impact for Increase over FY 21 Average Household* WATER ADMINISTRATION Rate Comparison, Lime Softened Facilities Only $50.00 $40.23 $40.00 $36.Sb �35.10 $35.01 $35.04 $33.82 �31.62 $30.00 �29'6� $20.00 $10.00 �— West Des Des A�e. W/4 lowa City Cedar Arnes Dubuque Council Moines Moines Dubuque Rapids Bluffs r FY22 Water �nly for A�erage Household (6,00� gallons) Based A verage Household = 6, 000 Gallons/Month 2nd Lowest Rates : The Highest Water � . . o . Rate (West Des Mo� nes) is 27 /o H � g her � , than Dubuque's Rate ; and the Average Rate is 9 .4% Higher than Dubuque . � M � WATER TREATMENT PLANT OPERATIONS � � • Water Production and Treatment � Regulatory Compliance � � � � � � � Water Quality - Consumer Confidence l • Source Water Protection � Wells and the Well field � - � � � � * . .�. �� _ � Treatment Plant ,� . .._. • Water Storage and Pumping Facility .,�� ' . . � Operation and Ma�ntenance • Reliable Data Access and Reporting � SCADA Communications � � � � � � � � WATER PLANT OPERATIONS ■ ■ Water: Treated and Non Re�enue Water Metered (Percentage) 2,500 2�2�4 25.00% � 19.81% 20.00% 0 2,000 1,898 20.00% ._ 0 1�5pp 15.00% 0 � 1,000 10.00% � c � 500 5.00% � �7 —/ — FY'20 AWWA Treated Metered "Benchmark" _ FY2Q NRW Percentage / � WATER DISTRIBUTION � _� � � � � ` � � � �,. � � � �� R�r - . �A_. :.� � , ■ ■ �� -{ _�,�� : ,� `' .4 � ► ' �'q ._ �ti •S' a . . F '- . 'j1 �_' F/� � � �y i 't'Y� ' �,��,�4 r � 'i ,�.. . h �✓'�� , � �- � �,�� `Se. ��^�, 6' y _ _ �,` � � � `� �jt� � � '�� • Operation and Maintenance �� ` - � R - -�� :��`'!�fi-y��4,. . �- ,.�.s'' ,, . �,�,,t �� Y �.. • � � � ,�`+,,,�M,� .. 5 �L, Emer enc Res onse �..� � . � : �.,_;. � .} �� .� J Y p �,�. ,..� . . , .� � .� �.� � �;\� .,,,,�. a -� • Inspection 5 � - �.� . � � �� r � �• .�.. . ..� , �.,� ■ �-��, +,��j .�-�� y:�.� ;i�y . • General Construction � T� � r � � a - _. _ .�� ;�� .�� ... . . �. • Service Line Main Taps � -� _=- _.�� . , �� :�.�. . A � ,�u 1 • Water Main Installation -- � , - �,-:. ,� . � , * • Meter Management � _ • � � :� �� , ¢�� • Backflow Prevention - - - • Development Review � � � '-� � S . . . . �.,�� ^�R� y � �� J ��; �,� � � 'a" � � � z . �,._.. ..� �� '>' . f �,..; � �fi y `a f {},``�Y` �� *��► - -�`� .ar"� - 7' �;� � .^' �+ . .?'.. r�, ''��`� ��'3, WATER DISTRIBUTION ■ ■ Water Main Break Response 125 105 100 85 �� 74 58 60 50 �8 25 0 FY'1G FY'17 FY'18 FY'19 FY'20 FY'21* � Water Main Break Response WAT E R DISTRIBUTION � ' � � . � *FY 2021 to date: � � 45 Service Taps New Connections � result from community growth " ' such as new housing, businesses, and � ' industry. � • • � . . WAT E R DISTRIBUTION � � � � - � � . . � � � � FY19 - start of all meter � � service and repairs being provided by the Water � � � � � Department. � , FY21 * - Due to COVID-19 " ' Meter & Register „ Maintenance was affected. Meter Service work has � " resumed and work in � � process is appox. 650 work orders. • , Backflow Prevention Program � � _ 1� � � � - �' � �o ' ` r�,� � �� I 1 • Administered internall b � � �� -�� I � � v y ,�� _ �, � � Water Department's Carl � _ T ^,, � �,,� , �,-� � � � ?� ;,� "��` �'�° � �;__�...-:- P I u m I ey. I r � `t�= � f,��,�' �- � ; �� ,� � _ �� ` � � �� -�� _ . . . . �o�= `�ry '� � � - - � y • Ad m i n istrative fee 25/device �:.� � ` � .j,�� , ,��- �_ �, � . - (City devices not billed). � �, � �� ,,,, �,�,� ;�` �� , � � ,�� .� __��. � ,�; . � � .., � � �� - -� � �---� � „ _ � i _ �� a�� `T ��f', '', �.t�� . • FY2021 Revenue Forecast: F_� . Y " � � =, 1s � , � .-.`.- ,� �_ � $75,950 � � .�� .�,� �' *. ,; ... , � �..�— � Based on 3,038 devices. : � . � � „� �� %, � �-, ��` �� - � D � I ' . '. . _ ��'. .`i. ��',�-v- �� : " - �,� � � � �� _ , ��; , : �-. {.....�.,�,�` - ; ,, , . �r -,� .;�� Jeff Mills performs backflow recertification testing � � A) Emergency Shelter In Place Accommodations at the Eagle Point Water � • • Treatment Plant - $12,145.80 • A & G ElectricElectrical work for RV hook up $2,964.70 • , • Giese Sheet Metal Secure Portal for RV Cabling $ 157.60 . • Three Rivers FS Heating LP RV Hookup $ 623.50 • Couler Valley, RVs RV Maintenance $8,400.00 B) Potential Impact to Meter Sales Revenue, Estimated - ($99,000) / • , , � • � � 1 . Portable Generator for the Olympic Heights Pump Station Estimated Purchase Price: $50,000 (Non-Recurring) 2. Full-time Water Operations Supervisor (GE-36B) in replacement of a Full-time Water Plant Operator (0E-16F) and 0.3FTE Water Distribution Maintenance Worker (0E-09B) Budget Savings: $6,735.89 (Recurring) FY 22 CAPITAL IMPROVEMENT PROJECTS - . - , , - � - . Water Meter Replacement Program $ 461 ,015 $ 2,692,533 Manhole Replacement Rehab $ 25,000 $ 75,000 Water Main Upgrades during Street General Repairs $ 20,000 $ 70,000 Water Line Extensions to New Developments $ 775,000 $ 775,000 Wells, Well Field, and Raw Transmission Piping Repair $ 120,000 $ 500,500 Water Treatment Plant Condition Assessment and � 20,000 $ 100,000 Master Plan Water Storage Tank Coating Program $ 25,000 $ 2,525,000 WTP and Pump Station Pipe Rehabilitation $ 20,000 $ 220,000 McFadden Farm Water Main Improvement (S. Heacock � 385,000 $ 655,000 Rd from Chavenelle to Pennsylvania) SCADA & Comms Improvements $ 250,000 $ 850,000 FY 22 CAPITAL IMPROVEMENT PROJECTS (Continued) . � - - - - . . Super 20 Mobile Home Park Water Connection to City � 142,000 $ 142,000 Water Green Alley Water Main and Fittings Replacement $ 108,000 $ 108,000 Burlington Street Water Main Replacement $ 350,000 $ 350,000 CIWA Water System Agreements for Water Service Line Installations $ 125,000 $ 224,000 Olympic Heights (Pressure Zone 5) Auto Flusher and CL2 Analyzer $ 37,075 $ 37,075 WTP Roof Repair $ 200,000 $ 200,000 E. 16th St Water Main Replacement (White St. to Alley � 71 ,500 $ 71 ,500 Between White and Jackson St) E.16 Street (White St. and Alley East of White St.) � 24,000 $ 24,000 Hydrant Relocation Pro�ect 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 pipe of Service Rate) <1% in staff hours Technical Meter Service /ssues % of Projects Completed within per 1,000 accounts the Program Budget I www.cityofdubuque.org/water