VTEPS, Inc. has to replace a production line motor that must be able to produce 100 hp output. Below are the options: Alpha Beta Gamma 10000 Purchase Price 15000 20000 500 250 Annual Maintenance 800 86% 92% Efficiency 7496 Recreate the following chart and graph in Excel to help determine which motor to choose, which will be based on the number of hours used per year: Motors Example (3 Different options) SkWh Electricity Cost ($/kWh) 0.05 10 Mrs Unit Conversion Useful Life (years) 100 hp 0.746 kw/hp Motor hp required Alpha Beta Gamma 10000 15000 20000 Purchase Price Annual Maintenance 800 500 250 Efficiency 86% 925 Annual Cost of Purchase Annual Maintenance Sub-total Energy Expense ($/hr) Alpha-Beta Hours Alpha Beta Diff Breakeven Hours Alpha Gamma Diff Alpha-Gamma Breakeven Pt Beta-Gamma Hours Beta Gamma Diff Break even Pt Hours Alpha Beta Gamma 500 1000 1500 2000 2500 30000 3500 4000 50000 5500 6000 6500 VTEPS, Inc. has to replace a production line motor that must be able to produce 100 hp output. Below are the options: Alpha Beta Gamma 10000 Purchase Price 15000 20000 500 250 Annual Maintenance 800 86% 92% Efficiency 7496 Recreate the following chart and graph in Excel to help determine which motor to choose, which will be based on the number of hours used per year: Motors Example (3 Different options) SkWh Electricity Cost ($/kWh) 0.05 10 Mrs Unit Conversion Useful Life (years) 100 hp 0.746 kw/hp Motor hp required Alpha Beta Gamma 10000 15000 20000 Purchase Price Annual Maintenance 800 500 250 Efficiency 86% 925 Annual Cost of Purchase Annual Maintenance Sub-total Energy Expense ($/hr) Alpha-Beta Hours Alpha Beta Diff Breakeven Hours Alpha Gamma Diff Alpha-Gamma Breakeven Pt Beta-Gamma Hours Beta Gamma Diff Break even Pt Hours Alpha Beta Gamma 500 1000 1500 2000 2500 30000 3500 4000 50000 5500 6000 6500