Hi,
Is it possible to make adjustments to a forecast at a parent level?
We are looking to layer in adjustments at a high level and then have it allocate below based on the existing child data.
Thanks for the help!
i am not sure how to do this, but am interested to learn
I am unsure of how to make adjustments at a parent level, rather than leaf level.
Could you do this using spreading?
I know that when we have accidentally tried to use a parent level when we are setting budgets there is a pop up box to question how you would like to spread the data.
Providing you are at the correct child level with all other dimensions other than the one you want to spread I think that would be possible.
We budget at the fiscal year level and allow the info to spread based on 2 / 3 year average versions we have set up. We also spread down to the product level in the same manner in the projection.
You can also use process manager to allocate a total amount down to leaf level based on a specific driver. For example, if you have $100K you can put it to an allocation code, lets call this TOTAL. Then you can set a methodology like allocate this $100K using last month’s actuals at individual leafs.
We always do it at the leaf level, Marissa’s comment is interesting though!
We have historically done it at leaf level.
We always do it at the leaf level
Historically, we have handled this at the leaf level. I’m curious to see if others approach it differently.
Not sure if this will be exactly what you are looking for, but you are able to change the “Calculation Definition” in the Model Manager for roll-up accounts for different rule sets. For instance, our account (4004) - Parts Cost of Sales is an aggregate of numerous accounts for our Actual results:
However, for forecasting purposes, the (4004) - Parts Cost of Sales account is an input account, ignoring the aggregate leaf level, meaning we only have to update the one account instead of all of the leaf level accounts. The only drawback to this is you won’t have a forecast for the leaf level, just the parent account. Again, this may not be what you need if you do want the leaf level detail, but this could be a time saver if you don’t need the leaf level detail.
1 Like
You can do budget on parent level but it also depends how much leaf levels would be affected and the number entered would be divided on each leaf level combination depending on page level combination/detail level combinations.
Sorry, I can’t answer this question.
I had no idea. My mind just exploded with this knowledge. Thank-you.
We forecast at the parent level using spreading. The spreading is based on existing data.