Use this forum to post Vensim related questions.
sally
Member
Posts: 40 Joined: Sun Nov 05, 2006 4:34 pm
Post
by sally » Tue Dec 05, 2006 7:41 am
hi,,
i want to use a function to do the forecasting----moving average. can i use Forcst function to do this?
bob@vensim.com
Senior Member
Posts: 1107 Joined: Wed Mar 12, 2003 2:46 pm
Post
by bob@vensim.com » Tue Dec 05, 2006 11:31 am
It is worth reading Sterman's book on this - the standard representation of expectations as formed by people is a SMOOTH function which is an exponentially weighted moving average.
sally
Member
Posts: 40 Joined: Sun Nov 05, 2006 4:34 pm
Post
by sally » Tue Dec 05, 2006 1:42 pm
if i only want to use simple moving agreage ?
which fuction should i use?
thank you .
bob@vensim.com
Senior Member
Posts: 1107 Joined: Wed Mar 12, 2003 2:46 pm
Post
by bob@vensim.com » Tue Dec 05, 2006 9:26 pm
To get a simple moving aveage use
moving average = period accumulation/averaging time
period accumulation = INTEG(value to average - outflow,init average value*averaging time)
outflow = DELAY FIXED(value to average,averaging time,init average value/averaging time)
sally
Member
Posts: 40 Joined: Sun Nov 05, 2006 4:34 pm
Post
by sally » Thu Dec 07, 2006 2:22 pm
i am still confused about the forecasting function in vensim, i want to use the customer to forecasting the inventory level.
i want to use simple moving average ,,
hope some one can help me to figure it out..
thank you
Attachments
forecast function.mdl
(1.21 KiB) Downloaded 344 times
sally
Member
Posts: 40 Joined: Sun Nov 05, 2006 4:34 pm
Post
by sally » Tue Feb 06, 2007 11:52 am
i still didn't know how to set up the forecast?
hope some one can help me
bob@vensim.com
Senior Member
Posts: 1107 Joined: Wed Mar 12, 2003 2:46 pm
Post
by bob@vensim.com » Tue Feb 06, 2007 1:44 pm
use
expected demand = SMOOTH(demand,time to form expectations) ~ Widget/Month
Time to form expectations = 5 ~ Month
Expected Inventory = MAX(0,Inventory + (expected production - expected demand) * Inventory Forecast Horizon) ~ Widget
Inventory Forecast Horizon = 4 ~ Month