The URL can be used to link to this page

Home My WebLink AboutUB-water rate studyWATER RATE CALCULATION Effective:10/01/22 CITY OF REXBURG 2021 2022 2023 VOLUME VOLUME 2 Year 26434 ACTUAL FORECAST BUDGET RELATED RELATED CUSTOMER Percent ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS COSTS Increase PERSONNEL COSTS 4100 SALARIES 452,599 507,000 546,000 30%163,800 21% 4106 CERTIFICATION RAISES 0 0 4,000 30%1,200 4107 MERIT RAISES 0 0 0 30%0 4109 HIRE NEW EMPLOYEE 0 0 80,200 30%24,060 4150 FULLTIMER OVERTIME 2,474 3,500 3,500 30%1,050 4159 BUILDING MAINTENANCE 0 0 0 30%0 4160 PART-TIME WAGES 18,617 18,000 20,000 30%6,000 7% 4190 ACCRUED LEAVE 11,816 3,900 6,500 30%1,950 4200 BENEFITS 299,070 338,000 344,000 30%103,200 15% 4240 PERSI PENSION EXP ADJ -48,815 0 17,000 30%5,100 4250 W/C SURCHARGE 3,583 16,100 7,300 30%2,190 104% 4251 W/C REFUND 1,620 42,000 -3,100 30%-930 -291% 4260 UNEMPLOYMENT BENEFITS 357 0 0 4270 UNIFORMS 1,332 2,000 2,000 30%600 4290 WELLNESS/REC.PROGRAM 1,616 1,500 1,600 30%480 TOTAL PERSONNEL 744,269 932,000 1,029,000 30%308,700 720,300 38% OPERATING COSTS 4300 SUPPLIES 16,069 15,000 16,000 30%4,800 4330 JANITOR SERVICE 1,204 1,200 1,300 0%0 4350 GAS & OIL 15,151 17,500 18,000 30%5,400 4360 POSTAGE 352 300 300 30%90 4390 SMALL TOOLS 9,618 10,000 8,000 30%2,400 4400 DRUG TEST & BACKGROUND 91 100 100 30%30 4414 STATE FEE-SDWA 11,949 12,000 12,000 0%0 4415 WATER DISTRICT FEES 4,128 4,600 4,600 80%3,680 4416 CITIES SETTLEMENT-RECHARGE 420 400 400 0%0 4426-4427 INTEREST PAYMENTS-only use maint share372,727 24,900 48,400 72%34,848 4430 HIRED WORK 25,875 25,000 25,000 30%7,500 -3% 4431 HIRED WORK-ENG/SMALL PROJECTS71,692 50,000 45,000 50%22,500 4432 HIRED WORK-TESTING 25,543 20,000 20,000 80%16,000 4446 HIRED WORK-SHERRIFF DISPATCH 5,000 50%2,500 4451 BACKFLOW TESTING EXP 3,510 5,000 5,000 30%1,500 4454 HIRED WORK-ODD YR.AERIAL PH.2,161 2,600 2,700 0%0 4460 INSURANCE 10,550 16,500 43,900 60%26,340 4470 TRAVEL & TRAINING 6,785 7,000 7,000 30%2,100 4480 DUES & MEMBERSHIP 7,318 7,500 7,700 100%7,700 4490 BANKING CHARGES 14,379 14,400 14,500 0%0 4495 STATEMENT BILLING 7,617 8,200 8,300 0%0 4496 AUTO-PAY DISCOUNT 7,105 7,200 7,200 0%0 4500 ADVERTISING/PUBLISHING 72 200 200 0%0 4510 TELEPHONE 10,141 12,300 12,400 80%9,920 4520 HEAT & LIGHTS 2,709 2,800 2,900 30%870 4532 PUMPING POWER 361,494 380,000 380,000 95%361,000 5% 4580 WATER/SEWER/GARBAGE 1,562 1,600 1,700 30%510 4590 REP-PUMPS/WELLS 16,367 13,000 13,000 100%13,000 4600 REP-BUILDING/GROUNDS 1,231 1,200 1,200 80%960 4601 REP-WATER TANK BUILDING 0 1,000 1,000 100%1,000 4610 REP-EQUIPMENT 10,063 15,000 16,000 30%4,800 4624 REP-PARTS AND PIPE 21,792 16,000 18,000 72%12,960 4625 REP-LINES AND STREET 0 2,500 2,500 50%1,250 4626 FIRE HYDRANT & REPAIRS 6,588 5,500 6,000 0%0 4627 METER MAINTENANCE 84,463 40,000 65,000 0%0 4640 COMPUTER MAINT.26,459 26,500 30,700 0%0 4677 DEPRECIATION 746,339 760,000 790,000 72%568,800 6% 4679 BAD DEBT 3,384 3,500 4,000 0%0 4680 LIABILITY LOSS 4,038 23,600 5,000 30%1,500 4690 MISCELLANEOUS 0 0 0 50%0 TOTAL OPERATING COSTS 1,910,945 1,554,100 1,650,000 68%1,113,958 536,042 -14% OTHER COSTS 4830 GIS OVERHEAD 35,405 48,500 56,800 0%0 4840 RIGHT-OF-WAY CHARGE 185,000 198,000 209,500 0%0 4850 SHOP EXPENSES 20,804 26,500 27,000 30%8,100 4860 ASSET SECURITY 227,300 255,300 257,900 72%185,688 4870 ASSET DISPOSAL 702 2,000 2,000 72%1,440 4872 CONTRIBUTED ASSETS 0 150,000 150,000 0%0 4873 PRIN PAYMENTS-MAINT 0 35,800 72,900 72%52,488 WATER RATE CALCULATION Effective:10/01/22 CITY OF REXBURG 2021 2022 2023 VOLUME VOLUME 2 Year 26434 ACTUAL FORECAST BUDGET RELATED RELATED CUSTOMER Percent ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS COSTS Increase 4876 PRIN PMT-CAPACITY-reduced below 0 58,400 118,900 72%85,608 4890 GEN. OVERHEAD 355,200 394,200 389,700 50%194,850 4942 TRANSFER TO CAPITAL 414,017 0 0 0%0 -100% 6000 CONTINGENCY 0%*OPERATIONS 0 0 0 50%0 0% TOTAL OTHER FIXED COSTS 1,238,428 1,168,700 1,284,700 41%528,174 756,526 4% GRAND TOTAL 3,893,642 3,654,800 3,963,700 49%1,950,832 2,012,868 2% 3,844,800 2022 Less Other Revenues, Parts -30,000 -93,600 Less Transfer from Fund 34 for Principle on Loan for Capacity Projects -85,608 -33,292 -118,900 Less Principal Payment and Interest Payment for DEQ Loan-Not to be included in rate calculations -87,336 -33,964 -121,300 Less Trnsfr to Capital-being paid with loan 0 Contributed Assets -150,000 Revenue Shift 13,500 -13,500 NET BASE COSTS 1,761,388 1,688,512 2022 FORECAST REVENUE 1,830,000 1,650,000 2022 PER UNIT CHARGE 1.153 18.62 (000) GAL.EQ. METERS 2022 BILLED UNITS 1,587,164 7,385 CALCULATED COST PER THOUSAND GALLONS/EQUIVALENT METERS 1.110 19.05 Volume Rate Base Rate Old Rate 1.153 18.62 Increase %-3.7%2.3% Increase $($0.0432)$0.43 100%Staff Recommended Rate $1.110 $19.05 Cont Cap Other Volume Customer Total Total Revenue 150,000 242,500 1,761,388 1,688,104 3,841,992 100%1,761,388 1,688,104 Old Adopted Rate New Calculated Rate Staff Recomm- ended Rate Dollar Increase % Increase WATER (10 Th. GAL)23.23 23.49 23.49 0.26 1.1% WATER (20 Th. GAL)34.77 34.59 34.59 -0.19 -0.5% What caused the increases in rates? Expenses 2021 2023 % Change Personnel 744,269 1,029,000 38.26% Operations 1,910,945 1,650,000 -13.66% Depreciation 746,339 790,000 5.85% Other Fixed Costs (Includes Depreciation)1,016,211 1,134,700 11.66%Less Contributed assets and transfers to capital Forecast Forecast FY 23 Water Reserve 9/30/2022 9/30/2023 Cap Projects Operating Reserves 6,716,726$ 6,076,326$ 1,314,800$ Capital Reserves 2,321,600$ -$ 2,321,600$ Water Capital Construction -$ -$ Total 9,038,326$ 6,076,326$ 3,636,400$ Recommend to take the full increase. No charge on DEQ Loan Principle and Interest (Maint Share due is about $2.82 Million) calculated in Rate.