Excel File Edit View Insert Format Tools Data Window Help a. Thu Mar 17 10:18 PM ... AutoSave OFF AP Homework2-2-1 a SP Home - Insert Draw Page Layout Formulas Data Review View Tell me e Share V Comments X Calibri (Body) v Y 11 == Y 2. Wrap Text s General I aw Aw A T 28. Or Paste BTU = = = .00 Insert Marge & Center Conditional Format Cell Formatting as Table Styles Delete Format Sort & Filter Find & Select Analyze Data Y E25 fr B C D E E F G G H I M M N 0 P Q RS TU V W A 1 Buyer's demand Hccepicble to detectivelor 150n 30 5.pplier 1 5.aplier 2 5.pplier3 Supplier 4 $ 10.00 $ 11,00 $ 12.00 $ 13.00 $ S 1000 1000 1000 1000 0.02 0.015 0.01 0.005 In this problem, we assume that a buyer is going to buy a single item from four suppliers to meet its demand that is 1500 units. The suppliers offer different wholesale prices that are $10, $11, $12 and $13, respectively. They also produce defective items and the percentage is 2% for the first supplier, 1.5% for the second supplier, 1% for the third supplier, and 0.5% for the forth supplier. Production capacity for all the suppliers is 1000 units. Assume that the buyer wants to minimize its purchasing cost. Use Solver to solve the problem for this case: acceptable number of defective items is less than 30 units. . The rubric In this problem, you want to 1. minimize the purchasing cost 2. meet the demand 3. incorporate the suppliers' production capacity into your calculation 4. keep number of defective iterns less than 30 units (0.75 point) - 0.375 point for Excel and 0.375 point for Solver (0.75 point) - 0.375 point for Excel and 0.375 point for Solver (0.75 point) - 0.375 point for Excel and 0.375 point for Solver (0.75 point) - 0.375 point for Excel and 0.375 point for Solver S Price 6 Capacity 7 Defective Percetage 8 9 Crder Quantity from they ppler 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 34 35 36 37 38 Factor Rating-3 points Supplier Selection-3 points Ready IT C W + 100% 6,229 17 tv N A