B 1 1.2 #11 234 3 results after using Excel's Solver tool: Decision variables: 9 D...

Transcribed Image Text:

B 1 1.2 #11 234 3 results after using Excel's Solver tool: Decision variables: 9 D E F G H 10 669190123456789 11 12 13 14 Constraints 15 Limited Capacity supplier A A B C Suppliers 1 0 1000 0 2 0 0 800 Components Cost of seed ($) 21000 RHS slack/surplus LHS 0 = 1000 0 800>= 800 0 18 Need for Component 1 1000 >= 1000 0 19 Need for Component 2 800 B 1 1.2 #11 234 3 results after using Excel's Solver tool: Decision variables: 9 D E F G H 10 669190123456789 11 12 13 14 Constraints 15 Limited Capacity supplier A A B C Suppliers 1 0 1000 0 2 0 0 800 Components Cost of seed ($) 21000 RHS slack/surplus LHS 0 = 1000 0 800>= 800 0 18 Need for Component 1 1000 >= 1000 0 19 Need for Component 2 800