• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Using Solver

Goal Seek is an efficient feature for helping you reach a particular goal, but it deals with only a single variable. For most businesses, the variables are much more complex. How can you reach the profit goal if advertising expenses increase? What's the best mix of products to increase sales in the first quarter, when revenues traditionally decline for your business? Which suppliers give you the optimum combination of price and delivery? For problems like these, you can use Solver, an add-in program that comes with Excel. This powerful analysis tool uses multiple changing variables and constraints to find the optimum solution to solve a problem. Previously, Solver was a tool used primarily for financial modeling analysis; however, Solver can be used in conjunction with models of any kind that you build in Excel. Later in this section is a discussion of using Solver with Gantt charts.

Note

Solver isn't enabled by default. To add it to the Tools menu, choose Tools, Add-Ins, select Solver Add-in in the Add-Ins dialog box, and click OK. If asked to confirm, choose Yes. (You'll need the Office 2000 CD.)



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint