The URL can be used to link to this page

Home My WebLink AboutUB-water rate studyWATER RATE CALCULATION Effective:10/01/23 CITY OF REXBURG 2022 2023 2024 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 499,628 593,000 606,400 30%181,920 21% 4106 CERTIFICATION RAISES 0 0 4,000 30%1,200 4107 MERIT RAISES 0 6,500 21,700 30%6,510 4109 HIRE NEW EMPLOYEE 0 0 89,500 30%26,850 4150 FULLTIMER OVERTIME 3,663 18,000 18,000 30%5,400 4159 BUILDING MAINTENANCE 0 0 0 30%0 4160 PART-TIME WAGES 12,886 18,000 19,000 30%5,700 47% 4190 ACCRUED LEAVE -1,502 11,700 7,000 30%2,100 4200 BENEFITS 314,389 372,000 389,400 30%116,820 24% 4240 PERSI PENSION EXP ADJ 41,208 17,000 17,000 30%5,100 4250 W/C SURCHARGE 16,123 9,700 10,000 30%3,000 -38% 4251 W/C REFUND 41,971 31,100 33,000 30%9,900 -21% 4260 UNEMPLOYMENT BENEFITS 0 0 0 4270 UNIFORMS 2,269 2,200 2,200 30%660 4290 WELLNESS/REC.PROGRAM 677 1,200 1,300 30%390 TOTAL PERSONNEL 931,313 1,080,400 1,218,500 30%365,550 852,950 31% OPERATING COSTS 4300 SUPPLIES 9,974 17,500 16,000 30%4,800 4330 JANITOR SERVICE 466 500 500 0%0 4350 GAS & OIL 23,396 22,000 24,000 30%7,200 4360 POSTAGE 287 300 300 30%90 4390 SMALL TOOLS 10,184 8,000 10,000 30%3,000 4400 DRUG TEST & BACKGROUND 116 100 100 30%30 4414 STATE FEE-SDWA 11,949 15,000 15,000 0%0 4415 WATER DISTRICT FEES 5,286 5,500 5,800 80%4,640 4416 CITIES SETTLEMENT-RECHARGE 0 0 0 0%0 4426-4427 INTEREST PAYMENTS-only use maint share96,586 48,400 47,300 72%34,056 4430 HIRED WORK 14,637 36,000 65,000 30%19,500 344% 4431 HIRED WORK-ENG/SMALL PROJECTS42,963 45,000 45,000 50%22,500 4432 HIRED WORK-TESTING 14,155 17,000 18,000 80%14,400 4446 HIRED WORK-SHERRIFF DISPATCH 0 5,000 5,000 50%2,500 4451 BACKFLOW TESTING EXP 0 5,000 5,000 30%1,500 4454 HIRED WORK-ODD YR.AERIAL PH.0 2,700 2,700 0%0 4460 INSURANCE 16,504 43,000 58,900 60%35,340 4470 TRAVEL & TRAINING 3,493 8,800 9,000 30%2,700 4480 DUES & MEMBERSHIP 7,646 8,700 8,800 100%8,800 4490 BANKING CHARGES 3,806 4,700 4,800 0%0 4495 STATEMENT BILLING 8,408 13,200 13,300 0%0 4496 AUTO-PAY DISCOUNT 7,244 12,800 13,000 0%0 4500 ADVERTISING/PUBLISHING 80 200 200 0%0 4510 TELEPHONE 11,639 11,700 12,000 80%9,600 4520 HEAT & LIGHTS 2,803 4,500 4,500 30%1,350 4532 PUMPING POWER 359,408 370,000 380,000 95%361,000 6% 4580 WATER/SEWER/GARBAGE 1,576 1,800 1,900 30%570 4590 REP-PUMPS/WELLS 9,662 12,400 13,000 100%13,000 4600 REP-BUILDING/GROUNDS 1,802 1,200 1,500 80%1,200 4601 REP-WATER TANK BUILDING 442 500 1,000 100%1,000 4610 REP-EQUIPMENT 15,181 16,500 17,000 30%5,100 4624 REP-PARTS AND PIPE 21,620 18,000 20,000 72%14,400 4625 REP-LINES AND STREET 3,255 4,500 4,500 50%2,250 4626 FIRE HYDRANT & REPAIRS 3,637 5,000 5,000 0%0 4627 METER MAINTENANCE 49,990 80,000 65,000 0%0 4640 COMPUTER MAINT.43,446 43,500 43,500 0%0 4677 DEPRECIATION 722,738 750,000 785,000 72%565,200 9% 4679 BAD DEBT 523 1,500 1,500 0%0 4680 LIABILITY LOSS 24,381 4,700 5,000 30%1,500 4690 MISCELLANEOUS 0 0 0 50%0 TOTAL OPERATING COSTS 1,549,284 1,645,200 1,728,100 66%1,137,226 590,874 12% OTHER COSTS 4830 GIS OVERHEAD 47,807 56,800 65,300 0%0 4840 RIGHT-OF-WAY CHARGE 198,000 209,500 228,500 0%0 4850 SHOP EXPENSES 22,131 23,000 24,000 30%7,200 4860 ASSET SECURITY 255,300 257,900 257,900 72%185,688 4870 ASSET DISPOSAL 0 1,000 1,000 72%720 4872 CONTRIBUTED ASSETS 0 250,000 250,000 0%0 4873 PRIN PAYMENTS-MAINT 0 72,900 74,100 72%53,352 WATER RATE CALCULATION Effective:10/01/23 CITY OF REXBURG 2022 2023 2024 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 118,900 120,800 72%86,976 4890 GEN. OVERHEAD 394,200 389,700 431,200 50%215,600 4942 TRANSFER TO CAPITAL 0 0 0 0%0 #DIV/0! 6000 CONTINGENCY 0%*OPERATIONS 0 0 10,000 50%5,000 0% TOTAL OTHER FIXED COSTS 917,437 1,379,700 1,462,800 38%554,536 908,264 59% GRAND TOTAL 3,398,035 4,105,300 4,409,400 47%2,057,312 2,352,088 30% 4,288,600 Less Other Revenues, Parts -80,000 -109,600 Less Transfer from Fund 34 for Principle on Loan for Capacity Projects -86,976 -33,824 -120,800 Less Principal Payment and Interest Payment for DEQ Loan-Not to be included in rate calculations -87,408 -33,992 -121,400 Less Trnsfr to Capital-being paid with loan 0 Contributed Assets -250,000 Revenue Shift 2,000 -2,000 NET BASE COSTS 1,804,928 1,922,672 2023 FORECAST REVENUE 1,761,400 1,688,100 2023 PER UNIT CHARGE 1.110 19.05 (000) GAL.EQ. METERS 2023 BILLED UNITS 1,586,847 7,385 CALCULATED COST PER THOUSAND GALLONS/EQUIVALENT METERS 1.137 21.70 Volume Rate Base Rate Old Rate 1.110 19.05 Increase %2.5%13.9% Increase $$0.0274 $2.65 100%Staff Recommended Rate $1.137 $21.70 Cont Cap Other Volume Customer Total Total Revenue 250,000 310,400 1,804,928 1,922,928 4,288,256 100%1,804,928 1,922,928 Old Adopted Rate New Calculated Rate Staff Recomm- ended Rate Dollar Increase % Increase WATER (10 Th. GAL)23.49 26.25 26.25 2.76 11.7% WATER (20 Th. GAL)34.60 37.62 37.62 3.02 8.7% What caused the increases in rates? Expenses 2022 2024 % Change Personnel 931,313 1,218,500 30.84% Operations 1,549,284 1,728,100 11.54% Depreciation 722,738 785,000 8.61% Other Fixed Costs (Includes Depreciation)1,112,337 1,212,800 9.03%Less Contributed assets and transfers to capital Forecast Forecast 2024 Water Reserve 9/30/2023 9/30/2024 Cap Projects Operating Reserves 7,165,924$ 8,049,372$ 2,170,000$ Capital Reserves 1,928,400$ 876,600$ 812,500$ Water Capital Construction -$ -$ Total 9,094,324$ 8,925,972$ 2,982,500$ Recommend to take the full increase. 2 Year increase of almost 30%. No charge on DEQ Loan Principle and Interest in Rate However.