5.Solving a Product Mix Problem using Solver | Optimization using Excel

[@tusseyd]

Using the SUMPRODUCT function to setup the constraints is a great idea. Really saves time.Thanks.

[@classicquants778]

You're welcome!

[@tusseyd]

This is a beautiful and well thought-out way to arrange your Excel spreadsheet for a classic optimization problem. Very helpful. The way you set up the Constraints for easy entry in Solver is quite clever.

[@classicquants778]

Glad it was helpful!

[@shahawalkhair5608]

Explain more what you was fixing. Everything is useless untill you dont expalin properly sumproduct. how you was fixing, i did everything here but finally solver returned nothing.

[@schakraborty336699]

Pause the video at 06:38. It is mentioned how to fix it. You need to keep the cursor on the range C3:E3 and press F4 in your keyboard. This will make it $C$3:$E$3. Now when you copy this down, this will not change