• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 32.  Testing Multiple Solutions ... > Using Multiple Scenario Sets

Using Multiple Scenario Sets

The scenarios you have seen in the previous examples present a simplified view of a planning situation. In the example, growth rates for costs and expenses vary independently of the growth rate of sales. In reality, however, costs are related to the level of sales. The values in rows 8 through 10 are the product of the current year's sales and reflect the appropriate percentage. To help reflect these complex dynamics, Version 97 of Excel enables you to have more than one set of scenarios on a worksheet at a time.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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