Suppose Jack like to solve the following formulation in Excel. Min: 2X +3X Subject To: 2X...

 

Transcribed Image Text:

Suppose Jack like to solve the following formulation in Excel. Min: 2X₁ +3X₂ Subject To: 2X₁ + X₂ 23 4X₁ +5X₂220 2X₁ +8X₂ 2 16 5X₁ +6X₂ ≤60 X1, X₂ 20 And the problem is setup in Excel like this: 1 2 decision variable 3 coefficient of objective function 4 Constraints 5 Constraints 1 6 Constraints 2 7 Constraints 3 A 8 Constraints 4 a. =max(B2:C2,B3:C3) O b. sumproduct(B2:C2,B3:C3) Oc=B1 B3+C1 C3 O d. either b or c. X1 B 2 2 4 2 X2 с 3 11 5 D objective LHS E 60 We want to put our objective function in cell D3. What should we type in D3? RHS 3 20 16 Suppose Jack like to solve the following formulation in Excel. Min: 2X₁ +3X₂ Subject To: 2X₁ + X₂ 23 4X₁ +5X₂220 2X₁ +8X₂ 2 16 5X₁ +6X₂ ≤60 X1, X₂ 20 And the problem is setup in Excel like this: 1 2 decision variable 3 coefficient of objective function 4 Constraints 5 Constraints 1 6 Constraints 2 7 Constraints 3 A 8 Constraints 4 a. =max(B2:C2,B3:C3) O b. sumproduct(B2:C2,B3:C3) Oc=B1 B3+C1 C3 O d. either b or c. X1 B 2 2 4 2 X2 с 3 11 5 D objective LHS E 60 We want to put our objective function in cell D3. What should we type in D3? RHS 3 20 16

Answer rating: 100% (QA)

The detailed answer for the above question is provided below The correct answer is d e... View the full answer