Eaton Products seeks to select the minimum total cost vendor for a product for any order quantity. Each of the four product vendors has an associated fixed order cost along with a per unit product cost. Data are provided in the workbook accompanying this quiz. A possible formula for the total cost for vendor AAA in cell D4 would be:
=B4*B9+C4
=B4+C4*B9
=B4+C4*C9
=B4+C4*$B$9
None of these answers are correct.
Exactly two of the above answers are correct.
