Below is a room overbooking model spreadsheet for Metze, a hotel chain. The hotel has $300$ ?rooms priced at $ $180$ ?per day each and is usually fully booked. Reservations can be canceled any time before $5$ : $00$ ?pm with no penalty. The hotel estimates an average overbooking cost of $ $150.$ ?Metze sets a reservation limit of $320$ ?and estimates an average customer demand of $330$ ?with a cancellation rate of $5\%.$ ?Which of the following is the Excel formula used to estimate the number of overbooked customers in cell B $13?$ ?

?A B

$1$ ?Data

$2$ ?Rooms available $300$

$3$ ?Price per room $180$

$4$ ?Overbooking cost $150$

$5$ ?Reservation limit $320$

$6$ ?Estimated customer demand $330$

$7$ ?Average cancellation $\%5\%$

$8$ ?

$9$ ?Model

$10$ ?Reservation # made $320$

$11$ ?Cancellation # $16$

$12$ ?Customer arrivals $304$

$13$ ?Overbooked customers $?$

?

?

Group of answer choices

$=$ IF $($ B $2-$ B $12>0,$ ?B $2-$ B $12,0)$

$=$ B $12-$ B $2$

$=$ IF $($ B $2-$ B $12>0,0,$ ?B $2-$ B $10)$

$=$ IF $($ B $12-$ B $2>0,$ ?B $12-$ B $2,0)$