Level 2 Sprint 2 2.3.10

LaurensCoene

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!

DEM01_148168.png

DEM02_148168.png

DAT03_148168.png

DEM03_148168.png

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