use Excel

(2) The initial investment in an industrial robot is $100,000. The robot will replace three operators in each shift. Knowing that the factory runs three shifts per day and 5 days per week, evaluate the return on investment (ROI) in weeks, considering the following: One hour for lunch 15 holidays per year 15 vacation days per year Two 15 minutes coffee breaks per day 10 sick days per year The robot is down 10% of the time. Plot the ROI vs. coffee breaks - use two 10, 15, 20, and 25 minutes. Each operator earns $35,000 plus 30% fringe benefits. Consider 10% robots down time. (2) The initial investment in an industrial robot is $100,000. The robot will replace three operators in each shift. Knowing that the factory runs three shifts per day and 5 days per week, evaluate the return on investment (ROI) in weeks, considering the following: One hour for lunch 15 holidays per year 15 vacation days per year Two 15 minutes coffee breaks per day 10 sick days per year The robot is down 10% of the time. Plot the ROI vs. coffee breaks - use two 10, 15, 20, and 25 minutes. Each operator earns $35,000 plus 30% fringe benefits. Consider 10% robots down time