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:

Mastery Goal

An orientation towards learning, where the focus is on gaining new knowledge or mastering a new skill, rather than on demonstrating superior performance compared to others.

Psychological Needs

Fundamental human requirements that are essential for mental well-being, such as the need for love, esteem, and self-actualization.

Motivation

An internal process that stimulates and guides actions to fulfill needs and objectives.

Physical Needs

Basic requirements for human survival including air, water, food, shelter, and sleep.