Can A to C here be solved on excel?

Burger King is attempting to improve customer satisfaction by offering the service such that

a. average wait time of customer does not exceed 5 minutes and

b. average queue length is 5 or fewer customers.

The manager wants to conduct a simulation study to verify the current service level.

Burger King get an average of 26 customer per hour. The inter arrival time and service time is shown in table below:

Distribution of Inter Arrival Time

Inter Arrival Time A	0	1	2	3	4
Probability P(A)	0.10	0.20	0.52	0.05	0.13

Distribution of Service Time

Service Time S	1	1	2	3	4
Probability P(S)	0.16	0.34	0.04	0.04	0.42

Please answer the following questions:

A	Simulate the model 500 times for an 8-hour shift	(4)
B	Determine the average wait time for the customer	(2)
C	Determine the time customer spends in the system (wait time + service time)	(2)
D	Determine the percentage of time the server spends waiting for the customer	(2)
E	Explain the solution through video walk through	(5)
F	Timely submission	(5)