Water Department FY19 Budget Presentation Copyrighted
February 26, 2018
City of Dubuque Public Hearings # 1.
ITEM TITLE: Water Department FY2019 Budget Presentation
SUMMARY:
SUGGESTED DISPOSITION:
ATTACHMENTS:
Description Type
FY19 Water Department Budget Recommendation Supporting Documentation
Water Department
1-
This page intentionally left blank.
-2-
WATER DEPARTMENT
FY 2017 FY 2018 FY 2019 % Change From
Budget Highlights Actual Budget Requested FY 2018 Budget
Expenses
Employee Expense 2,309,196 2,302,821 2,420,488 5.1 %
Supplies and Services 2,251,937 2,466,500 2,495,838 1.2 %
Machinery and Equipment 502,187 875,824 869,690 (0.7)%
Administrative Overhead Recharges — 264,683 405,172 53.1 %
Finance Utility Billing 163,674 170,662 %
Engineering Water Maintenance Charges 858 — 20,046 — %
Payment in Lieu of Taxes 142,884 142,884 142,884 — %
Payment to Construction Fund 2,412,000 1,157,000 935,000 (19.2)%
Debt Service 1,605,994 1,653,146 3,115,807 88.5 %
Total Expenses 9,388,730 9,033,520 10,404,925 15.2 %
Resources
Operating Revenue 8,937,964 9,296,823 10,423,618 12.1 %
Total Resources 8,937,964 9,296,823 10,423,618 12.1 %
Net Operating Surplus (Deficit) (450,766) 263,303 18,693 -244,610
Personnel -Authorized FTE 25.57 25.57 25.87
Water User Fee Rate Increase 3% 3% 3%
Revenue 1% Rate Increase Generates $ 78,002
Improvement Package Summary
1 of 7
This improvement package would provide funding for two seasonal employees (paid interns) per year for
four years starting in Fiscal Year 2019 (+0.50 FTE or 1,040 hours annually). The City of Dubuque's Water
Department receives a wide range, in the style and quality, of water utility information supplied by
engineering firms, developers, contractors, and City staff. The Water Department's goal is to standardize
and homogenize the style and quality of work that is delivered to the City to ensure easy and complete
transfer of infrastructure data into our Utility GIS.
In 2017, the Water Department developed a plan to create a Water Distribution Record Centralization
project that encompasses how all information collected on the distribution system will be correctly entered,
stored, and accessed by the many entities that look to the water department for system records. The true
challenge of the project is the volume of work and the available manpower to complete the exercise.
Working with the GIS Specialist, he was tasked with prioritizing and organizing the current workload,
scheduling training of current staff, developing 'how-to' instruction sheets, and identifying staffing needs to
complete the project.
While many of the activities can be completed by current staff, the data entry of historic records and
verification of data on each record for approximately 24,000 records will require additional assistance. The
department is requesting two (2) seasonal employees (paid interns) per year for four years starting in FY19
for 522+hours/intern. There would be a non-recurring fee to purchase a computer for these positions
($2,100/position). The accuracy of data in GIS reduces the amount of time spent researching paper records,
reduces the number of trips back to the office to verify data, increases the accuracy of data used for
developing a hydraulic water model for planning and growth, and ensures records are available for future
-3-
use.
Related Cost: $ 19,520 Water User Fees Recurring Recommend -Yes
Related Cost: $ 4,600 Water User Fees Non-Recurring
Total Cost: $ 24,120
Water Rate Impact: 0.31%
Activity: Water Administration
2 of 7
This improvement package would provide funding for the City of Dubuque Eagle Point Water Plant security
gate system that is no longer supported, and at times, the card entrance reader does not work. The key fobs
and cards for the system cannot be programmed and the fobs are not operable. From time to time, plant
operators are not able to access the plant unless the shift operator is present in the control room. The shift
operator is responsible for sampling and testing every 2 hours and conducting observation rounds in the
plant and may not be in the control room. Each operator should be provided a card or key FOB that can be
programmed accordingly to allow access to the plant to start shift or during an emergency.
The cameras and monitors supporting the gate system to verify guests and oversee the physical plant are
also in need of replacement and were installed prior to 2007 and no longer depict a clear image.
Related Cost: $ 7,500 Water User Fees Non-Recurring Recommend -Yes
Water Rate Impact: 0.10%
Activity: Water Operations
3 of 7
This improvement package would provide funding for a full-time Water Distribution Field Inspector (GE-29B)
to increase the efficiency and quantity of the operation, documentation of water distribution piping system
from the field and projects being completed within the City. This position would be responsible for assisting
the Water Distribution Engineering Assistant, GIS Specialist and other staff with the documentation of the
City's operation, maintenance and construction of the water treatment plant, pump stations, tanks, towers,
wells and the water distribution network. This person would field inspect all water field activities both public
and private in accordance with Federal, State and local codes and ordinances. Produce as-built drawings of
new or replaced water assets in addition to the collection of GPS coordinates for input into the City's
Geographic Information System. As the city continues to grow and the water system becomes of age
creates a demand on staff time to focus on its growth and maintenance. This position will support the
proactive sustainable approach of being as effective and efficient with the operation in providing
uninterrupted service to the citizens, contractors, developers and engineering firms that are served. Non-
Recurring includes a smart phone ($375) and computer ($2,100).
Related Cost: $ 69,895 Water User Fees Recurring Recommend - No
Related Cost: $ 2,475 Water User Fees Non-Recurring
Total Cost: $ 72,370
Water Rate Impact: 0.93%
Activity: Water Distribution
4 of 7
This improvement package would provide funding for the purchase of a front mounted extended reach valve
operator. This device would be mounted to the front bumper of the valve turning and vacuum excavator
vehicle number 4905 truck. This device provides hands free operation with intelligent automation. The
expandable arm provides full 750 ft/lbs of torque, and the device is fully compatible with VITALS software
which enables full data logging and sync between the hand held controller and our desktop GIS system. In
-4-
addition to the automatic input of data the front mounted operator provides safer and simpler access in the
operation of valve turning.
Related Cost: $ 23,000 Water User Fees Non-Recurring Recommend -Yes
Water Rate Impact: 0.29%
Activity: Water Distribution
5 of 7
This improvement package transfers the meter reads/service division that is now under the Finance
Department to the water meter division under the Water Department into one division that will reside in the
Water Department. Water meter activities currently under two separate departments are completing many of
the same tasks, but reporting to two different supervisors to complete their work. This has become
cumbersome and inefficient. Combining the two divisions under one supervisor will allow for a streamlined
process for repairing and replacing water meters throughout the city. This will also save $2,700 a year in on-
call pay.
This improvement package would also provide funding for the promotion of a Water Meter Repair Worker I
to a Water Repair Worker II position. There are currently three Water Meter Repair Worker 1 positions and
the work load for each differs in both technical ability and responsibility, and there are two additional meter
repair workers in Utility Billing. Due to the varying workload, technical ability, technology ability, customer
service, and general approach to working with meters, MIUs, and customers, a lead or step up water meter
repair worker will improve the overall efficiency of the meter section.
Related Cost: $ 5,230 Water User Fees Recurring Recommend -Yes
Related Cost Savings: $ (2,700) Water User Fees Recurring
Total Cost: $ 2,530
Water Rate Impact: 0.03%
Activity: Water Meters
6 of 7
This improvement package is for the elimination of the full-time Water Plant Manager (-1.0 FTE or-2,080
hours annually) which is a frozen position and a full-time Water Operator (-1.0 FTE or-2,080 hours
annually) which has been a vacant position since Fiscal Year 2018. The Water Plant Manager was frozen in
Fiscal Year 2018 and has not been a funded position since Fiscal Year 2017. The Fiscal Year 2018 budget
for the Water Operator was used to support contract operations assistance for a limited one-year term
contract of$48,908, and plant overtime during the transition period while current operators were trained to
cover shifts. The elimination of the full-time Water Plant Manager is a cost savings of$124,887 and the
elimination of the full-time Water Operator is a cost savings of$73,997.
Related Cost Savings: ($74,959) Water User Fees Recurring Recommend -Yes
Water Rate Impact: (0.96)%
Activity: Plant Operations and Maintenance
7 of 7
This improvement package is upgrade the part-time secretary position (0.50 FTE or 1,040 hours annually)
to a full-time confidential account clerk position (1.0 FTE or 2,080 hours annually). 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, 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.
-5-
For each call out of the water distribution crew 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. Ordering of new parts and materials may be handled by the engineering assistant,
the water distribution foreman or the water distribution supervisor and replenished on an as needed basis.
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.
Related Cost Savings: $36,772 Water User Fees Recurring Recommend - No
Water Rate Impact: 0.47%
Activity: Water Administration
Significant Line Items
Employee Expense
1. FY 2019 employee expense reflects a 1.5% wage package increase.
2. The Iowa Public Employee Retirement System (IPERS) City contribution increased from 8.93% in
FY 2018 to 9.44% in FY 2019. This resulted in an increase of City (PERS expense of$8,090 in
Water. The employee contribution increased from 5.95% in FY 2018 to 6.29% in FY 2019.
3. The City portion of health insurance expense is decreased from $1,325 in FY 2018 to $1,193 in FY
2019 per month per contract which results in an annual cost savings of -$23,850 or-10.00%.
4. Overtime is increased from $90,040 in FY 2018 to $94,040 in FY 2019 based on the last three years
of actual expenses. FY 2017 actual was $70,114.
5. Sick Leave Payout is increased from $16,474 in FY 2018 to $32,279 in FY 2019.
6. The Water Plant Manager position is frozen until June 30, 2019 with cost savings of$111,588 in FY
2019.
Supplies & Services
7. Property Insurance increased from $73,764 in FY 2018 to $77,050 in FY 2019.An appraisal of all
city buildings was completed during FY 2018. Property insurance cost is now allocated to
-6-
departments based on the appraised value of the building and square footage used by each
department.
8. Electricity Utility Expense increased from $603,738 in FY 2018 to $633,850 in FY 2019 based on FY
2017 actual of$555,798 plus 12.5% and the addition of English Mill Pump Station for an additional
$8,000.
9. Sales Tax expense increased from$476,890 in FY 2018 to $516,274 in FY 2019 based on increased
water rates in FY 2019 of 3%. This expense is directly offset by Sales Tax Revenue.
10. Machinery and Equipment Maintenance decreased from $128,233 in FY 2018 to $100,660 in FY
2019 based on FY 2017 actual plus a 2% increase in lab supplies.
11. Costs for Fluoride, Phosphate, Chlorine, Lime, and Polymer expense (water processing materials)
are projected to increased from $396,900 in FY 2018 to $399,400 in FY 2019 based on FY 2017
actual of$390,654 plus 2%.
12. Hauling Services increased from$148,250 in FY 2018 to $150,000 in FY 2019. It is anticipated that
the hauling contract for lime sludge will increase 5% each year. The amount of hauled tons of lime
sludge is highly variable from year to year based on water usage. FY 2017 actual expense was
$129,154.
13. Property Maintenance decreased from $73,088 in FY 2018 to $52,210 in FY 2019 based on a three-
year average. FY 2017 actual was $41,607.
14. Pipe Special Fittings is unchanged from $70,000 in FY 2018 to $70,000 in FY 2019.
15.Valves increased from $10,000 in FY 2018 to $33,600 in FY 2019 based on a three-year average.
FY 2017 actual was $62,190.
16. Environment Testing/Monitoring increased from $45,000 in FY 2018 to $60,000 in FY 2019. FY 2017
actual was $40,958. It is expected that there will be increased samples due to boil advisories and
chlorine monitoring.
Machinery & Equipment
17. Equipment replacement items at the maintenance level include ($869,690):
Administration
Smart Phone (1) $ 350
Meters
Cell Phones (6) $ 120
Software $ 13,650
Large Water Meters $ 27,000
Plant Operation & Maintenance
Laboratory Equipment $ 3,500
Shop Equipment $ 1,000
Pumps $ 1,000
-7-
Water Distribution System
Hydrants $ 35,000
Leak Detection Equipment $ 45,500
Electric Pump (2) $ 3,000
Cut Off Saw $ 1,800
Tapping Machine $ 6,200
Cell Phones (3) $ 470
2009 Ford Van $ 95,000
2002 Freightliner Dump Truck $ 110,000
Software $ 500
Annual Maintenance Proiects
Automatic Meter Reading System Maintenance $ 15,000
Pump Replace Vacuum Filter $ 20,000
Generator Maintenance Program $ 18,000
Large Valve Replacement (2) $ 25,000
Water Main Replacements (Repair of 70 mains) $ 300,000
Large Water Meters $ 75,000
Water Valve Box Maintenance (Public Works) $ 20,000
Water Meter Testing $ 25,000
Recommended Improvement Packages $ 27,600
Total $ 869,690
Debt Service
18. Debt service reflects repayment to ($3,115,807):
Final Call
Amount Debt Series Source Purpose Payment Date
$ 55,540 SRF 2007A Water Fees Clear Wells 2028
$ 114,388 Revenue 2008D Water Fees Water Improvements 2023 2016
$ 218,230 SRF Series 2009 Water Fees Meter Change-Out 2031
$ 383,250 Revenue 2010D Water Fees Water Improvements 2030 2017
$ 110,253 G.O. 2011A Water Fees Water Improvements 2031 2018
$ 43,387 G.O. 2012E Water Fees Water Improvements 2032 2018
$ 129,850 G.O. 2012D Water Fees Water Improvements 2033 2019
$ 765,131 G.O. 2014B Water Fees Water Improvements 2032 2021
$ 45,288 G.O. 2016C Water Fees Water Improvements 2033 2024
$ 130,490 SRF 2017 Water Fees CIWA Purchase/Imp 2036
$1,120,000 CIWA Contract Water Fees Water Improvements 2022
$3,115,807 Total Water Debt Service
Revenue
19.Water User Fees increased from $8,149,680 in FY 2018 to $8,166,483 in FY 2019. Increase is
based on FY 2017 actual of$7,800,231 plus the FY 2018 rate increase of 3% and the FY 2019
projected rate increase of 3%.
-8-
20. Flat Rates decreased from $20,000 in FY 2018 to $16,296 in FY 2019 based on FY 2017 actual of
$16,296.
21. Fire Protection Rates increased from $150,000 in FY 2018 to $161,368 in FY 2019 based on FY
2017 actual of$161,368.
22. Taps increased from $33,000 in FY 2018 to $33,905 in FY 2019 based on a three year historical
average. FY 2017 actual was $28,123.
23. Tap Service increased from $22,500 in FY 2018 to $24,938 in FY 2019 based on FY 2017 actual of
$24,938.
24. Connection Charge Front Footage decreased from$49,435 in FY 2018 to $18,671 in FY 2019 based
on FY 2017 actual expense of$18,671.
25. Backflow Prevention Administrative Fees increased from$66,038 in FY 2018 to $70,617 in FY 2019
based on FY 2017 actual of$70,617. This is the $25 annual fee charged to all customers with a
backflow device.
26. Penalties increased from $81,092 in FY 2018 to $82,636 in FY 2019 based on a three year historic
average. FY 2017 actual was $77,134.
27. Tower Monthly Rental increased from $80,183 in FY 2018 to $89,449 in FY 2019 based on FY 2017
actual of$89,449.
28. Sales Tax Collected increased from $476,890 in FY 2018 to $516,274 in FY 2019 based on the rate
increase for water fees. This line item off-sets the sales tax expense.
-9-
City of Dubuque
Water Department
Organizational Chart
(1)Water
Department
Manager
(0.5)
Secretary
r
(1)Water (1) (1)GIS (7)Plant (1)Equipment (1)Electronic
Distribution Engineering Specialist Operators Mechanic Technician
Supervisor Assistant
(1)Water (1)Meter (0.5)GIS
Distribution Repair Worker Seasonal
Foreman I I Interns
(2)Equipment (2.8)Meter
Operator II Repair Worker
(4) (1)Water
Distribution Meter
Workers Inspector
-10-
WATER DEPARTMENT
The Water Department ensures our community has high quality, safe, reliable and affordable
drinking water.
Water
Department
r I 1 I
Plant Water
Administration Operations and Distribution Water Meters
Maintenance
SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE
LEADING TO OUTCOMES
PLANNING
The Water Department is engaged in
PEOPLE conscientious, strategic planning which
allows for maintaining compliance with the
Employees of the Water state and federal regulatory agencies in
Department are provided training order to provide the highest quality, safe
to ensure the maintenance of the and cost effective drinking water possible.
appropriate licenses required by
the Iowa Department of Natural pp si
Resources. Other job-related _! ! il
educational training is provided ---
to broaden employee skills and -- ,,,.'- •'
increase productivity. i ^ -- ._
a
'4101111111b. i
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.
-11-
WATER DEPARTMENT
Resources and Property Tax Support
$11,000,000 $10,423,618
$10,000,000 $8,937,964 $9,296,823
$9,000,000 ill il
$8,000,000
$7,000,000
$6,000,000
$5,000,000
$4,000,000
$3,000,000
$2,000,000
$1,000,000
$0
Operating Revenue
II FY 2017 II FY 2018 FY 2019
The Water Department is supported by 25.87 full-time equivalent employees, which accounts for
23.26% of the department expense as seen below. Overall, the department's expenses are expected to
increase by 15.18% in FY 2019 compared to FY 2018.
Expenditures by Category by Fiscal Year
$3,500,000
$3,000,000
$2,500,000
$2,000,000
$1,500,000 I I I I I
$1,000,000 I I I I I
$500,000 I I , I I
kil
$0 m u) ,II m y . = C �i� n o
o a3 O 6
o 5 H
CD
3 O W 0 CD
Z
X 7 Q .. co
o n
a c CD
CD CD
c Q
CD 5
CD
W
FY 2017 U FY 2018 U FY 2019
-12-
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 2017 Actual FY 2018 Budget FY 2019 Requested
Expenditures $2,348,151 $2,417,082 $3,943,635
Resources $20 $— 6—
Water Administration Position Summary
FY 2019
Water Department Manager 1.00
Secretary 0.50
GIS Specialist 1.00
GIS Intern 0.50
Total FT Equivalent Employees 3.00
Highlights of the Past Year
• Purchased Central Iowa Water Association's Vernon and Barrington Lakes Water
Systems, thereby increasing the availability of safe, clean drinking water and fire flow
suppression to Dubuque County residents.
I . .
Vernon and Barrington Lakes Water System
-13-
WATER DEPARTMENT
• Obtained favorable financing from the State of Iowa Revolving Fund to extend water
mains and installation of the English Mill Pump station, bringing City water supply to
Vernon and Barrington Lakes water systems.
• Implemented Standard Operating Procedures in response to water main breaks, and
sanitary and unsanitary water conditions.
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 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/1
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.
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.
-14-
WATER DEPARTMENT
Over two hundred tests per day are performed by water treatment plant operators. In addition
to these tests, the Dubuque Water & Resource Recovery Laboratory performs over 60
bacteriological analyses of our drinking water on a monthly basis. Other compliance related
testing is performed by the University of Iowa Hygienic Laboratory and Keystone Laboratories.
All of these analytical measures ensure that the water reaching your home is safe to drink
Plant Operations and Maintenance Funding Summary
FY 2017 Actual FY 2018 Budget FY 2019 Requested
Expenditures $2,427,048 $2,525,835 $2,485,477
Resources $679 $250 $480
Plant Operations and Maintenance Position Summary
FY 2019
Electronic Technician 1.00
Equipment Mechanic 1.00
Plant Operator II 3.00
Plant Operator III &IV 1.00
Plant Operator IV 3.00
Total FT Equivalent Employees 9.00
Highlights of the Past Year
• Completed Well #8 Maintenance
• Maintained Regulatory Compliance
• Completed the 2016 - 2017 Consumer Confidence Reports for Dubuque, Vernon and
Barrington Lakes Water Systems.
Future Initiatives
• Maintain the operations 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.
4frGoal: Sustainable Environment
Outcome#1: Provide water treatment and distribute safe, clean, drinking water that
meets or exceeds drinking water regulations
-15-
WATER DEPARTMENT
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.
{
TotalTrihaIomethanes(ppb) •O(NM) W11� #0.00(i)•1a) 01/30/2016 NO
Total Haloacetic Acid
{ppb) 40W ) 1i1144 SAO-q 00/1012016 NO
Lead(ppb) -16 0 >4 L0011O-q 2015 NO
f
Copper(ppm ) MMU 0.31 crlpl5 o.02moui 1 M 00
i Water {pp 11/4.-is
S1�STEM
! Total Chlorine{ppm) Ma I la
rl -44 RAI LIp.16•1.761 0/XV2016 Nd
Total Coliform Bacteria IT(11) NM #S""Rles 14'11/1016 NO
' Quality NOWA
Report fllilSllED WATER TAP
I
,Th2017 Fluoride(ppm) 1(4) 964 46 01V0I1012 NO
F Barium (Rpm) 2(21 961 GAM11110112012 NO
�4rnrivw wr�biy�i
Sodium(Ppm) WA 1111W SO4 11 Of/211201S No
The 2017 Water Quality Report can be downloaded at
http://www.citvofdubuque.orq/waterqualitv
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
Water Treated (Million Gallons)
2,900 —
2,800 —
2,700
2,600
2,500
FY 08 FY 09 FY 10 FY 11 FY 12 FY 13 FY 14 FY 15 FY 16 FY 17
-16-
WATER DEPARTMENT
DID YOU
KNOW?
141.
Dubuque's drinking 4
•
water comes from •
•1 'il,' �
wells. There are five e, J• I � <e
shallow wells located
i..
at the A.Y. McDonald � _
Park and four deep ._._
wells located around
the Eagle Point Water - - -
Treatment PLant on
Hawthorne Street.
Water Distribution
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
11111111
FY 2017 Actual FY 2018 Budget FY 2019 Requested
Expenditures $3,862,513 $2,895,469 $2,935,545
Resources $8,831,994 $9,137,641 $10,309,518
Water Distribution Position Summary
FY 2019
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
-17-
WATER DEPARTMENT
Highlights of the Past Year
• Completion of English Ridge subdivision water main installation
• 90% Completion of Highway 20/Menards intersection water main installation
• Completion of Derby Grange Road & Kennedy Road water main installation
• Completion of Water main improvements through the Green Alley projects
• Completion of the B-Branch Utility replacements
• 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.
AJ Goal: Financially Responsible, High Performance Organization i'•
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
.ice.. .. ..
Derby Grange Road and Kennedy Road 12'Wawter Main Installation
Outcome #2: Addressing customer and system issues in a timely manner
Minimizes the time customers are without water
-18-
WATER DEPARTMENT
Main Breaks I
DID YOU
KNOW?
The distribution 137
system is composed
of 336 miles of water -
mains ranging in
diameter from 4" up
— 70 69
11 —
to 30", 7,196 control60valves; and 2,444 firehydrants -
FY'12 FY'13 FY'14 FY'15 FY'16 FY17
Service Taps
301
278
206
179 _r_
109
FY'12 FY'13 FY'14 FY'15 FY116 FY'17
Service taps are new connections to the public water mains
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.
-19-
WATER DEPARTMENT
Water Meters Funding Summary
FY 2017 Actual FY 2018 Budget FY 2019 Requested
Expenditures $242,205 $332,035 $497,222
Resources $105,025 $158,932 $113,620
Water Meters Position Summary
FY 2019
Water Meter Repair Worker I 2.00
Water Meter Repair Worker II 1.00
Water Meter Inspector 1.00
Water Meter Service Worker I 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.
-20-
WATER DEPARTMENT
ID YOU KNOW? di (41II*- .
Since the adoption by _
the Dubuque City • ' . le / ;�
Council of the Backflow • ti - i� iii �4- i-
Prevention Program, we '" _
have established over '' 1
2,004 accounts having /1'Y' • t -: 4
Backflow Protection `'
Iand we also monitor -
over 2,772 Control -
Devices. These Typical Meter/Fire Sprinkler Room
accounts are a
combination of various
Industrial and
ommercial facilities.
Annually we receive
$25.00 per device as ,; .
the administration fee. Itt
' 4 .
is expected an
additional 50 accounts " .
will be established e' fr,
before the end of the I,` ;, 1
fiscal year 2019. `� i,
‘.....,,
Meter
-21-
WATER DEPARTMENT
Outcome #3: Responding to customer inquiries in a timely manner
Maintains consumer confidence in the water utility
Service Calls
800 —
700
600
500
400 ■ ■ ■ ■ ■
■ w ■
300 ■ ■ ■ ■ ■
100 ■ ■ ■ • ■
0
FY12 FY13 FY14 FY15 FY16 FY17
_22_
Recommended Operating Revenue Budget - Department Total
42 -WATER
FY16 Actual FY17 Actual FY18 Adopted FY19 Recomm'd
Fund Account Account Title Revenue Revenue Budget Budget
640 43110 INVESTMENT EARNINGS 27,640 38,222 27,461 35,000
43-USE OF MONEY AND PROPERTY 27,640 38,222 27,461 35,000
640 51105 METER RATES 7,677,554 7,800,231 8,149,680 8,166,483
640 51106 UB REFUND CLEARING ACCT (6) 0 0 0
640 51110 FLAT RATES 20,685 16,296 20,000 16,296
640 51111 FLAT RATE KEY WEST 29,871 41,534 0 0
640 51115 FIRE PROTECTION RATES 155,143 161,368 150,000 161,368
640 51125 TAPS-3/4&1 INCH 42,056 28,123 33,000 33,905
640 51130 CONNECT CHG LARGE SERVICE 36,260 24,938 22,500 24,938
640 51135 CONNECT CHG FRONT FOOTAGE 75,905 18,671 49,435 18,671
640 51140 METER SALES-REMOTES 456 1,840 456 500
640 51145 SALE OF METERS 32,987 17,139 75,350 25,000
640 51146 SALE OF UFR DEVICES 5,973 5,420 5,973 5,973
640 51160 BOX-LID-PART SALES 0 5 0 0
640 51165 MAINTENANCE CHARGES 7,327 6,390 7,327 7,304
640 51170 REPAIR OF METERS 10,493 8,868 10,493 10,271
640 51175 SHUT OFF PENALTIES 22,923 23,721 22,923 23,721
640 51176 METER TAMPERING FEE 1,789 1,319 1,789 1,319
640 51177 CALL OUT CHARGE 1,618 795 1,618 1,000
640 51180 CROSS CON.CNTL ADMIN FEE 66,038 70,617 66,038 70,617
640 51215 PENALTIES 81,581 77,134 81,092 82,636
640 51310 MONTHLY RENTAL 80,183 89,449 80,183 89,449
640 51720 UB-W TR RPR TEMP HOLDING 1,285 0 0 0
51-CHARGES FOR SERVICES 8,350,121 8,393,858 8,777,857 8,739,451
640 53201 REFUNDS 119 0 0 0
640 53605 MISCELLANEOUS REVENUE 0 72 0 0
640 53610 INSURANCE CLAIMS 0 2,205 0 119
640 53615 DAMAGE CLAIMS 14,241 15,397 14,241 12,221
640 53620 REIMBURSEMENTS-GENERAL 2,467 93 124 73
640 53630 SALES TAX COLLECTION 450,414 486,637 476,890 516,274
53-MISCELLANEOUS 467,241 504,404 491,255 528,687
640 54109 SALVAGE SALES 250 1,359 250 480
640 54230 SRF GO BOND PROCEEDS 0 0 0 1,120,000
54-OTHER FINANCING SOURCES 250 1,359 250 1,120,480
640 59100 FR GENERAL 60,944 0 0 0
640 59500 TRF TO PEONY TRUST 584 0 0 0
59-TRANSFER IN AND INTERNAL 584 0 0 0
42-WATER TOTAL 8,845,836 8,937,843 9,296,823 10,423,618
-23-
Recommended Operating Expenditure Budget - Department Total
42 -WATER
FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd
Fund Account Account Title Expense Expense Budget Budget
640 61010 FULL-TIME EMPLOYEES 1,459,520 1,467,387 1,411,566 1,458,560
640 61020 PART-TIME EMPLOYEES 4,707 4,900 22,091 63,505
640 61030 SEASONAL EMPLOYEES 0 1,125 0 16,671
640 61050 OVERTIME PAY 63,023 70,114 90,040 94,040
640 61071 HOLIDAY PAY-OVERTIME 17,562 17,135 17,000 17,000
640 61072 TANK CLIMBING PAY 90 90 1,200 1,200
640 61091 SICK LEAVE PAYOFF 7,044 9,346 16,474 32,279
640 61092 VACATION PAYOFF 0 4,292 0 0
640 61310 IPERS 137,960 139,375 137,690 155,851
640 61320 SOCIAL SECURITY 113,605 114,748 119,219 128,771
640 61410 HEALTH INSURANCE 403,427 393,964 381,600 357,750
640 61415 WORKMENS'COMPENSATION 80,174 82,465 94,589 87,466
640 61416 LIFE INSURANCE 1,106 1,059 2,656 1,245
640 61620 UNIFORM ALLOWANCE 762 0 0 0
640 61640 SAFETY EQUIPMENT 2,814 2,460 6,000 4,750
640 61650 MEAL ALLOWANCE 584 484 500 500
640 61660 EMPLOYEE PHYSICALS 2,841 254 2,196 900
61-WAGES AND BENEFITS 2,295,219 2,309,198 2,302,821 2,420,488
640 62010 OFFICE SUPPLIES 3,426 3,342 3,850 4,009
640 62011 UNIFORM PURCHASES 14,093 13,006 14,550 15,686
640 62030 POSTAGE AND SHIPPING 1,354 1,780 2,445 1,700
640 62033 HAND TOOLS/EQUIPMENT 5,020 6,032 5,120 5,265
640 62034 REPAIR PARTS/SUPPLIES 10,690 8,669 13,595 7,846
640 62036 CONSTRUCTION SUPPLIES 1,528 856 2,900 1,830
640 62060 O/E MAINT CONTRACTS 0 80 0 0
640 62061 DP EQUIP.MAINT CONTRACTS 16,955 17,453 17,608 20,268
640 62062 JANITORIAL SUPPLIES 4,746 4,689 4,650 4,750
640 62063 SAFETY RELATED SUPPLIES 2,858 5,122 2,930 3,000
640 62064 ELECTRICAL SUPPLIES 9,254 10,199 9,650 10,453
640 62065 LAB SUPPLIES 12,202 12,754 12,260 13,500
640 62066 PLUMBING MATERIALS 12,128 585 12,370 2,000
640 62090 PRINTING&BINDING 1,371 844 1,400 920
640 62110 COPYING/REPRODUCTION 2,080 1,681 2,069 1,545
640 62130 LEGAL NOTICES&ADS 472 1,705 4,540 38,100
640 62170 SUBSCRIPTIONS-BOOKS-MAPS 716 1,227 1,380 870
640 62190 DUES&MEMBERSHIPS 3,543 2,543 4,485 4,615
640 62204 REFUNDS 9,623 5,396 9,815 5,091
640 62206 PROPERTY INSURANCE 84,655 71,583 73,764 77,050
640 62207 BOILER INSURANCE 6,730 0 0 0
640 62208 GENERAL LIABILITY INSURAN 20,926 20,896 21,942 21,392
640 62210 SALES TAX 445,192 489,433 476,890 516,274
640 62216 REFUND LEAK ALLLOWANCE 3,017 0 3,077 0
640 62310 TRAVEL-CONFERENCES 2,532 2,256 6,800 6,000
640 62320 TRAVEL-CITYBUSINESS 0 0 200 200
640 62340 MILEAGE/LOCAL TRANSP 4,169 4,738 4,512 4,150
640 62360 EDUCATION&TRAINING 4,955 9,289 17,350 14,755
640 62411 UTILITYEXP-ELECTRICITY580,517 555,798 603,738 633,850
640 62412 UTILITYEXP-GAS28,210 32,174 31,031 33,783
-24-
Recommended Operating Expenditure Budget - Department Total
42 -WATER
FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd
Fund Account Account Title Expense Expense Budget Budget
640 62414 UTILITY EXP-FUEL OIL 3,375 1,488 3,442 1,500
640 62415 UTILITY EXPENSE STORMWATR 169 180 173 180
640 62421 TELEPHONE 7,783 9,489 12,710 11,487
640 62423 TELECOMMUNICATION CG 7,939 7,898 8,098 7,898
640 62424 RADIO/PAGER FEE 0 0 2,500 0
640 62431 PROPERTY MAINTENANCE 43,615 41,607 73,088 52,210
640 62433 CUSTODIAL SERVICES 0 0 700 0
640 62435 ELEVATOR MAINTENANCE 175 1,488 2,000 2,000
640 62436 RENTAL OF SPACE 1,764 1,764 1,799 2,244
640 62437 BARRICADE RENTAL 5,364 3,226 5,471 5,000
640 62511 FUEL,MOTOR VEHICLE 20,007 18,464 20,007 21,964
640 62521 MOTOR VEHICLE MAINT. 20,701 32,950 21,783 20,992
640 62522 VEHICLE MAINT.,ACCIDENT 0 2,641 0 0
640 62528 MOTOR VEH.MAINT.OUTSOUR 5,601 4,321 5,713 5,633
640 62611 MACH/EQUIP MAINTENANCE 89,832 84,232 128,233 100,660
640 62613 METER MAINTENANCE 1,930 379 14,000 10,000
640 62614 EQUIP MAINT CONTRACT 0 0 0 835
640 62615 MACH/EQUIP MAINT.OUTSOUR 266 3,727 500 1,500
640 62628 INSTRUMENTATION MAINT 0 3,615 0 0
640 62630 FLUORIDE 0 13,074 14,700 14,700
640 62631 LIME 282,155 261,335 266,500 265,000
640 62632 PHOSPHATE 59,191 70,696 67,000 71,000
640 62633 CHLORINE 31,655 38,693 40,000 40,000
640 62638 POLYMER 6,783 6,855 8,700 8,700
640 62639 LIQUID CO2/02 13,353 16,217 18,000 16,460
640 62663 SOFTWARE LICENSE EXP 992 1,256 15,586 351
640 62664 LICENSE/PERMIT FEES 7,027 7,061 7,167 7,200
640 62667 INTERNET SERVICES 1,506 1,777 2,466 4,152
640 62669 PROGRAMMING 7,037 5,062 25,000 25,000
640 62671 MISC.OPERATING SUPPLIES 15 0 0 0
640 62675 VALVES 967 62,190 10,000 33,600
640 62676 PIPE-SPECIAL FITTINGS 56,886 38,264 70,000 70,000
640 62692 LANDFILL FEES 15 759 200 200
640 62696 OUTSIDE COLLECTOR EXPENSE 8,024 6,884 8,319 7,400
640 62710 CONTRACTOR SERVICES 0 0 500 0
640 62713 LEGAL SERVICES 32,451 144 0 0
640 62716 CONSULTANT SERVICES 13,860 29,000 14,137 0
640 62726 AUDIT SERVICES 2,500 3,000 3,700 4,070
640 62731 MISCELLANEOUS SERVICES 4,150 6,966 20,000 20,000
640 62746 ONE CALL OPERATION 5,568 4,932 5,679 0
640 62765 GRANTS 5,409 6,061 8,500 5,000
640 62767 ENVIRON.TESTING/MON. 33,685 40,958 45,000 60,000
640 62780 HAULING SERVICES 141,199 129,154 148,250 150,000
640 62820 STREET DIVISION SERVICES 1,920 0 1,958 0
62-SUPPLIES AND SERVICES 2,217,831 2,251,937 2,466,500 2,495,838
640 71120 PERIPHERALS,COMPUTER 200 0 7,580 0
640 71123 SOFTWARE 883 1,790 2,000 14,150
640 71124 MICRO-COMPUTER 0 0 0 4,600
-25-
Recommended Operating Expenditure Budget - Department Total
42 -WATER
FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd
Fund Account Account Title Expense Expense Budget Budget
640 71312 VAN/PICKUP/WAGREPL 0 0 42,000 95,000
640 71314 TRUCK-REPLACEMENT 0 0 70,000 0
640 71318 HEAVYEQUIP-REPLACEMENT0 88,941 0 110,000
640 71329 VEHICLE ACCESSORIES 0 0 0 23,000
640 71410 SHOP EQUIPMENT 266 408 2,200 1,000
640 71413 LABORATORY EQUIPMENT 481 4,558 3,500 3,500
640 71415 SAWS 0 0 0 1,800
640 71419 TAPPING MACHINE 17,770 768 0 6,200
640 71510 HYDRANTS 14,785 66,517 70,000 35,000
640 71511 PUMPS 3,487 1,099 21,000 24,000
640 71516 LARGE WATER METERS 81,356 93,888 83,500 102,000
640 71550 MISCELLANEOUS EQUIPMENT 0 0 0 45,500
640 71619 OTHER MAINT.EQUIPMENT 1,399 22,324 0 0
640 72410 PAGER/RADIO EQUIPMENT 0 0 46,175 0
640 72415 ELECTRONIC DATA COLLECTOR 0 0 2,644 0
640 72418 TELEPHONE RELATED 36 948 1,925 940
640 72515 TEST EQUIPMENT,OTHER 318 1,099 1,000 0
71-EQUIPMENT 120,981 282,340 353,524 466,690
640 72115 BARRICADES/WARN SIGNALS 89 644 1,000 0
72-EQUIPMENT 89 644 1,000 0
640 73211 CONST.CONTR-NOTBLDG 137,919 219,203 503,300 385,000
640 73410 EQUIP ACQUISITION 0 0 18,000 18,000
73-CIP EXPENDITURES 137,919 219,203 521,300 403,000
640 74111 PRINCIPAL PAYMENT 833,193 876,595 709,290 2,191,434
640 74112 INTEREST PAYMENT 732,244 729,399 943,856 924,373
74-DEBT SERVICE 1,565,437 1,605,994 1,653,146 3,115,807
640 91100 TO GENERAL 142,985 142,884 407,567 548,056
640 91740 TO WATER CONSTRUCTION 354,466 2,412,000 1,157,000 935,000
91-TRANSFER TO 497,451 2,554,884 1,564,567 1,483,056
42-WATER TOTAL 6,834,927 9,224,200 8,862,858 10,384,879
-26-
Recommended Expenditure Budget Report by Activity & Funding Source
42 -WATER
UNDISTRIBUTED - 10640
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY IS Adopted Budget FY19 Recomm'd Budget
SUPPLIES AND SERVICES 11,975 20,531 12,491
TRANSFER TO 2,554,884 1,564,567 1,483,056
UNDISTRIBUTED 2,566,859 1,585,098 1,495,547
WATER ADMINSTRATION -42100
-
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY1S Adopted Budget FY19 Recomm'd Budget
DEBT SERVICE 1,605,994 1,653.146 3,115,807
EQUIPMENT 4,950
SUPPLIES AND SERVICES 507,687 501,994 539,855
WAGES AND BENEFITS 234,469 261,942 283,023
WATERADMINSTRATION I i l 2,417,0:i_:
METERS
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
EQUIPMENT 8,139 22,000 40,770
SUPPLIES AND SERVICES 14,328 50,716 40,612
WAGES AND BENEFITS 219,738 259,319 415,840
METERS 242,205
PLANT OPER. &MAINT -42400
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
EQUIPMENT 5,144 48,625 5,500
SUPPLIES AND SERVICES 1,399,715 1,557,801 1,625,971
WAGES AND BENEFITS 1,022,189 919,409 854,006
PLANT OPER.&MAINT 2,427,048 2,525,835
WATER DISTR.SYSTEM -42700
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
CIP EXPENDITURES 5,379
EQUIPMENT 182,162 195,399 320,470
SUPPLIES AND SERVICES 275,312 252,821 251,909
WAGES AND BENEFITS 832,800 862,151 867,619
WATER DISTR.SYSTEM 1,295,
STORAGE TANK INSPECT/654MON-427051,310,371
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
SUPPLIES AND SERVICES - 14,137 -
STORAGE TANK INSPECT/MON 14,137
-27-
Recommended Expenditure Budget Report by Activity & Funding Source
42 -WATER
AUTO MTR RD SYS MNT PROG-42710
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
CIP EXPENDITURES 9,057 15,000 15,000
AUTO MTR RD SYS MNT PROG 9,057 15,000 AI 15,000
PUMP REPLC VACUUM FILTER-42713
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
EQUIPMENT — 20,000 20,000
Mir
UMP REPLC VACUUM FILTER — 20,000
FILTER MAINT PROGRAM - 42715
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
CIP EXPENDITURES — 25,000 —
ILTER MAINT PROGRAM — 25,000
FIRE HYDRANT PAINTING -42720 IMMI
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
SUPPLIES AND SERVICES 320 5,000 5,000
FIRE HYDRANT PAINTING 320 5,000 5,000
GENERATOR MAIN PROGRAM -42725 Ai
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
CIP EXPENDITURES — 18,000 18,000
IIIII
GENERATOR MAIN PROGRAM — 18,000' II
GIS MAINT/UPDATES -42730
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
SUPPLIES AND SERVICES 892 15,000
Ilim—
GIS MAINT/UPDATES 892 15,000 —
SERVICE LINE ASSIST -42735
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
SUPPLIES AND SERVICES 6,646 15,000 15,000
IP
SERVICE LINE ASSIST 6,646 15,000 15,000
VALVE EXERCISE PROGRAM -42740
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
-28-
Recommended Expenditure Budget Report by Activity & Funding Source
42 -WATER
SUPPLIES AND SERVICES — 25,000 —
VALVE EXERCISE PROGRAM — —
VALVE REPLACEMENT -4274
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
CIP EXPENDITURES 25,000 25,000
VALVE REPLACEMENT — 25,000 25,000
MIL INTERNAL LINES LOAN -42750
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
CIP EXPENDITURES — 45,000 —
INTERNAL LINES LOAN — 45,000
WATER MAIN REPLACEMENTS -42755
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
CIP EXPENDITURES 135,289 321,500 300,000
WATER MAIN REPLACEMENTS 135,289
WATER METER EXCHANGE -42760
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
EQUIPMENT 87,538 68,500 75,000
WATER METER EXCHANGE 87,538
WATER LEAK REPAIR GRANT -42765
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
SUPPLIES AND SERVICES 6,061 7,000 5,000
WATER LEAK REPAIR GRANT 6,061 7,000 5,000
AIL COUNTY WATER ASSISaifirinaliatt
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
SUPPLIES AND SERVICES — 1,500 —
COUNTY WATER ASSISTANCE — 1,500
WATER VALVE BOX MAINT -42770
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
CIP EXPENDITURES 19,255 20,000 20,000
WATER VALVE BOX MAINT 19,255
COMPUTERIZED LEAK SURVEY-42785
-29-
Recommended Expenditure Budget Report by Activity & Funding Source
42 -WATER
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
SUPPLIES AND SERVICES 29,000
- 111m- -WWI-
COMPUTERIZED LEAK SURVEY 29,000
WATER METER TESTING -42790
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget
CIP EXPENDITURES 603 25,000 25,000
WATER METER TESTING 603 25,000 25,000
WELL MAINT PROGRAM -42795
FUNDING SOURCE:WATER UTILITY OPERATION
Account FY17 Actual Expense FY13 Adopted Budget FY19 Recomm'd Budget
CIP EXPENDITURES 49.621 26.300
WELL MAINT PROGRAM 49,621 26,300
WATER TOTAL $ 9,224,197.86 $ 8,862,353.00 $ 10,384,8 9.00
-30-
CITY OF DUBUQUE, IOWA
DEPARTMENT DETAIL-PERSONNEL COMPLEMENT
42 WATER DEPARTMENT
FY 2017 FY 2018 FY 2019
FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET
61010 Full Time Employee Expense
640 3275 GE-40 WATER DEPARTMENT MANAGER 1.00 $ 106,708 1.00 $ 104,255 1.00 $ 106,616
640 2775 GE-37 WATER PLANT MGR. 1.00 $ 88,299 1.00 $ - 0.00 $ -
640 3200 GE-37 WATER DISTRIBUTION SUPERVISOR 1.00 $ 85,338 1.00 $ 86,711 1.00 $ 88,009
640 2950 GE-33 WATER ENGINEERING ASSISTANT 1.00 $ 63,371 1.00 $ 67,933 1.00 $ 72,779
640 2650 GE-31 FOREMAN -WATER DISTR. 1.00 $ 66,540 1.00 $ 52,000 1.00 $ 59,221
640 2610 GE-30 GIS SPECIALIST 1.00 $ 60,630 1.00 $ 61,606 1.00 $ 62,541
640 NA-49 WATER METER INSPECTOR 0.00 $ - 0.00 $ - 1.00 $ 56,327
640 2400 0E-16 ELECTRONIC TECHNICIAN 1.00 $ 60,669 1.00 $ 62,244 1.00 $ 63,165
640 2800 0E-14 EQUIPMENT MECHANIC 1.00 $ 58,206 1.00 $ 59,143 1.00 $ 60,041
640 2550 0E-13 WATER PLANT OPR CERT GR III/IV 3.00 $ 171,813 3.00 $ 166,238 1.00 $ 58,579
640 2475 0E-12 WATER PLANT OPERATOR CRT GR II 5.00 $ 271,998 5.00 $ 277,038 3.00 $ 168,592
640 2475 0E-12 WATER PLANT OPERATOR CRT GR IV 0.00 $ - 0.00 $ - 3.00 $ 185,509
640 2305 0E-10 EQUIPMENT OPERATOR II 2.00 $ 109,279 2.00 $ 106,554 2.00 $ 108,273
640 1775 0E-09 WATER METER REPAIRWORKER I 3.00 $ 158,303 3.00 $ 156,289 2.00 $ 110,396
WATER DISTR MAINTENANCE
640 1476 0E-09 WORKER 4.00 $ 210,834 4.00 $ 211,555 4.00 $ 204,648
TOTAL FULL TIME EMPLOYEES 25.00 $ 1,511,988 25.00 $ 1,411,566 24.00 $ 1,464,149
61020 Part-Time Employee Expense
640 225 GE-25 SECRETARY 0.50 $ 18,552 0.50 $ 18,850 0.50 $ 19,136
640 0E-07 WATER METER SERVICE WORKER I 0.00 $ - 0.00 $ - 0.80 $ 41,080
640 2050 0E-06 CUSTODIAN I 0.07 $ 3,189 0.07 $ 3,241 0.07 $ 3,289
TOTAL PART TIME EMPLOYEES 0.57 $ 21,741 0.57 $ 22,091 1.37 $ 63,505
61030 Seasonal Employee Expense
640 NA-34 GIS INTERN 0.00 $ - 0.00 $ - 0.50 $ 16,671
TOTAL SEASONAL EMPLOYEES 0.00 $ - 0.00 $ - 0.50 $ 16,671
TOTAL WATER DEPARTMENT 25.57 $ 1,533,729 25.57 $ 1,433,657 25.87 $ 1,544,325
-31-
CITY OF DUBUQUE,IOWA
ACTIVITY PERSONNEL COMPLEMENT SUMMARY
FY 2017 FY 2018 FY 2019
ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET
Water Administration-FT
64042100 61010 640 2610 GE-30 GIS SPECIALIST 1.00 $ 60,630 1.00 $ 61,606 1.00 $ 62,541
64042100 61010 640 3275 GE-40 WATER DEPARTMENT MANAGER 1.00 $ 106,708 1.00 $ 104,255 1.00 $ 106,616
Total 2.00 $ 167,338 2.00 $ 165,861 2.00 $ 169,157
Water Administration-PT
64042100 61020 640 225 GE-25 SECRETARY 0.50 $ 18,552 0.50 $ 18,850 0.50 $ 19,136
Total 0.50 $ 18,552 0.50 $ 18,850 0.50 $ 19,136
Water Administration-SEASONAL
64042100 61030 640 NA-34 GIS INTERN 0.00 $ - 0.00 $ - 0.50 $ 16,671
Total 0.00 $ - 0.00 $ - 0.50 $ 16,671
Water Meters-FT
64042300 61010 640 1775 OE-09 WATER METER REPAIRWORKER I 3.00 $ 158,303 3.00 $ 156,289 2.00 $ 110,396
64042300 61010 640 NA-49 WATER METER INSPECTOR 0.00 $ - 0.00 $ - 1.00 $ 56,327
Total 3.00 $ 158,303 3.00 $ 156,289 4.00 $ 226,176
Water Meters-PT
WATER METER SERVICE
64042300 61020 640 1775 OE-07 WORKER I 0.00 $ - 0.00 $ - 0.80 $ 41,080
Total 0.00 $ - 0.00 $ - 0.80 $ 41,080
Water Plant Operation-FT
64042400 61010 640 2475 OE-12 WATER PLANT OPER.CRT GR II 5.00 $ 271,998 5.00 $ 277,038 3.00 $ 168,592
64042400 61010 640 2550 OE-13 WATER PLANT OPR CERT GR III/IV 3.00 $ 171,813 3.00 $ 166,238 1.00 $ 58,579
64042400 61010 640 OE-13 WATER PLANT OPR CERT GR IV 0.00 $ - 0.00 $ - 3.00 $ 185,509
64042400 61010 640 2775 GE-37 WATER PLANT MGR. 1.00 $ 88,299 1.00 $ - 0.00 $ -
64042400 61010 640 2800 OE-16 ELECTRONIC TECHNICIAN 1.00 $ 60,669 1.00 $ 62,244 1.00 $ 63,165
64042400 61010 640 3015 OE-14 EQUIPMENT MECHANIC 1.00 $ 58,206 1.00 $ 59,143 1.00 $ 60,041
Total 11.00 $ 650,985 11.00 $ 564,663 9.00 $ 535,886
Water Distribution-FT
64042700 61010 640 1476 OE-09 WATER DIST MAINTENANCEWOR 4.00 $ 210,834 4.00 $ 211,555 4.00 $ 204,648
64042700 61010 640 2305 OE-10 EQUIPMENT OPERATOR II 2.00 $ 109,279 2.00 $ 106,554 2.00 $ 108,273
64042700 61010 640 2650 GE-31 FOREMAN-WATER DISTR. 1.00 $ 66,540 1.00 $ 52,000 1.00 $ 59,221
64042700 61010 640 2950 GE-33 WATER ENGINEERING ASSISTANT 1.00 $ 63,371 1.00 $ 67,933 1.00 $ 72,779
64042700 61010 640 3200 GE-37 WATER DISTRIBUTION SUPV 1.00 $ 85,338 1.00 $ 86,711 1.00 $ 88,009
Total 9.00 $ 535,362 9.00 $ 524,753 9.00 $ 532,930
Water Distribution-PT
64042700 61020 640 2050 GD-03 CUSTODIAN I 0.07 $ 3,189 0.07 $ 3,241 0.07 $ 3,289
Total 0.07 $ 3,189 0.07 $ 3,241 0.07 $ 3,289
TOTAL WATER DEPARTMENT 25.57 $ 1,533,729 25.57 $1,433,657 25.87 $ 1,544,325
-32-
Capital Improvement Projects by Department/Division
WATER
FY 16 Actual FY 17 Actual FY 18 Adopted FY 19 Recomm'd
OP Number Capital Improvement Project Title Expense Expense Budget Budget
7102639 LOWELL STREET 121,218 6,380
7401405 WATER MAIN REPLACEMENTS 11,327 88,027 - 456,860
7401411 MAIN EXT ANNEXATION REL. 206,286 18,018
7401415 SHALLOW WELL REHAB 137,000
7401672 ROOSEVELT RD MAIN EXT. 2,950 3,638 - 2,582,200
7401826 PAINT PUMP ROOM PIPES 1,046
7401829 SECURITY UPGRADES 39,000
7402030 VACUUM FILTER BACK-UP - - 30,000 -
7402052 WATER METER REPL PROGRAM 28,030
7402234 SOUTHGATE WATER 64,375
7402349 MANSON ROAD WATER MAIN - - 155,000 -
7402395 WATEREXT-AIRPORT 5,491,203 281,557
7402396 NORTH SOFTENING BASIN REN 8,948
7402504 ENGLISH MILL WATER MAINE 924 25,451
7402524 ONLINE PROCESS ANALYZER 314 35,000
7402526 SRF GREEN ALLEY - 21,901 - -
7402528 RAW H2O TRANSMISSION LINE 1,046
7402594 SW ARTERIAL MAIN EXT 458,918 18,925 250,000 770,000
7402595 CREEK CROSSING RESTORE 978 - 45,000 35,000
7402596 MAIN RELOC SEWER MANHOLE 418 - 20,000 20,000
7402633 PRIVATE WATER SYS PURCH 482,261 242,996
7402639 LOWELL STREET 97,929 5,154
7402641 AIRPORT SCADA SYSTEM 37,305 47,360
7402654 FIRE HYDRNT ASSMBLY SW PG 12,000 16,000
7402655 MAINT WTR MN-RETAIN WAL - - 20,000 -
7402656 WATER STORAGE TANK COATIN - - 45,000 -
7402657 WTR MN UPGRADES-STREET 25,000 20,000
7402658 WTR MN REPLACE-SWR CONS 121,800 104,000
7402703 WEST RURAL WATER PURCHASE - 1,215,694 4,396,500 543,275
7402704 TIMBER RIDGE WATER MAIN - 26,297 - -
7402713 RPR/MAINT WATER LINE ISLA 30,000 30,000
7402714 BULK CO2 TANK REPLACEMENT - - 75,000 -
7402744 PUBLIC LEAD LINE WATER RE 49,697
7402745 TAMARAK FRONTAGE WATER MN 518,125
7402746 COTTINGHAM RD WATER MAIN 1,085,937
7402747 CHESTERFIELD DR WATER MAI 100,000
7402748 EPWP TRANSFORMER SAFETY 45,000
-33-
PRGRM/
DEPT PROJECT DESCRIPTION FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 TOTAL PAGE
WATER DEPARTMENT
Business Type
Manhole Replacement Rehab $ 20,000 $ - $ - $ 25,000 $ - $ 45,000 71
Water Meter Replacement
Program $ 28,030 $ 79,845 $ 150,265 $ 153,370 $ 56,412 $ 467,922 72
Water Main Upgrades during
Street General Repairs $ 20,000 $ - $ 20,000 $ 20,000 $ - $ 60,000 73
Maintenance of Public Water
Mains during Stone Retaining Wall
Repair $ - $ - $ 20,000 $ 20,000 $ - $ 40,000 74
Westside Installation/Fire
Hydrants/Purchase $ 543,275 $ - $ - $ - $ - $ 543,275 75
Fire Hydrant Assembly Relocation/
Replacement for the Sidewalk
Program $ 16,000 $ - $ 20,000 $ - $ - $ 36,000 76
Public Lead Line Water
Replacement $ 49,697 $ 61,833 $ 122,470 $ - $ - $ 234,000 77
Water Main Replacements-
Streets $ 456,860 $ 26,092 $ 185,936 $ 18,870 $ 60,088 $ 747,846 78
Creek Crossing Restoration $ 35,000 $ - $ - $ - $ - $ 35,000 79
Tamarak Park Frontage Road
Water Main $ 518,125 $ - $ - $ - $ - $ 518,125 80
Southwest Arterial Water Main
Extension $ 770,000 $ - $ - $ - $ - $ 770,000 81
Wells, Well-field & Raw
Transmission Line Improvements $ 137,000 $ - $ 227,000 $ - $ - $ 364,000 83
Water Main Replacements-Sewer
Consent Decree $ 104,000 $ - $ - $ - $ - $ 104,000 84
Roosevelt Road Water Tower $ 2,582,200 $ - $ - $ - $ - $ 2,582,200 86
Bridge Repairs/City Island Water
Main $ 30,000 $ - $ - $ - $ - $ 30,000 87
Cottingham Road Water Main $ 1,085,937 $ - $ - $ - $ - $ 1,085,937 88
Chesterfield Drive Water Main $ 100,000 $ - $ - $ - $ - $ 100,000 89
Southgate/Simpson Water Main
Connection $ 64,375 $ - $ - $ - $ - $ 64,375 90
Westside Water System Security $ 39,000 $ - $ - $ - $ - $ 39,000 91
Online Process Analyzer
Replacement $ 35,000 $ - $ - $ - $ - $ 35,000 92
Eagle Point Water Plant
Transformer&Safety
Improvements $ 45,000 $ - $ - $ - $ - $ 45,000 93
Water Source& Hydraulic Model:
Master Plan $ - $ - $ 115,000 $ 325,000 $ - $ 440,000 94
North Cascade Road Water Main
Extension $ - $804,100 $ - $ - $ - $ 550,000 95
Eagle Point Water Plant Paint
Pipes $ - $ - $ 40,000 $ - $ - $ 40,000 96
English Ridge Water Main $ - $ - $ - $ 330,000 $ - $ 330,000 97
Water Storage Tank Coating
Program $ - $ - $ - $ 530,659 $701,000 $ 1,231,659 98
Total -Water Department $ 6,679,499 $971,870 $ 900,671 $1,422,899 $817,500 $ 10,538,339
-34-