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 formulasthxxx Assume that you are the manager of a travel agency thatsells vacation packages to its customers. The agency is open from 8:00AM to 5:00 PM. Two sales representatives are working in the travel

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!