The URL can be used to link to this page

Home My WebLink AboutUB-water rate studyWATER RATE CALCULATION Effective:10/01/19 CITY OF REXBURG 2018 2019 2020 VOLUME VOLUME 2 Year ACTUAL FORECAST BUDGET RELATED RELATED CUSTOMER Percentage ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS COSTS Increase OPERATING COSTS 26-434.10 SALARIES 336,739 352,000 392,700 30%117,810 17% 26-434.100 CERTIFICATION RAISES 0 0 3,600 30%1,080 26-434.102 HIRE NEW EMPLOYEE 0 0 63,400 30%19,020 26-434.15 FULLTIMER OVERTIME 7,983 8,200 8,400 30%2,520 26-434.152 BUILDING MAINTENANCE 0 0 0 30%0 26-434.16 PART-TIME WAGES 31,049 35,000 40,000 30%12,000 29% 26-434.19 ACCRUED LEAVE 8,034 7,800 8,000 30%2,400 26-434.20 BENEFITS 231,607 235,000 260,500 30%78,150 12% 26-434.24 PERSI PENSION EXP ADJ -24,053 -24,000 -24,000 30%-7,200 26-434.25 W/C SURCHARGE 34,189 38,700 37,800 30%11,340 11% 26-434.251 W/C REFUND 27,039 -1,700 -3,000 30%-900 -111% 26-434.26 UNEMPLOYMENT BENEFITS 1,415 0 0 26-434.27 UNIFORMS 1,459 2,400 2,800 30%840 26-434.29 WELLNESS/REC.PROGRAM 462 600 700 30%210 TOTAL PERSONNEL 655,923 654,000 790,900 30%237,270 553,630 21% 26-434.30 SUPPLIES 19,646 16,000 15,200 30%4,560 26-434.31 POSTAGE 228 200 200 30%60 26-434.35 GAS & OIL 14,109 15,800 16,500 30%4,950 26-434.39 SMALL TOOLS 15,672 21,000 16,000 30%4,800 26-434.40 DRUG TEST & BACKGROUND 231 200 200 30%60 26-434.41 STATE FEE-SDWA 11,949 12,000 12,000 0%0 26-434.411 WATER DISTRICT FEES 6,960 7,300 7,300 80%5,840 26-434.412 CITIES SETTLEMENT-RECHARGE 30,000 0%0 26-434.42 TESTING 13,354 16,000 16,500 80%13,200 26-434.43 HIRED WORK 19,503 30,000 45,000 30%13,500 131% 26-434.431 BACKFLOW TESTING EXP 5,916 7,000 7,000 30%2,100 26-434.432 ENGINEERING-INSPECTIONS 0 10,000 10,000 50%5,000 26-434.433 HIRED WORK-ENG. CONS.27,721 0 0 50%0 26-434.434 HIRED WORK-ODD YR.AERIAL PH.25,636 0 7,500 0%0 26-434.44 AUTO-PAY DISCOUNT 6,922 7,800 7,800 0%0 26-434.45 ADVERTISING/PUBLISHING 107 500 500 0%0 26-434.46 INSURANCE 9,720 10,400 12,100 60%7,260 26-434.47 TRAVEL & TRAINING 5,538 7,000 7,200 30%2,160 26-434.48 BANKING CHARGES 10,427 13,500 13,500 0%0 26-434.481 DUES & MEMBERSHIP 6,307 7,100 7,100 100%7,100 26-434.49 STATEMENT BILLING 7,977 8,000 8,000 0%0 26-434.50 JANITOR SERVICE 1,200 1,200 1,200 0%0 26-434.51 TELEPHONE 9,774 9,600 9,800 80%7,840 26-434.52 HEAT & LIGHTS 2,701 2,000 2,100 30%630 26-434.53 PUMPING POWER 353,048 315,000 320,000 95%304,000 -9% 26-434.58 WATER/SEWER/GARBAGE 1,445 1,600 1,600 30%480 WATER RATE CALCULATION Effective:10/01/19 CITY OF REXBURG 2018 2019 2020 VOLUME VOLUME 2 Year ACTUAL FORECAST BUDGET RELATED RELATED CUSTOMER Percentage ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS COSTS Increase 26-434.59 REP-PUMPS/WELLS 17,884 28,000 28,000 100%28,000 26-434.60 REP-BUILDINGS/TANKS 8,654 8,000 8,000 80%6,400 26-434.61 REP-EQUIPMENT 14,721 15,000 15,000 30%4,500 26-434.62 PARTS & PIPE & LINE REP.49,000 42,000 50,000 50%25,000 26-434.63 STREET PATCH-H20 LINE REPAIRS 0 15,000 15,000 26-434.64 COMPUTER MAINT.22,772 22,000 22,500 0%0 26-434.65 METER MAINTENANCE 8,754 8,000 8,000 0%0 26-434.66 FIRE HYDRANT & REPAIRS 17,942 18,000 18,000 0%0 26-434.69 MISCELLANEOUS 0 0 0 50%0 TOTAL OPERATING COSTS 715,818 675,200 738,800 61%447,440 291,360 3% OTHER COSTS 26-434.77 DEPRECIATION 584,195 630,000 670,000 72%482,400 15% 26-434.78 LIABILITY LOSS 888 700 700 30%210 26-434.79 BAD DEBT 111 300 300 0%0 26-434.84 CONTRIBUTED ASSETS 0 300,000 300,000 0%0 26-434.85 ASSET DISPOSAL 332 1,000 1,000 72%720 26-434.89 PRINCIPAL PAYMENTS 0 0 54,800 72%39,456 26-434.891 PRINCIPAL PMT-CAPACITY SHARE 0 0 186,700 72%134,424 26-434.90 INTEREST PAYMENTS 70,003 100,000 120,000 72%86,400 26-434.92 GIS OVERHEAD 48,925 60,100 56,900 0%0 26-434.94 RIGHT-OF-WAY CHARGE 169,181 180,800 182,000 0%0 26-434.95 SHOP EXPENSES 16,947 22,000 27,000 30%8,100 26-434.96 ASSET SECURITY 171,900 173,900 214,700 72%154,584 26-434.97 PARKS SERVICES 15,000 0 0 0%0 26-434.98 CONTINGENCY 0%*OPERATIONS 0 0 52,400 50%26,200 0% 26-434.99 GEN. OVERHEAD 354,900 378,600 356,800 50%178,400 26-434.999 TRANSFER TO CAPITAL 1,658,703 2,023,600 1,638,000 0%0 -1% TOTAL OTHER FIXED COSTS 3,091,085 3,871,000 3,861,300 29%1,110,894 2,750,406 25% WATER RATE CALCULATION Effective:10/01/19 CITY OF REXBURG 2018 2019 2020 VOLUME VOLUME 2 Year ACTUAL FORECAST BUDGET RELATED RELATED CUSTOMER Percentage ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS COSTS Increase GRAND TOTAL 4,462,826 5,200,200 5,391,000 33%1,795,604 3,595,396 21% 5,204,300 2019 Less Other Revenues, Parts -164,500 -134,900 Less Transfer from Fund 34 for Principle/Interest on Loan for Capacity Projects -134,424 -52,276 -186,700 Less Trnsfr to Capital-being paid with loan -1,638,000 Contributed Assets -300,000 Revenue Shift 0 0 NET BASE COSTS 1,496,680 1,470,220 2019 FORECAST REVENUE 1,440,000 1,400,000 2019 PER UNIT CHARGE 1.015 18.25 (000) GAL.EQ. METERS 2019 BILLED UNITS 1,418,719 6,393 CALCULATED COST PER THOUSAND GALLONS/EQUIVALENT METERS 1.055 19.17 Volume Rate Base Rate Old Rate 1.015 18.25 Increase %3.9%5.0% Increase $$0.040 $0.92 65%Staff Recommended Rate $1.041 $18.85 Cont Cap Other Volume Customer Total Total Revenue 300,000 2,124,100 1,496,680 1,470,575 5,391,355 65%1,476,842 1,445,874 Old Adopted Rate New Calculated Rate Staff Recommended Rate (65%)Dollar Increase % Increase WATER (10 Th. GAL)22.31 23.39 23.01 0.70 3.1% WATER (20 Th. GAL)32.47 33.94 33.42 0.95 2.9% What caused the increases in rates? Expenses 2018 2020 % Change Personnel 655,923 790,900 20.58% Operations 715,818 738,800 3.21% Depreciation 584,195 670,000 14.69% Other Fixed Costs (Includes Depreciation)1,673,882 1,923,300 14.90%Less Contributed assets and transfers to capital Could take this increase over several years because we have sufficient reserves and often times the scheduled construction takes longer than planned, which reduces the actual depreciation expense, which is a large driver of rates