Excel: Sounds Good Page 1 2 3 4 5 6 7 8 9 10 11 12 13

Data -> Data Tools ->What-If Analysis ->Scenario Manger     Scenario Manager 3. Name the first scenario:  Best Case   4. Type: B1 where it says Changing Cells. Remember, B1 is the cell for Initial Sales. 5. When you are done editing the scenario, you will be prompted to Enter a value. Please type in 100. After you click on OK you will return to the Scenario Manager.   Add another scenario for Worst Case and change the quantity for B2 from 100 to 50.