Need help setting up this waiting line model problem. PLEASE SET UP IN EXCEL

Please answer as many questions as you can. If you can't ignore part 1 and just do part 2.

Problem 12:1 The manager of a retail store is facing a problem where the single check-out lines in their stores are waiting too long. The manager's overall objective is to increase sales by improving customer check-out service. Usually, Customers line up in the single check-out line at the mean rate of 28 per hour. Customers are served on a first-come, first-served, basis. On average, one cashier can check out a customer in two minutes. When working with other cashiers, an additional cashier reduces the check-out time of a customer by 15 seconds, on average. The manager has also discovered that, on average, customers will leave if their wait is five minutes or more. (Assume Poisson arrivals and exponential service times.) Part 1: 1. state the appropriate operating characteristic used as criterion for this problem 2. state the specific criterion the consultant is using in terms of the operating characteristic. 3. state the minimum total number of cashiers needed to meet the consultant's objective. Part 2: With the minimum number of cashiers stated in part 3 all working together as a single team: 4. state the probability that the check-out line is empty of customers. 5. state how long in minutes and seconds, is the meantime that customers are expected to have to wait at the check-out line. 6. On average, state how many customers are expected to be waiting in line. 7 State how long, in minutes and seconds, is the meantime for a cashier to check out a customer. 8. state the chance that a customer will have to wait in line before being served by a cashier 9. state the chance that a customer will be taken by the cashier right away without having to wait at all. 10. state long, in minutes and seconds, it will take on average for customers to check-out, from the time they arrive on the waiting line until the time they leave the cashier. 11. state the chance that the check-out line is empty for five minutes so that all the cashiers can take a short break for personal business without being interrupted by the arrival of a customer. (Simply put, state the chance that no customers will arrive in a five-minute period.) Problem 12:1 The manager of a retail store is facing a problem where the single check-out lines in their stores are waiting too long. The manager's overall objective is to increase sales by improving customer check-out service. Usually, Customers line up in the single check-out line at the mean rate of 28 per hour. Customers are served on a first-come, first-served, basis. On average, one cashier can check out a customer in two minutes. When working with other cashiers, an additional cashier reduces the check-out time of a customer by 15 seconds, on average. The manager has also discovered that, on average, customers will leave if their wait is five minutes or more. (Assume Poisson arrivals and exponential service times.) Part 1: 1. state the appropriate operating characteristic used as criterion for this problem 2. state the specific criterion the consultant is using in terms of the operating characteristic. 3. state the minimum total number of cashiers needed to meet the consultant's objective. Part 2: With the minimum number of cashiers stated in part 3 all working together as a single team: 4. state the probability that the check-out line is empty of customers. 5. state how long in minutes and seconds, is the meantime that customers are expected to have to wait at the check-out line. 6. On average, state how many customers are expected to be waiting in line. 7 State how long, in minutes and seconds, is the meantime for a cashier to check out a customer. 8. state the chance that a customer will have to wait in line before being served by a cashier 9. state the chance that a customer will be taken by the cashier right away without having to wait at all. 10. state long, in minutes and seconds, it will take on average for customers to check-out, from the time they arrive on the waiting line until the time they leave the cashier. 11. state the chance that the check-out line is empty for five minutes so that all the cashiers can take a short break for personal business without being interrupted by the arrival of a customer. (Simply put, state the chance that no customers will arrive in a five-minute period.)