The MM1 Template.xlsx file is now set up so that when you enter any time value in cell H11, the formula in cell I11 gives the probability that the wait in queue will be greater than this amount of time. Suppose that you would like the information to go the other direction. That is, you would like to specify a probability, such as 0.05, in cell I11 and obtain the corresponding time in cell H11. Try doing this as follows with Excel’s Goal Seek tool. Use the Tools
Goal Seek menu items to get to a dialog box. Then in this dialog box, enter I11 as the Set cell, enter the desired probability such as 0.05 in the By Value box, and enter H11 as the changing cell. Use this procedure to answer the following. In an M
M
1 queue where customers are entering at rate 50 per hour and the mean service time is 1 minute, find the number of minutes t such that there is a 5% chance of having to wait in the queue more than t minutes.