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:00 pm. with no penalty. The hotel estimates an average overbooking cost of $150. Customer demand is set at 400 with an average cancellation of 20. Hotel Overbooking Model for the Metza group of hotels " Rooms Available "1 $180 Overbookin - Cost $150 -Ei-

Which of the following is the excel formula used to estimate overbooked customers? Calculate the net revenue.