Please state what exactly the answer is in the format given and how you get it,
ID: 3260079 • Letter: P
Question
Please state what exactly the answer is in the format given and how you get it, thanks. Also, pls consider the answer on the question if it helps, the cross means wrong, tick means correct. Also, I tried three times, all answers are shown below and they are wrong. Also, please use the worksheet 12-23, the link is here https://drive.google.com/file/d/0BwRTtt2PMBD3b1l1RFdqU1ZzOGc/view?usp=sharing
Problem 12-23 The Burger Dome waiting line model studies the waiting time of customers at its fast-food restaurant. Burger Dome's single-server waiting line system has an arrival rate of 0.75 customers per minute and a service rate of 1 customer per minute Adapt the Black Sheep Scarves spreadsheet shown below to simulate the operation of this waiting line. Make sure to use the random values for both interarrival and service times generated in the worksheet 12-23. Assuming that customer arrivals follow a Poisson probability distribution, the interarrival times can be simulated with the cell formula -(1/A)*LN(RAND(), where = 0.75. Assuming that the service time follows an exponential probability distribution, the service times can be simulated with the cell formula * LN(RAND(), where = 1, Run the Burger Dome simulation for 1000 customers. Discard the first 100 customers and collect data over the next 900 customers. The analytical model indicates an average waiting time of 3 minutes per customer. What average waiting time does your simulation model show? Round your answer to 3 decimal places. 1 Black Sheep Scarves with One Quality Inspector 3 Interarrival Times (Uniform Distribution) 4 Smallest Value Value 7 Service Times (Normal Distribution) 8 Mean 9 Standard Dev 10 0.3 12 Simulation 13 Interarrival Arriva Service Waiting Service Completion Time 15 Customer Time Start Time Time Time Time in SystemExplanation / Answer
I am given some simulation values
average waiting time in this format is 1.59
In generation of service time using exponential distribution, used normal random variable with mean 1 and standard deviation of 0.2 minutes to get the service time.
the impact of this change on the average waiting time is increase fastely and the waiting time value is 113.876
Random Values forService Time Arrival time Service start time Waiting time completion time Time in system 0.9540 0.6217 0.6217 0.0000 1.5757 0.9540 0.9790 0.6764 1.5757 0.8993 2.5547 1.8784 0.8167 0.6913 2.5547 1.8635 3.3714 2.6801 0.1035 0.9903 3.3714 2.3811 3.4749 2.4847 0.2734 1.0941 3.4749 2.3808 3.7483 2.6542 0.1201 1.9576 3.7483 1.7907 3.8684 1.9108 0.8454 2.7660 3.8684 1.1023 4.7138 1.9478 0.2805 3.6276 4.7138 1.0862 4.9943 1.3667 0.8516 4.1570 4.9943 0.8373 5.8458 1.6889 0.4150 4.3395 5.8458 1.5064 6.2608 1.9214 0.2444 4.6866 6.2608 1.5742 6.5052 1.8186 0.9544 4.8951 6.5052 1.6101 7.4596 2.5645