2.3.10 Activity: Create Demand Forecast
Hi all,
I'm stuck on this activity, I'm pulling through a 0 value for Default Forecast on Week 6 FY21 and the answer is suppose to be 73.48..
I'm not sure where I'm going wrong, I may have used the wrong formulas in DEM03. Can someone please point me in the direction
Best Answer
-
Hi,
You're almost there. Just two mistakes to fix.
- Syntax error, IF <condition> Then <value> Else IF (missing piece) <condition> Then <value> Else <value>
- Your 'default forecast' lineitem already has growth rate applied on baseline forecast. You just have to use OFFSET upon it, for 2nd year
Cheers!
0
Answers
-
Hi @EJamr ,
Your snapshots show that you have not completed 2.3.9 activity properly. Please make sure you satisfy the instructions given as part of below image:
While 2019 should reflect historical volume, 2020 should respect seasonality and reflect same volume as previous year, and 2021 should be 2020's volume times volume growth%. Use IF THEN ELSE statement and SYS time module, to derive respective baseline forecast for FY20 and remaining forecast years.
Cheers!
0 -
FY20 is the first forecast year, but your formula will return zero for any year except 2nd forecast year. As per shared instructions, the requirement is to return [if 1st forecast year then DAT03.offset volumes else if 2nd forecast year then 'FY20's forecast * volume growth' (you get this from default forecast lineitem) else zero]
Cheers!
0 -
Ok this is great thank you very much
0