Co to the Product Line worksheet, which lists three wind turbines that Four Winds Energy produces and sells. Madhu wants to find the product mix that generates the most net income for the company. Use Solver to maximize the percentage of difference between the even and optimal product mixeskcell F$23)$ by changing the optimal product mix $($range C$10$:E$10)$ subject to the following constraints:

The total units sold in the optimal product mix $($cell D$18)$ must be $4,750.$

The company needs to produce $1,200$ or more of each turbine model, so the optimal mix values for each model $($range $C10$:$E10)$ must be at least $1,200.$

Those same values in the range $C10$:$F10$ must be integers.

The Remaining values for each assembled part $($range J$5$:J$13)$ must be greater than or equal to zero because the company cannot produce more wind turbines than the parts avallable.

Run Solver, keep the solution, and then return to the Solver Parameters dialog box. Save the model to the range H$17$:H$24,$ and then close the Solver Parameters dialog box.

Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then exit Excel. Follow the directions on the SAM website to submit your completed project.