Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
WA1005-CS110712
(7/20/2011) George Marshall - Re: Water & Wastewater billing infoPage 1 From: Jessica Brown <JLB@freese.com> To: George Marshall <GMARSHALL@coppelltx.gov> Date: 7/12/2011 1:09 PM Subject: Re: Water & Wastewater billing info Thanks! Jessica Brown, P.E. Freese and Nichols, Inc. (817) 735-7406 On Jul 12, 2011, at 1:01 PM, "George Marshall" <GMARSHALL@coppelltx.gov> wrote: > Scott will be sending you ftp info for xls. The file was 70+mb > -----Original Message----- > From: Jessica Brown <JLB@freese.com> > To: George Marshall <GMARSHALL@coppelltx.gov> > > Sent: 7/12/2011 12:59:23 PM > Subject: Re: Water & Wastewater billing info > > Just checking - the rest of the billing data will be coming later? This definitely gets me what we need for overall water usage. > > Jessica Brown, P.E. > Freese and Nichols, Inc. > (817) 735-7406 > > On Jul 12, 2011, at 10:05 AM, "George Marshall" <gmarshall@coppelltx.gov> wrote: > >> Jessica B., >> >> Please see attached for utility billing info. >> >> Thank You, George >> >> George Marshall, PE >> City of Coppell >> Engineering >> 972-304-3562 >> >> >>>>> Chad Beach 7/12/2011 9:24 AM >>> >> George, see attached docs. >> >>>>> George Marshall 7/7/2011 12:04 PM >>> >> Thank you! >> -----Original Message----- >> From: Chad Beach >> To: George Marshall <GMARSHALL@coppelltx.gov<mailto:GMARSHALL@coppelltx.gov>> >> >> Sent: 7/7/2011 12:03:27 PM >> Subject: Re: Water & Wastewater billing info >> >> George, I was out last week and have bond presentations and a budget workshop on Monday. It will be Tuesday before I can stop and work on gathering the data you need. It looks like the majority of the (7/20/2011) George Marshall - Re: Water & Wastewater billing infoPage 2 historical water usage data being requested Ted should be able to get for you. Ted and I prepare the annual water usage report for the Tx Water Dev Board, Ted should have complete copies of that report for the prior 5 yrs. I put in a call to our programmer about pulling the utility billing data in electronic format as requested on the second bullet point under Historical Water Usage on their memo (not sure when that will be available). >> >> I talked to Ted on Tuesday, so give him call and see what he can provide >> >>>>> George Marshall 7/7/2011 10:49 AM >>> >> Chad, >> >> A few weeks ago I contacted Kay to gather some water usage billing info. I understand she forwarded it on to you. How is that going? Our consultant is meeting with us next week on Thursday to go over the project and would like to have that data to prep for the meeting. I was unaware that they needed it before this meeting. Is this something you can complete this week? >> >> Thank You, George >> >> >> George Marshall, PE >> City of Coppell >> Engineering >> 972-304-3562 >> >> Please consider the environment before printing this message. >> <CONSUM.XLS> >> <WS SEC 2011.pdf> >> <Top 20 Water Customers 2010.pdf> > > This electronic mail message is intended exclusively for the individual or entity to which it is addressed. This message, together with any attachment, may contain the sender's organization's confidential and privileged information. The recipient is hereby notified to treat the information as confidential and privileged and to not disclose or use the information except as authorized by sender's organization. Any unauthorized review, printing, retention, copying, disclosure, distribution, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this message in error, please immediately contact the sender by reply email and delete all copies of the material from any computer. Thank you for your cooperation. > > (7/20/2011) George Marshall - Re: Water & Wastewater billing infoPage 1 From: Chad Beach To:George Marshall Date: 7/12/2011 9:24 AM Subject: Re: Water & Wastewater billing info Attachments:CONSUM.XLS; WS SEC 2011.pdf; Top 20 Water Customers 2010.pdf George, see attached docs. >>> George Marshall 7/7/2011 12:04 PM >>> Thank you! -----Original Message----- From: Chad Beach To: George Marshall <GMARSHALL@coppelltx.gov> Sent: 7/7/2011 12:03:27 PM Subject: Re: Water & Wastewater billing info George, I was out last week and have bond presentations and a budget workshop on Monday. It will be Tuesday before I can stop and work on gathering the data you need. It looks like the majority of the historical water usage data being requested Ted should be able to get for you. Ted and I prepare the annual water usage report for the Tx Water Dev Board, Ted should have complete copies of that report for the prior 5 yrs. I put in a call to our programmer about pulling the utility billing data in electronic format as requested on the second bullet point under Historical Water Usage on their memo (not sure when that will be available). I talked to Ted on Tuesday, so give him call and see what he can provide >>> George Marshall 7/7/2011 10:49 AM >>> Chad, A few weeks ago I contacted Kay to gather some water usage billing info. I understand she forwarded it on to you. How is that going? Our consultant is meeting with us next week on Thursday to go over the project and would like to have that data to prep for the meeting. I was unaware that they needed it before this meeting. Is this something you can complete this week? Thank You, George George Marshall, PE City of Coppell Engineering 972-304-3562 CONSUM.XLS WATER CONSUMPTION HISTORY TOTAL AVERAGEAVERAGEMONTHLYTOTALAVERAGEAVERAGE RESIDENTIAL# OF RES.RESIDENTIALCOMMERCIAL# OF COMM.COMMERCIALCONS.# OFMONTHLYDAILYSeniorSeniorSenior DATECYCLECONSUMPTIONACCTS.CONSUMPTIONCONSUMPTIONACCTS.CONSUMPTIONBILLEDACCTS.CONS.USAGECons.Accts.Average 3/31/20111 & 2 2/28/20111 & 2 1/31/20111 & 2 94,176,700 10,947 8,603 45,813,600 1,330 34,446 139,990,300 12,277 11,403 4,515,816 3,361,500 491 6,846 12/31/20101 & 2 112,070,600 10,932 10,252 68,347,600 1,365 50,072 180,418,200 12,297 14,672 5,819,942 4,287,200 492 8,714 11/30/20101 & 2 138,985,000 10,921 12,726 93,342,300 1,384 67,444 232,327,300 12,305 18,881 7,744,243 5,216,800 490 10,647 10/31/20101 & 2 177,944,900 10,921 16,294 119,894,900 1,373 87,323 297,839,800 12,294 24,226 9,607,735 7,172,000 488 14,697 9/30/20101 & 2 245,584,700 10,912 22,506 158,673,900 1,396 113,663 404,258,600 12,308 32,845 13,475,287 10,044,000 488 20,582 8/31/20101 & 2 247,266,300 10,853 22,783 146,968,200 1,396 105,278 394,234,500 12,249 32,185 12,717,242 10,034,200 482 20,818 7/31/20101 & 2 200,411,100 10,861 18,452 128,387,800 1,384 92,766 328,798,900 12,245 26,852 10,606,416 7,940,500 480 16,543 6/30/20101 & 2 202,704,200 10,840 18,700 127,260,600 1,386 91,819 329,964,800 12,226 26,989 10,998,827 7,885,700 479 16,463 5/31/20101 & 2 136,115,300 10,854 12,541 78,477,600 1,382 56,786 214,592,900 12,236 17,538 6,922,352 4,861,200 471 10,321 4/30/20101 & 2 102,646,100 10,860 9,452 61,140,400 1,375 44,466 163,786,500 12,235 13,387 5,459,550 3,546,000 472 7,513 3/31/20101 & 2 65,697,200 10,833 6,065 37,653,700 1,339 28,121 103,350,900 12,172 8,491 3,333,900 2,090,000 470 4,447 2/28/20101 & 2 65,555,400 10,873 6,029 34,272,600 1,328 25,808 99,828,000 12,201 8,182 3,565,286 2,127,800 470 4,527 1/31/20101 & 2 81,719,100 10,857 7,527 38,422,800 1,334 28,803 120,141,900 12,191 9,855 3,875,545 2,704,200 464 5,828 12/31/20091 & 2 83,209,100 10,832 7,682 47,429,200 1,346 35,237 130,638,300 12,178 10,727 4,214,139 2,739,100 465 5,891 11/30/20091 & 2 85,575,900 10,830 7,902 60,593,800 1,365 44,391 146,169,700 12,195 11,986 4,872,323 2,800,000 462 6,061 10/31/20091 & 2 113,787,500 10,811 10,525 77,774,400 1,370 56,770 191,561,900 12,181 15,726 6,179,416 4,074,700 463 8,801 9/30/20091 & 2 212,319,800 10,797 19,665 137,193,500 1,367 100,361 349,513,300 12,164 28,733 11,650,443 8,122,000 465 17,467 8/31/20091 & 2 237,009,100 10,789 21,968 139,008,700 1,360 102,212 376,017,800 12,149 30,951 12,129,606 8,900,300 465 19,140 7/31/20091 & 2 247,443,200 10,796 22,920 165,169,100 1,366 120,914 412,612,300 12,162 33,926 13,310,074 9,620,300 463 20,778 6/30/20091 & 2 143,424,800 10,744 13,349 79,909,100 1,362 58,670 223,333,900 12,106 18,448 7,444,463 5,047,500 461 10,949 5/31/20091 & 2 107,962,300 10,791 10,005 68,223,200 1,323 51,567 176,185,500 12,114 14,544 5,683,403 3,716,200 464 8,009 4/30/20091 & 2 115,561,200 10,783 10,717 76,958,400 1,322 58,214 192,519,600 12,105 15,904 6,417,320 4,092,500 466 8,782 3/31/20091 & 2 102,442,600 10,807 9,479 64,640,500 1,354 47,740 167,083,100 12,161 13,739 5,389,777 3,862,400 464 8,324 2/28/20091 & 2 92,217,600 10,809 8,532 50,076,600 1,310 38,226 142,294,200 12,119 11,741 5,081,936 3,288,600 462 7,118 1/31/20091 & 2 92,872,200 10,807 8,594 51,936,700 1,295 40,106 144,808,900 12,102 11,966 4,671,255 2,983,400 443 6,735 Page 1 CONSUM.XLS WATER CONSUMPTION HISTORY TOTAL AVERAGEAVERAGEMONTHLYTOTALAVERAGEAVERAGE RESIDENTIAL# OF RES.RESIDENTIALCOMMERCIAL# OF COMM.COMMERCIALCONS.# OFMONTHLYDAILYSeniorSeniorSenior DATECYCLECONSUMPTIONACCTS.CONSUMPTIONCONSUMPTIONACCTS.CONSUMPTIONBILLEDACCTS.CONS.USAGECons.Accts.Average 12/31/20081 & 2 107,742,900 10,801 9,975 108,230,100 1,340 80,769 215,973,000 12,141 17,789 6,966,871 3,457,600 419 8,252 11/30/20081 & 2 142,509,400 10,784 13,215 84,516,500 1,296 65,213 227,025,900 12,080 18,794 7,567,530 4,829,300 417 11,581 10/31/20081 & 2 171,495,300 10,774 15,918 113,087,700 1,293 87,461 284,583,000 12,067 23,584 9,180,097 5,959,900 415 14,361 9/30/20081 & 2 203,212,700 10,754 18,896 138,761,600 1,340 103,553 341,974,300 12,094 28,276 11,399,143 6,856,300 418 16,403 8/31/20081 & 2 251,871,800 10,735 23,463 161,348,000 1,338 120,589 413,219,800 12,073 34,227 13,329,671 8,600,400 417 20,624 7/31/20081 & 2 234,799,400 10,720 21,903 149,759,000 1,333 112,347 384,558,400 12,053 31,906 12,405,110 8,024,000 418 19,196 6/30/20081 & 2 191,972,700 10,730 17,891 124,791,200 1,323 94,324 316,763,900 12,053 26,281 10,558,797 6,318,700 417 15,153 5/31/20081 & 2 132,659,800 10,743 12,348 80,480,900 1,311 61,389 213,140,700 12,054 17,682 6,875,506 4,231,700 419 10,100 4/30/20081 & 2 91,848,400 10,737 8,554 52,331,500 1,295 40,410 144,179,900 12,032 11,983 4,805,997 2,681,600 422 6,355 3/31/20081 & 2 86,877,900 10,743 8,087 48,930,000 1,285 38,078 135,807,900 12,028 11,291 4,380,900 2,660,800 424 6,275 2/29/20081 & 2 85,018,000 10,767 7,896 49,960,500 1,274 39,215 134,978,500 12,041 11,210 4,654,431 2,571,800 426 6,037 1/31/20081 & 2 84,376,500 10,784 7,824 51,858,800 1,271 40,802 136,235,300 12,055 11,301 4,394,687 2,555,400 426 5,999 12/31/20071 & 2 103,702,900 10,764 9,634 55,664,500 1,282 43,420 159,367,400 12,046 13,230 5,140,884 3,341,700 428 7,808 11/30/20071 & 2 143,196,500 10,765 13,302 103,650,700 1,273 81,422 246,847,200 12,038 20,506 8,228,240 4,698,200 427 11,003 10/31/20071 & 2 159,464,700 10,764 14,815 107,916,700 1,268 85,108 267,381,400 12,032 22,223 8,625,206 5,274,900 424 12,441 9/30/20071 & 2 191,176,400 10,746 17,790 117,457,500 1,282 91,621 308,633,900 12,028 25,660 10,287,797 6,471,400 424 15,263 8/31/20071 & 2 179,627,500 10,681 16,817 109,135,400 1,270 85,933 288,762,900 11,951 24,162 9,314,932 5,842,700 425 13,748 7/31/20071 & 2 109,295,300 10,661 10,252 68,334,800 1,259 54,277 177,630,100 11,920 14,902 5,730,003 3,586,900 427 8,400 6/30/20071 & 2 111,270,700 10,680 10,419 63,906,200 1,253 51,003 175,176,900 11,933 14,680 5,839,230 3,528,200 429 8,224 5/31/20071 & 2 105,380,500 10,716 9,834 65,323,400 1,262 51,762 170,703,900 11,978 14,251 5,506,577 3,307,500 430 7,692 4/30/20071 & 2 106,653,700 10,711 9,957 75,561,200 1,257 60,112 182,214,900 11,968 15,225 6,073,830 3,365,500 430 7,827 3/31/20071 & 2 102,525,900 10,746 9,541 60,060,800 1,239 48,475 162,586,700 11,985 13,566 5,244,732 3,248,200 431 7,536 2/28/20071 & 2 75,096,900 10,747 6,988 40,621,700 1,243 32,680 115,718,600 11,990 9,651 4,132,807 2,272,700 433 5,249 1/31/20071 & 2 88,299,400 10,743 8,219 51,184,000 1,219 41,989 139,483,400 11,962 11,661 4,499,465 2,743,600 431 6,366 12/31/20061 & 2 112,630,300 10,728 10,499 70,695,400 1,231 57,429 183,325,700 11,959 15,330 5,913,732 3,930,500 431 9,119 11/30/20061 & 2 132,458,700 10,708 12,370 94,300,000 1,234 76,418 226,758,700 11,942 18,988 7,558,623 4,491,600 424 10,593 10/31/20061 & 2 178,437,300 10,718 16,648 113,344,900 1,234 91,852 291,782,200 11,952 24,413 9,412,329 6,067,000 425 14,275 9/30/20061 & 2 258,997,900 10,707 24,190 144,322,800 1,229 117,431 403,320,700 11,936 33,790 13,010,345 8,787,900 423 20,775 Page 2 CONSUM.XLS WATER CONSUMPTION HISTORY TOTAL AVERAGEAVERAGEMONTHLYTOTALAVERAGEAVERAGE RESIDENTIAL# OF RES.RESIDENTIALCOMMERCIAL# OF COMM.COMMERCIALCONS.# OFMONTHLYDAILYSeniorSeniorSenior DATECYCLECONSUMPTIONACCTS.CONSUMPTIONCONSUMPTIONACCTS.CONSUMPTIONBILLEDACCTS.CONS.USAGECons.Accts.Average 8/31/20061 & 2 273,578,700 10,664 25,654 175,257,100 1,219 143,771 448,835,800 11,883 37,771 14,478,574 9,482,400 421 22,524 7/31/20061 & 2 260,568,900 10,642 24,485 145,739,200 1,223 119,165 406,308,100 11,865 34,244 13,543,603 9,174,100 422 21,740 6/30/20061 & 2 248,356,900 10,625 23,375 140,810,100 1,219 115,513 389,167,000 11,844 32,858 12,972,233 8,312,400 423 19,651 5/31/20061 & 2 157,310,080 10,637 14,789 91,111,300 1,219 74,743 248,421,380 11,856 20,953 8,013,593 5,039,600 419 12,028 4/30/20061 & 2 144,883,300 10,668 13,581 80,146,680 1,214 66,019 225,029,980 11,882 18,939 7,500,999 4,489,800 406 11,059 3/31/20061 & 2 96,529,200 10,633 9,078 59,674,700 1,217 49,034 156,203,900 11,850 13,182 5,038,835 2,592,800 363 7,143 2/28/20061 & 2 110,191,000 10,641 10,355 57,352,600 1,190 48,195 167,543,600 11,831 14,161 5,983,700 3,000,800 365 8,221 1/31/20061 & 2 122,941,600 10,630 11,566 70,630,500 1,201 58,810 193,572,100 11,831 16,361 6,244,261 3,386,800 366 9,254 12/31/20051 & 2 138,461,900 10,587 13,078 66,336,900 1,175 56,457 204,798,800 11,762 17,412 6,606,413 4,298,200 366 11,744 11/30/20051 & 2 175,712,400 10,584 16,602 112,313,100 1,176 95,504 288,025,500 11,760 24,492 9,600,850 5,150,200 364 14,149 10/31/20051 & 2 225,289,200 10,582 21,290 124,806,100 1,170 106,672 350,095,300 11,752 29,790 11,293,397 6,721,400 361 18,619 9/30/20051 & 2 249,076,000 10,565 23,576 151,170,700 1,176 128,547 400,246,700 11,741 34,090 13,341,557 7,545,300 361 20,901 8/31/20051 & 2 221,194,400 10,484 21,098 132,887,900 1,159 114,657 354,082,300 11,643 30,412 11,422,010 6,253,200 356 17,565 7/31/20051 & 2 251,971,700 10,508 23,979 136,011,300 1,164 116,848 387,983,000 11,672 33,240 12,515,581 7,008,900 356 19,688 6/30/20051 & 2 194,944,600 10,517 18,536 113,554,800 1,144 99,261 308,499,400 11,661 26,456 10,283,313 5,034,700 355 14,182 5/31/20051 & 2 156,443,500 10,531 14,856 75,978,700 1,152 65,954 232,422,200 11,683 19,894 7,497,490 4,156,600 356 11,676 4/30/20051 & 2 128,956,500 10,533 12,243 56,432,700 1,131 49,896 185,389,200 11,664 15,894 6,179,640 3,321,500 354 9,383 3/31/20051 & 2 76,905,100 10,560 7,283 42,744,700 1,119 38,199 119,649,800 11,679 10,245 3,859,671 1,846,700 359 5,144 2/28/20051 & 2 69,620,800 10,549 6,600 33,024,200 1,085 30,437 102,645,000 11,634 8,823 3,665,893 1,587,000 357 4,445 1/31/20051 & 2 84,080,300 10,586 7,943 41,499,400 1,093 37,968 125,579,700 11,679 10,753 4,050,958 2,056,100 361 5,696 12/31/20041 & 2 80,429,200 10,567 7,611 45,152,800 1,097 41,160 125,582,000 11,664 10,767 4,051,032 1,949,800 357 5,462 11/30/20041 & 2 99,253,700 10,564 9,395 53,825,900 1,106 48,667 153,079,600 11,670 13,117 5,102,653 2,451,100 359 6,828 10/31/20041 & 2 158,062,100 10,561 14,967 78,866,200 1,114 70,796 236,928,300 11,675 20,294 7,642,848 4,399,500 358 12,289 9/30/20041 & 2 179,871,300 10,564 17,027 117,360,000 1,098 106,885 297,231,300 11,662 25,487 9,907,710 4,863,400 355 13,700 8/31/20041 & 2 209,800,900 10,531 19,922 112,560,900 1,103 102,050 322,361,800 11,634 27,709 10,398,768 5,945,300 355 16,747 7/31/20041 & 2 150,679,700 10,489 14,365 79,737,900 1,103 72,292 230,417,600 11,592 19,877 7,432,826 3,914,400 355 11,026 6/30/20041 & 2 140,809,400 10,492 13,421 81,870,700 1,092 74,973 222,680,100 11,584 19,223 7,422,670 3,758,000 351 10,707 5/31/20041 & 2 132,160,300 10,531 12,550 74,599,100 1,090 68,440 206,759,400 11,621 17,792 6,669,658 3,338,900 351 9,513 Page 3 CONSUM.XLS WATER CONSUMPTION HISTORY TOTAL AVERAGEAVERAGEMONTHLYTOTALAVERAGEAVERAGE RESIDENTIAL# OF RES.RESIDENTIALCOMMERCIAL# OF COMM.COMMERCIALCONS.# OFMONTHLYDAILYSeniorSeniorSenior DATECYCLECONSUMPTIONACCTS.CONSUMPTIONCONSUMPTIONACCTS.CONSUMPTIONBILLEDACCTS.CONS.USAGECons.Accts.Average 4/30/20041 & 2 123,084,500 10,461 11,766 56,045,800 1,090 51,418 179,130,300 11,551 15,508 5,971,010 3,011,400 337 8,936 3/31/20041 & 2 73,255,800 10,486 6,986 38,118,700 1,071 35,592 111,374,500 11,557 9,637 3,592,726 1,590,400 328 4,849 2/29/20041 & 2 72,999,300 10,498 6,954 36,230,300 1,061 34,147 109,229,600 11,559 9,450 3,766,538 1,637,300 329 4,977 1/31/20041 & 2 99,239,600 10,520 9,433 43,271,500 1,078 40,141 142,511,100 11,598 12,288 4,597,132 2,434,900 332 7,334 12/31/20031 & 2 103,569,500 10,478 9,884 58,525,800 1,088 53,792 162,095,300 11,566 14,015 5,228,881 2,460,800 330 7,457 11/30/20031 & 2 137,589,400 10,490 13,116 67,487,600 1,073 62,896 205,077,000 11,563 17,736 6,835,900 3,693,600 329 11,227 10/31/20031 & 2 269,853,200 10,516 25,661 87,296,900 1,086 80,384 357,150,100 11,602 30,783 11,520,971 3,916,600 327 11,977 9/30/20031 & 2 285,093,000 10,481 27,201 119,839,300 1,080 110,962 404,932,300 11,561 35,026 13,497,743 5,024,800 330 15,227 8/31/20031 & 2 296,393,300 10,450 28,363 160,562,300 1,078 148,945 456,955,600 11,528 39,639 14,740,503 7,860,300 334 23,534 7/31/20031 & 2 186,333,400 10,450 17,831 109,377,900 1,020 107,233 295,711,300 11,470 25,781 9,539,074 4,636,100 330 14,049 6/30/20031 & 2 166,976,100 10,474 15,942 92,774,700 1,069 86,786 259,750,800 11,543 22,503 8,658,360 4,091,100 327 12,511 21,612,300 1,321 16,361 5/31/20031 & 2 159,006,900 10,481 15,171 82,425,700 1,033 79,793 241,432,600 11,514 20,969 7,788,148 4/30/20031 & 2 112,381,900 10,481 10,722 54,643,300 1,018 53,677 167,025,200 11,499 14,525 5,567,507 3/31/20031 & 2 80,493,600 10,434 7,715 42,937,080 1,018 42,178 123,430,680 11,452 10,778 3,981,635 2/28/20031 & 2 80,555,200 10,431 7,723 44,024,400 1,002 43,937 124,579,600 11,433 10,896 4,449,271 1/31/20031 & 2 85,470,500 10,436 8,190 43,990,500 993 44,301 129,461,000 11,429 11,327 4,176,161 12/31/20021 & 2 101,054,800 10,420 9,698 53,876,000 996 54,092 154,930,800 11,416 13,571 4,997,768 11/30/20021 & 2 104,256,600 10,414 10,011 53,386,500 988 54,035 157,643,100 11,402 13,826 5,254,770 10/31/20021 & 2 181,415,600 10,438 17,380 98,332,900 1,017 96,689 279,748,500 11,455 24,422 9,024,145 9/30/20021 & 2 251,412,900 10,429 24,107 118,669,400 1,006 117,962 370,082,300 11,435 32,364 12,336,077 6,393,200 321 19,917 8/31/20021 & 2 239,723,200 10,383 23,088 122,161,800 1,013 120,594 361,885,000 11,396 31,755 11,673,710 5,735,100 320 17,922 7/31/20021 & 2 181,927,100 10,389 17,512 93,495,300 977 95,696 275,422,400 11,366 24,232 8,884,594 4,167,300 319 13,064 6/30/20021 & 2 150,556,200 10,375 14,511 67,983,500 983 69,159 218,539,700 11,358 19,241 7,284,657 3,419,900 317 10,788 19,715,500 1,277 15,439 5/31/20021 & 2 116,790,400 10,406 11,223 58,991,200 968 60,941 175,781,600 11,374 15,455 5,670,374 4/30/20021 & 2 85,920,000 10,430 8,238 44,404,500 967 45,920 130,324,500 11,397 11,435 4,344,150 3/31/20021 & 2 86,508,300 10,432 8,293 40,128,500 973 41,242 126,636,800 11,405 11,104 4,085,058 2/28/20021 & 2 86,246,800 10,446 8,256 39,139,000 967 40,475 125,385,800 11,413 10,986 4,478,064 1/31/20021 & 2 88,650,900 10,460 8,475 40,460,800 958 42,235 129,111,700 11,418 11,308 4,164,894 Page 4 CONSUM.XLS WATER CONSUMPTION HISTORY TOTAL AVERAGEAVERAGEMONTHLYTOTALAVERAGEAVERAGE RESIDENTIAL# OF RES.RESIDENTIALCOMMERCIAL# OF COMM.COMMERCIALCONS.# OFMONTHLYDAILYSeniorSeniorSenior DATECYCLECONSUMPTIONACCTS.CONSUMPTIONCONSUMPTIONACCTS.CONSUMPTIONBILLEDACCTS.CONS.USAGECons.Accts.Average 12/31/20011 & 2 112,080,100 10,369 10,809 50,748,400 965 52,589 162,828,500 11,334 14,366 5,252,532 11/30/20011 & 2 148,711,700 10,389 14,314 67,762,100 951 71,254 216,473,800 11,340 19,089 7,215,793 10/31/20011 & 2 154,661,500 10,393 14,881 86,894,100 970 89,582 241,555,600 11,363 21,258 7,792,116 9/30/20011 & 2 215,124,900 10,370 20,745 89,578,200 950 94,293 304,703,100 11,320 26,917 10,156,770 5,172,400 315 16,420 8/31/20011 & 2 267,954,100 10,342 25,909 124,213,100 937 132,565 392,167,200 11,279 34,770 12,650,555 6,491,800 312 20,807 7/31/20011 & 2 233,853,500 10,314 22,673 111,177,600 938 118,526 345,031,100 11,252 30,664 11,130,035 5,151,100 310 16,616 6/30/20011 & 2 200,793,400 10,262 19,567 83,117,700 920 90,345 283,911,100 11,182 25,390 9,463,703 4,524,000 310 14,594 21,339,300 1,247 17,113 5/31/20011 & 2 134,085,400 10,316 12,998 153,824,300 906 169,784 287,909,700 11,222 25,656 9,287,410 4/30/20011 & 2 82,656,600 10,288 8,034 34,349,800 896 38,337 117,006,400 11,184 10,462 3,900,213 3/31/20011 & 2 69,034,600 10,266 6,725 27,774,300 861 32,258 96,808,900 11,127 8,700 3,122,868 2/28/20011 & 2 68,923,700 10,248 6,726 27,705,700 857 32,329 96,629,400 11,105 8,701 3,451,050 1/31/20011 & 2 84,368,800 10,242 8,238 33,472,200 858 39,012 117,841,000 11,100 10,616 3,801,323 12/31/20001 & 2 175,531,800 10,198 17,212 32,661,400 873 37,413 208,193,200 11,071 18,805 6,715,910 11/30/20001 & 2 119,451,900 10,235 11,671 57,022,100 900 63,358 176,474,000 11,135 15,849 5,882,467 10/31/20001 & 2 253,810,100 10,221 24,832 113,799,400 918 123,964 367,609,500 11,139 33,002 11,858,371 9/30/20001 & 2 298,302,100 10,163 29,352 116,941,300 880 132,888 415,243,400 11,043 37,602 13,841,447 8/31/20001 & 2 296,346,300 10,001 29,632 131,688,500 853 154,383 428,034,800 10,854 39,436 13,807,574 7/31/20001 & 2 175,455,400 10,002 17,542 76,307,000 823 92,718 251,762,400 10,825 23,257 8,121,368 6/30/20001 & 2 165,765,100 9,989 16,595 72,650,400 803 90,474 238,415,500 10,792 22,092 7,947,183 5/31/20001 & 2 121,238,700 9,977 12,152 48,464,000 798 60,732 169,702,700 10,775 15,750 5,474,281 4/30/20001 & 2 98,298,100 9,956 9,873 39,476,400 792 49,844 137,774,500 10,748 12,819 4,592,483 3/31/20001 & 2 98,873,200 9,938 9,949 47,362,600 803 58,982 146,235,800 10,741 13,615 4,717,284 2/29/20001 & 2 97,816,700 9,891 9,889 45,730,400 772 59,236 143,547,100 10,663 13,462 4,949,900 1/31/20001 & 2 99,872,300 9,821 10,169 58,693,900 536 109,504 158,566,200 10,357 15,310 5,115,039 12/31/19991 & 2 116,069,100 9,833 11,804 53,181,800 604 88,049 169,250,900 10,437 16,216 5,459,706 11/30/19991 & 2 153,869,600 9,765 15,757 67,860,400 625 108,577 221,730,000 10,390 21,341 7,391,000 10/31/19991 & 2 206,050,300 9,769 21,092 90,965,400 639 142,356 297,015,700 10,408 28,537 9,581,152 9/30/19991 & 2 283,496,500 9,725 29,151 110,634,700 650 170,207 394,131,200 10,375 37,989 13,137,707 Page 5 CONSUM.XLS WATER CONSUMPTION HISTORY TOTAL AVERAGEAVERAGEMONTHLYTOTALAVERAGEAVERAGE RESIDENTIAL# OF RES.RESIDENTIALCOMMERCIAL# OF COMM.COMMERCIALCONS.# OFMONTHLYDAILYSeniorSeniorSenior DATECYCLECONSUMPTIONACCTS.CONSUMPTIONCONSUMPTIONACCTS.CONSUMPTIONBILLEDACCTS.CONS.USAGECons.Accts.Average 8/31/19991 & 2 268,595,900 9,677 27,756 104,421,500 645 161,894 373,017,400 10,322 36,138 12,032,819 7/31/19991 & 2 189,698,600 9,615 19,729 98,364,000 624 157,635 288,062,600 10,239 28,134 9,292,342 6/30/19991 & 2 141,384,700 9,609 14,714 49,492,300 587 84,314 190,877,000 10,196 18,721 6,362,567 5/31/19991 & 2 124,220,000 9,549 13,009 45,407,100 567 80,083 169,627,100 10,116 16,768 5,471,842 4/30/19991 & 2 94,758,100 9,574 9,897 37,058,800 677 54,740 131,816,900 10,251 12,859 4,393,897 3/31/19991 & 2 88,802,000 9,520 9,328 27,448,700 549 49,998 116,250,700 10,069 11,545 3,750,023 2/28/19991 & 2 79,467,200 9,483 8,380 47,237,000 484 97,597 126,704,200 9,967 12,712 4,525,150 1/31/19991 & 2 77,960,200 9,427 8,270 21,900,900 481 45,532 99,861,100 9,908 10,079 3,221,326 12/31/19981 & 2 83,041,400 9,397 8,837 27,737,400 506 54,817 110,778,800 9,903 11,186 3,573,510 11/30/19981 & 2 111,110,900 9,383 11,842 46,541,100 535 86,993 157,652,000 9,918 15,896 5,255,067 10/31/19981 & 2 179,086,300 9,359 19,135 70,143,400 563 124,589 249,229,700 9,922 25,119 8,039,668 9/30/19981 & 2 252,657,100 9,304 27,156 75,026,400 569 131,857 327,683,500 9,873 33,190 10,922,783 8/31/19981 & 2 260,493,700 9,204 28,302 70,683,200 549 128,749 331,176,900 9,753 33,956 10,683,126 7/31/19981 & 2 224,246,600 9,164 24,470 71,213,700 529 134,619 295,460,300 9,693 30,482 9,530,977 6/30/19981 & 2 172,366,800 9,062 19,021 56,807,400 530 107,184 229,174,200 9,592 23,892 7,639,140 5/31/19981 & 2129,468,7009,00814,37343,359,00050885,352 172,827,700 9,516 18,162 5,575,087 4/30/19981 & 283,314,0008,9589,30125,452,00046554,735 108,766,000 9,423 11,543 3,625,533 3/31/19981 & 262,017,1008,9546,92621,937,70042551,618 83,954,800 9,379 8,951 2,708,219 2/28/19981 & 265,068,9008,8947,31622,451,00041054,759 87,519,900 9,304 9,407 3,125,711 1/31/19981 & 264,870,9008,8747,31025,668,70042160,971 90,539,600 9,295 9,741 2,920,632 12/31/19971 & 281,085,1008,8589,15429,127,40047361,580 110,212,500 9,331 11,811 3,555,242 11/30/19971 & 294,433,4009,03010,45843,500,30062869,268 137,933,700 9,658 14,282 4,597,790 10/31/19971 & 2144,823,7009,00916,07563,807,900630101,282 208,631,600 9,639 21,645 6,730,052 9/30/19971 & 2182,985,1008,85620,66261,962,300513120,784 244,947,400 9,369 26,144 8,164,913 8/31/19971 & 2190,424,1008,92721,33186,055,700627137,250 276,479,800 9,554 28,939 8,918,703 7/31/19971 & 2136,992,2008,91015,375119,087,300601198,149 256,079,500 9,511 26,925 8,260,629 6/30/19971 & 2115,865,9008,86813,06636,600,20058862,245 152,466,100 9,456 16,124 5,082,203 5/31/19971 & 291,748,0008,82810,39328,567,30057549,682 120,315,300 9,403 12,795 3,881,139 Page 6 CONSUM.XLS WATER CONSUMPTION HISTORY TOTAL AVERAGEAVERAGEMONTHLYTOTALAVERAGEAVERAGE RESIDENTIAL# OF RES.RESIDENTIALCOMMERCIAL# OF COMM.COMMERCIALCONS.# OFMONTHLYDAILYSeniorSeniorSenior DATECYCLECONSUMPTIONACCTS.CONSUMPTIONCONSUMPTIONACCTS.CONSUMPTIONBILLEDACCTS.CONS.USAGECons.Accts.Average 4/30/1997 2 37,026,700 4,785 7,738 8,749,90021939,954 45,776,600 5,004 9,148 1,525,887 3/31/19971 & 257,804,4008,7366,61719,125,90057133,495 76,930,300 9,307 8,266 2,481,623 2/28/19971 & 271,320,9008,7038,19524,398,60054644,686 95,719,500 9,249 10,349 3,418,554 1/31/19971 & 271,676,7008,5148,41924,931,20041260,513 96,607,900 8,926 10,823 3,116,384 12/31/19961 & 270,971,2008,6558,20023,657,00054843,170 94,628,200 9,203 10,282 3,052,523 11/30/19961 & 290,172,0008,61710,46438,781,60054671,029 128,953,600 9,163 14,073 4,298,453 10/31/19961 & 2108,875,7008,57412,69844,878,20056779,150 153,753,900 9,141 16,820 4,959,803 FY 96/9711,93078,342 15,891 FY 97/9814,98886,83118,922 FY 98/9915,00497,36619,762 FY 99/0016,15195,64521,620 FY 00/0115,44481,01520,794 FY 01/0213,64270,63718,549 FY 02/0314,66276,88620,272 FY 03/0413,42465,25118,292 FY 04/0514,00770,19919,499 FY 05/0617,33787,61024,496 FY 06/0711,61161,96316,874 FY 07/0813,71871,72220,010 FY 08/0913,69570,95520,010 FY 09/1012,51460,32517,897 1 YR. WINTER AVERAGE7,079 5 YR. WINTER AVERAGE8,960 SUMMER AVERAGE: FY 96/9717,609 FY 97/9824,737 FY 98/9922,838 FY 99/0023,280 FY 00/0122,224 FY 01/0219,805 FY 02/0322,334 FY 03/0416,184 FY 04/0521,797 FY 05/0624,426 FY 06/0713,820 FY 07/08 20,538 FY 08/09 19,475 FY 09/10 20,610 Page 7