You Have Been Given the Following Linear Programming Model and Excel

question 63

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: } & 8 X _ { 1 } + 5 X _ { 2 } \\\text { Subject to: } & 3 X _ { 1 } + 5 X _ { 2 } = 54 \\& 11 X _ { 1 } + 10 X _ { 2 } \leq 144 \\& X _ { 1 } \geq 12 \\& 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: } & 8 & 5 & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & 3 & 5 & & 54 \\\hline 9 & 2 & 11 & 10 & & 144 \\\hline 10 & 3 & 1 & 0 & & 12 \\\hline\end{array}$$

---

Definitions:

Aspirin

A medication used to reduce pain, fever, inflammation, and, in low doses, to prevent blood clots.

Advil

A brand of over-the-counter medication commonly used to reduce fever, relieve pain, and lessen inflammation; its active ingredient is ibuprofen.

Motrin

A brand of ibuprofen, a non-steroidal anti-inflammatory drug (NSAID) used to relieve pain, reduce inflammation, and lower fever.

Pick's Disease

A rare form of dementia characterized by progressive and irreversible neurological decline, similar to Alzheimer's disease but with distinct pathological features.