The MM1 Template.xlsx file is now set up so that when you enter any time value in

Question:

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 one minute, find the number of minutes tsuch that there is a 5% chance of having to wait in the queue more than t minutes.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Practical Management Science

ISBN: 1497

5th Edition

Authors: Wayne L. Winston, Christian Albright

Question Posted: