The following spreadsheet shows demand and booking data for Toretto Car Rentals.Use the spreadsheet to answer the question(s)below.
-How will the formula to calculate A18 be represented in B18?
A)MIN(B15,B5)∗ B6 - B16 ∗ B7
B)MAX(B15,B5)∗ B6 - B16 ∗ B7
C)MIN(B15,B5)∗ B6 + B16 ∗ B7
D)MAX(B15,B5)∗ B6 + B16 ∗ B7

Question

The following spreadsheet shows demand and booking data for Toretto Car Rentals.Use the spreadsheet to answer the question(s)below. 
-How will the formula to calculate A18 be represented in B18?
A)MIN(B15,B5)∗ B6 - B16 ∗ B7 
B)MAX(B15,B5)∗ B6 - B16 ∗ B7 
C)MIN(B15,B5)∗ B6 + B16 ∗ B7 
D)MAX(B15,B5)∗ B6 + B16 ∗ B7

Quizplus · Accepted Answer

A18 represents the revenue from the economy car rental bookings, which equals the minimum between the total economy car demand (B15) and the available economy cars (B5) multiplied by the economy rental rate (B6) and subtracted by the cancellations of economy car bookings (B16) multiplied by the economy cancellation penalty (B7). Therefore, the formula to calculate A18 will be represented as MIN(B15,B5)*B6-B16*B7 in B18.

The Following Spreadsheet Shows Demand and Booking Data for Toretto