Please show Excel Solver screenshots. This is an integer linear programming question.

Burnside Marketing Research conducted a study for Barker Foods on some designs for a new dry cereal. Three attributes were found to be most influential in determining which cereal had the best taste: the ratio of wheat to corn in the cereal flake, the type of sweetener (sugar, honey, or artificial), and the presence or absence of flavour bits. Seven children participated in taste tests and provided the following part-worths for the attributes.

a. Suppose the overall utility (sum of part-worths) of the current favourite cereal is 75 for each child. What is the product design that will maximize the share of choice for the seven children in the sample? b. Assume the overall utility of the current favourite cereal for the first four children in the group is 70, and the overall utility of the current favourite cereal for the last three children in the group is 80. What is the product design that will maximize the share of choice for the seven children in the sample?

\begin{tabular}{|cccccccc|} \hline \multicolumn{2}{c}{ Wheat/Corn } & \multicolumn{2}{c}{ Sweetener } & & \multicolumn{2}{c|}{ Flavor Bits } \\ Child & Low & High & Sugar & Honey & Artificial & Present & Absent \\ 1 & 15 & 35 & 30 & 40 & 25 & 15 & 9 \\ 2 & 30 & 20 & 40 & 35 & 35 & 8 & 11 \\ 3 & 40 & 25 & 20 & 40 & 10 & 7 & 14 \\ 4 & 35 & 30 & 25 & 20 & 30 & 15 & 18 \\ 5 & 25 & 40 & 40 & 20 & 35 & 18 & 14 \\ 6 & 20 & 25 & 20 & 35 & 30 & 9 & 16 \\ 7 & 30 & 15 & 25 & 40 & 40 & 20 & 11 \\ \hline \end{tabular}