$(3$ Points$)$ In cell B$3,$ use the Excel$$s built$-$in function named $$SUMPRODUCT$$ to write

a formula for the objective function. Be sure to reference the appropriate cells.

b$.(4$ Points$)$ In cells B$9$:E$9,$ enter the investment return coefficients for the objective function.

Make sure the coefficients are input as proportions, not percentages.

c$.(8$ Points$)$ In cells B$12$:E$19,$ enter the constraint coefficients for each of the eight

constraints.

d$.(4$ Points$)$ In cells H$12$:H$19,$ enter the appropriate constraint right$-$hand side values.

e$.(8$ Points$)$ In cells F$12$:F$19,$ use the $$SUMPRODUCT$$ function to write a formula for the

constraint left$-$hand side values. Be sure to reference the appropriate cells.

f$.(5$ Points$)$ In cells G$12$:G$19,$ write the type of inequality associated with each constraint

using either $<=,>=,$ or $=.$

h$.(7$ points$)$ Setup Excel Solver to use it to solve the model for the maximum return. Keep

the optimal solution returned by Solver in the model.