2.4.4.2 Doesn't match 'Check your work' screenshot

bmartino
Occasional Contributor

2.4.4.2 Doesn't match 'Check your work' screenshot

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

@bmartino 

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

View solution in original post

3 REPLIES 3
Misbah
Moderator

@bmartino 

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

bmartino
Occasional Contributor

Yes! I thought I put parenthesis and didn't! Thank you! Issue.PNGFixed.PNG

MI1110
Occasional Contributor

Hi @bimartino,

Glad to see that you got the desired result as per the check you work ss.

I need your assistance here, could you please assist me to get the same.

Actually "Override Forecast" line is not getting grad out when Override? is not checked.
Please let me if I am missing any thing .


Thanks,
Mohammed Irfan