Question
Instructions Using the information in tables 1 & 2 and the Project: Energy Yearly Projections Using Electricity, Coal, and Oil Data Set spreadsheet answer questions
Instructions
Using the information in tables 1 & 2 and the Project: Energy Yearly Projections Using Electricity, Coal, and Oil Data Set spreadsheet answer questions 1 - 7. You will submit the finished spreadsheet as the project in Canvas.
You can locate the Project: Energy Yearly Projections Using Electricity, Coal, and Oil Data Set spreadsheet under the Project: Energy Yearly Projections Using Electricity, Coal, and Oil Resources section.
Table 1:
Appliance | Central Air Conditioner | Water Heater | Clothes Dryer | oven | Dishwasher | Fridge | Ceiling Fan | LCD TV |
watts | 3800 | 4500 | 3000 | 1200 | 1500 | 1400 | 120 | 150 |
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 | 8 | 3 | 2.5 | 2 | 1.5 | 24 | 6 | 6 |
Add columns to the Project Data spreadsheet that show the following for each appliance (where applicable round to at least two decimal places):
- 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, calculate 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.14 per kWh, find the electricity cost of running each appliance for the entire year.
- According to the US Energy Information Administration, it requires 0.00057 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.
- Note: A direct link to this data is located under the Project: Energy Yearly Projections Using Electricity, Coal, and Oil Resources section entitled How Much Coal, Natural Gas, or Petroleum is Used to Generate a Kilowatt-Hour of Electricity?
- 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started