Estimate of percentage of customers expected to wait loner

Assignment Help Operation Management

Reference no: EM131801448

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 12 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 three digit decimal e.g. 0.256, 0.452, 0.991, etc.) Hint 1: "=if(rand()>0.5,1,0)" can be used to simulate whether the customer opts for the additional tire shine. Hint 2: "=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: EM131801448

Questions Cloud

Analyze the audience for resume : Using correct memo form (see above), write a 200-250 word memo to the instructor in which you analyze the audience for your resume.

Define jobs as education and library professionals : Computer equipment expenses of which Dr. Hill claims is necessary for their jobs as education and library professionals

Role of rewards and punishment in ethics : Explain how the justification of the punishment affects us and the society. What do you feel is the role of rewards and punishment in ethics?

What is the cost to society in given case : Epidemic the cost per day to society of an epidemic is C(x, y) = 20x + 200y where C is in dollars, x is the number of people infected on a given day.

Estimate of percentage of customers expected to wait loner : Using the median of these recorded percentages as your estimate of the percentage of customers expected to wait longer than 15 minutes,

Prepare quarterly income statements showing income : Prepare quarterly income statements showing income from operations for the three divisions. Use three column headings: Air, Rail, and Truck.

Describe a project that you have worked on from beginning : A project requires ample coordination of schedule, costs, and scope. Describe a project that you have worked on from beginning to end.

Instructions for a procedure of choosing : Using the guidelines described in the reading above, write your own instructions for a procedure of your choosing.

Expected project completion time for construction : Using PERT, a project team was able to determine that the expected project completion time for construction of a building is 21 months and the project variance

User Account

All Pages