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 formulas should be entered into cells E5 and D8:D10 to implement this model?
$$\begin{array} { l l } \text { MAX: } & 4 X _ { 1 } + 3 X _ { 2 } \\\text { Subject to: } & 6 X _ { 1 } + 7 X _ { 2 } \leq 84 \\& X _ { 1 } \leq 10 \\& X _ { 2 } \leq 8 \\& X _ { 1 } , 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: } & 4 & 3 & & \\\hline 6 & & & & & \\\hline 7 & \text { Constraints: } & & & \text { Used } & \text { Available } \\\hline 8 & 1 & 6 & 7 & & 84 \\\hline 9 & 2 & 1 & 0 & & 10 \\\hline 10 & 3 & 0 & 1 & & 8 \\\hline\end{array}$$