Working with multiples scenarios: A market’s segment exists, in which we want to enter with our star product but according to our investigations of the market there are others competitors who wish to be in and the future competitors who exist already in this market are spreading out and will invest more in order to cover the demand; the market is very attractive so the new demand exists.Our market investigation’s department has elaborated the following box from market participation’s prognosis translated in sold units and it is in function of the participation of our competitors.
|
|
We can sell: |
Our department is still investigating about the impact that maybe could work so then previous alternatives could be combined but at the moment a scenarios box to be able to represent all these results quickly and to be able to “play” with possible values of price and costs.
|
Sold units |
100.000,00 | |
To build these scenarios, the following has been made:
1. Model Analyzer for Excel has been downloaded and installed.2. A help tool of construction of scenarios has been used, named Scenarios sheet wizard, from Multiple Scenarios Manager.3. The inputs are the ranges: D26:D28 4. The outputs are the ranges: D30, D31 y D33 5. The scenarios have been taken from the range B14:B19 Then “Go” button has been pressed from the sheet that is created and then they got amazed with the results, they see the tool is intuitive, easy to use, fast, transmit ideas and of course your model has not been altered.
Moreover this table allows you to play with prices and costs if you want.
JABSOFT is a company specialized in the development of decision analysis software and solutions to empower individuals and organizations to make better decisions. Customized applications and software, such as Excel Add-Ins, Financial Calculators and Excel Modeling Tools. Find us at : www.jabsoft.com
