Delta sonic is a car wash provider in western new york a


Delta Sonic is a car wash provider in Western New York. VIP Customers at their Buffalo, NY location sign up for unlimited car washes and a separate line & dedicated car wash services those customers (i.e. a single-server single-queue model). Assume VIP customers arrive every 10 minutes on average and that their inter-arrival time is exponentially distributed. Also, assume that processing (washing) time is the sum of two components:

A constant (i.e. not random) basic washing time that is exactly 4 minutes.

A random extra-service time that is exponentially distributed with mean time of 2 minutes.

In Excel, simulate the arrival times and processing times of VIP customers at this car wash using 2,000 sample customers. Using the results of your simulation, calculate the percentage of VIP customers that were in the process (i.e. waiting+washing) for longer than 10 minutes.  Press F9 to rerun your simulation several times and record the results for the percentage of customers who wait longer than 10 minutes. Using the median of these recorded percentages as your estimate of the percentage of customers expected to wait longer than 10 minutes, enter that probability here as a two digit decimal e.g. 0.25, 0.45, 0.99, etc.)

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Delta sonic is a car wash provider in western new york a
Reference No:- TGS02562865

Expected delivery within 24 Hours