You have been given the following linear programming model and Excel spreadsheet to solve this problem. What formulas should be entered into cells E$5$ and D$8$:D$10$ to implement this model?

MAX: $2$ X$1+7$ X$2$

Subject to: $5$ X$1+9$ X$2<=90$

$9$ X$1+8$ X$2<=144$

X$2<=8$

X$1,$ X$2>=0$

A B C D E

$1$

$2$

$3$ X$1$ X$2$

$4$ Number to make: OBJ. FN$.$ VALUE

$5$ Unit profit: $27$

$6$

$7$ Constraints: Used Available

$815990$

$9298144$

$103018$

$7.$ In question $6,$ what cell references would you enter in Solver for the following?

Objective Cell:

Variables Cells:

Constraints Cells: