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,customers arrive randomly. Statistical analysis ofpast data shows that the interarrival time has a mean of 10 minutesand is exponentially distributed. Theservice time per customer has a mean of 8 minutes and isexponentially distributed. The arrival buffercapacity is 8 customers. The lost customer cost due to blocking is$500 per customer. The waiting cost is$200 per customer per hour. The server cost is $40 per server perhour. Use Performance.xls spreadsheetfor queue analysis and manual calculation for costs.a. Find the optimal number of servers to be employed to minimizethe total of lost customer cost, waitingcost, and server cost.b. Find the average overall waiting time and the average total flowtime through the system for theoptimal case.