(a) Use Excel's Solver tool to setup (8 points) and solve (2points) the following linear programming model and provide a Sensitivity [Analysis] Report AND CORRECTLY ENTER THE SLACK/SURPLUS FORUMULA FOR EACH CONSTRAINT. (2 points) (b) TYPE YOUR NAME ON THE SPREADSHEET. S Then, on the Excel output, highlight in yellow the cells containing the following items: (1) the optimal product mix and associated cost (4 points) (2) the maximum amount by which the cost per pound of enriched oat could decrease and still have the optimal product mix from (a) be optimal (2 points) (3) the change in cost that would result if one additional pound of weight was available (2 points) Bluegrass Farms, located in Lexington, Kentucky, has been experimenting with special diet for its racehorses. The feed components available for the diet are a standard horse feed product, an enriched oat product, and a new vitamin and mineral feed additive. The nutritional values in units per pound and the costs for the three feed components are summarized in the table below. Ingredient A Ingredient B Ingredient C Cost per pound Standard Enriched Additive Oat 0.8 0.2 0.0 3.0 1.5 1.0 2.0 0.6 0.1 $0.25 $0.50 $3.00 To help Bluegrass Farms make a decision of how many of each product to include such that cost will be minimized, the following linear programming model was developed. Let S # of pounds of the standard horse feed product E=# of pounds of the enriched oat product A=# of pounds of the vitamin and mineral feed additive Min 0.25S+ 0.5E+3A s.t. Ingredient A: Ingredient B: Ingredient C: Weight: 0.8S+0.2E 3 3.0S+1.5E+1.0A 6 2.0S+0.6E+0.1A 4 S+ E+ A 6 S, E, AO