Compute average time a customer waits for service

Assignment Help Strategic Management

Reference no: EM13544320

Case Study - Local Bank

A local bank has a single drive-through window with arrival times and service times that follow the distributions from the following tables:

Time between arrivals (min)	(%)
1	15
2	24
3	27
4	22
5	12

Service Time (min)	Unloading Frequency (%)
1	15
2	35
3	22
4	28

Use Excel (RAND, LOOKUP, Data Tables) to simulate the arrival of 200 customers to compute each of the following measures:

a) Average time a customer waits for service

b) Average time a customer is in the system (wait plus service time)

c) Percentage of time the server busy with customers (utilization factor)

Replicate each measure 20 times to compute the average.

Reference no: EM13544320

Questions Cloud

Determine what is the angular velocity of the particle : You observe a 2.0 kg particle moving at a constant speed of 3.9 m/s in a clockwise direction around a circle of radius 4.0 m. What is the angular velocity of the particle

Energy from a rotating flywheel with a radius : A car is designed to get its energy from a rotating flywheel with a radius of 2.25 m and a mass of 550 kg. The flywheel can be considered as a uniform thin cylinder. Before a trip, the flywheel is attached to an electric motor, which brings the flywh..

Find the angle between the inclined plane and the horizontal : A hollow, thin-walled cylinder and a solid sphere start from rest and roll without slipping down an inclined plane of length 3.0 m. find the angle between the inclined plane and the horizontal

Child climbs a normal staircase to the second floor : When an 78.3-kg adult uses a spiral staircase to climb to the second floor of his house, his gravitational potential energy increases by 2.08 x 103 J. By how much does the potential energy of a 19.5-kg child increase when the child climbs a normal st..

Compute average time a customer waits for service : Case Study - Local Bank - Average time a customer waits for service, average time a customer is in the system and percentage of time the server busy with customers (utilization factor)

Explain the activation energy of the oxidation reaction : Ammonia will react with oxygen in the presence of a copper catalyst to form nitrogen and water. From 164.5 C to 179C, the rate constant increases by a factor of 4.27. What is the activation energy of this oxidation reaction

Characteristic path of projectile motion : The drawing shows a skateboarder moving at 7.87 m/s along a horizontal section of a track that is slanted upward by 49.2 ° above the horizontal at its end, which is 0.739 m above the ground.

Explain what is the rate constant at 227 c : A rate constant obeys the Arrehnius equation, the factor A being 2.2 * 10^13 s-1 and the activation energy being 150 kj mol -1. What is the rate constant at 227 C, in s-1

Find what was the average angular speed of the ball : A soccer ball, which has a circumference of 70.0 , rolls 11.0 in 3.30. What was the average angular speed of the ball during this time

User Account

All Pages