Question: ( 7 5 points ) Using Excel, do a simulation by hand given the following information. We have system that has a single server and

(75 points) Using Excel, do a simulation by hand given the following information. We have system that has a single server and a single quaue (M/M/1), interarrival times are exponentially distributed with a mean of 5 minutes, and service times are also exponentally distributed with a mean of 4 minutes. The sample of the inter-arrival and service times are providad in the table below (all times are in minutes).
\table[[,Replication 1,Replication 2,Replication 3],[Entity,\table[[Inter Arrival],[Time]],\table[[Procesaing],[Time.]],\table[[Inter Arrival],[Time]],\table[[Processing],[Time]],\table[[Inter Arrival],[Time]],\table[[Processing],[Time]]],[1,1085,0.74,8.75,3.05,1.28,0.50],[2,5.67,1.15,7.53,1.33,1.39,1.31],[3,4.98,2.31,1.88,2.32,1.77,0.41],[4,4.57,1.28,4.52,4.84,1.31,4.71],[5,2.36,5.89,3.93,3.64,5.58,1.01],[6,,4.36,,1.14,,2.73]]
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 30 minutes.
For each replication, estimate the fol owing key performance indicators.
(1) Total Production.
(2) Average waiting time in queue.
(3) Maximum waiting time in queue.
(4) Average total time in wytem.
(5) Maximum total time in system.
(6) Time-average number of parts in queue.
(7) Maximum number of parts in queue.
(8) Server utilization
 (75 points) Using Excel, do a simulation by hand given the

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!