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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started