Use the Table Below to Answer the Following Questions)

question 9

Multiple Choice

Use the table below to answer the following questions) .
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 | c | c | } \hline & \text { A } & B \\\hline & \begin{array} { c } \text { Hotel Overbonking Model } \\\text { for the Metza group af } \\\text { hotels }\end{array} & \\\hline 1 & & \\\hline 2 & \text { Data } & \\\hline 3 & & \\\hline 4 & & \\\hline 5 & \text { Rooms Available } &425 \\\hline 6 & \text { Price per room } & \$ 180 \\\hline 7 & \text { overbonking Cost } & \$ 150\\\hline 8 & & \\\hline 9 & & \\\hline 10 & & \\\hline\end{array}$$ $$\begin{array} { | c | c | c | } \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 { Overbonked Custarers } & \\\hline\end{array}$$
-Which of the following is the excel formula used to estimate overbooked customers?

• A) =MIN0,B5-B15)
• B) =MAX0,B15-B5)
• C) =MAXB11,B12)
• D) =MINB11-B12,B11-B14)

---

Definitions:

Denmark Vesey

An African American man who was most famous for planning a large slave rebellion in Charleston, South Carolina in 1822; the plot was discovered and Vesey was executed.

Slave Revolt

An armed uprising by enslaved people seeking freedom from servitude, notably seen in instances such as the Haitian Revolution or Nat Turner's rebellion.

1822

A specific year in the 19th century marked by various global historical events, lacking a singular defining characteristic without context.

1815

is the year marked by the end of the Napoleonic Wars with the defeat of Napoleon at the Battle of Waterloo.