Water & Resource Recovery Center FY2020 Budget PresentationCopyrighted
February 27, 2019
City of Dubuque Public Hearings # 2.
ITEM TITLE: Water & Resource Recovery Center FY2020 Budget
Presentation
SUMMARY:
SUGGESTED DISPOSITION:
ATTACHMENTS:
Description
W&RRC FY2020 Budget Outline
Type
Supporting Documentation
Water & Resource
Recovery Center
This page intentionally left blank.
-38-
WATER & RESOURCE RECOVERY CENTER DEPARTMENT
Budget Highlights
Expenses
Employee Expense
Supplies and Services
Payment to Construction Fund
Machinery and Equipment
Engineering - Sewer Administration
Public Works Sewer Maintenance Charges
Administrative Overhead Recharge
Payment in Lieu of Taxes
Debt Service
Total Expenses
Resources
Operating Revenue
Total Resources
Net Operating Surplus (Deficit)
Personnel - Authorized FTE
Sanitary User Fee Rate Increase
Revenue 1% Rate Increase Generates
FY 2018
Actual
1,533,344
2,627,010
181,114
10,477
190,435
730,507
1,407,393
142,884
6,131,146
FY 2019 FY 2020 % Change From
Budget Requested FY 2019 Budget
1,476,394
2,870,704
845,000
29,570
234,473
830,141
1,376,688
142,884
5,275,393
1,448,236
2,963,561
458,758
128,275
280,899
758,438
1,444,114
142,884
5,229,832
(1.9)%
3.2 %
(45.7)%
333.8 %
19.8 %
(8.6)%
4.9 %
(0.9)%
12,954,310
13,796,771
13, 081, 247 12, 854, 997
13, 090, 204 12, 905, 459
(1.7)%
(1.4)%
13,796,771
842,461
17.00
3.00%
13, 090, 204
8,957
12, 905, 459
50,462
15.00 15.00
3.00% 4.50%
$ 96,813
(1 .4)%
41,505
Improvement Package Summary
1 of 4
This improvement package would provide funding for a carbon fiber repair kit that would provide materials
and training to expedite a spot repair to the 42" pre -stressed concrete cylinder pipe (PCCP) which conveys
wastewater from the Terminal Street Valve House to the Water & Resource Recovery Center. This
improvement would allow City staff to expeditiously restore service in the event of a failure of the 42" PCCP,
minimizing the effects of an extended sanitary bypass. This improvement supports the City Goals of
Financially Responsible, High -Performance City Organization: Sustainable, Equitable, and Effective Service
Delivery, and Sustainable Environment: Preserving and Enhancing Natural Resources.
Related Cost:
Sanitary User Fee Impact
Activity: Plant Operations
$15,668 Sanitary User Fee Non -Recurring Recommend - Yes
0.16%
2 of 4
This improvement package would provide funding for an exhaust wall to evacuate painting/chemical fumes
from the maintenance work space. This improvement allows for additional painting/finishing of components
in-house. This improvement also provides a safer working environment for maintenance staff. Filtration of
paint/fumes produces cleaner exhaust. This improvement supports the goals of Vibrant Community: Healthy
and Safe, and Sustainable Environment: Preserving and Enhancing Natural Resources.
Related Cost:
Sanitary User Fee Impact
Activity: Plant Operations
$3,500 Sanitary User Fee Non -Recurring Recommend - Yes
0.04%
-39-
3 of 4
This improvement package would provide funding for a spare pump for the W&RRC Disinfected Effluent
Water (DEW) system. This improvement would facilitate faster replacement of one of the systems three
identical pumps. Many processes at W&RRC depend on an adequate supply of DEWfor heating, cooling,
and washing. Utilization of DEW reduces the consumption of potable city water. This improvement supports
the City Goals of Financially Responsible, High -Performance City Organization: Sustainable, Equitable and
Effective Service Delivery, and Sustainable Environment: Preserving and Enhancing Natural Resources.
Related Cost: $6,950 Sanitary User Fee Non -Recurring Recommend - Yes
Sanitary User Fee Impact 0.07%
Activity: Plant Operations
4 of 4
This improvement package would provide funding for a spare pump and a pump rebuild kit for the Lake
Eleanor Road Lift Station. The additional pump and rebuild kit would expedite replacement of one of the two
existing pumps, allow sufficient time for rebuild of a pump removed from service, and provides a layer of
protection in the case of a pump failure. The additional pump greatly reduces the likelihood of a sanitary
sewer overflow associated with pump failure. This Improvement supports the City Goal of Financially
Responsible, High -Performance City Organization: Sustainable, Equitable, and Effective Service Delivery.
Related Cost: $9,800 Sanitary User Fee Non -Recurring Recommend - Yes
Sanitary User Fee Impact 0.10%
Activity: Plant Operations
Significant Line Items
Employee Expense
1. FY 2020 employee expense reflects a 1.5% wage package increase.
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 is decreased from $1,193 in FY 2019 to $921 in FY
2020 per month per contract which results in an annual cost savings of $52,111 or 22.77%.
4. Overtime is unchanged from $59,350 in FY 2019 to $59,350 in FY 2020. FY 2018 actual was
$52,395.
5. Sick leave payout is decreased from $14,720 in FY 2019 to $11,225 in FY 2020.
6. The FY 2019 budget recommendation included elimination of a Plant Operator Position effective
January 1, 2019. This results in a savings of $38,716 in FY 2020 (-0.50 FTE or 1,040 hours
annually).
Supplies & Services
7. Property Insurance decreased from $84,857 in FY 2019 to $79,951 in FY 2020 based on FY 2018
actual plus 8%.
-40-
8. Sales Tax increased from $307,767 in FY 2019 to $324,762 in FY 2020 based on increased sanitary
sewer rates in FY 2020. This expense is directly offset by sales tax revenue.
9. Electricity Utility Expense unchanged from $424,777 in FY 2019 to $424,777 in FY 2020 based on
FY 2019 budget. Electrical expense for the W&RRC plant in FY 2020 is $227,486, which includes
increased microturbine output and $79,766 for the estimated BioResoure Development electrical
usage which will be reimbursed on a monthly basis. The lift station electrical expense in FY 2020 is
estimated to be $197,291. FY 2018 actual was $384,033.
10. Gas Utility Expense increased from $65,204 in FY 2019 to $87,710 in FY 2020 based on FY 2018
actual.
11. Property Maintenance decreased from $91,050 in FY 2019 to $66,350 in FY 2020 based on FY 2018
actual of $69,433.
12. Machinery and Equipment Maintenance increased from $186,277 in FY 2019 to $309,625 in FY
2020. FY 2018 actual was $195,639. The increase is due to increasing digester cleaning (+$20,000)
due to quotes coming in higher, increasing pump, grinder, and mixer maintenance (+$16,000) due to
more frequent repair of equipment due to heavy wear from grit and struvite, increasing siloxane
media replacement (+$35,720) and increasing hydrogen sulfide media replacement (+$36,060) due
to more frequent replacement due to BioResource Development, adding monthly jetting digester
heat exchange maintenance (+$3,000) which was previously budgeted in the Property Maintenance
line item, and adding HVAC maintenance (+$10,000) due to the age of HVAC units and more
frequent repairs. This line item represents samplers and lab equipment maintenance ($2,817),
digester cleaning ($60,000), pump, grinder and mixer maintenance ($36,000), primary and final
clarifier maintenance ($10,000), boiler treatment ($6,900), siloxane media replacement ($35,720),
hydrogen sulfide media replacement ($111,060), ultraviolet lamp replacement ($25,500), water
based parts washer maintenance ($3,328), citric acid ($1,000), backflow testing ($2,500), monthly
jetting digester heat exchanger maintenance ($3,000), and HVAC maintenance ($10,000)
13. Major Repair Element is unchanged from $75,000 in FY 2019 to $75,000 in FY 2020.
14. Equipment Maintenance Contract Expense increased from $76,634 in FY 2019 to $77,293 in FY
2020 based on FY 2019 plus 1%. FY 2018 actual was $78,527.
15. Lift Station Maintenance decreased from $163,200 in FY 2019 to $138,155 in FY 2020 based on a
three year average. FY 2018 actual was $113,091.
16. Polymer Expense decreased from $245,985 in FY 2019 to $226,100 in FY 2020 based on bid results
in FY 2019. FY 2018 actual was $227,424.
17. Liquid Oxygen increased from $426,734 in FY 2019 to $427,536 in FY 2020. The FY 2020 budget
includes $27,536 for tank rental and $400,000 for oxygen based on the expected loading. FY 2018
actual was $434,495.
18. Environmental Testing/Monitoring Expense decreased from $59,663 in FY 2019 to $25,000 in FY
2020 based on FY 2018 actual of $24,967.
19. Hauling Service decreased from $276,722 in FY 2019 to $274,300 in FY 2020 based on FY 2018
actual $265,376 plus 3%.
-41-
Total Equipment $ 128,275
Machinery & Equipment
20. Equipment replacement items include ($128,275):
Administration
Smart Phone
$ 346
Plant Operations
Heavy Duty Pickup Truck $ 36,000
Compact Pickup Truck $ 14,500
Forklift $ 27,500
Steam Pressure Washer $ 5,000
Shop Equipment $ 14,519
Cell Phones
$ 60
Environmental Monitoring
Laboratory Equipment $ 11,900
Recommended Improvement Packages $ 18,450
Debt Service
21. Annual debt service payments for FY 2020 are as follows ($5,229,832):
Final Call
Amount Debt Series Source Purpose Payment Date
$ 62,400 G.O. 2017A Sanitary Fees Sanitary Sewer Improvements 2030 2025
$ 95,273 G.O. 2011A Sanitary Fees Sanitary Sewer Improvements 2031 2018
$ 43,507 G.O. 2012E Sanitary Fees Sanitary Forcemain Repairs 2032 2018
$ 110,944 G.O. 2012D Sanitary Fees Sanitary Sewer Improvements 2033 2019
$ 445,075 G.O. 20148 Sanitary Fees Sanitary Sewer Improvements 2034 2021
$ 165,406 G.O. 2016C Sanitary Fees Sanitary Sewer Improvements 2035 2024
$ 62,622 SRF 2006 Sanitary Fees Northfork Catfish Creek 2031
$ 218,550 SRF 2009 Sanitary Fees Meter Change -Out 2031
$ 3,696,980 SRF 2010 Sanitary Fees W&RRC Plant Upgrade 2039
$ 186,141 SRF 2013 Sanitary Fees W&RRC Cogeneration 2033
$ 118,061 SRF 2018 Sanitary Fees Kerper Boulevard Sanitary 2038
$ 24,873 Planned Sanitary Fees Outfall Manhole Sanitary 2039
$ 5,229,832 Total Sanitary Annual Debt Service
Revenue
22. Sewage Fees decreased from $10,366,756 in FY 2019 to $10,116,942 in FY 2020 based on a 4.50%
rate increase in FY 2020 and a 7% decrease in consumption in FY 2019.
23. Sewage dumping fees increased from $124,964 in FY 2019 to $130,148 in FY 2020 based on FY
2018 actual of $130,148.
-42-
24. Late Payment Penalties increased from $97,800 in FY 2019 to $126,353 in FY 2020 based on FY
2018 actual of $306,353 less one-time payments.
25. The VVater and Resource Recovery Center's pre-treatment largest industrial customers projected
changes in revenues as follows:
• Prairie Farms decreased from $472,345 in FY 2019 to $424,132 in FY 2020 based on FY 2018
actual of $405,868 plus 4.50%;
• Inland Protein increased from $170,017 in FY 2019 to $191,967 in FY 2020 based on FY 2018
actual of $183,701 plus 4.50%; and
• Rousselot is decreased from $900,000 in FY 2019 to $882,331 in FY 2020 based on FY 2018
actual actual of $844,336 plus 4.50%.
26. High Strength Waste revenue decreased from $190,000 in FY 2019 to $189,644 in FY 2020 based
on FY 2018 actual of $189,644. This revenue represents other entities paying the City to take high
strength waste which will be used in the anaerobic digesters to generate additional energy using the
micro -turbines.
27. Gas Revenue increased from $214,354 in FY 2019 to $221,609 in FY 2020. This line item
represents 5% of the gross revenue for BioResource Development ($63,843), lease of the site
($10,000), staff time reimbursement ($56,000), reimbursement of gas ($12,000) and electric cost
($79,766).
28. Fats, Oils and Grease Permit and Dumping fees decreased from $30,000 in FY 2019 to $24,614 in
FY 2020 based on FY 2018 actual of $24,614.
-43-
This page intentionally left blank.
-44-
WATER & RESOURCE RECOVERY CENTER
The Water & Resource Recovery Center uses technology to clean the water used by the
community to allow its safe return to the environment. The process provides the opportunity to
extract resources from the water for use within the Center and the surrounding community.
Water &
Resource
Recovery Center
Administration
Operations and Evnironmental
Maintenance Monitoring
SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE
LEADING TO OUTCOMES
PEOPLE
W&RRC Staff, Health Department,
Engineering and Public Works
provided the majority of our City
relationships. We also maintain
relationships with local industries,
the Resilient Community Advisory
Commission and Regional/Local
Engineers.
PLANNING
The W&RRC has ongoing planning
and implementation for several
environmental issues including spill
prevention plans, Bio -Solids
Management and Nutrient Reduction.
PARTNERSHIPS
The W&RRC maintains partnerships with
City Departments, Iowa Department of
Natural Resources, USEPA, Local
Industries and local/regionaUservice
providers.
-45-
/\
li$13,796,771
WATER & RESOURCE RECOVERY CENTER
$13,000,000
$12,000,000
$11,000,000
$10,000,000
FY 2018 FY 2019 FY 2020
Full -Time Equivalent 17.00 15.00 15.00
Resources
$13,Q9Q,204
Operating Revenue
$12,905,459
RI FY 2018 ■ FY 2019 FY 2020
The Water Resource Recovery Center is supported by 15.00 full-time equivalent employees, which
accounts for 28.97% of the department expense as seen below. Overall, the department's expenses
are expected to decrease by -2% in FY 2020 compared to FY 2019.
Expenditures and Debt by Fiscal Year
EmploYee Ekpense
StIpplies and SerViceS
Construction Find
E9vipment
Engineering �H
P" is Works aH
Admin pverheatl
$1,533,344
$1,476,394
$1,448,236
• $181,114
$845,000
$458,758
$10,477
1 $29,570
$128,275
$190,435
N $234,473
NM $280,899
$730,507
$830,141
$758,438
$1,407,393
$1,376,688
$1,444,114
$2,627,010
■ $2,870,704
$2,963,561
Debt Service $6,131,146
$5,275,393
$5,229,832
$0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000
FY 2018 7 FY 2019 FY 2020
-46-
WATER & RESOURCE RECOVERY CENTER
Operations and Maintenance
Overview
Operations and maintenance of the W&RRC consists of maintaining equipment and records
necessary to collect, pump, treat and dispose of the liquid wastes discharged into the sanitary
sewer system as required by state and federal regulatory agencies at the lowest possible cost
while sustaining appropriate maintenance programs for plant reliability; operating and
maintaining 20 pumping stations located throughout the City of Dubuque; Repair and maintain
all equipment required for the successful and efficient operation of the W&RRC. Stock
essential spare parts and maintain records for effective operation of the W&RRC.
00 00
Center Operations
For FY18 the Water & Resource Recovery
Center (W&RRC) treated an average 7.02
million gallons per day (M.G.D.) or 2,562
million gallons for the year.
7.02 million gallons is equal to about 1400 semi -tanker loads of sewer water per day.
The average BOD or Biochemical Oxygen Demand was 24,500 pounds of Oxygen per day of
which 23,900 pounds was removed or about 97.6 percent removal.
30000
25000
20000
15000
fnnn
Pounds of Oxygen Demand
1
1In II Out
That means that each day we kept 23,900 pounds of Oxygen from being removed from
the waters of the Mississippi River.
-47-
WATER & RESOURCE RECOVERY CENTER
12.5 tons of soil amendment (fertilizer) are produced PER DAY during the process of cleaning
the wastewater.
That is an average of eight semi loads per week of useful material being safely returned
to a beneficial purpose.
Operations and Maintenance Funding Summary
FY 2018Actual
FY 2019 Budget
FY 2020 Requested
Expenditures
$9,827,182
$9,144,151
$9,289,084
Resources
$13,454,137
$12,928,424
$12,738,062
Operations and Maintenance Position Summary
FY 2020
WRRC MANAGER
1.00
MAINTENANCE SUPERVISOR WW1
1.00
W&RRC OPERATIONS SUPERVISOR
1.00
EQUIPMENT MECHANIC - W WT
2.00
INDUSTRIALELECTRONICS TECH
1.00
WRRC OPERATOR CERT GR II
2.00
PLANT OPERATOR GRADE III &IV
200
CONFIDENTIALACCOUNT CLERK
1.00
Total FT Equivalent Employees
11.00
-48-
WATER & RESOURCE RECOVERY CENTER
Performance Measures
Operations and Maintenance -Activity Statement
Maintain efficient operations and maintenance of the W&RRC to assure for treatment of the City of Dubuque's
waste water in the most cost effective manner possible while protecting the environment and citizens from
exposure to pollution in the Mississippi River.
Goal: Sustainable Environment -1(14
Outcome #1: Maintain proper operation and maintenance of pumping stations
throughout the City of Dubuque to ensure that untreated wastewater is not discharged
to streets, storm sewers or creeks/rivers where citizens may come in contact with this
potentially dangerous material.
All pumping stations are connected with the W&RRC computer system to allow for real-time
monitoring of the operations of the stations. Stations are visited by the W&RRC Maintenance
staff at least weekly to check for proper operations. Three of the major stations are checked
daily during the work week. Three of the pumping stations have permanently installed standby
power generators and the others can be powered by the three portable generators owned by
the W&RRC. This capability along with the standby generators at the W&RRC assures the
businesses and citizens of the City of Dubuque that even during power outages the W&RRC
will continue to operate and provide essential services to our citizens.
All operations staff to have at least Grade II Certification
Training is provided to employees of the W&RRC to equip all employees with the required
skills to successfully operate a complex technical facility, to maintain and upgrade certifications
required by IDNR and keep abreast of current regulations and technologies. A higher level of
training for all operators will lead to a more efficient operation of the W&RRC.
1/4,47Goal: Robust Local Economy
Outcome #2: Increased Energy Production for use at the W&RRC
Increased addition of HSW to the digesters provides for additional revenue for the W&RRC and over
time will allow the W&RRC to produce most of the energy needed to operate the Center.
The W&RRC produces 75% to 85% of the electrical needs for the Center.
• Increased Gas Production via the Introduction of HSW
• Matching Center KW Demands with HSW Introduction
• Alliant agreement to allow increase KW production
-49-
WATER & RESOURCE RECOVERY CENTER
700
600
500
400
300
200
100
0
Electrical Demand KW
1
2 3
Blue = Total Demand Green = W&RRC Production Red = Purchased
-50-
WATER & RESOURCE RECOVERY CENTER
Environmental Monitoring
Overview
The Environmental Monitoring Section performs the chemical, biological and bacterial
sampling and analysis associated with the operations of the W&RRC and assists in the
operations of additional City Departments and the community by providing analytical services.
The function of the Industrial Pretreatment Program is to eliminate from industrial sources
those materials which may cause pass through and/or interference with the operation of the
City of Dubuque's Publicly Owned Treatment Works.
Working in conjunction with many City of Dubuque Departments to operate and maintain the
Fats, Oils and Grease program. The program is aimed at eliminating Sanitary Sewer Overflows
caused by the discharge of excessive amount of fats, oils and greases into the sanitary sewer
system.
Environmental Monitoring Funding Summary
FY 2018 Actual
FY 2019 Budget
FY 2020 Requested
Expenditures
$454,902
$492,422
$462,900
Resources
$338,259
$151,819
$158,258
Environmental Monitoring Position Summary
FY 2020
Lab Supervisor
1.00
Lab Technician
2.00
Environmental Coordinator
1.00
Total FT Equivalent Employees
4.00
Highlights of the Past Year
The Environmental Monitoring Activity created the position of Laboratory Supervisor from one
of the existing Laboratory Technician positions. This new position provides a staffing structure
that improves the efficiency and effectiveness of laboratory activities.
Future Initiatives
The Laboratory is currently pursuing state certification in the analysis of the nutrients
phosphorus and nitrogen.
Performance Measures
Environmental Monitoring - Activity Statement
Monitor the quality of water discharged from the Water & Resource Recovery Center to assure environmental
stewardship and adherence to State and Federal regulations and the environmental goals of the Citizens of
Dubuque.
-51-
WATER & RESOURCE RECOVERY CENTER
Outcome #1: Maintain a Fats, Oil and Grease program to protect the sanitary sewer
system from blockages caused by excessive buildup in the system helping eliminate
sanitary sewer overflows caused by Fats, Oils and Grease.
Outcome #2: Ensure a safe water supply - In support of the Water Department
Collect and analyze 16 water samples per week from various locations within the City of
Dubuque.
The assurance of safe drinking water is essential for the health and safety of the community.
-52-
Recommended Operating Revenue Budget - Department Total
43 - WATER & RESOURCE RECOVERY
Fund
Account
Account Title
FY17 Actual
Revenue
FY18 Actual
Revenue
FY19 Adopted
Budget
FY20 Recomm'd
Budget
610 42230 SEWAGE DISPOSAL PERMITS
610 42237 FOG PERMITS
610 42331 FOG INSPECTION fEES
1,150
37,325
50
1,485
38,850
250
1,150
37,325
50
1,485
38,850
250
42 - LICENSES AND PERMITS
38,525
40,585
38,525
40,585
610
43110
INVESTMENT EARNINGS
32,547
44,481
12,810
51,786
43 - USE OF MONEY AND PROPERTY
32,547
44,481
12,810
51,786
610 51,185 WATER TESTS -OUTSIDE
610 51,205 SEWAGE FEES
610 51,215 LATE PAYMENT PENALTY
610 51,216 FOG PENALTIES
610 51,218 ARTCO FLEETING
610 51,220 SWISS VALLEY FARMS
610 51,225 INLAND PROTEIN
610 51,227 HIGH STRENGTH WASTE
610 51,230 SEWAGE DUMPING FEES
610 51,231 FOG DUMPING FEES
610 51,235 WW IND. PRETREATMENT
610 51,240 SAN ROUESSLOT
610 51,256 BRD LEASE
610 51,257 BRD STAFF REIMBURSEMENT
610 51,258 BRD GAS REIMBURSEMENT
610 51,259 BRD ELECTRIC REIMB
610 51,260 BRD GROSS REVENUE
610 51261 BRD ELECTRIC USE PROFIT
610 51,690 LANDFILL PAYMENT -LAB TEST
610 51,964 ARENANOVELT
47,728
9,929,090
97,800
1,800
0
472,345
170,017
274,326
124,964
28,006
36,341
853,196
0
0
0
0
25,500
0
6,773
250
40,293
10,106,780
306,353
2,750
1,318
405,868
183,701
189,644
130,148
24,614
35,990
844,336
0
0
0
0
0
0
1,177
415
47,728
10,366,756
97,800
1,800
0
472,345
170,017
190,000
124,964
30,000
36,341
900,000
0
0
0
0
214,354
0
0
250
40,293
10,116,942
126,353
2,750
1,318
424,132
191,967
189,644
130,148
24,614
35,990
882,331
10,000
56,000
12,000
79,766
63,843
25,000
1,177
415
51- CHARGES FOR SERVICES
12,068,136 12,273,386 12, 652,355 12,414,683
610 53201 REFUNDS
610 53204 IOWA FUEL TAX REFUND
610 53520 WATER SAMPLING -PLANT
610 53521 WWT SAMPLING -AIRPORT
610 53523 WWT SAMPLING -OUTSIDE
610 53610 INSURANCE CLAIMS
610 53620 REIMBURSEMENTS -GENERAL
610 53630 SALES TAX COLLECTION
0
2,044
613
41,318
24,366
34,289
79
290,086
50
0
695
37,344
24,870
0
1,375
324,422
0
2,044
613
41,318
24,366
0
79
307,767
50
0
695
37,344
24,870
0
1,375
324,762
53 - MISCELLANEOUS
392,796 388,756 376,187 389,096
610
610
610
54109
54210
54220
SALVAGE SALES
GO BOND PROCEEDS
BOND DISCOUNT
366
652,158
21,006
170
1,030,001
15,018
366
0
0
170
0
0
54 - OTHER FINANCING SOURCES
673,531 1,045,189
366
170
610 59710 FR SANITARY SEWER CONST
20,000
0
0
0
59 - TRANSFER IN AND INTERNAL
20,000 0 0 0
43 - WATER & RESOURCE RECOVERY TOTAL
13,225,535 13, 792,396 13, 080, 243 12,896,320
-53-
Recommended Operating Expenditure Budget - Department Total
43 - WATER & RESOURCE RECOVERY
Fund
Account
Account Title
FY17 Actual
Expense
FY18 Actual
Expense
FY19 Adopted
Budget
FY 20 Recomm'd
Budget
610 61,010 FULL-TIME EMPLOYEES
640 61,010 FULL-TIME EMPLOYEES
610 61,020 PART-TIME EMPLOYEES
610 61,030 SEASONAL EMPLOYEES
100 61,050 OVERTIME PAY
610 61,050 OVERTIME PAY
640 61,050 OVERTIME PAY
610 61,071 HOLIDAY PAY -OVERTIME
640 61,071 HOLIDAY PAY -OVERTIME
610 61,091 SICK LEAVE PAYOFF
100 61,310 IPERS
610 61,310 IPERS
640 61,310 IPERS
100 61,320 SOCIAL SECURITY
610 61,320 SOCIAL SECURITY
640 61,320 SOCIAL SECURITY
100 61,410 HEALTH INSURANCE
610 61,410 HEALTH INSURANCE
640 61,410 HEALTH INSURANCE
610 61,415 WORKMENS' COMPENSATION
100 61,416 LIFE INSURANCE
610 61,416 LIFE INSURANCE
640 61,416 LIFE INSURANCE
610 61,640 SAFETY EQUIPMENT
610 61,660 EMPLOYEE PHYSICALS
965,479
0
0
22,612
0
55,670
0
23,739
0
24,172
0
94,388
0
0
80,088
0
0
270,316
0
40,971
0
768
0
4,690
121
964,031
809
638
4,473
42
52,124
230
24,601
355
14,843
4
93,513
124
3
76,654
101
12
254,095
293
38,766
0
752
1
6,837
42
961,728
0
0
0
0
59,350
0
17,221
0
14,720
0
98,016
0
0
80,556
0
0
214,651
0
29,293
0
859
0
0
0
990,095
0
0
0
0
59,350
0
17,221
0
11,225
0
100,694
0
0
82,45 8
0
0
1 62,54 0
0
23,810
0
843
0
0
0
61- WAGES AND BENEFITS
1,583,015 1,533,344
1,476,394 1,448,236
610 62010 OFFICE SUPPLIES
610 62011 UNIFORM PURCHASES
610 62030 POSTAGE AND SHIPPING
610 62032 FLAGS
610 62061 DP EQUIP. MAINT CONTRACTS
610 62062 JANITORIAL SUPPLIES
610 62065 LAB SUPPLIES
610 62090 PRINTING & BINDING
610 62110 COPYING/REPRODUCTION
610 62130 LEGAL NOTICES & ADS
610 62140 PROMOTION
610 62170 SUBSCRIPTIONS -BOOKS -MAPS
610 62190 DUES & MEMBERSHIPS
610 62204 REFUNDS
610 62206 PROPERTY INSURANCE
610 62208 GENERAL LIABILITYINSURAN
610 62210 SALES TAX
610 62310 TRAVEL -CONFERENCES
610 62320 TRAVEL -CITY BUSINESS
610 62360 EDUCATION & TRAINING
610 62411 UTILITY EXP-ELECTRICI TY
610 62412 UTILITY EXP -GAS
-54-
1,318
2,414
2,692
0
9,942
0
19,648
2,502
774
73
0
0
875
7,208
78,795
15,408
291,779
3,290
144
8,990
334,908
62,099
2,298
2,425
3,492
90
8,898
1,470
40,082
1,725
321
3,575
0
0
409
11,065
73,943
13,763
325,418
1,975
159
8,893
384,033
87,710
1,318
2,500
2,692
135
8,610
1,000
19,648
2,502
773
73
0
0
1,125
7,208
84,857
11,750
307,767
4,450
290
4,853
424,777
65,204
2,194
2,500
3,597
135
8,808
1,724
40,082
4,541
336
100
600
300
885
11,065
79,951
10,684
324,762
3,45 0
390
11,330
424,777
87,710
Recommended Operating Expenditure Budget - Department Total
43 - WATER & RESOURCE RECOVERY
Fund
Account
Account Title
FY17 Actual
Expense
FY18 Actual
Expense
FY19 Adopted
Budget
FY 20 Recomm'd
Budget
610 62415
610 62416
610 62421
610 62424
610 62431
610 62435
610 62436
610 62438
610 62511
610 62513
610 62521
610 62528
610 62611
610 62612
610 62613
610 62614
610 62621
610 62622
610 62623
610 62625
610 62628
610 62629
610 62631
610 62633
610 62638
610 62639
610 62663
610 62666
610 62667
610 62676
610 62678
610 62681
610 62692
610 62696
610 62710
610 62712
610 62713
610 62716
610 62721
610 62726
610 62731
610 62732
610 62733
610 62736
610 62747
610 62763
610 62767
610 62780
UTILITY EXPENSE STORMWATR
UTILITY EXP -WATER
TELEPHONE
RADIO/PAGER FEE
PROPERTY MAINTENANCE
ELEVATOR MAINTENANCE
RENTAL OF SPACE
FIRE SUPPRESSION
FUEL, MOTOR VEHICLE
FUEL, DIESEL
MOTOR VEHICLE MAINT.
MOTOR VEH. MAINT. OUTSOUR
MACH/EQUIP MAINTENANCE
MAJOR REPAIR ELEMENT
METER MAINTENANCE
EQUIP MAINT CONTRACT
02 PLANT MAINTENANCE
BELT FILTER MAINTENANCE
CETRIFUGE MAINTENANCE
LIFT STATION MAINTENANCE
INSTRUMENTATION MAINT
INSTR MAINT CONTRACT
LIME
CHLORINE
POLYMER
LIQUID CO2/02
SOFTWARE LICENSE EXP
CREDIT CARD CHARGE
DATA SERVICES
PIPE -SPECIAL FITTINGS
EDUCATIONAL MATERIALS
LUBRICATION PRODUCTS
LANDFILL FEES
OUTSIDE COLLECTOR EXPENSE
CONTRACTOR SERVICES
CONSULTING ENGINEERS
LEGAL SERVICES
CONSULTANT SERVICES
FINANCIAL CONSULTANT
AUDIT SERVICES
MISCELLANEOUS SERVICES
TEMP HELPCONTRACT SERV.
CONTRACT CUSTODIAL
CATERING SERVICES
MACH/EQUIPMENT RENTAL
PAYMENT TO IOWA DNR
ENVIRON. TESTING/MON.
HAULING SERVICES
5,991
47,805
6,838
2,026
86,412
2,736
480
0
7,781
2,436
9,497
1,127
154,385
0
9,057
74,879
0
76,333
36,729
148,495
3,072
6,720
906
9,630
245,985
548,121
6,354
0
86
0
0
5,043
18,752
8,291
0
0
5,692
9,773
1,177
2,200
3,421
0
29,851
0
1,500
6,470
59,663
276,722
11,606
39,101
7,184
2,758
69,433
2,845
480
0
10,285
389
7,260
100
195,639
0
5,500
78,527
100
0
33,924
113,091
0
3,798
0
13,892
227,424
434,495
14,546
0
395
0
120
4,577
10,281
6,962
0
19,088
7,242
8,727
7,043
2,200
10,152
0
12,838
82
0
2,839
24,967
265,376
6,395
51,209
6,857
2,067
91,050
2,178
480
0
7,937
2,436
7,454
1,150
186,277
75,000
9,057
76,634
0
0
36,729
163,200
3,072
17,500
906
9,630
245,985
426,734
6,353
0
444
0
0
5,043
31,700
8,291
8,000
0
5,692
60,000
1,177
2,750
0
0
17,700
0
0
5,700
59,663
276,722
13,181
42,034
7,173
2,869
66,350
2,845
480
5,770
10,285
389
7,405
1,742
309,625
75,000
0
77,293
0
0
34,942
138,155
13,000
22,500
960
11,000
226,100
427,536
9,541
600
480
12,253
0
4,577
51,531
6,961
0
0
5,752
12,500
1,177
2,200
0
20,000
17,700
300
0
2,134
25,000
274,300
-55-
Recommended Operating Expenditure Budget - Department Total
43 - WATER & RESOURCE RECOVERY
Fund
Account
Account Title
FY17 Actual
Expense
FY18 Actual
Expense
FY19 Adopted
Budget
FY 20 Recomm'd
Budget
62 - SUPPLIES AND SERVICES 2,765,294 2,627,010 2,870,704 2,963,561
610 71120 PERIPHERALS, COMPUTER
610 71314 TRUCK -REPLACEMENT
610 71318 HEAVY EQUIP -REPLACEMENT
610 71410 SHOP EQUIPMENT
610 71413 LABORATORY EQUIPMENT
610 71421 HIGH PRESSURE SPRAY
610 71511 PUMPS
610 71520 HVAC
610 71610 CUSTODIAL EQUIPMENT
610 72418 TELEPHONE RELATED
610 72515 TEST EQUIPMENT, OTHER
156
0
0
7,953
1,066
0
0
0
242
46
0
801
0
0
133
7,296
0
0
0
0
291
1,956
0
0
0
10,000
19,100
0
0
0
0
470
0
0
50,500
27,500
14,519
11,900
5,000
14,950
3,500
0
406
0
71- EQUIPMENT
9,463
10,477
29,570
128,275
610
610
74111
74112
PRINCIPAL PAYMENT
INTEREST PAYMENT
3,742,470
1,881,718
4,301,389
1,829,757
3,454,212
1,821,181
3,511,282
1,718,550
74 - DEBT SERVICE
5,624,188 6,131,146
5,275,393
5,229,832
610
91100
TO GENERAL
610 91710 TO SANITARY SEWER CONST
1,301,957
1,736,000
1,550,277
181,114
1,519,572
845,000
1,586,998
458,758
91- TRANSFER TO
3,037,957 1,731,391
2,364,572
2,045,756
43 - WATER & RESOURCE RECOVERY TOTAL
13,019, 916 12, 033,368
12, 016, 633 11,815,660
-56-
FATS OILS GREASE
34,970
32,2
WATER MAIN REPLACEMENTS - 43755
Recommended Expenditure Budget Report by Activity & Funding Source
43 - WATER & RESOURCE RECOVERY
• UNDISTRIBUTED
FUNDING SOURCE: SEWAGE FACILITY OPERATION
Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
SUPPLIES AND SERVICES 17,920 15,488 17,920
TRANSFER TO 1,731,391 2,364,572 2,045,756
UNDISTRIBUTED 1,749,311 2,380,060
WPC ADMINISTRATION - 43100
FUNDING SOURCE: SEWAGE FACILITY OPERATION
Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
DEBT SERVICE 6,131,146
EQUIPMENT 291
SUPPLIES AND SERVICES 398,037
WAGES AND BENEFITS 139,845
5,275,393
341,880
141,586
5,229,832
346
381,272
148,217
Mr
WRRP ADMINISTRATION 6,669,319 5,758,859 5,759,667
WPC PLANT OPERATIONS - 43400
FUNDING SOURCE: SEWAGE FACILITY OPERATION
Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
EQUIPMENT 133 10,470 116,029
SUPPLIES AND SERVICES 2,121,570 2,413,525 2,476,877
WAGES AND BENEFITS 1,001,189 929,014 903,060
Willi.
WRR PLANT OPERATIONS 3,122,893
FATS OILS GREASE - 43500
FUNDING SOURCE: SEWAGE FACILITY OPERATION
Account
FY18 Actual Expense
FY19 Adopted Budget FY20 Recomm'd Budget
EQUIPMENT
SUPPLIES AND SERVICES
WAGES AND BENEFITS
1,956
7,148
25,866
6,856
25,427
8,791
24,660
FUNDING SOURCE: WATER UTILITY OPERATION
Account
FY18 Actual Expense
FY19 Adopted Budget FY20 Recomm'd Budget
WAGES AND BENEFITS
1,913
ENVIRON -MONITORING 1,913
ENVIRON -MONITORING - 43700
FUNDING SOURCE: SEWAGE FACILITY OPERATION
Account FY18 Actual Expense FY19 Adopted Budget FY20 Recomm'd Budget
-57-
EQUIPMENT 8,097 19,100 11,900
SUPPLIES AND SERVICES 82,334 92,955 78,701
WAGES AND BENEFITS 364,470 380,367 372,299
r -r -
ENVIRON -MONITORING
ATER & RESOURCE RECOVERY TOTAL $ 12,033,367.74 $
492,422 462,900
12,016,633.00 $ 11,815,660.00
-58-
CITY OF DUBUQUE, IOWA
DEPARTMENT DETAIL - PERSONNEL COMPLEMENT
43 WATER AND RESOURCE RECOVERY CENTER
FD JC WP -GR JOB CLASS
FY 2018 FY 2019 FY 2020
FTE BUDGET FTE BUDGET FTE BUDGET
61010 Full Time Employee Expense
610 5080 GE -40 WRRC MANAGER 1.00 $ 92,652 1.00 $ 99,913 1.00 $ 108,576
610 3300 GE -35 WRRC ASSIST. MANAGER 1.00 $ - 0.00 $ - 0.00 $ -
610 3030 GE -34 MAINTENANCE SUPERVISOR VWVT 1.00 $ 79,395 1.00 $ 80,590 1.00 $ 82,420
610 GE -33 W&RRC OPERATIONS SUPERVISOR 0.00 $ - 1.00 $ 66,218 1.00 $ 67,792
610 GE -33 LAB SUPERVISOR 1.00 $ 75,273 1.00 $ 76,418 1.00 $ 78,150
610 GE -31 ENVIRONMENTAL COORDINATOR 1.00 $ 59,966 1.00 $ 60,860 1.00 $ 65,706
610 2100 GE -31 LAB TECHNICIAN II 2.00 $ 119,167 2.00 $ 123,350 2.00 $ 121,973
610 GE -25 CONFIDENTIAL ACCOUNT CLERK 1.00 $ 47,651 1.00 $ 48,373 1.00 $ 49,535
610 2400 0E-14 EQUIPMENT MECHANIC - VWdT 2.00 $ 117,126 2.00 $ 119,494 2.00 $ 122,200
610 2800 OE -14 MAINTENANCE ELECTRICIAN 1.00 $ 57,983 1.00 $ 58,864 1.00 $ 62,125
610 0E-14 WRRC OPERATOR CERT GR IV 0.00 $ - 1.00 $ 55,910 1.00 $ 63,243
610 0E-13 WRRC OPERATOR CERT GR III 2.00 $ 113,035 1.00 $ 56,563 1.00 $ 59,102
610 2500 OE -12 WRRC OPERATOR CERT GR II 2.00 $ 113,879 2.00 $ 115,175 2.00 $ 109,273
610 2450 0E-11 WRRC OPERATOR (NC/GR I C) 2.00 $ 108,559 0.00 $ - 0.00 $ -
TOTAL FULL TIME EMPLOYEES 17.00 $ 984,686 15.00 $ 961,728 15.00 $ 990,095
61030 SEASONAL EMPLOYEES
610 NA -38 INTERN 0.00 $ - 0.00 $ - 0.00 $ -
TOTAL SEASONAL EMPLOYEES 0.00 $ - 0.00 $ - 0.00 $
TOTAL WATER & RESOURCE RECOVERY CENTER 17.00 $ 984,686 15.00 $ 961,728 15.00 $ 990,095
-59-
CITY OF DUBUQUE, IOWA
ACTIVITY PERSONNEL COMPLEMENT SUMMARY
ACCT FD JC WP -GR POSITION CLASS
FY 2018 FY 2019 FY 2020
FTE BUDGET FTE BUDGET FTE BUDGET
Water & Resource Recovery Center Administration
WASTEWATER PLANT
61043100 61010 610 3300 GE -40 MANAGER 1.00 $ 92,652 1.00 $ 99,913 1.00 $ 108,576
Total 1.00 $ 92,652 1.00 $ 99,913 1.00 $ 108,576
Water & Resource Recovery Center Plant Operation
61043100 61010 610 3300 GE -35 W&RRC ASSIST PLANT MGR 1.00 $ - 0.00 $ - 0.00 $
MAINTENANCE SUPERVISOR
61043400 61010 610 3030 GE -34 W&RRC 1.00 $ 79,395 1.00 $ 80,590 1.00 $ 82,420
61043400 61010 610 GE -33 MARC OPERATIONS SUPV 0.00 $ 1.00 $ 66,218 1.00 $ 67,792
EQUIPMENT MECHANIC -
61043400 61010 610 2400 OE -14 W&RRC 2.00 $ 117,126 2.00 $ 119,494 2.00 $ 122,200
ENVIRONMENTAL
61043400 61010 610 2228 GE -31 COORDINATOR 0.00 $ - 0.00 $ - 0.00 $ -
61043400 61010 610 1000 GE -25 CONFIDENTIALACCOUNTCERK 0.65 $ 30,973 0.65 $ 31,443 0.65 $ 32,198
61043400 61010 610 3942 OE -13 MARC OPERATOR GR III/IV 2.00 $ 113,035 2.00 $ 112,473 2.00 $ 122,345
61043400 61010 610 2500 OE -12 W&RRC OPERATOR GR II 2.00 $ 113,879 2.00 $ 115,175 2.00 $ 109,273
61043400 61010 610 2450 OE -11 W&RRC PLANT OP (NC/GR I C) 2.00 $ 108,559 0.00 $ - 0.00 $ -
61043400 61010 610 2800 OE -14 MAINTENANCE ELECTRICIAN 1.00 $ 57,983 1.00 $ 58,864 1.00 $ 62,125
Total 11.65 $ 620,950 9.65 $ 584,257 9.65 $ 598,353
Environmental Monitoring Lab -FT
61043700 61010 610 GE -33 LAB SUPERVISOR
61043700 61010 610 2100 GE -31 LAB TECHNICIAN II
ENVIRONMENTAL
61043700 61010 610 2228 GE -31 COORDINATOR
Total
Fat Oils and Grease -FT
1.00 $ 75,273 1.00 $ 76,418 1.00 $ 78,150
2.00 $ 119,167 2.00 $ 123,350 2.00 $ 121,973
1.00 $ 59,966 1.00 $ 60,860 1.00 $ 65,706
4.00 $ 254,406 4.00 $ 260,628 4.00 $ 265,829
CONFIDENTIAL ACCOUNT
61043500 61010 610 1000 GE -25 CLERK 0.35 $ 16,678 0.35 $ 16,930 0.35 $ 17,337
Environmental Monitoring Lab -Seasonal
61043700 61030 610 650 NA -38 FINANCE INTERN -SEASONAL
Total
0.35 $ 16,678 0.35 $ 16,930 0.35 $ 17,337
0.00 $
- 0.00 $ - 0.00 $
0.00 $
- 0.00 $ - 0.00 $
TOTAL WATER & RESOURCE RECOVERY DEPARTMENT 17.00 $ 984,686 15.00 $ 961,728 15.00 $ 990,095
-60-
Capital Iniproveinent Projects by Departinent/Division
CIP Number Capital Improvement Project Title
FY 17 Actual
Expense
FY 18 Actual
Expense
FY 19 Adopted
Budget
FY 20 Recomm'd
Budget
71010710 UNDISTRIBUTED
7101339 SCADA SYSTEM UPGRADE
7101730 ALT 02 STUDY & IMPLEMENTA
7101731 DOG TRACK LIFT STATION
7101837 WRR PLANT RENOVATION 75,954
7102211 TERMINAL ST MAG METER REP 203,852
7102412 CEDAR LIFT PUMP/GEN/TRAIL
7102474 BRADLEY/PERRY FORCE MAIN
7102529 NUTRIENT REDUCT STRATEGY 212
7102530 OUTFALL MANHOLE
7102538 AIRPORT LS UPGRADES
7102598 CLARIFIER REALIGN/REPAIR 13,981
7102599 KERPER PUMP MOTOR/CONTROL
7102601 REPLACEMENT OF RADIOS
7102659 NUTRIENT RED/BASIN MOD 1
7102697 ASH POND ABANDONMENT 62,534 116,589
7102698 METHANE GAS SYSTEM WRRC 25,479 31,449
7102699 STRUVITE AIRPREX PILOT 29,518
7102700 LEVEL 4 AGREEMENT 10,099 19,569
7102701 HS WASTE RECEIVE & STORE 14,998
7102730 FRACK TANK 10,125 10,468
20,000
50,000
25,000
100,000
50,000
55,000
400,000
15,000
19,325 130,000
7102749 KW CAR WASH LIFT STATION
7102750 GRANGER CREEK LIFT STATIO
7102787 WRRC CAMERAS
27,500
12,000
45,900
WATER & RESOURCE RECOVERY TOTAL 280,900
-61-
PRGRM
/DEPT PROJECT DESCRIPTION FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 TOTAL PAGE
WATER & RESOURCE RECOVERY CENTER
Business Type
Final Clarifier Drive Pier
Realignment and Drive Repair
Catfish Lift Station Spare Pump
Lift Station SCADA Upgrades
Camera System Upgrade
High -Strength Waste Receiving
& Storage
Nitrogen Reduction
UV Disinfection System
Modifications
Side -Stream Phosphorous
Removal
Total - Water & Resource Recovery Center
$ 130,000 $ 130,000 $ 130,000 $ 130,000 $ $ 520,000 95
$ 55,000 $ — $ — $ — $ — $ 55,000 96
$ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 250,000 97
$ 45,900 $ — $ — $ — $ — $ 45,900 98
$ — $ — $ 522,155 $ 961,795 $ — $ 1,483,950 99
$ $ — $ 70,000 $ 98,000 $ 1,092,000 $ 1,260,000 100
$ — $ — $ — $ 10,000 $ 225,000 $ 235,000 1010
$ — $ — $ — $ — $ 300,000 $ 300,000 102
$ 280,900 $ 180,000 $ 772,155 $1,249,79 $ 1,667,000 $ 4,149, 850
-62-
5