This problem is based on Motorola’s online method for choosing suppliers. Suppose Motorola solicits bids from five suppliers for eight products. The list price for each product and the quantity of each product that Motorola needs to purchase during the next year are listed in the file P06_93.xlsx. Each supplier has submitted the percentage discount it will offer on each product.

These percentages are also listed in the file. For example, supplier 1 offers a 7% discount on product 1 and a 30% discount on product