What tool do you use to forecast PS revenue?

Elise Rairat

Hi,

I was wondering what tool do you use to forecast PS revenue in an agile way ?

thanks

Jerome Peck

@Gayle Lassen and @Eileen Looi Do you have any ideas for Elise?

Steven Forth

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

• Maximum
• Mean (sometimes Median)
• Minimum