Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
34. 22-308
JULY 12, 2022 22-308 RESOLUTION (CARRIED___6-0_____LOST________LAID OVER________WITHDRAWN________) PURPOSE: APPROVE 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 Sewer Use Charges Fee Schedule included within the attached City of Oshkosh, Wisconsin Cost of Service Sewer Rate Update for 2022 Test year as Table 7 on page 15 is hereby adopted and shall be in full force and effect as of August 1, 2022. Finance Department City Hall, 215 Church Avenue P.O. Box 1130 Oshkosh, WI 54903-1130 920.236.5005 http://www.ci.oshkosh.wi.us TO: Honorable Mayor and Members of the Common Council FROM: Russ Van Gompel, Director of Finance DATE: July 7, 2022 RE: Approve Fee Schedule for Sewer Use Charges BACKGROUND As discussed during the 2022 budget workshops, sewer revenue was budgeted to increase, but that was based on increasing sales estimates. After reviewing sales volume for 2022 and the current increase in expenses, I requested that Ehlers review our rate structure for 2022. Rates need to be increased in 2022 to keep the Utility in a productive capacity, operating at a prudent level. The current rate was last updated as of February 1, 2021. ANALYSIS The increase is needed due to the following reasons: A 5.6% increase in operating and maintenance expenses from 2021 to 2022, The issuance of approximately $14.82 million of sewer revenue bonds in 2022, Capital Improvement Program in 2023 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 9.42% increase to revenues is necessary to fund operations and debt service needs in 2022. FISCAL IMPACT If approved, the effect of the increase on the average residential user on a monthly basis is $3.06, which equates to an 8.7% increase. The annual impact is $36.72. For the impact on other customers, please refer to Table 11 on page 19 of the Ehlers Sewer Rate Study. RECOMMENDATION Staff recommends that Council pass this resolution. Respectfully Submitted, Approved: Russ Van Gompel Mark A. Rohloff Finance Director City Manager BUILDING COMMUNITIES. IT’S WHAT WE DO. June 27, 2022 Sewer User Rate Study Update City of Oshkosh, Wisconsin Cost of Service Sewer Rate Update for a 2022 Test Year Prepared by: Ehlers N21W23350 Ridgeview Pkwy Waukesha, WI 53188 2022 Sanitary Sewer User Rate Study Supporting Worksheets Description Page Page 1 City of Oshkosh Comparison of Sewer User Rates Whitewater 14,889 $12.75 $8.97 $51.67 North Fond Du Lac 5,378 $17.80 $7.41 $49.97 Menomonee Falls 38,527 $23.60 $5.24 $46.32 Waukesha 71,158 $5.91 $8.92 $44.62 Clintonville 4,591 $17.00 $5.42 $40.54 Omro 3,652 $13.78 $5.65 $38.32 Oshkosh - Proposed 66,816 $11.36 $6.18 $38.18 Green Bay 107,395 $11.97 $5.81 $37.18 Waupaca 6,282 $24.21 $2.76 $36.19 Brookfield 41,464 $22.33 $2.96 $35.19 Oshkosh - Current 66,816 $10.79 $5.61 $35.14 Wisconsin Dells 2,942 $8.00 $5.65 $32.54 New London 7,348 $1.33 $6.99 $31.65 Madison 269,840 $15.01 $3.46 $30.03 Stevens Point 25,666 $12.14 $4.09 $29.89 Fond Du Lac 44,678 $12.50 $3.91 $29.47 West Allis 60,325 $18.61 $1.75 $26.21 Sheboygan 49,929 $15.33 $2.16 $24.71 Janesville 65,615 $15.43 $2.12 $24.63 Beloit 36,657 $7.86 $3.68 $23.83 Wausau 39,994 $6.80 $3.11 $20.30 Eau Claire 67,238 $2.34 $3.81 $18.87 Racine 77,816 $6.67 $2.77 $18.69 Milwaukee 577,222 $5.15 $3.10 $18.60 Appleton 75,644 $4.53 $2.04 $13.40 LaCrosse 52,680 $5.00 $1.90 $13.25 Kenosha 99,986 $2.48 $1.99 $11.12 Municipality Population Monthly Connection Charge Volume Charge $$/CCF Monthly Bill 4.34 CCF Prepared by Ehlers 6/27/2022Page 2 Table 1 Comparison of Existing vs. Proposed Rates City of Oshkosh, WI 2022 $% Current Proposed Change Change Domestic Sewerage Customers Monthly Fixed Charge 5/8" $10.79 $11.36 $0.57 5.25% 3/4" $10.79 $11.36 $0.57 5.25% 1" $18.08 $18.30 $0.22 1.24% 1 1/4" $24.16 $24.09 -$0.07 -0.28% 1 1/2" $30.23 $29.88 -$0.35 -1.15% 2" $44.82 $43.77 -$1.05 -2.33% 3" $78.83 $76.19 -$2.64 -3.35% 4" $127.44 $122.50 -$4.94 -3.87% 6" $248.95 $238.28 -$10.67 -4.29% 8" $405.92 $377.22 -$28.70 -7.07% 10" $613.47 $585.62 -$27.85 -4.54% 12" $856.49 $817.17 -$39.32 -4.59% Volumetric Charge per 100 CU. FT. $5.61 $6.18 $0.57 10.22% Monthly flat charge (Based Upon 4.34 CCF/Mo.) $35.16 $38.22 $3.06 8.70% Non Domestic Customers Monthly Facilities Charge Same as Domestic Customers Volumetric Rate Same as Domestic Customers High Strength Industrial Surcharge Rate BOD /lb $0.664 $0.722 $0.06 8.74% Surcharge Rate TSS /lb $0.473 $0.548 $0.08 15.96% Surcharge Rate Phosphorus /lb $5.314 $6.101 $0.79 14.81% Surcharge Rate NH3-N /lb $1.420 $1.589 $0.17 11.93% Hauled Waste Charges Septic Tank Rate per 1,000 gal $93.21 $93.21 $0.00 0.00% Holding Tank Rate per 1,000 gal $6.81 $6.81 $0.00 0.00% Porta Potty Waste Rate per 1,000 gal $55.45 $55.45 $0.00 0.00% Reading/Billing of "Credit" Meter for "Water Only" Usage $1.66 $1.67 $0.01 0.60% Annual Cost for Average Residential User $421.65 $458.32 $36.67 8.70% Monthly Increase $3.06 TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 3 Table 2 Projected Test Year 2022 WWTF Flows and Loadings City of Oshkosh, WI Flow (CCF) BOD (Lbs) TSS (Lbs) P (Lbs) NH3-N (Lbs) Inside Customers Residential 917,000 1,430,135 1,430,135 57,205 143,013 Commercial 340,000 530,257 530,257 21,210 53,026 Multi-Family 222,000 346,227 346,227 13,849 34,623 Industrial 152,000 237,056 237,056 9,482 23,706 Municipal & Public 310,000 483,470 483,470 19,339 48,347 Subtotal Inside Customers 1,941,000 3,027,145 3,027,145 121,086 302,714 High Strength Industrial Axletech - 4 - 5 Bemis 1,085 59,253 - 180 Covanta 93,191 86,592 - 79 Hydrite Chemical - - - 264 JJ Keller 489 1,811 2 - Kingsbury - - - - Oshkosh 333 547 5,343 9,591 782 Oshkosh 500 Waukau 2,377 1,827 371 137 Oshkosh 2737 8,253 7,862 368 1,266 Oshkosh Correctional Inst 1700 64,699 40,133 59 1,948 Oshkosh Correctional Inst 1730 23,649 6,027 - 319 Pepsi Cola 122,227 2,602 60 - Silver Creek Meats 326 - - - Water Filtration Plant - 417,546 18 - Winnebago Co. Landfill - - - 5,650 Winnebago Co. Landfill II- Combined Cells 22,406 361 - 29,591 Subtotal High Strength Industrial Billable 339,249 629,361 10,468 40,220 Wastehaulers Septic Tank Waste 72 4,014 6,691 134 67 Porta Potty Waste 141 3,944 7,888 219 88 Mixed Loads 10,065 56,510 56,510 2,825 7,849 Holding Tank Waste 4,986 15,551 24,881 622 1,555 Subtotal Wastehaulers 15,263 80,019 95,970 3,800 9,558 Wastewater Treatment Facility Total Billable 1,956,263 3,446,413 3,752,476 135,354 352,493 Inflow/Infiltration (I/I)2,293,738 Total WWTF 4,250,000 Total For Rate Calcs 1,956,263 3,446,413 3,752,476 135,354 352,493 TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 4 Table 3 Projected Test Year 2022 Meter Counts City of Oshkosh, WI Meter Size Residential Commerical Multi-Family Industrial Municipal & Public Total 5/8"8,918 272 75 3 7 9,275 3/4"11,255 933 67 17 47 12,319 1"178 317 196 28 29 748 1 1/4" 1 1/2"1 101 145 19 28 294 2"123 68 29 72 292 3"36 2 11 40 89 4"12 8 5 19 44 6"4 3 3 10 8"11 10"11 12" 20,352 1,798 564 112 247 23,073 Meter Size Equiv. Ratio Residential Commerical Multi-Family Industrial Municipal & Public Total 5/8"1 8,918 272 75 3 7 9,275 3/4"1 11,255 933 67 17 47 12,319 1"2.5 445 793 490 70 73 1,870 1 1/4"3.75 - - - - - - 1 1/2"5 5 505 725 95 140 1,470 2"8 - 984 544 232 576 2,336 3"15 - 540 30 165 600 1,335 4"25 - 300 200 125 475 1,100 6"50 - 200 150 - 150 500 8"80 - - - - 80 80 10"125 - - - - 125 125 12"175 - - - - - - 20,623 4,527 2,281 707 2,273 30,410 Total Meters Equivalent Meters TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 5 Table 4 Historical Expenses and 2022 Adopted Budget for Sewer Utility City of Oshkosh, WI 2019 2020 2021 2022 ACTUAL ACTUAL BUDGET BUDGET SANITARY SEWER - 1920 Labor 226,501 242,806 244,100 270,000 Retirement Benefits 13,832 15,274 15,400 16,800 Insurance Benefits 45,920 44,000 48,200 55,900 Contractual Services 84,890 66,906 147,900 152,100 Repairs to Motor Vehicles 11,452 23,033 22,400 22,200 Maint Mach/Equip/Bldg/Struct 15 992 1,000 1,000 Maintenance of Sanitary Sewers 0000 Maint Mach/Equip/Bldg/Struct 0000 Building Rent 550 550 600 600 TV Inspection 0000 Chemicals 0000 Miscellaneous 4,901 679 6,600 17,600 Legal Fees 51,722 79,074 100,000 100,000 Diesel Fuel 20,125 17,346 19,700 22,200 Supplies and Repair Parts 16,127 31,146 30,200 27,500 Sewer Maintenance Supplies 19,313 18,872 27,800 31,600 Safety Equipment 0 1,006 500 500 Stone/Gravel/Concrete/Asphalt 15,970 14,813 20,000 20,000 Depreciation 1,754,621 1,668,501 2,076,000 1,714,700 TOTAL SANITARY SEWER 2,265,938 2,224,998 2,760,400 2,452,700 PUMPING STATIONS - 1930 Labor 107,916 102,407 106,900 85,800 Repair Parts 50,092 24,356 25,300 25,300 Gas & Oil 3,247 1,534 2,600 2,600 Heat 21,736 18,381 30,000 25,000 Equipment Rental 223 0 2,000 2,000 Postage 0 27 100 300 Professional Services 1,507 2,110 2,500 2,500 License & Permit 0000 Office Supplies 410 100 600 700 Other Supplies 0000 Telephone 2,302 3,190 3,000 4,500 Chemicals 41,127 46,378 75,600 70,000 Water 40,487 44,185 42,000 45,300 Sewer 506 560 600 600 Storm Water 17,319 21,519 30,000 32,000 Supplies and Repair Parts 39,992 16,063 35,500 33,800 Power & Light 88,037 86,420 84,400 84,400 Insurance 4,921 4,681 6,600 8,200 Depreciation 358,068 399,897 359,700 443,000 TOTAL PUMPING STATIONS 777,887 771,809 807,400 866,000 DISPOSAL PLANT - 1940 - Liquid Labor 823,685 840,731 874,200 950,700 Retirement Benefits 114,444 118,680 122,700 134,900 Insurance Benefits 203,803 189,861 216,600 242,900 Repair Parts 290,019 180,495 288,100 291,200 Office Supplies 333 388 500 500 Gas & Oil 4,687 5,128 5,000 5,000 Heat 39,798 30,006 54,400 54,400 Chemicals 240,335 284,508 300,000 280,000 Cont Svcs/Eng & Consulting Fees 108,554 174,888 432,600 560,600 Tools 4,616 12,771 12,500 14,000 Other Supplies 16,775 18,636 25,800 20,800 Telephone 1,364 1,469 1,800 2,300 Water 12,558 1,560 26,000 26,000 Storm Water 16,252 8,393 25,300 25,300 Power & Light 548,945 511,285 545,500 545,500 Car Allowance 0 108 300 300 Conference & Training 2,960 3,687 8,500 9,000 Insurance 35,628 40,407 56,400 63,600 Depreciation 1,010,606 1,018,495 1,033,200 1,030,700 Dues 2,875 2,250 3,000 3,500 Equipment Rental 5,877 2,048 6,000 6,000 Clothing 751 834 700 700 Miscellaneous 1,847 2,512 4,200 5,200 Fees & Permits 63,429 42,736 59,700 67,700 TOTAL DISPOSAL PLANT 3,550,145 3,491,875 4,103,000 4,340,800 TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 6 2019 2020 2021 2022 ACTUAL ACTUAL BUDGET BUDGET SOLID DISPOSAL - 1941 Labor 186,949 193,954 202,300 204,900 Retirement Benefits 26,064 27,512 28,700 29,100 Insurance Benefits 39,656 35,964 39,500 40,800 Repair Parts 11,206 25,619 25,000 27,500 Gas & Oil 2,167 0 2,200 2,200 Chemicals 107,701 93,915 87,400 108,000 Insurance 11,871 12,307 16,600 20,400 Contractual Services 99,614 1,028 1,100 1,100 Depreciation 477,570 480,444 474,700 483,400 Maintenance 18,199 11,969 17,000 20,000 Equipment Rental 47 0 100 100 Miscellaneous 251 443 400 400 Special Services 175,781 131,365 147,500 150,000 Uniforms 0 68 100 100 Landfill Fees 0 0 5,000 5,000 Supplies 67,751 39,753 68,600 72,800 TOTAL SOLID DISPOSAL 1,224,828 1,054,341 1,116,200 1,165,800 LABORATORY - 1945 Labor 70,479 73,428 76,400 77,600 Retirement Benefits 9,746 10,325 10,800 10,900 Insurance Benefits 19,909 18,046 19,800 20,300 Repairs 665 786 1,000 1,000 Chemicals 6,436 8,401 10,000 10,000 Other Supplies 338 343 400 400 Insurance 4,484 4,654 6,400 7,900 Depreciation 2,190 2,190 2,300 2,200 Conference & Training 0000 Office Supplies 0 0 100 100 Conference & Prof Training 0 0 100 100 Tools & Shop Supplies 3,542 3,491 11,900 11,900 Professional Services 197 197 200 200 TOTAL LABORATORY 117,985 121,861 139,400 142,600 MAINTENANCE - 1946 Labor 504,513 550,147 571,900 601,300 Retirement Benefits 70,144 77,433 80,500 85,300 Insurance Benefits 109,002 109,810 123,400 126,700 Motor Vehicle Expense 1,727 5,819 5,500 5,100 Contractual Services 3,983 3,795 4,000 4,200 Gas & Oil 15,571 10,337 15,300 14,800 Minor Equipment 0000 Office Supplies 592 0 300 800 Other Supplies 15,064 11,615 15,000 17,200 Repairs/Maint 17,954 28,067 23,300 23,700 Insurance 32,054 34,899 46,500 57,200 Depreciation 272,156 301,219 354,000 306,800 Clothing 384 684 700 600 Miscellaneous 0000 Equipment Rental 185 233 200 200 Landfill Fees 0000 Conference & Training 0000 TOTAL MAINTENANCE 1,043,328 1,134,057 1,240,600 1,243,900 TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 7 2019 2020 2021 2022 ACTUAL ACTUAL BUDGET BUDGET GENERAL & ADMINISTRATIVE - 1950 Labor 442,261 429,523 414,700 422,000 Retirement Benefits 81,679 89,342 91,500 93,500 Insurance Benefits 87,653 89,323 87,700 96,200 Acounting Loss/Debt Refinancing 0000 Software Supplies 0000 Minor Equipment 10,712 2,936 2,000 4,500 Office Supplies/Equipment 8,785 1,884 4,700 5,000 Postage 49,262 55,567 66,000 66,000 Computer Charges 34,674 34,724 34,800 34,900 Telephone 894 930 1,000 1,900 Misc Fixed Charges 0000 Contractual Services 5,067 9,845 40,900 40,900 Car Allowance 262 222 300 300 Maintenance Office Equipment 12,044 17,264 24,400 27,800 Professional Services 0000 Advertising/Marketing 0000 Other Supplies 2,046 (25) 2,000 500 Audit 5,284 7,920 8,000 8,000 Insurance 22,817 25,808 7,200 8,800 Uncollectable Accounts 6,313 309 4,200 4,200 Depreciation 2,143 14,065 2,700 2,700 Bond Issue Expense 2,077,782 1,876,221 2,302,000 2,047,000 Bond Service Fees 1,450 950 900 900 Bank Fees 0000 GASB 68 Pension Exp 0000 Conference & Training 150 0 600 600 Dues 430 460 600 600 TOTAL GENERAL & ADMINISTRATIVE 2,851,707 2,657,270 3,096,200 2,866,300 METER READING - 1951 Labor 0000 Retirement Benefits 0000 Insurance Benefits 0000 Meter Repairs 366,520 369,796 390,000 390,000 GASB 68 Pension Exp 232,883 14,458 195,700 214,000 Office Supplies 22,944 58,039 50,000 50,000 Car Allowance 0000 Insurance 0000 TOTAL METER READING 622,346 442,292 635,700 654,000 PRETREATMENT PROGRAM - 1955 Professional Services 32,577 34,562 54,000 60,000 Licenses & Permits 0000 Maint Computer 0 2,720 1,400 1,400 Conference/Training 209 0 200 200 Safety Equipment 0000 Office Supplies 46 0 100 100 TOTAL PRETREATMENT PROGRAM 32,832 37,282 55,700 61,700 TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 8 Table 5 Allocation of Costs to Function City of Oshkosh, WI Conv Flow BOD TSS P NH3-N Cst Cnn 2022 Budget Conveyance System Flow BOD TSS P NH3-N Billing Meter/Conn Operating & Maintenance Sanitary Sewer Labor 80%10% 10%$270,000 $216,000 $0 $0 $0 $0 $0 $27,000 $27,000 Retirement Benefits 80%10% 10%$16,800 $13,440 $0 $0 $0 $0 $0 $1,680 $1,680Insurance Benefits 80%10% 10%$55,900 $44,720 $0 $0 $0 $0 $0 $5,590 $5,590 Contractual Services 80%10% 10%$152,100 $121,680 $0 $0 $0 $0 $0 $15,210 $15,210 Repairs to Motor Vehicles 80%10% 10%$22,200 $17,760 $0 $0 $0 $0 $0 $2,220 $2,220 Maintenance of Sanitary Sewers 80%10% 10%$0 $0 $0 $0 $0 $0 $0 $0 $0 Maint Mach/Equip/Bldg/Struct 80%10% 10%$0 $0 $0 $0 $0 $0 $0 $0 $0Building Rent 80%10% 10%$600 $480 $0 $0 $0 $0 $0 $60 $60 TV Inspection 80%10% 10%$0 $0 $0 $0 $0 $0 $0 $0 $0 Chemicals 80%10% 10%$0 $0 $0 $0 $0 $0 $0 $0 $0 Miscellaneous 80%10% 10%$17,600 $14,080 $0 $0 $0 $0 $0 $1,760 $1,760 Legal Fees 80%10% 10%$100,000 $80,000 $0 $0 $0 $0 $0 $10,000 $10,000Diesel Fuel 80%10% 10%$22,200 $17,760 $0 $0 $0 $0 $0 $2,220 $2,220 Supplies and Repair Parts 80%10% 10%$27,500 $22,000 $0 $0 $0 $0 $0 $2,750 $2,750 Sewer Maintenance Supplies 80%10% 10%$31,600 $25,280 $0 $0 $0 $0 $0 $3,160 $3,160 Safety Equipment 80%10% 10%$500 $400 $0 $0 $0 $0 $0 $50 $50 Stone/Gravel/Concrete/Asphalt 80%10% 10%$20,000 $16,000 $0 $0 $0 $0 $0 $2,000 $2,000Subtotal Sanitary Sewer $738,000 $590,400 $0 $0 $0 $0 $0 $73,800 $73,800 Pumping Stations Labor 80%10% 10%$85,800 $68,640 $0 $0 $0 $0 $0 $8,580 $8,580 Repair Parts 80%10% 10%$25,300 $20,240 $0 $0 $0 $0 $0 $2,530 $2,530Gas & oil 43% 25% 22% 5% 5%0%$2,600 $0 $1,118 $650 $572 $130 $130 $0 $0 Gas & oil 43% 25% 22% 5% 5%0%$0 $0 $0 $0 $0 $0 $0 $0 $0 Heat 43% 25% 22% 5% 5%0%$25,000 $0 $10,750 $6,250 $5,500 $1,250 $1,250 $0 $0 Equipment Rental 32% 30% 26% 7% 5%0%$2,000 $0 $640 $600 $520 $140 $100 $0 $0 Postage 32% 30% 26% 7% 5%0%$300 $0 $96 $90 $78 $21 $15 $0 $0Professional Services 80%10% 10%$2,500 $2,000 $0 $0 $0 $0 $0 $250 $250 License & Permit 80%10% 10%$0 $0 $0 $0 $0 $0 $0 $0 $0 Office Supplies 80%10% 10%$700 $560 $0 $0 $0 $0 $0 $70 $70 Other Supplies 80%10% 10%$0 $0 $0 $0 $0 $0 $0 $0 $0 Telephone 80%10% 10%$4,500 $3,600 $0 $0 $0 $0 $0 $450 $450Chemicals57%43%0%$70,000 $0 $39,900 $0 $0 $30,100 $0 $0 $0 Water 32% 30% 26% 7% 5%0%$45,300 $0 $14,496 $13,590 $11,778 $3,171 $2,265 $0$0 Sewer 32% 30% 26% 7% 5%0%$600 $0 $192 $180 $156 $42 $30 $0 $0 Storm Water 32% 30% 26% 7% 5%0%$32,000 $0 $10,240 $9,600 $8,320 $2,240 $1,600 $0 $0 Supplies and Repair Parts 80%10% 10%$33,800 $27,040 $0 $0 $0 $0 $0 $3,380 $3,380Power & Light 43% 25% 22% 5% 5%0%$84,400 $0 $36,292 $21,100 $18,568 $4,220 $4,220 $0 $0 Insurance 80%10% 10%$8,200 $6,560 $0 $0 $0 $0 $0 $820 $820 Subtotal Pumping Stations $423,000 $128,640 $113,724 $52,060 $45,492 $41,314 $9,610 $16,080 $16,080 Disposal PlantLabor 33% 25% 22% 5% 5% 5% 5%$950,700 $0 $313,731 $237,675 $209,154 $47,535 $47,535 $47,535 $47,535 Retirement Benefits 33% 25% 22% 5% 5% 5% 5%$134,900 $0 $44,517 $33,725 $29,678 $6,745 $6,745 $6,745 $6,745 Insurance Benefits 33% 25% 22% 5% 5% 5% 5%$242,900 $0 $80,157 $60,725 $53,438 $12,145 $12,145 $12,145 $12,145 Repair Parts 33% 25% 22% 5% 5% 5% 5%$291,200 $0 $96,096 $72,800 $64,064 $14,560 $14,560 $14,560 $14,560 Office Supplies 33% 25% 22% 5% 5% 5% 5%$500 $0 $165 $125 $110 $25 $25 $25 $25Gas & Oil 33% 25% 22% 5% 5% 5% 5%$5,000 $0 $1,650 $1,250 $1,100 $250 $250 $250 $250 Heat 33% 25% 22% 5% 5% 5% 5%$54,400 $0 $17,952 $13,600 $11,968 $2,720 $2,720 $2,720 $2,720 Chemicals 57%43%0%$280,000 $0 $159,600 $0 $0 $120,400 $0 $0 $0 Cont Svcs/Eng & Consult Fees 33% 25% 22% 5% 5% 5% 5%$560,600 $0 $184,998 $140,150 $123,332 $28,030 $28,030 $28,030 $28,030 Tools 32% 30% 26% 7% 5%0%$14,000 $0 $4,480 $4,200 $3,640 $980 $700 $0 $0Other Supplies 32% 30% 26% 7% 5%0%$20,800 $0 $6,656 $6,240 $5,408 $1,456 $1,040 $0 $0 Telephone 32% 30% 26% 7% 5%0%$2,300 $0 $736 $690 $598 $161 $115 $0 $0 Water 32% 30% 26% 7% 5%0%$26,000 $0 $8,320 $7,800 $6,760 $1,820 $1,300 $0 $0 Storm Water 32% 30% 26% 7% 5%0%$25,300 $0 $8,096 $7,590 $6,578 $1,771 $1,265 $0 $0 Allocation Percentages WWTF Customer TY2022 Sewer Rate Study City of Oshkosh, WIPrepared 6/27/2022 Page 9 Conv Flow BOD TSS P NH3-N Cst Cnn 2022 Budget Conveyance System Flow BOD TSS P NH3-N Billing Meter/Conn Allocation Percentages WWTF Customer Power & Light 33% 34% 21% 5% 7%0%$545,500 $0 $180,015 $185,470 $114,555 $27,275 $38,185 $0 $0 Car Allowance 33% 34% 21% 5% 7%0%$300 $0 $99 $102 $63 $15 $21 $0 $0 Conference & Training 33% 25% 22% 5% 5% 5% 5%$9,000 $0 $2,970 $2,250 $1,980 $450 $450 $450 $450 Insurance 33% 25% 22% 5% 5% 5% 5%$63,600 $0 $20,988 $15,900 $13,992 $3,180 $3,180 $3,180 $3,180Dues33% 25% 22% 5% 5% 5% 5%$3,500 $0 $1,155 $875 $770 $175 $175 $175 $175 Equipment Rental 32% 30% 26% 7% 5%0%$6,000 $0 $1,920 $1,800 $1,560 $420 $300 $0 $0 Clothing 43% 25% 22% 5% 5%0%$700 $0 $301 $175 $154 $35 $35 $0 $0 Miscelleneous 33% 34% 21% 5% 7%0%$5,200 $0 $1,716 $1,768 $1,092 $260 $364 $0$0 Fees & Permits 33% 34% 21% 5% 7%0%$67,700 $0 $22,341 $23,018 $14,217 $3,385 $4,739 $0 $0Subtotal Disposal Plant $3,310,100 $0 $1,158,659 $817,928 $664,211 $273,793 $163,879 $115,815 $115,815 Solid Disposal Labor 43% 25% 22% 5% 5%0%$204,900 $0 $88,107 $51,225 $45,078 $10,245 $10,245 $0 $0 Retirement Benefits 43% 25% 22% 5% 5%0%$29,100 $0 $12,513 $7,275 $6,402 $1,455 $1,455 $0 $0Insurance Benefits 43% 25% 22% 5% 5%0%$40,800 $0 $17,544 $10,200 $8,976 $2,040 $2,040 $0 $0 Repair Parts 33% 34% 21% 5% 7%0%$27,500 $0 $9,075 $9,350 $5,775 $1,375 $1,925 $0 $0 Gas & Oil 43% 25% 22% 5% 5%0%$2,200 $0 $946 $550 $484 $110 $110 $0 $0 Chemicals 57%43%0%$108,000 $0 $61,560 $0 $0 $46,440 $0 $0 $0 Insurance 43% 25% 22% 5% 5%0%$20,400 $0 $8,772 $5,100 $4,488 $1,020 $1,020 $0 $0Contractual Services 43% 25% 22% 5% 5%0%$1,100 $0 $473 $275 $242 $55 $55 $0 $0 Maintenance 33% 34% 21% 5% 7%0%$20,000 $0 $6,600 $6,800 $4,200 $1,000 $1,400 $0 $0 Equipment Rental 33% 34% 21% 5% 7%0%$100 $0 $33 $34 $21 $5 $7 $0 $0 Miscellaneous 33% 34% 21% 5% 7%0%$400 $0 $132 $136 $84 $20 $28 $0 $0 Special Services 43% 25% 22% 5% 5%0%$150,000 $0 $64,500 $37,500 $33,000 $7,500 $7,500 $0 $0Uniforms43% 25% 22% 5% 5%0%$100 $0 $43 $25 $22 $5 $5 $0 $0 Landfill Fees 43% 25% 22% 5% 5%0%$5,000 $0 $2,150 $1,250 $1,100 $250 $250 $0 $0 Supplies 43% 25% 22% 5% 5%0%$72,800 $0 $31,304 $18,200 $16,016 $3,640 $3,640 $0 $0 Subtotal Solid Disposal $682,400 $0 $303,752 $147,920 $125,888 $75,160 $29,680 $0 $0 Laboratory Labor 30% 35% 15% 10% 10%0%$77,600 $0 $23,280 $27,160 $11,640 $7,760 $7,760$0$0 Retirement Benfits 30% 35% 15% 10% 10%0%$10,900 $0 $3,270 $3,815 $1,635 $1,090 $1,090 $0 $0 Insurance Benefits 30% 35% 15% 10% 10%0%$20,300 $0 $6,090 $7,105 $3,045 $2,030 $2,030 $0 $0 Repairs 30% 35% 15% 10% 10%0%$1,000 $0 $300 $350 $150 $100 $100 $0 $0Chemicals30% 35% 15% 10% 10%0%$10,000 $0 $3,000 $3,500 $1,500 $1,000 $1,000 $0 $0 Other Supplies 30% 35% 15% 10% 10%0%$400 $0 $120 $140 $60 $40 $40 $0 $0 Insurance 30% 35% 15% 10% 10%0%$7,900 $0 $2,370 $2,765 $1,185 $790 $790 $0 $0 Office Supplies 30% 35% 15% 10% 10%0%$100 $0 $30 $35 $15 $10 $10 $0 $0 Conference & Training 30% 35% 15% 10% 10%0%$100 $0 $30 $35 $15 $10 $10 $0 $0Tools & Shop Supplies 30% 35% 15% 10% 10%0%$11,900 $0 $3,570 $4,165 $1,785 $1,190 $1,190 $0 $0 Professional Services 30% 35% 15% 10% 10%0%$200 $0 $60 $70 $30 $20 $20 $0 $0 Subtotal Laboratory $140,400 $0 $42,120 $49,140 $21,060 $14,040 $14,040 $0 $0 MaintenanceLabor 43% 25% 22% 5% 5%0%$601,300 $0 $258,559 $150,325 $132,286 $30,065 $30,065 $0 $0 Retirement Benefits 43% 25% 22% 5% 5%0%$85,300 $0 $36,679 $21,325 $18,766 $4,265 $4,265 $0 $0 Insurance Benefits 43% 25% 22% 5% 5%0%$126,700 $0 $54,481 $31,675 $27,874 $6,335 $6,335 $0 $0 Motor Vehicle Expense 43% 25% 22% 5% 5%0%$5,100 $0 $2,193 $1,275 $1,122 $255 $255 $0 $0 Contractual Services 43% 25% 22% 5% 5%0%$4,200 $0 $1,806 $1,050 $924 $210 $210 $0 $0Gas & Oil 43% 25% 22% 5% 5%0%$14,800 $0 $6,364 $3,700 $3,256 $740 $740 $0 $0 Minor Equipment 43% 25% 22% 5% 5%0%$0 $0 $0 $0 $0 $0 $0 $0 $0 Office Supplies 43% 25% 22% 5% 5%0%$800 $0 $344 $200 $176 $40 $40 $0 $0 Other Supplies 43% 25% 22% 5% 5%0%$17,200 $0 $7,396 $4,300 $3,784 $860 $860$0$0 Repairs/Maintenance 43% 25% 22% 5% 5%0%$23,700 $0 $10,191 $5,925 $5,214 $1,185 $1,185 $0 $0Insurance43% 25% 22% 5% 5%0%$57,200 $0 $24,596 $14,300 $12,584 $2,860 $2,860 $0 $0 Clothing 43% 25% 22% 5% 5%0%$600 $0 $258 $150 $132 $30 $30 $0 $0 Miscellaneous 43% 25% 22% 5% 5%0%$0 $0 $0 $0 $0 $0 $0 $0 $0 Equipment Rental 43% 25% 22% 5% 5%0%$200 $0 $86 $50 $44 $10 $10 $0 $0 Conference & Training 43% 25% 22% 5% 5%0%$0 $0 $0 $0 $0 $0 $0 $0 $0Subtotal Maintenance $937,100 $0 $402,953 $234,275 $206,162 $46,855 $46,855 $0 $0 General & Administrative Labor 16% 16% 19% 17% 4% 4% 10% 14%$422,000 $67,520 $67,520 $80,180 $71,740 $16,880 $16,880 $42,200 $59,080 Retirement Benefits 16% 16% 19% 17% 4% 4% 10% 14%$93,500 $14,960 $14,960 $17,765 $15,895 $3,740 $3,740 $9,350 $13,090Insurance Benefits 16% 16% 19% 17% 4% 4% 10% 14%$96,200 $15,392 $15,392 $18,278 $16,354 $3,848 $3,848 $9,620 $13,468 TY2022 Sewer Rate Study City of Oshkosh, WIPrepared 6/27/2022 Page 10 Conv Flow BOD TSS P NH3-N Cst Cnn 2022 Budget Conveyance System Flow BOD TSS P NH3-N Billing Meter/Conn Allocation Percentages WWTF Customer Software Supplies 16% 16% 19% 17% 4% 4% 10% 14%$0 $0 $0 $0 $0 $0 $0 $0 $0 Minor Equipment 16% 16% 19% 17% 4% 4% 10% 14%$4,500 $720 $720 $855 $765 $180 $180 $450 $630 Office Supplies/Equipment 16% 16% 19% 17% 4% 4% 10% 14%$5,000 $800 $800 $950 $850 $200 $200 $500 $700 Postage 16% 16% 19% 17% 4% 4% 10% 14%$66,000 $10,560 $10,560 $12,540 $11,220 $2,640 $2,640 $6,600 $9,240Computer Charges 16% 16% 19% 17% 4% 4% 10% 14%$34,900 $5,584 $5,584 $6,631 $5,933 $1,396 $1,396 $3,490 $4,886 Telephone 16% 16% 19% 17% 4% 4% 10% 14%$1,900 $304 $304 $361 $323 $76 $76 $190 $266 Misc Fixed Charges 16% 16% 19% 17% 4% 4% 10% 14%$0 $0 $0 $0 $0 $0 $0 $0 $0 Contractual Services 16% 16% 19% 17% 4% 4% 10% 14%$40,900 $6,544 $6,544 $7,771 $6,953 $1,636 $1,636 $4,090 $5,726 Car Allowance 16% 16% 19% 17% 4% 4% 10% 14%$300 $48 $48 $57 $51 $12 $12 $30 $42Maintenance Office Equipment 16% 16% 19% 17% 4% 4% 10% 14%$27,800 $4,448 $4,448 $5,282 $4,726 $1,112 $1,112 $2,780 $3,892 Professional Services 16% 16% 19% 17% 4% 4% 10% 14%$0 $0 $0 $0 $0 $0 $0 $0 $0 Advertising/Marketing 16% 16% 19% 17% 4% 4% 10% 14%$0 $0 $0 $0 $0 $0 $0 $0 $0 Other Supplies 16% 16% 19% 17% 4% 4% 10% 14%$500 $80 $80 $95 $85 $20 $20 $50 $70 Audit 16% 16% 19% 17% 4% 4% 10% 14%$8,000 $1,280 $1,280 $1,520 $1,360 $320 $320 $800 $1,120Insurance16% 16% 19% 17% 4% 4% 10% 14%$8,800 $1,408 $1,408 $1,672 $1,496 $352 $352 $880 $1,232 Uncollectable Accounts 16% 16% 19% 17% 4% 4% 10% 14%$4,200 $672 $672 $798 $714 $168 $168 $420 $588 Bank Fees 16% 16% 19% 17% 4% 4% 10% 14%$0 $0 $0 $0 $0 $0 $0 $0 $0 GASB 68 Pension Exp 16% 16% 19% 17%4% 4% 10% 14%$0 $0 $0 $0 $0 $0 $0 $0 $0 Conference & Training 16% 16% 19% 17% 4% 4% 10% 14%$600 $96 $96 $114 $102 $24 $24 $60 $84Dues16% 16% 19% 17% 4% 4% 10% 14%$600 $96 $96 $114 $102 $24 $24 $60 $84 Subtotal General & Administrative $815,700 $130,512 $130,512 $154,983 $138,669 $32,628 $32,628 $81,570 $114,198 Meter Reading Labor 100% 0% $0 $0 $0 $0 $0 $0 $0 $0 $0Retirement Benefits 100% 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 Insurance Benefits 100% 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 Meter Repairs 100% $390,000 $0 $0 $0 $0 $0 $0 $0 $390,000 GASB 68 Pension Exp 100% 0% $214,000 $0 $0 $0 $0 $0 $0 $214,000 $0 Office Supplies 50% 50% $50,000 $0 $0 $0 $0 $0 $0 $25,000 $25,000Car Allowance 100% $0 $0 $0 $0 $0 $0 $0 $0 $0 Subtotal Meter Reading $654,000 $0 $0 $0 $0 $0 $0 $239,000 $415,000 Pretreatment Program Professional Services 43% 25% 22% 5% 5%0%$60,000 $0 $25,800 $15,000 $13,200 $3,000 $3,000 $0 $0Licenses & Permits 43% 25% 22% 5% 5%0%$0 $0 $0 $0 $0 $0 $0 $0 $0 Books & Periodicals 43% 25% 22% 5% 5%0%$0 $0 $0 $0 $0 $0 $0 $0 $0 Maint Computer 43% 25% 22% 5% 5%0%$1,400 $0 $602 $350 $308 $70 $70 $0 $0 Conference/Training 43% 25% 22% 5% 5%0%$200 $0 $86 $50 $44 $10 $10 $0 $0 Safety Equipment 43% 25% 22% 5% 5%0%$0 $0 $0 $0 $0 $0 $0 $0 $0Office Supplies 43% 25% 22% 5% 5%0%$100 $0 $43 $25 $22 $5 $5 $0 $0 Subtotal Pretreatment Program $61,700 $0 $26,531 $15,425 $13,574 $3,085 $3,085 $0 $0 Total O & M 11% 28% 19% 16% 6% 4% 7% 9%$7,762,400 $849,552 $2,178,251 $1,471,731 $1,215,056 $486,875 $299,777 $526,265 $734,893 Capital Costs Principal and Interest Payments 34% 11% 12% 10% 4% 3% 15% 11%$7,974,114 $2,711,199 $877,153 $956,894 $797,411 $318,965 $239,223 $1,196,117 $877,153 Capital Reserve 34% 11% 12% 10% 4% 3% 15% 11%$1,547,418 $526,122 $170,216 $185,690 $154,742 $61,897 $46,423 $232,113 $170,216 Total Capital Costs $9,521,531 $3,237,321 $1,047,368 $1,142,584 $952,153 $380,861 $285,646 $1,428,230 $1,047,368 Subtotal Revenue Requirements $17,283,931 $4,086,873 $3,225,619 $2,614,315 $2,167,209 $867,736 $585,423 $1,954,495 $1,782,261 Other Income Misc Service & Late Charges 23% 19% 15% 13% 5% 3% 11% 11%($162,100) ($37,283) ($30,799) ($24,315) ($21,073) ($8,105) ($4,863) ($17,831) ($17,831) Other Sewer Service Charges 23% 19% 15% 13% 5% 3% 11% 11%($342,646) ($78,809) ($65,103) ($51,397) ($44,544) ($17,132) ($10,279) ($37,691) ($37,691)Pre-Treatment Program 23% 19% 15% 13% 5% 3% 11% 11%($78,700) ($18,101) ($14,953) ($11,805) ($10,231) ($3,935) ($2,361)($8,657) ($8,657) Investment Income 23% 19% 15% 13% 5% 3% 11% 11%($255,400) ($58,742) ($48,526) ($38,310) ($33,202) ($12,770) ($7,662) ($28,094) ($28,094) Total Other Income ($838,846) ($192,935) ($159,381) ($125,827) ($109,050) ($41,942) ($25,165) ($92,273) ($92,273) Total Net Revenue Requirements $16,445,085 $3,893,938 $3,066,239 $2,488,488 $2,058,159 $825,794 $560,258 $1,862,222 $1,689,988 Summary Allocation of Costs to Function and Classification for City Rates TY2022 Sewer Rate Study City of Oshkosh, WIPrepared 6/27/2022 Page 11 Conv Flow BOD TSS P NH3-N Cst Cnn 2022 Budget Conveyance System Flow BOD TSS P NH3-N Billing Meter/Conn Allocation Percentages WWTF Customer Conveyance 2022 Budget System Flow BOD TSS P TKN Billing Meter/Conn O&M and Replacement 11% 28% 19% 16% 6% 4% 7% 9% $7,762,400 $849,552 $2,178,251 $1,471,731 $1,215,056 $486,875 $299,777 $526,265 $734,893 Capital 34% 11% 12% 10% 4% 3% 15% 11%$9,521,531 $3,237,321 $1,047,368 $1,142,584 $952,153 $380,861 $285,646 $1,428,230 $1,047,368Other Revenues ($838,846) ($192,935) ($159,381) ($125,827) ($109,050) ($41,942) ($25,165) ($92,273) ($92,273) Total 24% 19% 15% 13% 5% 3% 11% 10%16,445,085 3,893,938 3,066,239 2,488,488 2,058,159 825,794 560,258 1,862,222 1,689,988 Legend BOD = Biochemical Oxygen Demand TSS = Total Suspended Solids P = Phosphorus NH3-N = Amonia Nitrogen TY2022 Sewer Rate Study City of Oshkosh, WIPrepared 6/27/2022 Page 12 Table 6 Rate Computation Worksheet City of Oshkosh, WI Fixed Charges (Annual) Costs Billable Units City Rate 1,862,222 23,073 $80.71 1,689,988 30,410 $55.57 Equiv Meter/Connection Customer Total Meter Size Ratio Charge Charge Fixed Charge 5/8"1 $55.57 $80.71 $136.28 3/4"1 $55.57 $80.71 $136.28 1"2.5 $138.93 $80.71 $219.64 1 1/4"3.75 $208.40 $80.71 $289.11 1 1/2"5 $277.87 $80.71 $358.58 2"8 $444.59 $80.71 $525.30 3"15 $833.60 $80.71 $914.31 4"25 $1,389.34 $80.71 $1,470.05 6"50 $2,778.67 $80.71 $2,859.38 8"80 $4,445.88 $80.71 $4,526.59 10"125 $6,946.68 $80.71 $7,027.39 12"175 $9,725.35 $80.71 $9,806.06 Volumetric Charges Billable Units Charge Type Cost (Cu. Ft or lbs)Rate/Unit Flow Charge per 100 CF $3,066,239 1,956,263 $1.57 Conveyance Charge per 100 CF $3,893,938 1,941,000 $2.01 BOD Charge per lb.$2,488,488 3,446,413 $0.72 TSS Charge per lb.$2,058,159 3,752,476 $0.55 P Charge per lb.$825,794 135,354 $6.10 NH3-N Charge per lb.$560,258 352,493 $1.59 BOD Charge per 100 CF $1.13 TSS Charge per 100 CF $0.86 P Charge per 100 CF $0.38 NH3-N Charge per 100 CF $0.25 Total Volumetric Rate per 100 Cu. Ft $6.18 Charge Type Customer Charge Meter/Connection Charge City (Inside) Rates TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 13 Wastehauler Charges Septic Charges Flow Charge per 100 Cu. Ft $1.57 BOD Charge per 100 Cu. Ft $40.54 TSS Charge per 100 Cu. Ft $51.32 P Charge per 100 Cu Ft.$11.42 NH3-N Charge per 100 Cu. Ft $1.49 Total $106.34 Holding Tank Charges Flow Charge per 100 Cu. Ft $1.57 BOD Charge per 100 Cu. Ft $2.25 TSS Charge per 100 Cu. Ft $2.74 P Charge per 100 Cu Ft.$0.76 NH3-N Charge per 100 Cu. Ft $0.50 Total $7.81 Porta Potty Waste Charges Flow Charge per 100 Cu. Ft $1.57 BOD Charge per 100 Cu. Ft $20.27 TSS Charge per 100 Cu. Ft $30.79 P Charge per 100 Cu Ft.$9.51 NH3-N Charge per 100 Cu. Ft $0.99 Total $63.14 Mixed Load Waste Charges Flow Charge per 100 Cu. Ft $1.57 BOD Charge per 100 Cu. Ft $4.05 TSS Charge per 100 Cu. Ft $3.08 P Charge per 100 Cu Ft.$1.71 NH3-N Charge per 100 Cu. Ft $1.24 Total $11.65 Rate Summary City (Inside) Fixed charge per connection $136.28 Rate per 100 Cu. Ft $6.18 BOD rate per lb.$0.722 TSS rate per lb.$0.548 P rate per lb.$6.101 NH3-N Charge per lb. $1.589 TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 14 Table 7 Rate Summary City of Oshkosh, WI Monthly Charges 2022 Current COS Proposed City (Inside) Meter Size 5/8"$10.79 $11.36 $11.36 3/4"$10.79 $11.36 $11.36 1"$18.08 $18.30 $18.30 1 1/4"$24.16 $24.09 $24.09 1 1/2"$30.23 $29.88 $29.88 2"$44.82 $43.77 $43.77 3"$78.83 $76.19 $76.19 4"$127.44 $122.50 $122.50 6"$248.95 $238.28 $238.28 8"$405.92 $377.22 $377.22 10"$613.47 $585.62 $585.62 12"$856.49 $817.17 $817.17 Volumetric Rate per 100 Cu. Ft $5.61 $6.18 $6.18 BOD rate per lb.$0.664 $0.722 $0.72 TSS rate per lb.$0.473 $0.548 $0.55 P rate per lb.$5.314 $6.101 $6.10 NH3-N rate per lb.$1.420 $1.589 $1.59 Unmetered quarterly flat charge $35.16 $61.84 $61.84 Wastehauler Septic Rate per 100 Cu. Ft $124.62 $106.34 $124.62 Chemical Toilet Rate per 100 Cu. Ft $74.14 $63.14 $74.14 Mixed Load Rate per 100 Cu. Ft $8.90 $11.65 $11.65 Holding Tank Rate per 100 Cu. Ft $9.10 $7.81 $9.10 TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 15 Table 8 Revenue Check (Based on COS) City of Oshkosh, WI Annual Units Rate Total Fixed Charge Meter Size 5/8" 9,275 $11.36 1,264,028.83$ 3/4" 12,319 $11.36 1,678,875.60$ 1" 748 $18.30 164,293.41$ 1 1/4" 0 $24.09 -$ 1 1/2" 294 $29.88 105,421.70$ 2" 292 $43.77 153,386.88$ 3" 89 $76.19 81,373.73$ 4" 44 $122.50 64,682.03$ 6" 10 $238.28 28,593.82$ 8" 1 $377.22 4,526.59$ 10" 1 $585.62 7,027.39$ 12" 0 $817.17 -$ Subtotal 23,073 3,552,209.97$ Volumetric Charges-Inside Customers Residential Flow (CCF) 917,000 $6.18 $5,670,292 Commercial Flow (CCF) 340,000 $6.18 $2,102,398 Industrial Flow (CCF) 152,000 $6.18 $939,896 Multi-Family Flow (CCF) 222,000 $6.18 $1,372,742 Public Flow (CCF) 310,000 $6.18 $1,916,892 Septic Waste Haulers Flow (CCF) 72 $106.34 $7,603 Chemical Toilet Waste Haulers Flow (CCF) 141 $63.14 $8,871 Mixed Load Flow (CCF) 10,065 $11.65 $117,286 Holding Tank Waste Haulers Flow (CCF) 4,986 $7.81 $38,956 Subtotal 1,956,263 $12,174,937 High Strength Industial Industrial Excess BOD Lbs 339,249 $0.722 $244,955 Industrial Excess TSS Lbs 629,361 $0.548 $345,192 Industrial Excess P Lbs 10,468 $6.101 $63,864 Industrial Excess NH3-N Lbs 40,220 $1.589 $63,926 Subtotal 1,019,299 $717,939 Unmetered Customers customers 0 $61.84 $0 Volumetric Charges-Outside Customers Residential Flow (000 gal) 0 $6.18 $0 Commercial & Multiple Flow (000 gal) 0 $6.18 $0 Industrial Flow (000 gal) 0 $6.18 $0 Subtotal $0 Total Revenues $16,445,085 Revenue Requirements $16,445,085 Difference $0 TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 16 Table 9 Revenue Summary (Proposed Rates) City of Oshkosh, WI Annual Units Rate Total Fixed Charge Meter Size 5/8" 9,275 $11.36 1,264,028.83$ 3/4" 12,319 $11.36 1,678,875.60$ 1" 748 $18.30 164,293.41$ 1 1/4" 0 $24.09 -$ 1 1/2" 294 $29.88 105,421.70$ 2" 292 $43.77 153,386.88$ 3" 89 $76.19 81,373.73$ 4" 44 $122.50 64,682.03$ 6" 10 $238.28 28,593.82$ 8" 1 $377.22 4,526.59$ 10" 1 $585.62 7,027.39$ 12" 0 $817.17 -$ Subtotal 23,073 3,552,209.97$ Volumetric Charges-Inside Customers Residential Flow (CCF) 917,000 $6.18 $5,670,292 Commercial Flow (CCF) 340,000 $6.18 $2,102,398 Industrial Flow (CCF) 152,000 $6.18 $939,896 Multi-Family Flow (CCF) 222,000 $6.18 $1,372,742 Public Flow (CCF) 310,000 $6.18 $1,916,892 Septic Waste Haulers Flow (CCF) 72 $124.62 $8,910 Chemical Toilet Waste Haulers Flow (CCF) 141 $74.14 $10,416 Mixed Load Flow (CCF) 10,065 $11.65 $117,286 Holding Tank Waste Haulers Flow (CCF) 4,986 $9.10 $45,393 Subtotal 1,956,263 $12,184,226 High Strength Industrial Industrial Excess BOD Lbs 339,249 $0.722 $244,955 Industrial Excess TSS Lbs 629,361 $0.548 $345,192 Industrial Excess P Lbs 10,468 $6.101 $63,864 Industrial Excess NH3-N Lbs 40,220 $1.589 $63,926 Subtotal 1,019,299 $717,939 Total Revenues $16,454,375 Revenue Requirements $16,445,085 Difference $9,290 TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 17 Table 10 Test Year Cash Flow Analysis City of Oshkosh, WI 2022 Cash Sources Revenues from User Rates (1)$16,875,721 Other Income (2)$162,100 Investment Income on Unrestricted Cash $255,400 Total Cash Sources $17,293,221 Cash Uses O&M $7,762,400 Net Before Debt Service $9,530,821 Debt Service G.O. Debt Service P&I $905,252 Revenue Debt Service P&I $7,068,862 Total Debt Service $7,974,114 Capital Outlay (non reserve) (4)$705,000 Addition to Replacement Fund (3)$25,000 Net Cash Flow $826,707 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 2022 borrowing for the sewer utility. TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 18 Table 11 Comparison of Exisitng and Proposed Bills for Sample Customers City of Oshkosh, WI Usage Current Proposed Dollar Percent Customer Usage Meter Size (100 CF) Bill Bill Increase Change Residential Low 3/4" 1.00 $16.40 $17.54 $1.14 7.0% Residential Average 3/4" 4.34 $35.16 $38.22 $3.06 8.7% Residential High 3/4" 8.00 $55.67 $60.83 $5.16 9.3% Commercial Low 3/4"8.00 $55.67 $60.83 $5.16 9.3% Commercial Average 2"10.70 $104.82 $109.91 $5.09 4.9% Commercial High 6"20.00 $361.15 $361.95 $0.80 0.2% Industrial Low 1"20.00 $130.28 $141.97 $11.69 9.0% Industrial Average 2"33.42 $232.32 $250.44 $18.12 7.8% Industrial High 4"50.00 $407.94 $431.68 $23.74 5.8% Public Low 1"8.00 $62.96 $67.77 $4.81 7.6% Public Average 3"10.70 $138.83 $142.33 $3.50 2.5% Public High 10"20.00 $725.67 $709.29 ($16.38) -2.3% Monthly TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 19 Table 12 Summary Budget for Sanitary Districts City of Oshkosh, WI Test Year Summary for Algoma 2019 2020 2021 2022 Treatment Plant 3,550,145 3,491,875 4,103,000 4,340,800 Maintenance 1,043,328 1,134,057 1,240,600 1,243,900 Solids 1,224,828 1,054,341 1,116,200 1,165,800 Laboratory 117,985 121,861 139,400 142,600 Annual Audit 5,284 7,920 8,000 8,000 Office Rental 0000 Professional Services - Consultants 0000 Total O&M Plus Depreciation 5,941,570 5,810,055 6,607,200 6,901,100 Depreciation 1,701,400 1,802,347 1,864,200 1,823,100 O&M Only 4,240,170 4,007,708 4,743,000 5,078,000 Test Year Summary for Black Wolf, Sunset Point & Island View 2019 2020 2021 2022 Treatment Plant 3,550,145 3,491,875 4,103,000 4,340,800 Sanitary Sewers 2,265,938 2,224,998 2,760,400 2,452,700 Pumping Stations 777,887 771,809 807,400 866,000 Maintenance 1,043,328 1,134,057 1,240,600 1,243,900 Solids 1,224,828 1,054,341 1,116,200 1,165,800 Laboratory 117,985 121,861 139,400 142,600 Annual Audit 5,284 7,920 8,000 8,000 Office Rental 0000 Professional Services - Consultants 0000 Replacement Costs 0000 Total O&M Plus Depreciation 8,985,396 8,806,862 10,175,000 10,219,800 Depreciation 3,814,088 3,870,745 4,299,900 3,980,800 O&M Only 5,171,308 4,936,117 5,875,100 6,239,000 O&M plus Replacement 5,171,308 4,936,117 5,875,100 6,239,000 Notes: Source: 2014 Sanitary Sewer User Rate Study for the City of Oshkosh and adopted budget for 2022. TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 20 Table 13 Historical Influent Data at Wastewater Treatment Facility City of Oshkosh, WI Year Total Pumpage (1,000 Gallons) 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 5,040.19 2020 4,485.23 2021 4,006.68 2022 Test Year Projection 4,250.00 TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 21 Table 14 Contract Customer Historical Monthly Flows (1,000 Gal) City of Oshkosh, WI Algoma Sunset Black Island Edgewood Month-Yr Total Total Wolf View Shangri-La 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 Oct-19 19,253.5 490.0 5,496.9 1,621.8 Nov-19 16,126.7 423.5 3,301.3 1,488.3 Dec-19 19,309.8 508.1 5,539.2 1,611.6 776.0 Jan-20 18,414.3 480.6 5,181.2 1,726.5 Feb-20 14,906.1 400.6 4,493.8 1,238.3 Mar-20 24,512.3 663.0 7,450.7 2,076.1 731.0 Apr-20 18,324.3 474.4 4,272.4 1,452.8 May-20 20,688.8 549.6 5,173.9 1,798.7 Jun-20 17,930.2 468.9 4,580.5 1,693.1 900.0 Jul-20 16,410.1 431.6 4,694.0 1,542.8 Aug-20 15,038.8 391.3 3,864.5 1,535.5 Sep-20 13,356.8 349.7 2,569.0 1,485.4 897.0 Oct-20 16,116.0 457.6 5,143.8 1,655.3 Nov-20 15,878.4 459.6 4,647.7 1,507.2 Dec-20 16,107.8 524.1 3,905.7 1,524.5 788.0 Jan-21 12,674.8 424.2 2,827.3 1,199.7 Feb-21 12,999.7 359.9 2,971.9 1,236.7 Mar-21 18,998.5 606.6 4,369.7 1,676.5 706.0 Apr-21 18,028.4 506.3 3,954.1 1,518.5 May-21 18,465.2 638.8 4,424.0 1,638.7 Jun-21 15,256.2 541.0 3,466.0 1,499.1 735.0 Jul-21 22,490.2 699.2 5,441.7 2,096.2 Aug-21 21,040.9 692.1 4,031.9 1,912.0 Sep-21 16,459.4 505.3 2,583.9 1,491.1 793.0 Oct-21 14,831.7 532.2 2,580.1 1,625.3 Nov-21 13,229.1 515.1 3,418.0 1,406.2 Dec-21 15,736.4 596.1 3,282.0 1,725.7 721.0 2018 Total Flows 199,317.5 7,503.7 50,287.1 17,993.8 3,042.0 2019 Total Flows 221,143.3 7,787.4 56,732.1 19,267.6 3,145.0 2020 Total Flows 207,683.9 5,650.8 55,977.2 19,236.2 3,316.0 2021 Total Flows 200,210.4 6,616.9 43,350.6 19,025.6 2,955.0 Last 12 Months Flows 200,210.4 6,616.9 43,350.6 19,025.6 2,955.0 Total of WWTP Flow 4.71%0.16%1.02%0.45%0.07% Notes: Source: Historical data provided by the City of Oshkosh. TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 22 Table 15 2022 Estimated Charge to the ALGOMA SANITARY DISTRICT City of Oshkosh, WI ALGOMA SANITARY DISTRICT A. Demand Cost Treatment Plant 4,340,800 + Maintenance 1,243,900 + Solids 1,165,800 + Laboratory 142,600 + Annual Audit 8,000 + Office Rental 0 + Professional Services - Consultants 0 TOTAL 6,901,100 - Depreciation 1,823,100 NET 5,078,000 x 15.00% = Result 761,700 x 5.00% = 38,085.00 B. Flow Cost Treatment Plant 4,340,800 + Maintenance 1,243,900 + Solids 1,165,800 + Laboratory 142,600 + Annual Audit 8,000 + Office Rental 0 + Professional Services - Consultants 0 TOTAL 6,901,100 - Depreciation 1,823,100 NET 5,078,000 x 85.00% = Result 4,316,300 x 4.71% = 203,333.68 C. Depreciation Depreciation 1,823,100 x 5.00% =91,155.00 TOTAL CHARGE TO DISTRICT 332,573.68 TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 23 Table 16 2022 Estimated Charge to the BLACK WOLF SANITARY DISTRICT NO. 1 City of Oshkosh, WI BLACK WOLF SANITARY DISTRICT NO. 1 A. Demand Cost Treatment Plant 4,340,800 + Sanitary Sewers 2,452,700 + Pumping Stations 866,000 + Maintenance 1,243,900 + Solids 1,165,800 + Laboratory 142,600 + Annual Audit 8,000 + Office Rental 0 + Professional Services - Consultants 0 TOTAL 10,219,800 - Depreciation 3,309,400 NET 6,910,400 x 15.00% = Result 1,036,560 x 1.10% = 11,402.16 B. Flow Cost Treatment Plant 4,340,800 + Sanitary Sewers 2,452,700 + Pumping Stations 866,000 + Maintenance 1,243,900 + Solids 1,165,800 + Laboratory 142,600 + Annual Audit 8,000 + Office Rental 0 + Professional Services - Consultants 0 TOTAL 10,219,800 - Depreciation 3,309,400 NET 6,910,400 x 85.00% = Result 5,873,840 x 1.02% = 59,914.00 C. Depreciation Depreciation 3,309,400 x 1.10% =36,403.40 TOTAL CHARGE TO DISTRICT 107,719.56 TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 24 Table 17 2022 Estimated Charge to the SUNSET POINT SANITARY DISTRICT City of Oshkosh, WI SUNSET POINT SANITARY DISTRICT A. Demand Cost Treatment Plant 4,340,800 + Sanitary Sewers 2,452,700 + Pumping Stations 866,000 + Maintenance 1,243,900 + Solids 1,165,800 + Laboratory 142,600 + Annual Audit 8,000 + Office Rental 0 + Professional Services - Consultants 0 TOTAL 10,219,800 - Depreciation 3,980,800 NET 6,239,000 x 15.00% = Result 935,850 x 0.17% = 1,590.95 B. Flow Cost Treatment Plant 4,340,800 + Sanitary Sewers 2,452,700 + Pumping Stations 866,000 + Maintenance 1,243,900 + Solids 1,165,800 + Laboratory 142,600 + Annual Audit 8,000 + Office Rental 0 + Professional Services - Consultants 0 TOTAL 10,219,800 - Depreciation 3,980,800 NET 6,239,000 x 85.00% = Result 5,303,150 x 0.16% = 8,256.54 C. Depreciation Depreciation 3,980,800 x 0.17% =6,767.36 TOTAL CHARGE TO DISTRICT 16,614.85 TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 25 Table 18 2022 Estimated Charge to the ISLAND VIEW SANITARY DISTRICT City of Oshkosh, WI ISLAND VIEW SANITARY DISTRICT A. Demand Cost Treatment Plant 4,340,800 + Sanitary Sewers 2,452,700 + Pumping Stations 866,000 + Maintenance 1,243,900 + Solids 1,165,800 + Laboratory 142,600 + Annual Audit 8,000 + Office Rental 0 + Professional Services - Consultants 0 TOTAL 10,219,800 - Depreciation 3,309,400 NET 6,910,400 x 15.00% = Result 1,036,560 x 0.70% = 7,255.92 B. Flow Cost Treatment Plant 4,340,800 + Sanitary Sewers 2,452,700 + Pumping Stations 866,000 + Maintenance 1,243,900 + Solids 1,165,800 + Laboratory 142,600 + Annual Audit 8,000 + Office Rental 0 + Professional Services - Consultants 0 TOTAL 10,219,800 - Depreciation 3,309,400 NET 6,910,400 x 85.00% = Result 5,873,840 x 0.45% = 26,294.94 C. Depreciation Depreciation 3,309,400 x 0.70% =23,165.80 TOTAL CHARGE TO DISTRICT 56,716.66 TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 26 Table 19 2022 Estimated Charge to the EDGEWOOD-SHANGRI LA SANITARY DISTRICT City of Oshkosh, WI EDGEWOOD-SHANGRI LA SANITARY DISTRICT A. Demand Cost Treatment Plant 4,340,800 + Sanitary Sewers 2,452,700 + Maintenance 1,243,900 + Solids 1,165,800 + Laboratory 142,600 + Annual Audit 8,000 + Office Rental 0 + Professional Services - Consultants 0 TOTAL 9,353,800 - Depreciation 3,980,800 NET 5,373,000 x 15.00% = Result 805,950 x 0.1050% =846.25 B. Flow Cost Treatment Plant 4,340,800 + Sanitary Sewers 2,452,700 + Maintenance 1,243,900 + Solids 1,165,800 + Laboratory 142,600 + Annual Audit 8,000 + Office Rental 0 + Professional Services - Consultants 0 TOTAL 9,353,800 - Depreciation 3,980,800 NET 5,373,000 x 85.00% = Result 4,567,050 x 0.0695% = 3,175.44 C. Depreciation Depreciation 0 x 0.1050% =0.00 TOTAL CHARGE TO DISTRICT 4,021.69 TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 27 Table 20 2022 Estimated Charges to All Sanitary Districts City of Oshkosh, WI 2022 Sanitary District Estimated Charges Algoma Sanitary District $332,573.68 Black Wolf Sanitary District No. 1 $107,719.56 Sunset Point Sanitary District $16,614.85 Island View Sanitary District $56,716.66 Edgewood-Shangri La Sanitary District $4,021.69 Total $517,646.44 TY2022 Sewer Rate Study City of Oshkosh, WI Prepared 6/27/2022 Page 28