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