NOTE: QUESTION NEEDS TO BE ANSWERED IN EXACT WAY

A small$-$town Taxi operates one vehicle during the $9$:$00$ AM to $5$:$00$ PM period. Currently, consideration

is being given to the addition of a second vehicle to the fleet. The demand for the taxis follows the

distribution shown:

The distribution of time to complete a service is as follows:

Develop a hand simulation for one day using a single vehicle and determine:

Total idle time of the vehicle,

Average idle time per call,

Proportion of idle time,

Total time customers wait,

Average waiting item per customer,

Number of customers that wait,

Probability that a customer has to wait, and

Average waiting time of customers that wait.

Use Excel for your simulation table:

Assumption: The firs call arrives at $9$:$00$ AM$,$ and any call received before $5$:$00$ PM is served and those

that are received after $5$:$00$ are retuned $($not served$).$

Call

RD for Time Between Calls

Time Between Calls

Call time $($Clock$)$

RD for Service Time

Service Time

Service Time Begins

Time Customer Waites

Time Service Ends

Time Customer in System

Idel Time of Taxi $1$ NA $0202677934919483025329769038749008235095342104197117238124940130870145644155909167403172237181279196378209703214211226757$ Total

Random digit $00$ is equivalent to $100($in Excel$)$

Random digit $03$ is equivalent to $3($in Excel$)$ A small$-$town Taxi operates one vehicle during the $9$:$00$ AM to $5$:$00$ PM period. Currently, consideration is being given to the addition of a second vehicle to the fleet. The demand for the taxis follows the distribution shown:

The distribution of time to complete a service is as follows:

Develop a hand simulation for one day using a single vehicle and determine:

$-$ Total idle time of the vehicle,

$-$ Average idle time per call,

$-$ Proportion of idle time,

$-$ Total time customers wait,

$-$ Average waiting item per customer,

$-$ Number of customers that wait,

$-$ Probability that a customer has to wait, and

$-$ Average waiting time of customers that wait.

Use Excel for your simulation table:

Assumption: The firs call arrives at $9$:$00$ AM$,$ and any call received before $5$:$00$ PM is served and those that are received after $5$:$00$ are retuned $($not served$).$ A small$-$town Taxi operates one vehicle during the $9$:$00$ AM to $5$:$00$ PM period. Currently, consideration is being given to the addition of a second vehicle to the fleet. The demand for the taxis follows the distribution shown:

The distribution of time to complete a service is as follows:

Develop a hand simulation for one day using a single vehicle and determine:

$-$ Total idle time of the vehicle,

$-$ Average idle time per call,

$-$ Proportion of idle time,

$-$ Total time customers wait,

$-$ Average waiting item per customer,

$-$ Number of customers that wait,

$-$ Probability that a customer has to wait, and

$-$ Average waiting time of customers that wait.

Use Excel for your simulation table:

Assumption: The firs call arrives at $9$:$00$ AM$,$ and any call received before $5$:$00$ PM is served and those that are received after $5$:$00$ are retuned $($not served$).\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline Call & $\backslash$begin$\{$tabular$\}\{$l$\}$

RD for $\backslash \backslash$

Time $\backslash \backslash$

Between $\backslash \backslash$

Calls

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Time $\backslash \backslash$

Between $\backslash \backslash$

Calls

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Call time $\backslash \backslash$

$($Clock$)$

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

RD for $\backslash \backslash$

Service $\backslash \backslash$

Time

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Service $\backslash \backslash$

Time

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Service $\backslash \backslash$

Time $\backslash \backslash$

Begins

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Time $\backslash \backslash$

Customer $\backslash \backslash$

Waites

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Time $\backslash \backslash$

Service $\backslash \backslash$

Ends

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Time $\backslash \backslash$

Customer $\backslash \backslash$

in System

$\backslash$end$\{$tabular$\}$ & Idel Time of Taxi $\backslash \backslash$

$\backslash$hline $1$ & NA & & $0$ & $20$ & & & & & & $\backslash \backslash$

$\backslash$hline $2$ & $67$ & & & $79$ & & & & & & $\backslash \backslash$

$\backslash$hline $3$ & $49$ & & & $19$ & & & & & & $\backslash \backslash$

$\backslash$hline $4$ & $83$ & & & $02$ & & & & & & $\backslash \backslash$

$\backslash$hline $5$ & $32$ & & & $97$ & & & & & & $\backslash \backslash$

$\backslash$hline $6$ & $90$ & & & $38$ & & & & & & $\backslash \backslash$

$\backslash$hline $7$ & $49$ & & & $00$ & & & & & & $\backslash \backslash$

$\backslash$hline $8$ & $23$ & & & $50$ & & & & & & $\backslash \backslash$

$\backslash$hline $9$ & $53$ & & & $42$ & & & & & & $\backslash \backslash$

$\backslash$hline $10$ & $41$ & & & $97$ & & & & & & $\backslash \backslash$

$\backslash$hline $11$ & $72$ & & & $38$ & & & & & & $\backslash \backslash$

$\backslash$hline $12$ & $49$ & & & $40$ & & & & & & $\backslash \backslash$

$\backslash$hline $13$ & $08$ & & & $70$ & & & & & & $\backslash \backslash$

$\backslash$hline $14$ & $56$ & & & $44$ & & & & & & $\backslash \backslash$

$\backslash$hline $15$ & $59$ & & & $09$ & & & & & & $\backslash \backslash$

$\backslash$hline $16$ & $74$ & & & $03$ & & & & & & $\backslash \backslash$

$\backslash$hline $17$ & $22$ & & & $37$ & & & & & & $\backslash \backslash$

$\backslash$hline $18$ & $12$ & & & $79$ & & & & & & $\backslash \backslash$

$\backslash$hline $19$ & $63$ & & & $78$ & & & & & & $\backslash \backslash$

$\backslash$hline $20$ & $97$ & & & $03$ & & & & & & $\backslash \backslash$

$\backslash$hline $21$ & $42$ & & & $11$ & & & & & & $\backslash \backslash$

$\backslash$hline $22$ & $67$ & & & $57$ & & & & & & $\backslash \backslash$

$\backslash$hline Total & & & & & & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

Random digit $00$ is equivalent to $100($in Excel$)$

Random digit $03$ is equivalent to $3($in Excel$)$