Figure 1:

Figure 1 Demonstrates an Excel

question 9

Multiple Choice

Figure 1:

Figure 1 demonstrates an Excel spreadsheet that is used to model the following linear programming problem:
$$\begin{array} { l l } \operatorname { Max } : & 4 \mathrm { X } _ { 1 } + 3 \mathrm { X } _ { 2 } \\\text { Subject to: } & \\& 3 \mathrm { X } _ { 1 } + 5 \mathrm { X } _ { 2 } \leq 40 \\& 12 \mathrm { X } _ { 1 } + 10 \mathrm { X } _ { 2 } \leq 120 \\& \mathrm { X } _ { 1 } \geq 15 \\& \mathrm { X } _ { 1 } , \mathrm { X } _ { 2 } \geq 0\end{array}$$
Note: Cells B3 and C3 are the designated cells for the optimal values of X₁ and X₂,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)
• E)=SUMPRODUCT(B9:C9,B5:C5)

---

Definitions:

Jejunostomy Feeding

The provision of nutrition directly into the jejunum (part of the small intestine) through a surgically created opening known as a jejunostomy.

Diarrhea

A condition characterized by the frequent passage of loose or watery stools, often a symptom of infection or digestive issues.

Urine

A liquid waste product produced by the kidneys and excreted through the urinary tract, composed of water, salts, and urea.

Diabetes

A chronic condition characterized by high levels of sugar in the blood, due to the body's inability to produce or properly use insulin.