as shown below. Please note the following:$1.$The Solver Add$-$in is needed. Activate it the same way the Analysis ToolPak is added. $2.$The SUMPRODUCT$()$ function should be used$\mathrm{.}3.$The design$/$setup of the presentation of the problem in Excel is completely up to you and does not have to be the same as in Figure $6\mathrm{.}6,$ but it should be a clear structure that helps the reader understand what is being done and makes it easy for you to implement the SUMPRODUCT$()$ function. I have provided what I have done for this problem on the bottom of this page. You can see that it looks a bit different from Figure $6\mathrm{.}6.$