You Have Been Given the Following Linear Programming Model and Excel

question 13

Essay

You have been given the following linear programming model and Excel spreadsheet to solve this problem. What formulas should be entered into cells E5 and D8:D10 to implement this model?
$$\begin{array} { l l } \text { MAX: } & 4 X _ { 1 } + 3 X _ { 2 } \\\text { Subject to: } & 6 X _ { 1 } + 7 X _ { 2 } \leq 84 \\& X _ { 1 } \leq 10 \\& X _ { 2 } \leq 8 \\& 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: } & 4 & 3 & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & 6 & 7 & & 84 \\\hline 9 & 2 & 1 & 0 & & 10 \\\hline 10 & 3 & 0 & 1 & & 8 \\\hline\end{array}$$

---

Definitions:

Mercury

A chemical element with symbol Hg and atomic number 80, known for being a liquid metal at room temperature and for its toxicity.

Cerebrospinal Fluid

A clear, colorless body fluid found in the brain and spinal cord, it acts as a cushion for the brain's cortex, providing basic mechanical and immunological protection to the brain inside the skull.

Amphetamine

A potent central nervous system stimulant used to treat attention deficit hyperactivity disorder (ADHD) and narcolepsy, and recreationally as a performance enhancer and euphoriant.

Blood-Brain Barrier

A selective permeability barrier that protects the brain from foreign substances in the blood that may injure the brain.