please show using excel solver

Led eBook Burnside Marketing Research conducted a study for Barker Foods on several formulations for a new dn cereal. Three attributes were found to be most influential in determining which cereal had the best taster ratio of wheat to corn in the cereal flake, type of sweetener (sugar, honey, or artificial), and the presence or absence of flavor bits, Seven children participated in taste tests and provided the following part-worths for the attributes (see section 13.4): Wheat/Corn Sweetener Flavor Bits Child Low High Sugar Honey Artificial Present Absent 1 15 35 40 25 15 9 30 20 40 35 35 B 11 2 3 4 40 25 40 10 7 14 & 8 8 8 35 30 5 8 8 8 % 25 30 18 5 25 40 40 35 18 6 20 25 30 16 9 7 30 15 25 40 20 11 (a) Suppose the overall utility (sum of part-wortha) of the current favorite cereali 75 for each child What product design will maximize the number of children in the sample who prefer the nerdry cereal. Note that a child will prefer the new dry cereal only if its overall ulltys at least 1 part- worth larger then the utility of their current preferred cereal Product Designs Wheat/Com Low Sweetener Artificial Flavor Bits Absent Share of Choice (b) Assume that the overall blity of the current favorite creatorens to 4 $ 70 and the overall utility of the current favorite cereal for children 5 to 7h Bo what product design will maxdmise the thare of choice for the seven children in the sample? Product Design: Wheat Com - Select your answer - Sweetener - Select your answer Flavor Bits - Select your answer. Share of Choice Led eBook Burnside Marketing Research conducted a study for Barker Foods on several formulations for a new dn cereal. Three attributes were found to be most influential in determining which cereal had the best taster ratio of wheat to corn in the cereal flake, type of sweetener (sugar, honey, or artificial), and the presence or absence of flavor bits, Seven children participated in taste tests and provided the following part-worths for the attributes (see section 13.4): Wheat/Corn Sweetener Flavor Bits Child Low High Sugar Honey Artificial Present Absent 1 15 35 40 25 15 9 30 20 40 35 35 B 11 2 3 4 40 25 40 10 7 14 & 8 8 8 35 30 5 8 8 8 % 25 30 18 5 25 40 40 35 18 6 20 25 30 16 9 7 30 15 25 40 20 11 (a) Suppose the overall utility (sum of part-wortha) of the current favorite cereali 75 for each child What product design will maximize the number of children in the sample who prefer the nerdry cereal. Note that a child will prefer the new dry cereal only if its overall ulltys at least 1 part- worth larger then the utility of their current preferred cereal Product Designs Wheat/Com Low Sweetener Artificial Flavor Bits Absent Share of Choice (b) Assume that the overall blity of the current favorite creatorens to 4 $ 70 and the overall utility of the current favorite cereal for children 5 to 7h Bo what product design will maxdmise the thare of choice for the seven children in the sample? Product Design: Wheat Com - Select your answer - Sweetener - Select your answer Flavor Bits - Select your answer. Share of Choice