$Do$ the simulation model $on$ excel and show all formulas.

Judith's Airport Limousine Service

Judith's Airport Limousine Service. Judith McKnew $is$ always $on$ the lookout for $en-$

trepreneurial opportunities. Living $in$ Six Mile, South Carolina, she recognizes that the

nearest airport $is50$ miles away. Judith estimates that, $on$ average, there are about $45$

people from Six Mile $(and$ its vicinity$)$ who need rides $toor$ from the airport each day.

Judith $is$ considering leasing $a10-$passenger van and offering a $limousine$ service between

Six Mile and the airport. Operation Guidelines for Judith:

Reservations for a trip can $be$ made $upto12hrsin$ advance $by$ paying a nonrefund$-$

able $$10$ deposit.

Judith will accept $upto$ her reservation $limit(tobe$ defined $byus)..$

Ticket price $is$ $$35$ for those who reserve $in$ advance. Those passengers pay the

remaining $$25at$ the start $of$ the trip.

Judith accepts "walk$-up"$ passengers also $(those$ who did not reserve$),if$ there's

room $at$ $$50$ per trip.

The number $of$ reservations requested each trip follows a discrete uniform distribu$-$

tion between $7$ and $14.$

BCIT$-$OPMT$3301$:Quant.Meth.forBusinessStudentName:${?}_{?}$

Judith will reject reservation requests $if$ she has reached her $limit.$

The probability that a person with a reservation shows $upis0\mathrm{.}80.$

$If$ someone does not show $up,$ they $do$ not get their $$10$ deposit back.

$If$ the number $of$ people who show $up$ for their reservation exceeds $10(thelimit$ for

the van$),$ Judith makes alternate arrangements $to$ get those people $to$ the airport $at$

a cost $of$ $$75x=$# $of$ walk$-$upsP$(x=0)=0\mathrm{.}30$;$P(x=1)=0\mathrm{.}45$;$P(x=2)=0\mathrm{.}25$

The total cost per trip $to$ & from the airport $=$$$100$ for Judith

Question: How many reservations should Judith accept? $10,11,12,13,14?$