The URL can be used to link to this page

Home My WebLink AboutUB-water rate studyWATER RATE CALCULATION Effective:10/01/18 CITY OF REXBURG 2017 2018 2019 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 300,956 358,200 368,600 30%110,580 22% 26-434.100 CERTIFICATION RAISES 0 0 3,600 30%1,080 26-434.102 HIRE NEW EMPLOYEE 0 0 0 30%0 26-434.15 FULLTIMER OVERTIME 8,737 8,000 8,000 30%2,400 26-434.152 BUILDING MAINTENANCE 305 500 500 30%150 26-434.16 PART-TIME WAGES 18,331 24,000 24,000 30%7,200 31% 26-434.19 ACCRUED LEAVE 10,319 5,400 5,400 30%1,620 26-434.20 BENEFITS 195,226 228,000 269,500 30%80,850 38% 26-434.24 PERSI PENSION EXP ADJ -49,888 0 0 30%0 26-434.25 W/C SURCHARGE 32,990 34,200 45,100 30%13,530 37% 26-434.251 W/C REFUND 55,118 27,000 26,300 30%7,890 -52% 26-434.27 UNIFORMS 1,359 1,700 3,000 30%900 26-434.29 WELLNESS/REC.PROGRAM 749 1,000 1,000 30%300 TOTAL PERSONNEL 574,202 688,000 755,000 30%226,500 528,500 31% 26-434.30 SUPPLIES 10,230 16,000 16,000 30%4,800 26-434.31 POSTAGE 204 200 200 30%60 26-434.35 GAS & OIL 10,751 11,000 11,000 30%3,300 26-434.39 SMALL TOOLS 10,583 16,000 24,000 30%7,200 26-434.40 DRUG TEST & BACKGROUND 282 200 200 30%60 26-434.41 STATE FEE-SDWA 10,988 12,000 12,000 0%0 26-434.411 WATER DISTRICT FEES 2,691 2,700 2,700 80%2,160 26-434.42 TESTING 8,667 12,000 12,000 80%9,600 26-434.43 HIRED WORK 28,761 26,000 70,000 30%21,000 143% 26-434.431 BACKFLOW TESTING EXP 4,680 5,000 5,000 30%1,500 26-434.432 ENGINEERING-INSPECTIONS 24,776 30,000 30,000 50%15,000 26-434.433 HIRED WORK-ENG. CONS.2,350 3,000 3,000 50%1,500 26-434.434 HIRED WORK-ODD YR.AERIAL PH.25,652 25,700 25,700 0%0 26-434.44 AUTO-PAY DISCOUNT 7,096 7,100 7,100 0%0 26-434.45 ADVERTISING/PUBLISHING 384 400 400 0%0 26-434.46 INSURANCE 9,757 9,700 10,400 60%6,240 26-434.47 TRAVEL & TRAINING 5,296 6,000 10,000 30%3,000 26-434.48 BANKING CHARGES 10,220 9,500 9,500 0%0 26-434.481 DUES & MEMBERSHIP 6,522 11,000 11,000 100%11,000 26-434.49 STATEMENT BILLING 7,358 8,000 8,000 0%0 26-434.50 JANITOR SERVICE 1,200 1,200 1,200 0%0 26-434.51 TELEPHONE 8,795 9,700 9,700 80%7,760 26-434.52 HEAT & LIGHTS 2,800 2,600 2,600 30%780 26-434.53 PUMPING POWER 343,535 340,000 340,000 95%323,000 -1% 26-434.58 WATER/SEWER/GARBAGE 1,498 1,600 1,600 30%480 26-434.59 REP-PUMPS/WELLS 23,162 24,000 30,000 100%30,000 26-434.60 REP-BUILDINGS/TANKS 5,668 2,500 2,500 80%2,000 26-434.61 REP-EQUIPMENT 16,302 14,000 14,000 30%4,200 26-434.62 PARTS & PIPE & LINE REP.48,659 50,000 50,000 50%25,000 26-434.64 COMPUTER MAINT.23,932 27,000 27,000 0%0 26-434.65 METER MAINTENANCE 5,150 12,000 12,000 0%0 26-434.66 FIRE HYDRANT & REPAIRS 4,135 21,000 25,000 0%0 26-434.69 MISCELLANEOUS 0 0 0 50%0 TOTAL OPERATING COSTS 672,084 717,100 783,800 61%479,640 304,160 17% OTHER COSTS 26-434.77 DEPRECIATION 526,887 580,000 640,000 72%460,800 21% 26-434.78 LIABILITY LOSS 0 700 700 30%210 26-434.79 BAD DEBT 310 1,000 1,000 0%0 26-434.84 CONTRIBUTED ASSETS 0 300,000 300,000 0%0 26-434.85 ASSET DISPOSAL 500 5,000 5,000 72%3,600 26-434.89 PRINCIPAL PAYMENTS 0 54,800 54,800 72%39,456 26-434.891 PRINCIPAL PMT-CAPACITY SHARE 0 186,700 186,700 72%134,424 26-434.90 INTEREST PAYMENTS 37,949 28,800 28,800 72%20,736 26-434.92 GIS OVERHEAD 50,813 54,300 60,100 0%0 26-434.94 RIGHT-OF-WAY CHARGE 154,934 160,000 180,800 0%0 26-434.95 SHOP EXPENSES 32,375 28,000 28,000 30%8,400 26-434.96 ASSET SECURITY 160,296 171,900 173,900 72%125,208 26-434.97 PARKS SERVICES 15,000 15,000 15,000 0%0 26-434.98 CONTINGENCY 0%*OPERATIONS 0 25,500 0 50%0 0% 26-434.99 GEN. OVERHEAD 267,204 354,900 378,600 50%189,300 26-434.999 TRANSFER TO CAPITAL 3,394,796 3,495,200 905,000 0%0 -73% TOTAL OTHER FIXED COSTS 4,641,064 5,461,800 2,958,400 33%982,134 1,976,266 -36% GRAND TOTAL 5,887,350 6,866,900 4,497,200 38%1,688,274 2,808,926 -24% 4,310,500 Less Other Revenues, Parts -100,000 -102,500 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 -905,000 WATER RATE CALCULATION Effective:10/01/18 CITY OF REXBURG 2017 2018 2019 VOLUME VOLUME 2 Year ACTUAL FORECAST BUDGET RELATED RELATED CUSTOMER Percentage ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS COSTS Increase Contributed Assets -300,000 Revenue Shift -15,500 15,500 NET BASE COSTS 1,438,350 1,464,650 2018 FORECAST REVENUE 1,380,000 1,300,000 2018 PER UNIT CHARGE 0.988 16.86 (000) GAL.EQ. METERS 2018 BILLED UNITS 1,396,761 6,425 CALCULATED COST PER THOUSAND GALLONS/EQUIVALENT METERS 1.030 19.00 Volume Rate Base Rate Old Rate 0.988 16.86 Increase %4.2%12.7% Increase $$0.042 $2.14 65%Staff Recommended Rate $1.015 $18.25 Cont Cap Other Volume Customer Total Total Revenue 300,000 1,294,200 1,438,350 1,465,006 4,497,556 65%1,417,928 1,407,254 Old Adopted Rate New Calculated Rate Staff Recommended Rate (65%)Dollar Increase % Increase WATER (10 Th. GAL)20.81 23.12 22.31 1.50 7.2% WATER (20 Th. GAL)30.70 33.42 32.46 1.76 5.7% What caused the increases in rates? Expenses 2017 2019 % Change Personnel 574,202 755,000 31.49%7 FT IN 2016 AND 9 FT IN 2019 Operations 672,084 783,800 16.62% Depreciation 526,887 640,000 21.47% Other Fixed Costs (Includes Depreciation)1,246,268 1,753,400 40.69%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