Excel 2019 Bible

Chapter 32: Analyzing Data Using Goal Seeking and Solver

3232

TA B L E 3 2 .1 Constraints Summary

Constraint Expressed As

Capacity is 300 units B6<=300

At least 50 units of Product A B3>=50

At least 40 units of Product B B4>=40

No more than 40 units of Product C B5<=40

7. After you enter the last constraint, click OK to return to the Solver Parameters
   dialog box, which now lists the four constraints.


8. For the Solving Method, use Simplex LP.


9. Click the Solve button to start the solution process. You can watch the prog-
   ress on-screen, and Excel soon announces that it has found a solution. The Solver
   Results dialog box is shown in Figure 32.7.

FIGURE 32.7

Solver displays this dialog box when it finds a solution to the problem.

At this point, you have the following options:

■ (^) Keep the solution that Solver found.
■ Restore the original changing cell values.
■ (^) Create any or all of the three reports that describe what Solver did.
■ Click the Save Scenario button to save the solution as a scenario so that Scenario
Manager can use it.