DEM 03 Baseline forecast formulas

Options
RoyaGolchay
RoyaGolchay
in Academy Discussions

Hi,

I am trying to write formulas for this activity:

RoyaGolchay_0-1666078705879.png

Here is what I am doing:

RoyaGolchay_1-1666078765275.png

RoyaGolchay_2-1666078797901.png

 

But the results are nor correct,

How should I change the formulas and/or summary methods?

Thanks

Tagged:

Comments

  • Misbah
    Misbah
    Options

    @RoyaGolchay 


    1. Default Forecast Line item has to be Baseline Forecast * (1+Growth Rate)

    2. Growth Rate has to be Closing Balance on Time for Summary methods.

     

    Hope that helps

    Misbah

    Miz Logix

  • RoyaGolchay
    RoyaGolchay
    Options

    It works for default forcast. Thanks. But I dont understand why to +1 in this formulas: Baseline Forecast * (1+Growth Rate)

     

    And it is not still working correctly for Initial demand forecast. The result for specific item should be 90 but mine is 88. It seems that ROUND doesnt work correctly.( default forecast is 87.46)

  • RoyaGolchay
    RoyaGolchay
    Options

    I think as we have 2 forecast year and the wrong amount is for second one I need to make changes in baseline forecast formulas

  • Misbah
    Misbah
    Options

    @RoyaGolchay 


    For Default Forecast it has to be uplifted, thats why 1 in the formula. For example if the baseline is 100 and you want to uplift it by 1% you can not multiply 100 with 1 that is going to be give you 1 as result. Expectation is to have 101 in the result which can be achieved only when you say Baseline Forecast + Baseline Forecast * Growth Rate or Baseline Forecast(1+ Growth Rate). That's Math!

     

    For this one, please check your numbers in the Baseline Forecast Line and verify if those numbers are right

     

    Misbah

    Miz Logix

Categories