Answer Happy

Ingredient Blending 1 Excel Solver Computer Project The Organic Nutrition uses three bulk grains, A, B, and C, to blend a natural cereal that It sells by the pound. The cost of each bulk grain is indicated in the table below, along with the units of four types of nutrient (Nutrient 1, 2, 3, and 4) that is contained in each pound of the grains. After consulting with the nutritionist, Organic Nutrition has determined that each pound serving of the cereal should contain 24 units of Nutrient 1, 16 units of Nutrient 2, 8 units of Nutrient 3, and 3.4 units of Nutrient 4. Grain A Grain B Grain C Nutritionist's requirement Nutrient 1 22 28 21 24 Nutrient 2 16 14 25 16 Nutrient 3 8 7 9 8 Nutrient 4 5 0 6 3.4 33 47 38 Cost per pound of grain (cents) Organic Nutrition wishes to decide how to blend the three types of grain in order to minimize the total cost of each pound of the cereal. (a) Formulate a linear programming model for this problem. (16) (b) Set up a spreadsheet model for this problem and use the Excel Solver to find the optimal solution. (40) (c) State the optimal solution and the value of the objective function. (4) End of assignment Total marks = 60 Full marks = 60