Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

Can anyone show me how to write the following conversions into a excel soreadsheet Math Explanation: WASHING MACHINE Savings per hour= (3000 W *...

  • Can anyone show me how to write the following conversions into a excel soreadsheet
  • Math
  • Explanation:
  • WASHING MACHINE
  • Savings per hour=> (3000 W * $0.09 )- (1500 W * $0.09) =$135 per hour
  • savings per day= $135 since a washing machine is used once per day
  • REFRIGERATOR
  • Savings per day=> (100 W * $0.09 )- (75 W * $0.09) =$2.25 per day
  • DISH WASHER
  • Savings per hour=> (1500 W * $0.09 )- (1200 W * $0.09) =$27per hour
  • savings per day= $27*3= $54 since a dish washer is used thrice per day
  • savings per year= 365 days(135+2.25+54)=$69,806.25
  •  Comment   Unhelpful  Flag Answer
  • Annual Total savings=22666.5 cents-14782.5 cents=7884 cents
  • Annual amount of KWh saved=7884/9=876 KWh
  • Explanation:
  • Keep in mind:1 KW=1000W and 1KWh=9 cents
  • Electrical energy used=Power(KW)*Time(hours)
  • Non-energy efficient
  • Washing machine=3000W/1000*1h=3 KWh>>Cost=3*9=27 cents
  • Refrigerator=100/1000*24=2.4 KWh>>Cost=2.4*9=21.6 cents
  • Dishwasher=1500/1000*1=1.5 KWh>>Cost=1.5*9=13.5 cents
  • Total money spent in a day=27+21.6+13.5=62.1 cents
  • Total money spent in a year=62.1*365=22666.5 cents
  • Energy efficient
  • Washing machine=1500W/1000*1h=1.5 kWh>>Cost=1.5*9=13.5 cents
  • Refrigerator=75/1000*24=1.8 KWh>>Cost=2.4*9=16.2 cents
  • Dishwasher=1200/1000*1=1.2 KWh>>Cost=1.2*9=10.8 cents
  • Total money spent in a day=13.5+16.2+10.8=40.5 cents
  • Total money spent in a year=40.5*365=14782.5 cents
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question