Excel's Solver add-in provides a simple way to solve problems involving such formulas. Solver works backwards to find optimal inputs to the objectives and constraints you enter.

In Excel 2007, you would denote the problem as linear by clicking the Assume Linear Model under the Options screen. Your final setup should appear as in Figure 1-26. All right!

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 ...