# PROJECT 2

**Project 2 Instructions**

**Please also pay close attention to any additional specifications provided by your professor. Professors often will clarify their expectations regarding the format and presentation of your submission. **

Ever wonder how your electricity bill is computed? The following table gives the watts of power that are typically required by several major (and not so major) appliances. (Source: http://www.wholesalesolar.com/solar-information/how-to-save-energy/power-table, with some numbers rounded off for computational convenience.)

Table 1:

Appliance |
Central Air Conditioner | Water Heater | Clothes Dryer | Oven | Dishwasher | Fridge | Ceiling Fan | LCD TV |

Watts |
9000 | 5000 | 4500 | 4000 | 2400 | 2200 | 220 | 250 |

Assume that the number of hours that the aforementioned appliances run during an average day is given in the table below:

Table 2:

Appliance |
Central Air Conditioner | Water Heater | Clothes Dryer | Oven | Dishwasher | Fridge | Ceiling Fan | LCD TV |

Hours |
5 | 3 | 3.5 | 2 | 2.5 | 8 | 13 | 6 |

Add columns to the Project 2 Data spreadsheet that show the following for each appliance:

- The number of kilowatts of power required by each of these appliances (1 kilowatt = 1000 watts).
- If the appliance runs the number of hours specified in Table 2, compute the kilowatt-hours (kWh) of energy that each appliance consumes during an average day. Note: kWh are found by multiplying the power of an appliance by the number of hours that it is in use.
- The number of kilowatt-hours used by each appliance in the entire YEAR.
- Assuming that electricity costs $0.13 per kWh, find the electricity cost of running each appliance for the entire year.
- According to the US Energy Information Administration (see “How much coal, natural gas or petroleum is used to generate a kilowatt-hour of electricity” on https://www.eia.gov/tools/faqs/), it requires 0.00052 tons of coal to generate 1 kWh of electricity. Use this conversion to find how much coal would be required to run each of these appliances for a year.
- The same source also states that 0.00173 barrels of oil will generate 1 kWh of electricity. Like question 5, find how much oil each appliance would consume on an annual basis.
- Add a “Total” row to the spreadsheet that shows how much electricity is consumed by all 8 appliances combined in the course of a day and of a year. Also, find the cost, the amount of coal that would be required, and the barrels of oil that would be required in order to run all 8 appliances for a year.

Submit Project 2 by 11:59 p.m. (ET) on Monday of Module/Week 7.