The Prograssive Manufacturing Company has 20 machines that are basically the same and that they work 8 hours a day. These machines are break down from time to time despite the preventive practices of maintenance of the company. There are 4 mechanics who work 8 hours. The machines are of such a nature that only a mechanic can work effectively at every time. Sometimes more than four machines, while at other times the mechanics are idle. Much more often 2 or 3 men are unemployed. The management does not think it necessary to retain the four mechanics. The data compiled by the IO analyst, indicate that there is a one in ten chance of for a machine to break down at any given hour. A study of the Necessary repairs reveals the following probability distribution.

The cost of idle time of the machines is $ 8.00 per hour for the company, while the hourly wage of mechanics, which includes benefits
marginal is $ 4.00 per hour. Allow yourself a tolerance of 10 minutes per hour as personal time of each mechanic. Create a spreadsheet simulation that simulates 80 hours of work and that show the percentage utilization of mechanics,