Dedicated car wash services those customers

Assignment Help Operation Management

Reference no: EM132265613

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 16 minutes on average and that their inter-arrival time is exponentially distributed. Assume that the standard 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 normally distributed with mean time of 4 minutes and standard deviation of 1 minute.

In addition, assume that 50% of customers opt for an additional tire shine service that adds an exponentially distributed amount of service time with mean of 2 minutes. In Excel, simulate the arrival times and processing times of VIP customers at this car wash using 100,000 sample customers. Using the results of your simulation, calculate the percentage of VIP customers that were in the process (i.e. waiting+washing+extra services) for longer than 15 minutes. Press F9 to rerun your simulation several times and record the results for the percentage of customers who wait longer than 15 minutes. Using the median of these recorded percentages as your estimate of the percentage of customers expected to wait longer than 15 minutes, enter that probability here as a 3 digit decimal (e.g. 0.256, 0.452, 0.991, etc.)

Hint: "=if(rand()>0.5,1,0)" can be used to simulate whether the customer opts for the additional tire shine.

Hint2: "=NORM.INV(RAND(),15,2)" can be used to simulate a normally distributed random variable with mean of 15 and standard deviation of 2.

Reference no: EM132265613

Questions Cloud

What advice would you give monica : Case Study A- RR2- Read and Respond: Developing 'Savory Rosti-crisps' at Dreddo Dan's. What advice would you give Monica?

Market with one manufacturer and one retailer : Consider a vertical market with one manufacturer and one retailer. Market demand is P = 400 - Q, marginal cost to the manufacturer is $25 per-unit

Workers as assets.and cross trained workers : The text talks about personnel and organizational elements that define the lean system: Workers as assets. Cross trained workers

Monopolistic competition and adding increasing returns : Assuming monopolistic competition and adding increasing returns to our trade model makes it more realistic. How is this so?

Dedicated car wash services those customers : VIP Customers at their Buffalo, NY location sign up for unlimited car washes and a separate line & dedicated car wash services those customers.

Explain two ways that low interest rates : Explain two ways that low interest rates have affect the level of consumer spending or business investment in a country's economy.

Explain why a government budget deficit : Explain why a government budget deficit is likely to stimulate economic growth.

Can you think of any objection to the use of such policies : What kinds of fiscal or monetary policies might you use to close this gap? Can you think of any objection to the use of such policies?

Find the percentage change in quantity demanded : If the price of good X decreases by 0.5% and the price elasticity of demand is 1.4, find the percentage change in quantity demanded

User Account

All Pages