(WARM) Assignment:

(WARM) Assignment:
Use subject line: lastname firstname WARM
Save your file as: lastname firstname WARM.xls
In this assignment you will evaluate the CO2 equivalent emissions and energy use/production from your personal waste generation. You will learn about the scope, capabilty, and uncertainty of models. You will learn about the different impacts from various waste handling scenarios. And you will practice good graphing skills.

Your final homework should be turned in as an excel spreadsheet. You should have two separate worksheets. The first will be your ‘Raw’ data from your week of collecting all of your trash, recycling, etc. The second worksheet should have the WARM output data (which you will copy and paste from WARM), one CO2 graph, one energy graph, and one text box describing your findings.

Week prior to due date: Record your waste (trash, recycle, etc) for one week & enter data into excel
You should have kept a log of your personal waste generation for the past week. An excel spreadsheet with example weights of organic waste is available on Blackboard to aid in estimating your food and organic waste. If the exact trash is not available, you should estimate the weight and type of your trash using the example materials provided in class.

You should use WARM to model your current waste scenario (collect both CO2 emissions and energy). WARM is typically used by cities or large organizations; you should assum that you are the average citizen in Phoenix and scale your data up to an annual waste generation for the population of Phoenix. You should also evaluate ONE way to improve your waste footprint and create that scenario in WARM. Your final graphs will be bar graphs comparing the your current versus your idea for improvement.

You should use a text box in excel to write two paragraphs summarizing your findings from the WARM model. Your writeup should describe (paragraph 1) why emissions or energy is negative, and comment on the accuracy of the tools and/or your estimates. (e.g. what might be your largest source of error?) Paragraph two should discuss the findings from your improvement scenario. Were the emissions and energy actually better than your current waste? Don’t forget to refer to the principles of ESEM in either of these paragraphs and bold and italicize the sentence that reflects an ESEM principle and identify the ESEM principle number.

Download & Use WARM for this assignment:
• WARM Calculates CO2 equivalent emissions and BTUs for municipal waste scenarios
• Inputs are in tons and output is in MTCO2E and million BTU (you will have to do unit conversions!
• WARM models large scale local waste system (i.e. for a city)
• Download the xls: http://epa.gov/epawaste/conserve/tools/warm/index.html

Use the following inputs to the WARM.xls:
#3 Arizona
#4 Current Mix
#5 a. LFG Recovery b. Flare
#6 a. Dry b. Typical operation
#7 a. Provide Information
#8b. 45, 20, 41, 35

Because of the scale of the WARM model, you will need to increase your weekly waste consumption to the population of Phoenix for one year.

100% of your grade will be allocated to the WARM rubric, below.

WARM Rubric

Points Possible Points Earned
Data & GRAPHs:
Raw data reflects weekly trash collection for a person. Weights of trash estimated in xls. Amounts of waste scaled up to one year and Phx population. (1 pt ea) 3
Two graphs comparing two different waste management scenarios: current scenario and one example improvement. (2 pts each) 4
Graph aesthetics: Graph is properly labeled on both axes, has a title, proper units. (1 pt each) 4
Graph aesthetics: Graph is easy to read, maximizes real estate. 1
2-Paragraph Summary:
Paragraph 1 Describes any negative emissions/energy numbers. 1
Paragraph 1 Discusses major sources of error that might influence model results. 1
Bold & italicized at least one relevant ESEM principle 1
Paragraph 2 Describes improvement scenario shown in the graphs. Addresses whether the CO2 & energy results actually improved. Describes rationale for why CO2 & energy changed from ‘current’ scenario. (1 pt ea) 3
Writing is professional, well written, free of grammatical mistakes and typos. 3
# Name mass unit Disposal consumption rate unit recycled?
1 yogurt cup 30 mg
2 yogurt box g
3 subway cup g
4 cereal box g
5 plastic ware g
6 Soda can 46 g
7 Toilet paper roll
8 Brownie 38 g
9 Yogurt cup
10 Rice and brocolli
11 Burrito
12 Toothpaste
13 Toilet paper
14 subway wrapper
15 subway bag
16 1 sq ft aluminum foil 0.5 mg
2/20/2015 17 paper cup 14 mg
18 2 tbsp tea leaves 6 g
19 Paper plate 2 g
20 Tuna container X2 16 g
21 Nestle water bottle 28 g
22 Nestle water bottle 28 g
23 Two boxes 2000 g
24 Napkin 6 g
25 Receipt 1 g
26 Receipt 1 g
27 Paper plate 2 g
28 Plastic bag 2 g
29 Plastic bag 2 g
30 Plastic bag 2 g
31 Gum Wrapper 1 g
32 Paper plate 2 g
33 Red Solo Cup 14 g
34 Milk Carton 25 g
35 Granola Bar Wraper 2 g
36 Waffle Plastic Wrapper 3 g
37 Frozen Berries Bag 15 g
38 Tuna container X2 16 g
39 Roses Sheath 4 g
40 Paper plate 2 g
41 Water Bottle X2 28 g
42 Fork 4 g
43 Raffle ticket X2 1 g
44 Red Solo Cup 14 g
45 Aluminum Can X6 78 g
46 Paper Box (Red Bull) 60 g
47 Red Bull Can X2 20 g
48 Water Bottle X2 56 g
49 Jimmy Johns Packaging 16 g
50 Chips Bag 2 g
51 Einstein’s OJ Cup 14 g
52 Plastic Wrapping 2 g
53 Tabacco Can 15 g
54 Aluminum Can X6 78 g
55 Beer Bottle X2 1000 g
56 In-N-Out Burger 30 g
57 In-N-Out Burger 12 g
58 McDonalds 15 g
59 McDonalds 14 g
60 McDonalds 14 g
61 Prescription bag 3 g
62 Tuna container X2 16 g
63 Mac-N-Cheese 2 g
64 Mac-N-Cheese 14 g
65 Mac-N-Cheese 35 g
66 Paper Plate 2 g
67 Coffee Grounds 25 g
68 Coffee Grounds 25 g
69 Paper Plate 2 g
70 Paper towels 150 g
71 Toilet paper 412 g
72 Granola Bar Wraper 2 g
73 Starbucks Cup 15 g
74 Other coffee cup 12 g
75 Egg carton 50 g
76 Egg shell 5 g
77 12 oz glass bottle 192 g
78 750 ml glass pottle 225 g
79 Packing plastic (g/sq ft) 8.9 g
80 Pear core 75 g
81 Banana peel 50 g
82 Bicycle inner tube 400 g
83 100 oz detergent bottle 350 g
84 8.5×11 paper 4.5 g
85 Starbucks double shot can 14 g
86 jimmy johns wrapper 7 g
87 styrofoam food container 65 g
88 Plastic cup (32 oz) 31 g
89 paper towels (1 sheet) 7 g
90 napkins (1 sheet) 4 g
91 straw 4 g
92 apple core 31 g
93 food paper bag 7 g
94 burrito wrapper 5 g
95 24 oz water bottle 11 g
96 0.25 foot long subway sandwich 12g g
97 1 gal plastic container 55 g
98 1 gal detergent container 56 g
99 tin can medium sized (baked beans) 64 g
100 beer bottle 231 g
101 wine bottle with foil and cork 411 g

find the cost of your paper