Your learning team recently invested in a small boutique hotel in Montauk. The hotel has 20 standard rooms. During the peak summer season, the hotel is always sold out on weekends. Yet historically 16% of customers cancel their bookings prior to arrival. While occasionally your hotel can find a last-minute customer to compensate for a cancellation, often the rooms simply go vacant. To hedge against this loss in revenue, you are considering adopting an overbooking policy. But before doing so, however, your team wants to assess the risk and reward of overbooking. (a) Construct a simulation model of the occupancy of your hotel on a peak summer night. Assume you receive 20 reservations, but some of those 20 reservations cancel randomly. The probability that a given reservation cancels is 0.16. Simulate these cancellationsand compute the number of customers who show up on the simulated night. Provide asnapshot of your spreadsheet model and explain all formulas used.
(b) Use your model in part (a) to simulate1,000nights of operation of your hotel. What isyour estimate of the average occupancy? What is the probability that the hotel is full?
(c) Now consider overbooking your hotel by one room. That is, suppose you now accept21 reservations as a hedge against cancellations, knowing that there is some chance acustomer might have to be "walked" if all 21 reservations arrive. Simulate1,000days ofoperation of your hotel with this new overbooking policy. What is the average occupancy(number of guests staying at the hotel)? What is the average number of walked customersper night?
(d) Repeat your analysis from (c) when you overbook by 2, 3 and 4. Provide a table of theaverage occupancy and average number of walked customers each night for each of thefour overbooking policies.
(e) Based on your results, which policy would you adopt? (No right or wrong answer here, but think in terms of what you would choose if this was your hotel and what factorswould influence your decision.