Laserfiche WebLink
4.9.7 Tool for Estimating Potential GHG Savings <br />Foth prepared an Excel spreadsheet that can be used by individual cities to determine an estimate <br />of GHG savings for their city by changing from an open collection to an organized collection <br />system. The electronic file was provided to the MPCA with the report. A hard copy of the tool <br />is provided in Appendix H. <br />The instructions to use the tool are provided within the spreadsheet. To complete the estimate, <br />the following data is required: <br />The number of single family households receiving curbside collection service. <br />The number of households serviced by each hauler or some estimate of the each hauler's <br />market share. This may be available from hauler reports provided to cities or counties. <br />One way to develop an estimate if this information if it is not available is to follow <br />haulers on their route and count the houses the hauler serves versus all the households <br />passed (complete a sample for each hauling company). Another potential approach <br />would be to drive a sample area and document carts for each hauler (drive a <br />representative sample of multiple areas of the city). <br />Calculate the distance per household on the route by dividing the total distance driven by <br />the total households counted in various sections of the city. <br />Use the list of distances and fuel consumption rates in the spreadsheet tool to enter the <br />corresponding fuel consumption for the corresponding distance between homes serviced <br />by each hauler (the distance per household serviced by hauler automatically calculates <br />based on the average distance between households and the hauler's market share). <br />The spreadsheet will provide estimates of total annual fuel consumption and total annual CO2e <br />and Ce. <br />R - Analysis of Waste Collection Service Arrangements.doc Foth Infrastructure & Environment, LLC • 147 <br />June 2009 <br />