MBA 1730 Case Study - Spring 2013 You wil be expected to submit a Microsoft Ward file that contains your responses for each poblas of the case study project. You will shake apacked to submit fully functional, and clearly labeled Excel youdshorts that indade s complete copy of your simulation model that reflee's the calculation suchred with your aneven for each portion of the case study project. his recommended that you use a separis spre debat far cach simulation mockl. Your spreadsheet will be ropedted to include the camplie down set med and s complex copy of all cakeabbiees of athor watt you have performed to deave your women for each problem Problem I A popolo Mexican pill restaurant b cou kring al ting s dire-thu sevice loc. The dime- how myron will provide automen with the ability to place and pickup their ordo without ever lowing the co. Codemen do not have to schedule sheed, and there me wo order minimum. They drive up, place their food ander ton a move simplified ware while in the bare with an is- where lacan, and dive his i monbead poking pot mewling the ander. Their food asker has provided within minun This savker will mic oora man what bay in - h ter an the new dive. his spoken during ix Monday Friday hachibed bars of liam - ipm. . The seen will be idle for no one fun ininin The manager ha shed you to prodk The perfeminine of the drive dirs service syour during his time by anolding culame ared and service for the rules. Madly the Fared preached exiled "Ecimple2 55:Senaas"ancewary bo aiThe biloving patiruins . Cumbria ardarly arrive at the Marian mostcarl drive thru wih the himamid dres Allow me in expedial dinbrian with time between anival for 11 3as laxch fire as chran blow. Time has hogan 016Use the 'Problem_ServiceTime_Data_Spring2023 xls' to identify the correct distribution to use for service time in the Excel spreadsheet noted above. Use graphical and statistical tests to verify your identified distribution, and show your work. Once identified, set up the correct formula to generate the correct parameters for your identified service distribution in the simulation template. Assume the system there is one customer being serviced (service to be completed in 3 minutes) and there is one customer in the checkout queue at the beginning of the simulation. Part I Construct a simulation model to evaluate the above drive-thru problem for 40 customers, a. Make ten independent replications, each of run length 40 customers. (Hint: Run each individual simulation trial using the "One Trial" worksheet in the Example2.5SingleServer.xIs spreadsheet.) Record in a separate worksheet each of the ten independent replication results for the observed (1) mean amount of time customers spend waiting in the queue for each trial, and (2) number of instances in which the system is idle for more than 4 minutes for each trial b. Explain the observed differences between the ten trials with respect to the mean amount of time customers spend waiting in the queue, and number of instances in which the system is idle for more than 4 minutes. C. Estimate long-run mean time customers spend waiting in the queue with a 95% confidence interval. d. Using the results of part (a) and (b), estimate the total number of replications needed to estimate mean time customers spend waiting in the queue within 1 minute, Part II e. Run ten multi-trial replications of the simulation trials, with each replication consisting of 400 simulation trials. (Hint: Run each replication using the "Experiment" worksheet.) Record the observed (1) mean amount of time customers spend waiting in the system for each of the ten replications. f. Explain the observed difference in the degree of variability between the mean amount of time custor Soand waiting in the ou he for the ten individual trials in Part L. and