Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Business continues to grow at Clean Machine. Ahmed has decided to by a new machine. Based upon information obtained from similar information car wash stations,

Business continues to grow at Clean Machine. Ahmed has decided to by a new machine. Based upon information obtained from similar information car wash stations, it is believed that customers will arrive at the desk at a rate of 18 per hour (0.5-minute standards deviation). The Clean Machine car wash opens at 8:00 AM, but the service starts at 8:15. The current machine can service an average of 10 cars per hour (2-minutes standards deviation). He knows that he has two options: Machine 1 can service an average of 14 cars per hour (1-minute standards deviation). Machine 2 can service an average of 16 cars per hour (0.5-minute standards deviation). He has asked you to create a spreadsheet to develop a waiting line model for its customers for the current machine and the other options machines

Question 1: Create a spreadsheet simulation(interarrival time, arrival time, service start time, waiting time, service time, completion time & time in system) to develop a waiting line model for 5 customers for current machine, machine1, and machine2 to find: 1. Number of customers who had to wait and the probability of waiting? 2. Is the average customer waiting time 10 min or less? 3. Maximum and Minimum waiting time?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting and Reporting a Global Perspective

Authors: Michel Lebas, Herve Stolowy, Yuan Ding

4th edition

978-1408076866

Students also viewed these Accounting questions