Modeling probleme

SAtrane · 2023-11-07T14:00:50+00:00

There was an error rendering this rich post.

Hi all,

Can you please help me with the following model? I want to create a model to calculate my budget for the next year. Here's the list of components:

List:

Product: Family => Subfamily => KSU
Distribution Network: Global => Distribution Network Local
Brand: Brand X and Y

Input:

Sales history in quantity and revenue (CA) per month
Price for one unit
Forecast per year in quantity

Time:

Anaplan calendar year/month

Version:

Actual
Forecast

Module:

Module 1: Calculation of Forecast per month using the sales history data and applying a seasonality coefficient to adjust the data. The seasonality is not calculated per article but based on a key: Subfamily/Distribution Local/Brand. This means I need the sales data per this key. Please note that Subfamily, Distribution Network Local, and Brand have different hierarchical levels.

I am using the following formula to calculate the forecast in quantity: Forecast of the year * seasonality coefficient of every month.

I am stuck and don't know how to create the seasonality key (Subfamily/Distribution Local/Brand) in Anaplan. Could you please provide your feedback and assistance?"

Thanks in advance.

Accepted answers

All comments

albin

I think you should consult with the person who provided the data to know how seasonality key is calculated/created. It is difficult to decipher the key just from the information provided.

Dikshant

@SAtrane,

To implement the seasonality key (Subfamily/Distribution Local/Brand) in Anaplan, you can follow these steps:

Create a Seasonality Module:
1. Build a new module specifically for seasonality calculations. This module will include line items for Subfamily, Distribution Local, Brand, and the respective seasonality coefficients.
Import Seasonality Data:
1. Import or manually input the seasonality coefficients for each combination of Subfamily, Distribution Local, and Brand. You can structure this data in a separate CSV file and import it into the Seasonality module.
Create a System Module for Key Mapping:
1. Build a system module to map the relationships between Product, Distribution Network, and Brand. Use line items to map the relationships at each level of the hierarchy.
Use LOOKUP Functions for Key Mapping:
1. In the Forecast calculation module, use LOOKUP functions to bring in the seasonality coefficients from the Seasonality module based on the key (Subfamily/Distribution Local/Brand). You'll use the relationships established in the system module to perform these LOOKUPs.
Apply Seasonality in Forecast Calculation:
1. In the Forecast calculation module, apply the seasonality coefficients to the forecast quantity for each month. Multiply the forecast quantity by the respective seasonality coefficient to adjust the data.

Here's a simplified example of what the modules might look like:

Seasonality Module:
- Dimensions: Subfamily, Distribution Local, Brand
- Line items: Seasonality Coefficient
System Module:
- Dimensions: Product, Distribution Network, Brand
- Line items: Subfamily, Distribution Local
Forecast Calculation Module:
- Dimensions: Anaplan Time, Product
- Line items: Forecast Quantity, Adjusted Forecast (using the seasonality coefficients)

By establishing these modules and relationships, you can effectively create and apply the seasonality key in Anaplan for accurate forecast calculations. Adjust the structure and granularity based on your specific model requirements.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…