Question: 2. Using Excel, build a simulation model to answer the following questions. To avoid the startup data, use only the data starting from the 20

2. Using Excel, build a simulation model to

2. Using Excel, build a simulation model to answer the following questions. To avoid the startup data, use only the data starting from the 20 arrival. Run the model on 300 usable arrivals, total 320 arrivals in Excel. Submit an excel file with details and clear syntax of each formula in the PDF a. Utilization of each server. b. Average idle time for each server. c. Average time in each server queue. d. Average time in each server. e. Average time in system. f. Probability of an entity to wait at each server. o. Probability of an entity to wait before entering the system. h. Probability of each server to be idle. Inter-arrival Poisson (7) distribution First Machine Uniform (3.4) service time Second Machine Normal (5,4) service time Third machine Exponential (3) service time Fourth machine Normal (1,0.5) service time M/C1 M/C2 M/C3 M/C 4 2. Using Excel, build a simulation model to answer the following questions. To avoid the startup data, use only the data starting from the 20 arrival. Run the model on 300 usable arrivals, total 320 arrivals in Excel. Submit an excel file with details and clear syntax of each formula in the PDF a. Utilization of each server. b. Average idle time for each server. c. Average time in each server queue. d. Average time in each server. e. Average time in system. f. Probability of an entity to wait at each server. o. Probability of an entity to wait before entering the system. h. Probability of each server to be idle. Inter-arrival Poisson (7) distribution First Machine Uniform (3.4) service time Second Machine Normal (5,4) service time Third machine Exponential (3) service time Fourth machine Normal (1,0.5) service time M/C1 M/C2 M/C3 M/C 4

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!