Q$\mathrm{.}1$ aton Products seeks to select the minimum total cost vendor for a product. Each of the four possible vendors provides Eaton with a unit product cost and a fixed order cost. Eaton seeks to choose the vendor that minimizes the total order cost. Data are provided in the workbook accompanying this quiz.

Assume that all formulas above row $15$ have been entered correctly in the cells as indicated by the labels. The formula in cell B$15$ in the data table found in the range from A$15$ to C$30$ is:

$=$B$4*$C$4*$B$9$

$=$min$($D$4$:D$7)$

Exactly two answers are correct.

Q$\mathrm{.}2$ Suppose that a specific vendor's name, i$.$e$.,$ "AAA" or $"$BBB$",$ etc., is entered into cell B$10$ of the spreadsheet. A possible formula for looking up that vendor's unit cost based on the vendor's name as input would be:

$=$vlookup$($B$10,$B$4$:D$7,2,$false$)$

$=$vlookup$($B$10,$A$4$:E$7,3,$false$)$

None of the answers are correct.

Q$\mathrm{.}3$ A possible formula for the total cost for vendor CCC in cell D$6$ would be:

$=$B$6+$C$6+$B$9$

$=$B$6+$C$6*$B$9$

$=$B$6+$C$5*$$B$$9$

None of the answers are correct.