Revenue Distribution Help

S-Blaeser · 2024-04-22T20:51:50+00:00

There was an error rendering this rich post.

Hello all ,

I am trying to find the best way to distribute forecasted revenue across multiple periods based on a distribution chart (so to say). I will attach screen shots to better explain.

Each month has a forecasted value:

Each month's forecasted revenue will be allocated based on this chart: Period 1 would correspond to the first value that revenue is multiplied by.

This is the calculation that I would like Anaplan to conduct:

The result I am looking for :

I need some help on how I should dimension this and the best way to solve this in Anaplan. Any suggestions or ideas are greatly appreciated! Thanks!

Accepted answers

PujithaB

Hi @S-Blaeser

In this scenario, basically you need cumulative value of last all months with existing month.
It can be achieved as below.
Forecasted Amount —- This is by Month
Percentage value——This is by Month

Forecasted with Percentage value —- This is by month and Formulate as Forecasted Amount * Percentage value.
Cumulate period count ———This is by Month and each month will have 1, 2, 3, 4, corresponding and will reset as 1 for next year ——-Formula——-if previous (Cumulate period count) = 0 then 1 else if previous(parent(parent(item(time)))) <> (parent(parent(item(time)))) then 1 else 1+

Final forecasted amount —- This is by month and Formula—-Cumulate (Forecasted with Percentage value, false, Cumulate period count)

Let me know if this helps out.

Thanks
Pujitha

HimanshuRaj

@S-Blaeser You can also check Profile formula https://help.anaplan.com/profile-41b5fb84-395b-489f-80be-521add72c581 if you are only interested in Final Total column. It will profile the % spread for each period and cumulate values accordingly and give you total value in your line item

Cheers!!

All comments

PujithaB

Final forecasted amount —- This is by month and Formula—-Cumulate (Forecasted with Percentage value, false, Cumulate period count)

Let me know if this helps out.

Thanks
Pujitha

HimanshuRaj

Cheers!!

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…