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:

Interpersonal Communication

The process through which people exchange information, feelings, and meaning through verbal and non-verbal messages face-to-face.

Interactional

Relating to or involving the interaction between two or more individuals, often in the context of social relationships or communication.

Participants' Relationship

The connection or interaction between individuals taking part in a study, which can influence the outcomes of the research.

Context

The environment in which communication takes place.