The URL can be used to link to this page

Water & Resource Recovery Center Fiscal Year 2024 Budget PresentationCopyrighted March 21, 2023 City of Dubuque Special Meeting P UBLIC HE ARINGS # 03. IT E M T I T L E:Water & Resource Recovery Center Fiscal Year 2024 B udget Presentation S UM M ARY:Staff Memo Detailing Page Replacements S UG G E S T E D D I S P O S I T I O N: AT TAC H ME N TS: Description Type Memo F Y24 Replacement pages - Policy Budget Staff Memo Policy Budget Book Updated Supporting Documentation Presentation_Uploaded 3.21.23 Supporting Documentation Utilities and A C P Program Flyer Supporting Documentation TO: Michael C. Van Milligen, City Manager FROM: Jennifer Larson, Chief Financial Officer SUBJECT: Fiscal Year 2024 Policy Budget Volume 6 Replacement Pages DATE: March 17, 2023 In the Fiscal Year 2024 Policy Budget Volume III, pages 47-66 of the Water & Resource Recovery Center have been replaced due to a re-estimation of sanitary sewer revenue, including revenue for the largest industrial customers. The increase in overall sanitary sewer revenue has decreased the recommended sanitary sewer rate increase from 8% originally recommended to 6%. JML Water & Resource Recovery Center -47- This page intentionally left blank. -48- WATER & RESOURCE RECOVERY CENTER DEPARTMENT Budget Highlights FY 2022 Actual FY 2023 Budget FY 2024 Requested % Change From FY 2023 Budget Expenses Employee Expense 1,456,457 1,539,004 1,798,289 16.8 % Supplies and Services 3,544,088 3,471,823 3,714,800 7.0 % Payment to Construction Fund 700,000 1,796,419 1,800,000 0.2 % Machinery and Equipment 268 244,800 30,080 (87.7) % Engineering - Sewer Administration 239,794 373,935 423,683 13.3 % Public Works Sewer Maintenance Charges 752,273 714,116 729,701 2.2 % Administrative Overhead Recharge 1,575,249 1,694,233 1,837,404 8.5 % Payment in Lieu of Taxes 142,884 142,884 142,884 — % Debt Service 5,253,365 5,574,900 5,744,076 3.0 % Total Expenses 13,664,378 15,552,114 16,220,917 4.3 % Resources Operating Revenue 14,360,543 15,591,063 17,115,445 9.8 % General Fund 50% Rate Reduction 30,856 27,000 32,000 18.5 % Total Resources 14,391,399 15,618,063 17,147,445 9.8 % Net Operating Surplus (Deficit) 727,021 65,949 926,528 860,579 Personnel - Authorized FTE 15.00 15.00 17.00 Sanitary User Fee Rate Increase 3.00 % 9.00 % 6.00 % Revenue 1% Rate Increase Generates $ 121,461 Improvement Package Summary 1 of 1 This improvement package request is for an Assistant Water & Resource Recovery Center Manager (1.00 FTE at pay grade GE-35) . State and Federal code requires a sufficient number of staff, adequately trained and knowledgeable in the operation, of the Water & Resource Recovery Center, to be retained at all times. The employee in this position will work closely with the Department Manager, Operations Supervisor, Maintenance Supervisor, and Laboratory Supervisor, to promote efficient operation of the Water & Resource Recovery Center. This position provides the additional staff resources needed to support continuous improvement of department processes and organizational culture, and to provide additional focus toward meeting future needs. This request supports the resilient and equitable operation of the Water & Resource Recovery Center. Related Cost: $101,788 Sanitary User Fee Recurring Recommend - Yes Related Cost: $3,570 Sanitary User Fee Non-Recurring Total Cost: $105,358 Sanitary User Fee Impact 1.04 % Activity: Plant Operations -49- Significant Line Items Employee Expense 1.FY 2024 employee expense reflects a 5.00% wage package increase. 2.The Iowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2023 The employee contribution of 6.29% is unchanged from FY 2023. 3.The City portion of health insurance expense is unchanged from $1,119 in FY 2023 to $1,119 in FY 2024 per month per contract which results in an annual cost unchanged of $27,255 or —%. 4.Overtime is unchanged from $59,350 in FY 2023 to $59,350 in FY 2024. FY 2022 actual was $144,690, due to an ongoing transition from three shifts to one shift and a shortage of staff. 5.Five-Year Retiree Sick leave payout is unchanged from $8,839 in FY 2023 to $8,839 in FY 2024. 6.50% Sick Leave Payout unchanged from $1,892 in FY 2023 to $1,892 in FY 2024 based on FY 2023 actual to-date. Effective July 1, 2019, employees over the sick leave cap can convert 50% of the sick leave over the cap to vacation or be paid out. 7.During Fiscal Year 2023, the following personnel changes were approved: a.1.00 FTE Industrial Pre-Treatment Coordinator position (GE-32) was approved, which resulted in a cost increase of $87,871 Supplies & Services 8.Sales Tax expense increased from $411,777 in FY 2023 to $470,793 in FY 2024. This expense is directly offset by Sales Tax revenue. 9.Electricity Utility expense increased from $536,112 in FY 2023 to $561,095 in FY 2024 based on FY 2022 actual of $561,095. This line item represents all electricity expenses at the Water Resource and Recovery Center. Electricity is used in the wastewater conveyance and treatment process, which includes lift stations located across the city. 10.Gas Utility expense increased from $118,570 in FY 2023 to $182,878 in FY 2024 based on FY 2022 actual of $182,878. This line item includes natural gas expenses at the Water Resource and Recovery Center. Natural gas is used for primarily for space heating and water heating at the Water Resource and Recovery Center. 11.Lift Station Maintenance increased from $120,082 in FY 2023 to $200,865 in FY 2024 based on FY 2022 actual of $200,865. This line item includes expenses associated with the cleaning of Lift Stations, as well as as routine maintenance and repairs to Lift Station components such as motors and pumps. The Rustic Point Lift Station will enter service in calendar year 2023. Existing Lift Stations are aging and requiring additional maintenance. 12.Hauling Service expense decreased from $304,900 in FY 2023 to $250,000 in FY 2024. This line item funds the land application of biosolids produced at the Water Resource and Recovery Center, including the associated storage and hauling. The decrease in this expense is due to changes to the agreement that took effect in the Spring of 2022, which reduced the storage cost by $5,100 per month. The storage cost will be reduced further in the Spring of 2027. -50- 13.Equipment Maintenance and Repair increased from $420,664 in FY 2023 to $468,229 in FY 2024 based on FY 2022 actual of $459,048 plus 2%. The increase is due to digester cleaning, more frequent exchange of gas conditioning media, and increasing maintenance of major equipment, including solids conveyor, electrical switchgear, generators, and pumps. This line item represents samplers and lab equipment maintenance ($662), digester cleaning ($102,000), pump, grinder and mixer maintenance ($61,200), primary and final clarifier maintenance ($20,400), boiler treatment ($6,120), siloxane media replacement ($31,880), hydrogen sulfide media replacement ($99,122), ultraviolet lamp replacement ($26,010), water based parts washer maintenance ($3,395), citric acid ($1,020), backflow testing ($2,550), monthly jetting of digester heat exchanger ($3,060), and HVAC maintenance ($10,200). 14.Chemicals increased from $811,284 in FY 2023 to $889,029 in FY 2024 based on FY 2022 actual of $889,029. This line item represents chemicals used at the Water and Resource Recovery Center in the wastewater treatment process. Chemicals used include polymer, liquid oxygen, sodium hypochlorite, iron salts, and lime. The price of liquid oxygen has increased because of transportation and electricity costs. The budget includes tank rental and oxygen based on the expected usage of 80 million cubic feet. The price of polymer has increased due to supply chain issues. Machinery & Equipment 15.Equipment replacement items include ($30,080): WRRC Machinery and Equipment Administration Smart Phone and Case $ 350 Plant Operations Standard Flip Phones (2)$ 60 Shortel Desk Phones (10)$ 2,100 Environmental Monitoring Smart Phone Portable Specific Ion Meter $ 2,500 Lab Bench Specific Ion Meter $ 2,500 BOD Incubator $ 5,000 Refrigerated Samplers $ 8,000 Laboratory Utility Bicycle $ 1,000 Analytical Balance $ 5,000 Fats, Oil, Grease Test Equipment Recommended Improvement Packages $ 3,570 Total Equipment $ 30,080 -51- Debt Service 16.Annual debt service payments for FY 2024 are as follows ($5,744,076): Amount Debt Series Source Purpose Final Payment Call Date $ 61,700 G.O. 2017A Sanitary Fees Sanitary Sewer Improvements 2030 2025 $ 95,436 G.O. 2018A Sanitary Fees Sanitary Sewer Improvements 2031 2026 $ 38,124 G.O. 2021A Sanitary Fees Sanitary Force Main Repairs 2032 2028 $ 119,623 G.O. 2019C Sanitary Fees Sanitary Sewer Improvements 2033 2026 $ 385,700 G.O. 2021A Sanitary Fees Sanitary Sewer Improvements 2034 2028 $ 166,406 G.O. 2016C Sanitary Fees Sanitary Sewer Improvements 2035 2024 $ 62,578 SRF 2006 Sanitary Fees Northfork Catfish Creek 2031 $ 218,238 SRF 2009 Sanitary Fees Meter Change-Out 2031 $ 3,696,900 SRF 2010 Sanitary Fees W&RRC Plant Upgrade 2039 $ 186,500 SRF 2013 Sanitary Fees W&RRC Cogeneration 2033 $ 148,394 SRF 2018 Sanitary Fees Kerper Boulevard Sanitary 2038 $ 256,189 Planned Sanitary Fees Sanitary Projects 2041 $ 207,591 Planned Sanitary Fees Sanitary Projects 2042 $ 100,697 Planned Sanitary Fees Sanitary Projects 2043 $ 5,744,076 Total Sanitary Annual Debt Service Revenue 17.Sewage Fees increased from $12,160,876 in FY 2023 to $12,943,529 in FY 2024 based on the recommended FY 2024 rate increase of 6%. This line item represents revenue received from sewer charges on utility bills and invoicing for hauled septic waste. 18.Late Payment Penalties decreased from $84,464 in FY 2023 to $53,308 in FY 2024 based on FY 2019 Actual of $53,308. This line item represents the sewer portion of late frees received from past- due utility bills. 19.The Water and Resource Recovery Center’s pre-treatment largest industrial customers projected changes in revenues as follows: •Prairie Farms decreased from $560,399 in FY 2023 to $483,841 in FY 2024 based on FY 2022 Actual of $460,801 plus the FY 2023 rate increase of 9.00% and the FY 2024 recommended rate increase of 6.00%. •Inland Protein increased from $160,368 in FY 2023 to $164,760 in FY 2024 based on FY 2022 Actual of $156,914 plus the FY 2023 rate increase of 9.00% and the FY 2024 recommended rate increase of 6.00%. •Rousselot increased from $1,016,253 in FY 2023 to $1,159,573 in FY 2024 based on FY 2022 Actual of $1,104,355 plus the FY 2023 rate increase of 9.00% and the FY 2024 recommended rate increase of 6.00%. •Simmons increased from $534,194 in FY 2023 to $567,000 in FY 2024 based on increased production, FY 2023 year-to-date averages, and the FY 2024 recommended rate increase of 6.00%. -52- 20.High Strength Waste revenue increased from $300,000 in FY 2023 to $305,708 in FY 2024 based on FY 2023 budget. FY 2022 Actual was $285,314. A total of $305,708 was billed for waste accepted in FY 2022. This difference between FY 2022 Actual and FY 2022 billed represents revenue that was collected in early FY 2023 but was billed in late FY 2022. This revenue represents other entities paying the City to take high strength waste which will be used in the anaerobic digesters to generate additional biogas, which is then upgraded to renewable natural gas. 21.Other Leases increased from $132,202 in FY 2023 to $197,706 in FY 2024 based on FY 2023 actual revenue of $197,706. This line item represents revenue received from BioResource Development, which operates a biogas upgrading system at the Water and Resource Recovery Center. The FY 2023 actual revenue represents one whole year of revenue, as BioResource Development is charged and pays on an annual basis. In FY 2023, actual revenue received reflects the following charges to BioResource Development per the agreement: 5% of the gross revenue received by BioResource Development ($20,721), lease of the site ($10,000), staff time reimbursement ($6,000), reimbursement for natural gas ($104,140), and reimbursement for electricity ($56,845). 22.Fats, Oils and Grease Dumping fees increased from $22,606 in FY 2023 to $24,009 in FY 2024 based on FY 2022 actual of $24,009. This revenue represents disposal fees for grease waste collected from local food establishments. The Water and Resource Recovery Center processes grease from local establishes to divert grease from the collection system. -53- WATER & RESOURCE RECOVERY CENTER The Water & Resource Recovery Center uses mechanical, physical, and biochemical processes to clean the wastewater produced by the community before it is returned to the environment. The process provides opportunities to extract resources from the water for use within the Center and the surrounding community. SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES -54- WATER & RESOURCE RECOVERY CENTER FY 2022 FY 2023 FY 2024 Full-Time Equivalent 15.00 15.00 17.00 Resources $14,360,543 $15,591,063 $17,115,445 FY 2022 FY 2023 FY 2024 Operating Revenue $0 $10,000,000 $20,000,000 The Water Resource Recovery Center is supported by 17.00 full-time equivalent employees, which accounts for 24.49% of the department expense as seen below. Overall, the department's expenses are expected to increase by 2% in FY 2024 compared to FY 2023. Expenditures and Debt by Fiscal Year $1,456,457 $3,544,088 $700,000 $268 $239,794 $752,273 $1,575,249 $5,253,365 $1,539,004 $3,471,823 $1,796,419 $244,800 $373,935 $714,116 $1,694,233 $5,574,900 $1,798,289 $3,714,800 $1,800,000 $30,080 $423,683 $729,701 $1,837,404 $5,744,076 FY 2022 FY 2023 FY 2024 Employee Expense Supplies and Services Construction Fund Equipment Engineering OH Public Works OH Admin Overhead Debt Service $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 -55- WATER & RESOURCE RECOVERY CENTER Operations and Maintenance Mission & Services Operations and maintenance of the W&RRC consists of maintaining equipment and records necessary to collect, convey, treat and release 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; Repairing and maintaining all equipment required for the successful and efficient operation of the W&RRC. Stocking essential spare parts and maintaining records for effective operation of the W&RRC. Operations and Maintenance Funding Summary FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd Expenditures $9,905,869 $10,335,597 $10,681,648 Resources $14,260,585 $15,476,185 $16,719,504 Operations and Maintenance Position Summary FY 2024 WRRC MANAGER 1.00 ASST WRRC MANAGER 1.00 MAINTENANCE SUPERVISOR WWT 1.00 W&RRC OPERATIONS SUPERVISOR 1.00 EQUIPMENT MECHANIC - WWT 2.00 INDUSTRIAL ELECTRONICS TECH 1.00 WRRC OPERATOR CERT GR I & II 3.00 PLANT OPERATOR GRADE III 1.00 CONFIDENTIAL ACCOUNT CLERK 1.00 Total FT Equivalent Employees 12.00 Performance Measures City Council Goal: Sustainable Environment Performance Measure (KPI)Target FY 2021 Actual FY 2022 Actual FY 2023 Estimated Performance Indicator 1 Activity Objective: Maintain proper operation and maintenance of pumping stations throughout the City to ensure untreated wastewater is not discharged to streets, storm sewers, or creeks/rivers. # of avg. gallons of wastewater treated per day (in millions)<7 9.17 8.73 6.61 # of pumping station failures/outage incidents 0 4 3 1 # of operators with at least Grade II Certification 5 4 4 4 3 Activity Objective: Increase energy production for use at the W&RRC. % of electricity needs self-produced by the W&RRC 68.3 33.7 36.4 17.8 -56- WATER & RESOURCE RECOVERY CENTER Environmental Monitoring Mission & Services 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 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. 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 61043 FY 2022 Actual FY 2023 Budget FY 2024 Recomm'd Expenditures $341,479 $487,541 $598,767 Resources $106,730 $124,214 $379,177 Environmental Monitoring Position Summary FY 2024 Lab Supervisor 1.00 Lab Technician 2.00 Environmental Coordinator 1.00 Industrial Pretreatment Coordinator 1.00 Total FT Equivalent Employees 5.00 Performance Measures City Council Goal: Sustainable Environment Performance Measure (KPI)Target FY21 Actual FY22 Actual FY 2023 Estimated Performance Indicator 1 Activity Objective: Maintain a Fats, Oil, and Grease (FOG) Program to protect the sanitary sewer system from blockages caused by excessive buildup, helping eliminate sanitary sewer overflows. # of sanitary sewer overflows caused by fats, oils, and grease 0 0 1 1 2 Activity Objective: Ensure a safe water supply in support of the Water Department. # of avg. water samples analyzed per month from various locations in the City (requirement increased from 60 to 70 in 2022) 70 60 60 70 -57- Recommended Operating Revenue Budget - Department Total 43 - WATER & RESOURCE RECOVERY CENTER Fund/Account/Account Title FY21 Actual Revenue FY22 Actual Revenue FY23 Adopted Budget FY24 Recomm'd Budget 610 - Sanitary Sewer Operating 4A - Charges for Services 41380 - Water/Sewer Permit (33,515) (31,475) (33,515) (121,475) 41820 - FOG Inspection Fee 0 0 0 0 41900 - Miscellaneous Licenses 0 0 0 0 43120 - Leases - Other (132,202) (85,235) (132,202) (197,706) 45110 - Sewage Fees (10,444,483) (11,143,200) (12,160,876) (12,943,529) 45115 - Pre-Treatment Customers (1,770,884) (2,231,511) (2,305,078) (2,759,072) 45120 - High Strength Waste (197,041) (285,314) (300,000) (305,708) 45122 - FOG Dumping Fee (22,606) (24,009) (22,606) (24,009) 45210 - Water Tests Outside (28,092) (26,324) (28,092) (60,324) 45211 - Water Tests Internal (30,322) (21,301) (30,322) (21,301) 45212 - Lab Test (45) (150) (45) (150) 45213 - Wastewater Sampling OS (24,685) (19,408) (24,685) (23,908) 45300 - Forfeitures/Penalties (5,305) (53,308) (84,564) (53,308) 45500 - Miscellaneous Chg for Svcs 0 0 0 0 45520 - Customer Credits 0 0 0 0 47100 - Reimbursements (125) (1,354) 0 0 47150 - Refunds (613) (2,442) (393) 0 47350 - Fuel Tax Refunds 0 0 0 0 47450 - Sale of Salvage (124) (399) (124) (258) 4A - Charges for Services Total (12,690,041) (13,925,430) (15,122,502) (16,510,748) 4B - Grants/Contrib 47050 - Contrib - Private Sources 0 0 0 0 4B - Grants/Contrib Total 0 0 0 0 4K - Unrest Invest Earn 43000 - Interest (39,120) (14,780) (39,120) (85,140) 4K - Unrest Invest Earn Total (39,120) (14,780) (39,120) (85,140) 4N - Transfers 49100 - Transfer In General Fund (29,306) (30,856) (27,000) (32,000) 4N - Transfers Total (29,306) (30,856) (27,000) (32,000) 4O - Eliminated for GW 47115 - Sales Tax Collection (377,145) (396,249) (411,777) (470,793) 48200 - Proceeds from GO Debt (4,766,122) — — — 48205 - Bond Discount/Premium (236,009) — — — 4O - Eliminated for GW Total (5,379,276) (396,249) (411,777) (470,793) WRRC - Total (18,137,743)(14,367,315)(15,600,399)(17,098,681) -58- 6A - Salaries & Wages 100 - General 60100 - Salaries-Regular Full Time 0 0 0 0 60400 - Overtime 0 0 0 0 610 - Sanitary Sewer Operating 60100 - Salaries-Regular Full Time 850,420 845,304 1,031,473 1,232,327 60200 - Salaries - Regular Part Time 0 0 0 0 60300 - Hourly Wages - Temp/Seasonal 10,601 14,933 0 0 60400 - Overtime 138,854 144,690 59,350 59,350 60410 - Overtime - Holiday 24,028 26,158 18,821 17,221 60630 - Special Pay Sick Lv Payout Ret 15,193 8,850 8,839 8,839 60635 - Special Pay Sick Lv Payout 50% 1,892 1,946 1,892 1,892 60640 - Special Pay - Vacation Payout 0 9,308 0 0 60710 - Special Pay - Parental Leave 3,496 6,284 0 0 60720 - Spec Pay - Meals No Overnight 0 64 0 64 60730 - Spec Pay - Safety Equipment 4,565 8,413 2,950 2,950 60740 - Spec Pay - Meal Allowance 0 0 0 2 6A - Salaries & Wages Total 1,049,049 1,065,951 1,123,325 1,322,645 6B - Employee Benefits 100 - General 61100 - FICA - City Contribution 0 0 0 0 61300 - IPERS - City Contribution 0 0 0 0 61510 - Health Insurance 0 0 0 0 61540 - Life Insurance 0 0 0 0 610 - Sanitary Sewer Operating 61100 - FICA - City Contribution 75,405 76,993 85,590 100,132 61300 - IPERS - City Contribution 96,958 97,928 104,598 123,560 61510 - Health Insurance 184,440 195,480 201,345 228,600 61540 - Life Insurance 641 550 690 782 61600 - Workers' Compensation 24,988 19,411 23,456 22,426 61992 - Physicals 0 144 0 144 6B - Employee Benefits Total 382,432 390,506 415,679 475,644 6C - Staff Development 610 - Sanitary Sewer Operating 62100 - Association Dues 520 160 1,004 1,004 62200 - Subscriptions 0 0 0 0 62400 - Meetings & Conferences 135 698 5,370 6,295 62500 - Education Reimbursement 4,262 7,040 9,250 9,250 6C - Staff Development Total 4,917 7,898 15,624 16,549 6D - Repair/Maint/Util 610 - Sanitary Sewer Operating 63100 - Building Maintenance 102,439 64,612 102,439 64,612 63220 - Landscaping 0 0 0 0 63311 - Vehicle Ops - Diesel 1,455 16 3,360 3,360 63312 - Vehicle Ops - Gasoline 6,198 15,567 9,295 9,295 63320 - Vehicle Repair - Internal 9,533 11,259 9,723 11,484 Recommended Operating Expenditure Budget - Department Total 43 - WATER & RESOURCE RECOVERY CENTER Fund/Account/Account Title FY21 Actual Expense FY22 Actual Expense FY23 Adopted Budget FY 24 Recomm'd Budget -59- 63321 - Vehicle Repair - Outsourced 1,087 1,986 1,742 2,026 63400 - Equipment Maint/Repair 420,664 459,048 420,664 468,229 63425 - Meter Maintenance 0 0 0 0 63430 - Instrument Maintenance 8,933 2,557 8,933 16,500 63435 - Lift Station Maintenance 120,082 196,927 120,082 200,865 63710 - Electricity 523,247 561,095 536,112 561,095 63711 - Natural Gas 110,246 182,878 118,570 182,878 63730 - Telecommunications 10,703 10,064 10,839 10,809 63740 - Water 52,392 50,813 56,584 55,894 63742 - Stormwater 8,853 8,072 9,601 8,612 6D - Repair/Maint/Util Total 1,375,832 1,564,893 1,407,944 1,595,659 6E - Contractual Svcs 610 - Sanitary Sewer Operating 64010 - Accounting & Auditing 2,600 2,800 2,678 2,800 64020 - Advertising 45 775 495 775 64030 - Outsourced Labor 0 0 20,000 20,000 64040 - Collections 1,133 1,425 1,133 1,425 64045 - Bad Debt Expense 0 0 0 0 64062 - Refunds 6,256 5,405 6,256 5,405 64070 - Engineering - Outsourced 0 0 0 0 64080 - Insurance - Property 76,636 95,942 104,906 121,471 64081 - Insurance - Liability 9,367 11,203 12,975 12,040 64110 - Legal 1,916 10,130 0 0 64130 - Payments to Other Agencies 5,180 1,880 5,834 2,134 64140 - Printing 3,219 1,406 3,901 3,901 64145 - Copying 224 167 223 223 64160 - Rental - Land/Bldgs/Parking 440 440 440 440 64175 - Landfill Fees 43,386 40,355 43,386 40,355 64180 - Sales Tax Expense 376,985 388,885 411,777 470,793 64190 - Technology Services 10,320 12,333 35,207 35,606 64191 - IT Recharges 0 0 0 10,980 64195 - Credit Card Charge 315 96 315 96 64825 - Fire Suppression 15,355 6,386 15,355 6,386 64850 - Consulting Engineers 0 0 0 0 64865 - Elevator Service 2,200 2,400 2,200 2,200 64870 - HVAC Services 8,689 15,151 8,689 8,689 64880 - Custodial Services 9,101 6,301 17,700 17,700 64900 - Other Professional Service 64,577 62,585 45,300 45,300 64975 - Equip Maint Cont 73,760 72,932 73,760 72,932 64976 - Instrument Maint 21,029 10,578 21,029 10,578 64980 - Technology Equip Maint Cont 11,141 11,141 10,920 10,920 64985 - Hauling Contract 287,082 275,450 304,900 250,000 64990 - Other Contractual Service 2,059 0 2,059 2,059 6E - Contractual Svcs Total 1,033,015 1,036,168 1,151,438 1,155,208 6F - Commodities 610 - Sanitary Sewer Operating Recommended Operating Expenditure Budget - Department Total 43 - WATER & RESOURCE RECOVERY CENTER Fund/Account/Account Title FY21 Actual Expense FY22 Actual Expense FY23 Adopted Budget FY 24 Recomm'd Budget -60- 65010 - Chemicals 810,324 889,029 811,284 889,029 65025 - Program Materials 0 0 0 0 65040 - Small Tools & Equipment 5,442 2,041 35,800 14,300 65045 - Technology Equipment 916 268 2,800 30,080 65050 - Other Equipment 0 0 2,000 0 65060 - Office Supplies 1,008 990 1,008 990 65070 - Operating Supplies 3,277 1,563 3,277 1,563 65080 - Postage/Shipping 1,265 1,868 1,291 1,961 65100 - Safety Supplies 597 383 608 383 65925 - Uniform Purchase 2,406 2,272 2,406 2,406 65930 - Flags 0 229 0 0 65950 - Valves/Fittings 0 0 0 0 65965 - Janitorial 5,214 6,845 5,318 6,845 65970 - Lab Supplies 21,150 29,907 35,825 29,907 6F - Commodities Total 851,599 935,396 901,617 977,464 6G - Capital Outlay 610 - Sanitary Sewer Operating 67100 - Vehicles 0 0 240,000 0 67230 - Heavy Equipment 0 0 0 0 67500 - Buildings 29,679 0 0 0 6G - Capital Outlay Total 29,679 0 240,000 0 6H - Debt Service 610 - Sanitary Sewer Operating 68010 - Principal Payment 8,612,701 3,730,206 4,022,524 4,143,668 68020 - Interest Payments 1,668,225 1,523,160 1,552,376 1,600,408 68980 - Financial Consultant 8,595 0 0 0 68990 - Paying Agent Fees 591 0 0 0 6H - Debt Service Total 10,290,113 5,253,365 5,574,900 5,744,076 6I - Transfers 610 - Sanitary Sewer Operating 69100 - Transfers Out To General Fund 1,682,275 1,718,133 1,837,117 1,980,288 69611 - Transfers Out to Sanitary Cap 900,000 700,000 1,796,419 1,800,000 6I - Transfers Total 2,582,275 2,418,133 3,633,536 3,780,288 WRRC - Total 17,598,910 12,672,311 14,464,063 15,067,533 Recommended Operating Expenditure Budget - Department Total 43 - WATER & RESOURCE RECOVERY CENTER Fund/Account/Account Title FY21 Actual Expense FY22 Actual Expense FY23 Adopted Budget FY 24 Recomm'd Budget -61- 0000 - No Sub-Activity 610 - Sanitary Sewer Operating 6E - Contractual Svcs 6,830 7,389 6,830 6H - Debt Service ——— 6I - Transfers 2,418,133 3,633,536 3,780,288 0000 - No Sub-Activity Total 2,424,963 3,640,925 3,787,118 4301 - Administration 610 - Sanitary Sewer Operating 6A - Salaries & Wages 128,202 116,945 122,321 6B - Employee Benefits 34,589 33,680 34,594 6C - Staff Development 4,442 7,729 6,574 6D - Repair/Maint/Util 720 789 720 6E - Contractual Svcs 438,637 487,451 543,102 6F - Commodities 497 —350 6H - Debt Service 5,253,365 5,574,900 5,744,076 4301 - Administration Total 5,860,452 6,221,494 6,451,737 4302 - Plant Operations 610 - Sanitary Sewer Operating 6A - Salaries & Wages 734,292 708,554 812,253 6B - Employee Benefits 259,220 266,486 297,291 6C - Staff Development 3,456 6,585 6,585 6D - Repair/Maint/Util 1,563,418 1,404,318 1,594,170 6E - Contractual Svcs 544,043 612,013 564,249 6F - Commodities 902,194 839,879 918,113 6G - Capital Outlay 0 240,000 0 4302 - Plant Operations Total 4,006,623 4,077,835 4,192,661 4303 - Fats Oils Grease 610 - Sanitary Sewer Operating 6A - Salaries & Wages 22,798 18,517 19,368 6B - Employee Benefits 8,800 8,307 8,438 6C - Staff Development 0 0 0 6E - Contractual Svcs 7,195 9,444 9,444 6F - Commodities 0 0 0 4303 - Fats Oils Grease Total 38,794 36,268 37,250 4305 - Environmental Monitoring 610 - Sanitary Sewer Operating 6A - Salaries & Wages 180,658 279,309 368,703 6B - Employee Benefits 87,897 107,206 135,321 6C - Staff Development 0 1,310 3,390 6D - Repair/Maint/Util 756 2,837 769 6E - Contractual Svcs 39,463 35,141 31,583 6F - Commodities 32,705 61,738 59,001 4305 - Environmental Monitoring Total 341,479 487,541 598,767 Recommended Expenditure Budget Report by Activity & Funding Source 43 - WATER & RESOURCE RECOVERY CENTER Fund/Activity FY22 Actual Expense FY23 Adopted Budget FY24 Recomm'd Budget -62- 4306 - Floodwall Operation 100 - General 6A - Salaries & Wages 0 0 0 6B - Employee Benefits 0 0 0 4306 - Floodwall Operation Total 0 0 0 4399 - Pcard Clearing 610 - Sanitary Sewer Operating 6F - Commodities 0 0 0 WRRC TOTAL 12,672,311 14,464,063 15,067,533 Recommended Expenditure Budget Report by Activity & Funding Source 43 - WATER & RESOURCE RECOVERY CENTER Fund/Activity FY22 Actual Expense FY23 Adopted Budget FY24 Recomm'd Budget -63- C I T Y O F D U B U Q U E , I O W A DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 43 WATER AND RESOURCE RECOVERY CENTER FY 2022 FY 2023 FY 2024 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61010 Full Time Employee Expense 610 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 1.00 $ 51,249 1.00 $ 52,906 1.00 $ 55,338 610 2800 OE-16 ELECTRONIC TECHNICIAN 1.00 $ 68,840 610 2228 GE-31 ENVIRONMENTAL COORDINATOR 1.00 $ 61,437 1.00 $ 58,990 1.00 $ 79,728 610 2400 OE-14 EQUIPMENT MECHANIC - W&RRC 2.00 $ 125,836 2.00 $ 130,086 2.00 $ 136,066 610 GE-32 INDUSTRIAL PRE-TREAT COORD 1.00 $ 68,312 610 GE-33 LAB SUPERVISOR 1.00 $ 68,591 1.00 $ 65,603 1.00 $ 73,722 610 2100 GE-31 LAB TECHNICIAN II 2.00 $ 131,408 2.00 $ 139,991 2.00 $ 132,216 610 2800 OE-16 MAINTENANCE ELECTRICIAN 1.00 $ 63,372 1.00 $ 65,814 —$ — 610 3030 GE-34 MAINTENANCE SUPERVISOR WWT 1.00 $ 84,561 1.00 $ 87,301 1.00 $ 91,315 610 2500 OE-12 W&RRC OPERATOR GR I/II 2.00 $ 114,859 2.00 $ 119,985 3.00 $ 185,979 610 3942 OE-13 W&RRC OPERATOR GR III 2.00 $ 126,223 1.00 $ 62,971 1.00 $ 65,856 610 OE-16 W&RRC OPERATOR GR IV —$ — 1.00 $ 67,343 — 610 3300 GE-35 ASST WRRC MANAGER —$ — —$ — 1.00 $ 74,081 610 3300 GE-40 WRRC MANAGER 1.00 $ 113,261 1.00 $ 116,945 1.00 $ 122,321 610 GE-33 WRRC OPERATIONS SUPERVISOR 1.00 $ 61,533 1.00 $ 63,538 1.00 $ 78,190 TOTAL FULL TIME EMPLOYEES 15.00 $ 1,002,330 15.00 $ 1,031,473 17.00 $ 1,231,964 TOTAL WATER & RESOURCE RECOVERY CENTER 15.00 $ 1,002,330 15.00 $ 1,031,473 17.00 $ 1,231,964 -64- Water & Resource Recovery Center Administration 61043100 61010 610 3300 GE-40 WRRC MANAGER 1.00 $ 113,261 1.00 $ 116,945 1.00 $ 122,321 Total 1.00 $ 113,261 1.00 $ 116,945 1.00 $ 122,321 Water & Resource Recovery Center Plant Operation 61043400 61010 610 3030 GE-34 MAINTENANCE SUPERVISOR WWT 1.00 $ 84,561 1.00 $ 87,301 1.00 $ 91,315 61043400 61010 610 GE-33 WRRC OPERATIONS SUPERVISOR 1.00 $ 61,533 1.00 $ 63,538 1.00 $ 78,190 61043400 61010 610 2400 OE-14 EQUIPMENT MECHANIC - W&RRC 2.00 $ 125,836 2.00 $ 130,086 2.00 $ 136,066 61043400 61010 610 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.65 $ 33,312 0.65 $ 34,389 0.65 $ 35,970 61043400 61010 610 3942 OE-13 W&RRC OPERATOR GR III 2.00 $ 126,223 1.00 $ 62,971 1.00 $ 65,856 61043400 61010 610 OE-16 W&RRC OPERATOR GR IV —$ — 1.00 $ 67,343 — 61043400 61010 610 2500 OE-12 W&RRC OPERATOR GR I/II 2.00 $ 114,859 2.00 $ 119,985 3.00 $ 185,979 61043400 61010 610 2800 OE-16 ELECTRONIC TECHNICIAN 1.00 $ 63,372 1.00 $ 65,814 1.00 $ 68,840 Total 9.65 $ 609,696 9.65 $ 631,427 10.65 $ 736,297 Environmental Monitoring Lab-FT 61043700 61010 610 GE-33 LAB SUPERVISOR 1.00 $ 68,591 1.00 $ 65,603 1.00 $ 73,722 61043700 61010 610 2100 GE-31 LAB TECHNICIAN II 2.00 $ 131,408 2.00 $ 139,991 2.00 $ 132,216 61043700 61010 610 GE-32 INDUSTRIAL PRE-TREAT COORD 1.00 $ 68,312 61043700 61010 610 2228 GE-31 ENVIRONMENTAL COORDINATOR 1.00 $ 61,437 1.00 $ 58,990 1.00 $ 79,728 Total 4.00 $ 261,436 4.00 $ 264,584 5.00 $ 353,978 Fat Oils and Grease-FT 61043500 61010 610 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.35 $ 17,937 0.35 $ 18,517 0.35 $ 19,368 0.35 $ 17,937 0.35 $ 18,517 0.35 $ 19,368 TOTAL WATER & RESOURCE RECOVERY DEPARTMENT 15.00 $ 1,002,330 15.00 $ 1,031,473 17.00 $ 1,231,964 CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2022 FY 2023 FY 2024 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET -65- Capital Improvement Projects by Department/Division WATER & RESOURCE RECOVERY Project Number Capital Improvement Project Title Department Fund Account FY 24 Recomm'd Budget 4381500011 Boiler #2 Water & Resource Recovery 611 64070 100,000 4381500011 Boiler #2 Water & Resource Recovery 611 67500 400,000 4381500012 Odor and Struvite Control System Water & Resource Recovery 611 64070 50,000 4381500012 Odor and Struvite Control System Water & Resource Recovery 611 67990 100,000 4381500013 HVAC Replacement Water & Resource Recovery 611 67500 50,000 4381500014 Lift Station SCADA Upgrades Water & Resource Recovery 611 64070 10,000 4381500014 Lift Station SCADA Upgrades Water & Resource Recovery 611 67990 40,000 WATER & RESOURCE RECOVERY TOTAL 750,000 PRGRM/ DEPT PROJECT DESCRIPTION FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 TOTAL PAGE WATER & RESOURCE RECOVERY CENTER Business Type Final Clarifier Rehabilitation $ — $ 750,000 $ 750,000 $ — $ — $ 1,500,000 95 Lift Station SCADA Upgrades $ 50,000 $ 50,000 $ 50,000 $ — $ — $ 150,000 96 Sidestream Nitrogen Removal $ — $ 400,000 $ 3,600,000 $ — $ — $ 4,000,000 97 Sidestream Phosphorous Removal $ — $ — $ 1,979,245 $ 2,805,755 $ — $ 4,785,000 98 Boiler #2 $ 500,000 $ — $ — $ — $ — $ 500,000 99 Odor & Struvite Control System $ 150,000 $ — $ — $ — $ — 100 Bar Screen Replacement $ — $ 1,590,000 $ — $ — $ — $ 1,590,000 101 RAS Pump Replacement $ — $ 500,000 $ 500,000 $ — $ — $ 1,000,000 102 HVAC Replacement $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 250,000 103 TOTAL $ 750,000 $ 3,340,000 $ 6,929,245 $ 2,855,755 $ 50,000 $ 13,775,000 -66- WATER & RESOURCE RECOVERY CENTER FISCAL YEAR 2024 BUDGET PRESENTATION MISSION STATEMENT Water Resource & Recovery Center To operate and maintain the Water & Resource Recovery Center, in partnership with employees, as we safeguard public health and water quality,meet State and Federal environmental regulations, recover valuable water, energy, and nutrients, in a cost-effective manner, while delivering a great customer experience. Pending Retirements Wayne Polsean 43 years of service Insert Image Here Insert Image Here Water Resource & Recovery Center (17.00 Full-Time Equivalents) FISCAL YEAR 2023 HIGHLIGHTS •High Strength Waste Receiving and Storage Project •Nutrient Reduction Study •UV Disinfection Project FUTURE INITIATIVES •Nutrient Trading •High-strength Waste Receiving & Storage •Renewable Energy •Odor Reduction PROGRAMS & SERVICES •Wastewater Treatment •Hauled Wastes •Environmental Laboratory •Industrial Pretreatment •Fats, Oils, and Grease Service Area = 30 mile radius surrounding Dubuque WASTEWATER TREATMENT •≈ 6.5 million gallons of wastewater treated/day. •W&RRC utilizes physical, chemical, and biological processes in the treatment of wastewater. •Conventional pollutant load reduced by 94%. W&RRC DESIGN CAPACITY •9.14 Million Gallons/Day (Dry Weather Flow) ◦Current: ≈ 6.5 Million Gallons/Day (61%) •36,900 lbs./day Biochemical Oxygen Demand (design average) ◦Current: ≈ 24,000 lbs./Day (66%) •29,400 lbs./day Total Suspended Solids (design average) ◦Current: ≈ 20,000 lbs./Day (68%) RESOURCE RECOVERY •Effluent •Biosolids •Biogas ENVIRONMENTAL LABORATORY •Serves: ◦W&RRC ◦Water Department ◦Public Works ◦Engineering ◦Health Department ◦Public W&RRC COMPLIANCE + REQUIREMENTS •Consent Decree -Eliminate Sanitary Sewer Overflows W&RRC COMPLIANCE + REQUIREMENTS •Nutrient Reduction Requirements ◦Achieve 66% nitrogen reduction ◦Achieve 75% phosphorus reduction ◦Final Report due November 1, 2027 NUTRIENT TRADING ◦Regulatory credit for watershed improvements FY2024 RECOMMENDED IMPROVEMENT REQUESTS 1.Assistant Plant Manager Recurring | $101,788 Non-Recurring | $3,570 Total | $105,358 FY2024 CAPITAL IMPROVEMENT REQUESTS FY 2024 FY 2025 FY 2026 FY 2027 FY 2028 TOTAL Final Clarifier Rehabilitation 0 $750,000 $750,000 0 0 $1,500,000 Lift Station SCADA Upgrades $50,000 $50,000 $50,000 0 0 $150,000 Sidestream Nitrogen Removal 0 $400,000 $3,600,000 0 0 $4,000,000 Sidestream Phosphorous Removal 0 0 $1,979,245 $2,805,755 0 $4,785,000 Boiler #2 $500,000 0 0 0 0 $500,000 Odor & Struvite Control System $150,000 0 0 0 0 Bar Screen Replacement 0 $1,590,000 0 0 0 $1,590,000 RAS Pump Replacement 0 $500,000 $500,000 0 0 $1,000,000 HVAC Replacement $50,000 $50,000 $50,000 $50,000 $50,000 $250,000 Total $750,000 $3,340,000 $6,929,245 $2,855,755 $50,000 $13,775,000 FY 24 PROPOSED RATE INCREASE -SANITARY SEWER 6.00% Proposed Rate Increase over FY 23 $3.77 Monthly Bill Impact for Average Household* *Average Household = 6,000 Gallons/Month FY 24 RATE COMPARISON (Proposed) Rank City Rate 11 Davenport $60.65 10 Des Moines $54.92 9 Ankeny $53.24 8 Dubuque $51.19 7 Sioux City $41.92 6 West Des Moines $41.87 5 Ames $37.10 4 Iowa City $36.88 3 Cedar Rapids $35.16 2 Council Bluffs $33.84 1 Waterloo $33.56 Average w/o Dubuque $42.92 PERFORMANCE MEASURES WATER & RESOURCE RECOVERY CENTER Goal: Exceed 85% Removal of Conventional Pollutants 93.6% removal of Total Suspended Solids in Calendar 2022 94.1% removal of Biochemical Oxygen Demand in Calendar 2022 75% 80% 85% 90% 95% 100% 2022 Pollutant Removal Efficiency 85% Requirement BOD Removal TSS Removal THANK YOU www.cityofdubuque.org/wrrc Group Tours of Water & Resource Recovery Center Available by Appointment Discounted City Utilities Program The City offers income-qualified residential customers a reduction in monthly fees for all four City utilities (water, sanitary sewer, refuse collection, and storm water) of up to 50% of the base rate. Customers must submit an application for consideration and applications are renewed on an annual basis. Learn more and fill out a short application at: www.cityofdubuque.org/utilitiesdiscount or call 563.589.4144 You may be eligible for DISCOUNTED OR FREE INTERNET through the Affordable Connectivity Program (ACP). Struggling to afford internet? How It Works ACP gives a discount on your household’s monthly internet service. Participating internet service providers will apply this discount directly to your service plan. If eligible, your household can receive: • $30 per month discount on wireless internet plans and a free phone • OR $30 per month discount on wired internet service to your home • One-time discount of up to $100 for a laptop, tablet, or desktop computer. A small fee will be required. Your household may be eligible if someone in the household: • Receives SNAP, Medicaid, or other government benefits, or • Meets income guidelines, or • Goes to a school where they receive free or reduced-price lunch and breakfast. Find out if you qualify and how to participate at acp.cityofdubuque.org If you don’t have access to a computer or internet to apply, free access is available at Carnegie-Stout Public Library.