Loading...
HomeMy WebLinkAbout13. 20-44 JANUARY 28, 2020 20-44 RESOLUTION (CARRIED 6-0 LOST LAID OVER WITHDRAWN ) PURPOSE: APPROVAL OF FEE SCHEDULE FOR SEWER USE CHARGES INITIATED BY: CITY ADMINISTRATION WHEREAS, the Wastewater Systems Ordinance, Chapter 24, of the Municipal Code provides for the adoption of a fee schedule for wastewater service charges. NOW, THEREFORE, BE IT RESOLVED that the attached Sewer Use Charges Fee Schedule is hereby adopted and shall be in full force and effect on and after February 1, 2020. • City4116;_, of Oshkosh TO: Honorable Mayor and Members of the Common Council FROM: Russ Van Compel, Director of Finance DATE: January 23, 2020 RE: Approve Fee Schedule for Sewer Use Charges BACKGROUND As discussed during the 2020 budget workshops, sewer rates need to be increased in 2020 to keep the Utility in a productive capacity, operating at a prudent level. ANALYSIS The increase is needed due to the following reasons: • Usage increased slightly over the last 12 month period, • Moderate increase in expenses from 2010 to the present, • The planned issuance of approximately $17.63 million of sewer revenue bonds in 2020 • Capital Improvement Program in 2016 and beyond with regard to sewer infrastructure projects, and • Funds needed to meet bond covenant requirements with regard to debt payments (i.e. Debt Coverage). As enumerated above, the approximate 8.0% increase to revenues is necessary to fund operations and debt service needs in 2020. FISCAL IMPACT If approved, the effect of the increase on the average residential user on a monthly basis is $1.61, which equates to a 5.0% increase. The annual impact is $19.32. For the impact on other customers, please refer to Table 11 on page 20 of the Ehlers Sewer Rate Study RECOMMENDATION Staff recommends that Council pass this resolution. Respectfully Submitted, Approved: 4-7-41 Russ Van Gompel Mark A. Rohloff Finance Director City Manager Finance Department City Hall,215 Church Avenue P.O.Box 1130 Oshkosh,WI 54903-1130 920.236.5005 http://www.ci.oshkosh.wi.us FINANCIAL MANAGEMENT PLANNING Test Year 2020 Sewer Rate Study For City of Oshkosh Oshkosh January, 2020 Prepared by: Jon Cameron Senior Municipal Advisor Brian Roemer Municipal Advisor rg'*ZE H L E RS BUILDING COMMUNITIES. IT'S WHAT WE DO. info@ehlers-inc.com 1(BOO)552-1171 www.ehiers-inc.com 2020 Sanitary Sewer User Rate Study Supporting Worksheets Oshkosh Description Page Memo 1 Rate Comparison 2 Table 1 —Comparison of Existing and Proposed User Rates 3 Table 2 —Projected WWTF Flows and Loadings 4 Table 3 —Projected Equivalent Meters 5 Table 4 —Historical Expenses and 2020 Adopted Budget for Sewer Utility 6 Table 5 —Allocation of Costs to Function 10 Table 6 —Rate Computation Worksheet 14 Table 7 —Rate Summary 16 Table 8 —Revenue Check(Based Upon COS) 17 Table 9 —Revenue Summary (Proposed Rates) 18 Table 10 —Test Year Cash Flow Analysis 19 Table 11 —Comparison of Existing and Proposed Bills for Sample Customers 20 Table 12— Summary Budget for Sanitary Districts 21 Table 13 —Historical Influent Data at Wastewater Treatment Facility 22 Table 14 —Contract Customer Historical Monthly Flows 23 Table 15 —2020 Estimated Charges to the Algoma Sanitary District 24 Table 16 —2020 Estimated Charges to the Black Wolf Sanitary District No. 1 25 Table 17 —2020 Estimated Charges to the Sunset Point Sanitary District 26 Table 18 —2020 Estimated Charges to the Island View Sanitary District 27 Table 19 —2020 Estimated Charges to the Edgewood-Shangri La Sanitary District 28 Table 20 —2020 Estimated Charges to All Sanitary Districts 29 EHLERS Ig% EHLERS LEADERS IN PUBLIC FINANCE Memo To: Members of the City of Oshkosh Common Council From: Jon Cameron, Senior Municipal Advisor Cc: Mark Rohloff, Russ Van Gompel, James Rabe, Ken Gabrielson Date: January 23, 2020 Subject: Recommended Sewer Rates for 2020 We have completed the Sanitary Sewer User Rate Study Update for 2020. An 8.0% increase to revenues was projected in the long-range Cash Flow and Debt Analysis that we completed for the City this fall. This increase to revenues was incorporated into the adopted budget for the Sewer Utility for 2020. The proposed Rate Study Update slightly exceeds the amount of revenue shown in the Cash Flow presented this fall but yields a smaller increase to the average residential customer. The primary factors for increasing user rates in 2020 are: 1. City-wide billable sewer flows and loadings have slightly increased over the last 12-month period. 2. To provide required coverage for existing Sewer Utility debt. 3. The planned issuance of approximately $17.63 million of sewer revenue bonds in 2020. To accompany the increase to revenues in the adopted budget, an annual update to cost of service sewer rate study was performed to identify detailed user rates for 2020 for all customer classes. The last cost of service sewer rate study was completed in 2019. The purpose of a cost of service study is to calculate user rates such that they are fair and equitable to all customer classes, and to ensure that rates are based upon the principles of cost causation; i.e., those who cause the costs pay the costs. Enclosed please find a few key worksheets from the Rate Study showing the proposed user rates for 2020, as well as the impact the user rates will have on sample customers. A rate comparison worksheet comparing sewer user rates in Oshkosh to other municipalities is also enclosed. BUILDING COMMUNITIES. IT'S WHAT WE DO. ' info@ehlers-inc.com )(800)552-1171 www.ehiers-ine.com Page 1 City of Oshkosh Comparison of Sewer User Rates Quarterly Connection Volume Charge Quarterly Bill , .34 Municipality Population Charge $$/CCF CCF Whitewater 14,540 $12.75 $8.97 $51.67 North Fond Du Lac 5,070 $17.80 $7.41 $49.97 Menomonee Falls 37,443 $23.60 $5.24 $46.32 Clintonville 4,360 $17.00 $5.42 $40.54 Omro 3,582 $13.78 $5.65 $38.32 Waupaca 5,896 $24.21 $2.76 $36.19 Brookfield 37,920 $22.33 $2.96 $35.19 New London 7,109 $4.00 $6.99 $34.32 Oshkosh-Proposed 66,621 $10.42 $5.42 $33.94 Green Bay 105,116 $10.77 $5.21 $33.38 Wisconsin Dells 2,978 $8.00 $5.65 $32.54 Oshkosh -Current 66,621 $9.66 $5.22 $32.31 Waukesha 72,489 $5.81 $5.91 $31.46 Fond Du Lac 42,809 $12.50 $3.91 $29.47 Stevens Point 26,161 $11.79 $3.97 $29.02 Madison 255,214 $14.26 $2.52 $25.20 West Allis 59,934 $17.26 $1.75 $24.86 Sheboygan 48,329 $16.33 $1.70 $23.71 Janesville 64,359 $14.37 $2.01 $23.09 Beloit 36,773 $7.30 $3.42 $22.14 Wausau 39,114 $6.80 $3.11 $20.30 Milwaukee 595,351 $6.61 $3.10 $20.06 Eau Claire 68,587 $2.34 $3.81 $18.87 Racine 77,542 $6.67 $2.77 $18.69 Marinette 10,897 $10.00 $1.90 $18.25 Appleton 74,653 $4.53 $2.04 $13.40 Kenosha 99,877 $2.48 $1.99 $11.12 LaCrosse 52,440 $5.00 $1.26 $10.47 Prepared by Ehlers Page 2 1/23/2020 Table 1 Comparison of Existing vs. Proposed Rates WOshkosh City of oshkos& W-1 ProposedCurrent . Domestic Sewerage Customers Monthly Fixed Charge 5/8" $9.66 $10.42 $0.76 7.90% 3/4" $9.66 $10.42 $0.76 7.90% V $16.19 $17.47 $1.28 7.90% 11/4" $21.63 $23.34 $1.71 7.90% 11/2" $27.07 $29.21 $2.14 7.90% 2" $40.13 $43.30 $3.17 7.90% 3" $70.59 $76.17 $5.58 7.90% 4" $114.12 $123.13 $9.01 7.90% 6" $222.92 $240.53 $17.61 7.90% 8" $363.48 $392.19 $28.71 7.90% 10" $549.33 $592.72 $43.39 7.90% 12" $766.94 $827.52 $60.58 7.90% Volumetric Charge per 100 CU. FT. $5.22 $5.42 $0.20 3.77% Monthly flat charge (Based Upon 4.34 CCF/Mo.) $32.34 $33.95 $1.62 5.00% Non Domestic Customers Monthly Facilities Charge Same as Domestic Customers Volumetric Rate Same as Domestic Customers High Strength Industrial Surcharge Rate BOD/lb $0.621 $0.642 $0.02 3.38% Surcharge Rate TSS/lb $0.425 $0.457 $0.03 7.51% Surcharge Rate Phosphorus/lb $4.910 $5.134 $0.22 4.56% Surcharge Rate NH3-N/lb $1.324 $1.372 $0.05 3.62% Hauled Waste Charges Septic Tank Rate per 1,000 gal $90.06 $90.06 $0.00 0.00% Holding Tank Rate per 1,000 gal $6.58 $6.58 $0.00 0.00% Porta Potty Waste Rate per 1,000 gal $53.57 $53.57 $0.00 0.00% Reading/Billing of"Credit" Meter for"Water Only" Usage $1.67 $1.67 $0.00 0.00% Annual Cost for Average Residential User $387.78 $407.17 $19.39 5.00% Monthly Increase $1.62 TY2020 Sewer Rate Study '% E H L E RS City of Oshkosh, WI Prepared 1/23/2020 Page 3 ` _rA ZNr,III -..jDLII -i,,,ANC- Table 2 Aftaty Proieeted Test Year 2020 WWTF Flows and Loadings Cbshkosh city ofoshkosr; Wr Flow(CCF) : . . Inside Customers Residential 950,000 1,481,601 1,481,601 59,264 148,160 Commercial 375,000 584,843 584,843 23,394 58,484 Multi-Family 230,000 358,703 358,703 14,348 35,870 Industrial 150,000 233,937 233,937 9,357 23,394 Municipal & Public 335,000 522,459 522,459 20,898 52,246 Subtotal Inside Customers 2,040,000 3,181,543 3,181,543 127,262 318,154 High Strength Industrial Axletech - 19 - 19 A Keller 740 2,535 2 - Kingsbury - - - - Oshkosh 333 - 2,010 10,009 213 Oshkosh 500 Waukau 5,323 3,538 883 292 Oshkosh 2737 8,472 7,860 430 1,160 Oshkosh Correctional Inst 1700 82,717 55,689 92 5,929 Oshkosh Correctional Inst 1730 18,364 2,612 - 91 Pepsi Cola 104,392 1,995 88 - Fox River Ethanol - - - - Winnebago Co. Landfill II- Combined Cells 29,821 - - 31,148 Winnebago Co. Landfill - - - 5,431 Bemis 561 41,874 - 134 Water Filtration Plant - 662,742 41 - Subtotal High Strength Industrial Billable 250,390 780,874 11,547 44,416 Wastehaulers Septic Tank Waste 143 8,029 13,381 268 134 Porta Potty Waste 281 7,888 15,777 438 175 Mixed Loads 20,130 113,020 113,020 5,651 15,697 Holding Tank Waste 9,971 31,101 49,762 1,244 3,110 Subtotal Wastehaulers 30,525 160,038 191,939 7,601 19,116 Wastewater Treatment Facility Total Billable 2,070,525 3,591,971 4,154,357 146,409 381,687 Inflow/Infiltration (1/1) 2,563,239 Total WWTF 4,633,764 Total For Rate Calcs 2,070,525 3,591,971 4,154,357 146,409 381,687 TY2020 Sewer Rate Study � E FI L E RS City of Oshkosh, WI Prepared 1/23/2020 Page 4 N LEADERS IN PUBLIC FINANCE Table 3 Projected Test Year 2020 Meter Counts 14,05hkosh City of Oshkosh, `GVI TotalTotal Meters Meter Size Residential Commerical Multi-Family Industrial Municipal& Public 5/8" 9,600 305 82 3 9 9,999 3/4" 11,000 900 64 18 47 12,029 V 178 315 202 27 31 753 1 1/4" 1 1/2" 1 95 150 19 28 293 2" 117 69 28 71 285 3" 35 2 11 40 88 4" 10 8 5 19 42 6" 2 3 3 8 8" 1 1 10" 1 1 12" 20,779 1,779 580 111 250 23,499 TotalEquivalent Meters Meter Size Equiv. Ratio Residential Commerical Multi-Family Industrial Municipal& Public 5/8" 1 9,600 305 82 3 9 9,999 3/4" 1 11,000 900 64 18 47 12,029 V 2.5 445 788 505 68 78 1,883 1 1/4" 3.75 - - - - - - 1 1/2" 5 5 475 750 95 140 1,465 2" 8 936 552 224 568 2,280 3" 15 525 30 165 600 1,320 4" 25 250 200 125 475 1,050 6" 50 100 150 - 150 400 8" 80 - - 80 80 10" 125 125 125 12" 175 - - - - - - 21,050 4,279 2,333 698 2,272 30,631 TY2020 Sewer Rate Study City of Oshkosh,WI r=EHLERS Prepared 1/23/2020 Page 5 Lff"� IN F-1 F1nANC® Table 4 Historical Expenses and 2020 Adopted Budget for Sewer Utility WO5hk©sh city of Oshkosh, WT ACTUAL ACTUAL ACTUAL BUDGET ESTIMATE BUDGET SANITARY SEWER-1920 Labor 156,270 162,965 162,800 212,300 Retirement Benefits 21,647 22,924 22,800 30,000 Insurance Benefits 60,019 57,761 59,900 44,400 Contractual Services 191,888 229,216 203,800 138,800 Repairs to Motor Vehicles 13,666 18,449 17,000 17,000 Maint Mach/Equip/Bldg/Struct 0 0 0 Maintenance of Sanitary Sewers 0 0 0 Maint Mach/Equip/Bldg/Struct 0 0 0 0 Building Rent 550 550 600 600 TV Inspection 0 0 0 Chemicals 0 0 0 0 Miscellaneous 7,431 4,376 14,389 14,100 Legal Fees 82,054 57,108 100,000 100,000 Diesel Fuel 14,905 16,569 19,100 19,800 Supplies and Repair Parts 31,843 36,248 27,576 27,500 Sewer Maintenance Supplies 14,300 19,024 22,800 29,800 Safety Equipment 0 112 0 0 Stone/Gravel/Concrete/Asphalt 17,693 20,708 15,000 20,000 Depreciation 1,440,747 1,544,071 1,817,400 1,963,500 TOTAL SANITARY SEWER 2,053,013 2,190,081 2,282,744 2,483,164 2,455,100 2,617,800 PUMPING STATIONS-1930 Labor 69,025 83,014 65,800 72,600 Repair Parts 23,360 19,771 70,100 25,100 Gas&Oil 312 2,289 0 0 Heat 16,872 18,218 21,000 19,300 Equipment Rental 2,417 0 2,000 2,000 Postage 0 155 300 300 Professional Services 3,318 1,311 1,800 1,800 License&Permit 50 0 100 100 Office Supplies 120 428 1,400 1,700 Other Supplies 7,010 1,233 0 0 Telephone 1,346 1,517 2,700 2,700 Chemicals 77,942 60,283 70,000 70,000 Water 10,970 16,553 12,500 14,000 Sewer 0 0 0 Storm Water 2,696 2,983 3,300 5,000 Supplies and Repair Parts 24,349 31,810 79,800 31,900 Power&Light 80,104 80,222 80,500 84,400 Insurance 2,852 4,530 5,300 5,200 Depreciation 200,779 206,279 209,700 212,900 TOTAL PUMPING STATIONS 523,522 530,596 618,750 628,200 573,300 551,700 TY2020 Sewer Rate Study City of Oshkosh,WI rZk4EHLERS Prepared 1/23/2020 Page 6 0 LEADERS IN PLBL C FINANCE DISPOSAL PLANT-1940-Liquid Labor 835,193 119,213 834,000 861,300 Retirement Benefits 115,879 134,700 116,700 121,800 Insurance Benefits 208,998 204,463 211,900 209,400 Repair Parts 247,418 192,849 252,900 293,100 Office Supplies 2,050 2,714 1,000 1,000 Gas&Oil 683 1,395 2,600 3,200 Heat 77,086 84,419 40,000 54,400 Chemicals 231,098 185,797 225,000 225,000 Cont Svcs/Eng&Consulting Fees 56,739 175,506 385,000 435,600 Tools 3,462 9,584 10,900 10,900 Other Supplies 18,166 11,409 21,000 20,500 Telephone 1,573 1,341 1,600 1,600 Water 20,322 21,877 24,700 26,000 Storm Water 19,524 21,139 24,000 25,300 Power&Light 519,044 500,317 520,000 545,500 Car Allowance 283 130 300 300 Conference&Training 7,314 4,023 9,500 9,500 Insurance 34,476 46,296 42,700 45,800 Depreciation 838,416 982,633 1,033,200 1,105,100 Dues 2,686 2,698 2,800 3,000 Equipment Rental 5,222 2,389 8,500 6,500 Clothing 35 347 500 500 Miscellaneous 2,652 1,478 1,800 1,900 Fees&Permits 49,314 45,507 55,000 69,500 TOTAL DISPOSAL PLANT 3,297,633 2,752,224 3,639,192 3,825,600 3,961,546 4,076,700 SOLID DISPOSAL-1941 Labor 162,345 166,842 185,100 190,100 Retirement Benefits 22,643 23,563 26,000 26,900 Insurance Benefits 43,002 41,460 40,100 36,300 Repair Parts 0 0 25,000 25,000 Gas&Oil 134 994 200 3,200 Chemicals 81,068 66,528 74,000 96,000 Insurance 6,705 9,092 12,800 12,700 Contractual Services 0 82,500 120,000 70,000 Depreciation 526,209 474,696 474,700 474,700 Maintenance 9,792 11,988 26,000 17,000 Equipment Rental 0 0 0 100 Miscellaneous 2,360 3,057 300 400 Special Services 149,459 142,609 140,000 150,500 Uniforms 0 0 100 100 Landfill Fees 0 0 5,000 5,000 Supplies 17,272 20,650 48,300 72,700 TOTAL SOLID DISPOSAL 1,020,989 1,043,979 1,084,785 1,177,600 1,165,200 1,180,700 LABORATORY-1945 TY2020 Sewer Rate Study City of Oshkosh,WI rZk4EHLERS Prepared 1/23/2020 Page 7 0 LEADERS IN PLBL C FINANCE Labor 62,991 64,928 69,800 71,900 Retirement Benefits 8,712 9,103 9,700 10,200 Insurance Benefits 21,616 20,818 20,100 18,200 Repairs 364 1,066 1,000 1,000 Chemicals 7,864 8,636 10,000 10,000 Other Supplies 6,832 6,167 400 400 Insurance 2,599 3,535 5,000 4,900 Depreciation 2,226 2,287 2,300 2,300 Conference&Training 0 0 0 Office Supplies 50 119 100 100 Conference&Prof Training 0 0 100 100 Tools&Shop Supplies 70 0 12,900 12,900 Professional Services 286 239 300 300 TOTAL LABORATORY 113,610 116,898 119,590 131,700 134,000 132,300 MAINTENANCE-1946 Labor 449,811 456,906 586,000 557,600 Retirement Benefits 70,228 76,192 82,600 78,900 Insurance Benefits 104,605 110,652 142,500 109,300 Motor Vehicle Expense 2,718 3,024 5,000 5,000 Contractual Services 8,355 8,874 7,300 5,200 Gas&Oil 6,857 10,371 15,300 17,200 Minor Equipment 984 876 800 800 Office Supplies 1,196 466 900 1,000 Other Supplies 8,075 13,857 10,800 14,900 Repairs/Maint 22,650 24,122 20,000 20,400 Insurance 18,571 24,852 36,500 35,900 Depreciation 238,886 290,148 354,000 391,200 Clothing 162 0 400 600 Miscellaneous 0 872 800 800 Equipment Rental 209 174 200 200 Landfill Fees 0 0 0 0 Conference&Training 0 0 0 0 TOTAL MAINTENANCE 933,306 1,021,386 1,153,120 1,263,100 1,206,400 1,239,000 TY2020 Sewer Rate Study City of Oshkosh,WI rZk4EHLERS Prepared 1/23/2020 Page 8 0 LEADERS IN PLBL C FINANCE GENERAL&ADMINISTRATIVE-1950 Labor 342,883 274,929 325,600 375,000 Retirement Benefits 74,266 78,035 163,800 175,700 Insurance Benefits 78,267 85,131 0 0 Acounting Loss/Debt Refinancing 0 0 0 0 Software Supplies 329 1,983 0 0 Minor Equipment 355 3,000 3,000 Office Supplies/Equipment 3,824 4,408 5,700 5,800 Postage 23,880 22,558 66,000 66,000 Computer Charges 47,500 47,500 47,500 34,700 Telephone 688 783 1,400 1,400 Misc Fixed Charges 0 0 0 Contractual Services 6,305 8,387 39,400 40,900 Car Allowance 389 281 300 300 Maintenance Office Equipment 9,103 10,737 13,300 13,500 Professional Services 0 0 0 0 Advertising/Marketing 0 0 1,500 500 Other Supplies 0 0 0 0 Audit 5,938 4,638 5,500 6,600 Insurance 9,468 17,538 5,700 5,300 Uncollectable Accounts 4,210 4,040 4,200 4,200 Depreciation (826) 2,655 2,700 2,700 Bond Issue Expense 78,220 59,937 1,999,500 2,145,900 Bond Service Fees 850 450 900 900 Bank Fees 7,940 4,140 0 0 GASB 68 Pension Exp 0 0 0 0 Conference&Training 1,082 73 700 600 Dues 882 390 700 700 TOTAL GENERAL&ADMINISTRATIVE 695,198 628,948 2,545,534 2,687,400 2,682,550 2,883,700 METER READING -1951 Labor 0 0 0 0 Retirement Benefits 0 0 0 0 Insurance Benefits 0 0 0 0 Meter Repairs 369,672 378,442 390,000 390,000 GASB 68 Pension Exp 156,664 131,354 132,000 132,000 Office Supplies 22,742 30,676 50,000 50,000 Car Allowance 0 0 0 Insurance 0 0 0 0 TOTAL METER READING 549,078 540,472 468,356 572,000 572,000 572,000 PRETREATMENT PROGRAM-1955 Professional Services 135,558 68,510 54,000 54,000 Licenses&Permits 0 0 100 100 Maint Computer 1,230 1,265 1,300 1,300 Conference/Training 0 0 0 100 Safety Equipment 0 0 0 0 Office Supplies 25 336 100 100 TOTAL PRETREATMENT PROGRAM 136,814 70,111 45,949 55,500 55,700 55,600 TY2020 Sewer Rate Study City of Oshkosh,WI rZk4EHLERS Prepared 1/23/2020 Page 9 ft LEADERS IN PULL C FINANCE J �GD zR OV IL cn co 0 co IL 00000000000000000 0000000000000000000 00000000000000 ----------------- 0000000000000000000 �������o�00000 00000000000000000 00 00000 0 0 0000000 0 0---------------- 00000 000 0 0000000 000000 IL IL co LL 00000 0000 0 00000000000000 00000 000 0 0000000 000000 o0000 000 0 0000000 000000 • ���oo 000 � ������� �00000 00000 0000 0 00000000000000 00000000000000000 00 00000 0 0 O o)LL = lo a0+ Y ¢ to - a a o oo L F. m U ` u m o � U O ti °' � `�o°w wdEVO ,� � � � m � d V mm-� �_ o o �- �.�-� �' o r ma nn m 0' mm n n "3 O w n u- w�j a.o.o °s in in o u > o C oaO o b m��a u- _ d o o.°s°s...9 d u d E_ `°a o m .. m a� E a 3 w o- t0 `o w t- o a a `° o oo La •� `�°�=U�22m'�U 2 °�'oin in in 05 o � `�°m 08 a°a`�00�U�io i5 ina-o o `��°� _m O(7=U c) ono n N V It, O O O O d T N �i�a` V� 1 cn cli co IL 000000000 000000000000000 00000000000 000000000000000 000 oo���0000 000000000000000 00000000000 000000000000000 ��� 000 000 000000000 00000 000000000 00000000000 000000000000000 000 cu CL 000000000 000000000000000 00000000000 000000000000000 000 IL 000000000 00000 000000000 00000000000 000000000000000 000 , 000000000 00000 000000000 00000000000 000000000000000 000 • mm...o�Mm ...M� . mmmmmmmmmmm ............... mmm � MM���M�M ���M� ��MMM��� MMMMMMMMMM �������������� --- 000000000 000000000000000 00000000000 000000000000000 000 co .12 i2m 000 a O u i m co � Om do _ m —n E = - O E >uOiLL d $ c nf o 1 c P 9co m o � ( 0UOc U o i o 0� co `o w U m=C J 3$C �O m o`o T N �i�a` V$ 1 W cn co co co N mm. I F» N _ _ _ _ _ 0) w d 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 v vvvvvvvvvvvvvvvvvvv n n n n n n n v r�r� r�r�r�r� 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -------------------- -------------------- v vvvvvvvvvvvvvvvvvvv n n n n n n n co vv n n n n w IL IL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o N 0 T W 0-------------------co _a LL -------------------- 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o U v v v v v v N O c O 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o f0 N N O y N t0 U c m c � O E w n E `° U in c°',O d _ ,s m =o- oo c o a o a d E .. J a E ? o Oan O � - ` � o�'n '^a 1ma` o�aEU � n c �U c min� � o c U LLj o "c=i in '^in d an d '-�-o E m in o d U d w a� o - p c U LL7L `��°Q m m m o LL m w `° o m ? E m "w m a` o '� rc o p a `o o o°' '^ o ._° > °' Q o a Q m m o o o w w m 41 U a _ O d E t m OOaUFUU�a`�¢OQ���m(7Uo o ����C90U o �a`�m�UigO o O Au =U c ��np z 3$C O O m o`o T N �i�a` �§ �§ �< �( � \�\\\ �\ LL UP co )m . (;[/§} /\&&\» : \\\\\ ) 2 IL co LL 2 IL \ ( \\ \ mo , \\\) {}co 1E \ 3=e:: §{§ U Ke! Table 6 Date Comoutatlon Worksheet AP shkosh city of oshkosh, WT City . Rates Charges (Annual) Charge Type Costs Billable Units City Rate Customer Charge 1,703,253 23,499 $72.48 Meter/Connection Charge 1,611,007 30,631 $52.59 Equiv Meter/Connection Customer Total Meter Size Ratio Charge Charge Fixed Charge 5/8" 1 $52.59 $72.48 $125.08 3/4" 1 $52.59 $72.48 $125.08 1" 2.5 $131.49 $72.48 $203.97 11/4" 3.75 $197.23 $72.48 $269.71 1 1/2" 5 $262.97 $72.48 $335.46 2" 8 $420.76 $72.48 $493.24 3" 15 $788.92 $72.48 $861.40 4" 25 $1,314.87 $72.48 $1,387.35 6" 50 $2,629.74 $72.48 $2,702.22 8" 80 $4,207.59 $72.48 $4,280.07 10" 125 $6,574.36 $72.48 $6,646.84 12" 175 $9,204.10 $72.48 $9,276.58 Volumetric Charges Billable Units Charge Type Cost (Cu. Ft or Ibs) Rate/Unit Flow Charge per 100 CF $2,799,595 2,070,525 $1.35 Conveyance Charge per 100 CF $3,704,167 2,040,000 $1.82 BOD Charge per lb. $2,305,518 3,591,971 $0.64 TSS Charge per lb. $1,900,335 4,154,357 $0.46 P Charge per lb. $751,664 146,409 $5.13 NH3-N Charge per lb. $523,613 381,687 $1.37 BOD Charge per 100 CF $1.00 TSS Charge per 100 CF $0.71 P Charge per 100 CF $0.32 NH3-N Charge per 100 CF $0.21 Total Volumetric Rate per 100 Cu. Ft $5.42 TY2020 Sewer Rate Study City of Oshkosh, WI d** EHLERS Prepared 1/23/2020 Page 14 0 LEADERS IN PUBLIC FINANCE Wastehauler Charges Septic Charges Flow Charge per 100 Cu. Ft $1.35 BOD Charge per 100 Cu. Ft $36.04 TSS Charge per 100 Cu. Ft $42.80 P Charge per 100 Cu Ft. $9.61 NH3-N Charge per 100 Cu. Ft $1.28 Total $91.08 Holding Tank Charges Flow Charge per 100 Cu. Ft $1.35 BOD Charge per 100 Cu. Ft $2.00 TSS Charge per 100 Cu. Ft $2.28 P Charge per 100 Cu Ft. $0.64 NH3-N Charge per 100 Cu. Ft $0.43 Total $6.71 Porta Potty Waste Charges Flow Charge per 100 Cu. Ft $1.35 BOD Charge per 100 Cu. Ft $18.02 TSS Charge per 100 Cu. Ft $25.68 P Charge per 100 Cu Ft. $8.01 NH3-N Charge per 100 Cu. Ft $0.86 Total $53.92 Mixed Load Waste Charges Flow Charge per 100 Cu. Ft $1.35 BOD Charge per 100 Cu. Ft $3.60 TSS Charge per 100 Cu. Ft $2.57 P Charge per 100 Cu Ft. $1.44 NH3-N Charge per 100 Cu. Ft $1.07 Total $10.04 Rate Summary City (Inside) Fixed charge per connection $125.08 Rate per 100 Cu. Ft $5.42 BOD rate per lb. $0.642 TSS rate per lb. $0.457 P rate per lb. $5.134 NH3-N Charge per lb. $1.372 TY2020 Sewer Rate Study City of Oshkosh, WI d** EHLERS Prepared 1/23/2020 Page 15 0 LEADERS IN PUBLIC FINANCE Table 7 Rate Summary Oshkosh city of oshkosh, WT Monthly Charges 2020 Current Cos Proposed City (Inside) Meter Size 5/8" $9.66 $10.42 $10.42 3/4" $9.66 $10.42 $10.42 1" $16.19 $17.00 $17.47 1 1/4" $21.63 $22.48 $23.34 1 1/2" $27.07 $27.95 $29.21 2" $40.13 $41.10 $43.30 3" $70.59 $71.78 $76.17 4" $114.12 $115.61 $123.13 6" $222.92 $225.19 $240.53 8" $363.48 $356.67 $392.19 10" $549.33 $553.90 $592.72 12" $766.94 $773.05 $827.52 Volumetric Rate per 100 Cu. Ft $5.22 $5.42 $5.42 BOD rate per lb. $0.621 $0.642 $0.642 TSS rate per lb. $0.425 $0.457 $0.457 P rate per lb. $4.910 $5.134 $5.134 NH3-N rate per lb. $1.324 $1.372 $1.372 Unmetered quarterly flat charge $32.34 $54.17 $54.17 Wastehauler Septic Rate per 100 Cu. Ft $120.41 $91.08 $120.41 Chemical Toilet Rate per 100 Cu. Ft $71.63 $53.92 $71.63 Mixed Load Rate per 100 Cu. Ft $8.90 $10.04 $10.04 Holding Tank Rate per 100 Cu. Ft $8.80 $6.71 $8.80 TY2020 Sewer Rate Study City of Oshkosh, WI d** EHLERS Prepared 1/23/2020 Page 16 0 LEADERS IN PUBLIC FINANCE Table 8 Revenue Check (Based on COS) WwOshkosh City of oshkos& W-1 TotalAnnual Units Rate Fixed Charge Meter Size 5/8" 9,999 $10.42 $ 1,250,642.81 3/4" 12,029 $10.42 $ 1,504,548.70 1" 753 $17.00 $ 153,588.71 1 1/4" 0 $22.48 $ - 11/2" 293 $27.95 $ 98,288.67 2" 285 $41.10 $ 140,573.61 3" 88 $71.78 $ 75,803.62 4" 42 $115.61 $ 58,268.84 6" 8 $225.19 $ 21,617.80 8" 1 $356.67 $ 4,280.07 10" 1 $553.90 $ 6,646.84 12" 0 $773.05 $ - Subtotal 23,499 $ 3,314,259.65 Volumetric Charges-Inside Customers Residential Flow(CCF) 950,000 $5.42 $5,145,707 Commercial Flow(CCF) 375,000 $5.42 $2,031,200 Industrial Flow(CCF) 150,000 $5.42 $812,480 Multi-Family Flow(CCF) 230,000 $5.42 $1,245,803 Public Flow(CCF) 335,000 $5.42 $1,814,539 Septic Waste Haulers Flow(CCF) 143 $91.08 $13,025 Chemical Toilet Waste Haulers Flow(CCF) 281 $53.92 $15,150 Mixed Load Flow(CCF) 20,130 $10.04 $202,005 Holding Tank Waste Haulers Flow(CCF) 9,971 $6.71 $66,860 Subtotal 2,070,525 $11,346,769 High Strength Industial Industrial Excess BOD Lbs 250,390 $0.642 $160,714 Industrial Excess TSS Lbs 780,874 $0.457 $357,197 Industrial Excess P Lbs 11,547 $5.134 $59,281 Industrial Excess NH3-N Lbs 44,416 $1.372 $60,932 Subtotal 1,087,227 $638,123 Unmetered Customers customers 0 $54.17 $0 Volumetric Charges-Outside Customers Residential Flow(000 gal) 0 $5.42 $0 Commercial & Multiple Flow(000 gal) 0 $5.42 $0 Industrial Flow(000 gal) 0 $5.42 $0 Subtotal $0 Total Revenues $15,299,151 Revenue Requirements $15,299,151 Difference $0 TY2020 Sewer Rate Study �" E H L E RS City of Oshkosh, WI Prepared 1/23/2020 Page 17 LEADERS IN 2USLIC FINANCE Table 9 Revenue Summary (Proposed Rates) �&oshkosh city of oshkosf; Wr Annual Units Rate Total Fixed Charge Meter Size 5/8" 9,999 $10.42 $ 1,250,642.81 3/4" 12,029 $10.42 $ 1,504,548.70 1" 753 $17.47 $ 157,848.85 1 1/4" 0 $23.34 $ - 11/2" 293 $29.21 $ 102,696.46 2" 285 $43.30 $ 148,085.87 3" 88 $76.17 $ 80,431.37 4" 42 $123.13 $ 62,059.84 6" 8 $240.53 $ 23,090.78 8" 1 $392.19 $ 4,706.31 10" 1 $592.72 $ 7,112.67 12" 0 $827.52 $ - Subtotal 23,499 $ 3,341,223.66 Volumetric Charges-Inside Customers Residential Flow (CCF) 950,000 $5.42 $5,145,707 Commercial Flow (CCF) 375,000 $5.42 $2,031,200 Industrial Flow (CCF) 150,000 $5.42 $812,480 Multi-Family Flow (CCF) 230,000 $5.42 $1,245,803 Public Flow (CCF) 335,000 $5.42 $1,814,539 Septic Waste Haulers Flow (CCF) 143 $120.41 $17,218 Chemical Toilet Waste Haulers Flow (CCF) 281 $71.63 $20,128 Mixed Load Flow (CCF) 20,130 $10.04 $202,005 Holding Tank Waste Haulers Flow (CCF) 9,971 $8.80 $87,765 Subtotal 2,070,525 $11,376,843 High Strength Industrial Industrial Excess BOD Lbs 250,390 $0.642 $160,714 Industrial Excess TSS Lbs 780,874 $0.457 $357,197 Industrial Excess P Lbs 11,547 $5.134 $59,281 Industrial Excess NH3-N Lbs 44,416 $1.372 $60,932 Subtotal 1,087,227 $638,123 Total Revenues $16,366,190 Revenue Requirements $16,299,161 Difference $67,039 TY2020 Sewer Rate Study City of Oshkosh, WI d** EHLERS Prepared 1/23/2020 Page 18 0 LEADERS IN PUBLIC FINANCE Table 10 Test Year Cash Flow Analysis Wr Oshkosh city of oshkosf; Wr Cash Sources Revenues from User Rates $15,980,599 Other Income (2) $199,800 Investment Income on Unrestricted Cash $377,300 Total Cash Sources $16,557,699 Cash Uses O&M $7,010,300 Net Before Debt Service $9,547,399 Debt Service G.O. Debt Service P&I $1,154,193 Revenue Debt Service P&I $5,612,318 Total Debt Service $6,766,511 Capital Outlay (non reserve) (4) $0 Addition to Replacement Fund (3) $25,000 Net Cash Flow $2,755,889 Unrestricted Cash Balances Beginning Year Est. Balance $8,287,331 Net Additions $2,755,889 End of Year Balance $11,043,219 Notes: (1) Revenues from user rates plus revenues from Sanitary Districts plus pre-treatment sampling. (2) Miscellaneous revenue and late fees. (3)Addition to Replacement Fund made after year end to ensure fund is above the minimum required balance of$1,895,004. (4)Amount of cash on hand City plans to use to offset the proposed 2018 borrowing for the sewer utility. TY2020 Sewer Rate Study City of Oshkosh, Wl g*4EHLERS Prepared 1/23/2020 Page 19 W LEADERS IN PUBLIC FINANCE Table 11 Comparison of Exisitng and Proposed Bills for Sample Customers AOShkoSh City of Oshkosh, WT ProposedMonthly Usage Current Customer Usage Meter Size 00 CF) Bill Bill Change Residential Low 3/4" 1.00 $14.88 $15.84 6.4% Residential Average 3/4" 4.34 $32.34 $33.95 5.0% Residential High 3/4" 8.00 $51.42 $53.76 4.5% Commercial Low 3/4" 8.00 $51.42 $53.76 4.5% Commercial Average 2" 10.70 $95.96 $101.23 5.5% Commercial High 6" 20.00 $327.32 $348.86 6.6% Industrial Low V. 20.00 $120.59 $125.80 4.3% Industrial Average 2" 33.42 $214.60 $224.33 4.5% Industrial High 4" 50.00 $375.12 $393.96 5.0% Public Low V. 8.00 $57.95 $60.80 4.9% Public Average Y 10.70 $126.42 $134.10 6.1% Public High 10" 20.00 $653.73 $701.05 7.2% TY2020 Sewer Rate Study �" E H L E R� City of Oshkosh,WI Prepared 1/23/2020 Page 20 0 LEADERS IN Pur.LIC FINANCE Table 12 Summary Budget for Sanitary Districts A Oshkosh City of Oshkosh, WI Test Year Treatment Plant 3,627,300 3,716,200 3,909,800 3,639,192 3,825,600 4,076,700 Maintenance 985,400 1,030,733 928,400 1,153,120 1,263,100 1,239,000 Solids 1,001,800 937,700 956,000 1,084,785 1,177,600 1,180,700 Laboratory 117,800 117,100 118,500 119,590 131,700 132,300 Annual Audit 6,500 7,000 6,500 0 5,500 6,600 Office Rental 0 0 0 0 0 0 Professional Services-Consultants 0 0 0 0 0 0 Total O&M Plus Depreciation 5,738,800 5,808,733 5,919,200 5,996,687 6,403,500 6,635,300 Depreciation 1,461,200 1,488,700 1,712,700 1,701,400 1,701,400 1,973,300 O&M Only 4,277,600 4,320,033 4,206,500 4,295,287 4,702,100 4,662,000 PointTest Year Summary for Black Wolf,Sunset Treatment Plant 3,627,300 3,716,200 3,909,800 3,639,192 3,825,600 4,076,700 Sanitary Sewers 1,997,400 2,086,400 2,252,400 2,282,744 2,483,164 2,617,800 Pumping Stations 528,000 544,500 543,300 618,750 628,200 551,700 Maintenance 985,400 1,030,733 928,400 1,153,120 1,263,100 1,239,000 Solids 1,001,800 937,700 956,000 1,084,785 1,177,600 1,180,700 Laboratory 117,800 117,100 118,500 119,590 131,700 132,300 Annual Audit 6,500 7,000 6,500 0 5,500 6,600 Office Rental 0 0 0 0 0 0 Professional Services-Consultants 0 0 0 0 0 0 Replacement Costs 0 0 0 0 0 0 Total O&M Plus Depreciation 8,264,200 8,439,633 8,714,900 8,898,181 9,514,864 9,804,800 Depreciation 2,954,200 2,981,700 3,309,400 3,728,500 1,701,400 4,149,700 O&M Only 5,310,000 5,457,933 5,405,500 5,169,681 7,813,464 5,655,100 O&M plus Replacement 5,310,000 5,457,933 5,405,500 5,169,681 7,813,464 5,655,100 Notes: Source:2014 Sanitary Sewer User Rate Study for the City of Oshkosh and adopted budget for 2020. TY2020 Sewer Rate Study City of Oshkosh,Wl r=EHLERS Prepared 1/23/2020 Page 21 Lff"� IN F-1 F1nANC® Table 13 Historical Influent Data at Wastewater Treatment Facility AvOshkosh city of oshkosh, WT Year Total Purnpage 000 2013 4,549.19 2014 4,644.16 2015 4,265.31 2016 4,491.41 2017 4,537.97 2018 4,672.22 2019 Annualized 5,102.32 2020 Test Year Projection 4,700.00 TY2020 Sewer Rate Study City of Oshkosh, Wl g*4EHLERS Prepared 1/23/2020 Page 22 M LEADERS IN PUBLIC FINANCE Table 14 a Contract Customer Historical Monthly Flows (1,000 Gal) Oshkosh City of Oshkosh, DWI Algoma Sunset Black Island ... Month-Yr Total Total Wolf View Shangri-La Jan-16 15,660.5 848.1 3,424.4 1,444.8 Feb-16 15,863.3 1,431.0 3,755.4 1,493.2 Mar-16 24,647.1 1,835.6 6,818.2 2,265.5 695.0 Apr-16 19,318.5 1,237.8 4,617.6 1,600.7 May-16 17,884.3 698.7 4,116.8 1,760.2 Jun-16 19,110.3 419.2 4,231.6 1,847.1 744.0 Jul-16 12,742.3 282.6 2,906.4 1,306.6 Aug-16 14,005.8 282.6 3,031.1 1,385.4 Sep-16 16,312.5 345.5 3,437.0 1,576.7 874.0 Oct-16 13,484.6 285.1 2,811.3 1,297.1 Nov-16 14,617.0 334.4 3,056.6 1,461.8 Dec-16 14,523.2 373.7 3,217.9 1,572.7 731.0 Jan-17 19,222.8 502.2 4,416.1 2,027.5 Feb-17 16,736.9 466.5 4,217.5 1,637.5 Mar-17 21,810.7 552.6 5,117.1 1,900.3 677.0 Apr-17 25,758.2 662.4 6,394.2 2,284.8 May-17 19,660.6 507.4 4,392.6 1,629.5 Jun-17 18,380.3 514.5 5,211.9 1,677.6 741.0 Jul-17 18,940.2 469.6 4,348.7 1,655.9 Aug-17 19,011.1 496.7 3,875.4 1,677.6 Sep-17 13,991.4 359.1 2,935.6 1,215.1 813.0 Oct-17 13,122.3 379.7 2,747.3 1,388.5 Nov-17 14,073.7 392.8 2,845.8 888.1 Dec-17 16,607.7 484.3 3,738.9 1,845.9 741.0 Jan-18 12,793.4 506.8 3,164.9 1,553.7 Feb-18 12,242.4 531.4 2,988.2 1,181.1 Mar-18 14,443.4 769.7 3,462.9 1,305.7 648.0 Apr-18 19,416.0 942.2 5,535.4 1,726.7 May-18 24,716.7 1,047.0 7,242.4 1,842.0 Jun-18 16,899.8 542.1 4,438.0 1,421.5 763.0 Jul-18 14,415.6 440.9 3,466.9 1,321.6 Aug-18 14,915.7 532.9 3,844.8 1,467.4 Sep-18 18,361.2 645.6 4,836.5 1,688.9 852.0 Oct-18 25,417.2 715.4 6,646.5 2,165.4 Nov-18 9,509.3 313.5 1,574.1 874.8 Dec-18 16,186.9 516.3 3,086.5 1,445.0 779.0 Jan-19 18,681.2 611.1 4,641.6 1,626.6 Feb-19 14,395.2 565.3 2,455.6 1,388.4 Mar-19 21,065.6 1,004.0 5,887.9 2,166.3 679.0 Apr-19 20,296.3 1,016.7 5,087.6 1,552.2 May-19 21,299.9 918.4 5,806.3 1,649.7 Jun-19 18,760.6 667.1 5,233.0 1,558.4 793.0 Jul-19 19,371.6 589.6 5,009.0 1,533.4 Aug-19 17,153.1 508.4 4,015.0 1,493.2 Sep-19 15,429.9 485.4 4,258.7 1,577.7 897.0 2016 Total Flows 198,169.4 8,374.2 45,424.3 19,011.9 3,044.0 2017 Total Flows 217,315.9 5,787.6 50,241.0 19,828.4 2,972.0 2018 Total Flows 199,317.5 7,503.7 50,287.1 17,993.8 3,042.0 Last 12 Months Flows 217,566.8 7,911.1 53,701.8 19,031.2 3,148.0 Total of WWTP Flow 4.63% 0.17% 1.14% 0.40% 0.07% Notes: Source: Historical data provided by the City of Oshkosh. TY2020 Sewer Rate City of Oshkosh,WI Study f�NEHLERS Prepared 1/23/2020 page 23 LEADERS IN PUBL c FINANCE Table 15 C 2020 Estimated Charge to the WwOshkosh A.',GOMA SANITARY DISTRICT city of f osh osk W, SANITARYALGOMA - ICT A. Demand Cost Treatment Plant 4,076,700 + Maintenance 1,239,000 + Solids 1,180,700 + Laboratory 132,300 + Annual Audit 6,600 + Office Rental 0 + Professional Services- Consultants 0 TOTAL 6,635,300 - Depreciation 1,973,300 NET 4,662,000 x 15.00% = Result 699,300 x 5.00% = 34,965.00 B. Flow Cost Treatment Plant 4,076,700 + Maintenance 1,239,000 + Solids 1,180,700 + Laboratory 132,300 + Annual Audit 6,600 + Office Rental 0 + Professional Services- Consultants 0 TOTAL 6,635,300 - Depreciation 1,973,300 NET 4,662,000 x 85.00% = Result 3,962,700 x 4.63% = 183,436.59 C. Depreciation Depreciation 1,973,300 x 5.00% = 98,665.00 TOTAL CHARGE TO DISTRICT 317,066.59 TY2020 Sewer Rate Study City of Oshkosh, WI d*4EHLERS Prepared 1/23/2020 Page 24 0 LEADERS IN PUBLIC FINANCE Table 16 2020 Estimated Charge to the ArOshkosh BLACK WOLF SANITARY DISTRICT NO. 1 City of osfkoA W1 BLACK WOLF SANITARY DISTRICT NO. A. Demand Cost Treatment Plant 4,076,700 + Sanitary Sewers 2,617,800 + Pumping Stations 551,700 + Maintenance 1,239,000 + Solids 1,180,700 + Laboratory 132,300 + Annual Audit 6,600 + Office Rental 0 + Professional Services- Consultants 0 TOTAL 9,804,800 - Depreciation 3,309,400 NET 6,495,400 x 15.00% = Result 974,310 x 1.10% = 10,717.41 B. Flow Cost Treatment Plant 4,076,700 + Sanitary Sewers 2,617,800 + Pumping Stations 551,700 + Maintenance 1,239,000 + Solids 1,180,700 + Laboratory 132,300 + Annual Audit 6,600 + Office Rental 0 + Professional Services- Consultants 0 TOTAL 9,804,800 - Depreciation 3,309,400 NET 6,495,400 x 85.00% = Result 5,521,090 x 1.14% = 63,083.50 C. Depreciation Depreciation 3,309,400 x 1.10% = 36,403.40 TOTAL CHARGE TO DISTRICT 110,204.31 TY2020 Sewer Rate City of Oshkosh,WI Study jg'*%4 E H L E R S Prepared 1/23/2020 Page 25 0 LEADERS IN PUBLIC FINANCE Table 17 2020 Estimated Charge to the AQshkosh SUNSET POINT SANITARY DISTRICT City of oshkvsf; Wr POINTSUNSET A. Demand Cost Treatment Plant 4,076,700 + Sanitary Sewers 2,617,800 + Pumping Stations 551,700 + Maintenance 1,239,000 + Solids 1,180,700 + Laboratory 132,300 + Annual Audit 6,600 + Office Rental 0 + Professional Services- Consultants 0 TOTAL 9,804,800 - Depreciation 4,149,700 NET 5,655,100 x 15.00% = Result 848,265 x 0.17% = 1,442.05 B. Flow Cost Treatment Plant 4,076,700 + Sanitary Sewers 2,617,800 + Pumping Stations 551,700 + Maintenance 1,239,000 + Solids 1,180,700 + Laboratory 132,300 + Annual Audit 6,600 + Office Rental 0 + Professional Services- Consultants 0 TOTAL 9,804,800 - Depreciation 4,149,700 NET 5,655,100 x 85.00% = Result 4,806,835 x 0.17% = 8,090.89 C. Depreciation Depreciation 4,149,700 x 0.17% = 7,054.49 TOTAL CHARGE TO DISTRICT 16,587.43 TY2020 Sewer Rate Study City of Oshkosh,WI jg'*%4 E H L E R S Prepared 1/23/2020 Page 26 0 LEADERS IN PUBLIC FINANCE Table 18 2020 Estimated Charge to the ldwashkosh ISLAND VIEW SANITARY DISTRICT city of oshFosh, Wr ISLAND VIEW SANITARY DISTRICT A. Demand Cost Treatment Plant 4,076,700 + Sanitary Sewers 2,617,800 + Pumping Stations 551,700 + Maintenance 1,239,000 + Solids 1,180,700 + Laboratory 132,300 + Annual Audit 6,600 + Office Rental 0 + Professional Services-Consultants 0 TOTAL 9,804,800 - Depreciation 3,309,400 NET 6,495,400 x 15.00% = Result 974,310 x 0.70% = 6,820.17 B. Flow Cost Treatment Plant 4,076,700 + Sanitary Sewers 2,617,800 + Pumping Stations 551,700 + Maintenance 1,239,000 + Solids 1,180,700 + Laboratory 132,300 + Annual Audit 6,600 + Office Rental 0 + Professional Services-Consultants 0 TOTAL 9,804,800 - Depreciation 3,309,400 NET 6,495,400 x 85.00% = Result 5,521,090 x 0.40% = 22,355.96 C. Depreciation Depreciation 3,309,400 x 0.70% 23,165.80 TOTAL CHARGE TO DISTRICT 52,341.93 TY2020 Sewer Rate Study City of Oshkosh,WI jg'*%4 E H L E R S Prepared 1/23/2020 Page 27 0 LEADERS IN PUBLIC FINANCE Table 19 2020 Estimated Charge to the ldwoshkosh Enrri=vAtr)nn-SHANGRI LA SANITARY DISTRICT city of f osh osk W, EDG • •D RI LA SANITARYDISTRICT A. Demand Cost Treatment Plant 4,076,700 + Sanitary Sewers 2,617,800 + Maintenance 1,239,000 + Solids 1,180,700 + Laboratory 132,300 + Annual Audit 6,600 + Office Rental 0 + Professional Services- Consultants 0 TOTAL 9,253,100 - Depreciation 4,149,700 NET 5,103,400 x 15.00% = Result 765,510 x 0.1050% = 803.79 B. Flow Cost Treatment Plant 4,076,700 + Sanitary Sewers 2,617,800 + Maintenance 1,239,000 + Solids 1,180,700 + Laboratory 132,300 + Annual Audit 6,600 + Office Rental 0 + Professional Services- Consultants 0 TOTAL 9,253,100 - Depreciation 4,149,700 NET 5,103,400 x 85.00% = Result 4,337,890 x 0.0670% = 2,905.46 C. Depreciation Depreciation 0 x 0.1050% = 0.00 TOTAL CHARGE TO DISTRICT 3,709.25 TY2020 Sewer Rate Study City of Oshkosh, WI g*4EHLERS Prepared 1/23/2020 Page 28 N LEADERS IN PUBLIC FINANCE Table 20 2020 Estimated Charges to All Sanitary Districts Oshkosh city of oshkosh, WT 2020 Sanitary District Estimated Charges Algoma Sanitary District $317,066.59 Black Wolf Sanitary District No. 1 $110,204.31 Sunset Point Sanitary District $16,587.43 Island View Sanitary District $52,341.93 Edgewood-Shangri La Sanitary District $3,709.25 Total $499,909.51 TY2020 Sewer Rate Study City of Oshkosh, WI d** EHLERS Prepared 1/23/2020 Page 29 0 LEADERS IN PUBLIC FINANCE