Question: help solve ( a , b , c ) using excel, pls show all work so i can understand Question 2 : Using the data

help solve (a,b,c) using excel, pls show all work so i can understand Question 2: Using the data below, generate a simulation for a 1 station queue (similar to the
examples in class). Show the interarrival times, service times, start service and end service for each
entity. Let simulation run for 750 entities. Let the first entity start service at 0+ the first interarrival
time. (Hint: We did hand simulation in class where you rolled dice. Replicate that here in Excel)
a)(8 points) What is the approximate average waiting time, % server idle, and % server busy?
(Note: The number will change because the random number will change. Just provide an
approximate value or range.)
b)(8 points) Change the mean for the Interarrival Distribution to 8 and 12 and observe how
the system's performance changes. Describe how the system is impacted by these small
changes. (Hint: you can compare with the values from part a)
c) Extra Credit (up to 5 points): Calculate the average numbor
 help solve (a,b,c) using excel, pls show all work so i

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!