Question: Below is a room overbooking model spreadsheet for the Metza, a hotel chain The hotel has 425 rooms priced at $180 per day each, and

Below is a room overbooking model spreadsheet for the Metza, a hotel chain The hotel has 425 rooms priced at $180 per day each, and is usually fully booked. Reservations can be cancelled any time before 5:00p.m.with no penalty. The hotel estimates an average overbooking cost of $150. Customer demand is set at 400 with an average cancellation of 20. A B 1 Hotel Overbooking Model for the Metza group of hotels N 3 Data 4 5 Rooms Available 425 6 Price per room $180 7 Overbooking Cost $150 18 9 Model 10 11 Reservation Limit 425 12 Customer Demand 400 13 Reservation Made 14 Cancellations 20 15 Customer Arrivals 16 Overbooked Customers Calculate the customer arrivals at the Metza? 10 11 Reservation Limit 425 12 Customer Demand 400 13 Reservation Made 14 Cancellations 20 15 Customer Arrivals 16 Overbooked Customers Calculate the customer arrivals at the Metza? 380 405 400 O 425
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
