Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
UB-wwratestudy
WASTEWATER RATE CALCULATION Effective:10/1/2018 FIXED COST CITY OF REXBURG 2017 2018 2019 REXBURG OPER.CAPITAL BASE FEES ACTUAL FORECAST ESTIMATED COLLECTIONS TREATMT TREATMT WHETHER ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS ONLY COSTS COSTS USE SYSTEM OR NOT Treatment OPERATING COSTS 27-435.10 SALARIES 388,895 461,300 458,200 93%426,126 426,126 32,074 27-435.100 CERTIFICATION RAISES 0 0 4,800 93%4,464 4,464 336 27-435.101 ADD MAINT. POSITION 50/50 0 0 35,000 93%32,550 32,550 2,450 27-435.15 FULLTIMER OVERTIME 7,647 7,500 7,500 93%6,975 6,975 525 27-435.152 BLDG MAINT LABOR 0 400 400 93%372 372 28 27-435.16 PART-TIME WAGES 7,955 11,000 7,000 93%6,510 6,510 490 27-435.19 ACCRUED LEAVE 11,189 8,000 8,000 93%7,440 7,440 560 27-435.20 BENEFITS 221,074 237,100 251,200 93%233,616 233,616 17,584 27-435.24 PERSI PENSION EXP ADJ 2,676 0 0 93%0 0 0 27-435.25 W/C SURCHARGE 1,315 400 500 93%465 465 35 27-435.251 W/C REFUND -2,947 -2,100 -2,500 93%-2,325 -2,325 -175 27-435.27 UNIFORMS 1,722 1,600 1,600 93%1,488 1,488 112 27-435.29 WELLNESS PROGRAM 1,471 1,600 1,600 93%1,488 1,488 112 TOTAL PERSONNEL COSTS 640,997 726,800 773,300 93%719,169 0 719,169 54,131 27-435.30 SUPPLIES 20,626 20,000 20,000 95%19,000 19,000 1,000 27-435.301 LAB SUPPLIES 11,268 12,000 12,000 95%11,400 11,400 600 27-435.302 UV SYSTEM SUPPLIES 0 8,700 8,700 100%8,700 8,700 0 27-435.31 POSTAGE 1,048 1,300 1,300 93%1,209 1,209 91 27-435.32 CHEMICALS FOR TREATMENT 49,818 70,000 70,000 100%70,000 70,000 0 27-435.35 GAS & OIL 11,766 12,500 13,500 93%12,555 12,555 945 27-435.39 SMALL TOOLS 9,546 6,000 6,000 93%5,580 5,580 420 27-435.40 SHOTS/DRUG TESTS/BACKGROUND 120 200 200 93%186 186 14 27-435.41 LAND FILL TIPPING/HAULING FEES 139,773 140,000 140,000 100%140,000 140,000 0 27-435.42 TESTING HIRED OUT 11,427 12,000 15,000 93%13,950 13,950 1,050 27-435.43 HIRED WORK 1,683 1,800 1,800 5%90 90 1,710 27-435.431 ENG.-INSPECTIONS/SMALL PROJ.79 10,000 10,000 93%9,300 9,300 700 27-435.432 HIRED WORK-ENG.CONSULTANT/LIC.8,170 6,000 6,000 93%5,580 5,580 420 27-435.433 HIRED WORK-ODD YR.AERIAL PHOTO 6,515 100 7,500 93%6,975 6,975 525 27-435.45 ADVERTISING 143 200 200 93%186 186 14 27-435.46 INSURANCE 17,294 18,000 20,300 97%19,691 19,691 609 27-435.47 TRAVEL & TRAINING & MEETINGS 10,741 8,000 8,000 93%7,440 7,440 560 27-435.48 BANKING/CC CHARGES 7,338 7,500 7,500 0%0 0 7,500 27-435.481 DUES & MEMBERSHIP 359 500 500 93%465 465 35 27-435.49 STATEMENT BILLING 5,703 4,000 4,000 0%0 0 4,000 27-435.51 TELEPHONE/INTERNET 5,128 5,800 6,000 93%5,580 5,580 420 27-435.52 HEAT-NATURAL GAS 23,229 52,000 40,000 93%37,200 37,200 2,800 27-435.531 POWER-EFF BLDG/IRRIG 778 800 800 100%800 800 0 27-435.532 POWER-OLD TFMR/BLOWR 300,986 320,000 250,000 100%250,000 250,000 0 27-435.533 POWER-NEW TFMR 40,237 43,500 43,500 100%43,500 43,500 0 27-435.534 POWER-GRAV BELT/BLOWER 21,602 30,000 30,000 100%30,000 30,000 0 27-435.58 WATE/SEWER/GARBAGE-85%3,305 3,600 3,600 100%3,600 3,600 0 27-435.59 REP-PUMP/BLOWR 23,069 35,000 35,000 100%35,000 35,000 0 27-435.591 REP-K-MART LIFT STN 0 0 0 0%0 0 0 Volume TREATMENT AND COLL. RELATED TO VOLUME WASTEWATER RATE CALCULATION Effective:10/1/2018 FIXED COST CITY OF REXBURG 2017 2018 2019 REXBURG OPER.CAPITAL BASE FEES ACTUAL FORECAST ESTIMATED COLLECTIONS TREATMT TREATMT WHETHER ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS ONLY COSTS COSTS USE SYSTEM OR NOT Volume TREATMENT AND COLL. RELATED TO VOLUME 27-435.591 REP-SCREW PRESSES/GBT/ETC 0 75,000 0 100%0 0 0 27-435.60 REP-BUILDING 15,047 13,000 13,000 95%12,350 12,350 650 27-435.61 REP-EQUIPMENT 28,408 48,000 68,000 95%64,600 64,600 3,400 27-435.62 PARTS & PIPE 0 0 0 100%0 0 0 27-435.64 COMPUTER PROGRM 16,335 20,000 20,000 50%10,000 10,000 10,000 27-435.69 MISCELLANEOUS 0%0 0 0 TOTAL OPERATING COSTS 791,541 985,500 862,400 96%824,937 0 824,937 0 37,463 FIXED COSTS 94%=TREATMENT PERCENT OF (PERSONNEL + OPERATIONS) 27-435.77 DEPRECIATION 800,857 810,000 815,000 90%733,500 0 733,500 81,500 DEPREC. /UPGRADE 230,000 100%230,000 230,000 0 DEPREC. /UPG OFFSET -230,000 100%-230,000 0 -230,000 0 27-435.78 LIABILITY LOSS 425 1,000 1,000 100%1,000 0 1,000 0 27-435.79 BAD DEBT WRITEOFFS 312 1,000 1,000 0%0 0 0 1,000 27-435.84 CONT. CAP OFFSET 0 0 0 0%0 0 0 0 27-435.85 ASSET DISPOSAL 0 10,000 10,000 100%10,000 0 10,000 0 27-435.89 PRINCIPAL PAYMENTS 0 301,300 310,500 90%279,450 0 279,450 31,050 27-435.891 PRINCIPAL PAYMENTS-Offset by revenue 0 353,700 364,500 90%328,050 328,050 36,450 27-435.90 BOND INTEREST 105,676 96,500 87,400 90%78,660 0 78,660 8,740 27-435.901 BONDS PREM AMORT -9,020 -9,000 -9,000 90%-8,100 0 -8,100 -900 27-435.92 GIS OVERHEAD 0 0 0 90%0 0 0 27-435.94 RIGHT OF WAY CHG 0 0 0 90%0 0 0 27-435.95 SHOP EXP O/H 11,280 40,000 45,000 93%41,850 41,850 3,150 27-435.96 ASSET SECURITY EXP 185,796 165,600 167,500 12%20,868 20,868 146,632 27-435.97 PARKS SERVICES 0 0 0 0%0 0 0 27-435.98 CONTINGENCY 0 37,000 20,000 100%20,000 20,000 0 27-435.99 GEN. OVERHEAD 40%105,840 140,560 155,320 80%124,256 124,256 31,064 27-435.99 A/R OVERHEAD 40%105,840 140,560 155,320 80%124,256 124,256 31,064 27-435.99 A/P OVERHEAD 20%52,920 70,280 77,660 80%62,128 62,128 15,532 27-435.999 TRNSFR TO CAP-MAINT PROJ 1,895,849 230,000 46,000 0%0 0 46,000 TOTAL FIXED COSTS 3,255,775 2,388,500 2,247,200 81%1,815,918 0 623,358 1,192,560 431,282 Collections OPERATING COSTS 27-475.10 SALARIES/FULL TIME 134,818 178,000 190,000 4.72%8,968 59,741 8,968 121,291 27-475.100 CERTIFICATION RAISES 0 0 1,800 4.72%85 566 85 1,149 27-475.101 ADD MAINT. POSITION-50/50 0 0 35,000 4.72%1,652 11,005 1,652 22,343 27-475.15 FULLTIMER OVERTIME 1,740 1,500 1,500 4.72%71 472 71 957 27-475.19 ACCRUED LEAVE 12,203 10,000 10,000 4.72%472 3,144 472 6,384 27-475.20 BENEFITS 79,333 100,500 107,800 4.72%5,088 33,895 5,088 68,817 27-475.24 PERSI PENSION EXP ADJ 1,082 0 0 4.72%0 0 0 0 27-475.25 W/C SURCHARGE 4.72%0 0 0 0 27-475.251 W/C REFUND 0 -600 -600 4.72%-28 -189 -28 -383 27-475.27 UNIFORMS 475 1,200 1,200 4.72%57 377 57 766 27-475.29 WELLNESS PROGRAM 86 800 800 4.72%38 251 38 511 TOTAL PERSONNEL COSTS 229,737 291,400 347,500 4.72%16,403 109,262 16,403 0 221,835 WASTEWATER RATE CALCULATION Effective:10/1/2018 FIXED COST CITY OF REXBURG 2017 2018 2019 REXBURG OPER.CAPITAL BASE FEES ACTUAL FORECAST ESTIMATED COLLECTIONS TREATMT TREATMT WHETHER ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS ONLY COSTS COSTS USE SYSTEM OR NOT Volume TREATMENT AND COLL. RELATED TO VOLUME 27-475.30 SUPPLIES 9,806 8,200 8,200 4.72%2,706 1,813 2,706 3,681 27-475.35 GAS & OIL 5,299 8,400 9,000 4.72%425 2,830 425 5,745 27-475.39 SMALL TOOLS 1,416 3,500 3,500 4.72%165 1,101 165 2,234 27-475.40 SHOTS/DRUG TESTS 450 300 300 4.72%14 94 14 192 27-475.43 HIRED WORK 1,657 4,500 3,000 4.72%142 943 142 1,915 27-475.431 ENG.-INSPECTIONS/SMALL PROJ.10,770 12,000 12,000 4.72%566 3,773 566 7,661 27-475.433 HIRED WORK-ODD YR.-AERIAL PHOTO 0 300 7,000 4.72%330 2,201 330 4,469 27-475.45 ADVERTISING & PUBLISHING 56 100 100 4.72%5 31 5 64 27-475.46 INSURANCE 27,756 44,400 48,300 4.72%2,280 15,187 2,280 30,833 27-475.47 TRAVEL & TRAINING 4,008 4,000 4,000 4.72%189 1,258 189 2,553 27-475.48 BANKING/CC CHARGES 7,338 8,000 8,000 0.0%0 0 8,000 27-475.481 DUES & MEMBERSHIP 126 400 400 4.72%19 126 19 255 27-475.49 STATEMENT BILLING 1,654 4,000 4,000 0.0%0 0 4,000 27-475.51 TELEPHONE & INTERNET 1,350 1,500 1,500 4.72%71 472 71 957 27-475.54 LIFT STAT POWER-NON-V RIVER DR 27,644 28,400 28,400 100%28,400 28,400 0 0 27-475.541 LIFT STAT POWER-V RIVER DR 6,656 7,000 7,000 0%0 0 7,000 27-475.58 WATER/SEWER/GARBAGE-15%270 300 300 0%0 0 300 27-475.59 REPAIRS-PUMPS,LIFT STN 11,370 20,000 20,000 90%18,000 18,000 0 2,000 27-475.591 REPAIRS-V RIVER DR LIFTSTATION 352 8,000 4,000 0%0 0 4,000 27-475.60 REPAIRS-BUILDINGS 2,486 4,000 4,000 4.72%189 1,258 189 2,553 27-475.61 EQUIPMENT REPAIRS 8,769 8,500 8,500 4.72%401 2,673 401 5,426 27-475.62 PARTS & PIPE & LINE REPAIRS 4,944 5,000 5,000 90%4,500 4,288 212 500 27-475.64 COMPUTER PROGRAM 5,559 9,400 9,400 50%4,700 4,478 222 4,700 TOTAL OPERATING COSTS 139,736 190,200 195,900 32%63,102 88,924 7,936 0 99,040 27-475.77 DEPRECIATION 368,094 380,000 440,000 90%396,000 0 396,000 44,000 27-475.78 LIABILITY LOSS 9,103 6,000 6,000 100%6,000 6,000 0 0 27-475.84 CONT. CAP OFFSET 0 1,250,000 850,000 100%850,000 0 850,000 0 27-475.85 ASSET DISPOSALS 0 2,500 2,500 100%2,500 0 2,500 0 27-475.92 GIS OVERHEAD 71,186 77,000 85,200 100%85,200 4,021 81,179 27-475.94 RIGHT OF WAY CHARGE 231,900 266,300 292,900 100%292,900 13,825 279,075 27-475.95 SHOP EXPENSES 2,630 10,000 10,000 4.72%472 472 9,528 27-475.96 ASSET SECURITY 88,596 111,600 112,800 8.3%9,400 62,040 9,400 41,360 27-475.98 CONTINGENCY 0 9,000 10,900 100%10,900 6,231 514 4,154 27-475.99 GEN. OVERHEAD 40%48,638 56,160 59,480 80%47,584 34,340 2,246 22,894 A/R OVERHEAD 40%48,638 56,160 59,480 80%47,584 34,340 2,246 22,894 A/P OVERHEAD 20%24,319 28,080 29,740 80%23,792 17,170 1,123 11,447 TOTAL FIXED COSTS 893,104 2,252,800 1,959,000 90%1,772,332 160,122 33,848 1,248,500 516,530 GRAND TOTAL 5,950,890 6,835,200 6,385,300 82%5,211,861 358,308 2,225,651 2,441,060 1,360,281 LESS INDUSTRIAL USERS SURCHARGES -50,000 -150,000 LESS LIFT STATION POWER FOR SUGAR/TETON 76.39%-8,403 % increase fixed costs 1.013816021 LESS OTHER INCOME -41,800 -70,000 Contributed Capital -850,000 0 Less Trnsfr to Cap-Maint. Proj.-Paid from Operating Cash Reserves 0 -46,000 Less Prin PMT from Fund 35 -328050 -36,450 WASTEWATER RATE CALCULATION Effective:10/1/2018 FIXED COST CITY OF REXBURG 2017 2018 2019 REXBURG OPER.CAPITAL BASE FEES ACTUAL FORECAST ESTIMATED COLLECTIONS TREATMT TREATMT WHETHER ACCT # ACCT NAME EXPENSES EXPENSES EXPENSES SHARE COSTS ONLY COSTS COSTS USE SYSTEM OR NOT Volume TREATMENT AND COLL. RELATED TO VOLUME COST TRANSFER TOTAL TREATMENT COSTS 358,308 $2,225,651 $1,171,211 $1,049,428 TOT GAL REX GAL METERS 2017 FORECAST REVENUE 3,200,000 940,000 2017 PER UNIT CHARGE 2.40 4.22 14.40 Current Forecast REXBURG GALLONS (000)-/-EQUIVALENT METERS 758,294 758,294 5,440 $208,000 SUGAR CITY USAGE (000'S GALLONS)86,667 10.01% $51,000 TETON CITY USAGE (000'S GALLONS)21,250 2.45% $259,000 866,211 12.46% Wastewater Treatment Costs/1000 Gallons SUGAR/TETON REXBURG REXBURG TREATMENT TREATMENT FIXED COST COSTS COSTS BASE FEE OPERATING TREATMENT COST/1000 GAL.2.57 2.57 REXBURG COLLECTIONS ONLY ADDITIONAL COST 0.47 K-MART LIFT STATION POWER & REPAIR COSTS 0.08 0.08 REXBURG CAPITAL TREATMENT COST/1000 GAL.1.46 TOTAL TREATMENT COST/1000 GAL.2.65 4.58 REXBURG COST PER EQUIVALENT METER 16.08 Old Rate $2.40 $4.22 $14.40 Change in Rate $0.25 $0.36 $1.68 Total Increase 10.42%8.53%11.67% Total Revenue -New Rates $285,979 $3,472,986 $1,049,667 INCREASED AMOUNT TO COME FROM FUND BALANCE CARRYOVER What is causing the Increases? Expenses 2017 2019 % Change Personnel 868,058 1,120,800 29.12%Went from FTE 9 in 2016 to FTE 13.5 in 2019 Operations 931,277 1,058,300 13.64% Depreciation 1,168,951 1,255,000 7.36% Other Fixed Costs (Includes Depreciation)4,148,879 4,206,200 1.38% Staff Recommends we take the full calculated increase. Reserves are low for sewer.