Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
20130514SPL to Staff 1,5,7-11,13.pdf
RE - May 10, 2013 AH It: 35 CASE NO. SPL-W-13-01 '. PRODUCTION REQUEST RESPONSES: JTII" PREPARED BY LESLIE ABRAMS, PRESIDENT SLEWCO. May 10, 2013 CASE NO SPL-W-13-01 PRODUCTION REQUEST RESPONSES PREPARED BY LESLIE ABRAMS, PRESIDENT SLEWCO REQUEST NO 1 Please see attachment Map is attached showing general layout of SLEWCo The Current hook ups, future hook ups, and dormant accounts REQUEST NO 2 There are currently 288 residential customers There are currently 0 commercial or other class water connection REQUEST NO 3 All 288 residential customers are provided with a 1" meter REQUEST NO 4 There appear to be 55 lots that have not connected in the SLE and Treeport subdivisions SLEWCo Anticipate the possibility of one hook up per year as has been the case for the past 3 years The new hook ups will be provided with a standard 1" residential meter set REQUEST NO 5 Please see attachment Sanitary Survey attached There were no deficiencies We are acting on all recommendations WWlnc currently exercise valves twice annually. We are collecting quotes on reservoir cleaning A complete O&M is now on site. REQUEST NO 6 There have been no water quality and water system issues or violations identified by IDEQ since the completion of the Sanitary Survey in August 2011. REQUEST NO. 7: Please see attachment. The list for the past 3 years of all service related complaints is attached. REQUEST NO 8 Please see attachment The monthly water production data and yearly totals for 2010, 2011, and 2012 are attached REQUEST NO 9 Please see attachment We are unable to provide monthly water consumption data for each metered customer due to the fact that we are only reading meters quarterly and usually only have the ability to read meters twice per year. I have attached the consumption data for the quarters when the meters were read and have provided the annual consumption data for each customer. REQUEST NO. 10: Please see attachment. We are unable to provide monthly excess water consumption data for each metered customer due to the fact that we are only reading meters quarterly and usually only have the ability to read meters twice . S per year. I have attached the excess consumption data for the quarters when the meters were read and have provided the annual excess consumption data for each customer. REQUEST NO 11 Please see attachment We have attached the list showing a percentage of unmetered water for each calendar year. We have also provided data showing that this is not unaccounted for water due to leaks in our system but rather it is the amount of water that is making up the volume of our system infrastructure as well as the water we "waste" during our twice annual end of line directional velocity flushing procedure REQUEST NO 12 The Company is proposing to raise the base (fixed) rate but to maintain the current commodity rate primarily because we have such a limited knowledge about our customer's actual excess water usage due to insufficient meter reading data and we are concerned with raising the cost to the customer on a basis that is difficult for them to budget for REQUEST NO 13 Please see attachment After running the numbers it is apparent that per our sales for 2012 the Company's proposed rate will not meet the revenue requirement of $150,414. Please see attachment. REQUEST NO. 14: Please see attached list showing all water quality tests as required by IDEQ. We have figured the costs over the next 8 years as that follows the IDEQ sampling format REQUEST NO 15 There were 7 meter readings performed per the company tariff during 2010, 2011, and 2012 Meter Readings were performed 2010 04/01/2010 07/01/2010 10/04/2010 2011 07/01/2011 10/03/2011 2012 07/02/2012 10/01/2012 REQUEST NO 16 Please see attached for a sample copy of all the bills for a typical residential customer during 2012 REQUEST NO 17 The Company proposes to perform monthly meter reading when meters are accessible Our assumptions are based on experience of our operators and historical weather patterns in our area Meter reading will be performed during the first business day following the service month We propose that we use a REQUEST NO. 18: REQUEST NO. 19: REQUEST NO. 20: REQUEST NO. 21: REQUEST NO. 22: REQUEST NO. 23: flat rate billing during any months that we are unable to access the meters as a whole. The Company estimates that we should reasonably be able to perform up to 8 meter reads per year for the following months April May June July August September October November Please see attached. The calculations showing how the Company estimated the customer water loss during the test year totaling 2,311,242 gallons and a revenue forgiveness of $2,773.49 is attached. The Company currently has no capital improvement project plan or an asset inventory and management plan Please see attachment. A list of all capital improvement projects initiated and completed since the last general rate case is attached including the total cost for each, completion date, and justification for each project. There is no official record of ownership transfer to the Company from the previous owner due to the fact that the company was not sold, simply there was a stock purchase agreement for the outstanding 62.5 shares of common stock. The IPUC was contacted by the attorney for the previous owner of the stock to notify the Commission on the stock transfer agreement Please see special attachment. The contract is under a confidentiality clause. 0,11, kiwi The contract between the Company and the maintenance company Water Works, Inc. for regular minimum monthly maintenance, emergency services, and customer accounting is attached as well as the cost breakdown for services rendered. This contract is a trade secret and is under a confidentiality clause. The affiliation between Spirit Lake East Water Company and Water Works, Inc. is that there is a common share holder. Water Works, Inc. was hired by Spirit Lake East Water Company to work through the consent order process and to bring the system up to current standards. After the consent order was completed and the IDEQ gave Spirit Lake East Water Co. a clean bill of health, an employee and shareholder of Water Works, Inc. was presented with the • opportunity to obtain the shares for Spirit Lake Water Company. The management relationship between Spirit Lake East Water Company and Water Works, Inc. continued in exactly the same manner as it had previous to the stock transfer. Both companies are run independently of one another and Water Works, Inc. contracts with Spirit Lake East Water Company in exactly the same manner as the other 23 water and wastewater systems that they manage. REQUEST NO. 24: See attached. The name of the licensed operator for Spirit Lake East Water Company is Dean Renninger, and Leslie Abrams and Cole Rayner acting as backup as OIT. REQUEST NO. 25: For the Company's written record of complaints please refer to the response for REQUEST NO. 7. REQUEST NO. 26: Regarding customer deposits. No, the Company does not request deposits from its customers. REQUEST NO. 27: Please see attached to view a sample copy of the current bills with past due amounts and with no past due amounts as well as a sample copy of the proposed monthly billing statement. REQUEST NO. 28: Under the proposed change to monthly billing for the month(s) when the Company is unable to read the meters we will bill at the flat monthly rate. During months when the Company has the ability to read the meters, we will bill in a very similar manner as is followed now however we would be billing the flat rate monthly and using the meter reads to figure usage month to month as opposed to each 3 months. With no meter reading in the winter To account for winter we will use the the per month allowance multiplied by the number of months the meters were not read and subtracted from the difference between the previous meter read from the last billing period and the current meter read from the most recent billing period. For example using the current rates: Meter read April 1, 2013 1002500 Meter read November 1, 2013 1200500 Difference Gallons Used 5 months 198000 Allowed Gallons 9k X 5 45000 Total Overage to be billed 153000 Overage Bill at $1.20/100 gallons $183.60 Flat rate for current month $12.50 Total Billing for one month flat rate plus winter usage $196.10 REQUEST NO. 29: The Company does not offer customers a pre-printed form for the medical emergency certificate. • REQUEST NO 30 Please see attached The Company does supply a summary of rules, and we will actually provide the entire tariff. The document is sent by US Mail upon a new customer transfer, new hookup, or as requested REQUEST NO 31 Please see attached The Company does supply an explanation of rate schedules The document is sent by US Mail upon a new customer transfer, new hookup, or as requested REQUEST NO 32 To handle past due accounts the Company send a reminder notice within 15 days after the initial due date of the original bill If no payment is received within 10 days, a delinquent water bill 7 day notice is sent with a form for making payment arrangements If still no contact is made, a final notice with a shut off warning is sent Shut offs are always scheduled mid-week and we make sure to take a copy of the bill and the notices to the residents door prior to shutting the water off. If the resident is not home the Company leaves the notice on the door. If upon making physical contact with a resident, they offer a payment, the Company will not discontinue their water service It is the goal of the Company to ensure that all of its customers remain in good standing with the Company and are willing to take any reasonable steps to maintain service to its customers REQUEST NO 33 Please see attached for copies of the Companies collections documents CASE NO. SPL-W-13-01 SPIRIT LAKE WATER COMPANY FIRST PRODUCTION REQUEST RESPONSE ALL RESPONSES DRAFTED BY LESLIE ABRAMS, PRESIDENT SLEWCO. REQUEST NO. 1: Map is attached showing general layout of SLEWCo. The Current hook ups, future hook ups, and dormant accounts. CASE NO.SPL-W-13-O1 SPIRIT LAKE WATER COMPANY FIRST PRODUCTION REQUEST RESPONSE ALL RESPONSES DRAFTED BY LESLIE ABRAMS,PRESIDENT SLEWCO. REQUEST NO.5:Sanitary Survey attached.There were no deficiencies.We are acting on all recommendations.WWInc currently exercise valves twice annually.We are collecting quotes on reservoir cleaning.A complete O&M is now on site. STATE OF IDAHO DEPARTMENT OF ENVIRONMENTAL QUALITY 2110 Ironwood Parkway,Coeurd’Alene,ID 83814 (208)769-1422 C.L.“Butch”Otter,Governor Toni Hardesty,Director September 6,2011 Leslie Abrams Spirit Lake East Water Company P0 Box 920 Rathdmn,ID 8385$ lest ie@mywaterworksonline.com Subject:Sanitary Survey of PWS #1280176,Spirit Lake East Water Company Ms.Leslie Abrams: Thank you for your assistance in conducting the inspection ofthe Spirit Lake East water system onAugust10,2011.We found that the water system was well built,properly maintained,and in substantial compliance with the Idaho Rules for Public Drinking Water Systems.It will continue with its approveddesignation. No significant deficiencies were identified at the time of the survey. Recommendations: 1.The Department recommends the valves in distribution be exercised annually. 2.The Department recommends the reservoir be inspected and cleaned every 5 years. 3.The Department recommends an operation and maintenance manual be provided for thedrinkingwatersystem.Operation and maintenance manuals should include daily operating instructions,trouble shooting,operator safety procedures,location of valves and other key system features,parts lists and parts order forms,and information for contacting the watersystemoperator. If you have any questions regarding this survey,please do not hesitate to contact me at DEQ in Coeurd’Alene,located at 2110 Ironwood Parkway;phone 208 666-4630. Sincerely, Jean Felker Drinking Water Analyst Jean.felker@deg.idaho.gov IDAHO DEPARTMENT OF ENVIRONMENTAL QUALITY DRINKING WATER SUPPLY REPORT 2011 PWS NUMBER:101280176 SYSTEM:SPIRIT LAKE EAST WATER SYSTEM OWNERSHIP:Leslie Abrams INFORMATION OBTAINED FROM:Leslie Abrams LOCATION:Spirit Lake COUNTY:Kootenal County INSPECTOR:Jean Felker DATE:08/10/2011 POPULATION SERVED:700 NUMBER Of CONNECTIONS:280 FIELD SURVEY DATA The Spirit Lake East Water System is a privately owned LLC water system located on the north side ofHwy54betweenHwy41andHwy95,Kootenai County,Idaho.It is regulated by the Idaho Public Utilities Commission.The deficiencies from the sanitary survey dated November 1,2005,whileunderpreviousownership,have been corrected. The water system consists of one drilled well,well house building,200,000 gallon ground level concrete reservoir,sodium hypochlorite disinfection system,ten $1 gallon pressure tanks,vault housing the booster pumps and distribution mains serving the Spirit Lake East community.The water system also has a 175 watt diesel generator on site which will allow the system to provide the power tooperateintheeventofapoweroutage.It is exercised weekly by an auto transfer switch for a half- hour run time and has a 280 gallon fuel tank. The system serves 280 connections and approximately 700 people.The water system is a privately owned corporation by Leslie Abrams.The designated Administrator,owner and operator in charge,Leslie Abrams,was onsite at the time of the survey. Source Well #1 is drilled to a depth of 360 feet and produces approximately 170 gpm.The well is located outside of the pump house to the south.The static water depth is 308 feet.The well casing extends aminimumof18inchesabovethegroundsurfacewithproperlyscreenedventandsealedwellcap.The well log on file documents the well to have been drilled in 1974. No existing ground water problems were identified by the Source Water Assessment report completedOctober30,2001.The GWUDI (Ground Water Under Direct Influence of Surface Water)assessment was completed for this single well source on May 2,1995 and determined that no surface water isinfluencingthegroundwatersource. The water is disinfected with a flow proportional 12.5%sodium hypochlorite injection system prior tothereservoiranddistribution.At the time of the survey the free chlorine residual was .32 ppm.Thereisasmoothnosesampletappriortoandaftertheinjectionofsodiumhypochlorite.The chlorination injection is tied to the well pump initiation and will only turn on when the well pump is running.The system is equipped with an automatic shut off of sodium hypochiorination injection in the event the well pump energizes but fails to pump water through the water main to prevent overdosing the reservoir with sodium hypochiorite.The chlorine tank is properly vented to the outside. The well house contains 10 hydropneumatic tanks used for redundancy in the event of a major power loss (such as lightning strike)which disables the PLC.The system can be manually switched over to utilize the pressure switches controlling the hydropneumatic tanks to take over to maintain pressure within the system.The diesel powered generator supplies the power to the system in the event of a power outage.The pressure tanks are Xtrol model WX252 and are 81 gallon tanks.The Department recommends that pressure tanks be tested for structural integrity every 5 years. The well pumps to the reservoir tank which flows to the booster pumps and out to distribution.The water is disinfected with sodium hypochlorite solution prior to leaving the pump house.The booster pumps maintain adequate pressure in the distribution system. There were no toxic or hazardous materials noted on site at the well house at the time of the survey. The well house and surrounding well lot were securely locked to prevent unauthorized entry.The pressure gauge and instantaneous and totalizing flow meter were working properly at the time of the survey.The well is capable of being pumped to waste prior to the first service connection.The well house had adequate heat,lights,floor drains and ventilation. Storage The water system contains a 200,000 gallon above ground concrete reservoir used to store finished water for distribution.The reservoir is located within the well lot adjacent to the well house and has a 60 foot by 60 foot free standing wood structure with metal roof over the entire reservoir.The reservoir roof vent is adequately screened and the hatch meets the requirements to seal out any sources of contaminants.The reservoir is capable of being isolated from the distribution system to allow the system to provide well to pressure flow. The reservoir over flow and vent is screened with a 24 mesh and is in good condition.The overflow for the reservoir drains into a concrete basin and flows downhill away from the reservoir.The side wall of the reservoir has signs of deterioration in areas where seams were previously sealed.The operator stated the seams will be ground and re-sealed next week and is done as part of annual routine maintenance. The reservoirs operate on a float transducer system in the reservoir to signal the SCADA system to initiate the well to turn on at 9 feet and off at 11.6 feet.At 1.5 feet all booster pumps are set to shut down to avoid draining the reservoir and burning out the pumps.The on and off set points are determined by season and water consumption to avoid stagnant water stored within the reservoir. The two booster pumps draw finished water out of the reservoir to serve the Spirit Lake East distribution system.The two ten horse power centrifugal booster pumps alternate.The booster pumps have an automatic cut off switch off to prevent pump damage in the event the reservoir gets too low.The pressure gauges in the booster pump vault were working properly and reading 47 psi. The third booster pump is for fire flow purposes and kicks on if pressure drops below 35 psi.All three booster pumps are housed in the underground vault located between the reservoir and the pump house. In the Spring of 2012 the reservoir is scheduled to have a diver inspection.It was last inspected approximately three years ago and was found to be structurally sound.The reservoir interior appeared to be clean by inspection from the reservoir hatch.The reservoir hatch gasket seal was in good condition and spare gasket materials were stored in the pump house for future use.The Department recommends the reservoir be inspected and cleaned every 5 years. Distribution The system currently serves 280 connections,all of which are metered.The distribution lines consist of4-to 12-inch PVC pipe with no dead ends.The Department recommends that all valves and main lines be flushed annually.It is required that any dead end lines be flushed once every 6 months. If at any time there is a depressurization event,the water system operator must provide public notification to its users,disinfect and also notify the DEQ.The operator,Leslie Abrams,stated that all valves are exercised twice a year,and that main lines are flushed annually. A cross connection control program and by laws related to its enforcement are in effect as required bytheRules(IDAPA 58.01.08.552.06).The water system must ensure that cross connections do not existorareisolatedfromthepotablewatersystembyanapprovedbackflowpreventionassembly. Backflow prevention assemblies shall be inspected and tested annually for functionality by an Idaho licensed tester,as specified in Subsection 552.06.c.Annual backflow testing of all backflow assemblies installed on underground sprinkler systems within distribution is required. Financial &Managerial Capacity The Spirit Lake East Water Company is a privately owned corporation owned by the operator,Leslie Abrams.ft is current on their drinking water fees with the State. The Department recommends an operation and maintenance manual be provided for the drinking watersystem.Operation and maintenance manuals should include daily operating instructions,trouble shooting,operator safety procedures,location of valves and other key system features,parts lists andpartsorderforms,and information for contacting the water system operator. Monitoring Schedule The Spirit Lake East water system is required to collect 1 routine total coliform sample each monthfromdistribution.The last positive coliform sample was 10/2000.The Spirit Lake East Water Company has not applied for a Drinking Water Monitoring Waiver for the 2011-2013 monitoringperiod.The Department encourages you to apply for the waivers as soon as possible. Distribution: Total coliform —1 per month from distribution Lead and Copper —10 samples per 3 years from distribution Distribution By-Products (TTHM &HAA5)—I routine per 3 years Wel]: Gross Alpha —I sample per 6 years Rads,226,228,226&22$—I sample every 3 years Rads Uranium —1 sample every 6 years Sodium —I sample every 3 years VOC group —I sample per 6 years Arsenic —I sample per 3 years fluoride —I sample every 9 years IOC group —1 sample every 9 years Nitrate —1 sample per year Nitrite —I sample per 9 years Conclusions and Recommendations At the time of the survey it was evident that the operator,Leslie Abrams,takes his responsibility of providing adequately treated water to the users at Spirit Lake East seriously;her efforts are appreciated by the Department.The Spirit Lake East water system was found to be substantial compliance with the Idaho Rules for Public Drinking Water Systems. No significant deficiencies were identified during the survey. Recommendations: 1.The Department recommends the valves in distribution be exercised annually. 2.The Department recommends the reservoir be inspected and cleaned every 5 years. 3.The Department recommends an operation and maintenance manual be provided for the drinking water system.Operation and maintenance manuals should include daily operating instructions,trouble shooting,operator safety procedures,location of valves and other key system features,parts lists and parts order forms,and information for contacting the water system operator. 9/06/2011 Jean felker,Drinking Water Analyst Date sump discharge from booster vault SCADA panels/controls in pump house sodium hypochlorate injection sample tap finished water pressure tanks &pressure switches SPIRIT LAKE EAST 811012011 200K Reservoir with free standing metal roof booster pumps located in the vault booster pumps and sump pump visible booster pumps in vault e2 _.1 ;j4 b.‘4’i 4•—U’-4% 1.E ‘ reservoir flow to waste reservoir flow to waste screened .-‘. flow meter,sodium hypochiorite injection,raw sample tap well,vent,raw sample tap (to be upgraded) solution tanks and meter CASE NO. SPL-W-13-01 SPIRIT LAKE WATER COMPANY FIRST PRODUCTION REQUEST RESPONSE ALL RESPONSES DRAFTED BY LESLIE ABRAMS, PRESIDENT SLEWCO. REQUEST NO. 7: All service related complaints and an explanation on how each was resolved. 06/05/2010 - S.H. Water Leak - 3/2 bill forgiveness on timely repair. 09/02/2010 - S.K. Water Leak - 3/2 bill forgiveness on timely repair. 03/01/2011 —J.Z. Water Leak. /2 bill forgiveness on timely repair. 07/24/2011 - D.L. Water Leak. /2 bill forgiveness on timely repair. 09/19/2011 - A.N. Water Leak - Yz bill forgiveness on timely repair. 10/07/2011 - A.M. Misread water meter. Re read and re billed. 06/26/2012 - RB. Water Pressure complaint. Checked pressure and meter Found meter nut was not turned on all the way. They had shut it off to repair a frost free hydrant and didn't turn the meter back on all the way. 06/26/2012 - A.M. Water Leak. 34 bill forgiveness on timely repair. 07/10/2012 - A.F. Water Leak. 34 bill forgiveness on timely repair. 07/12/2012 - D.D. Water Leak. 34 bill forgiveness on timely repair. 07/31/2012 - M.G. Received bill with wrong name on it. Corrected info in computer and resent corrected copy of bill. 08/01/2012 - C.R. Water Leak. 3/2 bill forgiveness on timely repair. 08/01/2012 - J.F. Water shut off due to fire. Bill forgivenss. 10/12/2012 - G.D. Water Leak. 'A bill forgiveness on timely repair. 10/21/2012 - K.T. Water Leak. 34 bill forgiveness on timely repair. CASE NO. SPL-W-13-01 SPIRIT LAKE WATER COMPANY FIRST PRODUCTION REQUEST RESPONSE ALL RESPONSES DRAFTED BY LESLIE ABRAMS, PRESIDENT SLEWCO. REQUEST NO. 8: The monthly water production data and yearly totals for 2010, 2011, and 2012 are attached. SLEWCO. Water Production Data with Annual Totals: 2010, 2011, 2012 Jan-10 2652900 Feb-10 2113600 Mar-10 1665500 Apr-10 3422300 May-10 1956200 Jun-10 4121200 Jul-10 6890700 Aug-10 8242600 Sep-10 4800000 Oct-10 2566000 Nov-10 2141400 Dec-10 2419000 Total 2010 Gallons 42991400 Jan-11 1758200 Feb-11 2704000 Mar-11 1700000 Apr-11 1828400 May-11 4530600 Jun-11 5674000 Jul-11 11570800 Aug-11 8262800 Sep-11 4136520 Oct-11 3407400 Nov-11 2619100 Dec-11 1655900 Total 2011 Gallons 49847720 Jan-12 2754800 Feb-12 2465400 Mar-12 1914500 Apr-12 3890500 May-12 5332100 Jun-12 2997600 Jul-12 7167840 Aug-12 10412060 Sep-12 5580700 Oct-12 2801900 Nov-12 2722000 Dec-12 2979100 Total 2012 Gallons 51018500 CASE NO. SPL-W-13-01 SPIRIT LAKE WATER COMPANY FIRST PRODUCTION REQUEST RESPONSE ALL RESPONSES DRAFTED BY LESLIE ABRAMS, PRESIDENT SLEWCO. REQUEST NO. 9: For the years 2010, 2011, and 2012 we are unable to provide monthly water consumption data for each metered customer due to the fact that we are only reading meters quarterly and usually only have the ability to read meters twice per year. I have attached the consumption data for the quarters when the meters were read and have provided the annual consumption data for each customer. REQUEST NO. 10: For the years 2010, 2011, and 2012 we are unable to provide monthly excess water consumption data for each metered customer due to the fact that we are only reading meters quarterly and usually only have the ability to read meters twice per year. I have attached the excess consumption data for the quarters when the meters were read and have provided the annual excess consumption data for each customer. overage in usage in gallons gallons 10.1.09- 4.1.10- 3.31.10 6.30.10 4,404 29,065 32,000 13,140 7,622 11,961 68,080 167,447 15,125 176,079 30 344 17,090 43,713 41,596 81,900 29,202 14,010 6,545 22,657 14,392 14,923 18,640 42,255 14,062 22,290 Customer Usage and Excess Calculations for 2010 LOT # Status 7 6 21 GAL/NEEDS REPLACED 8 9 10 11 NEEDS REPLACED 12 13 GAL/NEEDS REPLACED 19 31 32 GAL/NEEDS REPLACED 17 16 15 35 36 14 34 39 40 74 usage in gallons 10.1.09 - 3.31.10 18595 12993 691 31895 58404 5685 22 0 33560 27287 83065 86000 13531 22597 8408 16471 27182 67140 25963 45561 17967 35537 overage in usage in gallons gallons 4.1.10- 7.1.10- 6.30.10 9.30.10 8452 21999 41080 18210 94098 8206 149079 393650 52 314 28350 16713 129224 14596 52195 54900 128300 2202 66781 97704 24347 86095 15850 14032 11594 15255 94360 83305 30264 overage in usage in gallons ft3 7.1.10- 10.1.10- 9.30.10 12.31.10 Winter Winter Winter 67098 Winter Winter 366650 Winter Winter Winter 185058 Winter 102224 Winter 25195 Winter 101300 Winter 39781 Winter 70704 Winter Winter 59095 Winter Winter Winter Winter 67360 Winter 56305 Winter 3264 Winter Total Usage 2010 34670 46952 86981 293440 81734 575414 105 658 79000 200225 176857 296200 109515 134311 39300 125223 57424 96096 56197 182175 115334 88092 usage in overage in usage in overage in usage in overage in usage in gallons gallons gallons gallons gallons gallons ft3 Total 10.1.09 - 10.1.09- 4.1.10- 4.1.10- 7.1.10- 7.1.10- 10.1.10- Usage LOT# Status 3.31.10 3.31.10 6.30.10 6.30.10 9.30.10 9.30.10 12.31.10 2010 41 21296 20,600 69983 42983 Winter 111878 73 16359 7,914 5520 Winter 29793 72 16396 11,646 47498 20498 Winter 75541 43 39951 34,984 7984 77470 50470 Winter 152405 71 17436 13,217 21385 Winter 52038 45 35597 21,550 68644 41644 Winter 125791 46 21632 31,715 4715 185990 158990 Winter 239338 70 29486 25,582 55651 28651 Winter 110719 47 NEEDS REPLACED 2738 17,698 26285 Winter 46720 69 0 0 0 OWinter 0 68 22268 48,844 21844 76371 49371 Winter 147483 67 24774 21,236 131626 104626 Winter 177635 50 87217 33,217 44,880 17880 66647 39647 Winter 198744 66 29546 15,708 17204 Winter 62458 51 GAL/NEEDS REPLACED 35540 19,770 46830 19830 Winter 102140 52 49181 33,810 6810 65712 38712 Winter 148702 53 28731 15,499 35350 8350 Winter 79580 64 59788 5,788 40,168 13168 91877 64877 Winter 191832 54 42486 28,798 1798 100830 73830 Winter 172115 55 43182 24,033 64904 37904 Winter 132119 56 NEEDS REPLACED 0 0 0 0 0 Winter 0 57 21542 11,968 12417 Winter 45927 58 18461 11,459 38200 11200 Winter 68120 59 FLOODED NEEDS REPLACE 22373 15,775 15558 Winter 53706 usage in overage in usage in overage in usage in overage in usage in gallons gallons gallons gallons gallons gallons ft3 Total 10.1.09 - 10.1.09- 4.1.10- 4.1.10- 7.1.10- 7.1.10- 10.1.10- Usage LOT# Status 3.31.10 3.31.10 6.30.10 6.30.10 9.30.10 9.30.10 12.31.10 2010 62 27197 94,031 67031 100958 73958 Winter 222186 60 19987 29,576 2576 114369 87369 Winter 163932 94 42150 34,737 7737 160326 133326 Winter 237213 93 124048 70,048 62,383 35383 73371 46371 Winter 259803 95 10921 6,882 32089 5089 Winter 49892 96 33585 17,354 24684 Winter 75623 97 19590 14,317 38761 11761 Winter 72668 98 3620 12,297 55771 28771 Winter 71688 99 36233 106,695 79695 2274 Winter 145202 100 30518 13,464 23861 Winter 67844 92 9911 10,756 20159 Winter 40826 91 23869 14,362 16329 Winter 54559 101 11489 4,368 55472 28472 Winter 71329 123 21655 14,212 19186 Winter 55053 124 32613 14,436 57746 30746 Winter 104795 122 36891 25,664 16060 Winter 78615 125 VACANT 0 426 26771 Winter 27197 127 30668 33,211 6211 81457 54457 Winter 145336 121 32388 18,999 53781 26781 Winter 105169 128 55823 1,823 26,748 72803 45803 Winter 155375 120 16508 4,211 2760 Winter 23480 129 68644 14,644 37,303 10303 315080 288080 Winter 421027 119 45553 30,593 3593 23936 Winter 100082 118 27788 14,683 27571 571 Winter 70043 usage in gallons 10.1.09 - LOUt Status 3.31.10 130 116 115 112 113 NEEDS REPLACED - REMO 80 77 111 NEEDS REPLACED - REMO 81 110 82 83 109 84 108 85 86 87 GAL/NEEDS REPLACED 88 104 89 103 90 102 17,959 74261 10,642 41,065 14065 40512 12,484 57955 8,086 34812 11,018 0 11,848 18648 7,099 12162 0 0 26,030 77568 45,553 18553 232927 9,477 11534 10,756 1885 19,493 48829 13,389 27601 32,718 5718 133525 11,714 11003 24,983 46600 25,620 77940 15,154 310996 12,566 22365 23,044 69,714 42714 305558 3,972 56489 60,459 73,027 46027 166587 23,263 77343 47261 Winter 13512 Winter 30955 Winter 7812 Winter U Winter Winter Winter Winter 50568 Winter 205927 Winter Winter Winter 21829 Winter 601 Winter 106525 Winter Winter 19600 Winter 50940 Winter 283996 Winter Winter 278558 Winter 29489 Winter 139587 Winter 50343 Winter 110390 146219 80290 58037 42434 51806 33555 11968 146159 330392 38604 22724 69736 68367 207869 62503 101354 131220 357649 62249 452316 80073 354073 132920 overage in usage in overage in usage in overage in usage in gallons gallons gallons gallons gallons ft3 Total 10.1.09- 4.1.10- 4.1.10- 7.1.10- 7.1.10- 10.1.10- Usage 3.31.10 6.30.10 6.30.10 9.30.10 9.30.10 12.31.10 2010 18169 64642 9851 15140 31416 21311 14294 11968 42561 51911 17593 10083 1414 27377 41626 39786 29770 27660 31498 27317 77044 19613 114459 32314 usage in overage in usage in overage in usage in overage in usage in gallons gallons gallons gallons gallons gallons ft3 Total 10.1.09 - 10.1.09- 4.1.10- 4.1.10- 7.1.10- 7.1.10- 10.1.10- Usage LOT# Status 3.31.10 3.31.10 6.30.10 6.30.10 9.30.10 9.30.10 12.31.10 2010 126 80036 26,036 25,193 84038 57038 Winter 189266 278 19261 1,376 1638 Winter 22275 277 36652 27,377 377 141222 114222 Winter 205251 279 GAL/NEEDS REPLACED 34260 18,680 31340 4340 Winter 84280 276 GAL/NEEDS REPLACED 25530 23,790 67470 40470 Winter 116790 280 8004 9,859 46167 19167 Winter 64029 275 29583 108,303 81303 212454 185454 Winter 350341 283 9814 4,638 6149 Winter 20600 284 18446 12,836 16538 Winter 47820 273 21296 12,140 30743 3743 Winter 64178 286 12349 8,138 42980 15980 Winter 63468 272 14055 10,711 158576 131576 Winter 183342 312 GAL/NEEDS REPLACED 7380 3,930 2396 4310 Winter 15620 309 23457 11,295 53923 26923 Winter 88675 308 66901 12,901 40,609 13609 51545 24545 Winter 159055 290 0 0 0 68143 41143 Winter 68143 292 11370 3,725 4256 Winter 19351 305 GAL/NEEDS REPLACED 6850 48,180 21180 141810 114810 Winter 196840 293 33002 24,041 78794 51794 Winter 135837 304 27796 48,553 21553 213472 186472 Winter 289820 303 67081 13,081 35,231 8231 82460 55460 Winter 184771 294 16478 7,555 7360 Winter 31394 296 20951 9,290 8647 Winter 38889 297 50266 11,893 476925 449925 Winter 539084 LOT# Status 298 299 302 300 GAL/NEEDS REPLACED 2001 2002 VACANT 1003 2003 2004 1005 2005 1006 2006 1007 iIs) 1008 2008 GAL/NEEDS REPLACED 1009 VACANT 1010 2010 HAD LEAK 1011 2011 1012 GAL/NEEDS REPLACED 2012 usage in gallons 10.1.09 - 3.31.10 15439 69938 16082 38980 47767 25432 50303 23210 32149 28716 44843 2498 111489 11220 50827 14960 37300 15 40325 526323 12103 15813 25080 34288 overage in usage in overage in usage in gallons gallons gallons gallons 10.1.09- 4.1.10- 4.1.10- 7.1.10- 3.31.10 6.30.10 6.30.10 9.30.10 54,671 27671 142920 15,938 24,819 106605 10,173 11893 25,990 39760 6,837 44603 17,578 24549 53,534 26534 211976 25,604 36084 18,483 48807 51,522 24522 329703 17,077 97 3,089 6582 57,489 14,773 47767 5,760 9874 39,472 12472 105124 13,015 79138 210 130 15 22 19,590 30743 472,323 89,214 62214 60506 6,149 292 7,173 8527 20,520 31460 15,506 12342 overage in usage in gallons ft3 Total 7.1.10- 10.1.10- Usage 9.30.10 12.31.10 2010 115920 Winter iJiMs] 79605 Winter 201362 Winter 38148 12760 Winter 104730 Winter 99207 Winter 67559 184976 Winter 315813 9084 Winter 84898 21807 Winter 99439 302703 Winter 409941 Winter 62017 Winter 12170 20767 Winter 174030 Winter 26853 78124 Winter 195422 52138 Winter 107114 Winter 37640 Winter 52 3743 Winter 90658 33506 Winter 676042 Winter 18543 Winter 31513 4460 Winter 77060 Winter 62136 overage in usage in overage in usage in gallons gallons gallons ft3 Total 4.1.10- 7.1.10- 7.1.10- 10.1.10- Usage 6.30. 10 9.30. 10 9.30.10 12.31.10 2010 21755 13549 8321 27537 14978 64493 31760 47117 28850 10666 0 47049 22073 68741 20510 23659 1646 46129 19844 38133 120 28948 48912 84891 63430 126487 137378 27250 96612 94196 57042 58905 52644 11856 92737 74374 56586 125821 68809 30870 6380 134393 48762 101578 8408 74875 84988 163580 135238 208886 157447 50161 220383 37493 Winter 4760 Winter 20117 Winter 1850 Winter Winter Winter 20049 Winter Winter 41741 Winter Winter Winter Winter 19129 Winter Winter 11133 Winter Winter 1948 Winter 21912 Winter 57891 Winter 36430 Winter 99487 Winter 110378 Winter 250 Winter 69612 Winter usage in overage in usage in gallons gallons gallons 10.1.09 - 10.1.09- 4.1.10- 3.31.10 3.31.10 6.30.10 16912 12,791 14414 10,868 3508 8,280 14683 9,111 0 1,189 43982 48,755 17787 9,537 18917 15,596 16531 40,549 23854 24,445 5520 1,690 3157 1,578 52943 35,321 13883 15,035 36779 26,666 8108 180 29621 16,306 22477 13,599 24153 54,537 29830 41,978 60005 6,005 22,395 8191 11,878 11317 11,594 87172 33,172 36,600 LOT# Status 1013 2013 1014 2014 1015 2015 313 3011 2016 2017 3010 3009 2019 3008 3007 2020 BANK OWNED 2021 3006 3005 VACANT 2022 2023 3004 3003 2024 usage in overage in usage in overage in usage in overage in usage in gallons gallons gallons gallons gallons gallons ft3 Total 10.1.09 - 10.1.09- 4.1.10- 4.1.10- 7.1.10- 7.1.10- 10.1.10- Usage LOT# Status 3.31.10 3.31.10 6.30.10 6.30.10 9.30.10 9.30.10 12.31.10 2010 2025 GAL/NEEDS REPLACED 16560 35,630 8630 82300 55300 Winter 134490 3002 32635 24,639 46279 19279 Winter 103553 3001 23921 11,429 25746 Winter 61097 271 25866 14,997 61755 34755 Winter 102618 270 39577 20,166 13187 Winter 72930 255 643 3,388 46533 19533 Winter 50565 269 52457 30,967 3967 49607 22607 Winter 133032 256 GAL/NEEDS REPLACED 25870 18,260 30360 3360 Winter 74490 268 18124 8,004 9978 Winter 36106 258 61239 7,239 40,744 13744 67806 40806 Winter 169789 267 33735 31,775 4775 40257 13257 Winter 105767 260 26696 14,212 23450 Winter 64358 265 28574 17,114 74441 47441 Winter 120129 264 112686 58,686 52,674 25674 36263 9263 Winter 201623 262 29479 24,400 84973 57973 Winter 138851 263 BANK OWNED-NO MAt LIN 22029 13,083 16419 Winter 51530 131 16912 8,116 49690 22690 Winter 74718 131 2693 1,720 2035 Winter 6448 245 13090 21,729 100307 73307 Winter 135126 243 17832 9,799 8408 Winter 36039 248 GAL/NEEDS REPLACED 36950 23,040 37970 10970 Winter 97960 242 44925 65,555 38555 14743 Winter 125223 241 84457 30,457 15,416 17324 Winter 117197 249 19478 10,158 28925 1925 Winter 58561 overage in usage in gallons gallons 4.1.10- 7.1.10- 6.30.10 9.30.10 539 9694 19111 66799 102326 91862 40691 38088 122170 45441 47965 177545 4506 -22283 900 46090 67327 50200 1102 65831 50617 6690 60109 11417 137587 7 13614 51388 104189 36390 42636 LOT # Status 240 251 254 253 252 237 238 234 GAL/NEEDS REPLACED 233 232 218 231 GAL/NEEDS REPLACED 220 230 GAL/NEEDS REPLACED 221 229 228 223 226 224 225 79 37 203 usage in overage in usage in gallons gallons gallons 10.1.09 - 10.1.09- 4.1.10- 3.31.10 3.31.10 6.30.10 1511 322 14003 8,318 17832 7,300 184232 130,232 93,799 27773 4,600 21490 13,097 12619 19,261 26870 25,910 16905 11,901 24056 74,965 37624 31,506 13140 27,900 12544 16,995 37390 23,460 39360 28,102 38851 26,988 45052 33,690 36166 38,417 -12679 411 4638 3,157 38739 21,318 13756 24,303 23517 16,389 11325 11,198 overage in usage in gallons ft3 7.1.10- 10.1.10- 9.30.10 12.31.10 Winter Winter Winter 75326 Winter 64862 Winter 13691 Winter 11088 Winter 95170 Winter 18441 Winter 150545 Winter Winter 19090 Winter 40327 Winter 23200 Winter 38831 Winter 23617 Winter 33109 Winter 110587 Winter Winter Winter 24388 Winter 77189 Winter 9390 Winter 15636 Winter Total Usage 2010 2371 32014 44244 380358 124235 75279 69968 174950 74246 276566 46847 87130 96866 111050 133294 116456 138851 212170 -12260 21408 111445 142247 76296 65158 usage in overage in usage in overage in usage in overage in usage in gallons gallons gallons gallons gallons gallons ft3 Total 10.1.09 - 10.1.09- 4.1.10- 4.1.10- 7.1.10- 7.1.10- 10.1.10- Usage LOT# Status 3.31.10 3.31.10 6.30.10 6.30.10 9.30.10 9.30.10 12.31.10 2010 201 45134 21,370 19441 Winter 85945 200 38716 4,451 49301 22301 Winter 92468 199 31274 18,393 19171 Winter 68838 198 18745 8,879 11833 Winter 39457 197 23008 9,926 10674 Winter 43608 206 36921 25,813 36674 9674 Winter 99409 207 28304 27,870 870 72848 45848 Winter 129023 196 GAL/NEEDS REPLACED 43890 23,090 53320 26320 Winter 120300 195 16927 11,669 128073 101073 Winter 156669 208 15095 113,681 86681 309193 282193 Winter 437969 194 22814 21,991 44431 17431 Winter 89236 209 16755 7,951 15259 Winter 39966 192 21071 12,080 87262 60262 Winter 120413 211 44603 12,589 60506 33506 Winter 117698 214 33884 42,187 15187 60887 33887 Winter 136959 215 19298 10,622 13090 Winter 43010 216 22941 11,691 49338 22338 Winter 83970 186 59085 5,085 29,793 2793 48014 21014 Winter 136891 191 40601 35,934 8934 64680 37680 Winter 141215 183 31207 43,691 16691 90717 63717 Winter 165615 188 34670 16,381 166445 139445 Winter 217496 182 19052 14,810 42875 15875 Winter 76737 181 26778 16,007 37774 10774 Winter 80560 179 23921 10,367 48702 21702 Winter 82991 usage in gallons 10.1.09 - 3.31.10 20764 17653 27414 28342 15237 34221 27519 24205 'iiri 19822 0 32090 16456 28357 28589 48321 59361 20428 133069 30526 10465 14219 27706 32987 overage in usage in gallons gallons 10.1.09- 4.1.10- 3.31.10 6.30.10 5,977 14,960 14,706 42,135 8,767 38,178 31,783 12,222 19,523 9,889 217 20,010 7,929 13,165 22,500 23,038 5,361 35,074 16,785 79,069 76,371 26,464 8,340 12,896 44,947 20,645 overage in usage in gallons gallons 4.1.10- 7.1.10- 6.30.10 9.30.10 50079 50939 60034 15135 288728 46376 11178 134042 4783 77590 55876 52263 34386 0 116530 115701 31506 37931 385893 8074 78278 52195 49371 280650 50370 10240 79714 17947 179086 18700 LOT# Status 147 180 148 177 176 175 150 174 151 173 172 154 GAL/NEEDS REPLACED 171 170 169 162 166 165 167 163 164 33 28 22 overage in usage in gallons ft3 Total 7.1.10- 10.1.10- Usage 9.30.10 12.31.10 2010 23079 Winter PlZ'] 23939 Winter 83552 33034 Winter 102154 261728 Winter 359205 19376 Winter 70379 107042 Winter 206441 50590 Winter 136891 28876 Winter 92303 25263 Winter 100090 7386 Winter 64096 Winter 217 89530 Winter 168630 88701 Winter 140085 4506 Winter 73027 10931 Winter 89019 358893 Winter 457252 51278 Winter 172713 25195 Winter 89408 253650 Winter 490090 23370 Winter 107360 Winter 29045 52714 Winter 106829 152086 Winter 251739 -8300 Winter 72332 usage in overage in usage in overage in usage in overage in usage in gallons gallons gallons gallons gallons gallons ft3 Total 10.1.09 - 10.1.09- 4.1.10- 4.1.10- 7.1.10- 7.1.10- 10.1.10- Usage LOT# Status 3.31.10 3.31.10 6.30.10 6.30.10 9.30.10 9.30.10 12.31.10 2010 26 41514 25,918 29247 2247 Winter 96679 25 26547 16,202 23360 Winter 66108 23 84561 30,561 29,120 2120 79123 52123 Winter 192804 24 26636 27,571 571 111497 84497 Winter 165704 30 28102 20,525 52173 25173 Winter 100800 29 29651 9,687 42561 15561 Winter 81899 27 3373 1,698 5647 Winter 10719 160 30144 16,157 2261204 2234204 Winter 2307505 159 7712 10,225 17099 Winter 35036 135 68367 14,367 30,593 3593 21243 Winter 120204 156 21924 20,458 48455 21455 Winter 90837 136 65054 11,054 70,297 43297 280680 253680 Winter 416030 134 30922 28,319 1319 34243 7243 Winter 93485 133 14736 9,799 21168 Winter 45703 132 34745 58,389 31389 128970 101970 Winter 222104 153 38485 26,763 24407 Winter 89655 137 13651 10,509 94966 67966 Winter 119126 138 176685 122,685 37,617 10617 14848 Winter 229150 139 5139 7 0 Winter 5146 140 66909 12,909 73,349 46349 217922 190922 Winter 358180 141 38627 20,002 35717 8717 Winter 94345 143 23113 17,720 39809 12809 Winter 80642 144 NEEDS REPLACED 13471 27,025 25 42045 15045 Winter 82542 149 35687 26,973 41649 14649 Winter 104309 usage in overage in usage in overage in usage in overage in usage in gallons gallons gallons gallons gallons gallons ft3 Total 10.1.09 - 10.1.09- 4.1.10- 4.1.10- 7.1.10- 7.1.10- 10.1.10- Usage LOT# Status 3.31.10 3.31.10 6.30.10 6.30.10 9.30.10 9.30.10 12.31.10 2010 145 16912 9,283 57162 30162 Winter 83357 146 12402 67,021 40021 172339 145339 Winter 251762 9213622 6,883,411 20542255 36639288 1,442,924 1757099 - 14340136 Customer Usage, Excess, and Total Usage Calculations for 2011 excess of 81k usage in shown in gallons gallons usage in ft3 1.1.11 - 10.1.10- 10.1.10- 3.31.11 6.30.11 6.30.11 Winter/No Reading 23278 Winter/No Reading 25178 Winter/No Reading 7330 Winter/No Reading 133675 52675 Winter/No Reading 23786 Winter/No Reading 219037 138037 Winter/No Reading 165 Winter/No Reading 127 Winter/No Reading 55770 Winter/No Reading 102237 21237 Winter/No Reading 210345 129345 Winter/No Reading 353400 272400 Winter/No Reading 37213 Winter/No Reading 45523 Winter/No Reading 16710 Winter/No Reading 40474 Winter/No Reading 35829 Winter/No Reading 53243 Winter/No Reading 40250 Winter/No Reading 82280 1280 Winter/No Reading 33802 excess of 27k usage in shown in gallons gallons Total 7.1.11- 7.1.11- usage in ft3 10.1.11 - Usage 9.30.11 9.30.2011 12.31.11 2011 6912 Winter/No Reading 30189 28095 1095 Winter/No Reading 53273 130980 Winter/No Reading 138310 7121 Winter/No Reading 140796 8774 Winter/No Reading 32560 399507 372507 Winter/No Reading 618544 0 Winter/No Reading 165 1129 Winter/No Reading 1257 25040 Winter/No Reading 80810 135732 108732 Winter/No Reading 237969 18820 Winter/No Reading 229165 389200 362200 Winter/No Reading 742600 149929 122929 Winter/No Reading 187142 95093 68093 Winter/No Reading 140617 26150 Winter/No Reading 42860 78046 51046 Winter/No Reading 118521 12364 Winter/No Reading 48194 13389 Winter/No Reading 66632 75398 48398 Winter/No Reading 115648 124250 97250 Winter/No Reading 206530 102641 75641 Winter/No Reading 136443 LOT # Status 7 6 21 GAL/NEEDS REPLACED 8 9 10 11 NEEDS REPLACED 12 13 GAL/NEEDS REPLACED 19 31 32 GAL/NEEDS REPLACED 17 15 35 36 14 34 39 40 excess of excess of 81k 27k usage in shown in usage in shown in gallons gallons gallons gallons Total usage in ft3 1.1.11 - 10.1.10- 10.1.10- 7.1.11- 7.1.11- usage in ft3 10.1.11 - Usage LOT# Status 3.31.11 6.30.11 6.30.11 9.30.11 9.30.2011 12.31.11 2011 74 Winter/No Reading 46735 32755 5755 Winter/No Reading 79490 41 Winter/No Reading 39494 62869 35869 Winter/No Reading 102364 73 Winter/No Reading 42105 80201 53201 Winter/No Reading 122305 72 Winter/No Reading 17189 56235 29235 Winter/No Reading 73424 43 Winter/No Reading 81293 293 152973 125973 Winter/No Reading 234266 71 Winter/No Reading 30488 46556 19556 Winter/No Reading 77044 45 Winter/No Reading 77979 124430 97430 Winter/No Reading 202409 46 Winter/No Reading 56324 24258 Winter/No Reading 80582 70 Winter/No Reading 52023 32523 5523 Winter/No Reading 84546 47 NEEDS REPLACED Winter/No Reading 14878 40175 13175 Winter/No Reading 55053 69 Winter/No Reading 0 0 Winter/No Reading 0 68 Winter/No Reading 42778 68180 41180 Winter/No Reading 110958 67 Winter/No Reading 79094 103119 76119 Winter/No Reading 182213 50 Winter/No Reading 156033 75033 71958 44958 Winter/No Reading 227990 66 Winter/No Reading 2169 0 Winter/No Reading 2169 51 GAL/NEEDS REPLACED Winter/No Reading 56950 48840 21840 Winter/No Reading 105790 52 Winter/No Reading 376857 295857 43661 16661 Winter/No Reading 420518 53 Winter/No Reading 56107 39494 12494 Winter/No Reading 95602 64 Winter/No Reading 138440 57440 105677 78677 Winter/No Reading 244117 54 Winter/No Reading 87067 6067 137931 110931 Winter/No Reading 224998 55 Winter/No Reading 85781 4781 83178 56178 Winter/No Reading 168958 56 NEEDS REPLACED Winter/No Reading 0 43481 16481 Winter/No Reading 43481 excess of excess of 81k 27k usage in shown in usage in shown in gallons gallons gallons gallons Total usage in ft3 1.1.11 - 10.1.10- 10.1.10- 7.1.11- 7.1.11- usage in ft3 10.1.11 - Usage LOT# Status 3.31.11 6.30.11 6.30.11 9.30.11 9.30.2011 12.31.11 2011 57 Winter/No Reading 37400 11295 Winter/No Reading 48695 58 Winter/No Reading 40519 27983 983 Winter/No Reading 68502 FLOODED NEEDS 59 REPLACED Winter/No Reading 27302 0 Winter/No Reading 27302 62 Winter/No Reading 107308 26308 186342 159342 Winter/No Reading 293650 60 Winter/No Reading 76139 125073 98073 Winter/No Reading 201212 94 Winter/No Reading 188279 107279 187935 160935 Winter/No Reading 376214 93 Winter/No Reading 208685 127685 88077 61077 Winter/No Reading 296762 95 Winter/No Reading 47199 65001 38001 Winter/No Reading 112200 96 Winter/No Reading 56848 24609 Winter/No Reading 81457 97 Winter/No Reading 35141 36106 9106 Winter/No Reading 71247 98 Winter/No Reading 18550 76191 49191 Winter/No Reading 94742 99 Winter/No Reading 81360 360 89304 62304 Winter/No Reading 170664 100 Winter/No Reading 32388 19373 Winter/No Reading 51762 92 Winter/No Reading 23914 36293 9293 Winter/No Reading 60207 91 Winter/No Reading 33024 14219 Winter/No Reading 47244 101 Winter/No Reading 21677 56556 29556 Winter/No Reading 78233 123 Winter/No Reading 41499 20114 Winter/No Reading 61613 124 Winter/No Reading 66722 35530 8530 Winter/No Reading 102252 122 Winter/No Reading 74149 26778 Winter/No Reading 100928 125 VACANT Winter/No Reading 64291 19583 Winter/No Reading 83873 127 Winter/No Reading 52136 70836 43836 Winter/No Reading 122971 excess of excess of 81k 27k usage in shown in usage in shown in gallons gallons gallons gallons Total usage in ft3 1.1.11 - 10.1.10- 10.1.10- 7.1.11- 7.1.11- usage in ft3 10.1.11 - Usage LOT# Status 3.31.11 6.30.11 6.30.11 9.30.11 9.30.2011 12.31.11 2011 121 Winter/No Reading 53632 65375 38375 Winter/No Reading 119007 128 Winter/No Reading 72833 53781 26781 Winter/No Reading 126614 120 Winter/No Reading 84300 3300 2558 Winter/No Reading 86858 129 Winter/No Reading 86574 5574 88271 61271 Winter/No Reading 174845 119 Winter/No Reading 53706 19672 Winter/No Reading 73379 118 Winter/No Reading 43496 21984 Winter/No Reading 65480 130 Winter/No Reading 46204 68464 41464 Winter/No Reading 114668 116 Winter/No Reading 113359 32359 72002 45002 Winter/No Reading 185362 115 Winter/No Reading 26419 23996 Winter/No Reading 50415 112 Winter/No Reading 22881 38642 11642 Winter/No Reading 61523 NEEDS REPLACED - 113 REMOTE READ Winter/No Reading 362556 281556 25671 Winter/No Reading 388227 80 Winter/No Reading 42090 20091 Winter/No Reading 62181 77 Winter/No Reading 18408 7435 Winter/No Reading 25843 NEEDS REPLACED - 111 REMOTE READ/DIG Winter/No Reading 0 0 Winter/No Reading 0 81 Winter/No Reading 19598 13539 Winter/No Reading 33136 110 Winter/No Reading 30174 106859 79859 Winter/No Reading 137034 82 Winter/No Reading 28417 10322 Winter/No Reading 38739 83 Winter/No Reading 15237 32807 5807 Winter/No Reading 48044 109 Winter/No Reading 18767 31880 4880 Winter/No Reading 50647 84 Winter/No Reading 36502 27601 601 Winter/No Reading 64104 108 Winter/No Reading 82729 1729 196058 169058 Winter/No Reading 278787 excess of excess of 81k 27k usage in shown in usage in shown in gallons gallons gallons gallons 10.1.10- 10.1.10- 7.1.11- 7.1.11- usage in ft3 10.1.11 - 6.30.11 6.30.11 9.30.11 9.30.2011 12.31.11 37153 15701 Winter/No Reading 67918 24460 Winter/No Reading 32470 114050 87050 Winter/No Reading 502267 421267 17623 Winter/No Reading 36353 12514 Winter/No Reading 10023 115192 88192 Winter/No Reading 71920 90366 63366 Winter/No Reading 244596 163596 131842 104842 Winter/No Reading 60438 94398 67398 Winter/No Reading 85481 4481 84546 57546 Winter/No Reading 55943 33279 6279 Winter/No Reading 66647 166355 139355 Winter/No Reading 47660 36040 9040 Winter/No Reading 58200 98650 71650 Winter/No Reading 51545 43234 16234 Winter/No Reading 108004 27004 188100 161100 Winter/No Reading 17458 3456 Winter/No Reading 34041 20076 Winter/No Reading 41544 21183 Winter/No Reading 20024 2932 Winter/No Reading 41596 198601 171601 Winter/No Reading 10940 831 5740 Winter/No Reading usage inft3 1.1.11- LOT # Status 3.31.11 85 Winter/No Reading 86 Winter/No Reading 87 GAL/NEEDS REPLACED Winter/No Reading 88 Winter/No Reading 104 Winter/No Reading 89 Winter/No Reading 103 Winter/No Reading 90 Winter/No Reading 102 Winter/No Reading 126 Winter/No Reading 278 Winter/No Reading 277 Winter/No Reading 279 GAL/NEEDS REPLACED Winter/No Reading 276 GAL/NEEDS REPLACED Winter/No Reading 280 Winter/No Reading 275 Winter/No Reading 283 Winter/No Reading 284 Winter/No Reading 273 Winter/No Reading Winter/No Reading 272 Winter/No Reading 312 GAL/NEEDS REPLACED Winter/No Reading Total Usage 2011 52854 92378 146520 519890 48867 125215 162286 376438 154836 170028 89221 233002 83700 156850 94779 296103 20914 54118 62727 22956 240198 16680 excess of excess of 81k 27k shown in usage in shown in gallons gallons gallons 10.1.10- 7.1.11- 7.1.11- usage in ft3 10.1.11 - 6.30.11 9.30.11 9.30.2011 12.31.11 usage in gallons usage in ft3 1.1.11 - 10.1.10- LOT# Status 3.31.11 6.30.11 Total Usage 2011 309 308 290 292 305 GAL/NEEDS REPLACED 293 304 303 294 296 297 298 299 302 300 GAL/NEEDS REPLACED 2001 2002 VACANT 1003 2003 2004 1005 2005 Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading 42314 89820 26756 14272 77780 65577 96739 122403 25634 30862 162017 54567 65622 18401 62510 29022 44700 239001 45157 110113 263303 38103 36712 9712 Winter/No Reading 8820 29254 2254 Winter/No Reading 13120 Winter/No Reading 10988 Winter/No Reading 102070 75070 Winter/No Reading 78974 51974 Winter/No Reading 15739 253856 226856 Winter/No Reading 41403 70492 43492 Winter/No Reading 8774 Winter/No Reading 8422 Winter/No Reading 81017 262847 235847 Winter/No Reading 161987 134987 Winter/No Reading 113561 86561 Winter/No Reading 12118 Winter/No Reading 58080 31080 Winter/No Reading 49443 22443 Winter/No Reading 15371 Winter/No Reading 158001 219718 192718 Winter/No Reading 55517 28517 Winter/No Reading 29113 71456 44456 Winter/No Reading 182303 342180 315180 Winter/No Reading 80649 53649 Winter/No Reading 79026 119074 39876 25260 179850 144551 350595 192894 34408 39285 424864 216553 179183 30518 120590 78465 60072 458718 100673 181570 605484 118752 excess of excess of 81k 27k usage in shown in usage in shown in gallons gallons gallons gallons Total usage in ft3 1.1.11 - 10.1.10- 10.1.10- 7.1.11- 7.1.11- usage in ft3 10.1.11 - Usage LOT# Status 3.31.11 6.30.11 6.30.11 9.30.11 9.30.2011 12.31.11 2011 1006 Winter/No Reading 6089 12671 Winter/No Reading 18760 2006 Winter/No Reading 65233 90875 63875 Winter/No Reading 156108 1007 Winter/No Reading 23562 6433 Winter/No Reading 29995 2007 Winter/No Reading 94413 13413 92640 65640 Winter/No Reading 187052 1008 Winter/No Reading 28798 84075 57075 Winter/No Reading 112873 2008 GAL/NEEDS REPLACED Winter/No Reading 30320 13550 Winter/No Reading 43870 1009 VACANT Winter/No Reading 52 22 Winter/No Reading 75 1010 Winter/No Reading 36502 5610 Winter/No Reading 42112 2010 HAD LEAK Winter/No Reading 59758 3635 Winter/No Reading 63393 1011 Winter/No Reading 29135 31304 4304 Winter/No Reading 60438 2011 Winter/No Reading 22747 6567 Winter/No Reading 29314 1012 GAL/NEEDS REPLACED Winter/No Reading 38080 35200 8200 Winter/No Reading 73280 2012 Winter/No Reading 68420 1616 Winter/No Reading 70035 1013 Winter/No Reading 42240 99177 72177 Winter/No Reading 141417 2013 Winter/No Reading 42673 36502 9502 Winter/No Reading 79176 1014 Winter/No Reading 11198 31768 4768 Winter/No Reading 42965 2014 Winter/No Reading 24811 57671 30671 Winter/No Reading 82482 1015 Winter/No Reading 9537 12896 Winter/No Reading 22433 2015 Winter/No Reading 124699 43699 86102 59102 Winter/No Reading 210801 313 Winter/No Reading 42643 40594 13594 Winter/No Reading 83237 3011 Winter/No Reading 32703 25888 Winter/No Reading 58591 2016 Winter/No Reading 45022 57274 30274 Winter/No Reading 102296 LOT# Status 2017 IIILl] 3009 2019 3008 3007 2020 BANK OWNED 2021 3006 3005 VACANT 2022 2023 3004 3003 2024 2025 GAL/NEEDS REPLACED 3002 3001 271 270 255 269 Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading 37968 7390 4017 59788 19949 46092 5827 52510 14668 63528 58673 68218 34415 27818 58800 94650 65218 71202 59907 38552 23390 83641 usage in gallons usage in ft3 1.1.11 - 10.1.10- 3.31.11 6.30.11 excess of excess of 81k 27k shown in usage in shown in gallons gallons gallons Total 10.1.10- 7.1.11- 7.1.11- usage in ft3 10.1.11 - Usage 6.30.11 9.30.11 9.30.2011 12.31.11 2011 11355 Winter/No Reading 49323 14489 Winter/No Reading 21879 1601 Winter/No Reading 5617 33653 6653 Winter/No Reading 93440 113576 86576 Winter/No Reading 133525 45875 18875 Winter/No Reading 91967 22 Winter/No Reading 5849 20645 Winter/No Reading 73154 4346 Winter/No Reading 19014 125716 98716 Winter/No Reading 189244 110412 83412 Winter/No Reading 169085 113038 86038 Winter/No Reading 181255 183327 156327 Winter/No Reading 217743 23517 Winter/No Reading 51335 89005 62005 Winter/No Reading 147805 13650 650630 623630 Winter/No Reading 745280 67956 40956 Winter/No Reading 133174 100067 73067 Winter/No Reading 171270 51290 24290 Winter/No Reading 111198 0 Winter/No Reading 38552 -68001 Winter/No Reading -44611 2641 52996 25996 Winter/No Reading 136637 LOT# Status 256 GAL/NEEDS REPLACED 268 258 267 260 265 264 262 BANK OWNED-NO 263 MAILING ADDRESS 131 131 245 243 248 GAL/NEEDS REPLACED 242 241 249 240 251 254 253 Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading 32411 25155 4899 18805 25365 62270 0 1429 39420 2334 23622 49660 335777 usage in gallons usage in ft3 1.1.11 - 10.1.10- 3.31.11 6.30.11 Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading 48160 33495 145007 59294 43668 37849 157634 5752 excess of excess of 81k 27k shown in usage in shown in gallons gallons gallons Total 10.1.10- 7.1.11- 7.1.11- usage in ft3 10.1.11 - Usage 6.30.11 9.30.11 9.30.2011 12.31.11 2011 27050 50 Winter/No Reading 75210 10083 Winter/No Reading 43578 64007 88631 61631 Winter/No Reading 233638 50131 23131 Winter/No Reading 109425 20607 Winter/No Reading 64276 69115 42115 Winter/No Reading 106964 76634 16060 Winter/No Reading 173693 71097 44097 Winter/No Reading 76850 9806 Winter/No Reading 42217 36360 9360 Winter/No Reading 61516 1563 Winter/No Reading 6463 84419 57419 Winter/No Reading 103224 8235 Winter/No Reading 33600 22550 Winter/No Reading 84820 53063 26063 Winter/No Reading 53063 32703 5703 Winter/No Reading 34131 29097 2097 Winter/No Reading 68517 367 Winter/No Reading 2700 7495 Winter/No Reading 31117 15446 Winter/No Reading 65106 254777 109507 82507 Winter/No Reading 445284 excess of excess of 81k 27k usage in shown in usage in shown in gallons gallons gallons gallons Total usage in ft3 1.1.11 - 10.1.10- 10.1.10- 7.1.11- 7.1.11- usage in ft3 10.1.11 - Usage LOT# Status 3.31.11 6.30.11 6.30.11 9.30.11 9.30.2011 12.31.11 2011 252 Winter/No Reading 14795 99499 72499 Winter/No Reading 114294 237 Winter/No Reading 34027 9485 Winter/No Reading 43511 238 Winter/No Reading 62174 26060 Winter/No Reading 88234 234 GAL/NEEDS REPLACED Winter/No Reading 32790 105240 78240 Winter/No Reading 138030 233 Winter/No Reading 43249 106874 79874 Winter/No Reading 150124 232 Winter/No Reading 130055 49055 167612 140612 Winter/No Reading 297667 218 Winter/No Reading 62211 55614 28614 Winter/No Reading 117825 231 GAL/NEEDS REPLACED Winter/No Reading 49040 43950 16950 Winter/No Reading 92990 220 Winter/No Reading 31027 74852 47852 Winter/No Reading 105879 230 GAL/NEEDS REPLACED Winter/No Reading 54270 41060 14060 Winter/No Reading 95330 221 Winter/No Reading 80156 74807 47807 Winter/No Reading 154963 229 Winter/No Reading 73917 45621 18621 Winter/No Reading 119538 228 Winter/No Reading 89558 8558 91129 64129 Winter/No Reading 180687 223 Winter/No Reading 94869 13869 112731 85731 Winter/No Reading 207600 226 Winter/No Reading 711 60 Winter/No Reading 770 224 Winter/No Reading 18648 14062 Winter/No Reading 32710 225 Winter/No Reading 47094 49046 22046 Winter/No Reading 96140 79 Winter/No Reading 53198 139465 112465 Winter/No Reading 192662 37 Winter/No Reading 42127 46675 19675 Winter/No Reading 88803 203 Winter/No Reading 48216 42397 15397 Winter/No Reading 90613 201 Winter/No Reading 59137 15947 Winter/No Reading 75084 200 Winter/No Reading 70028 79213 52213 Winter/No Reading 149241 excess of 81k usage in shown in gallons gallons usage in ft3 1.1.11 - 10.1.10- 10.1.10- 3.31.11 6.30.11 6.30.11 Winter/No Reading 48657 Winter/No Reading 50505 Winter/No Reading 21632 Winter/No Reading 63947 Winter/No Reading 54514 Winter/No Reading 64800 Winter/No Reading 52113 Winter/No Reading 221251 140251 Winter/No Reading 62907 Winter/No Reading 27586 Winter/No Reading 129793 48793 Winter/No Reading 0 Winter/No Reading 52435 Winter/No Reading 28274 Winter/No Reading 45845 Winter/No Reading 94039 13039 Winter/No Reading 78764 Winter/No Reading 89109 8109 Winter/No Reading 81547 547 Winter/No Reading 11362 Winter/No Reading 55128 Winter/No Reading 37931 excess of 27k usage in shown in gallons gallons Total 7.1.11- 7.1.11- usage in ft3 10.1.11 - Usage 9.30.11 9.30.2011 12.31.11 2011 22470 Winter/No Reading 71127 19298 Winter/No Reading 69803 7069 Winter/No Reading 28701 35687 8687 Winter/No Reading 99634 89992 62992 Winter/No Reading 144506 60660 33660 Winter/No Reading 125460 151126 124126 Winter/No Reading 203239 629105 602105 Winter/No Reading 850356 46526 19526 Winter/No Reading 109432 15267 Winter/No Reading 42853 349653 322653 Winter/No Reading 479446 24303 Winter/No Reading 24303 51762 24762 Winter/No Reading 104196 26479 Winter/No Reading 54754 67589 40589 Winter/No Reading 113434 34228 7228 Winter/No Reading 128267 50026 23026 Winter/No Reading 128791 106650 79650 Winter/No Reading 195759 146189 119189 Winter/No Reading 227736 12005 Winter/No Reading 23368 52136 25136 Winter/No Reading 107263 54836 27836 Winter/No Reading 92767 / LOT # Status 199 198 197 206 207 196 GAL/NEEDS REPLACED 195 ZsII 194 209 192 211 214 215 216 186 191 183 188 182 181 179 usage in gallons usage in ft3 1.1.11 - 10.1.10- 3.31.11 6.30.11 Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading excess of 81k shown in usage in gallons gallons 10.1.10- 7.1.11- 6.30.11 9.30.11 41305 48844 151664 240572 30174 117099 81270 101706 49383 46039 -217 198670 74269 31790 55920 494278 88571 72107 427407 26412 8093 165675 LOT # Status 147 180 148 177 176 175 150 174 151 173 172 154 GAL/NEEDS REPLACED 171 170 169 162 166 165 167 E*] 164 33 32568 40766 67432 t.I.jpi' T)PZi 25073 80171 65428 69616 58164 37265 [I] 74860 23607 45508 73326 61785 126846 50213 410876 52517 190598 132089 45846 329876 109598 51089 excess of 27k shown in gallons Total 7.1.11- usage in ft3 10.1.11 - Usage 9.30.2011 12.31.11 2011 14305 Winter/No Reading 73872 21844 Winter/No Reading 89610 124664 Winter/No Reading 219097 213572 Winter/No Reading 340692 3174 Winter/No Reading 55247 90099 Winter/No Reading 197270 54270 Winter/No Reading 146698 74706 Winter/No Reading 171322 22383 Winter/No Reading 107547 19039 Winter/No Reading 83305 Winter/No Reading -217 171670 Winter/No Reading 273530 47269 Winter/No Reading 97876 4790 Winter/No Reading 77298 28920 Winter/No Reading 129247 467278 Winter/No Reading 556063 61571 Winter/No Reading 215417 45107 Winter/No Reading 122320 400407 Winter/No Reading 838284 Winter/No Reading 78929 Winter/No Reading 198691 138675 Winter/No Reading 297764 excess of excess of 81k 27k usage in shown in usage in shown in gallons gallons gallons gallons Total usage in ft3 1.1.11 - 10.1.10- 10.1.10- 7.1.11- 7.1.11- usage in ft3 10.1.11 - Usage LOT# Status 3.31.11 6.30.11 6.30.11 9.30.11 9.30.2011 12.31.11 2011 28 Winter/No Reading 102371 21371 224407 197407 Winter/No Reading 326779 22 Winter/No Reading 40841 19747 Winter/No Reading 60588 26 Winter/No Reading 61560 17765 Winter/No Reading 79325 25 Winter/No Reading 15566 41978 14978 Winter/No Reading 57544 23 Winter/No Reading 55359 41073 14073 Winter/No Reading 96432 24 Winter/No Reading 68412 97921 70921 Winter/No Reading 166333 30 Winter/No Reading 539166 458166 51320 24320 Winter/No Reading 590486 29 Winter/No Reading 21557 16905 Winter/No Reading 38462 27 Winter/No Reading 16920 27250 250 Winter/No Reading 44169 160 Winter/No Reading 48096 12866 Winter/No Reading 60962 159 Winter/No Reading 69474 27728 728 Winter/No Reading 97203 135 Winter/No Reading 0 51687 24687 Winter/No Reading 51687 156 Winter/No Reading 44693 37789 10789 Winter/No Reading 82482 136 Winter/No Reading 119575 38575 150213 123213 Winter/No Reading 269789 134 Winter/No Reading 54006 31797 4797 Winter/No Reading 85803 133 Winter/No Reading 24011 29920 2920 Winter/No Reading 53931 132 Winter/No Reading 116351 35351 126786 99786 Winter/No Reading 243137 153 Winter/No Reading 71898 24160 Winter/No Reading 96058 137 Winter/No Reading 17167 157073 130073 Winter/No Reading 174239 138 Winter/No Reading 39524 10891 Winter/No Reading 50415 139 Winter/No Reading 85040 4040 28843 1843 Winter/No Reading 113883 140 Winter/No Reading 142457 61457 260551 233551 Winter/No Reading 403007 I... excess of 81k usage in shown in usage in gallons gallons gallons usage in ft3 1.1.11 - 10.1.10- 10.1.10- 7.1.11- LOT # Status 3.31.11 6.30.11 6.30.11 9.30.11 141 Winter/No Reading 62690 30593 143 Winter/No Reading 17174 7876 144 NEEDS REPLACED Winter/No Reading 83215 2215 34864 149 Winter/No Reading 57170 47969 145 Winter/No Reading 51582 71815 146 Winter/No Reading 3363711 3282711 132351 j1$cLLI 21897457 20145801 7984625 excess of 27k shown in gallons Total 7.1.11- usage in ft3 10.1.11 - Usage 9.30.2011 12.31.11 2011 3593 Winter/No Reading 93283 Winter/No Reading 25051 7864 Winter/No Reading 118079 20969 Winter/No Reading 105139 44815 Winter/No Reading 123398 105351 Winter/No Reading 3496062 42043258 42043258 13721066 21705691 Customer Usage, Excess, and Total Usage Calculations for 2012 overage in overage in usage in gallons gallons gallons 10.1.11- 10.1.11- 7.1.12- 6.30.12 6.30.12 9.30.12 18902 15888 28738 38148 97590 648973 153550 26950 14451 25073 10322 69534 137886 0 2564017 112 0 43740 246175 23680 55053 168494 135014 54014 100815 159100 1109068 318000 28559 125417 48568 116613 2762214 2681214 31783 72459 38417 17114 51545 32441 33443 50378 98310 17310 124482 24744 102177 75406 36128 overage in gallons 7.1.12- usage 10.1.12 - 9.30.12 12.31.2012 Winter/No Reading 11148 Winter/No Reading 126550 Winter/No Reading Winter/No Reading Winter/No Reading 110886 Winter/No Reading 2537017 Winter/No Reading Winter/No Reading Winter/No Reading 141494 Winter/No Reading 73815 Winter/No Reading 291000 Winter/No Reading 98417 Winter/No Reading 89613 Winter/No Reading Winter/No Reading 45459 Winter/No Reading Winter/No Reading 5441 Winter/No Reading 23378 Winter/No Reading 97482 Winter/No Reading 75177 Winter/No Reading 9128 Winter/No Reading usage 1.1.12 - LOT # Status 3.31.12 7 Winter/No Reading 6 Winter/No Reading 21 GAL/NEEDS REPLACED Winter/No Reading 8 Winter/No Reading 9 Winter/No Reading 10 Winter/No Reading 11 NEEDS REPLACED Winter/No Reading 12 Winter/No Reading 13 GAL/NEEDS REPLACED Winter/No Reading 19 Winter/No Reading 31 Winter/No Reading 32 GAL/NEEDS REPLACED Winter/No Reading 17 Winter/No Reading 16 Winter/No Reading 15 Winter/No Reading 35 Winter/No Reading 36 Winter/No Reading 14 Winter/No Reading 34 Winter/No Reading 39 Winter/No Reading 40 Winter/No Reading 74 Winter/No Reading Total Usage 2012 34789 66886 251140 41402 35395 207420 2564017 112 67420 223547 235829 477100 153976 165181 2762214 104241 55532 83985 83821 222792 126921 111534 usage 1.1.12 - LOT # Status 3.3 1.12 41 Winter/No Reading 73 Winter/No Reading 72 Winter/No Reading 43 Winter/No Reading 71 Winter/No Reading 45 Winter/No Reading 46 Winter/No Reading 70 Winter/No Reading 47 NEEDS REPLACED Winter/No Reading 69 Winter/No Reading 68 Winter/No Reading 67 Winter/No Reading 50 Winter/No Reading 66 Winter/No Reading 51 GAL/NEEDS REPLACED Winter/No Reading 52 Winter/No Reading 53 Winter/No Reading 64 Winter/No Reading 54 Winter/No Reading 55 Winter/No Reading 56 NEEDS REPLACED Winter/No Reading 57 Winter/No Reading 58 Winter/No Reading overage in overage in usage in gallons gallons gallons 10.1.11- 10.1.11- 7.1.12- 6.30.12 6.30.12 9.30.12 40212 53243 81749 749 102887 26883 21109 111624 30624 111385 30556 22059 82056 1056 30728 75989 144820 35889 12940 34146 26419 0 7540 59197 96492 25342 120398 150124 69124 70088 24609 13015 57050 345734 44390 24721 50640 66527 44603 98063 17063 73738 118708 37708 154986 76161 48687 43474 0 36951 18027 32807 34685 overage in gallons 7.1.12- usage 10.1.12 - 9.30.12 12.31.2012 26243 Winter/No Reading 75887 Winter/No Reading Winter/No Reading 84385 Winter/No Reading Winter/No Reading 3728 Winter/No Reading 117820 Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading 69492 Winter/No Reading 93398 Winter/No Reading 43088 Winter/No Reading Winter/No Reading 17390 Winter/No Reading 23640 Winter/No Reading 17603 Winter/No Reading 46738 Winter/No Reading 127986 Winter/No Reading 21687 Winter/No Reading Winter/No Reading Winter/No Reading 7685 Winter/No Reading Total Usage 2012 93455 184636 47992 223009 52614 112783 220810 48829 60566 7540 155689 145740 220211 37624 101440 75361 111130 171801 273693 124849 43474 54978 67492 162938 106150 N1 98737 25357 122522 142771 208520 58628 68891 15858 38290 76610 100135 122971 35291 29898 66392 24901 28274 21924 8445 93425 49892 30444 5214 54439 usage 1.1.12 - LOT# Status 3.31.12 59 FLOODED NEEDS REPLACE Winter/No Reading 62 Winter/No Reading 60 Winter/No Reading 94 Winter/No Reading 93 Winter/No Reading 95 Winter/No Reading 96 Winter/No Reading 97 Winter/No Reading 98 Winter/No Reading 99 Winter/No Reading 100 Winter/No Reading 92 Winter/No Reading 91 Winter/No Reading 101 Winter/No Reading 123 Winter/No Reading 124 Winter/No Reading 122 Winter/No Reading 125 VACANT Winter/No Reading 127 Winter/No Reading 121 Winter/No Reading 128 Winter/No Reading 120 Winter/No Reading 129 Winter/No Reading overage in overage in usage in gallons gallons gallons 10.1.11- 10.1.11- 7.1.12- 6.30.12 6.30.12 9.30.12 0 74598 51238 243938 187150 48171 68592 28319 21655 60147 65300 28746 14070 25110 42157 45778 68853 36113 83926 50714 25178 13015 179737 overage in gallons 7.1.12- usage 10.1.12 - 9.30.12 12.31.2012 Winter/No Reading 95522 Winter/No Reading 115771 Winter/No Reading 181520 Winter/No Reading 31628 Winter/No Reading 41891 Winter/No Reading Winter/No Reading 11290 Winter/No Reading 49610 Winter/No Reading 73135 Winter/No Reading 95971 Winter/No Reading 8291 Winter/No Reading 2898 Winter/No Reading 39392 Winter/No Reading Winter/No Reading 1274 Winter/No Reading Winter/No Reading Winter/No Reading 66425 Winter/No Reading 22892 Winter/No Reading 3444 Winter/No Reading Winter/No Reading 27439 Winter/No Reading Total Usage 2012 25357 197120 194009 452458 245778 117062 84449 66609 98265 160281 188272 64036 43967 91503 67058 74052 90777 44558 177351 100606 55621 18229 234176 overage in overage in usage in gallons gallons gallons usage 1.1.12 - 10.1.11- 10.1.11- 7.1.12- 3.31.12 6.30.12 6.30.12 9.30.12 LOT# Status 119 Winter/No Reading 118 Winter/No Reading 130 Winter/No Reading 116 Winter/No Reading 115 Winter/No Reading 112 Winter/No Reading 113 NEEDS REPLACED - REMO1 Winter/No Reading 80 Winter/No Reading 77 Winter/No Reading 111 NEEDS REPLACED - REMO1 Winter/No Reading 81 Winter/No Reading 110 Winter/No Reading 82 Winter/No Reading 83 Winter/No Reading 109 Winter/No Reading 84 Winter/No Reading 108 Winter/No Reading 85 Winter/No Reading 86 Winter/No Reading 87 GAL/NEEDS REPLACED Winter/No Reading 88 Winter/No Reading 104 Winter/No Reading 89 Winter/No Reading 48545 35455 49652 21400 35807 41230 165630 84630 73042 32501 33765 16980 25888 72706 43960 44499 26173 21857 17526 382228 0 61336 31566 135986 54986 201 27048 15439 74291 14219 21064 38515 39420 32987 37789 33869 44356 0 28948 18326 33730 171300 46050 60199 257851 39255 17346 72406 96492 overage in gallons 7.1.12- usage 10.1.12 - 9.30. 12 12.31.2012 8455 Winter/No Reading Winter/No Reading 14230 Winter/No Reading 46042 Winter/No Reading 6765 Winter/No Reading Winter/No Reading 16960 Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading 4566 Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading 11515 Winter/No Reading 5987 Winter/No Reading 6869 Winter/No Reading Winter/No Reading Winter/No Reading 19050 Winter/No Reading 230851 Winter/No Reading Winter/No Reading 69492 Winter/No Reading Total Usage 2012 84000 71053 77037 238672 66265 42868 116666 70671 39382 382228 92902 136187 42486 88511 59578 72406 71658 44356 47274 79780 318050 56601 168898 overage in overage in usage in overage in gallons gallons gallons gallons Total usage 1.1.12 - 10.1.11- 10.1.11- 7.1.12- 7.1.12- usage 10.1.12 - Usage LOT# Status 3.31.12 6.30.12 6.30.12 9.30.12 9.30.12 12.31.2012 2012 103 Winter/No Reading 71464 81068 54068 Winter/No Reading 152532 90 Winter/No Reading 247259 166259 179670 152670 Winter/No Reading 426928 102 Winter/No Reading 59316 88788 61788 Winter/No Reading 148104 126 Winter/No Reading 65577 96193 69193 Winter/No Reading 161770 278 Winter/No Reading 27257 12679 Winter/No Reading 39936 277 Winter/No Reading 57222 364650 337650 Winter/No Reading 421872 279 GAL/NEEDS REPLACED Winter/No Reading 43400 243632 23770 Winter/No Reading 67170 276 GAL/NEEDS REPLACED Winter/No Reading 36600 192768 83400 56400 Winter/No Reading 120000 280 Winter/No Reading 39128 58875 31875 Winter/No Reading 98003 275 Winter/No Reading 140878 59878 268412 241412 Winter/No Reading 409291 283 Winter/No Reading 15080 4899 Winter/No Reading 19979 284 Winter/No Reading 29868 12035 Winter/No Reading 41903 273 Winter/No Reading 20069 34670 7670 Winter/No Reading 54739 286 Winter/No Reading 5520 1877 Winter/No Reading 7398 272 Winter/No Reading 24983 155247 128247 Winter/No Reading 180231 312 GAL/NEEDS REPLACED Winter/No Reading 9460 4650 Winter/No Reading 14110 309 Winter/No Reading 88406 7406 63430 36430 Winter/No Reading 151837 308 Winter/No Reading 75937 19530 Winter/No Reading 95467 290 Winter/No Reading 21707 11145 Winter/No Reading 32852 292 Winter/No Reading 41918 17017 Winter/No Reading 58935 305 GAL/NEEDS REPLACED Winter/No Reading 54340 325463 86550 59550 Winter/No Reading 140890 293 Winter/No Reading 64792 92737 65737 Winter/No Reading 157529 304 Winter/No Reading 63573 217810 190810 Winter/No Reading 281383 overage in overage in usage in gallons gallons gallons 10.1.11- 10.1.11- 7.1.12- 6.30.12 6.30.12 9.30.12 96574 15574 67933 21198 7315 40938 5752 192535 111535 275937 39038 131723 67612 177418 24534 11220 48790 283949 43470 22216 34595 10442 0 412350 331350 187344 26591 48919 330638 249638 72736 297734 216734 293889 65757 64896 5632 5790 70529 35186 21243 6956 83260 2260 99290 350962 269962 375346 37880 202342 23940 37 30 25881 31192 overage in gallons 7.1.12- usage 10.1.12 - 9.30.12 12.31.2012 40933 Winter/No Reading Winter/No Reading Winter/No Reading 248937 Winter/No Reading 104723 Winter/No Reading 150418 Winter/No Reading Winter/No Reading 16470 Winter/No Reading 7595 Winter/No Reading Winter/No Reading 160344 Winter/No Reading 21919 Winter/No Reading 45736 Winter/No Reading 266889 Winter/No Reading 37896 Winter/No Reading Winter/No Reading 8186 Winter/No Reading Winter/No Reading 72290 Winter/No Reading 348346 Winter/No Reading Winter/No Reading Winter/No Reading 4192 Winter/No Reading usage 1.1.12 - LOT # Status 3.31.12 303 Winter/No Reading 294 Winter/No Reading 296 Winter/No Reading 297 Winter/No Reading 298 Winter/No Reading 3J] Winter/No Reading 302 Winter/No Reading 300 GAL/NEEDS REPLACED Winter/No Reading 2001 Winter/No Reading 2002 VACANT Winter/No Reading 1003 Winter/No Reading 2003 Winter/No Reading 2004 Winter/No Reading 1005 Winter/No Reading 2005 Winter/No Reading 1006 Winter/No Reading 2006 Winter/No Reading 1007 Winter/No Reading 2007 Winter/No Reading 1008 Winter/No Reading 2008 GAL/NEEDS REPLACED Winter/No Reading 1009 VACANT Winter/No Reading 1010 Winter/No Reading Total Usage 2012 164508 28514 46690 468472 170761 245030 35754 92260 56811 10442 599694 75511 403374 591623 11422 105715 28200 182549 726308 61820 67 57072 LOT# Status 2010 1011 2011 1012 GAL/NEEDS REPLACED 2012 1013 2013 1014 2014 1015 2015 313 3011 KIM 2017 3010 3009 2019 3008 3007 2020 BANK OWNED 2021 3006 usage 1.1.12 - 3.31.12 Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading overage in overage in usage in gallons gallons gallons 10.1.11- 10.1.11- 7.1.12- 6.30.12 6.30.12 9.30.12 154671 73671 103830 1331 471 20742 8071 45640 260387 59460 9799 112 10420 0 38372 27863 6986 35508 24796 32934 1758 1481 90291 9291 74516 21916 33249 34984 32553 48149 75578 43608 40003 13748 67716 2902 1421 51590 20039 30825 81158 47251 59885 7 0 54529 17503 19755 14190 overage in gallons 7.1.12- usage 10.1.12 - 9.30.12 12.31.2012 76830 Winter/No Reading Winter/No Reading Winter/No Reading 32460 Winter/No Reading Winter/No Reading Winter/No Reading 863 Winter/No Reading 8508 Winter/No Reading 5934 Winter/No Reading Winter/No Reading 47516 Winter/No Reading 6249 Winter/No Reading 5553 Winter/No Reading 48578 Winter/No Reading 13003 Winter/No Reading 40716 Winter/No Reading Winter/No Reading Winter/No Reading 54158 Winter/No Reading 32885 Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Total Usage 2012 258501 1803 28813 105100 9911 10420 66235 42494 57731 3239 164807 55165 67537 123727 83611 81465 4323 71628 111983 107136 7 72032 33944 overage in overage in usage in overage in gallons gallons gallons gallons Total usage 1.1.12 - 10.1.11- 10.1.11- 7.1.12- 7.1.12- usage 10.1.12 - Usage LOT# Status 3.31.12 6.30.12 6.30.12 9.30.12 9.30.12 12.31.2012 2012 3005 VACANT Winter/No Reading 35710 62570 35570 Winter/No Reading 98280 2022 Winter/No Reading 47932 101032 74032 Winter/No Reading 148964 2023 Winter/No Reading 79123 93874 66874 Winter/No Reading 172997 3004 Winter/No Reading 37168 184539 157539 Winter/No Reading 221707 3003 Winter/No Reading 27676 25731 Winter/No Reading 53407 2024 Winter/No Reading 42920 116583 89583 Winter/No Reading 159504 2025 GAL/NEEDS REPLACED Winter/No Reading 35070 181324 60350 33350 Winter/No Reading 95420 3002 Winter/No Reading 17609 0 Winter/No Reading 17609 3001 Winter/No Reading 80305 47782 20782 Winter/No Reading 128088 271 Winter/No Reading 62570 59803 32803 Winter/No Reading 122373 270 Winter/No Reading 34804 61568 34568 Winter/No Reading 96372 255 Winter/No Reading 22268 6941 Winter/No Reading 29209 269 Winter/No Reading 84704 3704 48179 21179 Winter/No Reading 132882 256 GAL/NEEDS REPLACED Winter/No Reading 73985 942215 915215 Winter/No Reading 1016200 268 Winter/No Reading 35059 12806 Winter/No Reading 47865 258 Winter/No Reading 168180 87180 67051 40051 Winter/No Reading 235231 267 Winter/No Reading 63161 53063 26063 Winter/No Reading 116224 260 Winter/No Reading 42771 24175 Winter/No Reading 66946 265 Winter/No Reading 51911 106066 79066 Winter/No Reading 157978 264 Winter/No Reading 43047 11968 Winter/No Reading 55015 262 Winter/No Reading 110091 29091 75608 48608 Winter/No Reading 185698 263 BANK OWNED-NO MAILIN Winter/No Reading 2438 0 Winter/No Reading 2438 131 Winter/No Reading 22021 41910 14910 Winter/No Reading 63932 LOT# Status 131 245 243 248 GAL/NEEDS REPLACED 242 241 249 240 251 254 253 252 237 238 234 GAL/NEEDS REPLACED 233 232 218 231 GAL/NEEDS REPLACED 220 230 GAL/NEEDS REPLACED 221 229 overage in overage in usage in gallons gallons gallons usage 1.1.12 - 10.1.11- 10.1.11- 7.1.12- 3.31.12 6.30.12 6.30.12 9.30.12 Winter/No Reading 3119 322 Winter/No Reading 81091 91 132396 Winter/No Reading 26868 33959 Winter/No Reading 59720 365706 36350 Winter/No Reading 231439 150439 213030 Winter/No Reading 41738 15050 Winter/No Reading 47251 26330 Winter/No Reading 47131 32097 Winter/No Reading 21542 7577 Winter/No Reading 29486 50251 Winter/No Reading 363378 282378 169347 Winter/No Reading 10607 18446 Winter/No Reading 33279 20548 Winter/No Reading 22956 24893 Winter/No Reading 52620 312598 13934 Winter/No Reading 44057 142786 Winter/No Reading 109821 28821 154559 Winter/No Reading 61688 53235 Winter/No Reading 52380 310802 104080 Winter/No Reading 21378 5199 Winter/No Reading 44930 255076 51390 Winter/No Reading 53781 71434 Winter/No Reading 67283 62720 overage in gallons 7.1.12- usage 10.1.12 - 9.30.12 12.31.2012 Winter/No Reading 105396 Winter/No Reading 6959 Winter/No Reading 9350 Winter/No Reading 186030 Winter/No Reading Winter/No Reading Winter/No Reading 5097 Winter/No Reading Winter/No Reading 23251 Winter/No Reading 142347 Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading 115786 Winter/No Reading 127559 Winter/No Reading 26235 Winter/No Reading 77080 Winter/No Reading Winter/No Reading 24390 Winter/No Reading 44434 Winter/No Reading 35720 Winter/No Reading Total Usage 2012 3441 213487 60827 96070 444469 56788 73581 79228 29120 79737 532726 29052 53826 47850 66554 186843 264381 114923 156460 26576 96320 125215 130002 overage in overage in usage in overage in gallons gallons gallons gallons Total usage 1.1.12 - 10.1.11- 10.1.11- 7.1.12- 7.1.12- usage 10.1.12 - Usage LOT# Status 3.31.12 6.30.12 6.30.12 9.30.12 9.30.12 12.31.2012 2012 228 Winter/No Reading 71075 111160 84160 Winter/No Reading 182235 223 Winter/No Reading 72646 138058 111058 Winter/No Reading 210704 226 Winter/No Reading 314 0 Winter/No Reading 314 224 Winter/No Reading 9896 12484 Winter/No Reading 22380 225 Winter/No Reading 58486 61149 34149 Winter/No Reading 119635 79 Winter/No Reading 28529 72085 45085 Winter/No Reading 100613 37 Winter/No Reading 31139 40766 13766 Winter/No Reading 71905 203 Winter/No Reading 26202 36502 9502 Winter/No Reading 62705 201 Winter/No Reading 66579 21587 Winter/No Reading 88167 200 Winter/No Reading 57918 49959 22959 Winter/No Reading 107877 199 Winter/No Reading 48396 26315 Winter/No Reading 74710 198 Winter/No Reading 72736 70611 43611 Winter/No Reading 143347 197 Winter/No Reading 24415 11198 Winter/No Reading 35612 206 Winter/No Reading 54761 43137 16137 Winter/No Reading 97898 207 Winter/No Reading 70222 149458 122458 Winter/No Reading 219680 196 GAL/NEEDS REPLACED Winter/No Reading 65840 411483 41750 14750 Winter/No Reading 107590 195 Winter/No Reading 26389 147169 120169 Winter/No Reading 173558 208 Winter/No Reading 56459 397854 370854 Winter/No Reading 454313 194 Winter/No Reading 37475 52210 25210 Winter/No Reading 89685 209 Winter/No Reading 24452 16673 Winter/No Reading 41125 192 Winter/No Reading 110218 29218 116770 89770 Winter/No Reading 226988 211 Winter/No Reading 3059 61074 34074 Winter/No Reading 64134 214 Winter/No Reading 84374 3374 118782 91782 Winter/No Reading 203157 LOT # Status 215 216 186 191 183 188 182 181 179 147 180 148 177 176 175 150 174 151 173 172 154 GAL/NEEDS REPLACED 171 170 usage 1.1.12 - 3.31.12 Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading overage in overage in usage in gallons gallons gallons 10.1.11- 10.1.11- 7.1.12- 6.30.12 6.30.12 9.30.12 27900 21393 35605 56990 90673 9673 51934 80881 58411 136390 55390 63034 48306 125410 29524 44798 61785 112948 38926 36667 60760 74134 38223 56100 67657 99611 85900 4900 263169 24205 20645 53579 143369 50991 84614 32845 85526 47835 68397 23779 39494 8580 22418 70530 446564 127530 122567 41567 34430 43818 28776 overage in gallons 7.1.12- usage 10.1.12 - 9.30.12 12.31.2012 Winter/No Reading 29990 Winter/No Reading 24934 Winter/No Reading 31411 Winter/No Reading 36034 Winter/No Reading 98410 Winter/No Reading 17798 Winter/No Reading 85948 Winter/No Reading 9667 Winter/No Reading 47134 Winter/No Reading 29100 Winter/No Reading 72611 Winter/No Reading 236169 Winter/No Reading Winter/No Reading 116369 Winter/No Reading 57614 Winter/No Reading 58526 Winter/No Reading 41397 Winter/No Reading 12494 Winter/No Reading Winter/No Reading 100530 Winter/No Reading 7430 Winter/No Reading 1776 Winter/No Reading Total Usage 2012 49293 92595 142606 139293 199424 173716 74321 174733 75593 134894 94323 167268 349069 44850 196948 135605 118371 116232 63273 30997 198060 156998 72593 271757 64105 191646 27954 824 15948 12440 86843 564142 128379 70469 552772 36697 14190 177164 224692 28723 67971 33279 107129 151500 70589 13576 23816 19822 28596 123517 25649 128619 38948 overage in overage in usage in gallons gallons gallons 10.1.11- 10.1.11- 7.1.12- 6.30.12 6.30.12 9.30.12 48313 352757 145105 26322 272646 54170 9746 39868 108954 46451 68135 44252 55389 81824 54006 5804 5700 55277 69676 96948 41514 93440 55285 overage in gallons 7.1.12- usage 10.1.12 - 9.30.12 12.31.2012 59843 Winter/No Reading 537142 Winter/No Reading 101379 Winter/No Reading 43469 Winter/No Reading 525772 Winter/No Reading 9697 Winter/No Reading Winter/No Reading 150164 Winter/No Reading 197692 Winter/No Reading 1723 Winter/No Reading 40971 Winter/No Reading 6279 Winter/No Reading 80129 Winter/No Reading 124500 Winter/No Reading 43589 Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading 1596 Winter/No Reading 96517 Winter/No Reading Winter/No Reading 101619 Winter/No Reading 11948 Winter/No Reading usage 1.1.12 - LOT # Status 3.31.12 169 Winter/No Reading 162 Winter/No Reading 166 Winter/No Reading 165 Winter/No Reading 167 Winter/No Reading 163 Winter/No Reading 164 Winter/No Reading 33 Winter/No Reading 28 Winter/No Reading 22 Winter/No Reading 26 Winter/No Reading 25 Winter/No Reading 23 Winter/No Reading 24 Winter/No Reading 30 Winter/No Reading 29 Winter/No Reading 27 Winter/No Reading 160 Winter/No Reading 159 Winter/No Reading 135 Winter/No Reading 156 Winter/No Reading 136 Winter/No Reading 134 Winter/No Reading Total Usage 2012 135156 916898 273484 96791 825418 90867 23936 217032 333645 75174 136106 77530 162518 233324 124594 19381 29516 75099 98272 220466 67163 222059 94233 overage in overage in usage in gallons gallons gallons 10.1.11- 10.1.11- 7.1.12- 6.30.12 6.30.12 9.30.12 27751 92079 26337 22515 34228 299873 134116 61942 39375 11079 218873 53116 28798 79482 27339 52397 13516 53265 336548 48493 60977 44116600 30002407 LOT# Status 133 132 153 137 138 139 140 141 143 144 NEEDS REPLACED 149 145 146 usage 1.1.12 - 3.31.12 Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading Winter/No Reading 40489 0 46002 100995 32254 88040 129711 48711 192393 20513728 23602873 overage in gallons 7.1.12- usage 10.1.12 - 9.30.12 12.31.2012 1798 Winter/No Reading 52482 Winter/No Reading 339 Winter/No Reading 25397 Winter/No Reading Winter/No Reading 26265 Winter/No Reading 309548 Winter/No Reading 21493 Winter/No Reading 33977 Winter/No Reading Winter/No Reading 73995 Winter/No Reading 61040 Winter/No Reading 165393 Winter/No Reading Total Usage 2012 56549 171561 53676 74912 47745 353138 470664 110435 100352 40489 146997 120293 322104 OJL?L1 12888410 17113997 CASE NO. SPL-W-13-01 SPIRIT LAKE WATER COMPANY FIRST PRODUCTION REQUEST RESPONSE ALL RESPONSES DRAFTED BY LESLIE ABRAMS, PRESIDENT SLEWCO. REQUEST NO. 11: We have provided a percentage of unmetered water for each calendar year. We have also provided data showing that this is not unaccounted for water due to leaks in our system but rather it is the amount of water that is making up the volume of our system infrastructure as well as the water we "waste" during our twice annual end of line directional velocity flushing procedure. SLEWCO. Water Production with Percentage unmetered: 2010, 2011, 2012 Jan-10 2652900 Feb-10 2113600 Mar-10 1665500 Apr-10 3422300 Flushing May-10 1956200 Jun-10 4121200 Jul-10 6890700 Aug-10 8242600 Sep-10 4800000 Flushing Oct-10 2566000 Nov-10 2141400 Dec-10 2419000 Total 2010 Gallons 42991400 Difference: 6352112 Percentage: 0.1477531 Delivered 36639288 Jan-11 1758200 Feb-11 2704000 Mar-11 1700000 Apr-11 1828400 May-11 4530600 Flushing Jun-11 5674000 Jul-11 11570800 Aug-11 8262800 Sep-11 4136520 Oct-11 3407400 Flushing Nov-11 2619100 Dec-11 1655900 Total 2011 Gallons 49847720 Difference: 7804462 Percentage: 0.1565661 Delivered 42043258 Jan-12 2754800 Feb-12 2465400 Mar-12 1914500 Apr-12 3890500 Flushing May-12 5332100 Jun-12 2997600 Jul-12 7167840 Aug-12 10412060 Flushing Sep-12 5580700 Oct-12 2801900 Nov-12 2722000 Dec-12 2979100 Total 2012 Gallons 51018500 Difference: 6901900 Percentage: 0.1352823 Delivered 44116600 CASE NO. SPL-W-13-01 SPIRIT LAKE WATER COMPANY FIRST PRODUCTION REQUEST RESPONSE ALL RESPONSES DRAFTED BY LESLIE ABRAMS, PRESIDENT SLEWCO. REQUEST NO. 13: Please see attachment. After running the numbers it is apparent that per our sales for 2012 the Company's proposed rate will not meet the revenue requirement of $150,414. Please see attachment. REQUEST NO. 13 RATE PROOF INCOME FOR FISCAL YEAR 2011/2012 AT CURRENT RATES OF $12.50/MONTH OR $37.50 QRTR 4TH QRTR 2011 CUSTOMER BASE 4TH QRTR CUSTOMER OVERAGE - NO READING 1ST QRTR 2012 CUSTOMER BASE 1ST QRTR CUSTOMER OVERAGE - NO READING 2ND QRTR 2012 CUSTOMER BASE 2ND QRTR CUSTOMER OVERAGES IN GALLONS AT 1.20 PER 1000 GALLONS 3RD QRTR 2012 CUSTOMER BASE 3RD QRTR CUSTOMER OVERAGES IN GALLONS AT 1.20 PER 1000 GALLONS 288 $37.50 $10,800.00 288 $37.50 $10,800.00 288 $37.50 $10,800.00 12888410 12888.41 $15,466.09 288 $37.50 $10,800.00 17113997.16 17114 $20,536.80 TOTAL: $79,202.89 INCOME FOR FISCAL YEAR 2011/2012 AT PROPOSED RATES OF $25.75/MONTH OR $77.25 QRTR 4TH QRTR 2011 CUSTOMER BASE 4TH QRTR CUSTOMER OVERAGE - NO READING 1ST QRTR 2012 CUSTOMER BASE 1ST QRTR CUSTOMER OVERAGE - NO READING 2ND QRTR 2012 CUSTOMER BASE 2ND QRTR CUSTOMER OVERAGES IN GALLONS AT 1.20 PER 1000 GALLONS 3RD QRTR 2012 CUSTOMER BASE 3RD QRTR CUSTOMER OVERAGES IN GALLONS AT 1.20 PER 1000 GALLONS 288 $77.25 $22,248.00 288 $77.25 $22,248.00 288 $77.25 $22,248.00 12888410 12888.41 $15,466.09 288 $77.25 $22,248.00 17113997.16 17114 $20,536.80 TOTAL: $124,994.89 CASE NO. SPL-W-13-01 SPIRIT LAKE WATER COMPANY FIRST PRODUCTION REQUEST RESPONSE ALL RESPONSES DRAFTED BY LESLIE ABRAMS, PRESIDENT SLEWCO. REQUEST NO.14: Please see attached list showing all water quality tests as required by IDEQ. We have figured the costs over the next 8 years as that follows the IDEQ sampling format. Sampling Requirement and Cost over the next 8 years TEST: FREQUENCY: COST: # OF TEST IN 8 YEARS: 8 YEAR TOTAL: 8 YEAR TOTAL PRORATED: Coliform Monthly 20 96 1920 240 Nitrate 1 each years 20 8 160 20 Lead and Copper 10 each 3 years 30 30 900 112.5 2013 2016 2019 TTHM HAAS 1 each 3 years 250 3 750 93.75 2013 2016 2019 RADS 226 leach 3years 120 3 360 45 2013 2016 2019 RADS228 leach 3years 110 3 330 41.25 2013 2016 2019 lOC leach 3 years 195 3 585 73.125 2013 2016 2019 RADS-URANIUM 1 each 6 years 55 2 110 13.75 2013 2019 VOCS 1 each 6 years 160 2 320 40 2013 2019 ARSENIC 1 each 9 years 20 1 20 2.5 2019 FLOURIDE 1 each 9 years 20 1 20 2.5 2019 IOCS PHASE 2 and 5 1 each 9 years 195 1 195 24.375 2019 RADS- Gross Alpha 1 each 6 years 75 2 150 18.75 2013 2019