Use the spreadsheet you built before, but add a column after the interarrival random times to

calculate the arrival time $($previous arrival time $+$ current interarrival time$).$ Use the Service

random values as the service times for each customer. Determine the Start$-$of$-$Service time $($greater

of the previous customer$$s end$-$of$-$service time and the current customer$$s arrival time$)$ and End$-$

of$-$Service time $($Start$-$of$-$Service time $+$ Service Time$)$ for each customer.

For output, calculate the Wait Times $($in minutes$)$ for each customer $($Start$-$of$-$Service minus

Arrival$)$ and the average wait time for the $90$ customers. Also find the maximum wait, and the

number of customers waiting less than $1$ minute, between $1$ and $5$ minutes, and greater than $10$

minutes $($use the COUNTIF function$).$ Create a data table that does $50$ replications of the

simulation for all those outputs. Average the $50$ replications. Determine a $95\%$ confidence interval

for the average wait time. Do all of this before considering the What$-$If scenarios below. You

should end up with a spreadsheet that looks very much like the lecture note and example

spreadsheets.

Now, create a copy of the simulation spreadsheet and copy the random numbers provided in

Canvas $($Assignment Random Numbers$)$ in place of the $=$RAND$()$ functions $($both columns$).$

That way, you all have the same output, but it makes the Data Table and Confidence Interval tabs

irrelevant. For the $$What$-$If Scenarios$,$ make copies of the Simulation tab using the $$fixed$$ values

for the random numbers, and change the parameters one at a time. Do not combine the scenarios

$$ each one is entirely separate from the others.

What$-$If Scenarios

$$ Raising your prices would decrease the number of customers you have. Change the

maximum arrival time from $30$ to $40,$ and delete the last $10$ customers $($change the

number of customers from $90$ to $80).$

$$ Options for reducing the service time are:

o Decrease options $($reduce mean service time from $45$ seconds to $35$ seconds$)$