Water Department FY202 Budget PresentationCopyrighted
February 27, 2019
City of Dubuque Public Hearings # 1.
ITEM TITLE:
SUMMARY:
SUGGESTED DISPOSITION:
Water Department FY2020 Budget Presentation
ATTACHMENTS:
Description
Water Department FY2020 Budget Outline
Type
Supporting Documentation
Water Department
-1-
This page intentionally left blank.
-2-
WATER DEPARTMENT
FY 2018 FY 2019 FY 2020 % Change From
Budget Highlights Actual Budget Requested FY 2019 Budget
Expenses
Employee Expense 2,151,486 2,420,488 2,404,255 (0.7)%
Supplies and Services 2,413,097 2,495,838 2,601,359 4.2 %
Machinery and Equipment 386,822 869,690 736,780 (15.3)%
Administrative Overhead Recharges 264,683 405,172 454,496 12.2 %
Finance Utility Billing 160,396 — %
Engineering Water Maintenance Charges 31,472 20,046 20,010 (0.2)%
Payment in Lieu of Taxes 142,884 142,884 142,884 — %
Payment to Construction Fund 1,157,000 935,000 400,000 (57.2)%
Debt Service 2,558,707 3,115,807 3,689,299 18.4 %
Total Expenses 9,266,547 10,404,925 10,449,083 0.4 %
Resources
Operating Revenue
Total Resources
10,518,160 10,423,618 10,497,358
0.7 %
10,518,160
Net Operating Surplus (Deficit) 1,251,613
Personnel - Authorized FTE
Water User Fee Rate Increase
Revenue 1% Rate Increase Generates
10,423,618 10,497,358
18,693 48,275
25.57 25.87 26.37
3% 3% 5%
$ 79,438
0.7 %
29,582
Improvement Package Summary
1 of 6
This improvement package would provide funding to systematically upgrade the two ruggedized cell phones
to 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, WebQA 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.
Related Cost:
Related Cost:
Total Cost:
Water Rate Impact:
Activity: Distribution
$ 672 Water User Fees Recurring
$ 700 Water User Fees Non -Recurring
$ 1,372
0.02%
-3-
Recommend - Yes
2 of 6
This improvement package would provide funding to systematically upgrade the two ruggedized cell phones
to smartphones for the water meter 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, WebQA 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.
Related Cost: $ 672 Water User Fees Recurring Recommend - Yes
Related Cost: $ 700 Water User Fees Non -Recurring
Total Cost: $ 1,372
Water Rate Impact: 0.02%
Activity: Water Meters
3 of 6
This improvement package would provide funding for replacement of an unsupported Access database
currently used for the collection of water treatment process data. HACH WIMS is an industry standard
supported software database used to compile, track, and trend data for treatment facilities, and is also used
at the Water & Resource Recovery Center. The quote includes non-recurring costs totaling $26,980, which
includes one time set up costs of and estimated 70 hours for programming services along with 3 days of on-
site training, and SCADA interface installation and training to collect up to 10 variables. The recurring cost is
for three licensed concurrent users and would reoccur annually. The water treatment data is collected and
entered into 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 in the 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:
Related Cost:
Total Cost:
Water Rate Impact:
$ 3,120 Water User Fees Recurring
$ 26,980 Water User Fees Non -Recurring
$ 30,100
0.38%
Activity: Operations and Maintenance
-4-
Recommend - Yes
4 of 6
This improvement package would provide funding for the purchase of a water treatment plant tablet for the
purpose of entering water treatment data into new software proposed in improvement package 3. The data
is collected and entered into 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 in the 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: $ 950 Water User Fees Non -Recurring
Related Cost: $ 120 Water User Fees Recurring
Total Cost: $ 1,070
Water Rate Impact: 0.01%
Activity: Operations and Maintenance
Recommend - Yes
5 of 6
This improvement package provides funding for the purchase of a water street valve box cutter. Valve box
cutter use is for cutting around valve boxes in street pavement from asphalt over -lay program and other
valve boxes that are buried under pavement to raise the valve box flush with street paving to make valve
accessible. The street valve box cutter would be powered from the back -hoe hydraulics. The Public Works
Department currently has similar cutter for raising their manhole cover lids. This request would provide a
safer and faster means of raising valve boxes for Water staff. This improvement request supports the City
Council Goal and Priority of Sustainable Environment: Preserving and Enhancing Natural Resources,
enable the City's crews to quickly restore access to system valves improving the response to provide safe,
dependable drinking water using affordable technology for water activities.
Related Cost: $ 30,000 Water User Fees Non -Recurring Recommend - Yes
Water Rate Impact: 0.38%
Activity: Water Distribution
6 of 6
This improvement package would provide six additional American Water Works Association (AVVWA)
memberships. AVN/VA membership would provide membership in Dubuque's local Section for attendance at
local and regional AVN/VA meetings to discuss policy and standards. In addition, membership would provide
access to training, networking, and community engagement opportunities. In addition, each member would
have a subscriptions to Journal —American Water Works Association presenting the latest industry
research, peer-reviewed articles, and information on all aspects of the water profession, and Opflow to gain
monthly hands-on guidance for smoother, more efficient utility operations from the publication that focuses
on the best emerging and established technologies. Members also would have access to the the latest
technical reports and tools and special -engagement webinars, along with discounts up to 33% on technical
resources and educational opportunities in the AVVWA Store. The City of Dubuque is also the host of the
state AVVWA conference every 4 years. AVN/VA is also the provider of the Standards the City adheres to
manage, operate and maintain its water system. This request supports the City Council Goal and Priority of
Sustainable Environment: Preserving and Enhancing Natural Resources to provide safe, dependable
drinking water.
Related Cost Savings:
$1,380 Water User Fees Recurring Recommend - Yes
Water Rate Impact: 0.02%
Activity: Administration/Meters/Plant Operations/Distribution
-5-
7 of 7
This improvement package would provide the elimination of the Part -Time Confidential Account Clerk and
the creation of a Full -Time Confidential Account Clerk at the City's Water Department. The Water
Department processes over 3,650 calls through the water plant and the distribution office; accounts payable
including approximately 700 purchase orders, 500 to 600 procurement cards purchases, and bi-monthly
payroll meeting union contract requirements equating to over 1,200 hours of work per year. In addition, from
an estimated 3,650 calls handled by the shift operator, department manager or the engineering assistant in
the distribution office, over 90% require a distribution crew member or members be dispatched to respond
to a water distribution system need, such as a water quality issue, main break, or private contractor request
for information.
For each call, a work order is created in WebQA, by a water plant operator, department manager, or a
distribution staff member. The WebQA alerts the water distribution foreman to the issue where he is able to
dispatch a crew. For each dispatch, the crew responds with the appropriate parts and materials available in
inventory or contacts the distribution foreman if a part needs to be located elsewhere immediately. Should
residents require notification of a distribution system issue the distribution crew with assistance from water
department administration provides the alerts to the City's public information officer.
There are numerous challenges associated with the current process of handling calls, processing accounts
payable, completion of payroll, creation of work orders via WebQA, and providing alerts and community
notifications. The work described is handled by current full-time staff members. The water distribution
foreman is a working foreman and assists crews in the field and operates equipment and responds to
residential issues. Often, he is not able to enter a new work order due to the current onsite/fieldwork
demands of his position and delays in responding to issues can happen. This is also true of the engineering
assistant who is responsible for completing development reviews, creating request for proposals, preparing
bid documents, reviewing, maintaining, and modifying water department standards, project managing
smaller engineering projects, working with contractors in the field, and performing some of the functions of
the water foreman, as needed, or in his absence. The engineering assistant currently answers over 2,300 of
the 3,600 calls to the department and as such, is not available to respond to the other needs of his role.
Payroll and accounts payable are handled by a water plant shift operator and the water department
manager, who is also performing the role of water plant manager handling all regulatory compliance
requirements.
It is critical that the above information, financial data, and customer responses are handled in a manner that
is effective and timely. The creation of a full time confidential account clerk will meet the needs of the
department as described above.
This package supports the City's goals and priority of a Financially Responsible, High Performing City
Organization as the department looks to provide services delivered in the most effective manner by
evaluating better ways to perform water supply services. This improvement package maintains the benefits
of having a dedicated staff member to address the administrative functions listed above will provide the
necessary support to the department's other full time positions, affording them the time to provide the
needed services of the water department.
Related Cost: $34,028 Water User Fees Recurring Recommend - Yes
Water Rate Impact: 0.43%
Activity: Administration/Meters/Plant Operations/Distribution
Significant Line Items
Employee Expense
1. FY 2020 employee expense reflects a 1.5% wage package increase.
-6-
2. The Iowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged
from FY 2019 The employee contribution of 6.29% is unchanged from FY 2019.
3. The City portion of health insurance expense decreased from $1,193 in FY 2019 to $921 in FY 2020
per month per contract which results in an annual cost savings of $75,798 or 22.77%.
4. Overtime is unchanged from $94,040 in FY 2019 to $94,040 in FY 2020. FY 2018 actual was
$109,707.
5. Sick Leave Payout is decreased from $32,279 in FY 2019 to $32,007 in FY 2020.
Supplies & Services
6. Property Insurance decreased from $77,050 in FY 2019 to $66,812 in FY 2020. An appraisal of all
city buildings was completed during FY 2019.
7. Electricity Utility Expense decreased from $633,850 in FY 2019 to $628,223 in FY 2020 based on FY
2018 actual.
8. Sales Tax expense increased from $516,274 in FY 2019 to $520,583 in FY 2020 based on increased
water rates in FY 2020 of 5%. This expense is directly offset by Sales Tax Revenue.
9. Machinery and Equipment Maintenance decreased from $100,660 in FY 2019 to $69,816 in FY 2020
based on FY 2018 actual of $69,826. 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.
10. Costs for Fluoride, Phosphate, Chlorine, Lime, and Polymer expense (water processing materials)
increased from $399,400 in FY 2019 to $433,950 in FY 2020. FY 2018 actual was $408,768. Lime
increased from $265,000 in FY 2019 to $310,000 in FY 2020.
11. Hauling Services decreased from $150,000 in FY 2019 to $148,250 in FY 2020 based on FY 2019
actual.The amount of hauled tons of lime sludge is highly variable from year to year based on water
usage. FY 2018 actual expense was $136,887.
12. Property Maintenance increased from $52,210 in FY 2019 to $65,560 in FY 2020 based on FY 2018
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 ($1335 per week for 26
weeks).
13. Pipe Special Fittings is increased from $70,000 in FY 2019 to $79,332 in FY 2020 based on FY
2018 actual. This line item represents the purchase of water pipe, special fitting and tapping material
for the distribution system. There is associated revenue budgeted in taps ($33,000) and taps
services ($14,500).
14. Valves decreased from $33,600 in FY 2019 to $24,192 in FY 2020 based on FY 2018 actual. This
line item represents the material cost only for valves in the distribution system. The budget
represents approximately 9 valves.
15. Environment Testing/Monitoring unchanged from $60,000 in FY 2019 to $60,000 in FY 2020. FY
2018 actual was $41,604. It is expected that there will be increased samples due to boil advisories,
chlorine monitoring, and increased testing for expansion of system. The additional funds are for
-7-
water quality testing using the Heterotrophic Plate Count (HPC) test. It 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. This testing is conducted twice per month
or as needed following an emergency.
Machinery & Equipment
16. Equipment replacement items at the maintenance level include ($736,780):
Meters
(1) Smartphone & (2) Cellphones
Portable Radio
Large Water Meters
$ 1,246
$ 1,200
$ 27,000
Plant Operation & Maintenance
Laboratory Equipment $ 3,000
Shop Equipment $ 1,000
Pumps $ 1,000
Smartphone (2) $ 792
Water Distribution System
Utility Truck with Crane
Hydraulic Valve Operator
$ 80,000
$ 55,500
Electric Generator $ 2,400
Cut Off Saw $ 3,000
Tapping Machine $ 48,000
Cell Phones $ 1,692
Annual Maintenance Projects
Pump Replace Vacuum Filter $ 15,000
Large Valve Replacement (2) $ 25,000
VVater Main Replacements (Repair of 70 mains) $ 350,000
Large VVater Meters $ 75,000
Water Valve Box Maintenance (Public Warks) $ 20,000
Water Meter Testing $ 25,000
Recommended Improvement Packages $ 950
Total $ 736,780
-8-
Debt Service
17. Annual debt service reflects repayment to ($3,689,299):
Amount
$ 56,640
Debt Series
SRF 2007A
Source
Water Fees
Purpose
Clear Wells
Final CaII
Payment Date
2028
$ 115,158
Revenue 2008D
VVater Fees
Water Improvements 2023 2016
$ 218,550
SRF Series 2009
Water Fees
Meter Change -Out 2031
$ 386,500
Revenue 2010D
VVater Fees
Water Improvements 2030 2017
$ 106,920
$ 42,772
$ 127,300
$ 756,031
$ 44,688
G.O. 2011A
G.O. 2012E
G.O. 2012D
G.O. 2014B
G.O. 2016C
Water Fees
Water Fees
Water Fees
Water Fees
Water Fees
Water Improvements
Water Improvements
Water Improvements
Water Improvements
Water Improvements
2031
2032
2033
2032
2033
2018
2018
2019
2021
2024
$ 674,220
SRF 2017 Water Fees CIWA Purchase/Imp 2036
$1,090,000
CIWA Contract Water Fees CIWA Purchase 2022
$ 70,520
SRF 2018
Water Fees Roosevelt Water Tower 2038
$3,689,299
Revenue
Total Water Annual Debt Service
18. Water User Fees decreased from $8,166,483 in FY 2019 to $8,161,223 in FY 2020. Increase is
based on FY 2018 actual of $7,943,791 plus the FY 2019 rate increase of 3% and the FY 2020
projected rate increase of 5%.
19. Flat Rates increased from $16,296 in FY 2019 to $18,389 in FY 2020 based on FY 2018 actual of
$18,389. This charge is for customers purchasing bulk water. Rates are set by City ordinance.
20. Fire Protection Rates increased from $161,368 in FY 2019 to $170,410 in FY 2020 based on FY
2018 actual of $170,410. This fee is the demand charge for fire sprinkler head connection. The rates
are set by City ordinance.
21. Taps decreased from $33,905 in FY 2019 to $33,000 in FY 2020 based on a three year historical
average and planned new subdivisions. FY 2018 actual was $64,217 due to South Pointe and
Rustic Point new subdivisions. This fee is charged to customers for 314" to 1" taps and represents
the cost of labor and materials. The rates are set by City ordinance.
22. Tap Service decreased from $24,938 in FY 2019 to $14,500 in FY 2020 based on three-year
average. FY 2018 actual was $16,655. 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.
23. Connection Charge Front Footage increased from $18,671 in FY 2019 to $55,000 in FY 2020 based
on a three-year average and planned new subdivisions. FY 2018 actual was $99,495. 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.
24. Backflow Prevention Administrative Fees increased from $70,617 in FY 2019 to $74,175 in FY 2020
based on FY 2018 actual of $71,357. This is the $25 annual fee charged to all customers with a
backflow device.
-9-
25. Penalties for late payments increased from $82,636 in FY 2019 to $84,383 in FY 2020 based on FY
2018 actual of $84,393.
26. Tower Monthly Rental increased from $89,449 in FY 2019 to $101,495 in FY 2020 based on FY 2018
actual of $101,495.
27. Sales Tax Collected increased from $516,274 in FY 2019 to $520,583 in FY 2020 based on the rate
increase for water fees. This line item off -sets the sales tax expense.
-10-
Water
Department
Manager
Confidential
Account Clerk
Water
Distribution
Supervisor
Water
Distribution
Foreman
Engineeri ng
Assistant
Meter Repair
Worker II
Equipment
Operator II (2)
Distribution
Workers (5)
Meter Repair
Worker I (2.8)
GIS Specialist
Plant Operators
(7)
GIS Seasonal
Interns (0.50)
-11-
Equipment
Mechanic
Electronic
Technician
This page intentionally left blank.
-12-
WATER DEPARTMENT
The Water Department ensures our community has high quality, safe, reliable and affordable
drinking water.
Water
Department
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 2018 FY 2019 FY 2020
Full -Time Equivalent 25.57 25.87 26.37
Resources Support
$10,518,160
FY 2018
$10,423,618 $10,497,358
Operating Revenue
FY 2019
FY 2020
The Water Department is supported by 26.37 full-time equivalent employees, which accounts for
23.01 % of the department expense as seen below. Overall, the department's expenses are expected to
increase by 0.42% in FY 2020 compared to FY 2019.
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
esuedx3 ee oIdw3
seovues pue se ddnE
m
173m
W
CO
F
0
FY 2018 FY 2019 In FY 2020
puna uoi1onJTsuo3
I I
I 11
111
I I
aovuos Tgeo
se6aego 6UpeoU 6u3
-14-
WATER DEPARTMENT
Administration
Overview
The 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, analysis of rate structure, 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 2018 Actual
FY 2019 Budget
FY 2020 Requested
Expenditures
$3,374,228
$3,943,635
$4,546,855
Resources
$1,172,921
$—
$—
Water Administration Position Summary
FY 2020
Water Department Manager
1.00
Confidential Account Clerk
1.00
GIS Specialist
1.00
GIS Intern
0.50
Total FT Equivalent Employees
3.50
Highlights of the Past Year
Q Completion of the Westside Water System
Improvements, which included the installation of over 2
miles of water main and the addition of the English Mill
Pump Station, connecting the Vernon Water Tower and
the Vernon and Barrington Lakes Water Systems to
the City of Dubuque water supply.
Q Completion of the John F. Kennedy Road water
main extension project. A 12 -inch water main was
extended north of Derby Grange Road providing water
service to the Derby Grange Road Housing Urban
Renewal Area.
Q Initiation of the Roosevelt Street Water Tower
planning and design. The tower will improve water
pressure and flows to better serve the residents in the
2nd Pressure Zone (Peru Road and Roosevelt Street)
and prepare the City for continued growth.
-15-
JFK Road Water Main Installation FY18
WATER DEPARTMENT
Future Initiatives
• Develop a Water Master Plan meeting the needs of current and future residents and
businesses in the Dubuque community.
• Maintain appropriate department staffing levels to ensure regulatory compliance and
maintain and operate the department's facilities and distribution system.
• Provide industry and professional development related training to maintain licensing and
expand the skill set of Water Department employees.
Performance Measures
Administration -Activity Statement
Provides evaluation and coordination of daily operations and long term planning of the department
and interacts with state and federal regulatory agencies to maintain regulatory compliance.
Goal: Financially Responsible, High Performance Organization/'
Outcome #1: Maintain a financially viable water utility
Financial viability allows the Water Department to achieve its operating objectives and allows
the department to fulfill its mission over the long term.
Outcome #2: Strategic planning of Water Department activities
Strategic planning enables the Water Department to be proactive and responsive to the current
and changing needs of the community, while focusing valuable resources of the organization in
the same direction to become more efficient and cost-effective.
-16-
WATER DEPARTMENT
Plant Operations and Maintenance
Overview
Plant Operations and Maintenance ensures that water
used for domestic, commercial and industrial purposes is
safe for drinking and is supplied at sufficient volumes to
meet the needs of our community as well as provide for fire
protection. Responsible for the management of equipment
and chemicals used to treat and disinfect groundwater for
human consumption and to maintain compliance with all
Federal, State and Local 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 our 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.
Highlights of the Past Year
• Abandoned the Barrington Lakes Wells, removed the well house and restored the site
for hand over to Barrington Lakes Homeowners Association.
• Maintained Regulatory Compliance. Focus on Lead and Copper water sampling in
residential homes.
• Completed the 2017-2018 Consumer Confidence Reports for Dubuque. Zero violations
were reported.
-17-
FY 2018 Actual
FY 2019 Budget
FY 2020 Requested
Expenditures
$2,443,137
$2,485,477
$2,468,782
Resources
$911
$480
$—
Highlights of the Past Year
• Abandoned the Barrington Lakes Wells, removed the well house and restored the site
for hand over to Barrington Lakes Homeowners Association.
• Maintained Regulatory Compliance. Focus on Lead and Copper water sampling in
residential homes.
• Completed the 2017-2018 Consumer Confidence Reports for Dubuque. Zero violations
were reported.
-17-
FY 2020
Electronic Technician
1.00
Equipment Mechanic
1.00
Plant Operator II
1.00
Plant Operator III & IV
0.00
Plant Operator IV
6.00
Total FT Equivalent Employees
9.00
Highlights of the Past Year
• Abandoned the Barrington Lakes Wells, removed the well house and restored the site
for hand over to Barrington Lakes Homeowners Association.
• Maintained Regulatory Compliance. Focus on Lead and Copper water sampling in
residential homes.
• Completed the 2017-2018 Consumer Confidence Reports for Dubuque. Zero violations
were reported.
-17-
WATER DEPARTMENT
uture Initiatives
• Maintain the operation and maintenance of the Eagle Point Water Plant and all
associated storage, pumping and well facilities in the most environmentally conscious
manner
• Ensure continued compliance with all regulatory agencies
Performance Measures
Plant Operations and Maintenance - Activity Statement
Protect, preserve and promote the public health and welfare of the residents of the city of Dubuque by
effectively and efficiently managing, maintaining and operating the Eagle Point Water Treatment Plant.
(9( Goal: Sustainable Environment
Outcome #1: Provide water treatment and distribute high quality, clean, drinking water
that meets or exceeds drinking water regulations
Drinking water is one of our most vital resources and is essential to human health. The Eagle
Point Water Treatment Plant delivers an average of 7 million gallons of clean water each day to
our homes, schools and businesses which is then used for cooking, drinking, cleaning,
bathing, and available for fire suppression.
The 2018 Water Quality Report can be downloaded at: http://www.cityofdubuque.org/waterquality
Outcome #2: Produce high quality water at the required pressures and volumes
Maintaining the proper pressures and volumes ensures adequate fire suppression abilities and
consumer demand.
2,900
2,800
2,700
2,600
2,500
Water Treated (Million Gallons)
-r
i mou.--- --rail iii -
1
FY 09 FY 10 FY 11 FY 12 FY 13 FY 14 FY 15 FY 16 FY 17 FY 18
-18-
WATER DEPARTMENT
Water Distribution
DID YOU
KNOW?
Dubuque's drinking
water comes from
wells. There are five
shallow wells located
at the A.Y. McDonald
Park and four deep
wells located around
the Eagle Point Water
Treatment PLant on
Hawthorne Street.
Overview
The function of the Water Distribution Division 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
-19-
FY 2018 Actual
FY 2019 Budget
FY 2020 Requested
Expenditures
$2,586,126
$2,935,545
$2,328,838
Resources
$9,218,783
$10,309,518
$10,378,220
-19-
FY 2020
Equipment Operator II
2.00
Water Distribution Maintenance Worker
4.00
Water Distribution Foreman
1.00
Water Distribution Supervisor
1.00
Water Engineering Assistant
1.00
Custodian I
0.07
Total FT Equivalent Employees
9.07
-19-
WATER DEPARTMENT
Highlights of the Past Year
• Completion of Highway 20/Menards intersection water main installation
• Street Reconstruction/Engineering Projects
Future Initiatives
• The Water Distribution Division is prepared to replace; as needed, the aged, existing
water main, fire hydrants, control valves and lead service lines on construction projects
in partnership with the Engineering and Public Works Departments.
Performance Measures
Water Distribution - Activity Statement
Operate and maintain a water distribution system consistent with established procedures recognized by the
American Water Works Association for efficient management practices.
Goal: Financially Responsible, High Performance Organization
Outcome #1: Ensure the integrity of the distribution system piping system
Maintains the safety of our drinking water through flushing, replacing aged piping, valves and
fire hydrants.
Outcome #2: Addressing customer and system issues in a timely manner
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.
-20-
1
WATER DEPARTMENT
Water Meters
Overview
The Water Meter Division provides dependable meter repair consisting of testing, dismantling,
cleaning, repairing, and reassembling meters as required. The Meter Division performs
installation services, addresses pressure complaints, investigates illegal use of water, installs
outside registers, and performs special reading of meters upon request and performs backflow
administration to comply with state and federal mandates while ensuring accurate charges to
the customer.
DID YOU KNOW? The distribution system is composed of 336 miles of water mains
ranging in diameter from 4" up to 30", 7,196 control valves; and 2,444 fire hydrants
160
140
120
100
80
60
40
350
300
250
200
150
100
50
Water Main Breaks
•
FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018
Service Taps
FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018
Service taps are new connections to the public water mains
-21-
WATER DEPARTMENT
Water Meters Funding Summary
FY 2018 Actual
FY 2019 Budget
FY 2020 Requested
Expenditures
$295,216
$497,222
$494,598
Resources
$120,545
$113,620
$119,138
Water Meters Position Summary
FY 2020
Water Meter Repair Worker I
3.00
Water Meter Repair Worker II
1.00
Water Meter Inspector
0.00
Water Meter Service Worker!
0.80
Total Full -Time Equivalent Employee's
4.80
Future Initiatives
• Continue to educate the public of the importance of adhering to all State and Federal
mandates concerning Backflow Control Devices, which protect public water supplies
from potential contamination
• Continue to provide excellent customer service
Performance Measures
Water Meters - Activity Statement
Provide dependable meter repair, installation services and backflow administration to comply with state and
federal mandates to ensure accurate charges to customers.
Goal: Sustainable Environment
Outcome #1: Provide accurate meter readings
Ensures that customers pay for the appropriate amount of water used by tracking private water
service line leaks (internal and external). Repair reimbursement and service line assistance.
Outcome #2: Backflow protection
Minimizes the possibility of contamination of the distribution system by preventing back
siphonage. A backflow prevention device prevents contamination of the water system from
industrial and commercial water services by using equipment that stops the backward flow of
water through a pipe or cross connection between potable water and contaminants.
-22-
WATER DEPARTMENT
�
ID YOU KNOW?
Since the adoption by
the Dubuque City
Council of the Backflow
Prevention Program, we
have established over
2,004 accounts having
Backflow Protection
Iand we also monitor
over 2,967 Control
Devices. These
accounts are a
combination of various
Industrial and
ommercial facilities.
Annually we receive
$25.00 per device as
the administration fee. It
is expected an
additional 40 accounts
will be established
before the end of the
fiscal year 2020.
Typical Meter/Fire Sprinkler Room
-23-
Meter
800
700
600
500
400
300
200
100
0
WATER DEPARTMENT
Outcome #3: Responding to customer inquiries in a timely manner
Maintains consumer confidence in the water utilty
714
591
i
Service Calls
420
673
696
650
FY13 FY14 FY1S FY16 FY17 FY18
-24-
Recommended Operating Revenue Budget - Department Total
42 - WATER
Fund
Account
Account Title
FY17 Actual
Revenue
FY18 Actual
Revenue
FY19 Adopted
Budget
FY20 Recomm'd
Budget
640
43110
INVESTMENT EARNINGS
38,222
51,283
35,000
76,061
43 USE OF MONEY AND PROPERTY - Total
38,222 51,283
35,000
76,061
640 44405 FEMA PUBLIC ASSISTANCE
0
2,453
0
0
44 INTERGOVERMENTAL - Total
0
2,453
0
0
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 FIRE PROTECTION RATES
640 51125 TAPS -3/4 & 1 INCH
640 51130 CONNECT CHG LARGE SERVICE
640 51135 CONNECT CHG FRONT FOOTAGE
640 51140 METER SALES -REMOTES
640 51145 SALE OF METERS
640 51146 SALE OF UFR DEVICES
640 51160 BOX -LID -PART SALES
640 51165 MAINTENANCE CHARGES
640 51170 REPAIR OF METERS
640 51175 SHUT OFF PENALTIES
640 51176 METER TAMPERING FEE
640 51177 CALL OUT CHARGE
640 51180 CROSS CON. CNTL ADMIN FEE
640 51215 LATE PAYMENT PENALTY
640 51310 PERMIT
640 51330 RAMP ASSIGNED
7,800,231
0
0
16,296
41,534
161,368
28,123
24,938
18,671
1,840
17,139
5,420
5
6,390
8,868
23,721
1,319
795
70,617
77,134
89,449
0
7,943,791
45
11,374
18,389
123,765
170,410
64,217
16,655
99,495
13,218
12,513
7,825
0
10,306
12,902
18,660
1,006
1,335
71,357
84,393
101,495
(6,262)
8,166,483
0
0
16,296
0
161,368
33,905
24,938
18,671
500
25,000
5,973
0
7,304
10,271
23,721
1,319
1,000
70,617
82,636
89,449
0
8,161,223
0
11,374
18,389
0
170,410
33,000
14,500
55,000
13,500
12,500
5,600
0
7,300
12,500
18,660
1,006
1,335
74,175
84,383
101,495
0
51- CHARGES FOR SERVICES
8,393,860 8,776,888
8,739,451 8,796,350
640 53605 MISCELLANEOUS REVENUE
640 53610 INSURANCE CLAIMS
640 53615 DAMAGE CLAIMS
640 53620 REIMBURSEMENTS -GENERAL
640 53630 SALES TAX COLLECTION
72
2,205
15,397
93
486,637
0
0
21,265
5,691
485,981
0
119
12,221
73
516,274
0
0
12,500
364
520,583
53 - MISCELLANEOUS
504,405 512,937
528,687 533,447
640
640
640
640
54109
54230
59100
59500
SALVAGE SALES
SRF GO BOND PROCEEDS
FR GENERAL
TRF TO PEONY TRUST
1,359
0
0
0
1,847
1,155,899
16,854
0
480
0
0
1,120,000
1,500
0
0
1,090,000
59- TRANSFER IN AND INTERNAL
1,359 1,174,600
1,120,480 1,091,500
42 - WATER TOTAL
8,937,845 10,518,160
10,423,618 10,497,358
-25-
Recommended Operating Expenditure Budget - Department Total
42 - WATER
Fund
Account
Account Title
FY17 Actual
Expense
FY18 Actual
Expense
FY19 Adopted
Budget
FY 20 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
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
0
1,467,387
4,900
1,125
0
70,114
17,135
90
9,346
4,292
0
139,375
0
114,748
0
393,964
82,465
0
1,059
2,460
484
254
1,187
1,229,655
4,953
7,638
641
109,065
24,605
120
29,311
34,719
163
122,458
131
104,048
503
381,097
94,589
3
913
2,221
1,618
1,848
0
1,458,560
63,505
16,671
0
94,040
17,000
1,200
32,279
0
0
155,851
0
128,771
0
357,750
87,466
0
1,245
4,750
500
900
0
1,539,445
46,318
15,154
0
94,040
17,000
1,200
32,007
0
0
161,724
0
133,505
0
281,952
74,335
0
1,375
4,750
500
950
61- WAGES AND BENEFITS
2,309,196 2,151,486
2,420,488 2,404,255
640 62010 OFFICE SUPPLIES
640 62011 UNIFORM PURCHASES
640 62030 POSTAGE AND SHIPPING
640 62033 HAND TOOLS/EQUIPMENT
640 62034 REPAIR PARTS/SUPPLIES
640 62036 CONSTRUCTION SUPPLIES
640 62060 O/E MAINT CONTRACTS
640 62061 DP EQUIP. MAINT CONTRACTS
640 62062 JANITORIAL SUPPLIES
640 62063 SAFETY RELATED SUPPLIES
640 62064 ELECTRICAL SUPPLIES
640 62065 LAB SUPPLIES
640 62066 PLUMBING MATERIALS
640 62090 PRINTING & BINDING
640 62110 COPYING/REPRODUCTION
640 62130 LEGAL NOTICES & ADS
640 62170 SUBSCRIPTIONS -BOOKS -MAPS
640 62190 DUES & MEMBERSHIPS
640 62204 REFUNDS
640 62206 PROPERTY INSURANCE
640 62207 BOILER INSURANCE
640 62208 GENERAL LIABILITY INSURAN
640 62210 SALES TAX
640 62216 REFUND LEAK ALLLOWANCE
640 62310 TRAVEL -CONFERENCES
-26-
3,342
13,006
1,780
6,032
8,669
856
0
80
17,453
4,689
5,122
10,199
12,754
585
844
1,681
1,705
1,227
2,543
5,396
71,583
0
20,896
489,433
2,256
3,028
17,152
2,472
8,637
4,373
4,012
0
0
17,608
4,873
3,050
9,808
15,757
2,415
1,592
4,022
1,267
2,208
3,612
8,828
67,141
120
18,419
501,222
4,188
4,009
15,686
1,700
5,265
7,846
1,830
0
0
20,268
4,750
3,000
10,453
13,500
2,000
920
1,545
38,100
870
4,615
5,091
77,050
0
21,392
516,274
6,000
3,205
17,152
2,149
5,775
4,373
3,827
2,698
0
20,560
4,764
3,050
9,800
15,757
2,390
1,521
4,054
705
914
5,605
6,284
66,812
120
20,087
520,583
6,950
Recommended Operating Expenditure Budget - Department Total
42 - WATER
Fund
Account
Account Title
FY17 Actual
Expense
FY18 Actual
Expense
FY19 Adopted
Budget
FY 20 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 62433
640 62435
640 62436
640 62437
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
640 62671
640 62675
640 62676
640 62692
640 62696
640 62710
640 62713
640 62716
640 62726
640 62731
640 62746
640 62765
640 62767
640 62780
TRAVEL-CITYBUSINESS
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
CUSTODIAL SERVICES
ELEVATOR MAINTENANCE
RENTAL OF SPACE
BARRICADE RENTAL
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
INTERNET SERVICES
PROGRAMMING
MISC. OPERATING SUPPLIES
VALVES
PIPE -SPECIAL FITTINGS
LANDFILL FEES
OUTSIDE COLLECTOR EXPENSE
CONTRACTOR SERVICES
LEGAL SERVICES
CONSULTANT SERVICES
AUDIT SERVICES
MISCELLANEOUS SERVICES
ONE CALL OPERATION
GRANTS
ENVIRON. TESTING/MON.
HAULING SERVICES
0
4,738
9,289
555,798
32,174
1,488
180
9,489
7,898
0
41,607
1,488
1,764
3,226
18,464
32,950
2,641
4,321
84,232
379
0
3,727
3,615
13,074
261,335
70,696
38,693
6,855
16,217
1,256
7,061
1,777
5,062
0
0
62,190
38,264
759
6,884
144
29,000
0
3,000
6,966
4,932
6,061
40,958
129,154
20
4,513
6,669
628,223
35,021
0
192
9,717
6,244
2,559
45,560
1,540
1,819
8,927
23,977
30,764
0
712
69,826
877
0
1,450
19
10,433
288,125
64,561
37,474
8,176
17,016
1,026
7,159
1,622
4,491
25
1,594
24,192
79,332
70
5,418
6,549
33,464
7,905
3,000
37,454
5,358
5,731
41,604
136,887
200
4,150
14,755
633,850
33,783
1,500
180
11,487
7,898
0
52,210
2,000
2,244
5,000
21,964
20,992
0
5,633
100,660
10,000
835
1,500
0
14,700
265,000
71,000
40,000
8,700
16,460
351
7,200
4,152
25,000
0
0
33,600
70,000
200
7,400
0
0
0
4,070
20,000
0
5,000
60,000
150,000
1,425
4,574
12,000
628,223
35,021
1,500
218
12,238
7,500
6,481
65,560
1,540
1,819
8,927
23,978
24,545
0
726
69,816
10,000
0
1,450
1,500
10,450
310,000
65,000
40,000
8,500
16,500
88,625
7,159
5,400
19,829
0
0
24,192
79,332
70
5,418
0
0
0
4,100
40,000
5,358
15,000
60,000
148,250
-27-
Recommended Operating Expenditure Budget - Department Total
42 - WATER
Fund
Account
Account Title
FY17 Actual
Expense
FY18 Actual
Expense
FY19 Adopted
Budget
FY 20 Recomm'd
Budget
62- SUPPLIES AND SERVICES 2,251,937 2,413,097 2,495,838 2,601,359
640 71120 PERIPHERALS, COMPUTER
640 71123 SOFTWARE
640 71124 COMPUTER
640 71225 SHELVING
640 71312 VAN/PICKUP/WAG REPL
640 71314 TRUCK -REPLACEMENT
640 71318 HEAVYEQUIP-REPLACEMENT
640 71329 VEHICLE ACCESSORIES
640 71410 SHOP EQUIPMENT
640 71413 LABORATORY EQUIPMENT
640 71415 SAWS
640 71419 TAPPING MACHINE
640 71510 HYDRANTS
640 71511 PUMPS
640 71516 LARGE WATER METERS
640 71550 MISCELLANEOUS EQUIPMENT
640 71619 OTHER MAINT. EQUIPMENT
640 72111 GAS SAFETY MONITOR
640 72410 PAGER/RADIO EQUIPMENT
640 72418 TELEPHONE RELATED
640 72515 TEST EQUIPMENT, OTHER
0
1,790
0
0
0
0
88,941
0
408
4,558
0
768
66,517
1,099
93,888
0
22,324
0
0
948
1,099
0
20,889
0
894
0
0
0
0
651
685
0
0
13,949
3,351
53,752
0
0
133
0
674
115
0
14,150
4,600
0
95,000
0
110,000
23,000
1,000
3,500
1,800
6,200
35,000
24,000
102,000
45,500
0
0
0
940
0
950
0
0
0
0
80,000
0
0
1,000
3,000
3,000
48,000
0
16,000
102,000
57,900
0
0
1,200
3,730
0
71- EQUIPMENT
282,340 95,093
466,690
316,780
640 72115 BARRICADES/WARN SIGNALS
644
307
0
0
72 - EQUIPMENT
644
307
0
0
640 73211 CONST.CONTR-NOTBLDG
640
73410
EQUIP ACQUISITION
219,203
0
291,422
0
385,000
18,000
420,000
0
73 - CIP EXPENDITURES
219,203 291,422
403,000
420,000
640
640
74111
74112
PRINCIPAL PAYMENT
INTEREST PAYMENT
876,595
729,399
1,857,435
701,272
2,191,434
924,373
2,746,524
942,775
74 - DEBT SERVICE
1,605,994 2,558,707
3,115,807
3,689,299
640
91100
TO GENERAL
640 91740 TO WATER CONSTRUCTION
142,884
2,412,000
407,567
1,157,000
548,056
935,000
597,380
400,000
91- TRANSFER TO
2,554,884 1,564,567
1,483,056
997,380
42 - WATER TOTAL
9,224,198 9,074,678
10,384,879 10,429,073
-28-
Recommended Expenditure Budget Report by Activity & Funding Source
42 - WATER
UNDISTRIBUTED - 10640
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
SUPPLIES AND SERVICES 11,703
TRANSFER TO 1,564,567
UNDISTRIBUTED
12,491
1,483,056
11,702
997,380
1,576,270 1,495,547
WATER ADMINSTRATION - 42100
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense
FY19 Adopted Budget FY20 Recomm'd Budget
DEBT SERVICE
EQUIPMENT
SUPPLIES AND SERVICES
WAGES AND BENEFITS
2,558,707
580,244
235,277
3,115,807
4,950
539,855
283,023
3,689,299
543,873
313,683
WATERADMINSTRATION
3,374,228
METERS - 42300
3,943,6
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
EQUIPMENT
SUPPLIES AND SERVICES
WAGES AND BENEFITS
METERS
21,934
19,562
253,720
40,770
40,612
415,840
29,446
67,575
397,577
295,216 497,222
SNOW & ICE CONTROL - 42420
FUNDING SOURCE: ROAD USE TAX
Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
WAGES AND BENEFITS
rilli
PER. & MAINT
2,628
2,628
PLANT OPER. & MAINT
FUNDING SOURCE: WATER UTILITY OPERATION
Account
- 42400
r ■
FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
EQUIPMENT 5,399
SUPPLIES AND SERVICES 1,485,130
WAGES AND BENEFITS 952,608
•
5,500
1,625,971
854,006
PLANT OPER. & MAINT 2,443,137
AIL WATER DISTR. SYSTEM
FUNDING SOURCE: WATER UTILITY OPERATION
Account
6,742
1,612,118
849,922
1111
FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
CIP EXPENDITURES 2,452
EQUIPMENT 15,510
SUPPLIES AND SERVICES 284,640
WAGES AND BENEFITS 707,254
-29-
320,470
251,909
867,619
190,592
286,091
843,073
Recommended Expenditure Budget Report by Activity & Funding Source
42 - WATER
WATER DISTR. SYSTEM 1,009,856 1,439,998 1,319,756
WATER DIST SYSTEM - 42700
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
SUPPLIES AND SERVICES
STORAGE TANK INSPECT/MON
14,137
AUTO MTR RD SYS MNT PROG - 42710
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
CIP EXPENDITURES
5,500
15,000
UTO MTR RD SYS MNT PROG 5,500 15,000
PUMP REPLC VACUUM FILTER - 42713
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
EQUIPMENT
PUMP REPLC VACUUM FILTER
FIRE HYDRANT P
20.000
20,00
15,000
15,000
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
SUPPLIES AND SERVICES
5,000 5,000
FIRE HYDRANT PAINTING 5,000
GENERATOR MAIN PROGRAM - 42725
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
CIP EXPENDITURES
GENERATOR MAIN PROGRAM
GIS MAINT/UPDATES - 42730
18,000
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
SUPPLIES AND SERVICES
GIS MAINT/UPDATES —
MIL SERVICE LINE ASSIST-WIIMMMI
5
25,000
25,000
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
SUPPLIES AND SERVICES 26,062
SERVICE LINE ASSIST 26,062
VALVE REPLACEMENT - 42745
FUNDING SOURCE: WATER UTILITY OPERATION
-30-
15,000 35,000
35,000
Recommended Expenditure Budget Report by Activity & Funding Source
42 - WATER
Account
FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
CIP EXPENDITURES
12,250 25,000
MilIF-
ALVE REPLACEMENT 12,250 25,000
A WATER MAIN REPLACEMENTS - 42755
FUNDING SOURCE: WATER UTILITY OPERATION
Account
25,000
1
FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
CIP EXPENDITURES
251,766
300,000
WATER MAIN REPLACEMENTS 251,766 300,00
WATER METER EXCHANGE - 42760
FUNDING SOURCE: WATER UTILITY OPERATION
Account
350,000
FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
EQUIPMENT
52,557
v
WATER METER EXCHANGE 52,557
WATER LEAK REPAIR GRANT - 42765
FUNDING SOURCE: WATER UTILITY OPERATION
Account
75,000
75,000
FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
SUPPLIES AND SERVICES
5,731
WATER LEAK REPAIR GRANT 7,7111111r
COUNTY WATER ASSISTANCE - 42766
5,000
5,000
5,000
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
SUPPLIES AND SERVICES
�COUNTY ASSISTANCE
WATER VALVE BOX MAINT ageraimilla
10,000
10,000
FUNDING SOURCE: WATER UTILITY OPERATION
Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
CIP EXPENDITURES 19.331 20,000 20,000
WATER VALVE BOX MAINT 19,331
WATER METER TESTING
FUNDING SOURCE: WATER UTILITY OPERATION
Account
20,0
20,000
FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
CIP EXPENDITURES 123 25,000 25,000
WATER METER TESTING
WATER TOTAL $
123 ' 25,000 25,000
9,074,678.45 $ 10,334,379.00 $ 10,429,073.00
-31-
CITY OF DUBUQUE, IOWA
DEPARTMENT DETAIL - PERSONNEL COMPLEMENT
42 WATER DEPARTMENT
FD JC WP -GR JOB CLASS
FY 2018 FY 2019 FY 2020
FTE BUDGET FTE BUDGET FTE BUDGET
61010 Full Time Employee Expense
640 3275 GE -40 WATER DEPARTMENT MANAGER 1.00 $ 104,255 1.00 $ 106,616 1.00 $ 109,298
640 2775 GE -37 WATER PLANT MGR. 1.00 $ - 0.00 $ - 0.00 $ -
640 3200 GE -37 WATER DISTRIBUTION SUPERVISOR 1.00 $ 86,711 1.00 $ 88,009 1.00 $ 90,025
640 2950 GE -33 WATER ENGINEERING ASSISTANT 1.00 $ 67,933 1.00 $ 72,779 1.00 $ 74,429
640 2650 GE -31 FOREMAN - WATER DISTR. 1.00 $ 52,000 1.00 $ 59,221 1.00 $ 67,509
640 2610 GE -30 GIS SPECIALIST 1.00 $ 61,606 1.00 $ 62,541 1.00 $ 64,050
640 GE -25 CONFIDENTIAL ACCOUNT CLERK 0.00 $ - 0.00 $ - 1.00 $ 39,153
640 NA -49 WATER METER INSPECTOR 0.00 $ - 1.00 $ 56,327 0.00 $ -
640 2400 0E-16 ELECTRONIC TECHNICIAN 1.00 $ 62,244 1.00 $ 63,165 1.00 $ 64,610
640 2800 0E-14 EQUIPMENT MECHANIC 1.00 $ 59,143 1.00 $ 60,041 1.00 $ 61,862
640 2550 0E-13 WATER PLANT OPR CERT GR III/IV 3.00 $ 166,238 1.00 $ 58,579 0.00 $ -
640 2475 0E-12 WATER PLANT OPERATOR CRT GR II 5.00 $ 277,038 3.00 $ 168,592 1.00 $ 57,751
640 2475 0E-12 WATER PLANT OPERATOR CRT GR IV 0.00 $ - 3.00 $ 185,509 6.00 $ 380,552
640 2305 0E-10 EQUIPMENT OPERATOR II 2.00 $ 106,554 2.00 $ 108,273 2.00 $ 110,767
640 1775 0E-09 WATER METER REPAIRWORKER I 3.00 $ 156,289 2.00 $ 110,396 3.00 $ 163,136
640 0E-14 WATER METER REPAIRWORKER II 0.00 $ - 1.00 $ 59,453 0.00 $ -
WATER DISTR MAINTENANCE
640 1,476 0E-09 WORKER 4.00 $ 211,555 4.00 $ 204,648 5.00 $ 256,303
TOTAL FULL TIME EMPLOYEES 25.00 $ 1,411,566 24.00 $ 1,464,149 25.00 $ 1,539,445
61020 Part -Time Employee Expense
640 225 GE -25 SECRETARY 0.50 $ 18,850 0.50 $ 19,136 0.00 $ -
640 0E-07 WATER METER SERVICE WORKER I 0.00 $ - 0.80 $ 41,080 0.80 $ 42,954
640 2050 0E-06 CUSTODIAN I 0.07 $ 3,241 0.07 $ 3,289 0.07 $ 3,364
TOTAL PART TIME EMPLOYEES 0.57 $ 22,091 1.37 $ 63,505 0.87 $ 46,318
61030 Seasonal Employee Expense
640 NA -34 GIS INTERN 0.00 $ - 0.50 $ 16,671 0.50 $ 15,154
TOTAL SEASONAL EMPLOYEES 0.00 $ - 0.50 $ 16,671 0.50 $ 15,154
TOTAL WATER DEPARTMENT 25.57 $ 1,433,657 25.87 $ 1,544,325 26.37 $ 1,600,917
-32-
ACCT FD JC WP -GR
Water Administration -FT
64042100
64042100
64042100
61010 640 2610
61010 640 3275
61010 640
CITY OF DUBUQUE, IOWA
ACTIVITY PERSONNEL COMPLEMENT SUMMARY
POSITION CLASS
GE -30 GIS SPECIALIST
GE -40 WATER DEPARTMENT MANAGER
GE -25 CONFIDENTIAL ACCOUNT CLERK
Total
Water Administration -PT
64042100 61020 640 225 GE -25 SECRETARY
Total
Water Administration -SEASONAL
64042100 61030 640 NA -34
Water Meters -FT
64042300 61010
64042300 61010
64042300 61010
64042300 61010
Water Meters -PT
GIS INTERN
Total
640 1775 OE -09 WATER METER REPAIRWORKER I
640 OE -14 WATER METER REPAIRWORKER II
WATER DISTRIBUTION
640 MAINTENANCE WORKER
640 NA -49 WATER METER INSPECTOR
Total
WATER METER SERVICE
64042300 61020 640 1775 OE -07 WORKER I
Water Plant Operation -FT
64042400 61010 640 2475
64042400 61010 640 2550
64042400 61010 640
64042400 61010 640 2775
64042400 61010 640 2800
64042400 61010 640 3015
Water Distribution -FT
64042700 61010 640 1476
64042700 61010 640 2305
64042700 61010 640 2650
64042700 61010 640 2950
64042700 61010 640 3200
Total
OE -12 WATER PLANT OPER. CRT GR II
OE -13 WATER PLANT OPR CERT GR III/IV
OE -13 WATER PLANT OPR CERT GR IV
GE -37 WATER PLANT MGR.
OE -16 ELECTRONIC TECHNICIAN
OE -14 EQUIPMENT MECHANIC
Total
OE -09 WATER DIST MAINTENANCEWOR
OE -10 EQUIPMENT OPERATOR II
GE -31 FOREMAN - WATER DISTR.
GE -33 WATER ENGINEERING ASSISTANT
GE -37 WATER DISTRIBUTION SUPV
Total
Water Distribution - PT
64042700 61020 640 2050 GD -03 CUSTODIAN I
Total
FY 2018 FY 2019 FY 2020
FTE BUDGET FTE BUDGET FTE BUDGET
1.00 $ 61,606
1.00 $ 104,255
0.00 $
1.00 $ 62,541
1.00 $ 106,616
0.00 $
1.00
1.00
1.00
$ 64,050
$ 109,298
$ 39,153
2.00 $ 165,861 2.00 $ 169,157 3.00 $ 212,501
0.50 $ 18,850 0.50 $ 19,136 0.00 $
0.50 $ 18,850 0.50 $ 19,136 0.00 $
0.00 $ - 0.50 $ 16,671 0.50 $ 15,154
0.00 $ - 0.50 $ 16,671 0.50 $ 15,154
3.00 $ 156,289 2.00 $ 110,396 3.00 $ 163,136
0.00 $ 1.00 $ 59,453 0.00 $ -
0.00 $ 0.00 $ 1.00 $ 52,691
0.00 $ 1.00 $ 56,327 0.00 $ -
3.00 $ 156,289 4.00 $ 226,176 4.00 $ 215,827
0.00 $ - 0.80 $ 41,080 0.80 $ 42,954
0.00 $ - 0.80 $ 41,080 0.80 $ 42,954
5.00 $ 277,038
3.00 $ 166,238
0.00 $
1.00 $
1.00 $ 62,244
1.00 $ 59,143
3.00
1.00
3.00
0.00
1.00
1.00
168,592
58,579
185,509
63,165
60,041
1.00
0.00
6.00
0.00
1.00
1.00
$ 57,751
$ 380,552
$ 64,610
$ 61,862
11.00 $ 564,663 9.00 $ 535,886 9.00 $ 564,775
4.00
2.00
1.00
1.00
1.00
$ 211,555
$ 106,554
$ 52,000
$ 67,933
$ 86,711
4.00
2.00
1.00
1.00
1.00
$ 204,648
$ 108,273
$ 59,221
$ 72,779
$ 88,009
4.00
2.00
1.00
1.00
1.00
$ 203,612
$ 110,767
$ 67,509
$ 74,429
$ 90,025
9.00 $ 524,753 9.00 $ 532,930 9.00 $ 546,342
0.07 $ 3,241 0.07 $ 3,289 0.07 $ 3,364
0.07 $ 3,241 0.07 $ 3,289 0.07 $ 3,364
TOTAL WATER DEPARTMENT 25.57 $ 1,433,657 25.87 $ 1,544,325 26.37 $ 1,600,917
-33-
Capital Improvement Projects by Department/Division
WATER
CIP Number Capital Improvement Project Title
FY 17 Actual FY 18 Actual FY 19 Adopted FY 20 Recomm'd
Expense Expense Budget Budget
7102639 LOWELL STREET 6,380
7401339 SCADA SYSTEM UPGRADE
7401405 WATER MAIN REPLACEMENTS 88,027
7401411 MAIN EXT ANNEXATION REL. 76,177
7401415 SHALLOW WELL REHAB
7401672 ROOSEVELT RD MAIN EXT. 3,638
7401829 SECURITY UPGRADES
7402030 VACUUM FILTER BACK-UP
7402052 WATER METER REPL PROGRAM
7402234 SOUTHGATE WATER
7402261 RAMP UTILITY RELOCATION
7402349 MANSON ROAD WATER MAIN
7402395 WATEREXT-AIRPORT 281,557
7402504 ENGLISH MILL WATER MAIN E 25,451
7402524 ONLINE PROCESS ANALYZER
7402525 N CASCADE WATER MAIN
7402526 SRF GREEN ALLEY 21,901
7402527 GENERATOR 7,887
7402594 SW ARTERIAL MAIN EXT 19,225
7402595 CREEK CROSSING RESTORE
7402596 MAIN RELOC SEWER MANHOLE
7402633 PRIVATE WATER SYS PURCH 242,996
7402639 LOWELL STREET 5,154
7402641 AIRPORT SCADA SYSTEM 47,360
7402653 LIME SLAKER REPLACE STUDY
7402654 FIRE HYDRNT ASSMBLY SW PG
7402655 MAINT WTR MN - RETAIN WAL
7402656 WATER STORAGE TANK COATIN
7402657 WTR MN UPGRADES - STREET
7402658 WTR MN REPLACE - SWR CONS
7402703 WEST RURAL WATER PURCHASE 1,391,885
7402704 TIMBER RIDGE WATER MAIN 42,947
7402705 GRANDVIEW/LORAS INTER IMP
7402713 RPR/MAINT WATER LINE ISLA
7402714 BULK CO2 TANK REPLACEMENT
7402734 RURAL WATER ENGLISH PUMP
7402744 PUBLIC LEAD LINE WATER RE
7402745 TAMARAK FRONTAGE WATER MN
7402746 COTTINGHAM RD WATER MAIN
7402747 CHESTERFIELD DR WATER MAI
7402748 EPWP TRANSFORMER SAFETY
7402786 DAVENPORT RD EXT/PMP STAT
0
0
0
0
10,565
505,000
456,860 209,000
137,000
151,977 2,582,200
39,000
27
8,679
1,008
32,665
2,655,921
866,746
11,300
903,680
0
0
0
0
28,030
64,375
35,000
770,000
35,000
20,000
79,845
804,100
855,000
16,000 20,000
20,000
104,000
543,275
30,000
49,697
518,125
1,085,937
100,000
45,000
0
122,500
61,833
1,085,937
15,000
0
100,000
!WATER
TC911
2,260,586 4,642,569 6,679,499 3,858,215
-34-
PRGRM/
DEPT PROJECT DESCRIPTION FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 TOTAL PAGE
WATER DEPARTMENT
Business Type
Water Meter Replacement
Program $ 79,845 $ 150,265 $ 153,370 $ 56,412 $ 159,580 $ 599,472 70
Manhole Replacement Rehab $ - $ - $ 25,000 $ - $ 25,000 $ 50,000 71
Water Main Upgrades during
Street General Repairs $ - $ - $ 20,000 $ - $ 25,000 $ 45,000 72
Maintenance of Public Water
Mains during Stone Retaining
Wall Repair $ - $ 20,000 $ - $ 22,550 $ - $ 42,550 73
Fire Hydrant Assembly
Relocation/Replacement for the
Sidewalk Program $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,400 $ 100,400 74
Cottingham Road Water Main $ 1,085,937 $ - $ - $ - $ - $ 1,085,937 75
Southwest Arterial Water Main
Extension $ 855,000 $ - $ - $ - $ $ 855,000 76
SCADA & Communications
Infrastructure $ 505,000 $ 325,000 $ - $ - $ - $ 830,000 78
North Cascade Road Water Main
Extension $ 804,100 $ $ - $ - $ - $ 804,100 80
Water Main Replacements -
Streets $ 209,000 $ 206,000 $ - $ - $ - $ 415,000 81
Water Main Replacements -
Sewer Consent Decree $ 122,500 $ - $ - $ - $ - $ 122,500 82
Public Lead Line Water
Replacement $ 61,833 $ 122,470 $ 84,500 $ - $ - $ 268,803 84
Water Line Extensions to New
Developments $ $ 307,500 $ 650,000 $ - $ $ 957,500 85
Wells, Well Field, and Raw
Transmission Piping Repair $ - $ 227,000 $ $ - $ 102,500 $ 329,500 86
Chesterfield Drive Water Main $ 15,000 $ 301,500 $ $ - $ - $ 316,500 87
Water Source & Hydraulic Model:
Master Plan $ $ 115,000 $ 25,000 $ - $ 25,000 $ 165,000 88
Water Storage Tank Coating
Program $ $ $ 150,000 $1,350,000 $ 100,000 $ 1,600,000 89
Old Davenport Road Water Main
Extension $ 100,000 $ $ $ - $ $ 100,000 90
Tamarak Park Frontage Road
Water Main $ $ $ $ 65,000 $ 600,000 $ 665,000 91
West End Annexation Phase II $ $ $ $ - $ 200,250 $ 200,250 92
West End Annexation Phase 1 $ $ $ $ - $ 70,000 $ 70,000 93
Creek Crossing Restoration $ $ $ $ - $ 35,000 $ 35,000 94
Total - Water Department $ 3,858,215 $1,794,735 $1,127,870 $1,513,962 $1,362,730 $ 9,657,512
-35-
This page left intentionally blank.
-36-