Delta Sonic is a car wash provider in Western New York. VIPCustomers at their Buffalo, NY location sign up for unlimited carwashes and a separate line & dedicated car wash services thosecustomers (i.e. a single-server single-queue model). Assume VIPcustomers arrive every 10 minutes on average and that theirinter-arrival time is exponentially distributed. Also, assume thatprocessing (washing) time is the sum of two components:
A constant (i.e. not random) basic washing time that isexactly 4 minutes.
A random extra-service time that is exponentially distributedwith mean time of 2 minutes.
In Excel, simulate the arrival times and processing times of VIPcustomers at this car wash using 2,000 sample customers. Using theresults of your simulation, calculate the percentage of VIPcustomers that were in the process (i.e. waiting+washing) forlonger than 12 minutes. Press F9 to rerun your simulationseveral times and record the results for the percentage ofcustomers who wait longer than 12 minutes. Using the median ofthese recorded percentages as your estimate of the percentage ofcustomers expected to wait longer than 12 minutes, enter thatprobability here as a two digit decimal e.g. 0.25, 0.45, 0.99,etc.)
