Question 17 Below is a room overbooking model spreadsheet for the Metza, a hotel

Question

Question 17 Below is a room overbooking model spreadsheet for the Metza, a hotel chain. The hotel has 425 rooms priced at S180 per day each, and is usually fully booked. Reservations can be cancelled any time before 5:00 p.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. Which of the following is the excel formula used to estimate overbooked customers? Not yet answered Points out of 1 Flag question Hotel Overbooking Model 1 for the Metza group of hotels 2 Data 4 Rooms Available Price per room Overbooking Cost 425 $180 $150 9 Model 425 400 12 13 14 15 16 Reservation Limit Customer Demand Reservation Made Cancellations Customer Arrivals Overbooked Customers 20 Select one O a.-MIN(0,B5-B15) O b. MAX(0,B15-B5) c. MAX(B11,B12) d. MIN(B11-B12,B11-B14)

Explanation / Answer

Option b. =MAX(0,B15-B5) will give the company number of overbooked customers. B15 - B5 will give the answer of overbooked customers and "Max" makes it choose the highest term that is overbooked customers

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.