The URL can be used to link to this page

Home My WebLink AboutUB-water rate study 2016.pdfWATER RATE CALCULATION Effective:10/01/15 CITY OF REXBURG 2014 2015 2016 VOLUME VOLUME ACTUAL FORECAST BUDGET RELATED RELATED CUSTOMER ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS COSTS OPERATING COSTS 26-434.10 SALARIES 268,803 276,500 284,900 25%71,225 26-434.100 CERTIFICATION RAISES 5,100 5,100 25%1,275 26-434.101 GIS/CITY WORK SHARED POS-13.4%9,100 25%2,275 26-434.15 FULLTIMER OVERTIME 2,907 3,600 3,600 25%900 26-434.152 BUILDING MAINTENANCE -10112 1,000 1,000 25%250 26-434.16 PART-TIME WAGES 2,227 2,000 2,000 25%500 26-434.19 ACCRUED LEAVE 7,350 4,200 4,200 25%1,050 26-434.20 BENEFITS 148,491 157,000 162,500 25%40,625 26-434.25 W/C SURCHARGE 0 0 25%0 26-434.251 W/C REFUND -2,362 -2,800 -2,800 25%-700 UNEMPLOYMENT BENEFITS 0 25%0 26-434.27 UNIFORMS 535 600 600 25%150 26-434.29 WELLNESS PROGRAM 137 300 300 25%75 TOTAL PERSONNEL 417,976 447,500 470,500 25%117,625 352,875 26-434.30 SUPPLIES 8,488 8,500 8,500 25%2,125 26-434.31 POSTAGE 432 200 200 25%50 26-434.35 GAS & OIL 17,677 17,000 17,000 25%4,250 26-434.39 SMALL TOOLS 5,020 4,000 4,000 25%1,000 26-434.40 SHOTS/DRUG TESTS 455 300 300 25%75 26-434.41 STATE FEE-SDWA 10,988 11,000 11,000 0%0 26-434.411 WATER DISTRICT FEES 2,909 3,000 3,000 80%2,400 26-434.42 TESTING 11,232 10,000 10,000 80%8,000 26-434.43 HIRED WORK 34,382 30,000 30,000 25%7,500 26-434.431 BACKFLOW TESTING EXP 9,450 9,400 9,400 25%2,350 26-434.44 AUTO-PAY DISCOUNT 7,856 8,000 8,000 0%0 26-434.45 ADVERTISING 494 500 500 0%0 26-434.46 INSURANCE 9,983 9,500 11,500 60%6,900 26-434.47 TRAVEL & TRAINING 6,081 5,500 5,500 40%2,200 26-434.48 BANKING CHARGES 4,072 4,500 4,500 0%0 26-434.49 STATEMENT BILLING 8,231 8,300 8,300 0%0 26-434.50 JANITOR SERVICE 1,200 1,200 1,200 0%0 26-434.51 TELEPHONE 5,625 5,700 5,700 80%4,560 26-434.52 HEAT & LIGHTS 1,177 1,600 1,600 25%400 26-434.53 PUMPING POWER 282,105 300,000 300,000 95%285,000 26-434.58 CITY UTILITIES 331 1,100 1,100 25%275 26-434.59 REP-PUMPS 32,172 20,000 20,000 100%20,000 26-434.60 REP-BUILDING 4,964 8,000 8,000 80%6,400 26-434.61 REP-EQUIPMENT 16,882 13,000 13,000 25%3,250 26-434.62 PARTS & PIPE 13,627 11,600 11,600 0%0 26-434.64 COMPUTER MAINT.9,555 9,800 10,900 0%0 26-434.65 METER MAINTENANCE 12,255 10,000 10,000 0%0 26-434.66 FIRE HYDRANTS 9,709 9,000 9,000 0%0 26-434.69 MISCELLANEOUS 0 0 50%0 TOTAL OPERATING COSTS 527,352 520,700 523,800 68%356,735 167,065 OTHER COSTS 26-434.77 DEPRECIATION 375234 450,000 550,000 72%396,000 26-434.78 LIABILITY LOSS 500 500 25%125 26-434.79 BAD DEBT -3 2,000 2,000 100%2,000 26-434.84 CONTRIBUTED ASSETS 300,000 300,000 0%0 26-434.85 ASSET DISPOSAL 4476 20,000 20,000 72%14,400 26-434.89 PRINCIPAL PAYMENTS 48,900 82%40,098 26-434.891 PRINCIPAL PMT-CAPACITY SHARE 198,500 72%142,920 26-434.90 INTEREST PAYMENTS 26,700 72%19,224 26-434.92 GIS OVERHEAD 49,466 52,400 52,400 25%13,100 26-434.94 RIGHT-OF-WAY CHARGE 132,719 123,200 126,400 50%63,200 26-434.95 SHOP EXPENSES 28,433 26,000 30,000 25%7,500 26-434.96 ASSET SECURITY 147,300 158,700 165,900 72%119,448 26-434.97 PARKS SERVICES 14,004 14,000 15,000 25%3,750 26-434.98 CONTINGENCY 5%*OPERATIONS 58,100 50,600 50%25,300 WATER RATE CALCULATION Effective:10/01/15 CITY OF REXBURG 2014 2015 2016 VOLUME VOLUME ACTUAL FORECAST BUDGET RELATED RELATED CUSTOMER ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS COSTS 26-434.99 GEN. OVERHEAD 259,404 249,600 264,400 25%66,100 26-434.999 TRANSFER TO CAPITAL 2,930,800 9,196,000 0%0 TOTAL FIXED COSTS 1,011,033 4,385,300 11,047,300 8%913,165 10,134,135 GRAND TOTAL 1,956,361 5,353,500 12,041,600 12%1,387,525 10,654,075 11,843,100 Less Other Revenues, Parts -33,500 -65,400 Less Transfer from Fund 34 for Principle/Interest on Loan for Capacity Projects -142,920 -55,580 -198,500 Less Trnsfr to Capital-being paid with loan -9,196,000 Contributed Assets -300,000 Revenue Shift -63,000 63,000 NET BASE COSTS 1,148,105 1,100,095 2015 FORECAST REVENUE 1,025,200 1,100,000 2015 PER UNIT CHARGE 0.82 15.87 (000) GAL.EQ. METERS 2015 BILLED UNITS 1,250,244 5,776 COST PER THOUSAND GALLONS/EQUIVALENT METERS 0.918 15.87 Old Rate 0.820 15.87 Increase 12.0%0.0% Cont Cap Other Volume Customer Total Total Revenue 300,000 9,493,400 1,148,105 1,100,000 12,041,505 Old Rate New Rate Increase WATER (10 Th. GAL)2.1%19.15 19.54 0.39 WATER (20 Th. GAL)5.0%27.35 28.73 1.38 DEQ LOAN PAYBACK-ESTIMATED-see amortization in matt folder CONSTRUCTION COSTS LOAN 11,100,000 LOAN 11,100,000 8.00%ENG.888,000 PRINCIPAL FOREGIVENES -2,211,250 1.25%ARTS 138,750 1,026,750 FINAL LOAN 8,888,750 TOTAL EXP 12,126,750 FUND 26 2,933,288 33%FUND 26 4,001,828 338,828 FUND 34 5,955,463 67%FUND 34 8,124,923 687,923 12,126,750 1,026,750 Year 1 FUND 34FUND 26 @ 100%Fund 26 @ 50% PRINCIPAL $198,500 $97,800 $48,900 INTEREST $104,200 $51,300 $25,650 $302,700 $149,100 $74,550 We hope to pay most, if not all of this with operating reserves. I purposely only budgeted 50% in case we decide to not deplete our reserves so significantly.mkn