2.3.10 Activity: Create Demand Forecast

SravanKumar
Occasional Contributor

2.3.10 Activity: Create Demand Forecast

As per the below activity information provided, do we need to write the formulas for all the line items in the module or need to write the formula for only Growth Rate % line item?

 

SravanKumar_0-1638506306152.pngSravanKumar_1-1638506359136.png

Can anyone provide clarity on this activity for me?

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

Re: 2.3.10 Activity: Create Demand Forecast

@SravanKumar 

 

For all line items and not just Growth rate%.

 

Baseline Forecast = Data available in one of the DAT modules

Default Forecast = Use Growth Rate and Baseline Fcst to arrive at Default Forecast

Initial DF = Use ROUND function on Default Forecast

 

Hope that helps

Misbah

Miz Logix

View solution in original post

4 REPLIES 4
Misbah
Moderator

Re: 2.3.10 Activity: Create Demand Forecast

@SravanKumar 

 

For all line items and not just Growth rate%.

 

Baseline Forecast = Data available in one of the DAT modules

Default Forecast = Use Growth Rate and Baseline Fcst to arrive at Default Forecast

Initial DF = Use ROUND function on Default Forecast

 

Hope that helps

Misbah

Miz Logix

Dijones128
Contributor

Re: 2.3.10 Activity: Create Demand Forecast

Hello,

 

Can someone help me figure what I am missing in my formula? I've tried several formulas and I don't think is the exact formula I'm suppose to use. 

I'm sharing my formula's and my DEM03 module.

Dijones128_0-1642108279813.pngDijones128_1-1642108314843.png

 

shady10
Contributor

Re: 2.3.10 Activity: Create Demand Forecast

Hi @Dijones128 

We already determined the forecast in the DAT03 Module so you just need to pull the "Offset Volumes for 1st Forecast Year" data

shady10_0-1642191494280.png

 

Dijones128
Contributor

Re: 2.3.10 Activity: Create Demand Forecast

Thank you for your reply, I ended up get my formulas but for some reason all of my data isn’t displaying