** 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. Q Q (:3 Solver Parameters Set Objective: $I$ 15' I To: 0 Max 0 Min 0 Value Of: |:| By Changing Variable Cells: $C$15:$G$15 I Subject to the Constraints: Reset All Load [Save Make Unconstrained Variables Non-Negative Select a Solving Method: Simplex LP a Vitamins Minerals Protein Calories Cost/Pound Dislikeness Decision Variable Objective Function Constraints Vitamins Minerals Protein Calories Seeds 500 $4 62 Raisins 450 $5 51 0.47732697 033412833 10 500 20 450 Flakes 10 10 160 53 42 131851575 10 10 160 Pecans 30 300 Walnuts H J Nutritional Requirements 20 16 2 10 1 15 500 600 $6 30 0 Minimize cost 6 153579952 20 24.6420043 >= 16 2 10 >= 10 1 15 >= 15 500 600 >= 600 - Decision Variables ' S = # of pounds of seeds in package ' R = # of pounds of raisins in package - F = # of pounds of flakes in package 0 P = # of pounds of pecans in package ' W = # of pounds of walnuts in package Formulation - Minimize: 45 + SR + 3F + 7P + 6W - Subject to: 105 + 20R + 10F + 30P + 20W >= 16 (vitamin floor) 55 + 7R + 4F + 9P + 2W >= 10 (mineral floor) 15 + 4R + 10F + 2P + 1W >= 15 (protein floor) 5005 + 450R + 160F + 300P + 500W >= 600 (calorie floor)