Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Operation Management Expert

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.

Operation Management, Management Studies

  • Category:- Operation Management
  • Reference No.:- M92629815

Have any Question?


Related Questions in Operation Management

1 what is strategy and how can a critical role in

1. What is strategy and how can a critical role in communication matter? 2. Create a research paper outline that discuss the following question. Things Christians should know about Jewish life. 3. How important is the ab ...

1 consider the role that health information management has

1. Consider the role that health information management has on preparation for tracer methodology surveys. Determine at least three ways that HIM can assit in tracer preparation. Minimum 250 words. 2. You have just taken ...

Risk categoriesconsider some of the risks faced by people

Risk Categories Consider some of the risks faced by people in different careers. A firefighter, for instance, faces a very different set of risks than someone who works in an office environment. What risks or uncertainti ...

1 define 1 incremental 2 substantial and 3 transformational

1. Define 1) incremental, 2) substantial, and 3) transformational innovation. Provide two examples of each type of innovation and explain why you chose them. 2. Search the Internet and find an article on a recent global ...

Find a professional in your personal network heshe might be

Find a professional in your personal network. He/she might be a business leader, teacher, a mentor, or an entrepreneur you admire. addressing the following prompts: What is the person or organization’s mission statement? ...

Teaming across distance and culture bull what are the major

Teaming Across Distance and Culture. • What are the major effects of the physical separation of group members? How can distance, in some cases, be beneficial to groups and teams? • What other areas of organizational beha ...

1 mention what system quality has been implemented and done

1. Mention what System Quality has been implemented and done in your company, show the process and how it works. 2. What Industry does the Best Buy participate? Remember what we discussed in class. This definition will t ...

1 what are different types of retails and the wholesalers

1. What are different types of retails and the wholesalers? Discuss in detail in your own word ( No copy paste from any website or book) 2. Assuming you were using excel software to implement the database, what architect ...

Case study six 71- a clean slatequestions 1 what is nick

Case Study Six 7.1- A Clean Slate QUESTIONS 1. What is Nick Gibbons's vision in this case study? How is it similar to or different from the vision of the owners of the paper? Discuss the unique challenges a leader faces ...

Judy is a retired school teacher who spends most of her

Judy is a retired school teacher who spends most of her time as a volunteer. She itemizes deductions and brought in a list of her charitable contributions. Which of her contributions is NOT deductible? Tuition she paid a ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As