Question: solve in excel then type answer please A hair salon in a crowded city anticipates a demand of 30 customers per hour (Poisson arrivals), and

solve in excel then type answer please

A hair salon in a crowded city anticipates a demand of 30 customers per hour (Poisson arrivals), and it can serve 45 customers per hour (exponentially distributed). The salon is very crowded, so the manager wants to minimize the number of seats needed for waiting customers. At the same time, she doesnt want to lose too many customers who would leave when all waiting seats are occupied. Compute the fewest waiting seats that can be placed in the salon such that the probability of a customer balking and not entering the salon is less

What values should i insert to table to solve? than 2.0% solve in excel then type answer please A hairsolve in excel then type answer please A hair

Queuing Model with Unlimited Queue Size \begin{tabular}{l|r|} \hline put (Arrival) Rate & 0.6 \\ \hline ervice Rate & 0.8 \\ \hline ctivity (Service) Time T=1/ & 1.25 \\ \hline Jumber of Servers c & 1 \\ \hline \end{tabular} lote: c should be an integer Save Results \begin{tabular}{lr|} \hline verage Queue Length Lq & 2.2500 \\ \hline verage Number in the System L & 3.0000 \\ \hline verage Wait for Jobs that Do Wait Wqw & 5.0000 \\ \hline verage Wait in the Queue Wq & 3.7500 \\ \hline verage Time in the System W & 5.0000 \\ robability of an Empty System P0 & 25.00% \\ robability of Waiting Pw & 75.00% \\ \hline \end{tabular} ueuing Computations developed by Chuck Munson, Washington State University. ersion 1: Nov. 11, 2022 Queuing Model with Limited Queue Size \begin{tabular}{l|r|} \hline nput (Arrival) Rate & 0.6 \\ Service Rate & 0.8 \\ \hline Activity (Service) Time T=1/ & 1.25 \\ Number of Servers c & 2 \\ System Max K (Buffer =Kc ) & 0.375 \\ \hline ho & \end{tabular} Notes: c and K should be integers; K must be c Save Results \begin{tabular}{lr|} \hline Average Queue Length Lq & 0.1227 \\ Average Number in the System L & 0.8727 \\ Average Wait for Jobs that Do Wait Wqw & 1.0000 \\ Average Wait in the Queue Wq & 0.2045 \\ Average Time in the System W & 1.4545 \\ Probability of an Empty System P0 & 45.45% \\ Probability of Blocking (Balking) Pb & 0.00% \\ \hline Probability of Waiting (if not blocked) Pw & 20.45% \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!