The URL can be used to link to this page

Home My Public Portal About201306132012 Water Usage Versus Implement CPI - Amended.xlsxWATER TIERED RATE COMPARISON (2012 data) CURRENT RATES Commercial Usage Volume 0-3,000 3,000-5,000 5,000-10,000 10,000-20,000 20,000 & ABOVE TOTALS Municipal Usage Volume 0-3,000 3,000-5,000 5,000-10,000 10,000-20,000 20,000 & ABOVE TOTALS Residential Usage Volume 0-3,000 3,000-5,000 5,000-10,000 10,000-20,000 20,000 & ABOVE TOTALS Seniors - 1/2 price on base rate only Usage Volume 0-3,000 3,000-5,000 5,000-10,000 10,000-20,000 20,000 & ABOVE TOTALS Sprinkler Usage Volume 0-5000 5,000-10,000 10,000-20,000 20,000 & ABOVE TOTALS GRAND TOTALS FOR CURRENT RATES VERSUS NEW TIERED RATE Per 1000 Gal Rate 3 3.25 3.5 3.75 Per 1000 Gal Rate 3 3.25 3.5 3.75 Per 1000 Gal Rate 3 3.25 3.5 3.75 Per 1000 Gal Rate 3 3.25 3.5 3.75 Per 1000 Gal Rate 3 3.25 3.5 4.5 Bills 1596 874 788 645 487 Bills 360 164 134 76 46 Bills 34347 15727 9639 3721 1131 Bills 561 178 67 22 1 Bills 1791 692 502 278 Yearly Consumption 18206 1696 3650 5725 21579 50856 Yearly Consumption 641 312 540 604 14045 16142 Yearly Consumption 88916 27944 32969 22131 16546 188506 Yearly Consumption 1318 284 205 97 2 1906 Yearly Consumption 4294 3068 3845 7320 18527 WATER (Based on consumption only) SEWER (Based on consumption only) Total Charges 0 5088 11862.5 20037.5 80921.25 117909.25 Total Charges 0 936 1755 2114 52668.75 57473.75 Total Charges 0 83832 107149.25 77458.5 62047.5 330487.25 Total Charges 0 852 666.25 339.5 7.5 1865.25 Total Charges 12882 9971 13457.5 32940 69250.5 576986 CONSUMPTION ONLY RATE CHANGE WITH 3 YEARS OF CPI INCREASSES CPI Increase based on last 3 years Commercial Usage Volume 0-3,000 3,000-5,000 5,000-10,000 10,000-20,000 20,000 & ABOVE TOTALS Municipal Usage Volume 0-3,000 3,000-5,000 5,000-10,000 10,000-20,000 20,000 & ABOVE TOTALS Residential Usage Volume 0-3,000 3,000-5,000 5,000-10,000 10,000-20,000 20,000 & ABOVE TOTALS Seniors - 1/2 price on base rate only Usage Volume 0-3,000 3,000-5,000 5,000-10,000 10,000-20,000 20,000 & ABOVE TOTALS Sprinkler Usage Volume 0-5000 5,000-10,000 10,000-20,000 20,000 & ABOVE TOTALS Total Difference Budget @ 80% Per 1000 Gal Rate 3.19 3.46 3.72 3.99 Per 1000 Gal Rate 3.19 3.46 3.72 3.99 Per 1000 Gal Rate 3.19 3.46 3.72 3.99 Per 1000 Gal Rate 3.19 3.46 3.72 3.99 Per 1000 Gal Rate 3.19 3.46 3.72 4.78 GRAND TOTALS FOR CURRENT RATES 36750.74 36750.74 73501.48 58801.184 Bills 1596 874 788 645 487 Bills 360 164 134 76 46 Bills 34347 15727 9639 3721 1131 Bills 561 178 67 22 1 Bills 1791 692 502 278 Yearly Consumption 18206 1696 3650 5725 21579 50856 Yearly Consumption 641 312 540 604 14045 16142 Yearly Consumption 88916 27944 32969 22131 16546 188506 Yearly Consumption 1318 284 205 97 2 1906 Yearly Consumption 4294 3068 3845 7320 18527 Total Charges 0 5410.24 12629 21297 86100.21 125436.45 Total Charges 0 995.28 1868.4 2246.88 56039.55 61150.11 Total Charges 0 89141.36 114072.74 82327.32 66018.54 351559.96 Total Charges 0 905.96 709.3 360.84 7.98 1984.08 Total Charges 13697.86 10615.28 14303.4 34989.6 73606.14 613736.74 Water: Commercial Multi Additional Units Commercial Single Bed & Breakfast (Commercial Rate) Municipal Residential - Single family Residential - Multi family/kitchen Consumption only/Sprinkler Residential - Senior Sewer: Commercial Multi Additional Units Commercial Single Bed & Breakfast (Commercial Rate) Municipal Residential - Single family Residential - Multi family /kitchen Residential - Senior Totals: Consumption Rate Increase @ 80% + Base Rate Increase : Expected Revenues increase based on 11 months of collection: Current Single Family Water & Sewer @ 3,000 gallons or below Current Single Family Water & Sewer @ 5,000 gallons consumed CIP Single Family Water & Sewer @ 3,000 gallons or below CIP Single Family Water & Sewer @ 5,000 gallons consumed Current Commercial Water & Sewer @ 3,000 gallons or below Current Commercial Water & Sewer @ a total of 5,000 gallons CIP Commercial Water & Sewer @ 3,000 gallons or below CIP Commercial Water & Sewer @ 5,000 gallons consumed Current Senior Water & Sewer @ 3,000 gallons or below Current Senior Water & Sewer @ 5,000 gallons consumed CIP Senior Water & Sewer @ 3,000 gallons or below CIP Senior Water & Sewer @ 5,000 gallons consumed Current Sprinkler Only Charge @ 2,000 gallons in a month CIP Sprinkler Only Charge @ 2,000 gallons in a month BASE RATE COMPARISON WITH 3 YEARS CPI INCREASES Current Rate 10.86 7 10.86 10.86 10.86 9.55 9.55 9.55 4.6 24.83 7 24.83 24.83 24.83 21.86 21.86 11.08 3 Years of CPI 11.55 7.44 11.55 11.55 11.55 10.15 10.15 10.15 4.89 26.4 7.44 26.4 26.4 26.4 23.24 23.24 11.78 31.41 43.41 33.39 46.15 35.69 47.69 37.95 50.71 15.77 27.77 16.67 29.43 15.55 16.53 # In Each Category 30 1 108 31 2853 150 38 30 2 97 18 2763 37 Per Month Increased 1.98 2.74 Increased 2.31 3.02 Increased 0.899999999999999 1.66 Increased 0.98 Individual Increases 0.690000000000001 0.44 0.690000000000001 0.690000000000001 0.690000000000001 0.6 0.6 0.6 0.29 1.57 0.44 1.57 1.57 1.57 1.38 1.38 0.699999999999999 Increased Revenue 248.4 5.28 894.240000000002 0 256.68 20541.6 0 1080 132.24 0 0 565.2 10.56 1827.48 0 339.12 45755.28 0 310.8 71966.88 130768.064 119870.7253