Level 2 Sprint 2 2.3.10

LaurensCoene
LaurensCoene
in Academy Discussions

Hi, as a result for the first question (2.3.10) I have the answer 71.34 but it should be 73.48. I don't seem to understand where I made a mistake. Could anyone help me out please?

 

- DEM01 screenshot 1 (DEM01)

 

- DEM02 screenshot 2 (DEM02)

 

- DAT03 screenshot 3 (DAT03) - Formula:

IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0

 

- DEM03 screenshot 4 (DEM03) - Formula:

 

-- Baseline Forecast: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' ELSE OFFSET(Baseline Forecast, -52, 0)

 

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

 

-- Default Forecast: Baseline Forecast + Baseline Forecast * Growth Rate %

 

-- Initial Demand Forecast: ROUND(Default Forecast, 0, UP)

 

Thanks for your help!

Tagged:

Comments

  • Misbah
    Misbah

    @LaurensCoene 

     

    For Baseline Forecast try this formula 

     

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

     

    You also may have to replace - (Not sure if that' s the followup exercise though)

    • OFFSET with LAG
    • -52 with 52
    • Add STRICT the fourth parameter in your syntax

    Hope that helps

    Misbah

    Miz Logix

  • LaurensCoene
    LaurensCoene

    Got it with your first hint. Thanks a lot!

  • brianperez
    brianperez

    Thanks so much for this question. Helped me out!

Categories