9781118041581

Set Target Cell:

Solver Parameters?

$F$7

$B$7

Equal to:

By Changing Cells:

Subject to Constraints:

Add

Change

Delete

Solve

Close

Options

Max Min

Set Target Cell:

Solver Parameters?

$F$7

$B$7

Equal to:

By Changing Cells:

Subject to Constraints:

Add

Change

Delete

Solve

Close

Options

Max Min

$C$7 ≤ 91

TABLE 2A.2

Optimizing a Spreadsheet

76 Special Appendix to Chapter 2 Optimization Using Spreadsheets

c02OptimalDecisionsUsingMarginalAnalysis.qxd 8/17/11 5:17 PM Page 76