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?
MIN: ^{8 X}₁^{+ 3 X}₂
Subject to: ^X₂^{≥ 8}
8 X₁+ 5 X₂≥ 80
3 X₁+ 5 X₂≥ 60 X₁,X₂≥ 0
$\begin{array}{|c|c|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: } & & & & \text { OBJ. FN. VALUE } \\\hline 5 & \text { Unit profit: } & & & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & & & &8 \\\hline 9 & 2 & & & & 80 \\\hline 10 & 3 & & & & 60 \\\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?
MIN: ^{8 X}₁^{+ 3 X}₂
Subject to: ^X₂^{≥ 8}
8 X₁+ 5 X₂≥ 80
3 X₁+ 5 X₂≥ 60 X₁,X₂≥ 0

\begin{array}{|c|c|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: } & & & & \text { OBJ. FN. VALUE } \\\hline 5 & \text { Unit profit: } & & & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & & & &8 \\\hline 9 & 2 & & & & 80 \\\hline 10 & 3 & & & & 60 \\\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? MIN: ^{8 X}₁^{+ 3 X}₂ Subject to: ^X₂^{≥ 8} 8 X₁+ 5 X₂≥ 80 3 X₁+ 5 X₂≥ 60 X₁,X₂≥ 0 $\begin{array}{|c|c|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: } & & & & \text { OBJ. FN. VALUE } \\hline 5 & \text { Unit profit: } & & & & \ \hline 6 & & & & & \ \hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\hline 8 & 1 & & & &8 \ \hline 9 & 2 & & & & 80 \ \hline 10 & 3 & & & & 60 \ \hline \end{array}$

You Have Been Given the Following Linear Programming Model and Excel