D 5 6 E C B C 1 1.2 #11 2 3 results after using Excel's Solver tool: 4 Decision variables: A B 1 0 1000 8 2 0 0 800 9 Components 10 11 12 Cost of seed ($) 21000 13 14 Constraints LHS RHS slack/surplus 0 15 Limited Capacity supplier A 0 0 = 16 Limited Capacity supplier B 1000 17 Limited Capacity Supplier C 800- 800 18 Need for Component 1 1000 19 Need for Component 2 1000 >>= 800 800 0 20 21 22 What is the Optimal Solution for HW 1.2 Question #11? O Purchase 1000 Units of component 1 from Supplier B and 800 Units of component 2 from Supplier C O Spend $800 for B and $1000 for C O Spend $1000 for B and $800 for C $21,000 F Suppliers 0 ooooo G 0 H