Question: Figure 1 demonstrates an Excel spreadsheet that is used to model the following linear programming problem: Max: 4 X1 + 3 X2 Subject to: 3
Figure 1 demonstrates an Excel spreadsheet that is used to model the following linear programming problem:
Max: 4 X1 + 3 X2
Subject to:
3 X1 +5 X2 40
12 X1 + 10 X2 120
X1 15
X1, X2 0
Note: Cells B3 and C3 are the designated cells for the optimal values of X1 and X2, respectively, while cell E4 is the designated cell for the objective function value. Cells D8:D10 designate the left-hand side of the constraints.
Refer to Figure 1. What formula should be entered in cell D9 to compute the amount of resource 2 that is consumed?
| a. | =B9*D9 + C9*D9 | |
| b. | =SUMPRODUCT(B2:C2,B9:C9) | |
| c. | =SUM(B9:C9) | |
| d. | =SUMPRODUCT(B3:C3,B9:C9 |
wa lake Tesl: Mid Term Exar"-MSIS e Chegy Sludy | Guided Solu lions https://umb.umassonline.net/webapps/assessment take takejsp?course assessment id= 525631 &course id-502801&content id=28465981&qu ::: Apps Movies | HBO NOW Q (hapter 1-M 210 p Deepankar Adhikari D t, Mail . DAdhikar00. rigure 3Number to Make OBJ. FN. VALUE Unit profit S4 $3 Constraints Used Available 40 120 12 10 0 Figure 1 demonstrates an Excel spreadsheet that is used to model the following linear programming problem Max: 4 X1+3 X2 Subject to 3 X1 +5 X2 40 8:10 AM Type here to search 10/30/2018 19
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts