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:

Risk of Loss

The potential for an asset to be damaged, destroyed, or lost, and the consideration of who bears this responsibility until the asset is delivered.

Insurable Interest

A principle requiring that a person purchasing insurance has a legitimate interest in the continuation of the life, property, or event insured, enough to incur a financial loss if the insured risk occurs.

Shipment Contract

A contract that requires the seller to arrange for the transportation of goods to the buyer, where the risk of loss passes to the buyer upon the seller's delivery to the carrier.

FOB Miami

A shipping term indicating that the seller of goods is responsible for them until they're loaded onto a vessel in Miami; from that point, the buyer assumes risk and costs.