Question: use excel plzzz Simulation of Queueing Systems Introduction To Simulation 2 Homework For the system you choose in last assignment, collect at least 35 data

Simulation of Queueing Systems Introduction To Simulation 2 Homework For the system you choose in last assignment, collect at least 35 data points for the arrival times and 35 points the service times. Then construct table of departures for them. inst ance m No arrival 1 3 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22222222 23 24 25 26 27 28 29 2 1 4 2 6 2 6 Random Departure time 6 2 7 7 8 2 3 4 3 4 2 4 1 6 2 2 5 4 3 5 1 2 5 2 3 1 4 1 6 5 1 1 2 2 2 2 5 5 6 5 4 2 8 8 5 7 7 4 3 1 7 3 7 8 7 5 1 2 1 6 5 5 30 31 32 33 34 35 36 37 3 38 3 39 6 40 6 41 2 42 2 43 6 44 6 45 4 46 5 47 5 48 2. 8 49 4 5 50 6 CS Scanned with CamScanner 2 Instan ce No 8 6 7 5 6 8 5 3 7 2 2 8 3 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 Random Random arrival Departur time e time 1 4 6 6 1 4 2 2 5 1 4 5 6 6 5 3 4 6 4 6 5 2 3 1 3 4 3 6 4 5 4 3 1 5 5 3 1 5 98 99 100 1 6 5 3 3 3 2 6 3 6 6 2 2 7 3 3 5 7 6 2 3 3 3 1 5 1 1 2 2 7 6 7 5 5 3 7 1 2 8 3 2 4 4 2 2 8 8 Simulation of Queueing Systems Introduction To Simulation 2 Class Work A small grocery store has one checkout counter. Customers arrive at random times from {1,2,...,8} minutes and service times vary from {1,2,...,6} minutes. Consider the system for 100 customers. Find the departure time of each customer. Use excel to solve the exercise. (Hint: use RANDBETWEEN(1;6) for arrival times and RANDBETWEEN (1;8) for service times.) Simulation of Queueing Systems Introduction To Simulation 2 Homework For the system you choose in last assignment, collect at least 35 data points for the arrival times and 35 points the service times. Then construct table of departures for them. inst ance m No arrival 1 3 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22222222 23 24 25 26 27 28 29 2 1 4 2 6 2 6 Random Departure time 6 2 7 7 8 2 3 4 3 4 2 4 1 6 2 2 5 4 3 5 1 2 5 2 3 1 4 1 6 5 1 1 2 2 2 2 5 5 6 5 4 2 8 8 5 7 7 4 3 1 7 3 7 8 7 5 1 2 1 6 5 5 30 31 32 33 34 35 36 37 3 38 3 39 6 40 6 41 2 42 2 43 6 44 6 45 4 46 5 47 5 48 2. 8 49 4 5 50 6 CS Scanned with CamScanner 2 Instan ce No 8 6 7 5 6 8 5 3 7 2 2 8 3 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 Random Random arrival Departur time e time 1 4 6 6 1 4 2 2 5 1 4 5 6 6 5 3 4 6 4 6 5 2 3 1 3 4 3 6 4 5 4 3 1 5 5 3 1 5 98 99 100 1 6 5 3 3 3 2 6 3 6 6 2 2 7 3 3 5 7 6 2 3 3 3 1 5 1 1 2 2 7 6 7 5 5 3 7 1 2 8 3 2 4 4 2 2 8 8 Simulation of Queueing Systems Introduction To Simulation 2 Class Work A small grocery store has one checkout counter. Customers arrive at random times from {1,2,...,8} minutes and service times vary from {1,2,...,6} minutes. Consider the system for 100 customers. Find the departure time of each customer. Use excel to solve the exercise. (Hint: use RANDBETWEEN(1;6) for arrival times and RANDBETWEEN (1;8) for service times.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
