Microsoft Office Tutorials and References
In Depth Information
Chapter 34: Beyond the Goal Seek—More Than One Changing Cell? Use the Solver
You can try and add one more constraint. For example, limit the units sold
to 54,000 units (imagine a maximum production capacity for instance), and add a
new changing cell, say reduce the marketing budget to achieve a breakeven. See
Figure 34.10.
The final solution says that in order to breakeven with these constraints, you
have to sell 54,000 units at $21.00 a piece. Additionally, the marketing expense has
to be reduced to $224,000.
FIGURE 34.9 Solver Results
FIGURE 34.10 Solver Results
Search JabSto ::

Custom Search