Question: I need urgent help solving this problem, please show me how to solve this problem in excel ASAP! Best answer guaranteed a thumbs up! A

I need urgent help solving this problem, please show me how to solve this problem in excel ASAP! Best answer guaranteed a thumbs up!

I need urgent help solving this problem, please

A small grocery store has only one checkout counter. Time between customer arrivals at this checkout counter is 4 minutes following an exponential distribution. The service times vary from 1 to 6 minutes with the probabilities shown in the table below. The problem is to analyze the system by simulating the arrival and service for four hours. Address the following statistics: 1) average wait time 2) proportion who waited 3) utilization of server 4) average time a customer is in the system. Enter any descriptive discussion you require in this box (it will expand as needed) Service time (min) Probability 10% 10% 30% 60% 85% 95% 20% 30% 25% 10% 5% Inter-arrival time 4 Minutes Length of sim 240 Minutes A small grocery store has only one checkout counter. Time between customer arrivals at this checkout counter is 4 minutes following an exponential distribution. The service times vary from 1 to 6 minutes with the probabilities shown in the table below. The problem is to analyze the system by simulating the arrival and service for four hours. Address the following statistics: 1) average wait time 2) proportion who waited 3) utilization of server 4) average time a customer is in the system. Enter any descriptive discussion you require in this box (it will expand as needed) Service time (min) Probability 10% 10% 30% 60% 85% 95% 20% 30% 25% 10% 5% Inter-arrival time 4 Minutes Length of sim 240 Minutes

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!