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

use excel plzzz
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 points for the arrival times and 35 points the 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.) 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

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 Accounting Questions!