If we had non-linear calculations in the model (perhaps a square root of a decision, a logarithm, or an exponential function), then we could use one of the other algorithms Excel provides in Solver.

Analytics software leader FICO today announced the release of a true global mathematical optimization solver as part of FICO® Xpress 9.2 Optimization.

Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.

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