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

Re: 2.4.4.2 Doesn't match 'Check your work' screenshot

@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

2 REPLIES 2
Misbah
Moderator

Re: 2.4.4.2 Doesn't match 'Check your work' screenshot

@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

bmartino
Occasional Contributor

Re: 2.4.4.2 Doesn't match 'Check your work' screenshot

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