Steven ForthManaging PartnerFounding Partner| Expert ✭✭✭
We frequently need to model the impact of a change in pricing on revenue and volume. This is different from your challenge but there may be some useful pointers.
(i) Model the supply demand relationship and explore. We have our own tool for this.
(ii) Create a set of scenarios we want to plan for.
(iii) Run a Monte Carlo simulation for each scenario
That gives a rich understanding, but usually too rich for the finance people so,
(iv) Simplify the above range of possibilities into three numbers
Answers
@Gayle Lassen and @Eileen Looi Do you have any ideas for Elise?
We frequently need to model the impact of a change in pricing on revenue and volume. This is different from your challenge but there may be some useful pointers.
(i) Model the supply demand relationship and explore. We have our own tool for this.
(ii) Create a set of scenarios we want to plan for.
(iii) Run a Monte Carlo simulation for each scenario
That gives a rich understanding, but usually too rich for the finance people so,
(iv) Simplify the above range of possibilities into three numbers