Question: Figure 1: A B C D E F G 1 X1 X2 X3 2 3 5 3 4 4 Constraints 5 Constrain 1 3 5

Figure 1: A B C D E F G 1 X1 X2 X3 2 3 5 3 4 4 Constraints 5 Constrain 1 3 5 1 <= 40 6 Constraint 2 4 2 2 <= 45 7 Constraint 3 2 1 0 >= 15 8 Constraint 4 0 4 -2 >= 2 9 Constraint 5 1 5 -1 <= 25 10 LHS Sign RHS Figure 1 demonstrates an Excel spreadsheet that is used to model the corresponding linear programming problem, which is a maximization problem. Note: Cells B2:D2 are the designated cells for the optimal values of X1, X2, and X3, respectively, while cell E3 is the designated cell for the objective function value. Cells E5:E9 designate the left-hand side of the constraints.

Refer to Figure 1. Which of the following is an incorrect formula for the specified cell?

A. cell E5: = SUMPRODUCT(B5:D5 , $B$2:$D$2)

B. cell E6: = SUMPRODUCT(B6:D6 , $B$2:$D$2)

C. cell E8: = B8*B2 + C8*C2 + D8*D2

D. cell E3: = SUMPRODUCT(B3:D3 , $B$2:$D$2)

E. cell E7: = SUMPRODUCT(B7:D7 , $B$1:$D$1)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!