How to Solve Linear Programming in Spreadsheet. ... Click the "Solve" button. Excel computes the optimal values for your objective formula's variables (e.g., 19 widgets and 1 gadget).

Solver is a linear programming / analysis tool for Excel that was included with Excel 2004 as an add-in, but dropped from Excel 2008 since it required Visual Basic for Applications (VBA).

As the title suggests, I have a problem in which I need to formulate an LP model. I'm supposed to work in Excel and use the Solver Add-in feature.I've done several other problems already, but this ...