O'Reilly logo

Business Analytics with Management Science Models and Methods by Arben Asllani

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

B. A Brief Tour of Solver

Real-life problems are sometimes larger and more complex than those offered in this book. They might offer hundreds or even thousands of decision variables and constraints. However, the methodology is similar no matter the size of the problem. The following steps can be followed to solve LP models with Excel Solver:

1. Set up constraints and the objective function in Solver.

2. Select Solver options.

3. Generate the solution.

4. Analyze the results.

Setting Up Constraints and the Objective Function in Solver

Typically, Solver is not installed by default when Excel is first set up. To add Solver to the Tools menu, perform the following steps:

1. Select File -> Options -> Add-Ins.

2. In the Add-ins window, choose Manage: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required