Loading...
Water & Resource Recovery Center FY22 Budget Presentation Copyrig hted March 22, 2021 City of Dubuque Public Hearings # 2. Special Meeting ITEM TITLE: Water& Resource Recovery Center FY22 Budget Presentation SUMMARY: SUGGESTED DISPOSITION: ATTACHMENTS: Description Type Water& Resource Recovery Center FY22 Policy Supporting Documentation Budget Outline Wate r & Res o u rce Recovery Center -31- This page intentionally left blank. -32- WATER & RESOURCE RECOVERY CENTER DEPARTMENT FY 2020 FY 2021 FY 2022 %Change From Budget Highlights Actual Budget Requested FY 2021 Budget Expenses Employee Expense 1,384,498 1,447,483 1,495,438 3.3 % Supplies and Services 3,256,495 3,269,758 3,448,197 5.5 % Payment to Construction Fund 458,758 900,000 700,000 (22.2)% Machinery and Equipment 13,631 28,380 116,710 311.2 % Engineering - SewerAdministration 179,483 249,746 273,818 9.6 % Public Works Sewer Maintenance Charges 732,412 660,557 782,527 18.5 % Administrative Overhead Recharge 1,444,114 1,539,391 1,575,249 2.3 % Payment in Lieu of Taxes 142,884 142,884 142,884 — % Debt Service 6,402,886 5,336,494 5,371,953 0.7 % Total Expenses 14,015,161 13,574,693 13,906,776 2.4 % Resources Operating Revenue 14,077,087 13,727,919 13,913,564 1.4 % Total Resources 14,077,087 13,727,919 13,913,564 1.4 % Net Operating Surplus (Deficit) 61,926 153,226 6,788 (146,438) Personnel -Authorized FTE 15.00 15.00 15.00 Sanitary User Fee Rate Increase 4.50 % — % 3.00 % Revenue 1% Rate Increase Generates $ 102,555 Improvement Package Summary 1 of 1 This improvement request is for an arc flash risk assessment of 17 lift stations (including 181 individual devices) and the WRRC Facility (including 710 individual devices). The assessment consists of the following 3 phases: Phase 1 - Data collection, Phase 2 - Engineering Analysis, Phase 3 - Labels, Label Deployment, and Training. OSHA requires employers to perform a PPE hazard assessment to determine necessary PPE. This assessment satisfies OSHA and NFPA 70E requirements for the assessment of workplace electrical safety. The assessment provides information and training necessary to maintain adequate protection for employees working on or around electrical components. This improvement package supports the following City goal: Financially Responsible, High Performance City Organization: Hire, retain a highly skilled City workforce reflective of the Dubuque Community. Related Cost: $71,500 Sanitary User Fee Recurring Recommend -Yes Sanitary User Fee Impact 0.71 % Every 5 Years Activity: Plant Operations Significant Line Items Employee Expense 1. FY 2022 employee expense reflects a 3.0% wage package increase. 2. The lowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2021 The employee contribution of 6.29% is unchanged from FY 2021. -33- 3. The City portion of health insurance expense is increased from $1,025 in FY 2021 to $1,086 in FY 2022 per month per contract which results in an annual cost increase of$11,040 or 5.99%. 4. Overtime is unchanged from $59,350 in FY 2021 to $59,350 in FY 2022. FY 2020 actual was $196,489, due to an ongoing transition from three shifts to one shift and a shortage of staff. 5. Five-Year Retiree Sick leave payout decreased from $15,211 in FY 2021 to $8,839 in FY 2022. 6. 50% Sick Leave Payout decreased from $1,920 in FY 2021 to $1,746 in FY 2022 based on FY 2021 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. Supplies & Services 7. Property Insurance increased from $74,466 in FY 2021 to $83,000 in FY 2022 based on FY 2020 actual plus 7%. 8. Sales Tax decreased from $345,618 in FY 2021 to $340,611 in FY 2022 based on FY 2020 Actual. This expense is directly offset by sales tax revenue. 9. Electricity Utility Expense decreased from $579,001 in FY 2021 to $553,536 in FY 2022 based on FY 2020 actual of$565,272 plus 2% and minus $40,000 which reflects savings from increased mircroturbine output. 10. Gas Utility Expense increased from $109,180 in FY 2021 to $113,106 in FY 2022 based on FY 2020 actual of$113,106. 11. Property Maintenance increased from $66,831 in FY 2021 to $68,350 in FY 2022 based on FY21 Budget plus 2%. 12. Machinery and Equipment Maintenance increased from $317,935 in FY 2021 to $350,339 in FY 2022. FY 2020 actual was $350,339. This results from increasing digester cleaning (+$40,000) based on FY 2021 year-to-date actual costs, increasing pump, grinder, and mixer maintenance (+ $24,000) due to more frequent repair of equipment due to heavy wear from grit from I&I, and increased primary and final clarifier maintenance due to increased grit from I&I ($+10,000). There is an annual cost savings in this line item of$50,000 due to the purchase of a pump trailer in Fiscal Year 2021. This line item represents samplers and lab equipment maintenance ($3,142), digester cleaning ($100,000), pump, grinder and mixer maintenance ($60,000), primary and final clarifier maintenance ($20,000), boiler treatment ($6,000), siloxane media replacement ($31,255), hydrogen sulfide media replacement ($97,178), ultraviolet lamp replacement ($25,500), water based parts washer maintenance ($3,328), citric acid ($1,000), backflow testing ($2,500), monthly jetting of digester heat exchanger ($3,000), and HVAC maintenance ($15,000). 13. Equipment Maintenance Contract Expense decreased from $76,490 in FY 2021 to $73,698 in FY 2022 based on FY 2020 actual of$73,698. 14. Lift Station Maintenance increased from $124,595 in FY 2021 to $157,692 in FY 2022 based on FY 2020 actual of$157,692. 15. Polymer Expense increased from $237,073 in FY 2021 to $355,235 in FY 2022 based on FY 2020 actual of$355,235. -34- 16. Liquid Oxygen decreased from $467,041 in FY 2021 to $448,602 in FY 2022. The FY 2022 budget includes $28,362 for tank rental and $420,240 for oxygen based on the expected usage of 800,000 hundred cubic feet at $0.5253 per hundred cubic feet. FY 2020 actual was $381,407. 17. Hauling Service unchanged from $304,900 in FY 2021 to $304,900 in FY 2022. Machinery 8� Equipment 18. Equipment replacement items include ($116,710): Administration = Smart Phone $ 350 Plant Operations Compact Pickup (1) Heavy Duty Pickup with Plow (1) $ 65,000 Forklift $ 31,500 Shop Equipment $ 10,000 Desk & Cell Phones $ 2,160 Environmental Monitorinq Laboratory Equipment $ 7,700 Total Equipment $ 116,710 Debt Service 19. Annual debt service payments for FY 2022 are as follows ($5,371,953): Final Call Amount Debt Series Source Purpose Payment Date $ 64,700 G.O. 2017A Sanitary Fees Sanitary Sewer Improvements 2030 2025 $ 94,687 G.O. 2018A Sanitary Fees Sanitary Sewer Improvements 2031 2026 $ 44,639 G.O. 2012E Sanitary Fees Sanitary Force Main Repairs 2032 2019 $ 123,911 G.O. 2019C Sanitary Fees Sanitary Sewer Improvements 2033 2026 $ 438,125 G.O. 2014B Sanitary Fees Sanitary Sewer Improvements 2034 2021 $ 166,006 G.O. 2016C Sanitary Fees Sanitary Sewer Improvements 2035 2024 $ 62,697 SRF 2006 Sanitary Fees Northfork Catfish Creek 2031 $ 217,703 SRF 2009 Sanitary Fees Meter Change-Out 2031 $ 3,696,459 SRF 2010 Sanitary Fees W&RRC Plant Upgrade 2039 $ 186,440 SRF 2013 Sanitary Fees W&RRC Cogeneration 2033 � $ 147,905 SRF 2018 Sanitary Fees Kerper Boulevard Sanitary 2038 $ 111,399 Planned Sanitary Fees Sanitary Projects 2041 _ $ 17,282 Planned Sanitary Fees Sanitary Projects 2042 $ 5,371,953 Total Sanitary Annual Debt Service -35- Revenue 20. Sewage Fees decreased from $10,873,168 in FY 2021 to $10,563,212 in FY 2022 based FY 2020 plus a 3% rate increase in FY 2022. 21. Sewage dumping fees increased from $120,634 in FY 2021 to $125,877 in FY 2022 based on FY 2020 Actual of$125,877. 22. Late Payment Penalties decreased from $118,344 in FY 2021 to $84,464 in FY 2022 based on FY 2020 Actual $84,464. 23. The Water and Resource Recovery Center's pre-treatment largest industrial customers projected changes in revenues as follows: • Prairie Farms increased from $494,324 in FY 2021 to $510,304 in FY 2022 based on FY 2020 Actual $510,304. • Inland Protein decreased from $163,518 in FY 2021 to $137,383 in FY 2022 based on FY 2020 Actual $137,383. • Rousselot is decreased from $1,021,890 in FY 2021 to $961,415 in FY 2022 based on FY 2020 Actual $961,415. 24. High Strength Waste revenue increased from $171,999 in FY 2021 to $240,679 in FY 2022 based on FY 2020 actual of$240,679. 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. 25. Gas Revenue decreased from $158,686 in FY 2021 to $132,000 in FY 2022 . This line item represents 5°/o of the gross revenue for BioResource Development ($14,000), lease of the site ($10,000), staff time reimbursement ($6,000), reimbursement of gas ($40,000) and electric reimbursement ($62,000). Electric reimbursement decreased from $82,663 in FY 2021 to $62,000 in FY 2022 due to BioResource Development installing a more efficient compressor that uses less electricity. 26. Fats, Oils and Grease Permit and Dumping fees decreased from $23,996 in FY 2021 to $16,762 in FY 2022 based on FY 2020 actual of$16,762. -36- 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. Water& Resource Rec�very Center � � Administrati�n �N�rati�ns and Evniranmental Maintenance 11l14niir�ring SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES � PLANNIN� I The V�lS�RR� ha� ongoi�g planning � and implemen#ation f�r sev�ral � . environmental i��ue� including spill PE�PLE prevention pla��; Bio-�olid� h�lanagement ar�d Nutriant F�educ�ior�_ 1dV&RR� �taff: Health D�partment, Engineerin� and Public Works � � provided th� r�tajority o� our �it�r � . relation�hip�. V�le also maintain � , � .� relation�hip� with local indu�trie� ` . _ ��- �. , ��� � _ -- the Resili�nt �ommunity Advisory - .�. �-� ~ --� . � �� °.,.�.,. .. � :_ �ommission and F�e�ionaliLocal . ' t,. I II �� Er��ineer�. � ..� �� . „�µ+r �',���..�2�. � . ..- �^«rt�� "')R 7 � t, . '.tir 'f �.. 7�T' 1�:�.WS�.�/1*�' r�r � .� �',�., � � { �� . . PA�TNEF��HIPS The V�l�F�R� maintains partr�er�hips wi#h � �i#� Departmen#�. lowa Department of � Na#�ral Resaurces, U�EPA; Lacaf � . ��� Industrie� and locallregional±�ervice praviders. -37- WATER & RESOURCE RECOVERY CENTER FY 2020 FY 2021 FY 2022 Full-Time Equivalent 15.00 15.00 15.00 Resources $20,000,000 $10,000,000 $14,077,087 $13,727,919 $13,913,564 $0 Operating Revenue FY 2020 � FY 2021 FY 2022 The Water Resource Recovery Center is supported by 15.00 full-time equivalent employees, which accounts for 25.96% of the department expense as seen below. Overall, the department's expenses are expected to increase by 1% in FY 2022 compared to FY 2021. Expenditures and Debt by Fiscal Year mplOY�e FXp�ns� $1,384,498 $1,447,483 Supplies S�ry, $1,495,438 and $3,256,495 ��s $3,269,758 $3,448,197 �OhstrU�t�on�und � $458,758 $900,000 $700,000 �qU�pment $28,380 $116,710 Eng�n�ering ON $179,483 $249,746 $273,818 �'Ubli�wor ks�H $732,412 � $660,557 $782,527 Admin p�er�,�ad $1,444,114 $1,539,391 $1,575,249 ��bt S�ry��e $5,336 494886 $5,371,953 $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 FY 2020 FY 2021 FY 2022 -38- 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 2020 Actual FY 2021 Budget FY 2022 Requested Expenditures $10,707,317 $9,615,284 $9,957,154 Resources $13,948,380 $13,579,366 $13,783,358 Operations and Maintenance Position Summary FY 2022 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 II 2.00 PLANT OPERATOR GRADE III & IV 2.00 CONFIDENTIALACCOUNT CLERK 1.00 Total FT Equivalent Employees 11.00 Performance Measures City Council Goal: Sustainable Environment Performance Measure(KPI) Target FY 2019 FY 2020 FY 2021 Performance Actual Actual Estimated Indicator � 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 �� g.17 8.73 7.22 C � per day(in millions) #of pumping station failures/outage 0 4 3 1 C � incidents #of operators with at least Grade II 5 4 4 4 C � Certification 3 Activity Objective: Increase energy production for use at the W&RRC. % of electricity needs self-produced by 68.3 33.7 36.4 56.8 a the W&RRC -39- 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 FY 2020 Actual FY 2021 Budget FY 2022 Requested Expenditures $331,973 $450,807 $462,818 Resources $126,646 $142,147 $126,645 Environmental Monitoring Position Summary FY 2022 Lab Supervisor 1.00 Lab Technician 2.00 Environmental Coordinator 1.00 Total FT Equivalent Employees 4.00 Performance Measures City Council Goal: Sustainable Environment Performance Measure(KPI) Target FY19 FY20 FY 2021 Performance Actual Actual Estimated Indicator � 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 0 0 1 0 � fats, oils, and grease 2 Activity Objective: Ensure a safe water supply in support of the Water Department. #of avg. water samples analyzed per 16 16 16 16 � week from various locations in the City .� '� � � , �" r` . .�.�,�: � >��k � - *. � �� • t 'y�' . l,' I yl�� � � � '�'# !t ,�Sr .�. .�� 1 �. �. �` '- �p �+��.i t S �� � ., . - ����, i� I, 7. � � -. . . �'l .af r'� ��'. � �"1 y�� ��� � � "5 ' _ �� r� r. #�� �.tysir.+c". . � .. �.����� '� �'S .f �..� �-�.' - {�. . -40- Recommended Operating Revenue Budget - Department Total 43-WATER&RESOURCE RECOVERY FY19 Actual FY20 Actual FY21 Adopted FY22 Recomm'd Fund Account Account Title Revenue Revenue Budget Budget 610 42230 SF,WAGE DISPOSAL PERMITS 865 1,050 865 1,050 610 42237 FOG PERMITS 35,425 33,070 35,425 33,070 42 LICENSES AND PERMITS -Total � 36,290 34,120 36,290 34,120 610 43ll0 INVESTMENTEARNINUS 60,573 85,140 54,515 85,140 43 USE OF MONEY AND PROPERTY-Total � 60,573 85,140 54,515 85,140 610 51185 WATER TESTS-OUTSIDE 36,754 29,023 36,754 29,023 610 51205 SEWAGE FEES 10,100,349 10,255,546 10,873,168 10,563,212 610 51206 SEWAGE RATE CREDIT 0 0 (124,692) 0 610 51215 LATE PAYMENT PENALTY 163,649 84,464 118,344 84,464 610 51216 FOG PENALTIES 200 100 200 100 610 51218 ARTCO FLEETING 969 736 969 736 610 51220 SWISS VALLEY FARMS 475,312 510,304 494,324 510,304 610 51223 SIMMONS 0 0 0 412,800 610 51225 INLAND PROTEIN 182,967 137,383 163,518 137,383 610 51227 HIGH STRENGTH WASTE 171,999 240,679 171,999 240,679 610 51230 SEWAGE DUMPING FEES 120,634 125,877 120,634 125,877 610 51231 FOG DUMPING FEES 23,996 16,762 23,996 16,762 610 51235 WWIND.PRETREATMENT 36,634 35,054 36,634 35,054 610 51240 SAN ROUESSLOT 871,432 961,415 1,021,890 961,415 610 51256 BRD LEASE 10,000 0 10,000 10,000 610 51257 BRD STAFF REIMBURSEMENT 0 0 3,000 6,000 610 51258 BRD GAS REIMBURSEMENT 54,329 0 51,023 40,000 610 51259 BRD ELECTRiC REIMB 82,663 0 82,663 62,000 610 51260 BRD GROSS REVENUE 20,643 0 12,000 14,000 610 51690 LANDFILL PAYMF.NT-LAB TEST 1,731 664 1,731 664 610 51)64 ARENA NOVELT 460 175 460 175 51 CHARGES FOR SERVICES -Total 12,354,720 12,398,181 13,098,615 13,250,648 610 53201 REFUNDS 181 0 0 0 610 53204 IOWA FUEL TAX REFUND 0 458 0 458 610 53520 WATER SAMPLING-PLANT 34,731 30,442 37,344 30,442 610 53523 WWT SAMPLiNG-OUTSIDE 27,852 24,650 24,870 24,650 610 53605 MISCELLANEOUS REVENUE 0 11,000 0 ll,000 610 53620 REIMBURSF,MENTS-GENERAL 9 1,756 0 1,756 610 53630 SALES TAX COLLECTION 327,526 324,382 345,017 340,610 53 MISCELLANEOUS -Total 390,299 392,687 407,231 408,916 610 54109 SALVAGE SALES 260 252 170 252 610 54210 GO BOND PROCEEDS 11,3 L2 1,1 L4,180 0 0 610 54220 BOND DISCOUNT 512 50,465 0 0 54 OTHER FINANCING SOURCES -Total � 12,084 1,164,897 l70 252 610 59100 FR GENERAL 0 0 124,692 130,927 59 TRANSFER IN AND INTERNAL -Total � 0 0 124,692 130,927 WATER&RESOURCE RECOVERY-Total 12,853,967 14,075,026 13,721,513 13,910,003 -41- Recommended Operating Expenditure Budget - Department Total 43-WATER&RESOURCE RECOVERY FY19 Actual FY20 Actual FY21 Adopted FY 22 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 61010 FULL-TIME EMPLOYEES 4,049 2,425 0 0 610 61010 FULL-TIME EMPLOYEES 863,911 751,828 966,433 1,002,330 610 61020 PART-TIME EMPLOYEES 174 1,065 0 0 610 61030 SEASONAL EMPLOYEES 8,600 5,624 0 0 100 61050 OVERTIME PAY 1,571 2,024 0 0 610 61050 OVERTIME PAY 94,461 194,465 59,350 59,350 610 61071 HOLIDAY PAY-OVERTIME 24,471 22,171 17,221 17,221 610 61081 COVIDI9 SCHOOL/DAYCARE CL 0 2,450 0 0 610 61082 COVIDI9 SICK FAMILY CARE 0 162 0 0 610 61083 COVIDI9 EMP NON-WORK 0 6,483 0 0 610 61091 SICK LEAVE PAYOFF 10,770 14,125 15,211 8,839 610 61092 VACATION PAYOFF 2,704 8,072 0 0 610 61095 PARENTAL LEAVE 0 10,046 0 0 610 61096 50%SICK LEAVE PAYOUT 0 1,746 1,920 1,746 100 61310 IPERS 530 420 0 0 610 61310 IPERS 93,609 93,838 98,460 101,830 100 61320 SOCIAL SECURITY 409 323 0 0 610 61320 SOCIAL SECURITY 73,129 74,886 81,100 83,346 100 61410 HEALTH INSURANCE 1,139 1,229 0 0 610 61410 HEALTH INSURANCE 213,504 161,311 184,440 195,480 610 61415 WORKMENS'COMPENSATION 29,293 23,810 22,125 21,023 100 61416 LIFE INSURANCE 3 3 0 0 610 61416 LIFE INSURANCE 650 567 843 843 610 61640 SAFETY EQUIPMENT 10,968 4,944 250 2,950 610 61650 MEAL ALLOWANCE 18 6 0 6 610 61660 EMPLOYEE PHYSICALS 384 474 130 474 61-WAGES AND BENEFITS 1,434,346 1,384,498 1,447,483 1,495,438 610 62010 OFFICE SUPPLIES (451) 1,782 2,238 1,782 610 620ll LTNIFORM PURCHASES 1,637 3,290 2,500 3,290 610 62030 POSTAGE AND SHIPPING 1,946 1,546 2,710 1,577 610 62032 FLAGS 0 160 135 163 610 62061 DP EQUIP.MAINT CONTRACTS 8,610 8,808 9,542 ll,141 610 62062 JANITORIAL SUPPLIES 1,588 4,619 1,619 4,711 610 62065 LAB SUPPLIES 32,886 23,401 37,825 35,825 610 62090 PRINTING&BINDING 1,412 3,825 2,762 5,262 610 62110 COPYING/REPRODUCTION 376 305 376 305 610 62130 LEGAL NOTICES&ADS 925 1,920 647 1,920 610 62140 PROMOTION 0 200 450 450 610 62170 SUBSCRIPTIONS-BOOKS-MAPS 0 0 300 0 610 62190 DUES&MEMBERSHIPS 770 160 882 420 610 62204 REFLTNDS 95,767 7,184 ll,065 7,184 610 62206 PROPERTY INSURANCE 70,920 77,309 74,466 83,000 610 62208 GENERAL LIABILITY INSURAN 10,940 12,479 ll,487 9,904 610 62210 SALES TAX 324,224 317,409 345,618 340,611 610 62310 TRAVEL-CONFERENCES 3,469 1,423 3,700 4,200 610 62320 TRAVEL-CITY BUSINESS 33 577 435 580 610 62360 EDUCATION&TRAINING 6,339 5,075 9,250 9,310 610 624ll UTILITY EXP-ELECTRICITY 536,ll2 565,272 579,001 553,536 -42- Recommended Operating Expenditure Budget - Department Total 43-WATER&RESOURCE RECOVERY FY19 Actual FY20 Actual FY21 Adopted FY 22 Recomm'd Fund Account Account Title Expense Expense Budget Budget 610 62412 UTILITY EXP-GAS 109,180 113,106 109,180 113,106 610 62415 UTILITY EXPENSE STORMWATR 13,450 15,761 15,340 16,837 610 62416 UTILITY EXP-WATER 46,624 41,759 50,936 43,847 610 62421 TELEPHONE 8,042 7,763 8,666 7,762 610 62424 RADIO/PAGER FEE 2,006 1,967 2,106 2,085 610 62431 PROPERTY MAINTENANCE 66,831 55,673 66,831 68,350 610 62434 HVAC MAINTENANCE 0 7,123 0 7,123 610 62435 ELEVATOR MAINTENANCE 2,505 2,400 2,400 2,400 610 62436 RENTAL OF SPACE 440 440 480 440 610 62438 FIRE SUPPRESSION 0 5,397 0 5,397 610 625ll FUEL,MOTOR VEHICLE 7,642 7,801 8,450 8,450 610 62513 FUEL,DIESEL 3,753 1,758 3,200 3,200 610 62521 MOTOR VEHICLE MAINT. 8,354 10,336 8,521 10,542 610 62528 MOTOR VEH.MAINT.OUTSOUR 1,784 4,520 1,742 1,742 610 626ll MACH/EQUIP MAINTENANCE 333,007 350,339 317,935 350,339 610 62612 MAJOR REPAIR ELEMENT 0 51,385 50,000 51,385 610 62613 METER MAINTENANCE 5,500 0 5,500 0 610 62614 EQUIP MAINT CONTRACT 72,867 73,698 76,490 73,698 610 62623 CETRIFUGE MAINTENANCE 0 4,849 34,942 37,000 610 62625 LIFT STATION MAINTENANCE ll2,200 157,692 124,595 157,692 610 62628 INSTRUMENTATION MAINT 1,092 1,250 13,000 1,250 610 62629 INSTR MAINT CONTRACT 538 44,152 22,500 44,152 610 62633 CHLORINE 7,609 10,294 8,000 10,294 610 62637 LANDSCAPE/FERT/PLANTS 0 22 0 22 610 62638 POLYMER 249,550 355,235 237,073 355,235 610 62639 LIQUID CO2/02 420,741 381,407 467,041 448,602 610 62663 SOFTWARE LICENSE EXP 40,981 10,595 10,568 10,595 610 62666 CREDIT CARD CHARGE 424 567 600 567 610 62667 DATA SERVICES 496 810 1,721 810 610 62678 EDUCATIONAL MATERIALS 293 0 293 0 610 62681 LUBRICATION PRODUCTS 6,977 3,683 6,977 3,683 610 62692 LANDFILL FEES 38,699 93,633 51,531 51,531 610 62696 OUTSIDE COLLECTOR EXPENSE 4,049 5,142 4,049 5,142 610 62710 CONTRACTOR SERVICES 0 352 0 352 610 62712 CONSULTING ENGINEERS 17,565 22,044 0 22,044 610 62713 LEGAL SERVICES 1,080 4,212 0 0 610 62716 CONSULTANT SERVICES 28,370 8,283 85,949 84,087 610 62726 AUDIT SERVICES 2,400 2,500 2,400 0 610 62731 MISCELLANEOUS SERVICES 5,461 6,791 0 2,700 610 62732 TEMP HELPCONTRACT SERV. 0 0 20,000 20,000 610 62733 CONTRACT CUSTODIAL 13,931 17,660 17,700 17,700 610 62736 CATERING SERVICES 0 513 300 300 610 62763 PAYMENT TO IOWA DNR 7,404 1,870 5,834 2,134 610 62767 ENVIRON.TESTING/MON. 27,028 25,288 25,000 25,000 610 62780 HAULING SERVICES 274,473 309,681 304,900 304,900 62-SUPPLIES AND SERVICES 3,040,849 3,256,495 3,269,758 3,447,666 610 62724 BOND PAYING AGENT FEE 0 531 0 531 627-CONTRACTUAL SERVICES 0 531 0 531 -43- Recommended Operating Expenditure Budget - Department Total 43-WATER&RESOURCE RECOVERY FY19 Actual FY20 Actual FY21 Adopted FY 22 Recomm'd Fund Account Account Title Expense Expense Budget Budget 610 71120 PERIPHERALS,COMPUTER R5 0 3,680 0 610 71312 VAN/PICKUP/WAG REPL 0 0 0 65,000 610 71318 HEAVY EQUIP-REPLACEMENT 0 0 0 31,500 610 71410 SHOP EQUIPMENT 1,827 9,289 10,000 10,000 610 71413 LABORATORY EQUIPMENT 17,192 430 10,800 7,700 610 71421 ffiGH PRESSURE SPRAY 0 2,800 0 0 610 71521 REFRIGERATOR 0 1,099 0 0 610 71610 CUSTODIAL EQUIPMENT 143 0 0 0 610 72418 TELEPHONE RELATED 168 13 3,400 2,510 610 72515 TEST EQUIPMENT,OTHER 24 0 500 0 71-EQUIPMENT 19,439 13,631 28,380 116,710 610 741 ll PRINCIPAL PAYMENT 3,473,317 4,729,712 3,651,034 3,777,014 610 74112 INTEREST PAYMENT 1,760,167 1,673,174 1,685,460 1,594,939 74-DEBT SERVICE 5,233,483 6,402,886 5,336,494 5,371,953 610 9ll00 TO GENERAL 1,519,572 1,586,998 1,682,275 1,718,133 610 91710 TO SANITARY SEWER CONST 845,000 458,758 900,000 700,000 91-TRANSFER TO 2,364,572 2,045,756 2,582,275 2,418,133 43-WATER&RESOURCE RECOVERY TOTAL 12,092,689 13,103,796 12,664,390 12,850,431 -44- Recommended Expenditure Budget Report by Activity & Funding Source 43-WATER& RESOURCE RECOVERY UNDISTRIBUTED - 10610 FUNDING SOURCE:SEWAGE FACILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget SUPPLIES AND SERVICES 12,326 16,024 12,326 TRANSFER TO 2,045,756 2,582,275 2,418,133 UNDISTRIBUTED 2,058,082 2,598,299 2,430,459 WPC ADMINISTRATION -43100 FUNDING SOURCE:SEWAGE FACILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget CONTRACTUAL SERVICES 531 531 DEBT SERVICE 6,402,886 5,336,494 5,371,953 EQUIPMENT 13 210 350 SUPPLIF,S AND SF,RVICF,S 349,732 400,560 390,323 WAGES AND B6NFFITS 154,014 148,234 145,948 WRRP ADMINISTRATION 6,907,175 5,885,498 5,909,105 FLOODWALL OPER./MAINT. -43340 FUNDING SOURCE:GENERAL Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget WAGES AND BENEFITS 6,425 FLOODWALL OPER./MAINT. 6,425 WPC PLANT OPERATIONS -43400 FUNDING SOURCE:SEWAGE FACILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget EQUIPMENT 13,188 16,660 108,660 SUPPLIES AND SERVICES 2,823,900 2,764,373 2,962,918 WAC'rES AND BENEFITS 926,830 915,419 941,227 WRR PLANT OPERATIONS 3,763,918 3,696,452 4,012,805 FATS OILS GREASE -43500 FUNDING SOURCE:SEWAGE FACILITY OPERATION Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget EQUIPMENT 0 500 0 SUPPLIES AND SERVICES 9,155 7,626 9,204 WAGES AND BENEFITS 27,068 25,208 26,040 FATS O1LS GREASE 36,224 33,334 35,244 ENVIRON-MONITORING -43700 FUNDING SOURCE:SEWAGE FACILITY OPERATION -45- Account FY20 Actual Expense FY21 Adopted Budget FY22 Recomm'd Budget EQUIPMENT 430 11,010 7,700 SUPPLIES AND SERVICES 61,382 A1,175 72,895 WAGES AND BENEFITS 270,161 358,622 382,223 ENVIRON-MONITORING 331,973 450,807 462,818 WATER&RESOURCE RECOVERY TOTAL $13,103,796 $12,664,390 $12,850,431 -46- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 43 WATER AND RESOURCE RECOVERY CENTER FY 2020 FY 2021 FY 2022 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61010 Full Time Employee Expense 610 5080 GE-40 WRRC MANAGER 1.00 $ 108,576 1.00 $ 111,599 1.00 $113,261 610 3030 GE-34 MAINTENANCE SUPERVISOR WWT 1.00 $ 82,420 1.00 $ 83,333 1.00 $ 84,561 610 GE-33 WRRC OPERATIONS SUPERVISOR 1.00 $ 67,792 1.00 $ 69,426 1.00 $ 61,533 610 GE-33 LAB SUPERVISOR 1.00 $ 78,150 1.00 $ 67,589 1.00 $ 68,591 610 GE-31 ENVIRONMENTAL COORDINATOR 1.00 $ 65,706 1.00 $ 53,134 1.00 $ 61,437 610 2100 GE-31 LAB TECHNICIAN II 2.00 $ 121,973 2.00 $ 126,360 2.00 $131,408 610 GE-25 CONFIDENTIALACCOUNTCLERK 1.00 $ 49,535 1.00 $ 50,518 1.00 $ 51,249 610 2400 0E-14 EQUIPMENT MECHANIC-WWT 2.00 $ 122,200 2.00 $ 123,556 2.00 $125,836 610 2800 0E-14 MAINTENANCE ELECTRICIAN 1.00 $ 62,125 1.00 $ 60,753 1.00 $ 63,372 610 0E-14 WRRC OPERATOR CERT GR IV 1.00 $ 63,243 1.00 $ 64,063 1.00 $ 65,234 610 0E-13 WRRC OPERATOR CERT GR III 1.00 $ 59,102 1.00 $ 60,103 1.00 $ 60,989 610 2500 0E-12 WRRC OPERATOR CERT GR II 2.00 $ 109,273 2.00 $ 110,480 2.00 $114,859 TOTAL FULL TIME EMPLOYEES 15.00 $ 990,095 15.00 $ 980,914 15.00 $1,002,33C TOTAL WATER&RESOURCE RECOVERY CENTER 15.00 $ 990,095 15.00 $ 980,914 15.00 $1,002,33( -47- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2020 FY 2021 FY 2022 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Water&Resource Recovery Center Administration 61043100 61010 610 3300 GE-40 WRRC MANAGER 1.00 $ 108,576 1.00 $ 111,599 1.00 $ 113,261 Total 1.00 $ 108,576 1.00 $ 111,599 1.00 $ 113,261 Water&Resource Recovery Center Plant Operation MAINTENANCE SUPERVISOR 61043400 61010 610 3030 GE-34 WWT 1.00 $ 82,420 1.00 $ 83,333 1.00 $ 84,561 WRRC OPERATIONS 61043400 61010 610 GE-33 SUPERVISOR 1.00 $ 67,792 1.00 $ 69,426 1.00 $ 61,533 EQUIPMENT MECHANIC- 61043400 61010 610 2400 0E-14 W&RRC 2.00 $ 122,200 2.00 $ 123,556 2.00 $ 125,836 61043400 61010 610 1000 GE-25 CONFIDENTIALACCOUNTCERK 0.65 $ 32,198 0.65 $ 32,837 0.65 $ 33,312 61043400 61010 610 3942 0E-13 W&RRC OPERATOR GR III/IV 2.00 $ 122,345 2.00 $ 124,166 2.00 $ 126,223 61043400 61010 610 2500 0E-12 W&RRC OPERATOR GR I/II 2.00 $ 109,273 2.00 $ 110,480 2.00 $ 114,859 61043400 61010 610 2800 0E-14 MAINTENANCE ELECTRICIAN 1.00 $ 62,125 1.00 $ 60,753 1.00 $ 63,372 Total 9.65 $ 598,353 9.65 $ 604,551 9.65 $609,696 Environmental Monitoring Lab-FT 61043700 61010 610 GE-33 LAB SUPERVISOR 1.00 $ 78,150 1.00 $ 67,589 1.00 $ 68,591 61043700 61010 610 2100 GE-31 LAB TECHNICIAN II 2.00 $ 121,973 2.00 $ 126,360 2.00 $ 131,408 ENVIRONMENTAL 61043700 61010 610 2228 GE-31 COORDINATOR 1.00 $ 65,706 1.00 $ 53,134 1.00 $ 61,437 Total 4.00 $ 265,829 4.00 $ 247,083 4.00 $261,436 Fat Oils and Grease-FT CONFIDENTIALACCOUNT 61043500 61010 610 1000 GE-25 CLERK 0.35 $ 17,337 0.35 $ 17,681 0.35 $ 17,937 0.35 $ 17,337 0.35 $ 17,681 0.35 $ 17,937 TOTAL WATER&RESOURCE RECOVERY DEPARTMENT 15.00 $ 990,095 15.00 $ 980,914 15.00 $1,002,330 -48- Capital Improvement Projects by Department/Division WATER&RESOURCE RECOVERY FY 19 Actual FY 20 Actual FY 21 Adopted FY 22 Recomm'd CIP Number Capital Improvement Project Title Expense Expense Budget Budget 7101305 CATFISH PUMP REPLACEMENT 16,830 21,642 7101339 SCADA SYSTEM UPGRADE 50,000 50,000 7101731 DOG TRACK LIFT STATION 10,608 7101837 WRR PLANT RENOVATION 7101924 SLUDGE/GREASE GRINDERS — 25,000 7102149 STANDBY GENERATOR 60,000 7102412 CEDAR LIFT PUMP/GEN/TRAIL 149,511 7102538 AIRPORT LS UPGRADES 13,906 7102599 KERPER PUMP MOTOR/CONTROL 7102601 REPLACEMENT OF RAD10S 7102659 NUTRIENT RED/BASIN MOD 1 7102698 METHANE GAS SYSTEM WRRC 6,673 — 7102700 LEVEL 4 AGREEMENT 519 7102701 HS WASTE RECEIVE&STORE 1,632,346 7102750 GRANGER CREEK LIFT STATIO 7,142 7102787 WRRC CAMERAS 7102840 PUMP TRAILER WRRC 110,000 7102841 UV DISINFECTION WRRC 235,000 7102904 LABORATORY HVAC REPLC 15,000 7102935 KERPER LIFT STATION PUMP — — — 40,000 WATER&RESOURCE RECOVERY TOTAL 55,677 171,153 395,000 1,822,346 -49- PRGRM/ DEPT PROJECT DESCRIPTION FY 2022 FY 2023 FY 2024 FY 2025 FY 2026 TOTAL PAGE WATER&RESOURCE RECOVERY CENTER Business Type Final Clarifier Rehabilitation $ — $ — $ — $ 860,000 $ — $ 860,000 139 Lift Station SCADA Upgrades $ 50,000 $ 50,000 $ 50,000 $ — $ — $ 150,000 140 Activated Sludge Process Improvements $ — $ — $ 70,000 $ 98,000 $ 1,092,000 $ 1,260,000 141 High-Strength Waste Receiving& Storage $1,632,346 $ — $ — $ — $ — $ 1,632,346 142 Sidestream Nitrogen Removal $ — $ — $ — $ — $ 400,000 $ 400,000 143 Sidestream Phosphorous Removal $ — $ — $ — $ — $ 300,000 $ 300,000 144 Sludge Blanket Level Detector Replacement $ 25,000 $ — $ — $ — $ — $ 25,000 145 Catfish Lift Station Pump Replacement $ 60,000 $ — $ — $ — $ — $ 60,000 146 Kerper Court Lift Station Spare Pump $ 40,000 $ — $ — $ — $ — $ 40,000 147 Laboratory HVAC Replacement $ 15,000 $ — $ — $ — $ — $ 15,000 148 TOTAL $1,822,346 $ 50,000 $ 120,000 $ 958,000 $ 1,792,000 $ 4,742,346 -50- WATER & RESOURCE RECOVERY CENTER FISCAL YEAR 2022 BUDGET PRESENTATION MISSION STATEMENT Water & Resource Recovery Center To operate and maintain the Center, in partnership with employees, as we safeguard public health and water quality,meet or exceed all State and Federal environmental regulations, recover valuable water, energy, and nutrients, all in a cost-effective manner, while delivering a great customer experience. New Faces Welcome! Ryan Cleary joined our team in FY21 as our Environmental Coordinator Insert Image Here Insert Image Here Thank You! Insert Image Here Insert Image Here Ryan Cleary, Cheryl Pregler, Devin Sweeney, Eric Kremer, Adam Leeser, Ken Offerman, Larry Hoppman, Jud Licht, Christian Bradley, Daryl Wickre, Andy Petitgout, Wayne Polsean Department Manager Water & Resource Recovery Center (15.00 Full-Time Equivalents) Operations Supervisor (vacant) Maintenance Supervisor Laboratory Supervisor (vacant) Certified Plant Operators (4) Laboratory Technicians (2) Confidential Account Clerk Environmental Coordinator 2 Equipment Mechanics Industrial Electronics Technician FISCAL YEAR 2021 HIGHLIGHTS •Renewable Natural Gas Project •Microturbine Conversion Renewable Fuel Standard Renewable Natural Gas Markets •RE100 •California LCFS •Oregon LCFS •Consumer-driven/Voluntary RNG Markets W&RRC INITIATIVES •Nutrient Trading •High-Strength Waste •Renewable Energy •New Staffing Model FY 22 PROPOSED RATE INCREASE -SANITARY SEWER 3.00% Proposed Rate Increase over FY 21 $1.27 Monthly Bill Impact for Average Household* *Average Household = 6,000 Gallons/Month Reduction of Monthly Utility Fees •Water •Sanitary Sewer •Refuse Collection •Stormwater https://www.cityofdubuque.org/463/Utility-Billing Utility Billing: 589-4144 FY 22 RATE COMPARISON (Proposed) Rank City Rate 11 Ankeny (FY21)$61.66 10 Davenport $52.48 9 Des Moines $52.04 8 Dubuque $43.43 7 West Des Moines $41.87 6 Sioux City $40.02 5 Iowa City $36.08 4 Ames $35.26 3 Waterloo $31.64 2 Cedar Rapids (FY21)$30.95 1 Council Bluffs $28.80 Average w/o Dubuque $41.08 PROGRAMS & SERVICES •Collection, Conveyance,and Treatment of Wastewater •Acceptance of Hauled Wastes •State-Certified Environmental Laboratory •Industrial Pretreatment Program •Fats, Oils, and Grease Program Service Area ~30 mile radius surrounding Dubuque WASTEWATER TREATMENT •W&RRC utilizes physical, chemical, and biological processes in the treatment of wastewater. •7 million gallons of wastewater per day. •Pollutant load is reduced by up to 98%. W&RRC DESIGN CAPACITY •9.14 Million Gallons/Day (Dry Weather Flow) ◦Current: ≈ 7 Million Gallons/Day (77%) •36,900 lbs./day Biochemical Oxygen Demand (design average) ◦Current: ≈ 22,000 lbs./Day (60%) •29,400 lbs./day Total Suspended Solids (design average) ◦Current: ≈ 20,000 lbs./Day (68%) RESOURCE RECOVERY •Effluent •Biosolids •Biogas ◦Renewable Natural Gas ◦Microturbines ◦Heat ◦Power ELECTRICITY USE/PRODUCTION •W&RRC •Lift Stations ENVIRONMENTAL LABORATORY •Serves: ◦W&RRC ◦Water Department ◦Public Works ◦Engineering ◦Health Department ◦Public W&RRC COMPLIANCE + REQUIREMENTS •Consent Decree -Eliminate Sanitary Sewer Overflows •Nutrient Reduction Requirements ◦Achieve 66% nitrogen reduction ◦Achieve 75% phosphorus reduction ◦Nutrient Reduction Study due January 1, 2022 FATS, OILS & GREASE •SSOs •Health Issue •Maintenance Issue FY2022 RECOMMENDED IMPROVEMENT REQUEST 1.Arc Flash Risk Assessment -17 Lift Stations + W&RRC a.Phase I: Data Collection b.Phase II: Engineering Analysis c.Phase III: Labels, Label Deployment, Training Recurring (every 5th year)| $71,500 Project FY22 Cost Total Project Cost Laboratory HVAC Replacement $15,000 $15,000 Sludge Blanket Level Detector $25,000 $25,000 Kerper Court Lift Station Spare Pump $40,000 $40,000 Catfish Lift Station Spare Pump $60,000 $60,000 Lift Station SCADA Upgrades $50,000 $200,000 High-Strength Waste Receiving/Storage $1,632,346 $1,632,346 FY 22 CAPITAL IMPROVEMENT PROJECTS Water Resource & Recovery Center PERFORMANCE MEASURES WATER & RESOURCE RECOVERY CENTER Goal: Remove 85% of biochemical oxygen demand and total suspended solids 97.3% removal of Total Suspended Solids in Calendar 2020 98% removal of Biochemical Oxygen Demand in Calendar 2020 THANK YOU www.cityofdubuque.org/WRRC Group Tours of Water & Resource Recovery Center Available by Appointment