Level 2 Sprint 2 2.3.10
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!