Loading...
Water & Resource Recovery Center FY21 BudgetCopyrighted April 16, 2020 City of Dubuque Public Hearings # 2. ITEM TITLE: Water & Resource Recovery Center FY21 Budget Presentation SUMMARY: SUGGESTED DISPOSITION: ATTACHMENTS: Description Type Water & Resource Recovery Center FY21 Policy Supporting Documentation Budget Outline Presentation Supporting Documentation Water & Resource Recovery Center This page intentionally left blank. -32- WATER & RESOURCE RECOVERY CENTER DEPARTMENT FY 2019 FY 2020 FY 2021 % Change From Budget Highlights Actual Budget Requested FY 2020 Budget Expenses Employee Expense 1,434,346 1,448,236 1,469,123 1.4 % Supplies and Services 3,040,849 2,963,561 3,272,671 10.4 % Payment to Construction Fund 845,000 458,758 900,000 96.2 % Machinery and Equipment 19,439 128,275 28,380 (77.9)% Engineering - Sewer Administration 159,611 280,899 251,566 (10.4)% Public Works Sewer Maintenance Charges 807,281 758,438 668,693 (11.8)% Administrative Overhead Recharge 1,376,688 1,444,114 1,539,391 6.6 % Payment in Lieu of Taxes 142,884 142,884 142,884 — Debt Service 5,233,483 5,229,832 5,336,494 2.0 % Total Expenses 13,059,581 12,854,997 13,609,202 5.9 % Resources Operating Revenue 12,880,086 12,905,459 13,809,029 7.0 Total Resources 12,880,086 12,905,459 13,809,029 7.0 % Net Operating Surplus (Deficit) Personnel -Authorized FTE Sanitary User Fee Rate Increase Revenue 1% Rate Increase Generates (179,495) 50,462 199,827 15.00 15.00 15.00 3.00% 4.50% 5.00% $ 104,326 149,365 Improvement Package Summary 1 of 2 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. Related Cost: $71,500 Sanitary User Fee Sanitary User Fee Impact 0.71% Activity: Plant Operations Non -Recurring Recommend - Yes 2 of 2 This improvement request is for four tablets with data service and one smartphone with voice and data service. The improvement will supply two Equipment Mechanics with one tablet each, one tablet for Operations staff, and one tablet and one smartphone for the Maintenance Supervisor. This will improve efficiency and connectivity by allowing staff to directly input work order details into the asset management system. Staff will also use equipment to research and source parts, communicate with staff and vendors. The improvement supports a data driven asset and facility management system. -33- Related Cost: $4,060 Sanitary User Fee Non -Recurring Recommend - Yes Related Cost: $1,824 Sanitary User Fee Recurring Total Cost: $5,884 Sanitary User Fee Impact 0.06% Activity: Plant Operations Significant Line Items Employee Expense 1. FY 2021 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 2020 The employee contribution of 6.29% is unchanged from FY 2020. 3. The City portion of health insurance expense is increased from $921 in FY 2020 to $1,013 in FY 2021 per month per contract which results in an annual cost increase of $21,900 or 11.26%. 4. Overtime is unchanged from $59,350 in FY 2020 to $59,350 in FY 2021. FY 2019 actual was $96,032. 5. Five -Year Retiree Sick leave payout increased from $11,225 in FY 2020 to $15,211 in FY 2021. 6. 50% Sick Leave Payout increased from $0 in FY 2020 to $3,740 in FY 2021 based on FY 2020 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 decreased from $79,951 in FY 2020 to $74,466 in FY 2021 based on FY 2019 actual plus 5%. 8. Sales Tax increased from $324,762 in FY 2020 to $345,618 in FY 2021 based on increased consumption. This expense is directly offset by sales tax revenue. 9. Electricity Utility Expense increased from $424,777 in FY 2020 to $579,001 in FY 2021 based on FY 2019 actual $536,112 of plus 8%. Electrical expense for the W&RRC plant in FY 2021 is $270,181, which includes decreased microturbine output and $66,957 for the estimated BioResoure Development electrical usage which will be reimbursed on a monthly basis. The lift station electrical expense in FY 2021 is estimated to be $241,863.. 10. Gas Utility Expense increased from $87,710 in FY 2020 to $109,180 in FY 2021 based on FY 2019 actual. 11. Property Maintenance increased from $66,350 in FY 2020 to $66,831 in FY 2021 based on FY 2019 actual. 12. Machinery and Equipment Maintenance increased from $309,625 in FY 2020 to $317,935 in FY 2021. FY 2019 actual was $333,007. This results from increasing digester cleaning (+$40,000) based on FY 2020 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 -34- a cost savings in this line item of $50,000 due to the purchase of a pump trailer through an FY20 CIP. This line item represents samplers and lab equipment maintenance ($3,174), 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 $77,293 in FY 2020 to $76,490 in FY 2021 based on FY 2019 actual of $72,867 plus 5%. 14. Lift Station Maintenance decreased from $138,155 in FY 2020 to $124,595 in FY 2021 based on a three year average. FY 2019 actual was $112,200. 15. Polymer Expense increased from $226,100 in FY 2020 to $237,073 in FY 2021 based on FY 2019 actual of $249,550 and adjusted for lower bid results in FY 2020. 16. Liquid Oxygen increased from $427,536 in FY 2020 to $467,041 in FY 2021. The FY 2021 budget includes $28,362 for tank rental and $438,679 for oxygen based on the expected loading and an 11.8% increase in bulk oxygen implemented in FY 2020. FY 2019 actual was $420,741. 17. Hauling Service increased from $274,300 in FY 2020 to $304,900 in FY 2021. The increase is due to increased hauling due to digester cleanout and increased sludge production. This line item also contains bio-solids management fixed costs and hauling of drying pad material. Machinery & Equipment 18. Equipment replacement items include ($28,380): Administration Smart Phone $ 210 Plant Operations Shop Equipment $ 10,000 Cell Phones $ 2,980 Environmental Monitoring Laboratory Equipment $ 10,800 Smart Phone $ 210 Fats, Oil, Grease Test Equipment $ 500 Recommended Improvement Packages $ 3,680 Total Equipment $ 28,380 -35- Debt Service 19. Annual debt service payments for FY 2021 are as follows ($5,336,494): Amount Debt Series Source Purpose Final Call Payment Date $ 61,050 G.O. 2017A Sanitary Fees Sanitary Sewer Improvements 2030 2025 $ 94,990 G.O.2018A Sanitary Fees Sanitary Sewer Improvements 2031 2026 $ 44,086 G.O. 2012E Sanitary Fees Sanitary Forcemain Repairs 2032 2019 $ 122,676 G.O.2019C Sanitary Fees Sanitary Sewer Improvements 2033 2026 $ 441,675 G.O. 2014B Sanitary Fees Sanitary Sewer Improvements $ 163,206 G.O. 2016C Sanitary Fees Sanitary Sewer Improvements $ 63,192 SRF 2006 Sanitary Fees Northfork Catfish Creek 2034 2021 2035 2024 2031 $ 218,708 SRF 2009 Sanitary Fees Meter Change -Out 2031 $ 3,697,220 SRF 2010 Sanitary Fees W&RRC Plant Upgrade 2039 $ 186,320 SRF 2013 Sanitary Fees W&RRC Cogeneration 2033 $ 168,660 SRF 2018 Sanitary Fees Kerper Boulevard Sanitary 2038 $ 24,873 Planned Sanitary Fees Sanitary Projects 2040 $ 49,838 Planned Sanitary Fees Sanitary Projects $ 5,336,494 Total Sanitary Annual Debt Service Revenue 2041 20. Sewage Fees increased from $10,116,942 in FY 2020 to $10,954,278 in FY 2021 based on a 5.00% rate increase in FY 2021 and a 1 % decrease in consumption in FY 2020. 21. Sewage dumping fees decreased from $130,148 in FY 2020 to $120,634 in FY 2021 based on FY 2019 actual of $120,634. 22. Late Payment Penalties decreased from $126,353 in FY 2020 to $118,344 in FY 2021. The decrease is due to Rousselot installing a system improving industrial pre-treatment compliance. 23. The Water and Resource Recovery Center's pre-treatment largest industrial customers projected changes in revenues as follows: • Prairie Farms increased from $424,132 in FY 2020 to $494,324 in FY 2021 based on FY 2020 year-to-date revenue plus 4%. • Inland Protein decreased from $191,967 in FY 2020 to $163,518 in FY 2021 based on FY 2020 year-to-date revenue tracking lower ($13,102 per month) plus 4%. • Rousselot is increased from $882,331 in FY 2020 to $1,021,890 in FY 2021 based on FY 2020 year-to-date revenue tracking higher ($81,882 per month) plus 4%. 24. High Strength Waste revenue decreased from $189,644 in FY 2020 to $171,999 in FY 2021 based on FY 2019 actual of $171,999. 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 $221,609 in FY 2020 to $158,686 in FY 2021 . This line item represents 5% of the gross revenue for BioResource Development ($12,000), lease of the site ($10,000), staff time reimbursement ($3,000), reimbursement of gas ($51,023) and electric cost ($82,663). -36- 26. Fats, Oils and Grease Permit and Dumping fees decreased from $24,614 in FY 2020 to $23,996 in FY 2021 based on FY 2019 actual of $23,996. -37- This page intentionally left blank. -38- 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. Administration Water & Resource Recovery Center Operations and Maintenance Evniranmental 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. r.. 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, (J EPA, Local Industries and local/regional/service providers_ -39- WATER & RESOURCE RECOVERY CENTER $13,000,000 $12, 000,000 $11,000,000 $10, 000,000 FY 2019 FY 2020 FY 2021 Full -Time Equivalent 15.00 15.00 15.00 $12,880,086 Resources or $12,905,459 Operating Revenue $13,809,029 FY 2019 • FY 2020 FY 2021 The Water Resource Recovery Center is supported by 15.00 full-time equivalent employees, which accounts for 25.91 % of the department expense as seen below. Overall, the department's expenses are expected to increase by 5% in FY 2021 compared to FY 2020. Expenditures and Debt by Fiscal Year Employee Expense Supplies and services Construction Fund Equipment Fngineer'ng OI-/ Public works DN Au%) overhead Debt service $845,000 $458,758 $900,000 $19,439 ■ $128,275 $28,380 $159,611 $280,899 $251,566 $807,281 I $758,438 $668,693 $1,434,346 $1,448,236 $1,469,123 $3,040,849 $2,963,561 $3,272,671 $1,376,688 $1,444,114 $1,539,391 $5,233,483 $5,229,832 $5,336,494 $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 FY 2019 FY 2020 FY 2021 -40- 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 2019 Actual FY 2020 Budget FY 2021 Requested Expenditures $9,175,924 $9,289,084 $9,632,726 Resources $12,665,967 $12,738,062 _ $13,660,476 Operations and Maintenance Position Summary FY 2021 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 CONFIDENTIAL ACCOUNT CLERK 1.00 Total FT Equivalent Employees 11.00 Performance Measures City Council Goal: Sustainableknvironment 7 Performance Measure (KPI) Target FY18 FY19 FY20 Performance Actual Actual Estimate 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 per day (in millions) 7 7.13 9.17 9.30 # of pumping station failures/outage incidents 0 4 4 3 # 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 energy needs self -produced by the W&RRC 68.3 51.8 33.7 36.4 -41- 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 2019 Actual FY 2020 Budget FY 2021 Requested Expenditures $443,802 $462,900 $457,918 Resources $188,001 _ $158.258 _ $142,147 Environmental Monitoring Position Summary FY 2021 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 1 Performance Measure (KPI) Target FY18 FY19 FY20 Performance Actual Actual Estimate 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 -42- Recommended Operating Revenue Budget - Department Total 43 - WATER & RESOURCE RECOVERY Fund Account Account Title FY18 Actual Revenue FY19 Actual Revenue FY20 Adopted Budget FY21 Recomm'd Budget 610 42230 610 42237 FOG PERMITS 610 42331 FOG INSPECTION FEE 42 LICENSES AND PERMITS -otal 610 43110 INVESTMENT EARNINGS 43 USE OF MONEY AND PROPERTY - Total 610 51185 610 51205 610 51215 610 51216 610 51218 610 51220 610 51225 610 51227 610 51230 610 51231 610 51235 610 51240 610 51256 610 51257 610 51258 610 51259 610 51260 610 51261 610 51690 610 51964 CHARGES FOR SERVICES - Total 610 53102 PRIVATE PARTICIPANT 610 53201 REFUNDS 610 53204 IOWA FUEL TAX REFUND 610 53520 WATER SAMPLING -PLANT 610 53523 WWT SAMPLING -OUTSIDE 610 53620 REIMBURSEMENTS -GENERAL 610 53630 SALES TAX COLLECTION SEWAGE DISPOSAL PERMITS WATER TESTS -OUTSIDE SEWAGE FEES LATE PAYMENT PENALTY FOG PENALTIES ARTCO FLEETING SWISS VALLEY FARMS INLAND PROTEIN HIGH STRENGTH WASTE SEWAGE DUMPING FEES FOG DUMPING FEES WW IND. PRETREATMENT SAN ROUESSLOT BRD LEASE BRD STAFF REIMBURSEMENT BRD GAS REIMBURSEMENT BRD ELECTRIC REIMB BRD GROSS REVENUE BRD MEDIA CHANGE REIMB LANDFILL PAYMENT -LAB TEST ARENA NOVELT 1,485 38,850 0 250 36,290 40,585 IMI 36,290 60,573 51,786 54,515 60,573 51,78 54 515 36,754 40,293 36,754 10,100,349 10,116,942 10,954,278 163,649 126,353 118,344 200 2,750 200 969 1,318 969 475,312 424,132 494,324 182,967 191,967 163,518 171,999 189,644 171,999 120,634 130,148 120,634 23,996 24,614 23,996 36,634 35,990 36,634 871,432 882,331 1,021,890 0 10,000 10,000 10,000 0 0 56,000 3,000 0 54,329 12,000 51,023 0 82,663 79,766 82,663 0 20,643 63,843 12,000 0 0 25,000 0 1,177 1,731 1,177 1,731 415 460 415 460 12,273,386 12,354,720 12,414,683 13,304,417 50 0 50 0 0 181 0 0 695 0 695 0 37,344 34,731 37,344 37,344 24,870 27,852 24,870 24,870 1,375 9 1,375 0 324,422 327,526 324,762 345,017 1,485 38,850 250 40,581 44,481 44 481 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 865 35,425 865 35,425 0 53 MISCELLANEOUS 389,096 610 54109 SALVAGE SALES 170 260 170 170 610 54210 GO BOND PROCEEDS 1,030,001 11,312 0 0 610 54220 BOND DISCOUNT 15,018 512 0 0 MERTHER FINANCING SOURCES - Total 1,045,189 12,0 WATER & RESOURCE RECOVERY - Total I 13,792,396 I 12,853,967 12,896,320 13,802,623 -43- Recommended Operating Expenditure Budget - Department Total 43 - WATER & RESOURCE RECOVERY Fund Account Account Title FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY 21 Recomm'd Budget 100 61010 FULL-TIME EMPLOYEES 610 61010 FULL-TIME EMPLOYEES 640 61010 FULL-TIME EMPLOYEES 610 61020 PART-TIME EMPLOYEES 610 61030 SEASONAL EMPLOYEES 100 61050 OVERTIME PAY 610 61050 OVERTIME PAY 640 61050 OVERTIME PAY 610 61071 HOLIDAY PAY -OVERTIME 640 61071 HOLIDAY PAY -OVERTIME 610 61091 SICK LEAVE PAYOFF 610 61092 VACATION PAYOFF 610 61096 50% SICK LEAVE PAYOUT 100 61310 IPERS 610 61310 IPERS 640 61310 IPERS 100 61320 SOCIAL SECURITY 610 61320 SOCIAL SECURITY 640 61320 SOCIAL SECURITY 100 61410 HEALTH INSURANCE 610 61410 HEALTH INSURANCE 640 61410 HEALTH INSURANCE 610 61415 WORKMENS' COMPENSATION 100 61416 LIFE INSURANCE 610 61416 LIFE INSURANCE 640 61416 LIFE INSURANCE 610 61640 SAFETY EQUIPMENT 610 61650 MEAL ALLOWANCE 610 61660 EMPLOYEE PHYSICALS 0 4,049 0 964,031 863,911 990,095 809 0 0 638 174 0 4,473 8,600 0 42 1,571 0 52,124 94,461 59,350 59,350 230 0 0 0 24,601 24,471 17,221 17,221 355 0 0 0 14,843 10,770 11,225 15,211 0 2,704 0 0 0 0 0 3,740 4 530 0 0 93,513 93,609 100,694 99,827 124 0 0 0 3 409 0 0 76,654 73,129 82,458 82,210 101 0 0 0 12 1,139 0 0 254,095 213,504 162,540 184,440 293 0 0 0 38,766 29,293 23,810 24,987 0 3 0 0 752 650 843 843 1 0 0 0 6,837 10,968 0 250 0 18 0 0 42 384 0 130 0 980,914 0 0 0 0 L 61 - WAGES AND BENEFITS 1,533,344 1,434,346 1,448,236 1,469,123 610 62010 OFFICE SUPPLIES 2,298 (451) 2,194 2,238 610 62011 UNIFORM PURCHASES 2,425 1,637 2,500 2,500 610 62030 POSTAGE AND SHIPPING 3,492 1,946 3,597 2,710 610 62032 FLAGS 90 0 135 135 610 62061 DP EQUIP. MAINT CONTRACTS 8,898 8,610 8,808 9,542 610 62062 JANITORIAL SUPPLIES 1,470 1,588 1,724 1,619 610 62065 LAB SUPPLIES 40,082 32,886 40,082 37,825 610 62090 PRINTING & BINDING 1,725 1,412 4,541 2,762 610 62110 COPYING/REPRODUCTION 321 376 336 376 610 62130 LEGAL NOTICES & ADS 3,575 925 100 647 610 62140 PROMOTION 0 0 600 450 610 62170 SUBSCRIPTIONS -BOOKS -MAPS 0 0 300 300 610 62190 DUES & MEMBERSHIPS 409 770 885 882 610 62204 REFUNDS 11,065 95,767 11,065 11,065 610 62206 PROPERTY INSURANCE 73,943 70,920 79,951 74,466 610 62208 GENERAL LIABILITY INSURAN 13,763 10,940 10,684 11,487 610 62210 SALES TAX 325,418 324,224 324,762 345,618 610 62310 TRAVEL -CONFERENCES 1,975 3,469 3,450 3,700 -44- Recommended Operating Expenditure Budget - Department Total 43 - WATER & RESOURCE RECOVERY Fund Account Account Title FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY 21 Recomm'd Budget 610 62320 610 62360 610 62411 610 62412 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 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 62712 610 62713 610 62716 610 62721 610 62726 610 62731 610 62732 610 62733 610 62736 610 62763 610 62767 TRAVEL -CITY BUSINESS EDUCATION & TRAINING UTILITY EXP-ELECTRICITY UTILITY EXP-GAS 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 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 CONSULTING ENGINEERS LEGAL SERVICES CONSULTANT SERVICES FINANCIAL CONSULTANT AUDIT SERVICES MISCELLANEOUS SERVICES TEMP HELPCONTRACT SERV. CONTRACT CUSTODIAL CATERING SERVICES PAYMENT TO IOWA DNR ENVIRON. TESTING/MON. 159 33 390 435 8,893 6,339 11,330 9,250 384,033 536,112 424,777 579,001 87,710 109,180 87,710 109,180 11,606 13,450 13,181 15,340 39,101 46,624 42,034 50,936 7,184 8,042 7,173 8,666 2,758 2,006 2,869 2,106 69,433 66,831 66,350 66,831 2,845 2,505 2,845 2,400 480 440 480 480 0 0 5,770 0 10,285 7,642 10,285 10,563 389 3,753 389 4,000 7,260 8,354 7,405 8,521 100 1,784 1,742 1,742 195,639 333,007 309,625 317,935 0 0 75,000 50,000 5,500 5,500 0 5,500 78,527 72,867 77,293 76,490 100 0 0 0 33,924 0 34,942 34,942 113,091 112,200 138,155 124,595 0 1,092 13,000 13,000 3,798 538 22,500 22,500 0 0 960 0 13,892 7,609 11,000 8,000 227,424 249,550 226,100 237,073 434,495 420,741 427,536 467,041 14,546 40,981 9,541 10,568 0 424 600 600 395 496 480 1,721 0 0 12,253 0 120 293 0 293 4,577 6,977 4,577 6,977 10,281 38,699 51,531 51,531 6,962 4,049 6,961 4,049 19,088 17,565 0 0 7,242 1,080 5,752 0 8,727 28,370 12,500 85,949 7,043 0 1,177 0 2,200 2,400 2,200 2,400 10,152 5,461 0 0 0 0 20,000 20,000 12,838 13,931 17,700 17,700 82 0 300 300 2,839 7,404 2,134 5,834 24,967 27,028 25,000 25,000 -45- Recommended Operating Expenditure Budget - Department Total 43 - WATER & RESOURCE RECOVERY Fund Account Account Title FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY 21 Recomm'd Budget 610 62780 HAULING SERVICES 265,376 274,473 274,300 304,900 62 - SUPPLIES AND SERVICES 2,627,010 3,040,849 2,963,561 3,272,671 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 801 85 0 0 0 50,500 0 0 27,500 133 1,827 14,519 10,000 7,296 17,192 11,900 10,800 0 0 5,000 0 0 0 14,950 0 0 0 3,500 0 0 143 0 0 291 168 406 3,400 1,956 24 0 500 3,680 0 0 71 - EQUIPMENT 10,477 19,439 128,275 28,380 610 74111 PRINCIPAL PAYMENT 4,301,389 3,473,317 3,511,282 3,651,034 610 74112 INTEREST PAYMENT 1,829,757 1,760,167 1,718,550 1,685,460 74 - DEBT SERVICE 6,131,146 5,233,483 5,229,832 5,336,494 610 91100 TO GENERAL 1,550,277 1,519,572 1,586,998 1,682,275 610 91710 TO SANITARY SEWER CONST 181,114 845,000 458,758 900,000 91 - TRANSFER TO 1,731,391 2,364,572 2,045,756 2,582,275 43 - WATER & RESOURCE RECOVERY TOTAL 12,033,368 12,092,689 11,815,660 12,688,943 -46- Recommended Expenditure Budget Report by Activity & Funding Source 43 - WATER & RESOURCE RECOVERY UNDISTRIBUTED - 10610 FUNDING SOURCE: SEWAGE FACILITY OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget SUPPLIES AND SERVICES 100,690 TRANSFER TO 2,364,572 17,920 2,045,756 16,024 2,582,275 IIIM- UNDISTRIBUTED 2,465,262 2,063,676 2,598,299 WPC ADMINISTRATION - 43100 FUNDING SOURCE: SEWAGE FACILITY OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget DEBT SERVICE EQUIPMENT SUPPLIES AND SERVICES WAGES AND BENEFITS 5,233,483 5,229,832 5,336,494 346 210 360,967 381,272 400,560 151,112 148,217 150,187 I6WRRP ADMINISTRATION 5,745,562 FLOODWALL OPER./MAINT. - 43340 5,759,667 1111 5,887,451 FUNDING SOURCE: GENERAL Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget WAGES AND BENEFITS 7,701 FLOODWALL OPER./MAINT. 7,701 WPC PLANT OPERATIONS - 43400 FUNDING SOURCE: SEWAGE FACILITY OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget EQUIPMENT 2,223 116,029 16,660 SUPPLIES AND SERVICES 2,496,144 2,476,877 2,767,286 WAGES AND BENEFITS 899,373 903,060 927,622 WRR PLANT OPERATIONS 3,397,740 3,495,966 3,711,568 FATS OILS GREASE - 43500 FUNDING SOURCE: SEWAGE FACILITY OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget EQUIPMENT 24 0 500 SUPPLIES AND SERVICES 6,935 8,791 7,626 WAGES AND BENEFITS 25,664 24,660 25,581 FATS OILS GREASE 32,622 ENVIRON-MONITORING - 43700 33,451 FUNDING SOURCE: SEWAGE FACILITY OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget -47- EQUIPMENT 17,192 11,900 11,010 SUPPLIES AND SERVICES 76,113 78,701 81,175 WAGES AND BENEFITS 350,497 372,299 365,733 w ENVIRON-MONITORING 443,802 462,900 WATER MAIN REPLACEMENTS - 43755 FUNDING SOURCE: WATER UTILITY OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget WAGES AND BENEFITS 0 0 0 WATER MAIN REPLACEMENTS 0 0 0 WATER & RESOURCE RECOVERY TOTAL $12,092,689 $11,815,660 $12,688,943 -48- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 43 WATER AND RESOURCE RECOVERY CENTER FD JC WP-GR JOB CLASS 61010 Full Time Employee Expense 610 5080 GE-40 610 3030 GE-34 610 GE-33 610 GE-33 610 GE-31 610 2100 GE-31 610 GE-25 610 2400 0E-14 610 2800 0E-14 610 0E-14 610 0E-13 610 2500 0E-12 WRRC MANAGER MAINTENANCE SUPERVISOR WWT WRRC OPERATIONS SUPERVISOR LAB SUPERVISOR ENVIRONMENTAL COORDINATOR LAB TECHNICIAN II CONFIDENTIAL ACCOUNT CLERK EQUIPMENT MECHANIC - WWT MAINTENANCE ELECTRICIAN WRRC OPERATOR CERT GR IV WRRC OPERATOR CERT GR III WRRC OPERATOR CERT GR II TOTAL FULL TIME EMPLOYEES FY 2019 FY 2020 FY 2021 FTE BUDGET FTE BUDGET FTE BUDGET 1.00 1.00 1.00 1.00 1.00 2.00 1.00 2.00 1.00 1.00 1.00 2.00 15.00 $ 99,913 $ 80,590 $ 66,218 $ 76,418 $ 60,860 $ 123,350 $ 48,373 $ 119,494 $ 58,864 $ 55,910 $ 56,563 $ 115,175 $ 961,728 1.00 1.00 1.00 1.00 1.00 2.00 1.00 2.00 1.00 1.00 1.00 2.00 15.00 $ 108,576 $ 82,420 $ 67,792 $ 78,150 $ 65,706 $ 121,973 $ 49,535 $ 122,200 $ 62,125 $ 63,243 $ 59,102 $ 109,273 $ 990,095 1.00 1.00 1.00 1.00 1.00 2.00 1.00 2.00 1.00 1.00 1.00 2.00 15.00 $ 111,599 $ 83,333 $ 69,426 $ 67,589 $ 53,134 $ 126,360 $ 50,518 $ 123,556 $ 60,753 $ 64,063 $ 60,103 $ 110,480 $ 980,914 TOTAL WATER & RESOURCE RECOVERY CENTER 15.00 $ 961,728 15.00 $ 990,095 15.00 $ 980,914 -49- CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY ACCT FD JC WP-GR POSITION CLASS Water & Resource Recovery Center Administration 61043100 61010 610 3300 GE-40 WRRC MANAGER Total Water & Resource Recovery Center Plant Operation MAINTENANCE SUPERVISOR 61043400 61010 610 3030 GE-34 WWT 61043400 61010 610 GE-33 61043400 61010 610 2400 OE-14 61043400 61010 610 1000 GE-25 61043400 61010 610 3942 OE-13 61043400 61010 610 2500 OE-12 61043400 61010 610 2800 OE-14 Environmental Monitoring Lab -FT 61043700 61010 610 GE-33 61043700 61010 610 2100 GE-31 WR_R_C_OPERATIONS EQUIPMENT MECHANIC - W&RRC CONFIDENTIAL ACCOUNT CERK W&RRC OPERATOR GR III/IV W&RRC OPERATOR GR II MAINTENANCE ELECTRICIAN Total LAB SUPERVISOR LAB TECHNICIAN II ENVIRONMENTAL 61043700 61010 610 2228 GE-31 COORDINATOR Total Fat Oils and Grease -FT CONFIDENTIAL ACCOUNT 61043500 61010 610 1000 GE-25 CLERK FY 2019 FTE BUDGET FY 2020 FY 2021 FTE BUDGET FTE BUDGET 1.00 $ 99,913 1.00 $ 108,576 1.00 $ 111,599 1.00 $ 99,913 1.00 $ 108,576 1.00 $ 111,599 1.00 $ 80,590 1.00 $ 82,420 1.00 $ 83,333 1.00 $ 66,218 1.00 $ 67,792 1.00 $ 69,426 2.00 $ 119,494 2.00 $ 122,200 2.00 $ 123,556 0.65 $ 31,443 0.65 $ 32,198 0.65 $ 32,837 2.00 $ 112,473 2.00 $ 122,345 2.00 $ 124,166 2.00 $ 115,175 2.00 $ 109,273 2.00 $ 110,480 1.00 $ 58,864 1.00 $ 62,125 1.00 $ 60,753 9.65 $ 584,257 9.65 $ 598,353 9.65 $ 604,551 1.00 $ 76,418 1.00 $ 78,150 1.00 $ 67,589 2.00 $ 123,350 2.00 $ 121,973 2.00 $ 126,360 1.00 $ 60,860 1.00 $ 65,706 1.00 $ 53,134 4.00 $ 260,628 4.00 $ 265,829 4.00 $ 247,083 0.35 $ 16,930 0.35 $ 17,337 0.35 $ 17,681 0.35 $ 16,930 0.35 $ 17,337 0.35 $ 17,681 TOTAL WATER & RESOURCE RECOVERY DEPARTMENT 15.00 $ 961,728 15.00 $ 990,095 15.00 $ 980,914 -50- Capital Improvement Projects by Department/Division WATER & RESOURCE RECOVERY CIP Number Capital Improvement Project Title FY 18 Actual FY 19 Actual FY 20 Adopted FY 21 Recomm'd Expense Expense Budget Budget 7101339 SCADA SYSTEM UPGRADE 50,000 50,000 7101730 ALT 02 STUDY & IMPLEMENTA 7101731 DOG TRACK LIFT STATION 10,608 7101837 WRR PLANT RENOVATION 7102412 CEDAR LIFT PUMP/GEN/TRAIL 55,000 7102474 BRADLEY/PERRY FORCE MAIN 7102529 NUTRIENT REDUCT STRATEGY 7102530 OUTFALL MANHOLE 7102538 AIRPORT LS UPGRADES 13,906 7102598 CLARIFIER REALIGN/REPAIR 19,325 130,000 7102599 KERPER PUMP MOTOR/CONTROL 7102601 REPLACEMENT OF RADIOS 7102659 NUTRIENT RED/BASIN MOD 1 7102697 ASH POND ABANDONMENT 116,589 7102698 METHANE GAS SYSTEM WRRC 49,930 6,673 7102700 LEVEL 4 AGREEMENT 19,569 519 7102701 HS WASTE RECEIVE & STORE 7102730 FRACK TANK 10,468 7102749 KW CAR WASH LIFT STATION — 7102750 GRANGER CREEK LIFT STATIO 7,142 7102787 WRRC CAMERAS 45,900 7102840 PUMP TRAILER WRRC 110,000 7102841 UV DISINFECTION WRRC 235,000 WATER & RESOURCE RECOVERY TOTAL 215,881 -51- PRGRM /DEPT PROJECT DESCRIPTION FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 TOTAL PAGE WATER & RESOURCE RECOVERY CENTER Business Type Final Clarifier Rehabilitation $- $ 860,000 $- $- $- $ 860,000 127 Lift Station SCADA Upgrades $ 50,000 $ 50,000 $ 50,000 $ 50,000 $- $ 200,000 128 Activated Sludge Process Improvements $- $- $- $ 70,000 $ 98,000 $ 168,000 129 High -Strength Waste Receiving 1,057,97 & Storage $— $ 574,371 $ 5 $- $- $ 1,632,346 130 UV Disinfection System Modifications $ 235,000 $- $- $- $- $ 235,000 131 Pump Trailer $ 110,000 $- $- $- $- $ 110,000 132 TOTAL $ 395,000 $1,484,371 $1,107,975 $ 120,000 $ 98,000 $ 3,205,346 -52- FISCAL YEAR 2021 BUDGET PRESENTATION WATER & RESOURCE RECOVERY CENTER FY 21 Budget Request Changes Due to COVID-19 Pandemic • The following presentation represents Water's FY21 budget requests prior to the COVID-19 pandemic. • In light of the pandemic, the City Manager will present an amended FY21 Budget Recommendation on April 23, 2020: This recommendation will include no property tax increase for the average homeowner and no increase in the stormwater, sanitary sewer, water, and refuse fees. The amended recommendation will impact the following budget request and may reduce or delay funding for some projects Water Resource & Recovery Center MISSION STATEMENT To operate and maintain the Water & Resource Recovery 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. Retirements Congratulations! Nancy Knipper retired in December 2019 after 33 years with the City of Dubuque New Faces Welcome! Devin Sweeney joined the team in FY20 as our Industrial Electronics Technician New Faces Welcome! Justin Licht joined the team in FY20 as a Water & Resource Recovery Center Operator Water Resource & Recovery Center (15.00 Full -Time Equivalents) Environmental Coordinator 2 Equipment Mechanics Maintenance Supervisor Industrial Electronics Technician Department Manager Operations Supervisor (vacant) Certified Plant Operators (4) Laboratory Supervisor (vacant) Laboratory Technicians (2) Confidential Account Clerk FISCAL YEAR 2020 HIGHLIGHTS • Renewable Natural Gas (BioCNG) FISCAL YEAR 2020 HIGHLIGHTS • Memorandum of Understanding with Iowa Department of Natural Resources FUTURE INITIATIVES • Nutrient Trading • High -strength Waste Receiving & Storage • Renewable Energy 21 PROPOSEDRATEINCREA - SANITARY SEWER *Average Household = 6,000 Gallons/Month • 5.00% Proposed Rate Increase over FY 20 $2.11 Monthly Bill Impact for Average Household* FY2I RATE COMPARISON (Proposed) 11 Ankeny 10 Davenport $ 61.66 $ 60.33 9 Des Moines 8 Dubuque $ 50.66 $ 44.35 7 West Des Moines $ 40.88 6 Iowa City $ 36.65 5 Ames $ 36.17 4 Sioux City $ 35.26 3 Cedar Rapids $ 30.96 2 Waterloo $ 29.82 1 Council Bluffs $ 22.94 Average Dubuque $ 40.53 PROGRAMS & SERVICES • • • Conveyance and Treatment of Wastewater • Acceptance of hauled liquid wastes • State -certified Environmental Laboratory • Industrial Pretreatment Program • Fats, Oils, and Grease Program Upper Missi River Wii ppi nc ster ational ife and... Dyersville ello Platteville 0 -‘1"Pullegglit Dubuque O Galena 0 neral Poi 0 Service Area = 30 mile radius surrounding Dubuque WASTEWATER TREATMENT • W&RRC utilizes physical, chemical, and biological processes in the treatment of wastewater. • Facility processes an average of 7 million gallons of wastewater per day. • Conventional pollutant load is reduced by up to 98%. W&RRC DESIGN CAPACITY • 9.14 Million Gallons/Day (Dry Weather Flow) Current: z. 7 Million Gallons/Day (77%) • 36,900 I bs./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 Microturbines Renewable Natural Gas INCOMING WASTEWATER RESOURCE RECOVERY WATER, ENERGY, NUTRIENTS 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 • Addendum due January 1, 2022 Phosphorus Recovery Pilot Regulatory credit for watershed improvements FATS, OILS & GREASE • SSOs • Health Issue • Maintenance Issue FY2021 RECOMMENDED IMPROVEMENT REQUESTS 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 Non -Recurring I $71,500 2. Four Tablets (Equipment Mechanics [2], Operations Staff, Maintenance Supervisor) + 1 Smartphone (Maintenance Supervisor): Non -Recurring I $4,060 + Recurring I $1,824 Water Resource & Recovery Center FY 21 CAPITAL IMPROVEMENT PROJECTS Total Project Cost Lift Station SCADA Upgrades $ 50,000 $ UV Disinfection System Modifications $ 235,000 $ $ 110,000 $ Pump Trailer 200,000 235,000 110,000 WATER & RESOURCE RECOVERY CENTER PERFORMANCE MEASURES Goal: Remove 85% of biochemical oxygen demand and total suspended solids 93.9% removal of Total Suspended Solids in Calendar 2019 96.5% removal of Biochemical Oxygen Demand in Calendar 2019 Group Tours of Water & Resource Recovery Center Available by Appointment www.cityofdubuque.org/WRRC