DATA To Be Provided

1. In class, we derived an average arrival rate (lambda). Be sure you have the right answer for this. Check with your team and teammates.

2. You need to derive from the class data set the average service rate (mu). There is a correct answer. Each team will be given 15 minutes to develop the data, and we will come back together as a group and agree on a number for mu.

3. From the attached queuing model, assume that Wawa has a three-server operation (that is, three persons working at the deli counter) and answer the following questions:

a. What is Po?

b. What is the probability that 1 customer is waiting? (use Table 11.4 and round up or down to the first significant digit, such as 1.x)

c. If the waiting cost per hour is $100, and the service cost per channel per hour is $45, what is total cost per hour for this operation?

You MUST post an Excel file to show your answers to item 3 above.

Solution Sheet2 Sheet3 Sheet 4 Sheet5 Sheet6 Sheet7 Sheet8 \begin{tabular}{|l|l|l|} \hline Multiple-Channel Waiting Line Model & & = answers \\ \hline & & cells for student entry \\ \hline Assumptions & & constants, do not edit \\ \hline Poisson Arrivals & & \\ \hline Exponential Service Times & & \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|} \hline Number of Channels & (k) & \multicolumn{1}{c|}{ units per } & \\ \hline Arrival Rate & (lamda) & & (be sure to use a common \\ \hline Service Rate For Each Channel & (mu) & & \\ \hline & & & \\ \hline & & & \\ \hline & & \\ \hline \end{tabular} Probability that no customers are in the system, Po Average number of customers in the waiting line, Lq Average number of customers in the system, L Average time a customer spends in the waiting line, Wq Average time a customer spends in the system, W Probability an arriving customer has to wait, Pw \begin{tabular}{l} Probability of \# of customers waiting \\ H of customers waiting \end{tabular} Economic Analysis \begin{tabular}{|l|} \hline The waiting cost per unit \\ The service cost per channel \\ Total cost per time period \end{tabular} 11.3 MultipleServer Waiting Line Model with Poisson Arrivals and Exponential Service Times 519 TABLE 11.4 VALUES OF P0 FOR MULTIPLE-SERVER WAITING LINES WTTH POISSON ARRIVALS AND EXPONENTIAL SERVICE TIMES