Question: use excel to solve the question :) Assignment 3 - Waiting Lines Model Part 1: Question 1: Ahmed is the manager of the Clean Machine

use excel to solve the question :) Assignment 3 -

use excel to solve the question :)

Assignment 3 - Waiting Lines Model Part 1: Question 1: Ahmed is the manager of the Clean Machine car wash and has gathered the following information. Customers arrive at a rate of 9 per hour according to a Poisson distribution. The car washing machine is working 16 hours a day and can service an average of 12 cars per hour with $7 rate per hour. The cost of waiting time is $6 per hour of time spent waiting in line Ahmed is concerned about the number of customers waiting in line. Ahmed realizes that how long the customer must wait is also very important. He is also concerned about customers dissatisfaction when the waiting line is too long. He has asked you to calculate the following system characteristics: 1. Average system utilization 2. Probability that the system is idle. 3. Average number of customers in the system. 4. Average number of customers waiting in line. 5. The average time a customer spends in the system. 6. The average time a customer spends waiting in line. 7. The probability of having more than three customers in the system. 8. The probability of having more than four customers in in the system. 9. Daily waiting 10. Waiting cost. 11. Daily machine cost. 12. Total costs

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!