Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
UB-wwratestudy
WASTEWATER RATE CALCULATION Effective:10/1/2019 FIXED COST CITY OF REXBURG 2018 2019 2020 REXBURG OPER.CAPITAL BASE FEES ACTUAL FORECAST ESTIMATED COLLECTIONS TREATMT TREATMT WHETHER ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS ONLY COSTS COSTS USE SYSTEM OR NOT Treatment OPERATING COSTS 27-435.10 SALARIES 415,622 412,000 421,900 93%392,367 392,367 29,533 27-435.100 CERTIFICATION RAISES 0 0 2,400 93%2,232 2,232 168 27-435.101 ADD MAINT. POSITION 50/50 0 0 0 93%0 0 0 27-435.15 FULLTIMER OVERTIME 10,261 10,000 10,000 93%9,300 9,300 700 27-435.152 BLDG MAINT LABOR 0 0 0 93%0 0 0 27-435.16 PART-TIME WAGES 12,333 13,000 13,000 93%12,090 12,090 910 27-435.19 ACCRUED LEAVE 12,476 8,200 8,400 93%7,812 7,812 588 27-435.20 BENEFITS 223,327 225,000 229,100 93%213,063 213,063 16,037 27-435.24 PERSI PENSION EXP ADJ -19,373 0 0 93%0 0 0 27-435.25 W/C SURCHARGE 414 400 700 93%651 651 49 27-435.251 W/C REFUND -2,133 -2,700 -3,000 93%-2,790 -2,790 -210 27-435.27 UNIFORMS 1,486 1,500 1,600 93%1,488 1,488 112 27-435.29 WELLNESS PROGRAM 668 700 800 93%744 744 56 TOTAL PERSONNEL COSTS 655,081 668,100 684,900 93%636,957 0 636,957 47,943 27-435.30 SUPPLIES 20,393 18,500 18,000 95%17,100 17,100 900 27-435.301 LAB SUPPLIES 12,530 14,500 13,800 95%13,110 13,110 690 27-435.302 UV SYSTEM SUPPLIES 0 8,700 8,300 100%8,300 8,300 0 6,095 0 6,500 27-435.31 POSTAGE 2,020 1,400 1,400 93%1,302 1,302 98 27-435.32 CHEMICALS FOR TREATMENT 86,290 121,000 121,000 100%121,000 121,000 0 27-435.35 GAS & OIL 15,938 17,500 18,000 93%16,740 16,740 1,260 27-435.39 SMALL TOOLS 3,813 3,800 4,000 93%3,720 3,720 280 27-435.40 SHOTS/DRUG TESTS/BACKGROUND 178 100 200 93%186 186 14 27-435.41 LAND FILL TIPPING/HAULING FEES 11,495 40,000 40,000 100%40,000 40,000 0 27-435.42 TESTING HIRED OUT 12,522 13,200 13,500 93%12,555 12,555 945 27-435.43 HIRED WORK 9,022 8,000 8,000 5%400 400 7,600 27-435.431 ENG.-INSPECTIONS/SMALL PROJ.952 1,000 1,000 93%930 930 70 27-435.432 HIRED WORK-ENG.CONSULTANT/LIC.200 0 0 93%0 0 0 27-435.433 HIRED WORK-ODD YR.AERIAL PHOTO 75 0 1,500 93%1,395 1,395 105 27-435.45 ADVERTISING 116 100 100 93%93 93 7 27-435.46 INSURANCE 18,023 20,300 20,300 97%19,691 19,691 609 27-435.47 TRAVEL & TRAINING & MEETINGS 6,010 9,000 8,600 93%7,998 7,998 602 27-435.48 BANKING/CC CHARGES 8,249 7,800 7,800 0%0 0 7,800 27-435.481 DUES & MEMBERSHIP 300 300 300 93%279 279 21 0 0 16,500 27-435.49 STATEMENT BILLING 3,988 4,000 4,000 0%0 0 4,000 27-435.51 TELEPHONE/INTERNET 5,674 5,200 5,300 93%4,929 4,929 371 27-435.52 HEAT-NATURAL GAS 55,898 51,000 53,000 93%49,290 49,290 3,710 27-435.531 POWER-EFF BLDG/IRRIG 1,039 800 800 100%800 800 0 27-435.532 POWER-OLD TFMR/BLOWR 336,786 300,000 308,000 100%308,000 308,000 0 27-435.533 POWER-NEW TFMR 48,220 44,000 44,000 100%44,000 44,000 0 27-435.534 POWER-GRAV BELT/BLOWER 42,716 35,000 35,000 100%35,000 35,000 0 27-435.58 WATE/SEWER/GARBAGE-85%4,014 3,500 3,600 100%3,600 3,600 0 27-435.59 REP-PUMP/BLOWR 19,097 32,000 32,000 100%32,000 32,000 0 Volume TREATMENT AND COLL. RELATED TO VOLUME WASTEWATER RATE CALCULATION Effective:10/1/2019 FIXED COST CITY OF REXBURG 2018 2019 2020 REXBURG OPER.CAPITAL BASE FEES ACTUAL FORECAST ESTIMATED COLLECTIONS TREATMT TREATMT WHETHER ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS ONLY COSTS COSTS USE SYSTEM OR NOT Volume TREATMENT AND COLL. RELATED TO VOLUME 27-435.591 REP-K-MART LIFT STN 0%0 0 0 27-435.591 REP-SCREW PRESSES/GBT/ETC 84,619 31,200 20,000 100%20,000 20,000 0 27-435.60 REP-BUILDING 13,186 15,500 15,500 95%14,725 14,725 775 27-435.61 REP-EQUIPMENT 49,546 50,000 50,000 95%47,500 47,500 2,500 27-435.62 PARTS & PIPE 100%0 0 0 27-435.64 COMPUTER PROGRM 14,558 13,000 15,000 50%7,500 7,500 7,500 27-435.69 MISCELLANEOUS 0%0 0 0 TOTAL OPERATING COSTS 893,562 870,400 895,000 93%832,143 0 832,143 0 39,857 FIXED COSTS 93%=TREATMENT PERCENT OF (PERSONNEL + OPERATIONS) 27-435.77 DEPRECIATION 815,457 815,000 840,000 90%756,000 0 756,000 84,000 Capital Maintenance Payback (formerly DEPREC./UPGRADE)300,000 100%300,000 300,000 0 Capital Maintenance Payback (formerly DEPREC./UPG OFFSET)-300,000 100%-300,000 0 -300,000 0 27-435.78 LIABILITY LOSS 0 1,000 1,000 100%1,000 0 1,000 0 27-435.79 BAD DEBT WRITEOFFS 90 500 500 0%0 0 0 500 27-435.84 CONT. CAP OFFSET 0%0 0 0 0 27-435.85 ASSET DISPOSAL 6,172 0 0 100%0 0 0 0 27-435.89 PRINCIPAL PAYMENTS 0 0 319,700 90%287,730 0 287,730 31,970 27-435.891 PRINCIPAL PAYMENTS-Offset by revenue 0 0 375,300 90%337,770 337,770 37,530 27-435.90 BOND INTEREST 95,625 87,400 87,400 90%78,660 0 78,660 8,740 27-435.901 BONDS PREM AMORT -9,020 -9,000 -9,000 90%-8,100 0 -8,100 -900 27-435.92 GIS OVERHEAD 90%0 0 0 27-435.94 RIGHT OF WAY CHG 90%0 0 0 27-435.95 SHOP EXP O/H 16,890 16,000 16,700 93%15,531 15,531 1,169 27-435.96 ASSET SECURITY EXP 165,600 167,500 175,600 12%21,643 21,643 153,957 27-435.97 PARKS SERVICES 0%0 0 0 27-435.98 CONTINGENCY 0 0 33,200 100%33,200 33,200 0 27-435.99 GEN. OVERHEAD 40%140,560 155,320 145,280 80%116,224 116,224 29,056 27-435.99 A/R OVERHEAD 40%140,560 155,320 145,280 80%116,224 116,224 29,056 27-435.99 A/P OVERHEAD 20%70,280 77,660 72,640 80%58,112 58,112 14,528 27-435.999 TRNSFR TO CAP-MAINT PROJ 154,636 75,000 100,000 0%0 0 100,000 TOTAL FIXED COSTS 1,596,850 1,541,700 2,303,600 79%1,813,994 0 660,934 1,153,060 489,606 Collections OPERATING COSTS 27-475.10 SALARIES/FULL TIME 178,112 230,000 239,100 4.72%11,286 75,179 11,286 152,635 27-475.100 CERTIFICATION RAISES 0 0 1,800 4.72%85 566 85 1,149 27-475.101 ADD MAINT. POSITION-50/50 0 0 0 4.72%0 0 0 0 27-475.15 FULLTIMER OVERTIME 1,288 1,000 1,200 4.72%57 377 57 766 27-475.19 ACCRUED LEAVE 5,681 4,700 4,700 4.72%222 1,478 222 3,000 27-475.20 BENEFITS 99,615 135,000 141,400 4.72%6,674 44,460 6,674 90,266 27-475.24 PERSI PENSION EXP ADJ -10,337 0 0 4.72%0 0 0 0 27-475.25 W/C SURCHARGE 0 100 100 4.72%5 31 5 64 27-475.251 W/C REFUND -555 -900 -1,300 4.72%-61 -409 -61 -830 27-475.27 UNIFORMS 1,304 1,200 1,200 4.72%57 377 57 766 WASTEWATER RATE CALCULATION Effective:10/1/2019 FIXED COST CITY OF REXBURG 2018 2019 2020 REXBURG OPER.CAPITAL BASE FEES ACTUAL FORECAST ESTIMATED COLLECTIONS TREATMT TREATMT WHETHER ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS ONLY COSTS COSTS USE SYSTEM OR NOT Volume TREATMENT AND COLL. RELATED TO VOLUME 27-475.29 WELLNESS PROGRAM 598 800 800 4.72%38 251 38 511 TOTAL PERSONNEL COSTS 275,706 371,900 389,000 4.72%18,363 122,310 18,363 0 248,327 27-475.30 SUPPLIES 8,437 8,000 8,100 4.72%2,640 1,802 2,640 3,658 27-475.35 GAS & OIL 16,045 20,000 20,500 4.72%968 6,446 968 13,086 27-475.39 SMALL TOOLS 3,564 3,900 3,500 4.72%165 1,101 165 2,234 27-475.40 SHOTS/DRUG TESTS 77 100 100 4.72%5 31 5 64 27-475.43 HIRED WORK 1,140 1,200 1,200 4.72%57 377 57 766 27-475.431 ENG.-INSPECTIONS/SMALL PROJ.20,436 16,000 18,000 4.72%850 5,660 850 11,491 27-475.433 HIRED WORK-ODD YR.-AERIAL PHOTO 300 0 6,000 4.72%283 1,887 283 3,830 27-475.45 ADVERTISING & PUBLISHING 59 100 100 4.72%5 31 5 64 27-475.46 INSURANCE 44,426 48,300 50,500 4.72%2,384 15,878 2,384 32,238 27-475.47 TRAVEL & TRAINING 3,493 5,000 4,800 4.72%227 1,509 227 3,064 27-475.48 BANKING/CC CHARGES 8,189 7,800 8,000 0.0%0 0 8,000 27-475.481 DUES & MEMBERSHIP 464 300 300 4.72%14 94 14 192 27-475.49 STATEMENT BILLING 3,989 4,000 4,000 0.0%0 0 4,000 27-475.51 TELEPHONE & INTERNET 1,676 1,600 1,700 4.72%80 535 80 1,085 27-475.54 LIFT STAT POWER-NON-V RIVER DR 29,655 28,800 29,500 100%29,500 29,500 0 0 27-475.541 LIFT STAT POWER-V RIVER DR 7,485 7,000 7,200 0%0 0 7,200 27-475.58 WATER/SEWER/GARBAGE-15%337 300 400 0%0 0 400 27-475.59 REPAIRS-PUMPS,LIFT STN 10,112 10,000 11,000 90%9,900 9,900 0 1,100 27-475.591 REPAIRS-V RIVER DR LIFTSTATION 10,110 2,500 3,000 0%0 0 3,000 27-475.60 REPAIRS-BUILDINGS 3,257 4,500 3,000 4.72%142 943 142 1,915 27-475.61 EQUIPMENT REPAIRS 11,972 9,000 9,000 4.72%425 2,830 425 5,745 27-475.62 PARTS & PIPE & LINE REPAIRS 4,866 5,000 5,000 90%4,500 4,288 212 500 27-475.64 COMPUTER PROGRAM 7,702 10,000 10,200 50%5,100 4,859 241 5,100 TOTAL OPERATING COSTS 197,791 193,400 205,100 28%57,245 87,670 8,698 0 108,732 27-475.77 DEPRECIATION 375,990 410,000 480,000 90%432,000 0 432,000 48,000 27-475.78 LIABILITY LOSS 2,364 3,000 3,000 100%3,000 3,000 0 0 27-475.84 CONT. CAP OFFSET 0 850,000 850,000 100%850,000 0 850,000 0 27-475.85 ASSET DISPOSALS 0 0 0 100%0 0 0 0 27-475.92 GIS OVERHEAD 69,378 85,200 83,000 100%83,000 3,918 79,082 27-475.94 RIGHT OF WAY CHARGE 284,534 292,900 289,300 100%289,300 13,655 275,645 27-475.95 SHOP EXPENSES 15,933 12,000 12,500 4.72%590 590 11,910 27-475.96 ASSET SECURITY 111,600 112,800 115,900 8.3%9,658 63,745 9,658 42,497 27-475.98 CONTINGENCY 0 0 10,000 100%10,000 5,717 472 3,811 27-475.99 GEN. OVERHEAD 40%56,160 59,480 63,040 80%50,432 36,396 2,380 24,264 A/R OVERHEAD 40%56,160 59,480 63,040 80%50,432 36,396 2,380 24,264 A/P OVERHEAD 20%28,080 29,740 31,520 80%25,216 18,198 1,190 12,132 TOTAL FIXED COSTS 1,000,199 1,914,600 2,001,300 90%1,803,628 163,451 34,244 1,282,000 521,605 WASTEWATER RATE CALCULATION Effective:10/1/2019 FIXED COST CITY OF REXBURG 2018 2019 2020 REXBURG OPER.CAPITAL BASE FEES ACTUAL FORECAST ESTIMATED COLLECTIONS TREATMT TREATMT WHETHER ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS ONLY COSTS COSTS USE SYSTEM OR NOT Volume TREATMENT AND COLL. RELATED TO VOLUME GRAND TOTAL 4,619,189 5,560,100 6,478,900 80%5,162,330 373,432 2,191,339 2,435,060 1,456,070 LESS INDUSTRIAL USERS SURCHARGES -50,000 -150,000 LESS LIFT STATION POWER FOR SUGAR/TETON 76.39%-7,792 % increase fixed costs 1.657612159 LESS OTHER INCOME -42,000 -73,500 Contributed Capital -850,000 0 Less Trnsfr to Cap-Maint. Proj.-Paid from Operating Cash Reserves 0 -100,000 Less Prin PMT from Fund 35 -337770 -37,530 COST TRANSFER TOTAL TREATMENT COSTS 373,432 $2,191,339 $1,155,291 $1,087,248 TOT GAL REX GAL METERS 2019 FORECAST REVENUE 3,420,000 1,058,800 2019 PER UNIT CHARGE 2.61 4.53 15.70 Current Forecast REXBURG GALLONS (000)-/-EQUIVALENT METERS 754,967 754,967 5,620 $225,000 SUGAR CITY USAGE (000'S GALLONS)86,207 10.01% $52,000 TETON CITY USAGE (000'S GALLONS)19,923 2.31% $277,000 861,097 12.33% Wastewater Treatment Costs/1000 Gallons SUGAR/TETON REXBURG REXBURG TREATMENT TREATMENT FIXED COST COSTS COSTS BASE FEE OPERATING TREATMENT COST/1000 GAL.2.54 2.54 REXBURG COLLECTIONS ONLY ADDITIONAL COST 0.49 K-MART LIFT STATION POWER & REPAIR COSTS 0.07 0.07 REXBURG CAPITAL TREATMENT COST/1000 GAL.1.46 TOTAL TREATMENT COST/1000 GAL.2.61 4.56 REXBURG COST PER EQUIVALENT METER 16.12 Old Rate $2.61 $4.53 $15.70 Change in Rate $0.00 $0.03 $0.42 Total Increase 0.00%0.66%2.68% Total Revenue -New Rates $277,000 $3,442,649 $1,087,125 INCREASED AMOUNT TO COME FROM FUND BALANCE CARRYOVER What is causing the Increases? Expenses 2018 2020 % Change Personnel 950,160 1,073,900 13.02% Operations 1,091,353 1,100,100 0.80% Depreciation 1,191,447 1,320,000 10.79% Other Fixed Costs (Includes Depreciation)4,142,049 4,304,900 3.93% Staff Recommends we take the full calculated increase. Reserves are low for sewer.