2. Every time a machine breaks down at the Savannah Manufacturing Co. either 1, 2, or 3 hours is required to fix it, according to the following probability distribution:
Repair Time (Hours) Probability
a. Simulate the machine breakdowns repair time for 20 weeks.
b. Compute the average repair time per week.
c. If it cost $50 per hour to repair a machine when it breaks, determine the average weekly breakdown cost.
Excel file contains simulation of the machine breakdowns repair time for 20 week calculation of average repair time per week and average weekly breakdown cost.