Question: use excel , this is OR 2 Question 3 7 points Use Excel (Solver) You won a prize in which you can fill your bad
use excel , this is OR 2
Question 3 7 points Use Excel (Solver) You won a prize in which you can fill your bad with a number of products. Each product has a value and a weight. There is also a limited number of products available to pick. All information are presented in the following table Information/Product A1 A2 811 B22 Value 15 20 5.6 8.2 weight(kg) 1.1 1.6 0.45 0.52 Number available 5 8 2 6 000 The only rule you have is that the weight of your bag cannot exceed 12 KS Find the optimal selection of the bad that will result in the highest total value. Choose all the correct answers: A This is a minimization problem This is a non linear programming problem We need to add 4 constraint for the product availability The value of the optimal value of z = 164.2 Product B11 is not selected in the optimal solution We need to have binary decision variables to solve this
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
