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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!