Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Arrival Times** Customer No Hours Minutes Service Times (minutes) 1 8 1 20 2 8 8 26.4 3 8 15 3.8 4 8 16 8.1
Arrival Times** | |||
Customer No | Hours | Minutes | Service Times (minutes) |
1 | 8 | 1 | 20 |
2 | 8 | 8 | 26.4 |
3 | 8 | 15 | 3.8 |
4 | 8 | 16 | 8.1 |
5 | 8 | 16 | 9.8 |
6 | 8 | 21 | 2.9 |
7 | 8 | 28 | 5 |
8 | 8 | 29 | 8.3 |
9 | 8 | 37 | 0.9 |
10 | 8 | 43 | 2.6 |
11 | 8 | 49 | 0.3 |
12 | 8 | 51 | 27.7 |
13 | 8 | 53 | 6.6 |
14 | 8 | 57 | 39.7 |
15 | 9 | 14 | 10.1 |
16 | 9 | 28 | 8.1 |
17 | 9 | 41 | 32 |
18 | 9 | 42 | 3.1 |
19 | 9 | 43 | 1.8 |
20 | 9 | 43 | 14.8 |
21 | 9 | 47 | 5.3 |
22 | 9 | 49 | 13.1 |
23 | 10 | 4 | 36.3 |
24 | 10 | 5 | 14.1 |
25 | 10 | 9 | 9.9 |
26 | 10 | 11 | 0.4 |
27 | 10 | 20 | 9.9 |
28 | 10 | 22 | 9.1 |
29 | 10 | 26 | 13.2 |
30 | 10 | 27 | 4.4 |
31 | 10 | 39 | 0.9 |
32 | 10 | 43 | 19.7 |
33 | 10 | 46 | 9.1 |
34 | 10 | 47 | 25.9 |
35 | 10 | 54 | 2.7 |
36 | 10 | 57 | 24.5 |
37 | 11 | 3 | 2.2 |
38 | 11 | 5 | 4.8 |
39 | 11 | 6 | 27.5 |
40 | 11 | 8 | 6.1 |
41 | 11 | 31 | 16.1 |
42 | 11 | 32 | 34.3 |
43 | 11 | 34 | 13 |
44 | 11 | 34 | 5.9 |
45 | 11 | 37 | 14.7 |
46 | 12 | 7 | 6.1 |
47 | 12 | 18 | 1.5 |
48 | 12 | 22 | 1.1 |
49 | 12 | 43 | 5.2 |
50 | 12 | 53 | 0.9 |
51 | 12 | 54 | 8.9 |
52 | 12 | 54 | 7.7 |
53 | 13 | 5 | 13.5 |
54 | 13 | 20 | 1.6 |
55 | 13 | 34 | 1.7 |
56 | 13 | 37 | 20.8 |
57 | 13 | 40 | 2.7 |
58 | 13 | 48 | 13.4 |
59 | 13 | 49 | 1.2 |
60 | 13 | 50 | 4.7 |
61 | 13 | 50 | 21 |
62 | 13 | 51 | 1.5 |
63 | 13 | 58 | 7.4 |
64 | 14 | 3 | 47.9 |
65 | 14 | 16 | 15.6 |
66 | 14 | 18 | 7.9 |
67 | 14 | 42 | 0.2 |
68 | 14 | 43 | 15.8 |
69 | 14 | 52 | 6.8 |
70 | 14 | 57 | 8.9 |
71 | 14 | 58 | 5.8 |
72 | 15 | 6 | 1.1 |
73 | 15 | 6 | 0.1 |
74 | 15 | 18 | 11.4 |
75 | 15 | 21 | 13.8 |
76 | 15 | 23 | 10.8 |
77 | 15 | 25 | 1.4 |
78 | 15 | 34 | 4 |
79 | 15 | 39 | 2 |
80 | 16 | 9 | 9.2 |
81 | 16 | 22 | 21.7 |
82 | 16 | 25 | 15.1 |
83 | 16 | 25 | 7.7 |
84 | 16 | 29 | 17 |
85 | 16 | 48 | 2.2 |
86 | 16 | 48 | 2.2 |
87 | 16 | 53 | 0.9 |
88 | 16 | 55 | 4.7 |
**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
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.xlsx. 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 averageStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started