Once the spreadsheet is completed, answer the following question:

QUESTION: Which customer was the 15th to balk?

FLG (Finger Licking Good) Chicken Shack, like most eating establishments, saw a significant increase in their drive-thru business because of the COVID pandemic. The establishment originally was intended as a casual sports bar and a DT window was added as a convenience feature for customers who want to pick up a meal to take home. However, with the restrictions put in place because of the pandemic, the DT was the only source of revenue. DT's have limited capacity dictated by their speed of service. For example, if it takes 1 minute to make and deliver the product to the customer, then they can only serve 60 customers during that hour Originally, FLG did not have any problems serving their drive-thru clientele. However, now, they noticed that it was common to see cars leave the waiting line and take their business elsewhere. "General Tso, FLG's owner, had watched with envy how McDonald's was able to handle their DT business and was contemplating adding a second window to his DT. The first window would be used to receive payment and the second window would be used to deliver the completed order to the customer, However, he wanted more evidence that a two-window DT would be a good investment Xiao Tso, the General's son, had recorded the customer and service data collected during the peak hours, when DT capacity was an issue, shown below to help his father. ARRIVAL DATA time between arrival (sec) Frequency 15 10 10 BALKINO DATA of cars probably in line of balking SERVICE TIME DATA) uniform Min 90 240 . 2 5 4 5 6 NOITE: Service time includes 30 seconds to pay for the order which has very little varability. The balance of time is spent waiting on order to assembled and based 15 07 75 90 10 120 135 190 20 30 25 1 REVENUE DATA nomal Mean Sid Dev. $0.00 $ 3.00 10 10 130 Total 1. Simulate FLG's current DT operation for two hours and determine how many balks will occur during that time as well as the revenues per hour. 2. Simulate FLG assuming it had a double window drive through and estimate the impact of the double window DT on balks and revenues. 3. Estimate the 95% confidence interval or average revenue per arrival (including balks) for both the current and proposed double window configuration for FLG with a +/- 10% margin of error. 4. For both DT configurations, determine the operating characteristics of the DT (average time in queue, average time in system, average server idle time, number of units in line, etc.). FLG (Finger Licking Good) Chicken Shack, like most eating establishments, saw a significant increase in their drive-thru business because of the COVID pandemic. The establishment originally was intended as a casual sports bar and a DT window was added as a convenience feature for customers who want to pick up a meal to take home. However, with the restrictions put in place because of the pandemic, the DT was the only source of revenue. DT's have limited capacity dictated by their speed of service. For example, if it takes 1 minute to make and deliver the product to the customer, then they can only serve 60 customers during that hour Originally, FLG did not have any problems serving their drive-thru clientele. However, now, they noticed that it was common to see cars leave the waiting line and take their business elsewhere. "General Tso, FLG's owner, had watched with envy how McDonald's was able to handle their DT business and was contemplating adding a second window to his DT. The first window would be used to receive payment and the second window would be used to deliver the completed order to the customer, However, he wanted more evidence that a two-window DT would be a good investment Xiao Tso, the General's son, had recorded the customer and service data collected during the peak hours, when DT capacity was an issue, shown below to help his father. ARRIVAL DATA time between arrival (sec) Frequency 15 10 10 BALKINO DATA of cars probably in line of balking SERVICE TIME DATA) uniform Min 90 240 . 2 5 4 5 6 NOITE: Service time includes 30 seconds to pay for the order which has very little varability. The balance of time is spent waiting on order to assembled and based 15 07 75 90 10 120 135 190 20 30 25 1 REVENUE DATA nomal Mean Sid Dev. $0.00 $ 3.00 10 10 130 Total 1. Simulate FLG's current DT operation for two hours and determine how many balks will occur during that time as well as the revenues per hour. 2. Simulate FLG assuming it had a double window drive through and estimate the impact of the double window DT on balks and revenues. 3. Estimate the 95% confidence interval or average revenue per arrival (including balks) for both the current and proposed double window configuration for FLG with a +/- 10% margin of error. 4. For both DT configurations, determine the operating characteristics of the DT (average time in queue, average time in system, average server idle time, number of units in line, etc.)