Question: Please show work 1. (75 points) Using Excel, do a simulation by hand given the following information. We have system that has a single server

Please show work

1. (75 points) Using Excel, do a simulation by hand given the following information. We have system that has a single server and a single queue (M/M/1), interarrival times are exponentially distributed with a mean of 5 minutes, and service times are also exponentially distributed with a mean of 4 minutes. The sample of the arrival and service times are provided in the table below (all times are in minutes). For each replication, complete the simulation by hand using the table below. I - Initially (time 0) empty and idle. - Base units: Minutes - Stop when 30 minutes of simulated time have passed. For each replication, estimate the following key performance indicators. (1) Total Production. (2) Average waiting time in queue. (3) Maximum waiting time in queue. (4) Average total time in system. (5) Maximum total time in system. (6) Time-average number of parts in queue. (7) Maximum number of parts in queue. (8) Server utilization 2. (25 points) Calculate the 90% Half Width for each KPI from part 1. In addition, estimate the 90% confidence interval (C.I.) for each KPI. Use the following table to fill in your results. 1. (75 points) Using Excel, do a simulation by hand given the following information. We have system that has a single server and a single queue (M/M/1), interarrival times are exponentially distributed with a mean of 5 minutes, and service times are also exponentially distributed with a mean of 4 minutes. The sample of the arrival and service times are provided in the table below (all times are in minutes). For each replication, complete the simulation by hand using the table below. I - Initially (time 0) empty and idle. - Base units: Minutes - Stop when 30 minutes of simulated time have passed. For each replication, estimate the following key performance indicators. (1) Total Production. (2) Average waiting time in queue. (3) Maximum waiting time in queue. (4) Average total time in system. (5) Maximum total time in system. (6) Time-average number of parts in queue. (7) Maximum number of parts in queue. (8) Server utilization 2. (25 points) Calculate the 90% Half Width for each KPI from part 1. In addition, estimate the 90% confidence interval (C.I.) for each KPI. Use the following table to fill in your results

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!

Using Excel, do a simulation by hand given the following information. We have system that has a single server and a single queue ( M / M / 1 ) , interarrival times are exponentially distributed with...

( 7 5 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...

undefined Dzenlemeyi etkinletir - Yerekiyorsa, Korumal Grnmde kalmanz daha gvenli olur. e bal olduunuzdan emin olun. Yeniden Dene P S T w Y Event Calendar JB Entity No, Time, Type RESULTS DON'T...

I need help with the following questions. Please see attached documents. 1.(20 points) Brunswick Corporation sells bowling balls and has developed the following information: Sales price $70 per unit...

Mat 152 Project 4 The Central Limit Theorem Student Learning Outcomes: 1) The student will demonstrate and compare properties of the central limit theorem. The Data A central tenet to being a good...

I know its a lot. But I seriously need help. They are so confusing. Please show work Review Test Submission: Ch. 10 Quiz Question 1 [1 out of'l [ {3% - Leyland Motors can service an average 5 cars...

Assignment: Analysis and Excel Simulation i Saved Help Save & Exit Submit Check my work Use Apple's financial statements in Appendix A to answer the following. Required: 10 1. Using fiscal 2017 as...

Staffing with the M/M/s Queue McNeese is determining the staffing level for their credit union located within the university, and has recently hired two tellers (servers). The beginning of the fall...

What rates of return rational investors using APT model would demand on security R and Q given the following information? Which security has higher rate of return and explain why. Portfolio A B C D E...

On page 529 of the text (right before section 18.3) the energy available from the proton gradient was derived. This assumes that the pH is 1.4 units lower in the IM space than in the matrix and that...

k e = required return R f = risk - free rate of return R m = market rate of return B = beta of stock, representing the sensitivity of a stock's returns to market returns Consider Coleman Co . , a U ....

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...