Evaluate average time a customer waits for service

Assignment Help Strategic Management

Reference no: EM13551881

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:

1. Average time a customer waits for service

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

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

Replicate each measure 20 times to compute the average.

Reference no: EM13551881

Questions Cloud

Does a atom gain or lose energy going from lyman series : Does a atom gain or lose energy going from lyman series to balmer series? Does a atom gain or lose energy going from balmer series to paschen series series? Does a atom gain or lose energy going from balmer series to prilind series?

Beams of high-speed protons can be produced in guns : Beams of high-speed protons can be produced in "guns" using electric fields to accelerate the protons. (a) What acceleration would a proton experience if the gun's electric field were 3.00 104 N/C? m/s2

Explain the distance from the earth to the nearest stars : The distance from the earth to the nearest stars is measured in light-years. Convert the distance 5.4 light-years to SI units m

Electron travel in the field before stopping momentarily : An electron with a speed of 7.00 108 cm/s enters an electric field of magnitude 1.00 103 N/C, traveling along the field in the direction that retards its motion. (a) How far will the electron travel in the field before stopping momentarily?

Evaluate average time a customer waits for service : Compute each of the measures- Average time a customer waits for service, Average time a customer is in the system and percentage of time the server busy with customers.

What is the increase in their temperature per 100 m of trave : What is the increase in their temperature per 100 m of travel

Evaluate the mass of this object : Find the mass of this objectAn object of unknown mass is attached to an ideal spring with force constant 130 and is found to vibrate with a frequency of 5.60 Hz. found to vibrate with a frequency of 5.60 Hz. Find the period. Find the angular veloci..

Evaluate how much work is done in each cycle : An engine with an output of 300 W has an efficiency of 35.0 %. It works at 13.00 cycles/s. How much work is done in each cycle

Find the amount of work the object does to bring the truck : A 900 Kg truck is driving at 45 m/s when it hits a large soft object and becomes embedded with it. Find the amount of work the object does to bring the truck to a stop

User Account

All Pages