Water Department FY21 Budget PresentationCity of Dubuque Public Hearings # 1.
ITEM TITLE:
SUMMARY:
SUGGESTED DISPOSITION:
Copyrighted
April 16, 2020
Water Department FY21 Budget Presentation
ATTACHMENTS:
Description Type
Water Department FY21 Policy Budget Outline Supporting Documentation
Presentation Supporting Documentation
Water Department
This page intentionally left blank.
-2-
WATER DEPARTMENT
FY 2019
Budget Highlights Actual
Expenses
Employee Expense
Supplies and Services
Machinery and Equipment
Administrative Overhead Recharges
Finance Utility Billing
Engineering Water Maintenance Charges
Payment in Lieu of Taxes
Payment to Construction Fund
Debt Service
Total Expenses
Resources
Operating Revenue
Total Resources
Net Operating Surplus (Deficit)
Personnel - Authorized FTE
Water User Fee Rate Increase
Revenue 1% Rate Increase Generates
FY 2020 FY 2021 % Change From
Budget Requested FY 2020 Budget
2,202,709 2,404,255 2,506,633 4.3 %
2,459,947 2,601,359 2,621,409 0.8 %
913,342 736,780 1,339,511 81.8 %
405,172 454,496 424,310 (6.6)%
1,801 — %
33,400 20,010 20,707 3.5 %
142,884 142,884 142,884 —
935,000 400,000 550,000 37.5 %
3,059,778 3,689,299 3,861,392 4.7 %
10,154,033 10,449,083 11,466,846 9.7 %
9,474,916
10,497,358
11,333,793 8.0 %
9,474,916 10,497,358 11,333,793
(679,117) 48,275 (133,053)
25.87
3%
26.37
5%
26.07
5%
80,639
8.0 %
-181,328
Improvement Package Summary
1 of 11
This improvement package would provide funding for Cartegraph or other applicable software licenses to
help to 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 and High Priority of a Citywide Departmental Work Order System Implementation.
Related Cost:
Water Rate Impact:
Activity: Administration
$45,000 Water User Fees Non -Recurring Recommend - Yes
0.56%
2 of 11
This improvement package would provide funding systematically upgrade the two ruggedized cell phones to
smartphones and provides service for six additional smartphones for the water distribution crew.
Smartphones would enable the crews to have access to WebQA and GIS mapping during the response to
an emergency improving the time with which it takes to locate isolation valves. The City operations would
be improved with decreased response times to emergency sites and the community would benefit from a
shortened interruption of water service in the event of a water main break. In addition, Web QA notifications
would come directly to the staff member. WebQA is currently used as the department work order system.
As work orders are available electronically, the crew would be able to view the order, complete and close it,
thereby improving response times in the City's WebQA process. This request follows the City Council Goal
and Priority of Sustainable Environment: Preserving and enhancing Natural Resources to readily respond to
provide safe, dependable drinking water and using affordable technology for water activities.
-3-
Related Cost:
Related Cost:
Total Cost:
Water Rate Impact:
Activity: Distribution
$ 4,992 Water User Fees Recurring
$ 700 Water User Fees Non -Recurring
$ 5,692
0.07%
Recommend - Yes
3 of 11
This improvement package would provide funding two additional smartphones for the Water Plant Operators
Special Assignment. These will enable the Water Plant Operators to respond to requests from the Electrical
and Mechanical Staff as needed. Due to the need for Water Plant Operators Special Assignment to work
away from the Water Treatment Plant in the field, it is important that they can be reached while out in the
field to respond to water quality concerns and request assistance when needed. The operators are currently
using their personal cell phones while working out in the field. This request follows the City Council Goal
and Priority of Sustainable Environment: Preserving and enhancing Natural Resources to readily respond to
provide safe, dependable drinking water and using affordable technology for water activities.
Related Cost: $ 1,248 Water User Fees Recurring
Related Cost: $ 700 Water User Fees Non -Recurring
Total Cost: $ 1,948
Water Rate Impact: 0.02%
Activity: Plant Operations
Recommend - Yes
4 of 11
This improvement package would provide funding for a tablet to be used by the Operators Special
Assignment at the Water Plant and out in the field. This will enable data to be collected directly from the
Well Sites, the distribution sites, the pump stations and customer properties in response to water quality
concerns. Distribution testing and sampling data will be used for trend analysis and completion of the
monthly operating reports that are submitted monthly to the Department of Natural Resources to ensure the
drinking water treatment process is compliant with all standards listed int he City's operating permit.
Continued and improved data collection and entry ensure continued compliance of the City with its
regulatory requirements stipulated by the Safe Drinking Water Act as enforced by the United States
Environmental Protection Agency and the Iowa Department of Natural Resources. This improvement
supports the City Council Goal and Priority of Sustainable Environment: Preserving and Enhancing Natural
Resources providing safe, dependable drinking water using affordable technology for water activities.
Related Cost: $ 120 Water User Fees Recurring
Related Cost: $ 950 Water User Fees Non -Recurring
Total Cost: $ 1,070
Water Rate Impact: 0.01%
Activity: Plant Operations
Recommend - Yes
5 of 11
This improvement package would provide funding for leadership development for the City of Dubuque Water
Department Leadership Team. The primary area of emphasis for maintaining positive momentum includes
implementation of strategic priorities and reinforcing the Work of Leaders model of Vision, Alignment, and
Execution. Fairchild Coaching recommends using the framework of Vision, Alignment and Execution, Work
of Leaders will encourage City of Dubuque Water Dept. leaders to understand their own leadership
behaviors and how these behaviors impact their effectiveness. This follows the City Council Goal and
priority of being Financially Responsible, High Performance City Organization: Provide City services
responsive to the community.
-4-
Related Cost: $10,713 Water User Fees Recurring Recommend - Yes
Water Rate Impact: 0.13%
Activity: Administration\Meters\Distribution\Operations
6 of 11
This improvement package provides funding for the purchase of cut off saw. The addition is a Chain saw
Style, unlike the existing one and will be run by hydraulics not gas, which makes it much safer for the
Distribution Crew when using it. This improvement supports the City Council Goal and Priority of
Sustainable Environment: Preserving and Enhancing Natural Resources providing safe, dependable
drinking water using affordable technology for water activities.
Related Cost:
$ 4,200 Water User Fees Non -Recurring Recommend - Yes
Water Rate Impact: 0.05%
Activity: Water Distribution
7 of 11
This improvement package would provide funding for the purchase of a new ground penetrating radar. As
the City purchased other utilities, the Distribution Staff has found the field record documentation of these
utilities to be unsatisfactory. This ground penetrating radar would be used to assist in the field locating new
utilities and document them to our GIS record system, providing accurate records. This ground penetrating
radar tool can also be shared with other City Departments in locating their utilities. 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 Savings: $30,000 Water User Fees Recurring Recommend - Yes
Water Rate Impact: 0.37%
Activity: Distribution
8 of 11
This improvement package would provide funding to upgrade the 3/4 ton truck to a utility truck. This vehicle
has met or exceeded the time frame for trade in and is not equipped to perform the necessary functions that
are required of the Water Distribution Crew. This package would ensure that the needs of citizens are met
in a timely manner. This improvement supports the City Council Goal and Priority of Sustainable
Environment: Preserving and Enhancing Natural Resources providing safe, dependable drinking water
using affordable technology for water activities.
Related Cost:
Water Rate Impact:
Activity: Meters
$34,028 Water User Fees Recurring Recommend - Yes
0.42%
9 of 11
This improvement package would provide funding to upgrade the 3/4 ton 4X4 Super Cab truck to a Utility
Truck, 4X4 450 Series, Regular Cab with a 10' Utility box with crane, ladder rack, front mount valve turner
and Hydraulic motor pump. The existing vehicle has exceeded the time frame for trade-in and is currently
rusting out around the wheel wells. This vehicle is not capable of performing the functions needed for the
Water Distribution Crew. This improvement supports the City Council Goal and Priority of being a
Sustainable Environment: Preserving and Enhancing Natural Resources providing safe, dependable
drinking water using affordable technology for water activities.
Related Cost:
Water Rate Impact:
Activity: Distributions
$40,000 Water User Fees Recurring Recommend - Yes
0.50%
-5-
10 of 11
This improvement package would provide funding to upgrade the replacement of the 2002 Freightliner
Tandem Dump Truck to a Tandem Truck that has greater horse power and larger carrying capacity to meet
the needs of the Water Distribution division enabling them to better serve the citizens of Dubuque. This truck
would be equipped with a snow plow to assist Public Works on snow events equal to or greater than 8
inches. This improvement supports the City Council Goal and Priority of Sustainable Environment:
Preserving and Enhancing Natural Resources providing safe, dependable drinking water using affordable
technology for water activities.
Related Cost:
Water Rate Impact:
Activity: Distributions
$40,000 Water User Fees Recurring Recommend - Yes
0.50%
11 of 11
This improvement package would provide funding for Backhoe/Loader to be replaced by a Skid Steer with a
rubber track, bucket and broom attachments with a trailer. The Backhoe/Loader is a 1999 John Deere 410
4X4 Extend a hoe with ride control. This vehicle has exceeded the standard time frame for trade in. It has
maximized its hours and is developing maintenance issues representative to its age. It is functionally
obsolete, replacing this with a fully equipped Skid Steer will optimize the work completed by the Distribution
Crew. The Skid Steer replacement for this will operate with better efficiency within the Water Distribution
Department. This request follows the City Council Goals and Priorities of being Financially responsible,
High -Performing City Organization: Sustainable, Equitable and Effective Service Delivery.
Related Cost:
Related Savings:
Net Savings:
Water Rate Impact:
Activity: Distribution
Employee Expense
$ 55,000 Water User Fees Non -Recurring
$ 90,000 Water User Fees Non -Recurring
$ 35,000
(0.43)%
Significant Line Items
1. FY 2021 employee expense reflects a 1.5% wage package increase.
Recommend - Yes
2. The Iowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged
from FY 2020 The employee contribution of 6.29% is unchanged from FY 2020.
3. The City portion of health insurance expense increased from $921 in FY 2020 to $1,013 in FY 2021
per month per contract which results in an annual cost increase of $37,744 or 11.26%.
4. Overtime is unchanged from $94,040 in FY 2020 to $94,040 in FY 2021 . FY 2019 actual was
$108,641.
5. Five -Year Retiree Sick leave payout is decreased from $32,007 in FY 2020 to $29,299 in FY 2021.
6. 50% Sick Leave Payout is increased from $0 in FY 2020 to $2,097 in FY 2021 based on FY 2020
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. During Fiscal Year 2020, the following personnel changes were approved (net change -0.30 FTE):
a. -0.80 FTE Part -Time Water Meter Service Worker position eliminated (-$60,913)
-6-
b. +0.50 FTE Part -Time Water Distribution Maintenance Worker position added (+$32,733)
Supplies & Services
8. Property Insurance decreased from $66,812 in FY 2020 to $59,548 in FY 2021 based on FY 2019
actual plus 5%.
9. Electricity Utility Expense increased from $628,223 in FY 2020 to $678,511 in FY 2021 based on FY
2020 budget plus 8%. FY 2019 actual was $668,403.
10. Sales Tax expense decreased from $520,583 in FY 2020 to $461,701 in FY 2021 based on
decreased consumption plus an increase in water rates in FY 2021 of 5%. This expense is directly
offset by sales tax revenue.
11. Machinery and Equipment Maintenance increased from $69,816 in FY 2020 to $83,952 in FY 2021
based on FY 2019 actual of $87,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.
12. Costs for Fluoride, Phosphate, Chlorine, Lime, and Polymer expense (water processing materials)
decreased from $433,950 in FY 2020 to $430,663 in FY 2021. FY 2019 actual was $379,114.
Chlorine decreased from $40,000 in FY 2020 to 37,480 in FY 2021.
13. Hauling Services increased from $148,250 in FY 2020 to $157,815 in FY 2021 based on FY 2019
actual plus 4%.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 2019 actual expense was $151,610.
14. Consultant Services increased from $0 in FY 2020 to $62,464 in FY 2021. FY 2019 actual was
$47,769. This line item represents special plant operating services and consultant services as well
as conducting a leak survey ($29,000) every three years, next scheduled in FY 2021.
15. Software decreased from $88,625 in FY 2020 to $64,701 in FY 2021 due to the one-time cost in FY
2020 to replace the unsupported Access database currently used for the collection of water
treatment process data (-$26,980).
16. Property Maintenance decreased from $65,560 in FY 2020 to $36,995 in FY 2021 based on FY
2019 actual less the one-time expense of $20,000 for the third floor restoration at the Water Plant
and a decrease in the cost of the mowing contract. This line item represents the contract for building
and grounds maintenance for Eagle Point Plant, sludge plant, storage tanks, reservoirs, booster
stations, well houses ($535 per week for 32 weeks in FY 2021 as compared to $1,335 per week for
26 weeks in FY 2020).
17. Pipe Special Fittings is unchanged from $79,332 in FY 2020 to $79,332 in FY 2021 based on FY
2020 budget. FY 2019 actual was $89,509. 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 ($26,591) and taps services ($35,121).
18. Valves increased from $24,192 in FY 2020 to $44,192 in FY 2021 due to adding $20,000 for Water
Treatment Plant and pump station ongoing valve replacement and maintenance. FY 2019 actual was
$64,236. 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.
-7-
19. Environment Testing/Monitoring decreased from $60,000 in FY 2020 to $41,604 in FY 2021 based
on FY 2019 actual of $39,892 plus 4%. 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.
Machinery & Equipment
20. Equipment replacement items at the maintenance level include ($1,339,511):
Administration
Smartphone (1)
$ 350
Meters
(1) Smartphone
$ 350
3/4 Super Cab 4X4 Truck $ 90,000
Large Water Meters $ 27,000
Plant Operation & Maintenance
Laboratory Equipment $ 5,800
3/4 Super Cab 4X4 Truck $ 40,000
Water Distribution System
3/4 Super Cab 4X4 Truck $ 160,000
Hydrants $ 31,500
Gas Safety Monitor
$ 950
Smartphone (1) $ 1,050
Tandem Dump Truck with Snow Plow $ 130,000
Backhoe $ 90,000
Annual Maintenance Projects
Pump Replace Vacuum Filter $ 15,000
Large Valve Replacement (2) $ 20,000
Water Main Replacements (Repair of 70 mains) $ 350,000
Water Meter Replacement $ 176,661
Large Water Meters $ 75,000
Water Valve Box Maintenance (Public Works) $ 20,000
Water Meter Testing $ 25,000
Recommended Improvement Packages $ 45,950
Total $ 1,339,511
-8-
Debt Service
21. Annual debt service reflects repayment to ($3,861,392):
Amount Debt Series Source
Purpose
Final CaII
Payment Date
56,699 SRF 2007A Water Fees
Clear Wells 2028
$ 115,598 Revenue 2008D Water Fees
Water Improvements 2023 2019
$ 218,708 SRF Series 2009 Water Fees
Meter Change -Out 2031
$ 384,450 Revenue 2010D Water Fees
Water Improvements 2030 2019
$ 106,604 G.O. 2018A Water Fees
Water Improvements 2031 2026
$ 43,340 G.O. 2012E Water Fees
Water Improvements 2032 2019
$ 144,356 G.O. 2019C Water Fees
Water Improvements 2033 2026
$ 751,781 G.O. 2014B Water Fees
Water Improvements 2032 2021
$ 44,088 G.O. 2016C Water Fees
Water Improvements 2033 2024
$ 674,260 SRF 2017 Water Fees
CIWA Purchase/Imp 2036
$1,060,000 CIWA Contract Water Fees
CIWA Purchase 2022
$ 261,508 SRF 2019
Water Fees
Roosevelt Water Tower
2038
$3,861,392 Total Water Annual Debt Service
Revenue
22. Water User Fees increased from $8,161,223 in FY 2020 to $8,990,033 in FY 2021 based on the FY
2021 projected rate increase of 5% and and a 1 % decrease in consumption in FY 2020.
23. Flat Rates increased from $18,389 in FY 2020 to $20,769 in FY 2021 based on FY 2019 actual of
$20,769. This charge is for customers purchasing bulk water. Rates are set by City ordinance.
24. Fire Protection Rates increased from $170,410 in FY 2020 to $174,459 in FY 2021 based on FY
2019 actual of $174,459. This fee is the demand charge for fire sprinkler head connection. The rates
are set by City ordinance.
25. Taps decreased from $33,000 in FY 2020 to $26,591 in FY 2021 based on FY 2019 actual of
$26,591. 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.
26. Tap Service increased from $14,500 in FY 2020 to $35,121 in FY 2021 based on FY 2019 actual of
$35,121. 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.
27. Connection Charge Front Footage is unchanged from $55,000 in FY 2020 to $55,000 in FY 2021
based on a three-year average and planned new subdivisions. FY 2019 actual was $144,708. 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.
28. Backflow Prevention Administrative Fees increased from $74,175 in FY 2020 to $76,025 in FY 2021
based on actual number of accounts. FY 2019 actual was $73,578. This is the $25 annual fee
charged to all customers with a backflow device.
29. Penalties for late payments increased from $84,383 in FY 2020 to $95,739 in FY 2021 based on FY
2019 actual of $95,739.
-9-
30. Tower Monthly Rental increased from $101,495 in FY 2020 to $103,795 in FY 2021 based on water
lease contract amounts. FY 2019 actual was $141,804.
31. Sales Tax Collected decreased from $520,583 in FY 2020 to $461,701 in FY 2021 based on the rate
increase for water fees. This line item off -sets the sales tax expense.
-10-
Water
Distribution
Supervisor
Water
Distribution
Foreman
Water
Department
Manager
Confidential
Account Clerk
Engineering
Assistant
Meter Repair
Worker fI
Equipment
❑peratnr II {2)
Distribution
Workers (5)
Meter Repair
Worker I (2.8)
GIS Specialist
Plant Operators
�7)
GIS Seasonal
Interns(0.50)
Equipment
Mechanic
Electronic
Technician
-11-
This page intentionally left blank.
-12-
WATER DEPARTMENT
The Water Department ensures our community has high quality, safe, reliable and affordable
drinking water.
Wa
Departme
Administration
Plant Operations
& Maintenance
Water
Distribution
Water Meters
SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE
LEADING TO OUTCOMES
PEOPLE
Employees of the Water
Department are provided training
to ensure the maintenance of the
appropriate licenses required by
the Iowa Department of Natural
Resources. Other job -related
educational training is provided
to broaden employee skills and
increase productivity.
PLANNING
The Water Department is engaged in
conscientious, strategic planning which
allows for maintaining compliance with the
state and federal regulatory agencies in
order to provide the highest quality, safe
and cost effective drinking water possible.
PARTNERSHIPS
The Water Department is involved in Community
Activities/Partnerships/ Outreach programs such as Water
Conservation Educational Program and the Smarter City Initiative.
The Water Department provides tours of its Eagle Point Treatment
Plant to local schools and organizations.
-13-
$10,000,000
$8,000,000
$6,000,000
$4,000,000
$2,000,000
$0
WATER DEPARTMENT
FY 2019 FY 2020 FY 2021
Full -Time Equivalent 25.87 26.37 26.07
Resources Support
$9,474,916
FY 2019
$10,497,358
Operating Revenue
FY 2020
$11,333,793
FY 2021
The Water Department is supported by 26.07 full-time equivalent employees, which accounts for
21.86% of the department expense as seen below. Overall, the department's expenses are expected to
increase by 9.74% in FY 2021 compared to FY 2020.
Expenditures by Category by Fiscal Year
$3,500,000
$3,000,000
$2,500,000
$2,000,000
$1,500,000
$1,000,000
$500,000
$0
CD
0,
FY 2019
peege o Uppy
FY 2020 FY 2021
pun3 uopruisuoO
aouuag iqa
sa6aeg3 6uuaaui6u3
-14-
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 2019 Actual
FY 2020 Budget
FY 2021 Requested
Expenditures
$3,809,223
$4,546,855
$4,771,692
Resources
$13,923
$—
$—
Water Administration Position Summary
FY 2021
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
FY18 FY19 FY20 Performance
Actual Actual Estimate Indicator
1 Activity Objective: Maintain a financially -viable water utility.
# of staff who completed annual training
(hrs) to support CEUs and professional 20 15 20 30
development in emergency response
Reduction of Water Quality Issues per
100 miles of Pipe
<20 22 30 22
% of lost/unaccounted for water
<18% 18.9% 18.9% 17.8%
% of projects completed within the
program budget
100% 100% 100% 100%
Operating cost coverage for water (Total
operational Revenue/Total Operating
Cost)
1.0 1.14
1.04 0.97
# New connections and partnerships (per
year)
1/yr 3/yr 2/yr 3/yr
-15-
WATER DEPARTMENT
Plant Operations and Maintenance
Overview
Plant Operations and Maintenance ensures that water used
for domestic, commercial and industrial purposes is high
quality and is supplied to meet the needs our community. We
are responsible for the management of equipment and
treatment process of the City's drinking water in compliance
with all federal and state water quality standards.
Over 200 tests per day are performed by water treatment
plant operators. In addition to these tests, the Dubuque
W&RRC Laboratory performs over 60 bacteriological analysis
of the drinking water on a monthly basis. Other compliance -
related testing is performed by the University of Iowa Hygienic
Laboratory. All of these analytical measures ensure the water
reaching homes is of drinking -water quality.
Plant Operations
and Maintenance
Funding
Summary
FY 2019 Actual
FY 2020 Budget
FY 2021 Requested
Expenditures
$2,427,854
$2,468,782
$2,510,781
Resources
$1,716
$—
$—
Plant Operations and Maintenance
Position Summa
FY 2021
Electronic Technician
1.00
Equipment Mechanic
1.00
Plant Operator II
1.00
Plant Operator IV
6.00
Total FT Equivalent Employees
9.00
Performance Measures
City Council Goal: Sustainable Environment
Performance Measure (KPI) Target FY18 FY19 FY20 Performance
Actual Actual Estimate Indicator
1 Activity Objective: Provide water treatment and distribute high -quality, clean drinking water that
meets or exceeds drinking water regulations.
# of Regulatory Compliance as No
Violations
0 0
0 0
Water treated and produced (MGD/Plant
O&M)
1.1 0.79
0.75 0.75
Cost effectiveness ratio of the treatment
operation. (O&M costs, thousands per
million gallons)
1.0 0.94
0.99
1.03
The 2018 Water Quality Report can be downloaded at: http://www.cityofdubuque.org/waterquality
-16-
WATER DEPARTMENT
Water Distribution
Mission & Services
The function of the Water Distribution Team is to safely transport potable water from the source to point of use.
Distribution is also responsible for the machinery, equipment, materials and personnel required to repair main
breaks; install water mains, control valves and fire hydrants and assist other sections of the Water Department. It
is our goal to operate and maintain a water distribution system consistent with established procedures recognized
by the American Water Works Association for efficient management practices and to meet Federal, State and
local rules and regulations.
Water Distribution
Funding Summary
FY 2019 Actual
FY 2020 Budget
FY 2021 Requested
Expenditures
$2,691,664
$2,328,838
$2,817,199
Resources
$9,299,582
$10,378,220
$11,192,514
Water Distribution Position Summary
FY 2021
Equipment Operator II
2.00
Water Distribution Maintenance Worker
4.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
9.57
Performance Measures
City Council Goal: Financially Responsible, High -Performance Organization
Performance Measure (KPI) Target
FY18 FY19 FY20 Performance
Actual Actual Estimate Indicator
1 Activity Objective: Ensure the integrity of the distribution system piping system.
# of breaks per 100 miles of pipe
<11 21 19 23
Operation & 10% of system valves
annually
Hydrant effectiveness (out of service rate)
<1% or 25FH
O&M costs for water per 100 miles of pipe
(thousands per 100 miles)
775 128* 134* 775
<1% <1% 0% <1%
<343** 398 311 508
" 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 325 miles of water mains ranging in
diameter from 4" up to 30"; 7,750 control valves; and 2,541 fire hydrants
-17-
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 2019 Actual
FY 2020 Budget
FY 2021 Requested
Expenditures
$517,031
$494,598
$539,806
Resources
$151,704
$119,138
$141,279
Water Meters Position Summary
FY 2021
Water Meter Repair Worker I
2.00
Water Meter Repair Worker 11
1.00
Water Meter Inspector
0.00
Water Distribution Maintenance Worker
1.00
Total Full -Time Equivalent Employee's
4.00
Performance Measures
City Council Goal: Sustainable Environment
1
Performance Measure (KPI) Target
FY18 FY19 FY20 Performance
Actual Actual Estimate Indicator
Activity Objective: Minimize the possibility of contamination in the distribution through the
installation of backflow prevention devices.
High Hazard services, by definition, to
participate in the backflow prevention 100% 98%
program
99%
98%
C�]
City Council Goal: Financially Responsible, High -Performance Organization
1
Activity Objective: Respond to customer inquiries in a timely manner to maintain consumer
confidence in the water utility.
Respond to technical meter service
issues per 1,000 accounts
<150 137 178 199
Enhanced meter reading accuracy, larger
users: O&M on all large meters (>3") per 24/yr N/A 12/yr
AWWA standards (Ig meter/yr)
24/yr E4J
-18-
Recommended Operating Revenue Budget - Department Total
42-WATER
Fund
Account
Account Title
FY18 Actual
Revenue
FY19 Actual
Revenue
FY20 Adopted
Budget
FY21 Recomm'd
Budget
640 43110 INVESTMENT EARNINGS
43 USE OF MONEY AND PROPERTY - Total
640 44405 FEMA PUBLIC ASSISTANCE
VTERGOVERMEN
640 45701 STATE GRANTS
MILLT GRANTS
640 51105
METER RATES
640 51106 UB REFUND CLEARING ACCT
640 51107 UNAPPLIED CREDITS
640 51110 FLAT RATES
640 51111 FLAT RATE KEY WEST
640 51115
640 51125
640 51130
640 51135
640 51140
640 51145
640 51146
640 51165
640 51170
640 51175
640 51176
640 51177
640 51180
640 51215
640 51310
640 51330
CHARGES FOR SERVICES - Total
640
640
640
640
640
53
640
640
640
640
53201 REFUNDS
53605 MISCELLANEOUS REVENUE
53615 DAMAGE CLAIMS 21,265
53620 REIMBURSEMENTS -GENERAL 5,691
53630 SALES TAX COLLECTION 485,981
MISCELLANEOUS it -Total 12,937
54109 SALVAGE SALES 1,847
54210 GO BOND PROCEEDS 1,155,899
54220 BOND DISCOUNT 16,854
54230 SRF GO BOND PROCEEDS
OTHER FINANCING SOURCES - Total
WATER - Total
51,283
51,283
2,453
82,505
82,505
0
327
76,061
74,254
7,943,791 8,063,877 8,161,223 8,990,033
45 0 0 0
11,374 24,104 11,374 24,104
18,389 20,769 18,389 20,769
123,765 13,233 0 0
FIRE PROTECTION RATES 170,410 174,459 170,410 174,459
TAPS-3/4 & 1 INCH 64,217 26,591 33,000 26,591
CONNECT CHG LARGE SERVICE 16,655 35,121 14,500 35,121
CONNECT CHG FRONT FOOTAGE 99,495 144,708 55,000 55,000
METER SALES -REMOTES 13,218 16,283 13,500 16,000
SALE OF METERS 12,513 21,711 12,500 22,000
SALE OF UFR DEVICES 7,825 9,506 5,600 9,500
MAINTENANCE CHARGES 10,306 6,757 7,300 7,300
REPAIR OF METERS 12,902 17,123 12,500 17,000
SHUT OFF PENALTIES 18,660 19,368 18,660 18,660
METER TAMPERING FEE 1,006 628 1,006 628
CALL OUT CHARGE 1,335 750 1,335 750
CROSS CON. CNTLADMIN FEE 71,357 73,578 74,175 76,025
LATE PAYMENT PENALTY 84,393 95,739 84,383 95,739
PERMIT 101,495 141,804 101,495 103,795
RAMP ASSIGNED (6,262) 0 0 0
8,796,350 9,693,474
0 4,294 0 0
0 75 0 0
29,125 12,500 12,500
16,878 364 364
418,776 520,583 461,701
469,148 533,447 474,565
1,606 1,500 1,500
13,311 0 0
603 0 0
0 0 1,090,000 1,090,000
91,500
-19-
Recommended Operating Expenditure Budget - Department Total
42-WATER
Fund
Account
Account Title
FY18 Actual
Expense
FY19 Actual
Expense
FY20 Adopted
Budget
FY 21 Recomm'd
Budget
250 61010 FULL-TIME EMPLOYEES
640 61010 FULL-TIME EMPLOYEES
640 61020 PART-TIME EMPLOYEES
640 61030 SEASONAL EMPLOYEES
250 61050 OVERTIME PAY
640 61050 OVERTIME PAY
640 61071 HOLIDAY PAY -OVERTIME
640 61072 TANK CLIMBING PAY
640 61091 SICK LEAVE PAYOFF
640 61092 VACATION PAYOFF
640 61096 50% SICK LEAVE PAYOUT
250 61310 IPERS
640 61310 IPERS
250 61320 SOCIAL SECURITY
640 61320 SOCIAL SECURITY
250 61410 HEALTH INSURANCE
640 61410 HEALTH INSURANCE
640 61415 WORKMENS' COMPENSATION
250 61416 LIFE INSURANCE
640 61416 LIFE INSURANCE
640 61640 SAFETY EQUIPMENT
640 61650 MEAL ALLOWANCE
640 61660 EMPLOYEE PHYSICALS
1,187 0
1,229,655 1,280,652
4,953 39,623
7,638 18,960
163
122,458 137,603 161,724 164,397
131 0 0 0
104,048 108,449 133,505 134,259
503 0 0 0
381,097 357,750 281,952 319,696
94,589 87,466 74,335 78,771
3 0 0 0
913 928 1,375 1,430
2,221 1,427 4,750 4,750
1,618 758 500 0
1,848 1,802 950 1,804
0
1,539,445
46,318
15,154
0
1,613,930
28,634
15,326
0
641 0 0
109,065 108,641 94,040 94,040
24,605 21,298 17,000 17,000
120 420 1,200 1,200
29,311 36,346 32,007 29,299
34,719 587 0 0
0 0 0 2,097
0 0 0
61- WAGES AND BENEFITS
2,151,486 2,202,709
2,404,255 2,506,633
640 62010 OFFICE SUPPLIES 3,028 3,793 3,205 3,306
640 62011 UNIFORM PURCHASES 17,152 19,828 17,152 17,152
640 62030 POSTAGE AND SHIPPING 2,472 2,022 2,149 2,721
640 62033 HAND TOOLS/EQUIPMENT 8,637 4,517 5,775 8,809
640 62034 REPAIR PARTS/SUPPLIES 4,373 7,954 4,373 5,363
640 62036 CONSTRUCTION SUPPLIES 4,012 4,774 3,827 4,093
640 62050 OFFICE EQUIPMENT MAINT 0 0 2,698 0
640 62061 DP EQUIP. MAINT CONTRACTS 17,608 20,268 20,560 19,858
640 62062 JANITORIAL SUPPLIES 4,873 3,942 4,764 4,953
640 62063 SAFETY RELATED SUPPLIES 3,050 3,199 3,050 3,111
640 62064 ELECTRICAL SUPPLIES 9,808 17,727 9,800 10,664
640 62065 LAB SUPPLIES 15,757 11,430 15,757 16,075
640 62066 PLUMBING MATERIALS 2,415 2,746 2,390 2,465
640 62090 PRINTING & BINDING 1,592 2,017 1,521 1,677
640 62110 COPYING/REPRODUCTION 4,022 2,568 4,054 4,023
640 62130 LEGAL NOTICES & ADS 1,267 1,953 705 1,362
640 62170 SUBSCRIPTIONS -BOOKS -MAPS 2,208 218 914 2,256
640 62190 DUES & MEMBERSHIPS 3,612 3,770 5,605 4,953
640 62204 REFUNDS 8,828 5,786 6,284 5,911
640 62206 PROPERTY INSURANCE 67,141 56,713 66,812 59,548
640 62207 BOILER INSURANCE 120 0 120 0
640 62208 GENERAL LIABILITY INSURAN 18,419 19,377 20,087 20,346
640 62210 SALES TAX 501,222 410,251 520,583 461,701
640 62310 TRAVEL -CONFERENCES 4,188 83 6,950 6,000
-20-
Recommended Operating Expenditure Budget - Department Total
42-WATER
Fund
Account
Account Title
FY18 Actual
Expense
FY19 Actual
Expense
FY20 Adopted
Budget
FY 21 Recomm'd
Budget
640 62320
640 62340
640 62360
640 62411
640 62412
640 62414
640 62415
640 62421
640 62423
640 62424
640 62431
640 62434
640 62435
640 62436
640 62437
640 62438
640 62511
640 62521
640 62522
640 62528
640 62611
640 62613
640 62614
640 62615
640 62628
640 62630
640 62631
640 62632
640 62633
640 62638
640 62639
640 62663
640 62664
640 62667
640 62669
100 62671
640 62671
640 62675
640 62676
640 62692
640 62696
640 62713
640 62716
640 62721
640 62726
640 62731
640 62732
640 62746
TRAVEL -CITY BUSINESS
MILEAGE/LOCAL TRANSP
EDUCATION & TRAINING
UTILITY EXP-ELECTRICITY
UTILITY EXP-GAS
UTILITY EXP-FUEL OIL
UTILITY EXPENSE STORMWATR
TELEPHONE
TELECOMMUNICATION CG
RADIO/PAGER FEE
PROPERTY MAINTENANCE
HVAC MAINTENANCE
ELEVATOR MAINTENANCE
RENTAL OF SPACE
BARRICADE RENTAL
FIRE SUPPRESSION
FUEL, MOTOR VEHICLE
MOTOR VEHICLE MAINT.
VEHICLE MAINT., ACCIDENT
MOTOR VEH. MAINT. OUTSOUR
MACH/EQUIP MAINTENANCE
METER MAINTENANCE
EQUIP MAINT CONTRACT
MACH/EQUIP MAINT. OUTSOUR
INSTRUMENTATION MAINT
FLUORIDE
LIME
PHOSPHATE
CHLORINE
POLYMER
LIQUID CO2/02
SOFTWARE LICENSE EXP
LICENSE/PERMIT FEES
DATA SERVICES
PROGRAMMING
MISC. OPERATING SUPPLIES
MISC. OPERATING SUPPLIES
VALVES
PIPE -SPECIAL FITTINGS
LANDFILL FEES
OUTSIDE COLLECTOR EXPENSE
LEGAL SERVICES
CONSULTANT SERVICES
FINANCIAL CONSULTANT
AUDIT SERVICES
MISCELLANEOUS SERVICES
TEMP HELPCONTRACT SERV.
ONE CALL OPERATION
20 0 1,425
4,513 2,366 4,574
6,669 12,778 12,000
628,223 668,403 628,223
35,021 36,825 35,021
0 0 1,500
192 314
9,717 11,421
6,244 8,180
2,559 2,667
45,560 54,390
218
12,238
7,500
6,481
65,560
1,135
4,674
22,213
678,511
37,467
1,500
220
12,480
8,180
6,680
36,995
0 5,688 0 0
1,540 439 1,540 2,000
1,819 2,119 1,819 1,819
8,927 9,034 8,927 8,927
0 1,020 0 0
23,977 33,593 23,978 24,625
30,764 32,596 24,545 31,381
0 182 0 0
712 856 726 726
69,826 87,994 69,816 83,952
877 6,891 10,000 10,000
0 306 0 0
1,450 (93) 1,450 1,450
19 12,544 1,500 0
10,433 9,736 10,450 9,500
288,125 266,839 310,000 310,503
64,561 61,893 65,000 65,000
37,474 34,661 40,000 37,480
8,176 5,984 8,500 8,180
17,016 19,079 16,500 17,325
1,026 1,647 88,625 64,701
7,159 7,151 7,159 7,159
1,622 2,502 5,400 120
4,491 5,219 19,829 0
25 0 0 0
1,594 0 0 0
24,192 64,236 24,192 44,192
79,332 89,509 79,332 79,332
70 990 70 70
5,418 3,192 5,418 3,192
6,549 891 0 0
33,464 47,769 0 62,464
7,905 0 0 0
3,000 3,200 4,100 3,200
37,454 26,291 40,000 47,932
0 13,531 0 0
5,358 5,807 5,358 5,358
-21-
Recommended Operating Expenditure Budget - Department Total
42-WATER
Fund
Account
Account Title
FY18 Actual
Expense
FY19 Actual
Expense
FY20 Adopted
Budget
FY 21 Recomm'd
Budget
640
640
640
62765
62767
62780
GRANTS
ENVIRON. TESTING/MON.
HAULING SERVICES
5,731
41,604
136,887
2,868
39,892
151,610
15,000
60,000
148,250
15,000
41,604
157,815
62 - SUPPLIES AND SERVICES
2,413,097 2,459,947 2,601,359 2,621,409
640 71120 PERIPHERALS, COMPUTER 0 3,079 950
640 71123 SOFTWARE 20,889 24,239 0 45,000
640 71124 COMPUTER 0 125 0 950
640 71225 SHELVING 894 144 0 0
640 71312 VAN/PICKUP/WAG REPL 0 81,369 0 0
640 71314 TRUCK -REPLACEMENT 0 0 80,000 290,000
640 71318 HEAVY EQUIP -REPLACEMENT 0 0 0 220,000
640 71329 VEHICLE ACCESSORIES 0 19,012 0 0
640 71410 SHOP EQUIPMENT 651 1,464 1,000 0
640 71413 LABORATORY EQUIPMENT 685 366 3,000 5,800
640 71415 SAWS 0 0 3,000 4,200
640 71419 TAPPING MACHINE 0 8,550 48,000 0
640 71510 HYDRANTS 13,949 32,054 0 31,500
640 71511 PUMPS 3,351 828 16,000 15,000
640 71515 WATER METER PRODUCT 0 0 0 176,661
640 71516 LARGE WATER METERS 53,752 100,705 102,000 102,000
640 71520 HVAC 0 878 0 0
640 71550 MISCELLANEOUS EQUIPMENT 0 45,525 57,900 30,000
640 72111 GAS SAFETY MONITOR 133 1,853 0 950
640 72410 PAGER/RADIO EQUIPMENT 0 414 1,200 0
640 72415 ELECTRONIC DATA COLLECTOR 0 6,095 0 0
640 72418 TELEPHONE RELATED 674 269 3,730 2,450
640 72515 TEST EQUIPMENT, OTHER 115 0 0 0
0
71 - EQUIPMENT
95,093 326,969 316,780 924,511
640 72115 BARRICADES/WARN SIGNALS 307 0 0 0
72 - EQUIPMENT
307 0 0 0
640 73211 CONST.CONTR-NOT BLDG 291,422 586,373 420,000 415,000
73 - CIP EXPENDITURES
291,422 586,373 420,000 415,000
640 74111 PRINCIPAL PAYMENT 1,857,435 2,192,687 2,746,524 2,967,689
640 74112 INTEREST PAYMENT 701,272 867,092 942,775 893,703
74 - DEBT SERVICE
2,558,707 3,059,778
3,689,299 3,861,392
640 91100 TO GENERAL 407,567 548,056 597,380 567,194
640 91740 TO WATER CONSTRUCTION 1,157,000 935,000 400,000 550,000
91 - TRANSFER TO
1,564,567 1,483,056 997,380 1,117,194
42 - WATER TOTAL 9,074,678 10,118,832 10,429,073 11,446,139
-22-
Recommended Expenditure Budget Report by Activity & Funding Source
42-WATER
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
SUPPLIES AND SERVICES
TRANSFER TO
11,703
1,564,567
9,853
1,483,056
11,702
997,380
9,888
1,117,194
lit UNDISTRIBUTED
1,576,270 1,492,909 1,009,082 1,127,082
WATER ADMINSTRATION - 42100
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
DEBT SERVICE
EQUIPMENT
SUPPLIES AND SERVICES
WAGES AND BENEFITS
2,558,707
580,244
235,277
3,059,778
269
496,552
252,623
3,689,299
543,873
313,683
3,861,392
45,350
532,554
332,396
WATER ADMINSTRATION
3,374,228 3,809,223
METERS - 42300
4,546,855
4,771,692
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
EQUIPMENT 21,934 108,849 29,446 117,350
SUPPLIES AND SERVICES 19,562 35,552 67,575 67,695
WAGES AND BENEFITS 253,720 372,630 397,577 354,761
METERS
295,216 517,031
PLANT OPER. & MAINT - 42400
1
494,598
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
EQUIPMENT 5,399 2,428 6,742 47,450
SUPPLIES AND SERVICES 1,485,130 1,566,062 1,612,118 1,590,927
WAGES AND BENEFITS 952,608 859,365 849,922 872,404
PLANT OPER. & MAINT
2,443,137 2,427,854 2,468,782
SNOW & ICE CONTROL - 42420
2,510,781
FUNDING SOURCE: ROAD USE TAX
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
WAGES AND BENEFITS
2,628 0
SNOW & ICE CONTROL
2,628
WATER DISTR. SYSTEM - 42700
0
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
CIP EXPENDITURES 2,452 14,430 - 0
EQUIPMENT 15,510 137,040 190,592 447,700
SUPPLIES AND SERVICES 284,640 329,196 286,091 295,345
WAGES AND BENEFITS 707,254 718,091 843,073 947,072
-23-
Recommended Expenditure Budget Report by Activity & Funding Source
42-WATER
WATER DISTR. SYSTEM
1,009,856 1,198,755
AUTO MTR RD SYS MNT PROG - 42710
1,690,117
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
CIP EXPENDITURES 5,500 38,742 0
AUTO MTR RD SYS MNT PROG
5,500 38,742
PUMP REPLC VACUUM FILTER - 42713
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
EQUIPMENT
15,000 15,000
rim
REPLC VACUUM FILTER lin
FIRE HYDRANT PAINTING - 42720
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
SUPPLIES AND SERVICES 202 5,000 1,000
FIRE HYDRANT PAINTING 3-
202
GIS MAINT/UPDATES - 42730
1,000
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
SUPPLIES AND SERVICES
25,000 25,000
IS MAINT/UPDATES
SERVICE LINE ASSIST - 42735
T- MME
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
SUPPLIES AND SERVICES
26,062 19,663
35,000 35,000
SERVICE LINE ASSIST
26,062 19,663
VALVE REPLACEMENT - 42745
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
CIP EXPENDITURES
SUPPLIES AND SERVICES
12,250 22,144 25,000 20,000
20,000
VALVE REPLACEMENT 12,250 22,144
- WATER MAIN REPLACEMENTS - 42755
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
CIP EXPENDITURES
251,766 490,963 350,000 350,000
WATER MAIN REPLACEMENTS
251,766 490,963
WATER METER EXCHANGE - 42760
350,000
FUNDING SOURCE: WATER UTILITY OPERATION
-24-
Recommended Expenditure Budget Report by Activity & Funding Source
42-WATER
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
EQUIPMENT
52,557 78,383
75,000 251,661
WATER METER EXCHANGE
52,557 78,383
WATER LEAK REPAIR GRANT - 42765
251,661
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
SUPPLIES AND SERVICES
GRANT
5,731 2,868 5,000 5,000
ir
5,731 2
COUNTY WATER ASSISTANCE - 42766
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
SUPPLIES AND SERVICES
10,000 10,000
COUNTY WATER ASSISTANCE
WATER VALVE BOX MAINT - 42770
-.IIM10,000
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
CIP EXPENDITURES
19,331 12,325 20,000 20,000
WATER VALVE BOX MAINT
19,331 12,325
COMPUTERIZED LEAK SURVEY - 42785
20,000
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
SUPPLIES AND SERVICES 29,000
COMPUTERIZED LEAK SURVEY
WATER METER TESTING - 42790
...=
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
CIP EXPENDITURES
123 7,769 25,000 25,000
ATER METER TESTING 123 25,000
PCARD CLEARING - 99999
FUNDING SOURCE: GENERAL
Account
FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget
SUPPLIES AND SERVICES 25
CARD CLEARING WATER $ 25 $ — $
WATER TOTAL $9,074,678 $10,118,832
$10,429,073
0
$11,446,139
-25-
CITY OF DUBUQUE, IOWA
DEPARTMENT DETAIL - PERSONNEL COMPLEMENT
42 WATER DEPARTMENT
FD JC WP-GR JOB CLASS
FY 2019 FY 2020 FY 2021
FTE BUDGET FTE BUDGET FTE BUDGET
61010 Full Time Employee Expense
640 3275 GE-40 WATER DEPARTMENT MANAGER 1.00 $ 106,616 1.00 $ 109,298 1.00 $ 110,505
640 3200 GE-37 WATER DISTRIBUTION SUPERVISOR 1.00 $ 88,009 1.00 $ 90,025 1.00 $ 91,659
640 2950 GE-33 WATER ENGINEERING ASSISTANT 1.00 $ 72,779 1.00 $ 74,429 1.00 $ 75,252
640 2650 GE-31 FOREMAN - WATER DISTR. 1.00 $ 59,221 1.00 $ 67,509 1.00 $ 68,265
640 2610 GE-30 GIS SPECIALIST 1.00 $ 62,541 1.00 $ 64,050 1.00 $ 64,679
640 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.00 $ - 1.00 $ 39,153 1.00 $ 49,429
640 NA-49 WATER METER INSPECTOR 1.00 $ 56,327 0.00 $ - 0.00 $ -
640 2400 0E-16 ELECTRONIC TECHNICIAN 1.00 $ 63,165 1.00 $ 64,610 1.00 $ 65,319
640 2800 0E-14 EQUIPMENT MECHANIC 1.00 $ 60,041 1.00 $ 61,862 1.00 $ 62,691
640 2550 0E-13 WATER PLANT OPR CERT GR III/IV 1.00 $ 58,579 0.00 $ - 0.00 $
640 2475 0E-12 WATER PLANT OPERATOR CRT GR II 3.00 $ 168,592 1.00 $ 57,751 1.00 $ 58,395
640 2475 0E-12 WATER PLANT OPERATOR CRT GR IV 3.00 $ 185,509 6.00 $ 380,552 6.00 $ 384,585
640 2305 0E-10 EQUIPMENT OPERATOR II 2.00 $ 108,273 2.00 $ 110,767 2.00 $ 116,147
640 1775 0E-09 WATER METER REPAIRWORKER I 2.00 $ 110,396 3.00 $ 163,136 2.00 $ 110,462
640 0E-14 WATER METER REPAIRWORKER II 1.00 $ 59,453 0.00 $ 1.00 $ 61,474
WATER DISTR MAINTENANCE
640 1476 0E-09 WORKER 4.00 $ 204,648 5.00 $ 256,303 5.00 $ 266,434
TOTAL FULL TIME EMPLOYEES 24.00 $ 1,464,149 25.00 $ 1,539,445 25.00 $ 1,585,296
61020 Part -Time Employee Expense
640 225 GE-25 SECRETARY 0.50 $ 19,136 0.00 $ - 0.00 $ 640 1476 0E-09 WATER DISTR MAINTENANCE 0.00 $ - 0.00 $ - 0.50 $ 25,233
640 0E-07 WATER METER SERVICE WORKER I 0.80 $ 41,080 0.80 $ 42,954 0.00 $ 640 2050 0E-06 CUSTODIAN I 0.07 $ 3,289 0.07 $ 3,364 0.07 $ 3,401
TOTAL PART TIME EMPLOYEES 1.37 $ 63,505 0.87 $ 46,318 0.57 $ 28,634
61030 Seasonal Employee Expense
640 NA-34 GIS INTERN
TOTAL SEASONAL EMPLOYEES
0.50 $ 16,671 0.50 $ 15,154 0.50 $ 15,326
0.50 $ 16,671 0.50 $ 15,154 0.50 $ 15,326
TOTAL WATER DEPARTMENT 25.87 $ 1,544,325 26.37 $ 1,600,917 26.07 $ 1,629,256
-26-
ACCT FD JC WP-GR
Water Administration -FT
64042100 61010 640 2610 GE-30
64042100 61010 640 3275 GE-40
64042100 61010 640 GE-25
Water Administration -PT
64042100 61020 640 225 GE-25
Water Administration -SEASONAL
64042100 61030 640 NA-34
CITY OF DUBUQUE, IOWA
ACTIVITY PERSONNEL COMPLEMENT SUMMARY
POSITION CLASS
GIS SPECIALIST
WATER DEPARTMENT MANAGER
CONFIDENTIAL ACCOUNT CLERK
Total
SECRETARY
Total
GIS INTERN
Total
Water Meters -FT
64042300 61010 640 1775 OE-09 WATER METER REPAIRWORKER I
64042300 61010 640 OE-14 WATER METER REPAIRWORKER II
WATER DISTR MAINTENANCE
WORKER
64042300 61010 640 NA-49 WATER METER INSPECTOR
Total
64042300 61010 640
Water Meters -PT
WATER METER SERVICE
64042300 61020 640 1775 OE-07 WORKER I
Water Plant Operation -FT
64042400
64042400
64042400
64042400
64042400
61010
61010
61010
61010
61010
640 2475
640 2550
640
640 2800
640 3015
Water Distribution -FT
64042700
64042700
64042700
64042700
64042700
61010
61010
61010
61010
61010
OE-12
OE-13
OE-13
OE-16
OE-14
640 1476 OE-09
640 2305 OE-10
640 2650 GE-31
640 2950 GE-33
640 3200 GE-37
Water Distribution - PT
64042700 61020 640 1476 OE-09
64042700 61020 640 2050 GD-03
Total
WATER PLANT OPERATOR CRT
no II
WATER PLANT OPR CERT GR III/IV
WATER PLANT OPERATOR CRT
no 1\/
ELECTRONIC TECHNICIAN
EQUIPMENT MECHANIC
Total
WATER DISTR MAINTENANCE
WORKER
EQUIPMENT OPERATOR II
FOREMAN - WATER DISTR.
WATER ENGINEERING ASSISTANT
WATER DISTRIBUTION
ci ioCoxncno
Total
WATER DISTR MAINTENANCE
WORKER
CUSTODIAN I
Total
FY 2019
FTE BUDGET
FY 2020 FY 2021
FTE BUDGET FTE BUDGET
1.00
1.00
0.00
$ 62,541
$ 106,616
$ -
1.00
1.00
1.00
$ 64,050
$ 109,298
$ 39,153
1.00
1.00
1.00
$ 64,679
$ 110,505
$ 49,429
2.00 $ 169,157 3.00 $ 212,501 3.00 $ 224,613
0.50 $ 19,136 0.00 $
- 0.00 $
0.50 $ 19,136 0.00 $
- 0.00 $
0.50 $ 16,671 0.50 $ 15,154 0.50 $ 15,326
0.50 $ 16,671 0.50 $ 15,154 0.50 $ 15,326
2.00 $ 110,396 3.00 $ 163,136 2.00 $ 110,462
1.00 $ 59,453 0.00 $ 1.00 $ 61,474
0.00 $ - 1.00 $ 52,691 1.00 $ 54,178
1.00 $ 56,327 0.00 $ 0.00 $
4.00 $ 226,176 4.00 $ 215,827 4.00 $ 226,114
0.80 $ 41,080 0.80 $ 42,954 0.00 $
0.80 $ 41,080 0.80 $ 42,954 0.00 $
3.00
1.00
3.00
1.00
1.00
$ 168,592
$ 58,579
$ 185,509
$ 63,165
$ 60,041
1.00
0.00
6.00
1.00
1.00
57,751
380,552
64,610
61,862
1.00
0.00
6.00
1.00
1.00
$ 58,395
$ $ 384,585
$ 65,319
$ 62,691
9.00 $ 535,886 9.00 $ 564,775 9.00 $ 570,990
4.00 $ 204,648
2.00 $ 108,273
1.00 $ 59,221
1.00 $ 72,779
1.00 $ 88,009
4.00
2.00
1.00
1.00
1.00
$ 203,612
$ 110,767
$ 67,509
$ 74,429
$ 90,025
4.00 $ 212,256
2.00 $ 116,147
1.00 $ 68,265
1.00 $ 75,252
1.00 $ 91,659
9.00 $ 532,930 9.00 $ 546,342 9.00 $ 563,579
0.00 $ - 0.00 $ - 0.50 $ 25,233
0.07 $ 3,289 0.07 $ 3,364 0.07 $ 3,401
0.07 $ 3,289 0.07 $ 3,364 0.57 $ 28,634
TOTAL WATER DEPARTMENT 25.87 $ 1,544,325 26.37 $ 1,600,917 26.07 $ 1,629,256
-27-
Capital Improvement Projects by Department/Division
CIP Number Capital Improvement Project Title
FY 18 Actual
Expense
FY 19 Actual
Expense
FY 20 Adopted FY 21 Recomm'd
Budget Budget
7401339 SCADA SYSTEM UPGRADE
7401405 WATER MAIN REPLACEMENTS
7401415 SHALLOW WELL REHAB
7401672 ROOSEVELT RD MAIN EXT. 156,349
7401829 SECURITY UPGRADES
7402030 VACUUM FILTER BACK-UP
7402052 WATER METER REPL PROGRAM
7402234 SOUTHGATE WATER
7402349 MANSON ROAD WATER MAIN 27
7402524 ONLINE PROCESS ANALYZER 42,577
7402525 N CASCADE WATER MAIN 40,237
7402526 SRF GREEN ALLEY 8,679
7402527 GENERATOR 1,008 4,936
7402594 SW ARTERIAL MAIN EXT 3,521
7402595 CREEK CROSSING RESTORE -
7402596 MAIN RELOC SEWER MANHOLE 1,734
7402653 LIME SLAKER REPLACE STUDY
7402654 FIRE HYDRNT ASSMBLY SW PG 32,905
7402655 MAINT WTR MN - RETAIN WAL
7402656 WATER STORAGE TANK COATIN
7402657 WTR MN UPGRADES - STREET
7402658 WTR MN REPLACE - SWR CONS 160,712
7402703 WEST RURAL WATER PURCHASE 2,656,076 366,172
7402704 TIMBER RIDGE WATER MAIN 870,529 44,252
7402705 GRANDVIEW/LORAS INTER IMP 11,330
7402713 RPR/MAINT WATER LINE ISLA 3,495
7402714 BULK CO2 TANK REPLACEMENT
7402734 RURAL WATER ENGLISH PUMP 944,041 102,693
7402744 PUBLIC LEAD LINE WATER RE
7402745 TAMARAK FRONTAGE WATER MN 478,151
7402746 COTTINGHAM RD WATER MAIN 21,179
7402747 CHESTERFIELD DR WATER MAI -
7402748 EPWP TRANSFORMER SAFETY 22,230
7402786 DAVENPORT RD EXT/PMP STAT -
7402814 BRIARWOOD SUB MAIN EXT
7402821 LANDFILL WATER MAIN EXT
7402836 MAIN EXT TO NEW DEV
7402837 WATER PLANT ASSESS PLAN
7402838 ALTHAUSER & EAGLE WTR MN 0 0
7402839 WATER PLANT IMPROVEMENTS 0 0
WATER 4,691,510 1,744,577
505,000
10,565 158,156 209,000
287,451
7,080 79,845 176,661
804,100
855,000
16,000
122,500
61,833
1,085,937
15,000
100,000
0
0
495,000
271,375
250,000
35,000
20,000
20,000
25,000
65,000
122,470
362,500
187,813
121,500
307,500
115,000
151,065
20,000
-28-
PRGRM/
DEPT PROJECT DESCRIPTION FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 TOTAL PAGE
WATER DEPARTMENT
Business Type
Westside Water System Service
Line Installation/Fire Hydrant
Install/Purchase $ 65,000 $- $- $- $- $ 65,000 99
Water Meter Replacement
Program $ 176,661 $ 182,511 $ 188,360 $ 194,210 $ 200,060 $ 941,802 100
Manhole Replacement Rehab $- $ 25,000 $- $ 25,000 $- $ 50,000 101
Water Main Upgrades during
Street General Repairs $- $ 20,000 $- $ 25,000 $- $ 45,000 102
Maintenance of Public Water
Mains during Stone Retaining
Wall Repair $ 20,000 $- $ 22,550 $- $ 22,550 $ 65,100 103
Fire Hydrant Assembly
Relocation/Replacement for the
Sidewalk Program $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,400 $ 100,400 104
Cottingham Road Water Main $ 187,813 $- $- $- $- $ 187,813 105
Southwest Arterial Water Main
Extension $- $ 725,000 $- $1,575,000 $- $ 2,300,000 106
SCADA & Communications
Infrastructure $ 495,000 $- $- $- $- $ 495,000 108
Water Main Replacements -
Streets $ 271,375 $- $- $- $- $ 271,375 110
Public Lead Line Water
Replacement $ 122,470 $ 84,500 $ 85,000 $- $- $ 291,970 111
Water Line Extensions to New
Developments $ 307,500 $ 775,000 $- $- $- $ 1,082,500 112
Wells, Well Field, and Raw
Transmission Piping Repair $ 250,000 $- $ 90,000 $- $ 110,500 $ 450,500 113
Water Treatment Plant Condition
Assessment and Master Plan $ 115,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 155,000 114
Water Storage Tank Coating
Program $ 25,000 $ 150,000 $1,350,000 $ 100,000 $ 900,000 $ 2,525,000 115
Tamarak Park Frontage Road
Water Main $ 362,500 $- $- $- $- $ 362,500 116
West End Annexation Phase II $- $- $- $- $ 300,250 $ 300,250 117
West End Annexation Phase I $- $- $- $- $ 165,000 $ 165,000 118
Creek Crossing Restoration $ 35,000 $ 22,500 $ 25,350 $ 18,900 $ 30,000 $ 131,750 119
Landfill Frontage Rd. Water Main
Extension $ 121,500 $- $- $- $- $ 121,500 120
Althauser St. & Eagle St. Water
Main Improvements $ 151,065 $ 141,425 $- $- $- $ 292,490 121
Public Safety Way Water Main
Improvements $- $ 106,700 $- $- $- $ 106,700 122
Water Treatment Plant Boiler
Improvements $ 20,000 $- $- $- $- $ 20,000 123
WTP and Pump Station Pipe
Rehabilitation $- $ 20,000 $- $- $- $ 20,000 124
Pump Station Site Drainage
Improvements $- $- $ 15,000 $- $- $ 15,000 125
McFadden Farm Water Main
Improvement (S. Heacock Rd
from Chavenelle to Pennsylvania) $- $- $ 176,186 $ 517,410 $- $ 693,596 126
TOTAL $ 2,745,884 $2,282,636 $1,982,446 $2,485,520 $1,758,760 $ 11,255,246
-29-
This page left intentionally blank.
-30-
FISCAL YEAR 2021
BUDGET PRESENTATION
WATER
DEPARTMENT
FY 21 Budget Request Changes Due to
i -19 Pandemic
• The following presentation represents Water's FY21 budget
requests prior to the COVID-19 pandemic. This includes the rate
increase and impact to average homeowner as originally
recommended.
• In light of the pandemic, the City Manager will present an amended
FY21 Budget Recommendation on April 23, 2020:
This recommendation will include no property tax increase for
the average homeowner and no increase in the stormwater,
sanitary sewer, water, and refuse fees.
The amended recommendation will impact the following budget
request and may reduce or delay funding for some projects
Water Department
ISSION STATEMENT
The City Water Department is passionate about delivering
high quality drinking water with excellent customer service,
while meeting our customers' changing demands with
equitable and sustainable rates.
New Faces of FY2020- Welcome!
1)))) E ti
Deb Searles Steve Valentine Andrew Fonck Chad Sharkey Nick Connolly
Confidential Water Distribution Water Distribution Water Distribution Water Treatment
Account Clerk Maintenance Worker Maintenance Worker Maintenance Worker Operator
(PT)
Water Department (26.07 Full -Time Equivalents)
(1) Water
Distribution
Supervisor
(1) Water
Distribution
. Foreman
(1)
Engineering
Assistant_
(1) Meter
Repair Worker
II
(2) Equipment
Operator II
r
(5) Distribution
I Workers
(2.8) Meter
Repair Worker
I
(1) Water
Department
Manager
(1) t
Confidential
AccountCie/
(1 )
pecialis
} Plant
Operators
(0.5) GIS
Seasonal
Interns
(1) Equipment
Mechanic
(1) Electronic
Technician
FISCAL YEAR 2020
HIGHLIGHTS
• Roosevelt Street Elevated Water Tower - Under
Construction
• Tower Overall Height: 120 feet
• Capacity: 1.25 million gallons
• Increase in Zone 2 Pressure: 15psi at low water level
• Tower Contractor: MCDERMOTT INT (CB&I) $2,928,600
• Infrastructure Contactor: Portzen Construction $986,620
• Total Project Cost Est: $5,227,672 (SRF & Local Funds)
• Target Completion Date: November 2020*
FISCAL YEAR 2020
HIGHLIGHTS
• Westside Fire Hydrant
Installation Project
• CIWA Purchase
• 23 Fire Hydrants
• Awarded to Kueter
Equipment Company
• Project Cost: $171,857.50
Westside Fire Hydrant Installation ..
Utility Conflicts - Fiber Optic Dic
THE
Westside Subdivisions
id Special Achievement in CrIS
IE 2018 Award Winner
Masi apiece on the Mississippi Fire Hydrant Installation Project
HWY 20 ♦�
CEDAR CREST --- " _ �t
Z - •
•
� •
NORTH CASCADE RD e`. -
1 1t
KEY
4`,
-•.
.� -
HWY 20
BARRINGTON LAKES
WILD WOOD ESTATES
`
�
NORTH CASCADE RD ''
j
1
SWISS VALLEY RD t_
/
•wr.. ... o. �.a Map Prepared by:
r0.4G151* g w 2 City of Dubuque
:zr r. oa, =, d =,,; 0 2,500 5,000 10,000 \/ Water Department
Feet "�� 1902 Hawthorne St
�I d� 1 ,- e,�� '
.,,.,P,.N6,> °Y my �, 563-589-4291
FISCAL YEAR 2020
HIGHLIGHTS
• SCADA Upgrade Project - In
progress. Project Est:
$900,000
• Intra-Department Efficiency -
Streamlining Water Meter,
M.I.U, Tapping, and
Connection Fee Payment
Process
enn Tan
English
Roosevelt Tower
•Well6
Olympic Heights Well Hou Well
SocceriTank
John F Kennedy Rd to Soccer Tank
thrOamwd Di,donce: ISM Feet
® nt... _.
Legend
L+Giber Network
game
Aturqo mad n nun
Mamma
GaraugaIMDM
(Upper)
• Reduce Service Outages:
Southgate Drive Water Main Loop Project
SHE CITY OF
DUBS E
Legend
* Main Break
Water Main
Status
— Active
Abandoned
• Proposed
Southgate Dr Main Breaks and Proposed Mitigation
31 Main Breaks In Visible Map Extent Front 1958 to 2020. 70% Of Which Happened In The Last 20 Years
1
. 225 1221
Mete a'
003167 s es
tsRUMSKILL Ro_ Matelot
1 inch= 136feet
100 93 0 100
1420 -241
• u
200 Feel
L1I66 .tare
•205
J
2445 21r5'
r i l
Proposed Mitigation Loop Consisting
Of 260 feet Of 6" Water Main
265
fAf 2305
2216V!2'215
JSpedaI Achievement in GIS
2016 Award Winner
161
195
369
405
Map Prepared by:
City of DubugoJe
Water Department
1902 Hawthorne St
563-589-4291
FUTURE
INITIATIVES
• Reduce Service Outages:
Althauser and Eagle Street Water Main
Replacement Projects
ALTHAUSER AVENUE (2021) AND EAGLE STREET (2022)
PROPOSED 6" WATER MAIN REPLACEMENT A mien a`a=",ems
GAF`" ,may
510 FEET OF WATER MAIN, EAGLE STREET
525 FEET OF WATER MAIN, ALTHAUSER STREET
W+E
TNECITV CAP
DUB E
Mnsler�.i.vrw� the Mississippi
Map Prepared by:
City of Dubuque
Water Distribution Division
925 Kerper Court
563-589-4303
FUTURE
INITIATIVES
Support Economic Growth and Development:
Tamarack Park Phase 2 Water Main
Extension Project
DUB'the Mwrssimi
Tamarack Park Phase 2 _7""'"`h�=ooG15
E018 Awaitl Winner
o�
0 0
4� \l B/jpN2F�
Phase 2 Installation
'4
Legend
Water Main
Active
Proposed
0
Lo
0 100 200 400
600
Feet
Map Prepared by
City of Dubuque
Water Department
1902 Hawthorne St
563-589-4291
Eagle Point Water Treatment Plant
• Plant Capacity: 11- 13 MGD
• Well Capacity: 16 MGD
• Peak Day Demand: 10.7 MGD
(11/2016)
• Average Day Demand: 6.2 MGD
.moo. r.kxr no.no% �kc
Eagle Point Station - 1900
Eagle Point Pumping Station -
Addition 1923
1
Eagle Point Water Treatment Plant - 2019
Source Water Protection
Well and Well Field
Rehabilitation
Water Treatment Plant
Condition Assessment
Source Water Protection
Phase 2 Planning
FY 21 PROPOSED RATE INCREA
*Average Household = 6,000 Gallons/Month
4
5.00%
Proposed Rate
Increase over FY 20
$1.54
Monthly Bill Impact for
Average Household*
WATER ADMINISTRATION
Rate Comparison, Lime Softened Facilities Only
$40.00 $36.98 $35.79 $35.01
$33.57 $32.28 $32.16 $31.87
$30.00
$20.00
$10.00
$-
b
West Des Des
Moines Moines
di
Iowa City Ave. W/O Dubuque Cedar
Dubuque Rapids
FY21 Water Only for Average Household (6,000 gallons)
Ames
$29.60
Council
Bluffs
WATER ADMINISTRATION
• Employee Training and Development
• Professional Development
• On Boarding of New Employees
• Continuing Education Programs
• Regulatory Compliance
• Reporting, monitoring, and working with
Iowa DNR and EPA on compliance.
• Capital Improvement Planning
• Project development including
budgeting, initiation, and award through
construction completion.
FAIRCHILDCOAC6011
HING
Personalized Leadership Develoi
WATER TREATMENT PLANT OPERATIONS
• Water Production and Treatment
• Regulatory Compliance
• Water Quality - Consumer Confidence
• Source Water Protection
• Wells and the Well field
• Treatment Plant
• Water Storage and Pumping Facility
Operation and Maintenance
• Reliable Data Access and Reporting
• SCADA Communications
CITY OF DUBUQUE
WATER
.QUALITY
CONSUMER CONFIDENCE REPORT
THE CITY OF
DUB
Masierpirce on OW MiR is6ippr
Water Department
563.589.4291
www. c ityafd u bu que. arg/water
WATER PLANT OPERATIONS
•
c
E
0
0
0
c
0
2,635
0 7d 8
2,538
Water: Treated and Metered
2,640 2,538 2,579
2,061
2,494 2,392 74 3
2,011 2,025 2
Treated
1
6
2,602
Adjusted Metered
2,586
2,456
WATER PLANT OPERATIONS
25.00%
20.00%
15.00%
10.00%
5.00%
21.80%
1
Unaccounted Water (Percentage)
23.80%
9.40% 20.20%
7.20% 17.30%
2.30%
1
5.40%
19.40%
FY'12 FY'13 FY'14 FY'15 FY'16
22.80%
FY' 17
0
.Jvi0
FY'18
Water Loss Percentage, Before Master Meter Change
Water Loss Percentage, Post Master Meter Change (est.FY12 - FY18)
ui
FY'19*
WATER DISTRIBUTION
• Operation and Maintenance
• Emergency Response
• Inspection
• General Construction
• Service Line Main Taps
• Water Main Installation
• Meter Management
• Backflow Prevention
• Development Review
WATER DISTRIBUTION
150
125
100
75
50
25
0
137
Water Main Break Response
81
58
60
105
74
85
FY' 14 FY' 15 FY' 16 FY' 17 FY' 18 FY' 19 FY'20
Water Main Break Response
WATER
DISTRIBUTION
*FY 2020 to date:
92 Service Taps
New Connections
result from
community growth
such as new housing,
businesses, and
industry.
350
301
300
250
200
150
100
50
206
New Service Taps
109
179
■
278
113
272
125
L
92
FY` 12 FY'13 FY'14 FY'15 FY' 16 FY' 17* FY'18 FY'19 FY'20
WATER
DISTRIBUTION
FY19 marked the start
of all meter service
and repairs being
provided by the Water
Department.
4,500
4,000
3,500
3,000
2,500
2,000
1,500
1,000
591
Meter Service Calls
4,226
2,851
500 � 420
n
0
673 696
o
i
IL
FY'14 FY'15 FY' 16 FY'17 FY'18 FY' 19* FY' 20
Backflow Prevention Program
• •
• Administered internally by
Water Department's Carl
Plumley.
• Administrative fee $25/device
(City devices not billed).
• FY2020 revenue projected to
manage the program:
$75,275, up 1.5% from
Budget Est.
Based on 3,011 devices.
FY2020: Total Backflow Devices 3,087 (est.)
Projected, 14, 0.5% Non Billed City Devices, 76, 2.5%
Billable Devices, 2997, 97.1%
Non Billed City Devices
. Billable Devices
Projected
FY2021
RECOMMENDED
IMPROVEMENT
REQUESTS
1. Cartegraph + Work Order Management Software Licenses
Non -Recurring I $45,000
2. Smartphones - Water Distribution Crew
Non -Recurring I $5,692
3. Smartphones - Water Plant Operators Special Assignment
Recurring I$1,948
4. Tablet - Operators Special Assignment
Non -Recurring I $950 + Recurring I $120
5. Water Department Leadership Development
Recurring I $10,713
6. Cut Off Saw
Non -Recurring I $4,200
FY2021
RECOMMENDED
IMPROVEMENT
REQUESTS
(Continued)
7. Ground Penetrating Radar
Recurring I $30,000
8. Upgrade 3/4 Ton Truck to Utility Truck
Recurring I $34,028
9. Upgrade 3/4 Ton Truck to Utility Truck with Crane, Ladder Rack,
Front Mount Valve Turner & Hydraulic Motor Pump
Recurring I $40,000
10. Replace 2002 Freightliner Tandem Dump Truck to Tandem
Truck
Recurring I $40,000
11. Replace Backhoe/Loader with Skid Steer
Non -Recurring I $35,000
Water Department
FY 21 CAPITAL IMPROVEMENT PROJECTS
Project
Westside Water System Service Line Installation/Fire
Hydrant Install/Purchase
Water Meter Replacement Program
Maintenance of Public Water Mains during Stone
Retaining Wall Repair
Fire Hydrant Assembly Relocation/Replacement for the
Sidewalk Program
Cottingham Road Water Main
FY21 Cost
$ 65,000 $
$ 176,661 $
$ 20,000 $
$ 20,000 $
$ 187,813 $
SCADA & Communications Infrastructure $ 495,000 $
Water Main Replacements - Streets $ 271,375 $
Public Lead Line Water Replacement $ 122,470 $
Water Line Extensions to New Developments $ 307,500 $
Wells, Well Field, and Raw Transmission Piping Repair $ 250,000 $
Total Project Cost
65,000
941,802
65,100
100,400
187,813
495,000
271,375
291,970
1,082,500
450,500
Water Department
FY 21 CAPITAL IMPROVEMENT PROJECTS (Continued)
Water Treatment Plant Condition Assessment and
Master Plan
Water Storage Tank Coating Program
Tamarak Park Frontage Road Water Main
Creek Crossing Restoration
Landfill Frontage Rd. Water Main Extension
Althauser St. & Eagle St. Water Main Improvements
Water Treatment Plant Boiler Improvements
Project Cost
115,000 $
25,000 $
362,500 $
35,000 $
121,500 $
151,065 $
20,000 $
155,000
2,525,000
362,500
131,750
121,500
292,490
20,000
I
Goals that need work:
# of Breaks per 100 miles of
Pipe
O&M Costs for Water
Distribution per 100 miles of
pipe
Technical Meter Service Issues
per 1,000 accounts
WATER DEpARTM-NT
PERFORMANCE MEASURES
Goals Improving:
of Lost/Unaccounted for
Water
Operation of 10% of
Distribution System Valves
Annually
Hydrant effectiveness (Out
of Service Rate) <1%
Goals that are on track:
# of Regulatory Compliance
Violations, Target Zero (0)
# of Completed Annual Training
hours to support CEUs, reported
in staff hours
of Projects Completed within
the Program Budget
www.cityofdubuque.org/water