1) (8 points) For this question you will use the Line Sim.xls file of John O. McClain. Read the instructions carefully. Especially, note that you should be saving your work as a separate workbook for your models and keep the original LineSim.xls file unchanged. You will design a production line with 6 machines with a total of four storage areas (buffers) between machines. Machines will never fail (default option) For all machines' processing time, use the same Shifted Erlang-3 distribution. Set the processing time of all machines to have a mean of 5 minutes and standard 5 deviation of 2 minutes. You want to decide how much storage capacity (buffer capacity) you should allocate for each buffer. Change the name of the first machine to M1 and the second one to M2. Set your run parameters as: o Run-in time: 300 Run-time:2000 o Repetitions: 8 Run simulations for the following 4 models o Model 1: All buffers have a capacity of 1 o Model 2: All buffers have a capacity of 20 o Model 3: Buffer after machine M3 has a capacity 20 and the other have a capacity of 1. Model 4: Buffer after machine M5 has a capacity 20 and the other have a capacity of 1. o Model 5: Buffer after machine M1 has a capacity 20 and the other have a capacity of 1. Model 6: A model that you think would give a good performance. You should define and explicitly explain what good performance is and set the buffer capacities to achieve this goal. Copy-paste Values the cumulative statistics from your models to the table in hw2_91.xlsx file. Prepare a bulleted list to the factory manager explaining what you have learned by running the simulation models regarding the placement/capacity of buffers. 1) (8 points) For this question you will use the Line Sim.xls file of John O. McClain. Read the instructions carefully. Especially, note that you should be saving your work as a separate workbook for your models and keep the original LineSim.xls file unchanged. You will design a production line with 6 machines with a total of four storage areas (buffers) between machines. Machines will never fail (default option) For all machines' processing time, use the same Shifted Erlang-3 distribution. Set the processing time of all machines to have a mean of 5 minutes and standard 5 deviation of 2 minutes. You want to decide how much storage capacity (buffer capacity) you should allocate for each buffer. Change the name of the first machine to M1 and the second one to M2. Set your run parameters as: o Run-in time: 300 Run-time:2000 o Repetitions: 8 Run simulations for the following 4 models o Model 1: All buffers have a capacity of 1 o Model 2: All buffers have a capacity of 20 o Model 3: Buffer after machine M3 has a capacity 20 and the other have a capacity of 1. Model 4: Buffer after machine M5 has a capacity 20 and the other have a capacity of 1. o Model 5: Buffer after machine M1 has a capacity 20 and the other have a capacity of 1. Model 6: A model that you think would give a good performance. You should define and explicitly explain what good performance is and set the buffer capacities to achieve this goal. Copy-paste Values the cumulative statistics from your models to the table in hw2_91.xlsx file. Prepare a bulleted list to the factory manager explaining what you have learned by running the simulation models regarding the placement/capacity of buffers