Final_Holloman_AFB_CMA_PDF_Full_Draft_Apr2018.pdf

INSTRUCTIONS

Commodity

Tons Recycled (Fiscal

Year) (Updates each time the DataCallInfoSheet is updated)

Proceeds (Fiscal Year)

(Updates each time the

DataCallInfoSheet is updated)

Data Call Info Aerosol Cans (empty)

Summary Data Sheet Aluminum 23.31 $7,459.20

Feasibility Analysis Aluminum Cans 0.81 $649.35

WS1 Generation Data Antifreeze 0.00 $0.00

WS2 Buyer Pricing Bimetal Cans 0.00 $0.00

WS3 Scoring Sheet Brass 14.64 $41,244.00

Buyer Info Cardboard 189.99 $8,411.34

CBA Equipment Cell Phones

Cost Benefit Analysis Clear Glass 0.00 $0.00

C&D Colored Glass 0.00 $0.00

Waste Percentage Estimates Cooking Grease 0.00 $0.00

Copper 2.35 $7,057.50

IMPORTANT NOTES:

Electronics (non data storage)

3.62 $0.00

Equipment 0.00 $0.00

Expended Brass

Fabric/Textiles/Rags 0.00 $0.00

Film Plastic 0.00 $0.00

HDPE #2 0.00 $0.00

Hi-Temp Alloys

Lead-Acid Batteries 29.72 $12,769.31

2,157 Machine Parts

Magazines

2. Enter the per ton tipping fee for the landfill used by the Base in the yellow box:

$23.50 Misc. Batteries 0.00 $0.00

Mixed Paper 41.79 $5,085.90

3. Enter the total annual cost for the contract for solid waste minus any recycling costs and tipping fee charges in the blue box.

$301,704.00 Mixed Recyclables

Newspaper 0.00 $0.00

$199.35 Other (Food) 38.54 $0.00

Other (Glass) 0.00 $0.00

Other (Metals) 96.48 $4,434.40

Other (Non-Food) 44.14 $0.00

Other (Paper) 0.35 0.00

Other (Plastic) 1.76 0.00

6. Go to WS3ScoringSheet. Other (Textiles) 0.00 $0.00

Other (Wood) 0.00 $0.00

Paint 0.00 $0.00

Pallets, Scrap 0.00 $0.00

PETE #1 2.00 $0.00

Plastics Nos. 3-7 0.00 $0.00

Precious Metals

Rags (Non-Hazardous) 0.00 $0.00

Range Residue

(Other)

Rubber

Sandblast Residue 0.00 $0.00

Shredded Paper

Steel (Stainless) 8.29 $3,647.60

Target Metals Gleaned

Timber/Wood Waste 0.00 $0.00

Tin 0.00 $0.00

Tires 18.62 $0.00

Toner/Ink Jet

Cartridges

3.00 $2,286.00

Used Fuel (JP-8, Diesel)

Used Hydraulic Fluid 0.00 $0.00

Used Motor Oil 38.39 $0.00

Used Solvent 0.00 $0.00

Used Vehicles 0.00 $0.00

White Goods/

Appliances

1.24 $0.00

White Paper (High

Grade)

Wire, metal 0.00 $0.00

558.69 $93,044.60

•Making changes to certain cells will cause cells in other worksheets to change as well, which may affect calculations in other worksheets.

•IMPORTANT! Make a copy of this workbook and work from the new copy. Save the original copy. Include the Fiscal Year in the title of the new workbook.

1. Ensure the DataCallInfo worksheet is complete for the fiscal year being evaluated. The table starting in column F on this page is a summary of the Data Call Information sheet, and is linked from that page. Most other tables are dependent on this summary table. Grey cells/rows are those for which a percentage of waste generated could not be calculated or the commodity is not eligible for the QRP or diversion metric. Once the DataCallInfo sheet is complete, the grey cell below (Cell B23) is automatically calculated. This number is the total waste generated by the base in tons (solid waste disposal plus total recycling).

To Complete an Annual Update of this CMA or Change Critical Information:

b. All fields in white (except for the Commodity Name) should be completed in accordance with the instructions at the top of each column.

The grey box is automatically calculated for per ton contract costs for disposal.

4. Skipping the Feasibility Analysis sheet for now, check that the information in the WS1GenerationData Sheet is current and correct in

a. Any column that is greyed out contains links or formulas and should not be changed.

c. After the first year of data, the only changes that will be needed are in cases where commodities recycled or methods to recycle them have changed.

Use the CLINs from the Solid Waste contract to determine this number. Your Solid Waste COR should have this information.

5. Go to WS2BuyerPricing sheet. Update buyer names, prices, and terms for the new fiscal year. Ensure at least 3 buyers/brokers are

10. Complete the Feasibility Analysis sheet by sorting by the Commodity Score (column G) and filling in information in the analysis section

11. Copy and paste the Summary Data Sheet and Feasibility Analysis into the Integrated Solid Waste Management Plan in the appropriate

7. Complete buyer/broker information in the BuyerInfo sheet, creating a copy of buyer/broker information for each commodity they

8. Enter C&D Diversion Data in the C&D sheet.

9. Complete Cost Benefit Analyses for equipment and total operations (if needed) for conditions and equipment if needed. Instructions are included on each page.

Not allowed for QRP or data call.

Percentage data not available. Included with Other Metals.

Percentage data not available. Included with Tires.

Percentage data not available, but data should be collected for data call if non-hazardous paint is diverted.

No data on percentage disposed. Included with Mixed Paper

The total for this waste is included with mixed paper to ensure the weight is calculated despite the unavailability of percentage of white paper in the waste stream.

A percentage for magazine disposal cannot be determined. Magazines are included in the Mixed Paper category.

Included with Other Non-Food. Category is vague, thus all remaining percentages are in Other.

A percentage for machine parts disposal cannot be determined. Machine parts are included in the Other Metal category.

Rankings of commodities and potential commodities with explanations, caveats, and additional information. This sheet is the culmination of many other sheets, providing rankings of commodity scores. A Feasibility Analysis is required by Department of Defense Instruction and this sheet may be copied and pasted in the same appendix as the Summary Data Sheet in the Integrated Solid Waste

Management Plan.

Used to determine if changes in techniques or equipment will support greater diversion and/or proceeds.

Cost Benefit Analysis for purchase of equipment, if needed.

Enter C&D diversion data in this spreadsheet.

WS2 Buyer Pricing provides information on three potential buyers for each commodity and the current price each pays for the commodity.

The scoring sheet is used to develop a Commodity Score for each potential recyclable.

•Some cells in worksheets are locked to editing, as they contain formulas or links to other cells and worksheets. There is no password, so sheets may be unlocked if needed.

Sources of information for waste percentage estimates of each commodity.

No stats on aerosol cans. Included in Other Metals.

Although a percentage of antifreeze in SW stream could not be determined, antifreeze diversion data should be collected for the data call. Additionally, recycling feasibility decisions are made based on the cost of disposal of

Antifreeze, which differs from cost of disposal for SW.

Instructions start at Row 20 of this worksheet.

First review the purpose of each worksheet in this workbook:

DataCallInfo must be completed before anything else in this workbook can be considered completed.

Government Cell Phones must be turned into DLADS. Personal cell phones are disposed of at various locations throughout the base area. There is risk to recycling cell phones by the QRP, as they may have sensitive data in storage.

Notes

This worksheet provides functional data for the analysis, based on estimates or actual percentages of waste generated, unless the base has performed a waste stream analysis.

A useful list of commodity buyers with contact information and the commodities they recycle. This worksheet may be sorted by buyer, commodity or location.

This spreadsheet is not as complicated as it looks - the only information required for entry is tons recycled, proceeds, and buyer/broker. It should be used to collect data for the data call. If used to collect data call information, it automatically populates all other worksheets in this workbook, making updates of this Commodity Market Analysis and Feasibility Study much more simple and quick.

Although "Equipment" is too vague to determine a percentage, equipment diverted through NAF should be counted as diversion. Equipment must be considered scrap. Diversion weights should be captured for the data call.

Added to Brass category to incorporate all types of brass to match percentage calculations by EPA.

A percentage for hi-temp alloy disposal cannot be determined. Hi temp alloys are included in the Other Metal category.

Summary of numerical data on all recyclable commodities for the Installation. This sheet may be copied and pasted into the appropriate appendix in the Integrated Solid Waste Management Plan. This sheet is locked for changes, as the each cell in the sheet is either linked or has a formula.

DLADS tons not included in this table, as it is included in DataCallInfo sheet for diversion rate, but base does not have control over sales price or buyer. Additionally, if

DLADS information is separated by commodity, it should be entered into appropriate commodity in DataCallInfo Sheet.

A percentage for white paper disposal cannot be determined. White Paper is included in the Mixed Paper category.

Although waste percentage cannot be determined, data should be collected for hydraulic fluid for data call if diversion purpose is not waste-to-energy.

Although waste percentage cannot be determined, data should be collected for used motor oil for data call if diversion purpose is not waste-to-energy.

Although waste percentage cannot be determined, data should be collected for used solvent for data call if diversion purpose is not waste-to-energy.

Percentage data not available. Included with Other Metals.

Not QRP or data call eligible, as nearly all would be used as Waste-To-Energy (burned for fuel).

Data Call Entry Sheet

Date Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Tons

OCT 20.02 $2,502.50 Master Fibers $125.00 0.00 $0.00 $0.00 11.55 $1,693.21 Master Fibers $146.60 0.00 $0.00 $0.00 17.50 0.00

NOV 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.30 $0.00 DeCA $0.00 17.01 0.00

DEC 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 0.00

JAN 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.05 $0.00 DeCA $0.00 22.94 0.00

FEB 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 0.00

MAR 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 23.80 0.00

APR 5.44 $898.01 Master Fibers $165.08 0.00 $0.00 $0.00 18.45 $2,305.94 Master Fibers $124.98 0.00 $0.00 $0.00 9.35 0.00

MAY 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 0.00

JUN 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 4.71 0.00

JUL 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 14.99 0.00

AUG 32.95 $5,010.83 Master Fibers $152.07 0.00 $0.00 $0.00 11.44 $1,086.75 Master Fibers $95.00 0.00 $0.00 $0.00 21.28 0.00

SEP 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 0.00 Tons Dollars

Q1 20.02 $2,502.50 0.00 $0.00 11.55 $1,693.21 0.30 $0.00 35 0.00 66.38 $ 4,195.71

Q2 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.05 $0.00 47 0.00 46.79 $ -

Q3 5.44 $898.01 0.00 $0.00 18.45 $2,305.94 0.00 $0.00 14 0.00 37.95 $ 3,203.95

Q4 32.95 $5,010.83 0.00 $0.00 11.44 $1,086.75 0.00 $0.00 36 0.00 80.66 $ 6,097.58

FY 58.41 $8,411.34 0.00 $0.00 41.44 $5,085.90 0.35 $0.00 131.58 0.00 231.78 $ 13,497.24

Verify Total: 231.78 $13,497.24

Date Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Tons

OCT 0.00 $0.00 $0.00 0.00 $0.00 $0.00 2.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.59 0.00

NOV 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.29 0.00

DEC 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 0.00

JAN 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.54 0.00

FEB 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 0.00

MAR 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 0.00

APR 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 0.00

MAY 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 0.00

JUN 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.34 0.00

JUL 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 0.00

AUG 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 0.00

SEP 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 0.00 Tons Dollars

Q1 0.00 $0.00 0.00 $0.00 2.00 $0.00 0.00 $0.00 0.00 $0.00 0.88 0.00 2.88 $ -

Q2 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.54 0.00 0.54 $ -

Q3 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.34 0.00 0.34 $ -

Q4 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 0.00 0.00 $ -

FY 0.00 $0.00 0.00 $0.00 2.00 $0.00 0.00 $0.00 0.00 $0.00 1.76 0.00 3.76 $ -

3.76 $0.00

•The following items are not included, because they are not QRP or Diversion Metric eligible: Cell Phones, Precious Metals, Used Fuel.

2. Enter DLADS and refuse information at the bottom of this sheet, starting on Row 252.

NOTES:

BACK TO

TOP

Average Per

Ton Price:

Plastic

Recycled by

AAFES

FIBER

PLASTIC

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

#DIV/0! #DIV/0!

Average Per

Ton Price:

#DIV/0!

Other PlasticFilm Plastic

Plastic

Recycled by

DeCA

4/2/2018 17:38

Cardboard

Recycled by

DeCA

Cardboard

Recycled by

AAFES

Refuse

•Colors for each Commodity signify nothing. They are simply a way to separate commodities and better view the data.

•If different commodities are recycled, they may be inserted in the Non-Food Mixed Recyclables Category or Other Paper Category, but those names need to be changed on all other worksheets.

Food Non-Food

Miscellaneous Categories

LAST UPDATED ON:

HDPE #2 PETE #1 Plastics 3-7

122.19$

Other Paper (white paper, added to total of Mixed Paper in other calculations in this workbook due to lack of percentage data for this category)

Average Per

Ton Price:

#DIV/0!

Cardboard

Base Recycling

(not AAFES/DeCA)

Newspaper

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

147.38$

Mixed-Paper

With No Calculable Percent Disposal

(Shred, Magazines, White)

Average Per

Ton Price:

Select Wastes (1) Select Wastes (2)

DLA

WASTE CATEGORIES

Click on the name of the category to go to the first cell of data entry for the first commodity in that category.

Fiber

Plastic

Glass

Metal (1) Metal (2)

Textiles Wood

Instructions for this page.

1. Enter monthly tons and proceeds and buyer/broker for each commodity sold.

•If different or additional categories are required, they will need to be changed appropriately in other worksheets.

•Quarterly data automatically rolls up at the bottom of each commodity, summary data rolls up at the end of each major category (to the right). All data rolls up at the bottom of this sheet.

Date Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton

OCT 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

NOV 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

DEC 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JAN 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

FEB 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

MAR 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

APR 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

MAY 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JUN 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JUL 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

AUG 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

SEP 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 Tons Dollars

Q1 $0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $ -

Q2 $0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $ -

Q3 $0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $ -

Q4 $0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $ -

FY $0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $ -

0.00 $0.00

Date Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton

OCT 1.74 $80.04 DLADS $46.00 19.01 $6,083.20 DLADS $320.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 10.01 $28,280.00 DLADS $2,825.17

NOV 9.97 $458.62 DLADS $46.00 0.60 $192.00 DLADS $320.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

DEC 0.20 $9.20 DLADS $46.00 0.64 $204.80 DLADS $320.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 2.53 $7,084.00 DLADS $2,800.00

JAN 5.77 $265.42 DLADS $46.00 0.03 $9.60 DLADS $320.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 2.00 $5,600.00 DLADS $2,800.00

FEB 6.26 $287.96 DLADS $46.00 0.08 $25.60 DLADS $320.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.04 $112.00 DLADS $2,800.00

MAR 0.08 $0.00 DeCA $0.00 2.95 $944.00 DLADS $320.00 0.81 $649.35 A.C.T $801.67 0.00 $0.00 $0.00 0.06 $168.00 DLADS $2,800.00

APR 72.46 $3,333.16 DLADS $46.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

MAY 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JUN 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JUL 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

AUG 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

SEP 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

Q1 96.48 $547.86 20.25 $6,480.00 0.00 $0.00 0.00 $0.00 12.54 $35,364.00

Q2 12.11 $553.38 3.06 $979.20 0.81 $649.35 0.00 $0.00 2.10 $5,880.00

Q3 72.46 $3,333.16 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00

Q4 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00

FY 96.48 $4,434.40 23.31 $7,459.20 0.81 $649.35 0.00 $0.00 14.64 $41,244.00

Date Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton

OCT 0.00 $0.00 $0.00 0.25 $757.50 DLADS $3,030.00 0.08 $35.20 DLADS $440.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

NOV 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.73 $321.20 DLADS $440.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

DEC 0.00 $0.00 $0.00 0.00 $0.00 $0.00 5.38 $2,367.20 DLADS $440.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JAN 0.00 $0.00 $0.00 2.00 $6,000.00 DLADS $3,000.00 2.00 $880.00 DLADS $440.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

FEB 0.00 $0.00 $0.00 0.04 $120.00 DLADS $3,000.00 0.04 $17.60 DLADS $440.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

MAR 0.00 $0.00 $0.00 0.06 $180.00 DLADS $3,000.00 0.06 $26.40 DLADS $440.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

APR 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

MAY 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JUN 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JUL 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

AUG 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

SEP 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 Tons Dollars

Q1 0.00 $0.00 0.25 $757.50 6.19 $2,723.60 0.00 $0.00 0.00 $0.00 135.71 $45,873

Q2 0.00 $0.00 2.10 $6,300.00 2.10 $924.00 0.00 $0.00 0.00 $0.00 22.28 $15,286

Q3 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 72.46 $3,333

Q4 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0

FY 0.00 $0.00 2.35 $7,057.50 8.29 $3,647.60 0.00 $0.00 0.00 $0.00 #DIV/0! 145.88 $64,492

230.45 $64,492.05

BACK TO

TOP

BACK TO

TOP

BACK TO

TOP

Average Per

Ton Price:

Average Per

Ton Price:

#DIV/0!

Other Metal

With No Calculable Percent Disposal (Aerosol Cans, Machine Parts, Range Residue, Gleaned Target

Metals, Hi-Temp Alloys)

Aluminum Aluminum Cans Bi Metal Cans Brass and Expended Brass

Wire, MetalTinSteel (Stainless)CopperUsed Vehicles

Average Per

Ton Price:

440.00$ #DIV/0!

Average Per

Ton Price:

3,007.50$

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

2,805.03$

Average Per

Ton Price:

#DIV/0!

Other Glass (use this category for combined glass)

Colored Glass

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

#DIV/0!

METAL

Section 1 of 2

METAL

Section 2 of 2

GLASS

Average Per

Ton Price:

46.00$

Average Per

Ton Price:

320.00$

Average Per

Ton Price:

801.67$

Clear Glass

Date Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton

OCT 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

NOV 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

DEC 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JAN 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

FEB 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

MAR 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

APR 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

MAY 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JUN 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JUL 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

AUG 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

SEP 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

Q1 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00

Q2 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00

Q3 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00

Q4 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00

FY 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00

Date Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton

OCT 0.00 $0.00 $0.00 2.00 $0.00 DeCA $0.00 2.00 $0.00 $0.00

NOV 0.00 $0.00 $0.00 1.88 $0.00 DeCA $0.00 2.00 $0.00 $0.00

DEC 0.00 $0.00 $0.00 3.75 $0.00 DeCA $0.00 2.00 $0.00 $0.00

JAN 0.00 $0.00 $0.00 5.58 $0.00 DeCA $0.00 2.00 $0.00 $0.00

FEB 0.00 $0.00 $0.00 2.44 $0.00 DeCA $0.00 2.00 $0.00 $0.00

MAR 0.00 $0.00 $0.00 1.87 $0.00 DeCA $0.00 2.00 $0.00 $0.00

APR 0.00 $0.00 $0.00 3.76 $0.00 DeCA $0.00 2.78 $0.00 DLADS .78T $0.00

MAY 0.00 $0.00 $0.00 2.96 $0.00 DeCA $0.00 6.58 $0.00 DLADS 2.58T $0.00

JUN 0.00 $0.00 $0.00 2.36 $0.00 DeCA $0.00 6.58 $0.00 DLADS 2.58T $0.00

JUL 0.00 $0.00 $0.00 1.43 $0.00 DeCA $0.00 6.40 $0.00 DLADS 4.40T $0.00

AUG 0.00 $0.00 $0.00 6.61 $0.00 DeCA $0.00 3.80 $0.00 DLADS 1.8T $0.00

SEP 0.00 $0.00 $0.00 3.90 $0.00 DeCA $0.00 6.00 $0.00 DLADS 4T $0.00 Tons Dollars

Q1 0.00 $0.00 7.63 $0.00 6.00 $0.00 13.63 $ -

Q2 0.00 $0.00 9.89 $0.00 6.00 $0.00 15.89 $ -

Q3 0.00 $0.00 9.08 $0.00 15.94 $0.00 25.02 $ -

Q4 0.00 $0.00 11.94 $0.00 16.20 $0.00 28.14 $ -

FY 0.00 $0.00 38.54 $0.00 44.14 $0.00 82.68 $ -

82.68 $0.00

Date Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton

OCT 0.80 $0.00 DLADS $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

NOV 0.33 $0.00 DLADS $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

DEC 0.66 $0.00 DLADS $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 2.40 $0.00 DLADS $0.00

JAN 1.07 $0.00 DLADS $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 5.51 $0.00 DLADS $0.00

FEB 0.13 $0.00 DLADS $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

MAR 0.63 $0.00 DLADS $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 1.24 $0.00 DLADS $0.00 10.71 $0.00 DLADS $0.00

APR 0.00 $0.00 $0.00 0.00 $0.00 $0.00 3.00 $2,286.00 Jaco $762.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

MAY 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JUN 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JUL 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

AUG 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

SEP 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 Tons Dollars

Q1 1.79 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 2.40 $0.00 4.19 $0.00

Q2 1.83 $0.00 0.00 $0.00 0.00 $0.00 1.24 $0.00 16.22 $0.00 19.29 $0.00

Q3 0.00 $0.00 0.00 $0.00 3.00 $2,286.00 0.00 $0.00 0.00 $0.00 3.00 $2,286.00

Q4 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00

FY 3.62 $0.00 0.00 $0.00 3.00 $2,286.00 1.24 $0.00 18.62 $0.00 26.48 $2,286.00

26.48 $2,286.00

BACK TO

TOP

BACK TO

TOP

BACK TO

TOP

Average Per

Ton Price:

Tires (includes rubber)

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

762.00$

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

#DIV/0!

Electronics (only non-data-containing peripherals)

#DIV/0!

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

#DIV/0!

Average

Per Ton

Price:

#DIV/0!

Pallets, Scrap Other Wood Timber/Wood Waste

Cooking Grease Other Food

(Donated and Composted)

Donations via Airman's Attic and

Holloman AFB Thrift Store (1 TON each per month)

Furniture Through DLADS

FOOD

WOOD

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

Fabric/Textiles/Rags Other Textiles Rags (Non-Hazardous

TEXTILES

NON-FOOD OTHER

#DIV/0!

Average Per

Ton Price:

#DIV/0!

MISCELLANEOUS CATEGORIES

Equipment (usually NAF items)

Toner/Ink Jet Cartridges White Goods /Appliances

Date Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton

OCT 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

NOV 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

DEC 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JAN 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

FEB 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

MAR 0.00 $0.00 $0.00 0.00 $0.00 $0.00 18.23 $7,657.33 Union $420.04 0.00 $0.00 $0.00

APR 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

MAY 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JUN 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JUL 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

AUG 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

SEP 0.00 $0.00 $0.00 0.00 $0.00 $0.00 11.49 $5,111.98 Union $444.91 0.00 $0.00 $0.00

Q1 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00

Q2 0.00 $0.00 0.00 $0.00 18.23 $7,657.33 0.00 $0.00

Q3 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00

Q4 0.00 $0.00 0.00 $0.00 11.49 $5,111.98 0.00 $0.00

FY 0.00 $0.00 0.00 $0.00 29.72 $12,769.31 0.00 $0.00

Date Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton Tons Proceeds Buyer Per Ton

OCT 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

NOV 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

DEC 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JAN 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

FEB 0.00 $0.00 $0.00 0.00 $0.00 $0.00 6.94 $0.00 Mesa $0.00 0.00 $0.00 $0.00

MAR 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

APR 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

MAY 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

JUN 0.00 $0.00 $0.00 0.00 $0.00 $0.00 12.21 $0.00 Mesa $0.00 0.00 $0.00 $0.00

JUL 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00

AUG 0.00 $0.00 $0.00 0.00 $0.00 $0.00 19.24 $0.00 Heritage $0.00 0.00 $0.00 $0.00

SEP 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 0.00 $0.00 $0.00 Tons Dollars

Q1 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00 0.00 $0.00

Q2 0.00 $0.00 0.00 $0.00 6.94 $0.00 0.00 $0.00 25.17 $7,657.33

Q3 0.00 $0.00 0.00 $0.00 12.21 $0.00 0.00 $0.00 12.21 $0.00

Q4 0.00 $0.00 0.00 $0.00 19.24 $0.00 0.00 $0.00 30.73 $5,111.98

FY 0.00 $0.00 0.00 $0.00 38.39 $0.00 0.00 $0.00 68.11 $12,769.31

68.11 $12,769.31

Total Recycled Total Total MSW Total Generated Diversion Rate Quarter (Tons) Proceeds (Tons) (Tons) Percent

Date Tons Proceeds Date (Tons) Q1 222.79 $50,068.67 347.29 570.08 39.1%

OCT 0.00 $0.00 OCT 133.86 Q2 129.96 $22,943.26 362.67 492.63 26.4%

NOV 0.00 $0.00 NOV 108.89 Q3 150.98 $8,823.11 387.08 538.06 28.1%

DEC 0.00 $0.00 DEC 104.54 Q4 139.53 $11,209.56 416.41 555.94 25.1%

JAN 0.00 $0.00 JAN 125.28 Annual 643.26 $93,044.60 1,513.45 2,156.71 29.8%

FEB 0.00 $0.00 FEB 107.48

MAR 0.00 $0.00 MAR 129.91

APR 0.00 $0.00 APR 117.63 Notes: Aluminum weights are estimated based on $600/ton.

MAY 0.00 $0.00 MAY 132.31

JUN 0.00 $0.00 JUN 137.14

JUL 0.00 $0.00 JUL 134.78

AUG 0.00 $0.00 AUG 152.63

SEP 0.00 $0.00 SEP 129.00

Q1 0.00 $0.00 Q1 347.29

Q2 0.00 $0.00 Q2 362.67

Q3 0.00 $0.00 Q3 387.08

Q4 0.00 $0.00 Q4 416.41

FY 0.00 $0.00 FY 1,513.45

Tons QA 0.00

BACK TO TOP

BACK TO

TOP

BACK TO

TOP

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

#DIV/0!

Antifreeze Sandblast Residue

Cooking Oil

Conversions Used in Metrics

Conversion FactorMaterial

Used Oil

Paint

Solvent

Hydraulic Fluid

7 Pounds/Gallon

11.5 Pounds/Gallon

6.4 Pounds/Gallon

7.2 Pounds/Gallon

8 Pounds/Gallon

Lead Acid Batteries

Antifreeze 9.4 Pounds/Gallon

Pallets 40 Pounds/Pallet

DLA* *Items that are separated into commodity type sold should be entered into that commodity section (above) and weights and proceeds for those commodities should not be included in this DLA table.

Average Per

Ton Price:

#DIV/0!

Average Per

Ton Price:

#DIV/0!

Refuse (MSW)

Lead Acid Batteries Misc. Batteries

Paint (non-hazardous)

SELECT WASTES (USUALLY DISPOSITIONED BY HAZMART)

Section 1 of 2

SELECT WASTES (USUALLY DISPOSITIONED BY HAZMART)

Section 2 of 2

Average Per

Ton Price:

432.47$

Used Hydraulic Fluid (Waste-to-Energy not allowed)

Used Motor Oil (Waste-to-Energy not allowed)

Used Solvent (Waste-to-Energy not allowed)

Average Per

Ton Price:

#DIV/0!

Summary Data Sheet

(feeds to other sheets)

A C D E F G H I J K L M

Commodity

Tons

Recycled

Total

Proceeds

Average Commodity

Market Price per Ton

Total Waste

Generated (ALL

Commodities Recycled

+ Disposed)

Annual Generation in Tons

(Recycled Plus Disposed) from percent of Total on

WS1

Potential Annual

Revenue

Tipping Fee

Per Ton

Potential

Landfill Cost

Avoidance

Contract Costs per Ton

Contract Cost

Avoidance

Total Cost Avoidance

(Contractor Costs Plus

Tipping Fees)

Aerosol Cans (empty) 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Aluminum 23.31 $7,459.20 $500.00 2,157 26.51 $13,253.02 $23.50 $622.89 $199.35 $5,283.94 $5,906.83

Aluminum Cans 0.81 $649.35 $833.33 2,157 10.40 $8,665.10 $23.50 $244.36 $199.35 $2,072.85 $2,317.21

Antifreeze 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Bimetal Cans 0.00 $0.00 $36.67 2,157 15.98 $585.94 $23.50 $375.53 $199.35 $3,185.63 $3,561.16

Brass 14.64 $41,244.00 $2,433.33 2,157 27.42 $66,732.12 $23.50 $644.47 $199.35 $5,466.97 $6,111.43

Cardboard 189.99 $8,411.34 $94.00 2,157 380.15 $35,734.51 $23.50 $8,933.63 $199.35 $75,783.21 $84,716.84

Cell Phones 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Clear Glass 0.00 $0.00 $0.00 2,157 70.31 $0.00 $23.50 $1,652.35 $199.35 $14,016.77 $15,669.12

Colored Glass 0.00 $0.00 $0.00 2,157 70.31 $0.00 $23.50 $1,652.35 $199.35 $14,016.77 $15,669.12

Cooking Grease 0.00 $0.00 $78.81 2,157 12.78 $1,007.52 $23.50 $300.43 $199.35 $2,548.50 $2,848.93

Copper 2.35 $7,057.50 $3,353.33 2,157 5.55 $18,597.72 $23.50 $130.33 $199.35 $1,105.59 $1,235.93

Electronics 3.62 $0.00 $0.00 2,157 24.39 $0.00 $23.50 $573.27 $199.35 $4,862.96 $5,436.22

Equipment 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Expended Brass 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Fabric/Textiles/Rags 0.00 $0.00 $0.00 2,157 7.99 $0.00 $23.50 $187.77 $199.35 $1,592.81 $1,780.58

Film Plastic 0.00 $0.00 $96.67 2,157 19.18 $1,853.70 $23.50 $450.64 $199.35 $3,822.75 $4,273.40

HDPE #2 Bottles 0.00 $0.00 $370.00 2,157 4.79 $1,773.80 $23.50 $112.66 $199.35 $955.69 $1,068.35

Hi-Temp Alloys 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Lead-Acid Batteries 29.72 $12,769.31 $421.64 2,157 45.70 $19,268.88 $23.50 $1,073.95 $199.35 $9,110.27 $10,184.22

Machine Parts 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Magazines 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Misc. Batteries 0.00 $0.00 -$3,000.00 2,157 1.60 -$4,794.06 $23.50 $37.55 $199.35 $318.56 $356.12

Mixed Paper 41.79 $5,085.90 $40.00 2,157 164.84 $6,593.50 $23.50 $3,873.68 $199.35 $32,860.12 $36,733.80

Mixed Recyclables 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00 Newspaper 0.00 $0.00 $35.00 2,157 55.93 $1,957.57 $23.50 $1,314.37 $199.35 $11,149.70 $12,464.07 Other (Food) 38.54 $0.00 -$23.50 2,157 241.49 -$5,674.98 $23.50 $5,674.98 $199.35 $48,140.38 $53,815.36 Other (Glass) 0.00 $0.00 $0.00 2,157 70.31 $0.00 $23.50 $1,652.35 $199.35 $14,016.77 $15,669.12 Other (Metals) 96.48 $4,434.40 $66.67 2,157 101.27 $6,751.60 $23.50 $2,379.94 $199.35 $20,188.83 $22,568.77 Other (Non-Food) 44.14 $0.00 $0.00 2,157 226.31 $0.00 $23.50 $5,318.39 $199.35 $45,115.41 $50,433.80 Other (Paper) 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00 Other (Plastic) 1.76 $0.00 $20.00 2,157 25.73 $514.61 $23.50 $604.66 $199.35 $5,129.30 $5,733.96

Other (Textiles) 0.00 $0.00 $0.00 2,157 7.99 $0.00 $23.50 $187.77 $199.35 $1,592.81 $1,780.58

Other (Wood) 0.00 $0.00 $0.00 2,157 35.16 $0.00 $23.50 $826.18 $199.35 $7,008.38 $7,834.56

Paint 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Pallets, Scrap 0.00 $0.00 $98.31 2,157 68.71 $6,755.01 $23.50 $1,614.80 $199.35 $13,698.20 $15,313.00

PETE #1 2.00 $0.00 $52.50 2,157 19.58 $1,027.86 $23.50 $460.09 $199.35 $3,902.89 $4,362.98

Plastics Nos. 3-7 0.00 $0.00 -$35.00 2,157 12.78 -$447.45 $23.50 $300.43 $199.35 $2,548.50 $2,848.93

Precious Metals 0.00 $0.00 $0.00 2,157 1.60 $0.00 $23.50 $37.55 $199.35 $318.56 $356.12

Rags (Non-Hazardous) 0.00 $0.00 -$4,600.00 2,157 7.99 -$36,754.46 $23.50 $187.77 $199.35 $1,592.81 $1,780.58

Range Residue (Other) 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Rubber 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Sandblast Residue 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Shredded Paper 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Steel (Stainless) 8.29 $3,647.60 $240.00 2,157 69.01 $16,563.54 $23.50 $1,621.85 $199.35 $13,757.99 $15,379.84

Target Metals Gleaned 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Timber/Wood Waste 0.00 $0.00 $0.00 2,157 105.47 $0.00 $23.50 $2,478.53 $199.35 $21,025.15 $23,503.68

Tin 0.00 $0.00 $70.00 2,157 30.36 $2,125.37 $23.50 $713.52 $199.35 $6,052.70 $6,766.21

Tires 18.62 $0.00 $0.00 2,157 60.17 $0.00 $23.50 $1,413.96 $199.35 $11,994.50 $13,408.46

Toner/Ink Jet Cartridges 3.00 $2,286.00 $460.79 2,157 31.76 $14,636.70 $23.50 $746.46 $199.35 $6,332.18 $7,078.64

Used Fuel (JP-8, Diesel) 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Used Hydraulic Fluid 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Used Motor Oil 38.39 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Used Solvent 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Used Vehicles 0.00 $0.00 $40.00 2,157 31.96 $1,278.42 $0.00 $0.00 $199.35 $6,371.26 $6,371.26

White Goods/ Appliances 1.24 $0.00 $80.00 2,157 25.21 $2,016.82 $23.50 $592.44 $199.35 $5,025.64 $5,618.08

White Paper (High Grade) 0.00 $0.00 $0.00 2,157 0.00 $0.00 $23.50 $0.00 $199.35 $0.00 $0.00

Wire, metal 0.00 $0.00 $460.00 2,157 1.60 $735.09 $23.50 $37.55 $199.35 $318.56 $356.12

558.69 $93,044.60 2,118.32 $180,757.47 $49,029.45 $422,283.93 $471,313.38

DO NOT MODIFY THIS WORKSHEET. Click "Unprotect Sheet" under the "Review" tab. Copy and paste into Appendix B of the ISWMP. Lock the sheet back down by going to the "Review" tab

Feaasibility Analysis

FEASIBILITY

ANALYSIS

2. Sort by

Column H using the filter arrow.

3. It is recommended to protect this sheet again once sorted.

4. Provide comments and analysis in the Analysis column, which may be changed/updated and saved, even with the locked worksheet.

Commodity

Annual

Generation

(Potential

Diversion in

Tons)

Amount

Recycled in 2017

(tons)

Potential

Annual

Proceeds

Potential

Annual Cost

Avoidance

(Tipping

Fees)

Total Potential

Annual Benefit

(Proceeds +

Tipping Fees)

Potential

Annual Cost

Avoidance

(Contracted

Disposal Costs)

Commodity

Score

ANALYSIS

Cardboard 380.15 189.99 $35,734.51 $8,933.63 $44,668.14 $75,783.21 11

Cardboard should continue to be recycled as it is legally required, the diversion rate is enhanced by the great amount of cardboard generated and diverted, and the market is usually excellent. Additional awareness might increase diversion and proceeds for cardboard, although Holloman AFB recycles nearly 85% of all cardboard when DeCA cardboard is considered in the total (380 tons is the estimated total, minus 190 tons recycled by the

QRP in 2017, minus the DeCA total of 132 tons equals 58 tons available for recycling based on estimated quantities of cardboard generated at the base).

Brass 27.42 14.64 $66,732.12 $644.47 $67,376.59 $5,466.97 9

Brass is only feasibly recyclable through DLADS, although proceeds have been a small fraction of the estimated amount due to the inoperable DLADS system. Once DLADS' system is operational, the QRP Manager should ensure that all DD Forms 1348-1A include the proper F3875 QRP account number to ensure proper transfer of proceeds from metal recycling. The base also might consider working with Fort Bliss to recycle their expended brass shell casings to increase QRP proceeds.

Mixed Paper 164.84 41.79 $6,593.50 $3,873.68 $10,467.18 $32,860.12 9 Mixed paper should continue to be recycled as the office paper portion is legally required. Additional awareness might gain more non-office paper, although proceeds from that commodity are commonly less than from sorted office paper. Awareness might increase proceeds as the generation estimation is approximately four times the amount recycled in 2016.

Lead-Acid Batteries 45.70 29.72 $19,268.88 $1,073.95 $20,342.83 $9,110.27 8 Lead-acid batteries should continue to be recycled, as the tipping fees and disposal costs reflected by SW disposal information is lower than the cost to dispose of this commodity as a hazardous waste, which is how it must be disposed if not recycled.

Other (Food) 241.49 38.54 -$5,674.98 $5,674.98 $0.00 $48,140.38 8 Food, as diverted through donation by DeCA, should continue to be donated. This diversion requires no additional equipment and very little labor.

Use of the DeCA database to gather information for the diversion metric should continue. Composting of food is not economic for the base, although in the future, use of an in-vessel food composting system at dining establishments might be considered.

Other Non-Food 226.31 44.14 $0.00 $5,318.39 $5,318.39 $45,115.41 8 Enhanced recycling of other non-food items requires more in-depth study by the Recycling Center and QRP Manager, as well as waste stream analysis.

Cooking Grease 12.78 0.00 $1,007.52 $300.43 $1,307.95 $2,548.50 7 Due to the uncertainty of the use for cooking grease, the base might determine what its grease is used for before taking credit for recycled grease in its diversion metric. The base may want to consider collecting cooking grease diversion data for future considerations of diversion methods.

Electronics 24.39 3.62 $0.00 $573.27 $573.27 $4,862.96 7

Although the annual generation potential is high, only a portion of electronics generated by the base is eligible for the QRP. Holloman AFB might consider entering into an agreement with DLADS to recycle only non-data containing electronics through the QRP if an economic source for recycling those materials can be found. Additionally once the DLADS system is operational again, the base should ensure to capture the diversion rate for electronics recycling from DLADS.

Fabric/Textiles/Rags 7.99 0.00 $0.00 $187.77 $187.77 $1,592.81 7 The base might coordinate with Airman's Attic on base to ensure their diverted fabric/textile/rag items are included in the diversion metrics.

Additionally, work with Airman's Attic to establish a relationship with Goodwill Industries for their excess fabric, textile, and other items that do not sell. Other bases provide that excess material to Goodwill instead of disposing of it. Goodwill has markets for unusable fabrics and other items.

Other Textiles 7.99 0.00 $0.00 $187.77 $187.77 $1,592.81 7 Other textiles can include a variety of items. The base might coordinate with Airman's Attic to ensure their items are included in the diversion metrics.

Pallets Scrap 68.71 0.00 $6,755.01 $1,614.80 $8,369.81 $13,698.20 7 Scrap pallet prices very greatly, and the benefit is seen from disposal avoidance costs. Holloman AFB currently reuses numerous scrap pallets. The base might consider reviewing conditions under which scrap pallets may be sold to national buyers who pick up slightly damaged pallets that DLADS does not want. Additionally, once DLADS system is functional, pallet diversion data should be collected for the data call..

Shredded Paper 0.00 0.00 $0.00 $0.00 $0.00 $0.00 7 Shredded paper is included with mixed paper in this analysis, as there is no information on the percentage of shredded paper generated or disposed

of. The base does recycle shredded paper.

Tires 60.17 18.62 $0.00 $1,413.96 $1,413.96 $11,994.50 7 Tires are recycled through DLADS via the transportation office. The base should ensure captures tire weights are captured in the diversion metric as appropriate once the DLADS system is functional again.

Toner Cartridges 31.76 3.00 $14,636.70 $746.46 $15,383.16 $6,332.18 7 The base currently recycles toner cartridges in an economic manner, although the estimated generation rate shows that only a small percentage of the amount generated is diverted. The base might want to consider if this generation rate is correct for Holloman AFB and if so, develop an enhanced awareness program for ink and toner cartridge recycling.

Used Vehicles 31.96 0.00 $1,278.42 $0.00 $1,278.42 $6,371.26 7 Used vehicles are sold through DLADS via the Logistics Readiness Squadron. The base should ensure that diversion is recorded by DLADS and funding is placed into the QRP account properly when the DLADS system is again operational.

White Paper (Hi-Grade) 0.00 0.00 $0.00 $0.00 $0.00 $0.00 7 White paper is included with mixed paper, as information on percentage of paper generated or disposed of is not refined to the level of types of paper.

Copper 5.55 2.35 $18,597.72 $130.33 $18,728.05 $1,105.59 6 The base might consider diverting metal that goes to DLADS from C&D activities through the QRP instead. Additionally, a local metals buyer is willing to work with Holloman AFB to place containers on base or use Holloman AFB's containers to pick up metals and send proceeds to the QRP. The base might want to consider contacting the local buyer to increase QRP proceeds and diversion rates for many metals.

Machine Parts 0.00 0.00 $0.00 $0.00 $0.00 $0.00 6 No information is available on the percent of machine parts generated or placed in solid waste stream. However, machine parts that are no longer usable may be recycled with mixed metals.

Range Residue 0.00 0.00 $0.00 $0.00 $0.00 $0.00 6 Consider working with the Installation Restoration Program Manager to recycle lead from range cleanup activities through the QRP.

White Goods/Appliances 25.21 1.24 $2,016.82 $592.44 $2,609.27 $5,025.64 6 Discussions with Unaccompanied Airmen Housing might provide diversion metrics for White Goods and Appliances. Additionally, the base might consider working with a buyer/broker to set up bins on the base for mixed metals, into which appliances may be place.

Aluminum 26.51 23.31 $13,253.02 $622.89 $13,875.91 $5,283.94 5 The base might consider diverting metal that goes to DLADS from C&D activities through the QRP instead. Additionally, a local metals buyer is willing to work with Holloman AFB to place containers on base or use Holloman AFB's containers to pick up metals and send proceeds to the QRP. The base might want to consider contacting the local buyer to increase QRP proceeds and diversion rates for many metals.

Aluminum Cans 10.40 0.81 $8,665.10 $244.36 $8,909.46 $2,072.85 5 A local metals buyer is willing to work with Holloman AFB to place containers on base or use Holloman AFB's containers to pick up metals and send proceeds to the QRP. The base might want to consider contacting the local buyer to increase QRP proceeds and diversion rates for many metals.

Antifreeze 0.00 0.00 $0.00 $0.00 $0.00 $0.00 5 No information available on the percent of antifreeze generated or placed in solid waste stream.

Equipment 0.00 0.00 $0.00 $0.00 $0.00 $0.00 5 No information available on the percent of the general category, "equipment" generated or placed in solid waste stream.

Hi-Temp Alloys 0.00 0.00 $0.00 $0.00 $0.00 $0.00 5 No information available on the percent of hi-temp alloys generated or placed in solid waste stream.

Newspaper 55.93 0.00 $1,957.57 $1,314.37 $3,271.95 $11,149.70 5 Newspaper is included with other paper. This method may be best, as generation of newspaper continues to decrease due to online sources of information and the low potential proceeds for newspaper as a recycling commodity.

Other Metals 101.27 96.48 $6,751.60 $2,379.94 $9,131.54 $20,188.83 5 The base might consider diverting metal that goes to DLADS from C&D activities through the QRP instead. Additionally, a local metals buyer is willing to work with Holloman AFB to place containers on base or use Holloman AFB's containers to pick up metals and send proceeds to the QRP. The base might want to consider contacting the local buyer to increase QRP proceeds and diversion rates for many metals.

Paint 0.00 0.00 $0.00 $0.00 $0.00 $0.00 5 Paint is difficult to recycle at any location and typically costs to recycle. Holloman AFB does recycle some paint for paintball activities.

Stainless Steel 69.01 8.29 $16,563.54 $1,621.85 $18,185.39 $13,757.99 5 The base might consider diverting metal that goes to DLADS from C&D activities through the QRP instead. Additionally, a local metals buyer is willing to work with Holloman AFB to place containers on base or use Holloman AFB's containers to pick up metals and send proceeds to the QRP. The base might want to consider contacting the local buyer to increase QRP proceeds and diversion rates for many metals.

Target Metals Gleaned 0.00 0.00 $0.00 $0.00 $0.00 $0.00 5 The base may want to ensure data and proceeds are captured once the DLADS system is operational, as the firing range does capture and recycle gleaned target metals.

Tin 30.36 0.00 $2,125.37 $713.52 $2,838.88 $6,052.70 5 The base might consider diverting metal that goes to DLADS from C&D activities through the QRP instead. Additionally, a local metals buyer is willing to work with Holloman AFB to place containers on base or use Holloman AFB's containers to pick up metals and send proceeds to the QRP. The base might want to consider contacting the local buyer to increase QRP proceeds and diversion rates for many metals.

Used Hydraulic Fluid 0.00 0.00 $0.00 $0.00 $0.00 $0.00 5 No information is available on the percent of the amount of used hydraulic fluid generated or disposed of in the solid waste stream.

Used Motor Oil 0.00 38.39 $0.00 $0.00 $0.00 $0.00 5 No information is available on the percent of the amount of used motor oil generated or disposed of in the solid waste stream.

Used Solvent 0.00 0.00 $0.00 $0.00 $0.00 $0.00 5 No information is available on the percent of the amount of used solvent generated or disposed of in the solid waste stream.

Wire, Metal 1.60 0.00 $735.09 $37.55 $772.64 $318.56 5 The base might consider diverting metal that goes to DLADS from C&D activities through the QRP instead. Additionally, a local metals buyer is willing to work with Holloman AFB to place containers on base or use Holloman AFB's containers to pick up metals and send proceeds to the QRP. The base might want to consider contacting the local buyer to increase QRP proceeds and diversion rates for many metals.

Aerosol Cans (empty) 0.00 0.00 $0.00 $0.00 $0.00 $0.00 4 Aerosol cans are recycled through DLADS after puncturing. The base might consider capturing weights of aerosol cans sent to DLADS from the hazardous waste dispositioning function for inclusion into the diversion metric.

Bimetal Cans 15.98 0.00 $585.94 $375.53 $961.48 $3,185.63 4 Bimetal cans are not currently economically feasible to recycle, and must be rinsed before recycling, which requires contract modifications.

Misc. Batteries 1.60 0.00 -$4,794.06 $37.55 -$4,756.51 $318.56 4 The commonly used recycler for other batteries, Call2Recycle, will begin charging for battery recycling soon; thus the Air Force may need to research another source for other battery recycling. Currently available battery recyclers charge to recycle.

Plastics No. 3-7 12.78 0.00 -$447.45 $300.43 -$147.02 $2,548.50 4 The QRP Program might consider a conversation with the buyer/broker who recycles plastics for DeCA and/or AAFES. Additionally, the QRP Program should continue to monitor petroleum prices for possible increases in plastic recyclable markets.

Other Wood 35.16 0.00 $0.00 $826.18 $826.18 $7,008.38 3 No proceeds are associated with wood waste, and wood waste is not currently economically feasible to recycle.

Timber/Wood Waste 105.47 0.00 $0.00 $2,478.53 $2,478.53 $21,025.15 3 No proceeds are associated with wood waste, and wood waste is not currently economically feasible to recycle.

Magazines 0.00 0.00 $0.00 $0.00 $0.00 $0.00 3 No information exists on the percentage of magazines generated or disposed of, as magazines are combined with other mixed paper when collected for recycling.

Precious Metals 1.60 0.00 $0.00 $37.55 $37.55 $318.56 3 Precious metals are not QRP eligible for the QRP program or diversion metric, although a generation…