Use the Table Below to Answer the Following Questions)

question 50

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}$$
-Calculate the net revenue.

• A) $72,900
• B) $76,500
• C) $64,650
• D) $68,400

---

Definitions:

1930s

A decade characterized by the Great Depression, which had a profound impact on the world economy, social conditions, and the political landscape.

John Collier

An American social reformer and advocate for the rights of Native Americans, serving as Commissioner for the Bureau of Indian Affairs from 1933 to 1945, where he promoted policies to preserve Native American culture and autonomy.

Bureau of Indian Affairs

A federal agency within the United States tasked with the administration and management of lands and resources for Native American tribes.

Social Worker

A professional dedicated to helping individuals, families, and communities to cope with challenges and improve their well-being.