Do these for me asap

83. This problem is based on Motorolas online method for choosing suppliers. Suppose Motorola solicits bids from tive 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 PO6 93.xlsx. Each supplier has submitted the percentage discount it will offer on ouch 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 2 The following considerations also apply: There is an administratie cost of $5000 associated with setting up a supplier's account. For example, it Mctorolaj uses three suppliers, it incurs an administrative cost of $15,000 To ensure reliability, no supplier can supply more than 80% of Motorolas demand for any product. A supplier must supply an integer amount of each product it supplies. Develop a linear Integer model to help Motorola minimize the sum of As purchase and administrative costs. Data F G A B D E 1 Motorola supplier selection problem 2 3 List prices and quantities to purchase 4 Product List price Quantity 5 1 $40 592 6 2 $98 446 7 3 $51 548 8 4 $83 647 9 5 $55 245 10 6 $87 797 11 7 $63 603 12 8 8 $96 401 13 14 Percentage discounts offered by suppliers (along top) on products (along side) 15 Product supplier 1 1 2 3 4 4 5 5 16 1 27% 29% 30% 60% 6% 17 2 31% 25% 10% 13% 30% 18 3 23% 32% % 15% 60% 9% 19 4 6% 21% 18% 60% 28% 20 5 17% 18% 6% 8% 31% 6 7% 22% 25% 34% 35% 22 7 30% 18% 18% 31% 26% 23 8 21% 30% 34% 12% 14% 24 25 21 Covou 26