Conduct Monte Carlo Simulation Using Historical Data and Resampling Techniques

question 10

Multiple Choice

Conduct Monte Carlo simulation using historical data and resampling techniques. Use the information below to answer the following question(s) .
Below is a spreadsheet for a hotel overbooking model. $\begin{array}{|c|c|c|c|l|l|}\hline & \text { A } & \text { B } & \text { C } &{\text { D }} & \text { E } \\\hline 1 & \text { Hotel Overbooking Model } & & & \text { Demand } & \text { Probability } \\\hline 2 & & & & 290 & 0.03 \\\hline 3 & \text { Data } & & & 295 & 0.05 \\\hline 4 & & && 300 & 0.08 \\\hline 5 & \text { Rooms av ailable } & 350 && 305 & 0.12 \\\hline 6 & \text { Price } & \$ 120 & & 310 & 0.15 \\\hline 7 & \text { Overbooking cost } & \$ 100 && 315 & 0.20 \\\hline 8 && & & 320 & 0.15 \\\hline 9 & \text { Model } & & & 325 & 0.10 \\\hline 10 & & & & 330 & 0.05 \\\hline 11 & \text { Reserv ation limit } & 350 && 335 & 0.04 \\\hline 12 & \text { Customer demand } & 320 && 340 & 0.02 \\\hline 13 & \text { Reservations made } & & &345 & 0.01 \\\hline 14 & \text { Cancellations } & 15 \\\hline 15 & \text { Customer arrivals } & \\\hline 16 & & \\\hline 17 & \text { Overbooked customers } & \\\hline 18 & \text { Net revenue } & \\\hline\end{array}$ Assume that each reservation has a constant probability p = 0.04 of being cancelled. Answer the question(s) using the Risk Solver Platform.
-With respect to B12, what is the range for values given in the Parameters section in the Discrete dialog?

• A) $E$2:$E$13
• B) $D$2:$D$8
• C) $D$2:$D$13
• D) $E$2:$E$8

---

Definitions:

P = ATC

P = ATC denotes the point where the price is equal to the average total cost, indicating a break-even point for a firm in the short run.

Level of Output

The quantity of goods or services produced by a business within a certain period.

Marginal Revenue

The increase in revenue that results from the sale of one additional unit of a product.

Output

The total amount of goods or services produced by a company, industry, or economy within a specific period.