Chapt. $4-$ Questions & Problems: Problem #$4,$ pg$.174-175.$

$1.$ For this problem, you will graph the constraints, shade the feasible region and use excel to calculate the optimal solution from the graph as was demonstrated in the instructor's learning resource from week $5.$

$2.$ Set up this problem in a separate excel spreadsheet, based on your reading and the example presented to you by the instructor.

$3.$ After you setup this problem, use solver to generate the optimal solution as well as a sensitivity report. compare your results to the graphical analysis.

$4.$ Compare the solution results for the graphical solution and solver.