Soldato
i am trying to use scenario manager to create scenarios for business forecasting.
I need to generate a model for the next two years, based on this years data.
I have two variables, buying price and selling price/quantity, they could increase/decrease by a percentage in either year.
E.g. in 2016 the buying price could increase and the selling price could increase.
in 2017 the buying price could decrease and the selling price could increase.
another scenario
2016 - buying decreases selling decreases
2017 - buying increases selling decreases.
Therefore there are potentially 16 combinations of what each buying and selling price could be in a given year.
Is there a way I can automate this in excel and add the numbers into scenario manager?
I need to generate a model for the next two years, based on this years data.
I have two variables, buying price and selling price/quantity, they could increase/decrease by a percentage in either year.
E.g. in 2016 the buying price could increase and the selling price could increase.
in 2017 the buying price could decrease and the selling price could increase.
another scenario
2016 - buying decreases selling decreases
2017 - buying increases selling decreases.
Therefore there are potentially 16 combinations of what each buying and selling price could be in a given year.
Is there a way I can automate this in excel and add the numbers into scenario manager?
Last edited: