Read the attached summary problem (Assign 7 - Worked Out Problem.doc) with solution for the Single Queue, Single Server problem. a) The statistics for the first problem are solved. You DO NOT have to look at all the problems following. I simply want you to understand the simple equations for calculating the basic statistics L, Lq, W, Wq b) Open Queueing Calculations(1).xlsx then enter the first problem from a) into the spreadsheet and confirm that L, L, W, Wq are the same. (Use lambda=30, mu=40) c) Open Queueing Simulator.xls (I hope your version of Excel is macro-enabled) Enter the lambda and mu values into the model, use a single server, then click the "RUN" button and note the simulated results. Are the simulated results similar? Run several trials and see how the simulated results for L, Lq, W, Wq vary. Take note of the range of deviation in the results. d) Finally, using both spreadsheets, enter the following data and calculate L, L, W, Wq: Run several simulations in the Queueing Simulator and compare results. A) Arrival rate = 20 customers per hour, Service rate = 26 customers per hour. One (1) server. B) Arrival rate = 20 customers per hour, Service rate = 13 customers per hour. Two (2) servers. COMPARE A) AND B). Is the service identical? If not, which is faster? Read the attached summary problem (Assign 7 - Worked Out Problem.doc) with solution for the Single Queue, Single Server problem. a) The statistics for the first problem are solved. You DO NOT have to look at all the problems following. I simply want you to understand the simple equations for calculating the basic statistics L, Lq, W, Wq b) Open Queueing Calculations(1).xlsx then enter the first problem from a) into the spreadsheet and confirm that L, L, W, Wq are the same. (Use lambda=30, mu=40) c) Open Queueing Simulator.xls (I hope your version of Excel is macro-enabled) Enter the lambda and mu values into the model, use a single server, then click the "RUN" button and note the simulated results. Are the simulated results similar? Run several trials and see how the simulated results for L, Lq, W, Wq vary. Take note of the range of deviation in the results. d) Finally, using both spreadsheets, enter the following data and calculate L, L, W, Wq: Run several simulations in the Queueing Simulator and compare results. A) Arrival rate = 20 customers per hour, Service rate = 26 customers per hour. One (1) server. B) Arrival rate = 20 customers per hour, Service rate = 13 customers per hour. Two (2) servers. COMPARE A) AND B). Is the service identical? If not, which is faster