• 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 optimal 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 optimal 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. Using Solver with Gantt charts is discussed later in this section.

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 might need the Office 2003 CD, depending on how you installed the software.)



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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