Figure 1: X2 3 Number to Make: Unit profit Constraints OBJ. FN. VALUE: S4 $3 Ava

Question

Figure 1: X2 3 Number to Make: Unit profit Constraints OBJ. FN. VALUE: S4 $3 Available 40 120 15 Used 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 S40 12 X1+10 X2 120 X1215 X1, X220 Note: Cells B3 and C3 are the designated cells for the optimal valucs of X1 and X2, respectively, while cell E4 is the designated cell for the objective function valuc. Cells D8:D10 designate the left-hand side of the constraints.

Explanation / Answer

The formula that should be entered in cell D9 to compute the amount of resource 2 is:

a. =SUMPRODUCT(B3:C3,B9:C9)

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.