A. trust us bank has two types of customers merchant customers and regular customers the menu arrival rate of each type of customers is 15 per hour both types of customers currently wait in the same line and are served by the same tellers with the same average service time however Suzanne is considering changing this the new system she is considering would have two lines one for merchant customers and one for regular customers they would be a single teller serving each line. What would be the average waiting time for each type of customer before reaching the teller? On average how many total customers would be in the bank including those currently being served?

B. Suzanne feels that if the tellers are specialized into merchant tellers and regular tellers they will be more efficient and conserve customers in an average of 2.5 minutes instead of three minutes answer the question from part A again with this new average service time

(please use excel)

Suzanne Gifford has just completed her MBA degree and is proud to have earned a promotion to Vice President for Customer Services at the Trust Us Bank. One of her responsibilities is to manage how tellers provide services to customers, so she is taking a hard look at this area of the bank's operations. Customers needing teller service arrive randomly at a mean rate of 30 per hour. Customers wait in a single line and are served by the next available teller when they reach the front of the line. Each service takes a variable amount of time (assume an exponential distribution), but on average can be completed in 3 minutes. The tellers earn an average wage of $18 per hour. The customer metric is based upon the notion that they should not wait in the que more than 5 minutes. File Edit Vi to save su Home Review View insert Formulas Page Layout Draw Data Developer AL HE Y Filter Geography Sort G H LE L Results DIV/01 NDIVIO! W WE ADIVOI #DIV/0! . Connections E Properties From From Now Database Refresh Stocks HTML Text Query All Edit Links C28 4 x fx B D Template for the M/M/s Queueing Model 2 3 Data 4 (mean anival rate) 5 (mean service rato) 5 servers 7 8 PrW> DIVO 9 when te BDIV/01 10 RAIO 11 Prob(W) SREF 12 when 13 14 15 16 17 18 19 02 20 21 0 22 01 5.10 11 12 15 23 Numerely 24 25 20 Antwer 22 Question 10 25 Aug Waiting time in the System in Minutes) Avy Waiting Time in the Que? On minutes) 25 30 PET NDIV/01 1 2 3 OB 06 Q4 7 8 9 10 10 12 13 141 15 10 17 10 19 20 P. DIVIO NDIV/01 DIV/01 OVO #DIV/! BDIVO NDIVO DIV/0 #DIVO POIVOI #DIVIO DIVO! OIVO OVO! OVO NOIVOS NOVO! #DIVO #DIV/01 NOIVO DIVO DIVO DIVOR OIVO ROMVOI DIVOR 12 14 10 23 24 25 11.15 11.12 11.10 11.1 Suzanne Gifford has just completed her MBA degree and is proud to have earned a promotion to Vice President for Customer Services at the Trust Us Bank. One of her responsibilities is to manage how tellers provide services to customers, so she is taking a hard look at this area of the bank's operations. Customers needing teller service arrive randomly at a mean rate of 30 per hour. Customers wait in a single line and are served by the next available teller when they reach the front of the line. Each service takes a variable amount of time (assume an exponential distribution), but on average can be completed in 3 minutes. The tellers earn an average wage of $18 per hour. The customer metric is based upon the notion that they should not wait in the que more than 5 minutes. File Edit Vi to save su Home Review View insert Formulas Page Layout Draw Data Developer AL HE Y Filter Geography Sort G H LE L Results DIV/01 NDIVIO! W WE ADIVOI #DIV/0! . Connections E Properties From From Now Database Refresh Stocks HTML Text Query All Edit Links C28 4 x fx B D Template for the M/M/s Queueing Model 2 3 Data 4 (mean anival rate) 5 (mean service rato) 5 servers 7 8 PrW> DIVO 9 when te BDIV/01 10 RAIO 11 Prob(W) SREF 12 when 13 14 15 16 17 18 19 02 20 21 0 22 01 5.10 11 12 15 23 Numerely 24 25 20 Antwer 22 Question 10 25 Aug Waiting time in the System in Minutes) Avy Waiting Time in the Que? On minutes) 25 30 PET NDIV/01 1 2 3 OB 06 Q4 7 8 9 10 10 12 13 141 15 10 17 10 19 20 P. DIVIO NDIV/01 DIV/01 OVO #DIV/! BDIVO NDIVO DIV/0 #DIVO POIVOI #DIVIO DIVO! OIVO OVO! OVO NOIVOS NOVO! #DIVO #DIV/01 NOIVO DIVO DIVO DIVOR OIVO ROMVOI DIVOR 12 14 10 23 24 25 11.15 11.12 11.10 1