$2-17$ Solve the following LP problem by using the graphi$-$

cal procedure and by using Excel:

Minimize cost $=3x+7Y$

subject to the constraints

$9x+3Y36$

$4x+5Y40$

$x-Y0$

$2x,,6$

$x,Y,$

ANSWER: x$=3,$ y$=5\mathrm{.}6,$ objective $48\mathrm{.}20$ Make Unconstrained Variables Non$-$Negative

Select a Solving Method:

Solving Method

Select the GRG Nonlinear engine for Solver Problems that are smooth

nonlinear. Select the LP Simplex engine for linear Solver Problems,

and select the Evolutionary engine for Solver problems that are non$-$

smooth.

PLEASE HELP WITH EXCEL STEP$/$EXPLANATION ON HOW TO GET ANSWER THANK YOU