In Excel: At a single-phase, multiple-channel service facility, customers arrive randomly. Statistical analysis of past

[answerhappygod]

In Excel:
At a single-phase, multiple-channel service facility, customersarrive randomly. Statistical analysis of pastdata shows that the interarrival time has a mean of 12 minutes anda standard deviation of 6 minutes. Theservice time per customer has a mean of 10 minutes and a standarddeviation of 4 minutes. The waiting cost is$100 per customer per hour. The server cost is $20 per server perhour. Assume general probabilitydistribution and no buffer capacity restriction.a. Find the optimal number of servers to be employed to minimizethe total of waiting and server costs. (Ans:Cost per hour with one server=$105.42; Cost with 2 servers =$44.12; Cost with 3 servers = $60.76: So twoservers are optimal.)b. Find the average waiting time and the average total time throughthe system for the optimal case. (waiting:0.4940 min; Total: 10.4940 min)c. Find the cost per hour, average waiting time, and average flowtime for one server if the probabilitydistributions for the interarrival time and service time areassumed to be exponential and the mean valuesremain the same. The cost data remain the same. Use manualcalculations. (Ans: Cost per hour=$436.67,Waiting time=50.00 min, Flow time=60.00 min).