For the single$-$server queue problem of Section $2\mathrm{.}1\mathrm{.}1$ in the Kelton replace the data in Table $2-1$

with the following data:

Part

Number

Arrival

Time

Interarrival

Time

Service

Time

A $00\mathrm{.}443\mathrm{.}85$

B $0\mathrm{.}441\mathrm{.}169\mathrm{.}23$

C $1\mathrm{.}600\mathrm{.}217\mathrm{.}00$

D $1\mathrm{.}812\mathrm{.}110\mathrm{.}58$

E $3\mathrm{.}9216\mathrm{.}661\mathrm{.}09$

F $20\mathrm{.}580\mathrm{.}823\mathrm{.}45$

G $21\mathrm{.}400\mathrm{.}340\mathrm{.}15$

H $21\mathrm{.}741\mathrm{.}9410\mathrm{.}11$

I $23\mathrm{.}681\mathrm{.}392\mathrm{.}47$

J $25\mathrm{.}071\mathrm{.}482\mathrm{.}89$

K $26\mathrm{.}554\mathrm{.}680\mathrm{.}80$

L $31\mathrm{.}232\mathrm{.}110\mathrm{.}69$

M $33\mathrm{.}348\mathrm{.}835\mathrm{.}03$

N $42\mathrm{.}171\mathrm{.}742\mathrm{.}14$

O $43\mathrm{.}9117\mathrm{.}242\mathrm{.}43$

a$)$ Reconstruct the spreadsheet simulation demonstrated in class and available in Moodle.

i$.$ Extend and update each column G through N and T through V$.$

ii$.$ Update the Queue Length and Server Busy Plots.

b$)$ Calculate the average interarrival time and the average service time. If these averages are

representative of the arrival and service times for the entire time the system is running,

what will happen to the queue length if we run the system long enough?

c$)$ What is the total utilization percentage of the server $($total time the server is in use over the

total time the system is running$)?$