Question 1

On a visit to an amusement park you pass someone who has just ridden a roller coaster and asks you for directions to the First Aid Station. Realizing that traffic at the First Aid Station would be something to study with simulation, you gather some information. Two EMTs staff the station, and patients wait and go to the first one available. People coming there can be divided into two groups: those who need something minor (e.g. Tylenol, a band-aid) or those who need more help. Assume those in the first group constitute 25% of the patients and take 5 minutes to have their problem solved. Those in the second group need an uncertain amount of time, as given by a probability distribution. Develop a flowchart for this simulation problem.

Accepted Answer

The answer of On a visit to an amusement park...

Question 2

As the owner of a rent-a-car agency you have determined the following statistics: $$\begin{array} { c c c c } 
\begin{array} { c } 
\text { Potential } \
\text { Rentals Daily }
\end{array} & \text { Probability } & \begin{array} { c } 
\text { Rental } \
\text { Duration }
\end{array} & \text { Probability } \
\hline 1 & 10 & 1 \text { day } & .50 \
2 & .15 & 2 \text { day } & .30 \
3 & .20 & 3 \text { days } & .15 \
4 & .30 & 4 \text { days } & .05
\end{array}$$ The gross profit is $40 per car per day rented. When there is demand for a car when none is available there is a goodwill loss of $80 and the rental is lost. Each day a car is unused costs you $5 per car. Your firm initially has 4 cars. 
a.Conduct a 10-day simulation of this business using Row #1 below for demand and Row #2 below for rental length. $$\begin{array} { l l l l l l l l l l l } 
\text { Row \#1: } & 63 & 88 & 55 & 46 & 55 & 69 & 13 & 17 & 36 & 81 \
\hline \text { Row \#2: } & 59 & 09 & 57 & 87 & 07 & 92 & 29 & 28 & 64 & 36
\end{array}$$ 
b.If your firm can obtain another car for $200 for 10 days, should you take the extra car?

Accepted Answer

The answer of As the owner of a rent-a-car agency...

Question 3

Using the spreadsheet below, give the cell address which would have the formula shown. $\begin{array}{|l|l|}
\hline{\text { Cell Formula }} & \text { Belongs in Cell } \
\hline=\mathrm{VLOOKUP}(\mathrm{B} 18, \$ \mathrm{~B} \$ 10: \$ \mathrm{C} \$ 12,2) & \
\hline=\mathrm{VLOOKUP}(\mathrm{D} 23, \$ \mathrm{~F} \$ 11: \$ \mathrm{G} \$ 14,2) & \
\hline=\mathrm{K} 19^{*}(\$ \mathrm{I} \$ 16-\mathrm{I} 19) & \
\hline=\mathrm{VLOOKUP}(\mathrm{H} 27, \$ \mathrm{~B} \$ 10: \$ \mathrm{C} \$ 12,2) & \
\hline=\mathrm{AVERAGE}(\mathrm{L} 18: \mathrm{L} 27) & \
\hline
\end{array}$

Accepted Answer

The answer of Using the spreadsheet below, give the cell...

Question 4

Arrivals to a truck repair facility have an interarrival time that is uniformly distributed between 20 and 50 minutes. Service times are normally distributed with mean 30 minutes and standard deviation 10 minutes. Develop a spreadsheet model to simulate the arrival of 100 trucks. Collect information on the time the repair facility is idle and on the average waiting time for trucks.

Accepted Answer

The answer of Arrivals to a truck repair facility have...

Question 5

Seventy-five percent of calls arriving at a help line can be handled by the person who answers the phone, but the remaining 25% of them will need to be referred to someone else. Assume that every call requires one minute of attention by the person who answers the phone (either to answer the question or to figure out how the referral should be handled). Calls that are referred need an additional amount of time, as given in the table below. $$\begin{array} { c c } 
\text { Time Required } & \text { Probability } \
\hline 3 \text { minutes } & .25 \
5 \text { minutes } & .35 \
10 \text { minutes } & .40
\end{array}$$ Callers are served on a first come, first served basis, and are put on hold until the line is free. Use the random numbers to simulate what happens to 10 callers. (Use the random numbers in order -- from left to right, first row first -- as you need them.) What percentage of your callers needs to be referred? Of those who had to be referred, what is the average referral time? $\begin{array} { l  }
.82&.39&.16&.79&.56&.62&.13&.04&.42&.81\.85&.32&.64&.90&.73&.02&.76&.03&.86&.67
\end{array}$

Accepted Answer

The answer of Seventy-five percent of calls arriving at a...

Question 6

An airline reservation system first asks customers whether they want to schedule a domestic or an international flight. Sixty-five percent of the reservations are for domestic flights. The time distribution of advance sales is also important, and it is given below. \[\begin{array}{l}
\begin{array} { | l | c | l | } 
\hline{ \text { Domestic Flights } } \
\hline \text { Make Reservations } & \text { Rel. Freq. } & \text { RN Range } \
\hline \begin{array} { l } 
\text { Less than } 1 \text { week } \
\text { in advance }
\end{array} & .25 & \
\hline \begin{array} { l } 
1 \text { week to } 2 \text { months } \
\text { in advance }
\end{array} & .35 & \
\hline \begin{array} { l } 
\text { Over } 2 \text { months } \
\text { in advance }
\end{array} & .40 & \
\hline
\end{array}\\
\begin{array} { | l | c | c | } 
\hline  { \text { International Flights } } \
\hline \text { Make Reservations } & \text { Rel. Freq. } & \text { RNRange } \
\hline \begin{array} { l } 
\text { Less than } 1 \text { week } \
\text { in advance }
\end{array} & .12 & \
\hline \begin{array} { l } 
\text { 1 week to } 2 \text { months } \
\text { in advance }
\end{array} & .35 & \
\hline \begin{array} { l } 
2 \text { months to } 6 \text { months } \
\text { in advance }
\end{array} & .40 & \
\hline \begin{array} { l } 
\text { Over } 6 \text { months } \
\text { In advance }
\end{array} & .13 & \
\hline
\end{array}
\end{array}\] $$\begin{array} { | l | c | l | } 
\hline  { \text { Flight Type } } & \text { Rel. Freq. } & \text { RN Range } \
\hline \text { Domestic } & .65 & \
\hline \text { Interrational } & .35 & \
\hline
\end{array}$$ 
a.Place the appropriate random number ranges in the tables above.
b.Set up and perform a simulation for three customers.Determine whether they want a domestic or international flight, and how far in advance the reservation is being made.Use random numbers from this list: .632 .715 .998 .671 .744 .021

Accepted Answer

The answer of An airline reservation system first asks customers...

Question 7

The time required to set up lighting for a portrait studio is uniformly distributed between 12 and 20 minutes. Use the following random numbers to generate the setup time for 10 customers.
.27
.53
.06
.92
.16
.74
.06
.29
.82
.23

Accepted Answer

The answer of The time required to set up lighting...

Question 8

Greenfields is a mail order seed and plant business. The size of orders is uniformly distributed over the interval from $25 to $80. Use the following random numbers to generate the size of 10 orders.
.41
.99
.07
.05
.38
.77
.19
.12
.58
.60

Accepted Answer

The answer of Greenfields is a mail order seed and...

Question 9

Estimates of the financial information for a new product show the following information: $$\begin{array} { c c l l } 
\text { Units Sold } & \text { Probability } & \text { Fixed cost } & \$ 8,000 \
600 & .35 & \text { Variable cost } & \$ 6 / \text { unit } \
800 & .45 & \text { Revenue } & \$ 22 / \text { unit }
\end{array}$$ Use the random numbers .51, .97, .58, .22, and .16 to simulate five trials. What is the net profit for each trial?

Accepted Answer

The answer of Estimates of the financial information for a...

Quiz 12: Simulation

The time required to set up lighting for a portrait studio is uniformly distributed between 12 and 20 minutes. Use the following random numbers to generate the setup time for 10 customers. .27 .53 .06 .92 .16 .74 .06 .29 .82 .23

Greenfields is a mail order seed and plant business. The size of orders is uniformly distributed over the interval from $25 to $80. Use the following random numbers to generate the size of 10 orders. .41 .99 .07 .05 .38 .77 .19 .12 .58 .60