You Have Been Given the Following Linear Programming Model and Excel

question 50

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|c|c|c|c|} \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: } & 8 & 5 & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & 3 & 5 & & 54 \\\hline 9&2 & 1 & 1 & & 14 \\&& 1 & 0 && 4 \\\hline 10 & 3 & 1 & 0 & & 12 \\\hline\end{array}$

---

Definitions:

Self-Determination

The ability or process of making one's own decisions without influence from outside forces.

Meaning

The significance or understanding that is attached to something, such as a word, sign, symbol, or gesture, in communication.

Natural Work Units

Organizational divisions or groupings that reflect a logical segmentation of work based on process, function, or customer, facilitating team coherence and effectiveness.

Task Identity

The degree to which a job involves completing a whole, identifiable piece of work from start to finish with a visible outcome.