** Please use excel solver and provide formulas***

Herrick Foods has gotten complaints from its customers that its trailmix is rather distasteful. The company conducted a survey and found the \"W3? associated with the ingredients to be as follows: Mmm -_ CI p Assuming that Herrick still needs to meet the nutritional requirements, a. What is the optimal mix when minimizing the "Mm\" index? What is the cost? b. What is a good set of weights to use so that Herrick balances cost minimization and minimization of \"WW? Explain. Data (in grams per pound) Seeds Raisins Flakes Pecans Walnuts Nutritional Requirements Vitamins 10 20 10 30 20 16 Minerals 5 7 4 9 2 10 Protein 1 4 10 2 1 15 Calories 500 450 160 300 500 600 Cost/Pound $4 $5 $3 $7 $6 Dislikeness 62 51 42 25 30 Decision Variable 0.47732697 0.33412888 1.31861575 0 0 Minimize cost Objective Function 4 5 7 6 7.53579952 Constraints Vitamins 10 20 10 30 20 24.6420048 >= 16 Minerals 5 7 4 9 2 10 >= 10 Protein H 4 10 2 1 15 >= 15 Calories 500 450 160 300 500 600 >= 600