You Have Been Given the Following Linear Programming Model and Excel

question 72

Essay

You have been given the following linear programming model and Excel spreadsheet to solve this problem. What cell references would you enter in the Risk Solver Platform (RSP) task pane for the following?
Objective Cell:
Variables Cells:
Constraints Cells:
$$\begin{array} { l l } \text { MAX: } & 12 X _ { 1 } + 9 X _ { 2 } \\\text { Subject to: } & 9 X _ { 1 } + 10.5 X _ { 2 } \leq 126 \\& X _ { 1 } \geq 5 \\& X _ { 2 } \geq 6 \\& X _ { 1 } , X _ { 2 } \geq 0\end{array}$$ $$\begin{array} { | c | c | c | c | c | c | } \hline & \text { A } & \text { B } & \text { C } & \text { D } & \text { E } \\\hline 1 & & & & & \\\hline 2 & & & & & \\\hline 3 & & \mathrm { X } _ { 1 } & \mathrm { X } _ { 2 } & & \\\hline 4 & \text { Number to make: } & & & & \text { OBJ. FN. VALUE } \\\hline 5 & \text { Unit profit: } & 12 & 9 & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & 9 & 10.5 & & 126 \\\hline 9 & 2 & 1 & 0 & & 5 \\\hline 10 & 3 & 0 & 1 & & 6 \\\hline\end{array}$$

---

Definitions:

Muscle Spindle

A sensory receptor located within muscle, which detects changes in muscle length and tension.

Stretch Reflex

A muscle contraction in response to stretching within the muscle, functioning as a feedback mechanism to maintain muscle tone.

Golgi Tendon Organ

Proprioceptive nerve ending in a tendon.

Homeostatic

Relating to homeostasis, the process by which living organisms regulate their internal environment to maintain a stable, constant condition.