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 cn be cancelled any time before 5:00 p.m. with no penalty. The hotel estimates an average overbooking cost of S150. Customer demand is set at 400 with an average cancellation of 20. Hotel Overbooking Model for the Metza group of hotels 2 4 Rooms Available Price per room Overbooking Cost 425 $180 $150 Model 10 425 400 Reservation Limit Customer Demand Reservation Made Cancellations Customer Arrivals 12 13 14 15 16 Overbooked Customers 20 Hotel Overbooking Model for the Metza group of hotels Data 4 Rooms Available Price per room Overbooking Cost 425 $180 $150 Model 10 Reservation Limit425 Customer Demand Reservation Made 12 13 14 15 16 Overbooked Customers 400 Cancellations Customer Arrivals 20 Calculate the net revenue