Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed 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 average

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project management

Authors: Harvey maylor

4th Edition

027370432X, 978-0273704324

More Books

Students also viewed these General Management questions

Question

What are the three different meanings of the term "markets"?

Answered: 1 week ago