Question: 2. Simulation Start with a Blank Excel file and build the model from scratch. The Harriet Hotel in downtown Boston has 100 rooms that rent

2. Simulation Start with a Blank Excel file and build the model from scratch. The Harriet Hotel in downtown Boston has 100 rooms that rent for $150 per night. It costs the hotel $30 per room in variable costs (cleaning, bathroom items, etc.) each night a room is occupied. For each reservation accepted, there is a 5% chance that the guest will not arrive. If the hotel overbooks, it costs $200 to compensate guests whose reservations cannot be honored. How many reservations should the hotel accept if it wants to maximize the average daily profit? [Use Microsoft Excel, use Random Numbers to simulate guest showo-show, create a Data Table, and use 1000 replications.]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
