You Have Been Given the Following Linear Programming Model and Excel

question 7

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?

$\begin{array}{|l|l|l|l|l|l|} \hline& \mathrm{A} & \mathrm{B} & \mathrm{C} & \mathrm{D} & \mathrm{E} \\\hline 1 & & & & & \\\hline 2 & & & & & \\\hline 3 & & \mathrm{x}_{1} & \mathrm{X}_{2} & & \\\hline 4 & \text { Number to make: } & & & & \begin{array}{l}\text { OBJ. FN. } \\\text { VALUE }\end{array} \\\hline 5 & \text { Unit profit: } & & & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & & 1 & & 8 \\\hline 9 & 2 & 8 & 5 & & 80 \\\hline 10 & 3 & 3 & 5 & & 60 \\\hline\end{array}$

---

Definitions:

Stress Hormone

Hormones, such as cortisol, released into the body in response to stress, affecting various bodily functions including the immune response.

Epinephrine

A hormone and medication also known as adrenaline, involved in the body's fight-or-flight response.

Thyroxin

A hormone produced by the thyroid gland, crucial for regulating metabolism and influencing the growth and development of the body.

Prolactin

A hormone produced by the pituitary gland that plays essential roles in lactation and fertility in mammals.