Simulate $5000$ vehicle arrivals using spreadsheet starting at $7$:$00$:$00.$ For each vehicle, show

its arrival order, vehicle type, time between arrival of previous vehicle and itself, arrival

time, service start time, service time, service end time, waiting time and charge.

$($For the first vehicle, the arrival of the previous vehicle is assumed to be the simulation

starting time.$)(30$ marks$)$

$($b$)$ Based on $1$ replication, find the following performance measures:

$($i$)$ Revenue collected during the period $7$:$15$:$0010$:$30$:$00(5$ marks$)$

$($ii$)$ Number of vehicles arriving between $7$:$15$:$00$ and $10$:$30$:$00(5$ marks$)$

$($iii$)$ Mean waiting time for vehicles arriving between $7$:$15$:$00$ and $10$:$30$:$00(5$ marks$)$

$($iv$)90$th percentile waiting time for vehicles arriving between $7$:$15$:$00$ and $10$:$30$:$00$

$(5$ marks$)$

$($c$)$ Replicate the above simulation for $200$ times using Data Table. For each replication, show