3. A manufacturing process runs at a rate of 6 finished products per hour, according to...

   

Transcribed Image Text:

3. A manufacturing process runs at a rate of 6 finished products per hour, according to a negative exponential distribution. Customers seeking the finished products arrive at the shop on the average of 4 per hour, following a Poisson distribution. They are served on a first-in, first-out basis and come from a very large (almost infinite) population of possible buyers. Note: do not do this manually. Use MS Excel to obtain the following operating characteristics (the correct formulas should reflect in your excel cells): a. Average server utilisation b. Average number of customers in the queue c. Average number of customers in system (1) d. Average waiting time in the queue e. Average time in the system f. Probability (% of time) that the system is empty (1) g. Probability of more than k cars in the system (show calculations up to k=5 and cumulative probabilities) (6) 3. A manufacturing process runs at a rate of 6 finished products per hour, according to a negative exponential distribution. Customers seeking the finished products arrive at the shop on the average of 4 per hour, following a Poisson distribution. They are served on a first-in, first-out basis and come from a very large (almost infinite) population of possible buyers. Note: do not do this manually. Use MS Excel to obtain the following operating characteristics (the correct formulas should reflect in your excel cells): a. Average server utilisation b. Average number of customers in the queue c. Average number of customers in system (1) d. Average waiting time in the queue e. Average time in the system f. Probability (% of time) that the system is empty (1) g. Probability of more than k cars in the system (show calculations up to k=5 and cumulative probabilities) (6)

Answer rating: 100% (QA)

To calculate the operating characteristics using Excel we can utilize various functions and formulas Heres a stepbystep guide on how to obtain the req... View the full answer