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}$

Question

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}$

Quizplus · Accepted Answer

The Answer of 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}$

You Have Been Given the Following Linear Programming Model and Excel