Question: Please help with each part, also pls explain everything with formulas thxxx Assume that you are the manager of a travel agency that sells vacation




Please help with each part, also pls explain everything with formulas thxxx
Assume that you are the manager of a travel agency that sells vacation packages to its customers. The agency is open from 8:00 AM to 5:00 PM. Two sales representatives are working in the travel agency to serve incoming customers. The sales representatives are highly skilled and are able to serve any customer with the same efficiency level. At any given time, each representative only serves one customer at a time. As a manager you are concerned about the high waiting times and decide to conduct an analysis to understand the extent of the problem. On a typical day, you logged the arrival times of customers as well as how long it took for the sales representative to serve the customers. Please see the customer arrival time and service time data in the Excel file named "Q2_data.xIsx. You can assume that this data is representative for other operating days as well and the distribution of customer arrivals and service times do not change. Use the data to answer the following questions. a) Compute the average of interarrival times and service times as well as their standard deviation. b) What is the utilization level of the travel agency? c) How long do customers wait before talking to a sales representative on average? d) How many customers are waiting in the queue on average? fx total time *"For instance the first customer arrived at 08:01 AM. The second customer arrived at 08:08AM. The third customer arrived at 08:15 AM
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
