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/2020 FIXED COST CITY OF REXBURG 2019 2020 2021 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 406,557 425,000 451,600 93%419,988 419,988 31,612 27-435.100 CERTIFICATION RAISES 0 0 2,000 93%1,860 1,860 140 27-435.101 ADD MAINT. POSITION 50/50 0 0 0 93%0 0 0 27-435.104 MERIT RAISES 0 0 -6,100 93%-5,673 -5,673 -427 27-435.15 FULLTIMER OVERTIME 9,095 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 9,643 19,000 10,000 93%9,300 9,300 700 27-435.19 ACCRUED LEAVE 5,886 7,000 7,000 93%6,510 6,510 490 27-435.20 BENEFITS 221,878 230,500 252,200 93%234,546 234,546 17,654 27-435.24 PERSI PENSION EXP ADJ 34,984 0 0 93%0 0 0 27-435.25 W/C SURCHARGE 406 700 200 93%186 186 14 27-435.251 W/C REFUND -2,709 -3,000 -3,100 93%-2,883 -2,883 -217 27-435.27 UNIFORMS 2,332 1,600 1,600 93%1,488 1,488 112 27-435.29 WELLNESS PROGRAM 782 700 700 93%651 651 49 TOTAL PERSONNEL COSTS 688,854 691,500 726,100 93%675,273 0 675,273 50,827 27-435.30 SUPPLIES 26,495 27,000 25,000 95%23,750 23,750 1,250 27-435.301 LAB SUPPLIES 14,995 16,000 16,000 95%15,200 15,200 800 27-435.302 UV SYSTEM SUPPLIES 9,834 8,300 8,300 100%8,300 8,300 0 27-435.303 SMALL TOOLS-GAS SENSORS 0 6,500 6,500 100%6,500 6,500 0 27-435.31 POSTAGE 2,060 2,300 2,300 93%2,139 2,139 161 27-435.32 CHEMICALS FOR TREATMENT 155,515 140,000 145,000 100%145,000 145,000 0 27-435.35 GAS & OIL 18,328 16,000 16,500 93%15,345 15,345 1,155 27-435.39 SMALL TOOLS 9,933 4,000 4,000 93%3,720 3,720 280 27-435.40 SHOTS/DRUG TESTS/BACKGROUND 55 100 100 93%93 93 7 27-435.41 LAND FILL TIPPING/HAULING FEES 0 10,000 10,000 100%10,000 10,000 0 27-435.42 TESTING HIRED OUT 10,236 12,000 12,000 93%11,160 11,160 840 27-435.43 HIRED WORK 4,333 5,000 6,000 5%300 300 5,700 27-435.431 ENG.-INSPECTIONS/SMALL PROJ.3,798 3,000 3,000 93%2,790 2,790 210 27-435.432 HIRED WORK-ENG.CONSULTANT/LIC.0 0 0 93%0 0 0 27-435.433 HIRED WORK-ODD YR.AERIAL PHOTO 0 500 500 93%465 465 35 27-435.45 ADVERTISING 75 100 100 93%93 93 7 27-435.46 INSURANCE 20,314 20,300 18,400 97%17,848 17,848 552 27-435.47 TRAVEL & TRAINING & MEETINGS 9,468 6,900 8,600 93%7,998 7,998 602 27-435.48 BANKING/CC CHARGES 7,236 7,800 8,200 0%0 0 8,200 27-435.481 DUES & MEMBERSHIP 444 500 500 93%465 465 35 27-435.482 IPDES PERMIT FEES-BEGIN FY20 16,429 16,500 16,500 93%15,345 15,345 1,155 27-435.49 STATEMENT BILLING 3,955 4,000 4,000 0%0 0 4,000 27-435.51 TELEPHONE/INTERNET 5,332 5,300 5,300 93%4,929 4,929 371 27-435.52 HEAT-NATURAL GAS 61,837 63,000 63,000 93%58,590 58,590 4,410 27-435.531 POWER-EFF BLDG/IRRIG 864 800 800 100%800 800 0 27-435.532 POWER-OLD TFMR/BLOWR 339,568 343,000 295,000 100%295,000 295,000 0 27-435.533 POWER-NEW TFMR 46,187 41,500 42,000 100%42,000 42,000 0 27-435.534 POWER-GRAV BELT/BLOWER 34,516 34,500 34,500 100%34,500 34,500 0 27-435.58 WATE/SEWER/GARBAGE-85%4,086 4,500 4,600 100%4,600 4,600 0 Volume TREATMENT AND COLL. RELATED TO VOLUME WASTEWATER RATE CALCULATION Effective:10/1/2020 FIXED COST CITY OF REXBURG 2019 2020 2021 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.59 REP-PUMP/BLOWR 25,982 32,000 30,000 100%30,000 30,000 0 27-435.591 REP-K-MART LIFT STN 0 0%0 0 0 27-435.591 REP-SCREW PRESSES/GBT/ETC 47,411 58,000 45,000 100%45,000 45,000 0 27-435.60 REP-BUILDING 27,894 36,000 22,000 95%20,900 20,900 1,100 27-435.61 REP-EQUIPMENT 38,831 55,000 50,000 95%47,500 47,500 2,500 27-435.62 PARTS & PIPE 0 0 100%0 0 0 27-435.64 COMPUTER PROGRM 10,850 11,400 12,500 50%6,250 6,250 6,250 27-435.69 MISCELLANEOUS 0%0 0 0 TOTAL OPERATING COSTS 956,861 991,800 916,200 96%876,580 0 876,580 0 39,620 FIXED COSTS 94%=TREATMENT PERCENT OF (PERSONNEL + OPERATIONS) 27-435.77 DEPRECIATION 822,695 850,000 860,000 90%774,000 0 774,000 86,000 Capital Maintenance Payback (formerly DEPREC./UPGRADE)325,000 100%325,000 325,000 0 Capital Maintenance Payback (formerly DEPREC./UPG OFFSET)-325,000 100%-325,000 0 -325,000 0 27-435.78 LIABILITY LOSS 345 0 0 100%0 0 0 0 27-435.79 BAD DEBT WRITEOFFS 333 500 500 0%0 0 0 500 27-435.84 CONT. CAP OFFSET 0%0 0 0 0 27-435.85 ASSET DISPOSAL 37,017 0 0 100%0 0 0 0 27-435.89 PRINCIPAL PAYMENTS 0 0 345,000 90%310,500 0 310,500 34,500 27-435.891 PRINCIPAL PAYMENTS-Offset by revenue 0 0 405,000 90%364,500 364,500 40,500 27-435.90 BOND INTEREST 86,567 87,400 25,800 90%23,220 0 23,220 2,580 27-435.901 BONDS PREM AMORT -9,020 -9,000 0 90%0 0 0 0 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 17,752 16,000 18,000 93%16,740 16,740 1,260 27-435.96 ASSET SECURITY EXP 167,499 175,600 200,900 13%25,270 25,270 175,630 27-435.97 PARKS SERVICES 0%0 0 0 27-435.98 CONTINGENCY 0 0 0 100%0 0 0 27-435.99 GEN. OVERHEAD 40%155,320 145,300 146,600 80%117,280 117,280 29,320 27-435.99 A/R OVERHEAD 40%155,320 145,300 146,600 80%117,280 117,280 29,320 27-435.99 A/P OVERHEAD 20%77,659 72,600 73,200 80%58,560 58,560 14,640 27-435.999 TRNSFR TO CAP-MAINT PROJ 33,629 0 0 0%0 0 0 TOTAL FIXED COSTS 1,545,116 1,483,700 2,221,600 81%1,807,350 0 660,130 1,147,220 414,250 Collections OPERATING COSTS 27-475.10 SALARIES/FULL TIME 234,743 226,000 255,800 4.72%12,074 80,430 12,074 163,296 27-475.100 CERTIFICATION RAISES 0 0 1,500 4.72%71 472 71 957 27-475.101 ADD MAINT. POSITION-50/50 0 0 0 4.72%0 0 0 0 27-475.104 MERIT RAISES 0 0 -3,100 4.72%-146 -975 -146 -1,979 27-475.15 FULLTIMER OVERTIME 1,054 1,000 1,000 4.72%47 314 47 639 27-475.19 ACCRUED LEAVE 4,509 4,900 4,900 4.72%231 1,541 231 3,128 27-475.20 BENEFITS 135,905 128,000 153,900 4.72%7,264 48,390 7,264 98,246 27-475.24 PERSI PENSION EXP ADJ 19,851 0 0 4.72%0 0 0 0 27-475.25 W/C SURCHARGE 46 100 200 4.72%9 63 9 128 WASTEWATER RATE CALCULATION Effective:10/1/2020 FIXED COST CITY OF REXBURG 2019 2020 2021 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.251 W/C REFUND -892 -1,300 -1,500 4.72%-71 -472 -71 -957 27-475.27 UNIFORMS 1,165 1,200 1,200 4.72%57 377 57 766 27-475.29 WELLNESS PROGRAM 1,342 1,000 1,000 4.72%47 314 47 639 TOTAL PERSONNEL COSTS 397,723 360,900 414,900 4.72%19,583 130,455 19,583 0 264,862 27-475.30 SUPPLIES 8,970 8,600 9,000 4.72%2,838 2,033 2,838 4,129 27-475.35 GAS & OIL 13,684 11,000 12,500 4.72%590 3,930 590 7,980 27-475.39 SMALL TOOLS 3,699 3,000 3,500 4.72%165 1,101 165 2,234 27-475.40 SHOTS/DRUG TESTS 342 100 100 4.72%5 31 5 64 27-475.43 HIRED WORK 2,878 5,000 2,500 4.72%118 786 118 1,596 27-475.431 ENG.-INSPECTIONS/SMALL PROJ.7,420 10,000 10,000 4.72%472 3,144 472 6,384 27-475.433 HIRED WORK-ODD YR.-AERIAL PHOTO 1,800 1,800 4.72%85 566 85 1,149 27-475.45 ADVERTISING & PUBLISHING 41 100 100 4.72%5 31 5 64 27-475.46 INSURANCE 48,264 50,500 100,200 4.72%4,729 31,505 4,729 63,966 27-475.47 TRAVEL & TRAINING 7,351 3,300 4,800 4.72%227 1,509 227 3,064 27-475.48 BANKING/CC CHARGES 7,236 7,800 8,000 0.0%0 0 8,000 27-475.481 DUES & MEMBERSHIP 390 400 400 4.72%19 126 19 255 27-475.49 STATEMENT BILLING 3,956 4,000 4,000 0.0%0 0 4,000 27-475.51 TELEPHONE & INTERNET 1,712 2,000 2,000 4.72%94 629 94 1,277 27-475.54 LIFT STAT POWER-NON-V RIVER DR 29,135 29,000 29,500 100%29,500 29,500 0 0 27-475.541 LIFT STAT POWER-V RIVER DR 7,338 7,400 7,500 0%0 0 7,500 27-475.58 WATER/SEWER/GARBAGE-15%581 700 700 0%0 0 700 27-475.59 REPAIRS-PUMPS,LIFT STN 8,662 7,000 8,000 90%7,200 7,200 0 800 27-475.591 REPAIRS-V RIVER DR LIFTSTATION 2,010 9,400 3,000 0%0 0 3,000 27-475.60 REPAIRS-BUILDINGS 4,133 2,800 4,000 4.72%189 1,258 189 2,553 27-475.61 EQUIPMENT REPAIRS 13,620 18,000 15,000 4.72%708 4,716 708 9,576 27-475.62 PARTS & PIPE & LINE REPAIRS 4,362 5,000 5,000 90%4,500 4,288 212 500 27-475.64 COMPUTER PROGRAM 8,338 12,500 13,000 50%6,500 6,193 307 6,500 TOTAL OPERATING COSTS 184,122 199,400 244,600 24%57,944 98,547 10,763 0 135,290 27-475.77 DEPRECIATION 396,730 410,000 430,000 90%387,000 0 387,000 43,000 27-475.78 LIABILITY LOSS 432 2,500 2,500 100%2,500 2,500 0 0 27-475.84 CONT. CAP OFFSET 0 400,000 400,000 100%400,000 0 400,000 0 27-475.85 ASSET DISPOSALS 0 0 0 100%0 0 0 0 27-475.92 GIS OVERHEAD 76,423 83,000 47,500 100%47,500 2,242 45,258 27-475.94 RIGHT OF WAY CHARGE 292,899 289,300 294,200 100%294,200 13,886 280,314 27-475.95 SHOP EXPENSES 19,755 9,000 18,000 4.72%850 850 17,150 27-475.96 ASSET SECURITY 112,800 115,900 121,900 8.3%10,158 67,045 10,158 44,697 27-475.98 CONTINGENCY 0 0 6,800 100%6,800 3,887 321 2,592 27-475.99 GEN. OVERHEAD 40%59,480 63,040 65,000 80%52,000 37,527 2,454 25,018 A/R OVERHEAD 40%59,480 63,040 65,000 80%52,000 37,527 2,454 25,018 A/P OVERHEAD 20%29,740 31,520 32,600 80%26,080 18,821 1,231 12,548 TOTAL FIXED COSTS 1,047,739 1,467,300 1,483,500 86%1,279,088 167,309 33,597 787,000 495,594 GRAND TOTAL 4,820,415 5,194,600 6,006,900 79%4,715,818 396,311 2,275,926 1,934,220 1,400,443 LESS INDUSTRIAL USERS SURCHARGES -51,000 -149,000 LESS LIFT STATION POWER FOR SUGAR/TETON 76.39%-8,021 % increase fixed costs 1.428965368 LESS OTHER INCOME -40,000 -89,500 Contributed Capital -400,000 0 WASTEWATER RATE CALCULATION Effective:10/1/2020 FIXED COST CITY OF REXBURG 2019 2020 2021 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 Less Trnsfr to Cap-Maint. Proj.-Paid from Operating Cash Reserves 0 0 Less Prin PMT from Fund 35 -364500 -40,500 COST TRANSFER TOTAL TREATMENT COSTS 396,311 $2,275,926 $1,078,720 $1,113,422 TOT GAL REX GAL METERS 2020 FORECAST REVENUE 3,400,000 1,100,000 2020 PER UNIT CHARGE 2.61 4.56 16.12 Current Forecast REXBURG GALLONS (000)-/-EQUIVALENT METERS 745,614 745,614 5,687 $230,000 SUGAR CITY USAGE (000'S GALLONS)88,123 10.33% $50,000 TETON CITY USAGE (000'S GALLONS)19,157 2.25% $280,000 852,894 12.58% Wastewater Treatment Costs/1000 Gallons SUGAR/TETON REXBURG REXBURG TREATMENT TREATMENT FIXED COST COSTS COSTS BASE FEE OPERATING TREATMENT COST/1000 GAL.2.67 2.67 REXBURG COLLECTIONS ONLY ADDITIONAL COST 0.53 K-MART LIFT STATION POWER & REPAIR COSTS 0.07 0.07 REXBURG CAPITAL TREATMENT COST/1000 GAL.1.38 TOTAL TREATMENT COST/1000 GAL.2.74 4.65 REXBURG COST PER EQUIVALENT METER 16.32 Old Rate $2.61 $4.56 $16.12 Change in Rate $0.13 $0.09 $0.20 Total Increase 4.98%1.97%1.24% Staff Recommends we take the full calculated increase.