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:

Adversity

A state of hardship, difficulty, or misfortune that one must manage or overcome.

Demanding

Requiring much time, attention, effort, or patience; often refers to people or tasks that are challenging and insist on high standards.

Authoritative

A parenting style characterized by high demand and high responsiveness, combining clear expectations with emotional support.

Responsive

Being quick to react or respond positively or supportively to stimuli or actions.