You have been given the following linear programming model and Excel spreadsheet to solve this problem.What numbers should be entered into cells B5:C5 and B8:C10 to implement this model?
MAX: ^{4 X}₁^{+ 3 X}₂
Subject to: ^{6 X}₁^{+ 7 X}₂^{≤ 84}
X₁≤ 10
X₂≤ 8 X₁,X₂≥ 0
$\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: } & & & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & & & & \\\hline 9 & 2 & & & & 84 \\\hline 10 & 3 & & & & 10 \\\hline\end{array}$

Question

You have been given the following linear programming model and Excel spreadsheet to solve this problem.What numbers should be entered into cells B5:C5 and B8:C10 to implement this model?
MAX: ^{4 X}₁^{+ 3 X}₂
Subject to: ^{6 X}₁^{+ 7 X}₂^{≤ 84}
X₁≤ 10
X₂≤ 8 X₁,X₂≥ 0

\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: } & & & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & & & & \\\hline 9 & 2 & & & & 84 \\\hline 10 & 3 & & & & 10 \\\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 numbers should be entered into cells B5:C5 and B8:C10 to implement this model? MAX: ^{4 X}₁^{+ 3 X}₂ Subject to: ^{6 X}₁^{+ 7 X}₂^{≤ 84} X₁≤ 10 X₂≤ 8 X₁,X₂≥ 0 $\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: } & & & & \\hline 6 & & & & & \ \hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\hline 8 & 1 & & & & \ \hline 9 & 2 & & & & 84 \ \hline 10 & 3 & & & & 10 \ \hline \end{array}$

You Have Been Given the Following Linear Programming Model and Excel