Forecasting assumptions is yearly but need monthly for modelling

4 posts / 0 new
Last post
Cornell Tsiang 1 X 3
CT
Forecasting assumptions is yearly but need monthly for modelling

Hello

I am using the single entity model (COA4) with budgeting and scenario. Historical data is very limited, only 2 months. I've had to alter the amount of available historical data a few times.  I noted that when entering the assumption data, that the default is Y-o-Y growth. And indeed, the model only forecasts for the 2 months of historical data provided.

Is there a way to alter this so that I can have monthly forecasts.

Thanks

Cornell

Jun Yan A+ 124

Hi Cornell,

The YoY growth is the standard driver that goes into the model.

If you're using the variable drivers content, you should be able to right click the row and select a new driver option.

For example, given there's only 2 months of historical, you may want to address it by selecting the Growth Rates driver, which will allow you to input Month on Month growth.

Alternatively, you can pop in amounts / units x prices, which might be more relevant if they're in early stages of sales.

Hope that helps.

Jun

Cornell Tsiang 1 X 3
CT

Thanks Jun!

It works!  I wasnt so familiar with the new edition of Modano.

dennisjohn2023 X 1
PS

Thank you for helping me out as well, you made my day :)