Please analyze and answer the Chapter $11$ Objective Question #$17$National State Bank$($p$295)$ using Excel $($an Excel template file is enclosed$).$

The National State Bank is trying to make sure it has enough tellers to handle the Friday afternoon rush of workers wanting to cash their paychecks. It is only concerned with the last hour of the day from $4$:$00$ to $5$:$00$ p$.$m$.$ It takes $5$ minutes per customer to be processed by the tellers. The average customer arrivals are shown in the following table.

Time Customers Arriving

$4$:$004$:$052$

$4$:$054$:$105$

$4$:$104$:$156$

$4$:$154$:$208$

$4$:$204$:$2510$

$4$:$254$:$3012$

$4$:$304$:$3516$

$4$:$354$:$4012$

$4$:$404$:$4510$

$4$:$454$:$506$

$4$:$504$:$554$

$4$:$555$:$002$

$5$:$005$:$050$

Total $93$

The bank currently has eight teller stations, and all are staffed during the Friday afternoon rush hour.

a$.$ What is the current maximum output at the bank during rush hour?

b$.$ Can the bank process all the customers by $5$:$00$ p$.$m$.?$

c$.$ What is the maximum waiting time for customers, and what time period does it occur in$?$