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:

Sympathetic Nervous

Part of the autonomic nervous system that activates the body's fight-or-flight response.

Parietal Lobes

Regions of the brain located behind the frontal lobes, important for processing sensory information and spatial orientation.

Endocrine Systems

The collection of glands that produce hormones to regulate metabolism, growth, development, and reproduction among other functions.

Epigenetics

The study of how behaviors and environment can cause changes that affect the way genes work, without altering the DNA sequence itself.