Question 1 ABC Grocery Store has only one checkout counter. Customers arrive at random The service time at the counter times from 1 to 4 minutes, vary from 1 to 4 minutes, with the with the following probabilities. following probabilities: CUSTOMER SERVICE Probability \" Service Time Probability n -s1_m Use the Excel template (Questionl Termplate.xlsx) posted under homework 9 on the assignments page) to answer the following questions: (a) Simulate this checkout counter's performance manually for 10 customers. To determine the inter arrival times, use the following random numbers: l32l34l4ol75l 5l4slso| a |25|38| To determine the service times, use the following random numbers: man You can use the following format to record your simulation results. Provide the following summary statistics for 10-customer simulation. l SUMMARY STATS - 10 Customers lb) SUMMARY STATS- 200 Customers l | Number waited | 6 Number waited 114 | l Avg Wait Time l 1.30 Avg Wait Time 0.87 l | Average time in service | 4.10 Average time in service 3.62 l l Total Idle Time l 7.00 Total Idle Time 49.00 l (Using Excel. simulate checkout counter performance for 200 customers]. You can determine the initial values for the first row/customer manually and use Excel functions to calculate the values in the second row. You can then copy the second row for the next 198 customers to simulate the performance for 200 customers. Use the random numbers provided on the Excel solution template for this simulation of 200 customers. Provide the same summary statistics listed above for ZOO-customer simulation