Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Water & Resource Recovery Center FY19 Budget Presentation
Copyrighted February 26, 2018 City of Dubuque Public Hearings # 2. ITEM TITLE: Water& Resource Recovery Center FY2019 Budget Presentation SUMMARY: SUGGESTED DISPOSITION: ATTACHMENTS: Description Type FY19 W&RRC Budget Presentation Supporting Documentation Water & Resource Recovery Center 35- This page intentionally left blank. -36- WATER & RESOURCE RECOVERY CENTER DEPARTMENT FY 2017 FY 2018 FY 2019 % Change From Budget Highlights Actual Budget Requested FY 2018 Budget Expenses Employee Expense 1,583,015 1,553,942 1,433,073 (7.8)% Supplies and Services 2,765,294 2,830,054 2,912,704 2.9 % Payment to Construction Fund 1,736,000 181,114 845,000 366.6 % Machinery and Equipment 9,463 22,015 29,570 34.3 % Engineering - Sewer Administration 172,455 198,838 235,794 18.6 % Public Works Sewer Maintenance Charges 573,671 781,129 830,141 6.3 % Administrative Overhead Recharge 1,159,073 1,407,393 1,376,688 (2.2)% Payment in Lieu of Taxes 142,884 142,884 142,884 — % Debt Service 5,624,188 5,203,262 5,275,393 1.4 % Total Expenses 13,766,043 12,320,631 13,081,247 6.2 % Resources Operating Revenue 13,234,875 12,787,466 13,090,204 2.4 % Total Resources 13,234,875 12,787,466 13,090,204 2.4 % Net Operating Surplus (Deficit) (531,168) 466,835 8,957 (457,878) Personnel -Authorized FTE 17.16 17.00 14.50 Sanitary User Fee Rate Increase 3% 3% 3% Revenue 1% Rate Increase Generates $ 102,270 Improvement Package Summary 1 of 1 This improvement package would provide funding for a staffing transition which includes transitioning to one-shift operations with on-call status. The staffing transition includes the elimination of the Assistant Plant Manager position (-1.0 FTE or 2,080 hours annually), the elimination of the Maintenance Electrician position (-1.0 FTE or 2,080 hours annually), the elimination of one Plant Operator position beginning July 1, 2018 (-1.00 FTE or 2,080 hours annually), the elimination of a second Plant Operator Position beginning January 1, 2019 (-0.50 FTE or 1,040 hours annually), and the creation of an Operations Supervisor position at GE-33D (+1.0 FTE or 2,080 hours annually). The Assistant Plant Manager position is vacant and has been frozen since Fiscal Year 2018. The Maintenance Electrician and both Plant Operator positions are currently filled and funded positions in Fiscal Year 2018. Recurring funding also includes contracted electrician services ($42,000). Non-recurring funding is included for staff training and the development of Standard Operating Procedures needed for one-shift operations ($50,000). -37- A summary of the cost impact of the staffing transition plan is as follows: Cost Position Type FTE Change (Savings) Assistant Plant Manager Full-Time -1.00 Eliminated 711118 ($86,873) Maintenance Electrician Full-Time -1.00 Eliminated 7/1/18 ($83,281) Plant Operator Grade IV Full-Time -1.00 Eliminated 7/1/18 ($85,473) Plant Operator Grade II Full-Time -0.50 Eliminated 1/1/19 ($39,660) Operations Supervisor Full-Time +1.00 New 711118 +$91,893 Total Change -2.50 ($203,394) If the W&RRC staffing transition plan is not approved as recommended, the sanitary user fee would need to be increased an additional 1.09%. Related Cost: $133,893 Sanitary User Fee Recurring Recommend -Yes Related Cost Savings: ($295,287) Sanitary User Fee Recurring Related Cost: $50,000 Sanitary User Fee Non-Recurring Total Cost: ($111,394) Activity: Plant Operations Significant Line Items Employee Expense 1. FY 2019 employee expense reflects a 1.5% wage package increase. 2. The Iowa Public Employee Retirement System (IPERS) City contribution increased from 8.93% in FY 2018 to 9.44% in FY 2019. This resulted in an increase of City IPERS expense of$4,936 in Water & Resource Recovery Center. The employee contribution increased from 5.95% in FY 2018 to 6.29% in FY 2019. 3. The City portion of health insurance expense is decreased from $1,325 in FY 2018 to $1,193 in FY 2019 per month per contract which results in an annual cost savings of-$46,904 or -10.00%. 4. Overtime is unchanged from $59,350 in FY 2018 to $59,350 in FY 2019. FY 2017 actual was $55,670. 5. Sick leave payout is unchanged from $14,720 in FY 2018 to $14,720 in FY 2019. 6. The FY 2019 budget recommendation includes elimination of the Maintenance Electrician position (-$83,281) beginning July 1, 2018 (-1.0 FTE or 2,080 hours annually), the elimination of one Plant Operator position (-$85,473) beginning July 1, 2018 (-1.00 FTE or 2,080 hours annually), the elimination of a second Plant Operator Position (-$39,660) beginning January 1, 2019 (-0.50 FTE or 1,040 hours annually), and the creation of an Operations Supervisor position (+91,893) at GE-33D (+1.0 FTE or 2,080 hours annually). Net change in full-time equivalents in FY 2019 is-2.50 FTE. -38- Supplies & Services 7. Property Insurance increased from $81,236 in FY 2018 to $84,857 in FY 2019.An appraisal of all city buildings was completed during FY 2018. Property insurance cost is now allocated to departments based on the appraised value of the building and square footage used by each department. 8. Sales Tax decreased from $310,002 in FY 2018 to $307,767 in FY 2019 based on decreased sanitary sewer rates in FY 2019. This expense is directly offset by sales tax revenue. 9. Electricity Utility Expense increased from $289,383 in FY 2018 to $424,777 in FY 2019 based on a 5% increase in regional transmission service charges and 2.75 cents/kWh. Electrical expense for the W&RRC plant in FY19 is $227,486, which includes increased microturbine output and $79,766 for the estimated BioResoure Development electrical usage which will be reimbursed on a monthly basis. The lift station electrical expense in FY19 is estimated to be $197,291. FY 2017 actual was $334,908. 10. Gas Utility Expense increased from $59,080 in FY 2018 to $65,204 in FY 2019 based on FY 2017 actual plus 5%. 11. Property Maintenance decreased from $92,537 in FY 2018 to $91,050 in FY 2019 based on FY 2017 actual of$86,412 plus 5%. 12. Machinery and Equipment Maintenance increased from $168,400 in FY 2018 to $186,277 in FY 2019 based on budgeting for cleaning one digester each year at a cost of$40,000. FY 2017 actual was $154,385. 13. Major Repair Element is unchanged from $75,000 in FY 2018 to $75,000 in FY 2019. 14. Equipment Maintenance Contract Expense decreased from $79,022 in FY 2018 to $76,634 in FY 2019 based on FY 2017 actual of$74,879 plus 2%. 15. Lift Station Maintenance increased from $155,937 in FY 2018 to $163,200 in FY 2019 based on FY 2017 actual of$148,495 plus 10%. 16. Polymer Expense increased from $242,811 in FY 2018 to $245,985 in FY 2019 based on FY 2017 actual of$245,985. 17. Liquid Oxygen decreased from$600,000 in FY 2018 to $426,734 in FY 2019 based on bidding the contract during FY 2017 which resulted in cost savings. The FY 2019 budget includes $26,734 for tank rental and $400,000 for oxygen based on the expected loading. FY 2017 actual was $548,121. 18. Environmental Testing/Monitoring Expense decreased from $74,595 in FY 2018 to $59,663 in FY 2019 based on FY 2017 actual of$59,663. 19. Hauling Service decreased from $284,753 in FY 2018 to $276,722 in FY 2019 based on FY 2017 actual of$276,722. -39- Machinery & Equipment 20. Equipment replacement items at the maintenance level include ($29,570): Plant Operations Shop Equipment $10,000 Cell Phones (2) $ 470 Environmental Monitoring Laboratory Equipment $19,100 Total Equipment $29,570 Debt Service 21. Debt service payments for FY 2019 are as follows ($5,275,393): Final Call Amount Debt Series Source Purpose Payment Date $ 63,750 G.O. 2017A Sanitary Fees Sanitary Sewer Improvements 2030 2025 $ 98,243 G.O. 2011A Sanitary Fees Sanitary Sewer Improvements 2031 2018 $ 44,133 G.O. 2012E Sanitary Fees Sanitary Forcemain Repairs 2032 2018 $ 105,944 G.O. 2012D Sanitary Fees Sanitary Sewer Improvements 2033 2019 $ 448,325 G.O. 2014B Sanitary Fees Sanitary Sewer Improvements 2034 2021 $ 167,606 G.O. 2016C Sanitary Fees Sanitary Sewer Improvements 2035 2024 $ 63,020 SRF 2006 Sanitary Fees Northfork Catfish Creek 2031 $ 218,230 SRF 2009 Sanitary Fees Meter Change-Out 2031 $ 3,696,760 SRF 2010 Sanitary Fees W&RRC Plant Upgrade 2039 $ 185,901 SRF 2013 Sanitary Fees W&RRC Cogeneration 2033 $ 164,730 SRF 2017 Sanitary Fees Kerper Boulevard Sanitary 2036 $ 2,961 Planned Sanitary Fees Harlan & Euclid Sanitary 2039 $ 15,790 Planned Sanitary Fees Outfall Manhole Sanitary 2039 $ 5,275,393 Total Sanitary Debt Service Revenue 22. Sewage Fees increased from $10,140,162 in FY 2018 to $10,366,756 in FY 2019 based on a 3% rate increase in FY 2019. 23. Sewage dumping fees decreased from $127,991 in FY 2018 to $124,964 in FY 2019 based on FY 2017 actual of$124,964. 24. Late Payment Penalties decreased from $104,236 in FY 2018 to $97,800 in FY 2019 based on FY 2017 actual of$97,800. -40- 25. The Water and Resource Recovery Center's pre-treatment largest industrial customers projected changes in revenues as follows: • Prairie Farms increased from $470,013 in FY 2018 to $472,345 in FY 2019 based on FY 2017 actual of$472,345; • Inland Protein increased from$116,689 in FY 2018 to $170,017 in FY 2019 based on FY 2017 actual of$170,017; and • Rousselot is unchanged from $900,000 in FY 2018 to $900,000 in FY 2019 based on FY 2017 actual actual of$853,196 and the last four months payments averaged $75,000 each. 26. High Strength Waste revenue decreased from $215,000 in FY 2018 to $190,000 in FY 2019 based on FY 2017 actual of$274,326 and a reduction for Rousselot further processing their high strength waste which has significantly reduced the loads taken to W&RRC. This revenue represents other entities paying the City to take high strength waste which will be used in the anaerobic digesters to generate additional energy using the micro-turbines. 27. Gas Royalty increased from $172,000 in FY 2018 to $214,354 in FY 2019 . This line item represents 5% of the gross revenue for BioResource Development ($83,354), lease of the site ($10,000), staff time reimbursement ($6,000), reimbursement of gas ($12,000) and electric cost ($78,000), and profit on electrical use ($25,000). 28. Fats, Oils and Grease Permit and Dumping fees decreased from $30,875 in FY 2018 to $30,000 in FY 2019 based on FY 2017 actual of$28,006. -41- This page intentionally left blank. -42- WATER & RESOURCE RECOVERY CENTER The Water & Resource Recovery Center uses technology to effectively clean the water used by the community in such a manner as to allow its safe return to the environment. The process of completing this task also provides the opportunity to extract resources from the water and additional sources for use within the Center and the surrounding community. Water& Resource Recovery Center I I I Administration Operations and Evnironmental Maintenance Monitoring SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES PLANNING The W&RRC has ongoing planning Uand implementation for several environmental issues including spill PEOPLE prevention plans, Bio-Solids W&RRC Staff, Health Department, Management and Nutrient Reduction. Engineering and Public Works provided the majority of our City relationships. We also maintain a relationships with local industries, ,r ,'. the Resilient Community Advisory Commission and Regional/Local © oh _- Engineers. y 1 PARTNERSHIPS The W&RRC maintains partnerships with p City Departments, Iowa Department of Natural Resources, USEPA, Local 17> Industries and local/regional/service providers. -43- WATER & RESOURCE RECOVERY CENTER Resources $13,234,875 $13,090,204 $13,000,000 $12,787,466 $12,000,000 $11,000,000 $10,000,000 Operating Revenue FY 2017 • FY 2018 FY 2019 The Water Resource Recovery Center is supported by 14.50 full-time equivalent employees, which accounts for 27.45% of the department expense as seen below. Overall, the department's expenses are expected to increase by 5% in FY 2019 compared to FY 2018. Expenditures and Debt by Fiscal Year FmploYeeFkpense — $1,583,015 $1,553,942 $1,433,073 Supplies and Services $2,765,294 $2,830,054 $2,912,704 Onnstruction Fund $1,736,000 $181,114 $845,000 Equipment $22,015 $29,570 �ngneering OH $172,455 $198,838 $235,794 Public works OH $573,671 $781,129 $830,141 Admin Overt,ead $1,159,073 $1,407,393 $1,376,688 Debt Service $5,624,188 $5,203,262 $5,275,393 $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 FY 2017 FY 2018 FY 2019 -44- WATER & RESOURCE RECOVERY CENTER Operations and Maintenance Overview Operations and maintenance of the W&RRC consists of maintaining equipment and records necessary to collect, pump, treat and dispose of the liquid wastes discharged into the sanitary sewer system as required by state and federal regulatory agencies at the lowest possible cost while sustaining appropriate maintenance programs for plant reliability; operating and maintaining 20 pumping stations located throughout the City of Dubuque; Repair and maintain all equipment required for the successful and efficient operation of the W&RRC. Stock essential spare parts and maintain records for effective operation of the W&RRC. Center Operations For FY17 the Water & Resource Recovery Center (W&RRC) treated an average 7.082 million gallons per day(M.G.D.) or 2,585 O O O 00 million gallons for the year. 7.082 million gallons is equal to about 1350 semi-tanker loads of sewer water per day. The average BOD or Biochemical Oxygen Demand was 23,935 pounds of Oxygen per day of which 23,403 pounds was removed or about 97.8 percent removal. Pounds of Oxygen Demand 30000 25000 - .04 20000 VN 15000 1` 10000 In ■Out �1�s.'- l That means that each day we kept 23,403 pounds of Oxygen from being removed from the waters of the Mississippi River. -45- WATER & RESOURCE RECOVERY CENTER 12.5 tons of soil amendment (fertilizer) are produced PER DAY during the process of cleaning the wastewater. _ jL�u1`4 ►. am .1 f . . •%' __ 6 igeW�,2; Pl. _ N _ iiiiiiilh —i _) 4 1NIIIIIIII I 'dr di 1.4 That is an average of eight semi loads per week of useful material being safely returned to a beneficial purpose. Operations and Maintenance Funding Summary FY 2017 Actual FY 2018 Budget FY 2019 Requested Expenditures $9,517,653 $9,080,417 $9,142,830 Resources $13,066,942 $12,619,524 $12,928,424 Operations and Maintenance Position Summary FY 2019 WRRC MANAGER 1.00 MAINTENANCE SUPERVISOR WWT 1.00 W&RRC OPERATIONS SUPERVISOR 1.00 EQUIPMENT MECHANIC-WWT 2.00 WRRC OPERATOR CERT GR II 2.50 PLANT OPERATOR GRADE III &IV 2.00 CONFIDENTIAL ACCOUNT CLERK 1.00 Total FT Equivalent Employees 10.50 Performance Measures Operations and Maintenance -Activity Statement Maintain efficient operations and maintenance of the UU&RRC to assure for treatment of the City of Dubuque's waste water in the most cost effective manner possible while protecting the environment and citizens from exposure to pollution in the Mississippi River. a Goal: Sustainable Environment --1(A -46- WATER & RESOURCE RECOVERY CENTER Outcome #1: Maintain proper operation and maintenance of pumping stations throughout the City of Dubuque to ensure that untreated wastewater is not discharged to streets, storm sewers or creeks/rivers where citizens may come in contact with this potentially dangerous material. All pumping stations are connected with the W&RRC computer system to allow for real-time monitoring of the operations of the stations. Stations are visited by the W&RRC Maintenance staff at least weekly to check for proper operations. Three of the major stations are checked daily during the work week. Three of the pumping stations have permanently installed standby power generators and the others can be powered by the three portable generators owned by the W&RRC. This capability along with the standby generators at the W&RRC assures the businesses and citizens of the City of Dubuque that even during power outages the W&RRC will continue to operate and provide essential services to our citizens. All operations staff to have at least Grade II Certification Training is provided to employees of the W&RRC to equip all employees with the required skills to successfully operate a complex technical facility, to maintain and upgrade certifications required by IDNR and keep abreast of current regulations and technologies. A higher level of training for all operators will lead to a more efficient operation of the W&RRC. 4gOlhik Goal: Robust Local Economy 10. Outcome #2: Increased Energy Production for use at the W&RRC Increased addition of HSW to the digesters provides for additional revenue for the W&RRC and over time will allow the W&RRC to produce most of the energy needed to operate the Center. The W&RRC produces 75%to 85% of the electrical needs for the Center. • Increased Gas Production via the Introduction of HSW • Matching Center KW Demands with HSW Introduction • Alliant agreement to allow increase KW production Electrical Demand KW 700 600 5Io 4 3 2 1 2 3 Blue=Total Demand Green=W&RRC Production Red= Purchased -47- WATER & RESOURCE RECOVERY CENTER Environmental Monitoring Overview The Environmental Monitoring Section performs the chemical, biological and bacterial sampling and analysis associated with the operations of the W&RRC and assists in the operations of additional City Departments and the community by providing analytical services. The function of the Industrial Pretreatment Program is to eliminate from industrial sources those materials which may cause pass through and/or interference with the operation of the City of Dubuque's Publicly Owned Treatment Works. Working in conjunction with many City of Dubuque Departments to operate and maintain the Fats, Oils and Grease program. The program is aimed at eliminating Sanitary Sewer Overflows caused by the discharge of excessive amount of fats, oils and greases into the sanitary sewer system. Environmental Monitoring Funding Summary FY 2017 Actual FY 2018 Budget FY 2019 Requested Expenditures $448,818 $519,429 $492,422 Resources $158,593 $157,028 $151,819 Environmental Monitoring Position Summary FY 2019 Lab Supervisor 1.00 Lab Technician 2.00 Environmental Coordinator 1.00 Total FT Equivalent Employees 4.00 Highlights of the Past Year The Environmental Monitoring Activity created the position of Laboratory Supervisor from one of the existing Laboratory Technician positions. This new position provides a staffing structure that improves the efficiency and effectiveness of laboratory activities. Future Initiatives The Laboratory is currently pursuing state certification in the analysis of the nutrients phosphorus and nitrogen. Performance Measures Environmental Monitoring -Activity Statement Monitor the quality of water discharged from the Water& Resource Recovery Center to assure environmental stewardship and adherence to State and Federal regulations and the environmental goals of the Citizens of Dubuque. -48- WATER & RESOURCE RECOVERY CENTER Outcome #1: Maintain a Fats, Oil and Grease program to protect the sanitary sewer system from blockages caused by excessive buildup in the system helping eliminate sanitary sewer overflows caused by Fats, Oils and Grease. it" NS4. � ` t I; �. . r sr,' .:fit` q Outcome #2: Ensure a safe water supply- In support of the Water Department Collect and analyze 16 water samples per week from various locations within the City of Dubuque. The assurance of safe drinking water is essential for the health and safety of the community. 49- This page intentionally left blank. -50- Recommended Operating Revenue Budget - Department Total 43 -WATER&RESOURCE RECOVERY FY16 Actual FY17 Actual FY18 Adopted FY19 Recomm'd Fund Account Account Title Revenue Revenue Budget Budget 610 42230 SEWAGE DISPOSAL PERMITS 100 1,150 1,000 1,150 610 42237 FOG PERMITS 30,600 37,325 30,600 37,325 610 42331 FOG INSPECTION fEES 0 50 0 50 42-LICENSES AND PERMITS 30,700 38,525 31,600 38,525 610 43110 INVESTMENT EARNINGS 28,015 32,547 0 12,810 610 43230 LEASE,PROPERTY 10 0 0 0 43-USE OF MONEY AND PROPERTY 28,025 32,547 0 12,810 610 51185 WATER TESTS-OUTSIDE 34,140 47,728 34,140 47,728 610 51205 SEWAGE FEES 9,746,096 9,929,090 10,140,162 10,366,756 610 51215 PENALTIES 102,193 97,800 104,236 97,800 610 51216 FOG PENALTIES 100 1,800 100 1,800 610 51220 SWISS VALLEY FARMS 470,013 472,345 470,013 472,345 610 51225 INLAND PROTEIN 116,689 170,017 116,689 170,017 610 51227 HIGH STRENGTH WASTE 232,980 274,326 215,000 190,000 610 51230 SEWAGE DUMPING FEES 127,991 124,964 127,991 124,964 610 51231 FOG DUMPING FEES 30,386 28,006 30,875 30,000 610 51235 WW IND.PRETREATMENT 29,349 36,341 29,349 36,341 610 51240 SANROUESSLOT 926,057 853,196 900,000 900,000 610 51260 GAS ROYALTY 0 25,500 172,000 214,354 610 51690 LANDFILL PAYMENT-LAB TEST 39,507 6,773 39,507 0 610 51964 ARENANOVELT 1,165 250 1,165 250 51-CHARGES FOR SERVICES 11,856,666 12,068,136 12,381,227 12,652,355 610 53201 REFUNDS 0 2,044 0 2,044 610 53204 IOWA FUEL TAX REFUND 543 613 543 613 610 53520 WATER SAMPLING-PLANT 33,685 41,318 33,685 41,318 610 53521 WWT SAMPLING-AIRPORT 3,390 0 0 0 610 53523 WWT SAMPLING-OUTSIDE 20,325 24,366 20,325 24,366 610 53610 INSURANCE CLAIMS 0 34,289 0 0 610 53620 REIMBURSEMENTS-GENERAL 21,416 79 0 79 610 53630 SALES TAX COLLECTION 309,171 290,086 309,172 307,767 53-MISCELLANEOUS 388,530 392,795 363,725 376,187 610 54109 SALVAGE SALES 49 366 0 366 610 54210 GO BOND PROCEEDS 0 652,158 0 0 610 54220 BOND DISCOUNT 0 21,006 0 0 54-OTHER FINANCING SOURCES 49 673,530 0 366 610 59710 FR SANITARY SEWER CONST 0 20,000 0 0 59-TRANSFER IN AND INTERNAL 0 20,000 0 0 43-WATER&RESOURCE RECOVERY TOTAL 12,303,970 13,225,533 12,776,552 13,080,243 -51- Recommended Operating Expenditure Budget - Department Total 43 -WATER&RESOURCE RECOVERY FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 610 61010 FULL-TIME EMPLOYEES 919,127 965,479 984,686 930,835 610 61030 SEASONAL EMPLOYEES 1,707 22,612 0 0 610 61050 OVERTIME PAY 163,555 55,670 59,350 59,350 610 61071 HOLIDAY PAY-OVERTIME 21,754 23,739 17,221 17,221 610 61091 SICK LEAVE PAYOFF 17,795 24,172 14,720 14,720 610 61092 VACATION PAYOFF 10,066 0 0 0 610 61310 IPERS 98,632 94,388 94,808 95,099 610 61320 SOCIAL SECURITY 83,681 80,088 82,344 78,193 610 61410 HEALTH INSURANCE 274,330 270,316 254,400 207,496 610 61415 WORKMENS'COMPENSATION 41,901 40,971 38,766 29,293 610 61416 LIFE INSURANCE 724 768 1,970 866 610 61620 UNIFORM ALLOWANCE 234 0 0 0 610 61640 SAFETY EQUIPMENT 7,172 4,690 5,555 0 610 61660 EMPLOYEE PHYSICALS 368 121 122 0 61-WAGES AND BENEFITS 1,641,046 1,583,014 1,553,942 1,433,073 610 62010 OFFICE SUPPLIES 2,940 1,318 3,302 1,318 610 62011 UNIFORM PURCHASES 1,814 2,414 1,851 2,500 610 62030 POSTAGE AND SHIPPING 2,729 2,692 2,820 2,692 610 62032 FLAGS 0 0 0 135 610 62061 DP EQUIP.MAINT CONTRACTS 9,664 9,942 8,898 8,610 610 62062 JANITORIAL SUPPLIES 0 0 0 1,000 610 62065 LAB SUPPLIES 17,841 19,648 17,247 19,648 610 62090 PRINTING&BINDING 2,579 2,502 2,631 2,502 610 62110 COPYING/REPRODUCTION 267 774 273 773 610 62130 LEGAL NOTICES&ADS 450 73 459 73 610 62190 DUES&MEMBERSHIPS 1,914 875 2,054 1,125 610 62204 REFUNDS 11,179 7,208 0 7,208 610 62206 PROPERTY INSURANCE 93,230 78,795 81,236 84,857 610 62207 BOILER INSURANCE 5,521 0 0 0 610 62208 GENERAL LIABILITYINSURAN 15,361 15,408 16,178 11,750 610 62210 SALES TAX 303,924 291,779 310,002 307,767 610 62216 REFUND LEAK ALLLOWANCE 4,203 0 0 0 610 62310 TRAVEL-CONFERENCES 1,139 3,290 8,562 4,450 610 62320 TRAVEL-CITY BUSINESS 2,600 144 863 290 610 62360 EDUCATION&TRAINING (284) 8,990 4,671 4,853 610 62411 UTILITYEXP-ELECTRICITY 326,330 334,908 289,383 424,777 610 62412 UTILITYEXP-GAS 53,709 62,099 59,080 65,204 610 62415 UTILITY EXPENSE STORMWATR 7,915 5,991 8,073 6,395 610 62416 UTILITYEXP-WATER 62,032 47,805 63,273 51,209 610 62421 TELEPHONE 5,140 6,838 5,141 6,857 610 62424 RADIO/PAGERFEE 2,551 2,026 2,628 2,067 610 62431 PROPERTY MAINTENANCE 90,722 86,412 92,537 91,050 610 62435 ELEVATOR MAINTENANCE 2,857 2,736 2,914 2,178 610 62436 RENTAL OF SPACE 480 480 490 480 610 62511 FUEL,MOTOR VEHICLE 8,965 7,781 8,965 7,937 610 62513 FUEL,DIESEL 0 2,436 0 2,436 610 62521 MOTOR VEHICLE MAINT. 5,113 9,497 5,467 7,454 610 62528 MOTOR VEH.MAINT.OUTSOUR 998 1,127 1,018 1,150 -52- Recommended Operating Expenditure Budget - Department Total 43 -WATER&RESOURCE RECOVERY FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 610 62611 MACH/EQUIP MAINTENANCE 165,098 154,385 168,400 186,277 610 62612 MAJOR REPAIR ELEMENT 131,824 0 75,000 75,000 610 62613 METER MAINTENANCE 5,500 9,057 5,610 9,057 610 62614 EQUIP MAINT CONTRACT 71,873 74,879 79,022 76,634 610 62622 BELT FILTER MAINTENANCE 0 76,333 0 0 610 62623 CETRIFUGE MAINTENANCE 0 36,729 35,000 36,729 610 62625 LIFT STATION MAINTENANCE 152,880 148,495 155,937 163,200 610 62628 INSTRUMENTATION MAINT 7,951 3,072 8,110 3,072 610 62629 INSTR MAINT CONTRACT 0 6,720 0 17,500 610 62631 LIME 0 906 1,000 906 610 62633 CHLORINE 7,030 9,630 7,171 9,630 610 62638 POLYMER 238,050 245,985 242,811 245,985 610 62639 LIQUID CO2/O2 712,576 548,121 600,000 426,734 610 62663 SOFTWARE LICENSE EXP 125 6,354 8,070 6,353 610 62667 INTERNET SERVICES 0 86 480 444 610 62671 MISC.OPERATING SUPPLIES 2,586 0 1,356 0 610 62681 LUBRICATION PRODUCTS 2,215 5,043 2,260 5,043 610 62692 LANDFILL FEES 21,234 18,752 21,659 31,700 610 62696 OUTSIDE COLLECTOR EXPENSE 9,557 8,291 9,748 8,291 610 62710 CONTRACTOR SERVICES 0 0 0 50,000 610 62712 CONSULTING ENGINEERS 0 0 2,525 0 610 62713 LEGAL SERVICES 4,321 5,692 4,407 5,692 610 62716 CONSULTANT SERVICES 5,557 9,773 13,834 60,000 610 62721 FINANCIAL CONSULTANT 0 1,177 0 1,177 610 62726 AUDIT SERVICES 1,875 2,200 2,500 2,750 610 62731 MISCELLANEOUS SERVICES 3,759 3,421 0 0 610 62733 CONTRACT CUSTODIAL 21,059 29,851 21,480 17,700 610 62736 CATERING SERVICES 794 0 810 0 610 62747 MACH/EQUIPMENT RENTAL 0 1,500 0 0 610 62763 PAYMENT TO IOWA DNR 0 6,470 3,500 5,700 610 62767 ENVIRON.TESTING/MON. 78,257 59,663 74,595 59,663 610 62780 HAULING SERVICES 279,170 276,722 284,753 276,722 62-SUPPLIES AND SERVICES 2,967,174 2,765,295 2,830,054 2,912,704 610 71120 PERIPHERALS,COMPUTER 0 156 1,040 0 610 71127 UPS SYSTEM 0 0 980 0 610 71410 SHOP EQUIPMENT 11,084 7,953 0 10,000 610 71413 LABORATORY EQUIPMENT 6,047 1,066 19,500 19,100 610 71610 CUSTODIAL EQUIPMENT 0 242 0 0 610 72418 TELEPHONE RELATED 0 46 495 470 71-EQUIPMENT 17,131 9,463 22,015 29,570 610 74111 PRINCIPAL PAYMENT 2,931,589 3,742,470 3,344,518 3,454,212 610 74112 INTEREST PAYMENT 1,816,628 1,881,718 1,858,744 1,821,181 74-DEBT SERVICE 4,748,217 5,624,188 5,203,262 5,275,393 610 91100 TO GENERAL 750,505 1,301,957 1,550,277 1,519,572 610 91710 TO SANITARY SEWER CONST 1,269,916 1,736,000 181,114 845,000 91-TRANSFER TO 2,020,421 3,037,957 1,731,391 2,364,572 43-WATER&RESOURCE RECOVERY TOTAL 11,393,989 13,019,917 11,340,664 12,015,312 -53- Recommended Expenditure Budget Report by Activity & Funding Source 43 -WATER&RESOURCE RECOVERY I UNDISTRIBUTED 111 - 10610 FUNDING SOURCE:SEWAGE FACILITY OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget SUPPLIES AND SERVICES 15,488 9,427 15,488 TRANSFER TO 3,037,957 1,731,391 2,364,572 UNDISTRIBUTED 3,053,445 2,380,060 WPC ADMINISTRATION - 4310 FUNDING SOURCE:SEWAGE FACILITY OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget DEBT SERVICE 5,624,188 5,203,262 5,275,393 EQUIPMENT 201 375 - SUPPLIES AND SERVICES 334,314 344,530 341,880 WAGES AND BENEFITS 154,730 134,421 141,586 WRRP ADMINISTRATION 6,113,433 5,682,5:'`3 WPC PLANT OPERATIONS -43400 FUNDING SOURCE:SEWAGE FACILITY OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget EQUIPMENT 8,195 1,100 10,470 SUPPLIES AND SERVICES 2,318,040 2,351,212 2,455,525 WAGES AND BENEFITS 1,039,193 1,013,717 885,693 WRR PLANT OPERATIONS =,428 I FATS OILS GREASE 143500 III. FUNDING SOURCE:SEWAGE FACILITY OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget SUPPLIES AND SERVICES 6,856 6,100 6,856 WAGES AND BENEFITS 31,936 25,700 25,427 FATS OILS GREASE 38,792 31,800 32,283 ENVIRON-MONITORING - 43700 11 FUNDING SOURCE:SEWAGE FACILITY OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget EQUIPMENT 1,066 20,540 19,100 SUPPLIES AND SERVICES 90,596 118,785 92,955 WAGES AND BENEFITS 357,156 380,104 380,367 ENVIRON-MONITORING 448,818 519,429 492,422 ATER&RESOURCE RECOVERY TOTAL $ 13,019,916.28 $ 11,340,664.00 $ 12,015,312.00 -54- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 43 WATER AND RESOURCE RECOVERY CENTER FY 2017 FY 2018 FY 2019 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 $ 107,734 1.00 $ 92,652 1.00 $ 99,913 610 3300 GE-35 WRRC ASSIST. MANAGER 1.00 $ 59,732 1.00 $ - 0.00 $ - 610 3030 GE-34 MAINTENANCE SUPERVISOR WJVT 1.00 $ 78,137 1.00 $ 79,395 1.00 $ 80,590 610 GE-33 W&RRC OPERATIONS SUPERVISOR 0.00 $ - 0.00 $ - 1.00 $ 66,218 610 GE-33 LAB SUPERVISOR 0.00 $ - 1.00 $ 75,273 1.00 $ 76,418 610 GE-31 ENVIRONMENTAL COORDINATOR 1.00 $ 54,469 1.00 $ 59,966 1.00 $ 60,860 610 2100 GE-31 LAB TECHNICIAN II 3.00 $ 193,282 2.00 $ 119,167 2.00 $ 123,350 610 GE-25 CONFIDENTIAL ACCOUNT CLERK 1.00 $ 46,576 1.00 $ 47,651 1.00 $ 48,373 610 2400 0E-14 EQUIPMENT MECHANIC-WWi 2.00 $ 114,701 2.00 $ 117,126 2.00 $ 119,494 610 2800 0E-14 MAINTENANCE ELECTRICIAN 1.00 $ 57,065 1.00 $ 57,983 0.00 $ - 610 0E-14 WRRC OPERATOR CERT GR IV 0.00 $ - 0.00 $ - 1.00 $ 55,910 610 0E-13 WRRC OPERATOR CERT GR III 1.00 $ 56,370 2.00 $ 113,035 1.00 $ 56,563 610 2500 0E-12 WRRC OPERATOR CERT GR II 2.00 $ 112,082 2.00 $ 113,879 2.50 $ 143,146 610 2450 0E-11 WRRC OPERATOR (NC/GR I C) 3.00 $ 156,168 2.00 $ 108,559 0.00 $ - TOTAL FULL TIME EMPLOYEES 17.00 $1,036,316 17.00 $ 984,686 14.50 $930,835 61030 SEASONAL EMPLOYEES 610 NA-38 INTERN 0.16 $ 4,199 0.00 $ - 0.00 $ - TOTAL SEASONAL EMPLOYEES 0.16 $ 4,199 0.00 $ - 0.00 $ - TOTAL WATER&RESOURCE RECOVERY CENTER 17.16 $1,040,515 17.00 $ 984,686 14.50 $930,835 -55- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2017 FY 2018 FY 2019 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Water&Resource Recovery Center Administration WASTEWATER PLANT 61043100 61010 610 3300 GE-40 MANAGER 1.00 $ 107,734 1.00 $ 92,652 1.00 $ 99,913 Total 1.00 $ 107,734 1.00 $ 92,652 1.00 $ 99,913 Water&Resource Recovery Center Plant Operation 61043100 61010 610 3300 GE-35 W&RRC ASSIST PLANT MGR 1.00 $ 59,732 1.00 $ - 0.00 $ - MAINTENANCE SUPERVISOR 61043400 61010 610 3030 GE-34 W&RRC 1.00 $ 78,137 1.00 $ 79,395 1.00 $ 80,590 61043400 61010 610 GE-33 W&RRC OPERATIONS SUPV 0.00 $ - 0.00 $ - 1.00 $ 66,218 EQUIPMENT MECHANIC- 61043400 61010 610 2400 OE-14 W&RRC 2.00 $ 114,701 2.00 $ 117,126 2.00 $ 119,494 ENVIRONMENTAL 61043400 61010 610 2228 GE-31 COORDINATOR 0.00 $ - 0.00 $ - 0.00 $ - 61043400 61010 610 1000 GE-25 CONFIDENTIAL ACCOUNT CERK 0.65 $ 30,484 0.65 $ 30,973 0.65 $ 31,443 61043400 61010 610 3942 OE-13 W&RRC OPERATOR GR III/IV 1.00 $ 56,370 2.00 $ 113,035 2.00 $ 112,473 61043400 61010 610 2500 OE-12 W&RRC OPERATOR GR II 2.00 $ 112,082 2.00 $ 113,879 2.50 $ 143,146 61043400 61010 610 2450 OE-11 W&RRC PLANT OP(NC/GR I C) 3.00 $ 156,168 2.00 $ 108,559 0.00 $ - 61043400 61010 610 2800 OE-14 MAINTENANCE ELECTRICIAN 1.00 $ 57,065 1.00 $ 57,983 0.00 $ - Total 11.65 $ 664,739 11.65 $ 620,950 9.15 $ 553,364 Environmental Monitoring Lab-FT 61043700 61010 610 GE-33 LAB SUPERVISOR 0.00 $ - 1.00 $ 75,273 1.00 $ 76,418 61043700 61010 610 2100 GE-31 LAB TECHNICIAN II 3.00 $ 193,282 2.00 $ 119,167 2.00 $ 123,350 ENVIRONMENTAL 61043700 61010 610 2228 GE-31 COORDINATOR 1.00 $ 54,469 1.00 $ 59,966 1.00 $ 60,860 Total 4.00 $ 247,751 4.00 $ 254,406 4.00 $ 260,628 Fat Oils and Grease-FT CONFIDENTIAL ACCOUNT 61043500 61010 610 1000 GE-25 CLERK 0.35 $ 16,092 0.35 $ 16,678 0.35 $ 16,930 0.35 $ 16,092 0.35 $ 16,678 0.35 $ 16,930 Environmental Monitoring Lab-Seasonal 61043700 61030 610 650 NA-38 FINANCE INTERN-SEASONAL 0.16 $ 4,199 0.00 $ - 0.00 $ - Total 0.16 $ 4,199 0.00 $ - 0.00 $ - TOTAL WATER&RESOURCE RECOVERY DEPARTMENT 17.16 $1,040,515 17.00 $ 984,686 14.50 $ 930,835 -56- Capital Improvement Projects by Department/Division WATER&RESOURCE RECOVERY I. - FY 16 Actual FY 17 Actual FY 18 Adopted FY 19 Recomm'd CIP Number Capital Improvement Project Title Expense Expense Budget Budget 71010710 UNDISTRIBUTED 5,000 7101339 SCADA SYSTEM UPGRADE 50,000 7101730 ALT 02 STUDY&IMPLEMENTA - - 150,000 - 7101731 DOG TRACK LIFT STATION 25,000 7101837 WRR PLANT RENOVATION 41,373 75,928 7102211 TERMINAL ST MAG METER REP 4,847 203,852 7102412 CEDAR LIFT PUMP/GEN/TRAIL 100,000 7102529 NUTRIENT REDUCT STRATEGY 2,509 7102530 OUTFALL MANHOLE 7,364 400,000 7102538 AIRPORT LS UPGRADES 15,000 7102597 FOG RECEIVING STATION 1,569 7102598 CLARIFIER REALIGN/REPAIR 4,234 13,981 7102600 CONCRETE PAD GAS COND EQ 10,340 7102601 REPLACEMENT OF RADIOS - - 9,735 - 7102659 NUTRIENT RED/BASIN MOD 1 - - 70,000 - 7102697 ASH POND ABANDONMENT - 62,534 - - 7102698 METHANE GAS SYSTEM WRRC - 25,479 - - 7102699 STRUVITE AIRPREX PILOT - 29,518 - - 7102700 LEVEL 4 AGREEMENT - 10,099 - - 7102701 HS WASTE RECEIVE&STORE - 14,998 100,000 - 7102749 KW CAR WASH LIFT STATION 27,500 7102750 GRANGER CREEK LIFT STATIO 12,000 !ITER&RESOURCE RECOVERY TOTAL 77,235 436,387 329,735 629,500 -57- PRGRM /DEPT PROJECT DESCRIPTION FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 TOTAL PAGE WATER&RESOURCE RECOVERY CENTER Business Type Outfall Manhole Reconstruction $ 400,000 $ — $ — $ — $ — $ 400,000 99 Dog Track Lift Station Upgrades $ 25,000 $ — $ — $ — $ — $ 25,000 100 Key West Car Wash Lift Station Rehabilitation $ 27,500 $ — $ — $ — $ — $ 27,500 101 Granger Creek Lift Station Upgrades $ 12,000 $ — $ — $ — $ — $ 12,000 102 Airport Lift Station Upgrades $ 15,000 $ — $ — $ — $ — $ 15,000 103 Cedar Creek Lift Station Spare Pump $ 100,000 $ — $ — $ — $ — $ 100,000 104 Lift Station SCADA Upgrades $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 250,000 105 Final Clarifier Drive Pier Realignment and Drive Repair $ — $ 41,120 $ — $ — $ — $ 41,120 106 High-Strength Waste Receiving &Storage $ — $ — $ — $ 522,155 $ 961,795 $ 1,483,950 107 UV Disinfection System Modifications $ — $ — $ — $ — $ 10,000 $ 10,000 108 Total -Water& Resource Recovery Center $ 629,500 $ 91,120 $ 50,000 $ 572,155 $1,021,795 $2,364,570 -58-