Reference no: EM132152530

The Knapp Manufacturing Company employs a maintenance crew to repair its machines as needed. Management now wants a computer simulation study done to analyze what the size of the crew should be, where the crew sizes under consideration are two, three and four. The time required by the crew to repair a machine has a uniform distribution over the interval from zero to twice the mean, where the mean depends on the crew size. The mean is four hours with two crew members, three hours with three crew members, and two hours with four crew members. The time between breakdowns of some machine has an exponential distribution with a mean of five hours. When a machine breaks down and so requires repair, management wants its average waiting time before repair begins to be no more than three hours. Management also wants the crew size to be no larger than necessary to achieve this. Formulate a spreadsheet model to perform a computer simulation to estimate the average waiting time before repair begins. Perform this simulation over a period of 100 breakdowns for each of the three crew sizes under consideration. What do these results suggest the crew size should be? SHOW ALL WORK.