Question: ( 7 5 points ) Using Excel, do a simulation by hand given the following information. We have system that has a single server and
points Using Excel, do a simulation by hand given the following information. We have system that has a single server and a single quaue MM interarrival times are exponentially distributed with a mean of minutes, and service times are also exponentally distributed with a mean of minutes. The sample of the interarrival and service times are providad in the table below all times are in minutes
tableReplication Replication Replication EntitytableInter ArrivalTimetableProcesaingTimetableInter ArrivalTimetableProcessingTimetableInter ArrivalTimetableProcessingTime
For each replication, complate the simulation by hand, you may use any of the two methods shown in the lectures.
Additional details
Initially at time O the system is empty and idla.
Base units: Minutes
The simulation length is minutes.
For each replication, estimate the fol owing key performance indicators.
Total Production.
Average waiting time in queue.
Maximum waiting time in queue.
Average total time in wytem.
Maximum total time in system.
Timeaverage number of parts in queue.
Maximum number of parts in queue.
Server utilization
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
