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 Interarrival Time Probability Service Time Probability RN RN 0.10 00-09 0.10 00-09 IN 0.20 10-29 0.10 10-19 AWNI 0.40 30-69 0.70 20-89 A 0.30 70-99 0.10 90-99 Use the Excel template (Question1 Termplate.xIsx) 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: 32 34 40 75 5 45 8 25 38 To determine the service times, use the following random numbers: 14 40 60 44 12 22 48 7 15 92 You can use the following format to record your simulation results. Provide the following summary statistics for 10-customer simulation. SUMMARY STATS - 10 Customers (b ) SUMMARY STATS - 200 Customers Number waited 6 Number waited 114 Avg Wait Time 1.30 Avg Wait Time 0.87 Average time in service 4.10 Average time in service 3.62 Total Idle Time 7.00 Total Idle Time 49.00 (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 200-customer simulation