You Have Been Given the Following Linear Programming Model and Excel

Essay

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: $\quad 8 X _ { 1 } + 3 X _ { 2 }$
Subject to: $\quad X _ { 2 } \geq 8$
$\begin{array} { l } 8 \mathrm { X } _ { 1 } + 5 \mathrm { X } _ { 2 } \geq 80 \\3 \mathrm { X } _ { 1 } + 5 \mathrm { X } _ { 2 } \geq 60 \\\mathrm { X } _ { 1 } , \mathrm { 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: } & & & & \\\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}$$