Forecast

Use this forum to post Vensim related questions.
Post Reply
Jindu
Member
Posts: 24
Joined: Thu Mar 21, 2019 3:36 pm
Vensim version: PLE

Forecast

Post by Jindu »

Hi,
I’m trying to forecast the future for example picking the last value of the historical order cycle (in this case 34 being the last value of the historical order pattern) then use it as the start value of the forecast to see the future order pattern. Is there any way I can do this? An example of the structure have been attached.
Many thanks and kind regards.
Attachments
Run1.mdl
(2.44 KiB) Downloaded 170 times
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: Forecast

Post by Administrator »

I don't understand what you are asking. The model you've uploaded is using the forecast function, is it not doing what you need?
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Jindu
Member
Posts: 24
Joined: Thu Mar 21, 2019 3:36 pm
Vensim version: PLE

Re: Forecast

Post by Jindu »

Thanks for your reply. What I’m trying to do is to project the future customer order from where the historical actual order cycle ends. For example, if the historical is 60 weeks and the last value for the 60th week is 34 units/week. I want to then project or forecast for example from the 60th week (34 units/week) to 90th week from the historical order. The model uploaded with the forecast function still start from the same old value I don't know if you understand.
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: Forecast

Post by Administrator »

I'm still struggling to understand what you are trying to do.

Does this help?
https://www.vensim.com/documentation/in ... ckward.htm
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559
Jindu
Member
Posts: 24
Joined: Thu Mar 21, 2019 3:36 pm
Vensim version: PLE

Re: Forecast

Post by Jindu »

Thanks.
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: Forecast

Post by tomfid »

In your FORECAST(Actual Order Cycle, 10 , 20 ) equation, the 10 and 20 should be made into named parameters, both for dimensional consistency and to expose them to sensitivity testing and make the model structure more portable.
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: Forecast

Post by tomfid »

I think you want something like the following:

historic order rate = order cycle(time)
last historic order rate = order cycle(switch time)
future order trend = ... {this could be a constant, or estimated from the lookup}
future order rate = last historic order rate + future order trend*MAX(0,time-switch time)
switch time = 60
order rate = IF THEN ELSE( time <= switch time, historic order rate, future order rate )
Jindu
Member
Posts: 24
Joined: Thu Mar 21, 2019 3:36 pm
Vensim version: PLE

Re: Forecast

Post by Jindu »

Many thanks for your suggestion the order rate works (projects) as I intended.
sankee82
Member
Posts: 28
Joined: Mon Oct 01, 2018 5:56 pm
Vensim version: DSS

Re: Forecast

Post by sankee82 »

Hi!
I am also trying to forecast the future variables by using the historic data. In my case my variable of interest is modeled as a level whereas In the above case the order cycle was a lookup. Can you please suggest me how to use the above algorithm for a level/stock i.e., Auxiliary variable?


Thanks and Regards,
Sankeerthana.
Post Reply