 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
• 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