Loading...
HomeMy WebLinkAboutUB-wwratestudy 2016.pdfWASTEWATER RATE CALCULATION Effective:10/1/2015 CITY OF REXBURG 2014 2015 2016 OPER.CAPITAL COLLECTN ACTUAL FORECAST ESTIMATED ------TREATMENT------TREATMT TREATMT & BILLING ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS COSTS COSTS COSTS OPERATING COSTS 27-435.10 SALARIES 373,291 370,000 393,800 79%311,102 311,102 82,698 27-435.100 CERTIFICATION RAISES 0 10,500 10,500 79%8,295 8,295 2,205 27-435.101 ADD MAINT. POSITION 0 0 58,200 79%45,978 45,978 12,222 27-435.102 GIS/CITY SHARED POS.0 0 9,100 79%7,189 7,189 1,911 27-435.15 FULLTIMER OVERTIME 11,190 10,100 11,000 79%8,690 8,690 2,310 27-435.152 BLDG MAINT LABOR -868 2,000 2,000 79%1,580 1,580 420 27-435.16 PART-TIME WAGES 4,458 6,000 6,500 79%5,135 5,135 1,365 27-435.19 ACCRUED LEAVE 6,995 6,900 6,900 79%5,451 5,451 1,449 27-435.20 BENEFITS 205,022 205,000 216,000 79%170,640 170,640 45,360 25435.201 BENEFITS ON RAISES 0 0 0 79%0 0 0 27-435.25 W/C SURCHARGE 471 1,900 1,900 79%1,501 1,501 399 27-435.251 W/C REFUND -3,501 -1,400 -1,400 79%-1,106 -1,106 -294 27-435.27 UNIFORMS 611 600 600 79%474 474 126 27-435.29 WELLNESS PROGRAM 700 1,100 1,100 79%869 869 231 TOTAL PERSONNEL COSTS 598,369 612,700 716,200 79%565,798 565,798 150,402 27-435.30 SUPPLIES 11,431 11,000 11,900 90%10,710 10,710 1,190 27-435.301 LAB SUPPLIES 6,714 6,800 6,800 100%6,800 6,800 0 27-435.302 UV SYSTEM SUPPLIES 6,714 6,500 6,500 100%6,500 6,500 0 27-435.31 POSTAGE 1,231 1,300 1,300 33%429 429 871 27-435.32 CHEMICALS 40,834 40,000 40,000 100%40,000 40,000 0 27-435.33 SAND 0 400 400 100%400 400 0 27-435.35 GAS & OIL 24,558 24,000 24,000 70%16,800 16,800 7,200 27-435.39 SMALL TOOLS 2,856 2,400 2,400 79%1,896 1,896 504 27-435.40 SHOTS/DRUG TESTS 460 400 400 79%316 316 84 27-435.41 LAND FILL TIPPING FEES 0 100%0 0 0 27-435.42 TESTING 11,246 15,000 15,000 100%15,000 15,000 0 27-435.43 HIRED WORK 5,776 9,000 9,000 80%7,200 7,200 1,800 27-435.45 ADVERTISING 203 600 600 79%474 474 126 27-435.46 INSURANCE 36,498 34,000 41,400 89%36,846 36,846 4,554 27-435.47 TRAVEL & TRAINING 6,314 7,500 7,500 90%6,750 6,750 750 27-435.48 BANKING CHARGES 4,198 4,600 4,600 0%0 0 4,600 27-435.49 STATEMENT BILLING 8,231 8,400 8,400 0%0 0 8,400 27-435.51 TELEPHONE 7,061 7,300 7,300 67%4,891 4,891 2,409 27-435.52 NATURAL GAS 24,898 25,000 25,000 100%25,000 25,000 0 27-435.531 EFF BLDG/IRRIG 3,858 800 800 100%800 800 0 27-435.532 OLD TFMR/BLOWR 188,892 195,000 195,000 100%195,000 195,000 0 27-435.533 NEW TFMR 55,674 62,000 62,000 100%62,000 62,000 0 27-435.534 POWER-GRAV BELT 58,819 65,000 65,000 100%65,000 65,000 0 27-435.54 LIFT STN PWR-OTHER 24,024 26,000 26,000 0%0 0 26,000 27-435.541 LIFT STN PWR-KMART 6,025 6,500 6,500 0%0 0 6,500 27-435.58 SOLID WASTE 2,287 4,000 4,000 100%4,000 4,000 0 27-435.59 REP-PUMP/BLOWR 19,834 50,000 50,000 100%50,000 50,000 0 27-435.591 REP-K-MART LIFT STN 318 1,500 1,500 0%0 0 1,500 27-435.60 REP-BUILDING 13,260 14,000 19,000 100%19,000 19,000 0 27-435.61 REP-EQUIPMENT 31,444 41,000 41,000 89%36,490 36,490 4,510 27-435.62 PARTS & PIPE 661 1,500 1,500 10%150 150 1,350 27-435.64 COMPUTER PROGRM 9,672 9,800 13,200 0%0 0 13,200 27-435.69 MISCELLANEOUS 0 0 0 50%0 0 0 TOTAL OPERATING COSTS 613,991 681,300 698,000 88%612,452 612,452 0 85,548 FIXED COSTS 83%=TREATMENT PERCENT OF (PERSONNEL + OPERATIONS) 27-435.77 DEPRECIATION 893,652 1,020,000 1,100,000 89%979,000 0 979,000 121,000 DEPREC. /UPGRADE 155,000 100%155,000 155,000 0 DEPREC. /UPG OFFSET -155,000 100%-155,000 0 -155,000 0 27-435.78 LIABILITY LOSS 0 2,000 2,000 0%0 0 0 2,000 27-435.79 BAD DEBT WRITEOFFS 0 1,000 1,000 0%0 0 0 1,000 27-435.84 CONT. CAP OFFSET 0 1,750,000 1,750,000 0%0 0 0 1,750,000 27-435.85 ASSET DISPOSAL 106,252 5,000 5,000 89%4,450 0 4,450 550 27-435.89 PRINCIPAL PAYMENTS 269,100 276,000 285,200 89%253,828 0 253,828 31,372 27-435.891 PRINCIPAL PAYMENTS 324,000 334,800 0%0 0 334,800 27-435.90 BOND INTEREST 129,413 122,100 113,800 100%113,800 0 113,800 0 27-435.901 BONDS PREM AMORT -9,020 -9,000 -9,000 100%-9,000 0 -9,000 0 27-435.92 GIS OVERHEAD 75,601 73,300 73,400 10%7,340 7,340 66,060 27-435.94 RIGHT OF WAY CHG 214,905 214,700 229,600 7%15,072 15,072 214,528 27-435.95 SHOP EXP O/H 19,649 30,600 30,000 89%26,700 26,700 3,300 27-435.96 SECURITY EXP 251,304 275,800 283,300 89%252,137 252,137 31,163 27-435.97 PARKS SERVICES 3,000 1,000 1,000 100%1,000 1,000 0 27-435.98 CONTINGENCY 5%*OPERATIONS 77,700 83%64,736 64,736 12,964 27-435.99 GEN. OVERHEAD 40%158,520 148,240 154,200 83%128,473 128,473 25,727 27-435.99 A/R OVERHEAD 40%158,520 148,240 154,200 0%0 0 154,200 27-435.99 A/P OVERHEAD 20%79,260 74,120 77,100 83%64,236 64,236 12,864 27-435.999 TRNSFR TO CAP-MAINT PROJ 1,265,000 1,265,000 0%0 0 1,265,000 TOTAL FIXED COSTS 2,350,156 5,722,100 5,928,300 32%1,901,772 714,694 1,187,078 4,026,528 GRAND TOTAL 3,562,516 7,016,100 7,342,500 42%3,080,022 1,892,944 1,187,078 4,262,478 LESS INDUSTRIAL USERS SURCHARGES -50,000 -50,000 LESS LIFT STATION POWER FOR SUGAR/TETON 84%-6,720 % increase fixed costs 2.522513399 LESS OTHER INCOME -63,000 -22,200 Contributed Capital -1,750,000 Less Trnsfr to Cap-Maint. Proj.-Paid from Operating Cash Reserves -1,265,000 Less Prin PMT from Fund 35 -334,800 COST TRANSFER -26,000 26,000 TOTAL TREATMENT COSTS $1,842,944 $1,048,079 $909,758 TOT GAL REX GAL METERS 2015 FORECAST REVENUE 2,620,000 910,000 2015 PER UNIT CHARGE 2.25 3.58 13.34 Current Forecast REXBURG GALLONS (000)-/-EQUIVALENT METERS 731,844 731,844 5,685 $200,000 SUGAR CITY USAGE (000'S GALLONS)88,889 10.56% $48,000 TETON CITY USAGE (000'S GALLONS)21,333 2.53% $248,000 842,066 13.09% Wastewater Treatment Costs SUGAR/TETON REXBURG COLLECTN TREATMENT TREATMENT & BILLING COSTS COSTS COSTS OPERATING TREATMENT COST/1000 GAL.2.19 2.19 K-MART LIFT STATION POWER & REPAIR COSTS 0.06 0.06 REXBURG CAPITAL TREATMENT COST/1000 GAL.1.37 TOTAL TREATMENT COST/1000 GAL.2.25 3.62 REXBURG COST PER EQUIVALENT METER 13.34 Old Rate $2.25 $3.58 $13.34 Change in Rate $0.00 $0.04 $0.00 Total Increase 0.0%1.1%0.0% REXBURG RESIDENTS -SAMPLE BILL AVERAGE OLD NEW INCREASE INCREASE SEWER (10 th. gal)49.14 49.54 0.40 0.8% WATER (10 th. gal)19.15 19.54 0.39 2.0% GARBAGE (90 gal)20.15 20.54 0.39 1.9% LIGHTING 1.65 1.65 0.00 0.0% TOTAL 90.09 91.27 1.18 1.3%