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

This is a multiobjective question

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 15 Calories 500 450 160 300 500 600 Cost/Pound $4 $5 $3 $7 $6Herrick 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