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 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 minimum total cost in cell B11 in this case would be: =if(D4