I don't know how it happened but my model does not match the 'Check your work' screenshot. Specifically, the Default Forecast is not calculating the same, which makes the Initial Demand Forecast incorrect. Then there is the issue of the Initial Demand Forecast not updating in 2021.
Solved! Go to Solution.
Formula in Default forecast line item is wrong. You have added the growth rate to baseline when you should be uplifting the baseline with 1%.
So the formula in default forecast should be
Baseline * ( 1 + Growth rate)
and Not
Baseline + Growth rate
Hope that helps
Misbah
Formula in Default forecast line item is wrong. You have added the growth rate to baseline when you should be uplifting the baseline with 1%.
So the formula in default forecast should be
Baseline * ( 1 + Growth rate)
and Not
Baseline + Growth rate
Hope that helps
Misbah
Yes! I thought I put parenthesis and didn't! Thank you!