Ventana software support forum

Hello
I am trying to look (model) into the future from the historical demand pattern. For example I used Lookup Forward (order cycle, time) for historical demand pattern. I am now trying to project orders into the future or use different kind of trend line like interpolation instead of repeating the same demand pattern any help or suggestion would really be appreciated in carrying out this task.
Regards.

You can use the FORECAST function to extrapolate. If that's not too your liking (it can be noise-sensitive) there are a lot of ways to modify it.

Hi.
I am thankful for your suggestion. I have tried to use the FORECAST function to extrapolate as you suggested but it does not simulate but says –order cycle- is a special type and cannot be used as a normal variable. Any suggestion or information on how to solve this problem is really appreciated. An example of the structure is attached.
Many thanks and kind regards

You've got "Order cycle" as a lookup variable. I'd suggest creating a new variable called "actual order cycle"

actual order cycle = Order cycle (time)

Then change customer order rate,
customer order rate = FORECAST(actual order cycle, Time , 200 )

Thanks for your suggestion it was helpful.