Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started