Laserfiche WebLink
City of Medina Attachment F <br /> Water Revenue Calculations-Hamel Water System <br /> 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 <br /> 1 <br /> 2 <br /> 3 <br /> 4 <br /> 5 <br /> 6 <br /> 7 Water Trunk Conneection Charge 3,580 3,940 4,689 5,064 5,469 5,906 6,379 6,889 7,440 8,035 8,678 9,373 <br /> 8 <br /> 9 Total Connection Revenue-Residential 519,100 114,260 295,382 1,063,374 1,011,725 809,161 478,409 172,227 208,326 152,673 390,522 46,863 <br /> 10 <br /> 11 Usage-Residential <br /> 12 Projected annual usage 82,044,386 113,032,382 98,289,062 103,531,922 121,008,122 136,403,822 147,804,962 154,046,462 156,126,962 158,457,122 160,038,302 163,783,202 <br /> 13 Average usage per connection per quarter 35,486 45,799 38,038 36,506 32,918 30,889 29,775 29,264 29,106 28,937 28,825 28,573 <br /> 14 Base charge-up to 10,000 gal/quarter 26.87 30.36 33.40 35.74 37.52 39.40 41.37 43.44 45.61 47.89 50.29 52.80 <br /> 15 Annual increase In minimum charge 13.00% 10.00% 7,00% 5,00% 5,00% 5,00%- 5,00% 5.00% 5,00% 5.00% 5,00% <br /> 16 Water rate over 10,000 gallons/quarter 2.69 3.04 3.34 3.56 3.76 3.94 4.14 4.35 4.57 4.79 5.03 5.29 <br /> 17 Annual increase in usage charge,up to 30,000 13.00% 10.00%' 7,00% 5.OD% rc 5:00% 5,DO% 'a 5.00% 5.00% 5,00% 5.00% 5.00% <br /> 18 Water rate over 30,000 gallons/quarter 2.94 3.53 3.88 4.15 4.36 4.58 4.81 5.05 5.30 5.56 5.84 6.14 <br /> 19 Annual increase in usage charge over30,OD0, 20,00% 10,00% 7.00% 5.00%s` 5.00% 5,00% 5,00% 5.00% '. 5.00% 5100% 5.00%' <br /> 20 Revenue for 1st 10,000 gallons/quarter 62,123 74,936 86,304 101,351 137,939 173,992 205,363 228,663 244,657 262,254 279,188 302,652 <br /> 21 Revenue for 10-30,000 gallons 83,075 100,208 114,074 124,485 139,201 154,016 167,825 179,727 189,942 200,884 211,958 225,116 <br /> 22 Revenue for over 30,000 gallons 152,542 195,401 148,762 167,666 205,766 243,543 277,094 303,234 322,696 343,888 364,686 391,880 <br /> 23 Discounted rate for seniors (2,200) (2,486) (2,735) (2,926) (3,072) (3,226) (3,387) (3,557) (3,734) (3,921) (4,117) (4,323) <br /> 24 Water revenue-residential 295,540 368,060 346,405 390,576 479,834 568,325 646,894 708,067 753,561 803,105 851,714 915,325 <br /> 25 Quarterly big for 27,000 gallons use per quarter 72.60 82.04 90.25 96.56 101.39 106.46" 111.78 117.37 123.24 129.40 °" 135.87 142.67 <br /> 26 <br /> 27 Number of New Commercial REU's 51 52 10 70 70 15 15 15 15 5 5 5 <br /> 28 WAC charge per REU 3,580 3,940 4,689 5,064 5,469 5,906 6,379 6,889 7,440 8,035 8,678 9,373 <br /> 29 Irrigation connections-new 0 0 0 0 0 0 0 0 0 0 0 1 <br /> 30 WAC charge per irrigation connection 3,580 3,940 4,689 5,064 5,469 5,906 6,379 6,889 7,440 8,035 8,678 9,373 <br /> 31 WACTotal-Commercial 182,580 204,880 46,886 354,458 382,815 88,594 95,682 103,336 111,603 40,177 43,391 56,235 <br /> 33 Commercial(Inc.charitable/churches)end In _._1I;al u e wnnecuons la hook-u fee connections(for slow lease- <br /> 34 Number of Commercial Connections 127 130 156 166 201 236 244 251 259 266 269 271 <br /> 35 Average Use/Connection/Quarter-CA 52,280 53,050 52,500 52,500 52,500 52,500 52,500 52,500 52,500 52,500 52,500 52,500 <br /> 36 Total Commercial Usage 26,558,240 27,586,000 32,760,000 34,860,000 42,210,000 49,560,000 51,135,000 52,710,000 54,285,000 55,860,000 56,385,0110 56,910,000 <br /> 37 <br /> 38 Annual increase in base charge 13,OD% 10.00% 7.00% 5.00% 5.00% 5.00% 5:00% 5.00% 5.00% 5.00% 5100%' <br /> 39 Water rate for 1 st quarter usage 2.69 3.04 3.34 3.58 3.76 3.94 4.14 4.35 4.57 4.79 5.03 5.29 <br /> 40 Usage charge(over first quarter use) 3.13 3.54 3.89 4.16 4.37 4.59 4.82 5.06 5.31 5.58 5.86 6.15 <br /> 41 Annual increase in commercial usage charge 13.0011A 10.00% 7.0o% 5,00% 5.00% 5.DO% a 5,00% 5.00% 5.00% S.DO% 5.00% <br /> 42 Water usage revenue-commercial/industrial 76,513 88,502 117,315 133,573 169,823 209,364 226,818 245,495 265,472 286,833 304,005 322,177 <br /> 43 <br /> 44 Total WAC Revenue 701,680 319,140 342,268 1,417,833 1,394,540 897,755 574,091 275,564 319,929 192,850 433,914 103,098 <br /> 45 Total Usage',Water Revenues 372,053 456,562 463,720 524,149 649,657 777,689 873,712 953,562 1,019,033 1,089.937 1,155.719 1,237,502; <br /> 2/21/2007 <br /> J <br />