2.3.10 Activity: Create Demand Forecast

IF 'SYS01 Time Settings By Week'.Current Period? THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE 52

Baseline Forecast formula

Screenshot 2022-07-18 at 12.56.52 AM.png

 'DEM02 Volume Growth Rates by Week'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product Family]

Growth % formula 

Baseline Forecast * (1 + Growth Rate %)

Default forecast formula 

Intial Demand Forecast formula correct Plz help

Tagged:

Comments

  • @Vibhas 

    You're close, very close. Let's take a closer look at that first formula.

    JaredDolich_0-1658089527355.png

    • Any time you use a conditional statement, you always want to use the most likely case first so Anaplan will exit the calculation sooner. This helps with optimization. So use the NOT statement.
    • If the first condition is met (not the first forecast year) then it must be the second forecast year and we need to move the first year forecast forward 52 weeks. We use the LAG function to do this.
    • To be safe, use the STRICT variable in the LAG function to ensure you don't apply this function if the calendar falls outside the range.
    • If the week is in the first forecast year then lets grab the historic volumes that we set up in DAT03.

    IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN LAG(Default Forecast, 52, 0, STRICT) ELSE 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year'