Update Available We've made some fixes and improvements. To complete the process, the app needs to restart.

To use Excel's Solver for computing the number of pairs of shoes for each of the three models refer to Excel hints section on the instructions worksheet.

Cell I Hint:

G$20$ I Use the function $=$SUMPRODUCT$()$ to calculate total contribution margin. Note that cell G$20$ is zero while all pairs of shoes are zero. Once Solver solves for the

optimum number of shoes that will maximize total contribuition margin, G$20$ will be updated with the new Total contribution margin. The Solver solution maximizes

contribution margin in cell G$20,$ by changing the number of pairs of shoes sold $($C$17,$ D$17,$ E$17),$ using the constraints in columns J and K$.$ A copy of the Solver window.

Instructions

ENTERANSWERS