Use the Table Below to Answer the Following Question(s) -Which of the Following Is the Excel Formula Used to Is

question 66

Multiple Choice

Use the table below to answer the following question(s) .
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 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. $\begin{array}{|c|l|l|}\hline &A&B\\\hline1 & \begin{array}{c}\text { Hotel Overbooking Model } \\\text { for the Metza group of } \\\text { hotels }\end{array} & \\\hline 2& & \\\hline 3 & \text { Data } & \\\hline 4 & & \\\hline 5 & \text { Rooms Available } & 425 \\\hline 6 & \text { Price per room } & \$ 180 \\\hline 7 & \text { Overbooking Cost } & \$ 150 \\\hline 8 & & \\\hline 9 & \text { Model } & \\\hline 10 & & \\\hline 11 & \text { Reservation Limit } & 425 \\\hline 12 & \text { Customer Demand } & 400 \\\hline 13 & \text { Reservation Made } & \\\hline 14 & \text { Cancellations } & 20 \\\hline 15 & \text { Customer Arrivals } & \\\hline 16 & \text { Overbooked Customers } & \\\hline\end{array}$
-Which of the following is the excel formula used to estimate overbooked customers?

• A) =MIN(0,B5-B15)
• B) =MAX(0,B15-B5)
• C) =MAX(B11,B12)
• D) =MIN(B11-B12,B11-B14)

---

Definitions:

Satisfaction or Dissatisfaction

An individual's feeling of pleasure or disappointment resulting from comparing a product's perceived performance against expectations.

Post-Purchase Evaluation

The process consumers undergo after buying a product, assessing their satisfaction and the product's performance against expectations.

Satisfice

A decision-making strategy that aims for a satisfactory or adequate solution, rather than an optimal one.

Optimal

Refers to the most favorable or desirable condition, level, or outcome in a given situation.