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. Suppose that a specific vendor's name, ("AAA", "BBB", etc.,) was found in cell B10 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(B10,B4:D7,2,false) =vlookup(B10,A4:C7,2,false) =vlookup(B10,A4:C7,3,false) =vlookup(B10,A4:D7,2,false) None of these answers are correct. Exactly two of the above answers are correct. Eaton Products Vendor Analysis Vendor AAA BBB CCC DDD Units Purchased Minimum Total Cost Fixed Cost Unit Cost Total Cost Vendor $210 $5.00 $140 $6.00 $100 $7.00 $80 $8.00 Mimimum Cost Vendor File Preview Total Cost Vendor Units 10 20 30 40 50 60 65 70 75 80 212223242585R28