Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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):

  1. The number of kilowatts of power required by each of these appliances (1 kilowatt = 1000 watts).
  2. 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.
  3. The number of kilowatt-hours used by each appliance in the entire YEAR.
  4. Assuming that electricity costs $0.14 per kWh, find the electricity cost of running each appliance for the entire year.
  5. 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.
    1. 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?
  6. 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.
  7. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems The Processes and Controls

Authors: Leslie Turner, Andrea Weickgenannt

2nd edition

9781118473030, 1118162307, 1118473035, 978-1118162309

More Books

Students also viewed these Physics questions

Question

c. Are there any prerequisites for the course?

Answered: 1 week ago

Question

Describe the organization of a flat file database.

Answered: 1 week ago