How to calculate as Dinamic

Previous Member

Hi,

I have data like this :

Safety Stock (Enable Data Entry)

Setting Safety Stock : 2

Week : Wc01 Wc02 Wc03 Wc04 Wc05 Wc06

Demand : 10 10 10 10 10 10

Safety Stock : [........] [........] [........] [........] [........] [........]

I want calculate Demand to Safety Stock as Dinamic.

When I want Calculate Safety Stock, Safety Stock on

Wc01 is 20 => (Wc02 + Wc03) from demand

Wc02 is 20 => (Wc03 + Wc04) from demand

Wc03 is 20 => (Wc04 + Wc05) from demand

When I want to change Setting Safety Stock to : 3

Wc01 is 30 => (Wc02 + Wc03 + Wc04) from demand

Wc02 is 30 => (Wc03 + Wc04 + Wc05) from demand

Wc03 is 30 => (Wc04 + Wc05 + Wc06) from demand

Thank you.

Find more posts tagged with

Accepted answers

All comments

Helmut Heimann

Hi Chrisyan Manalu,

you could achieve that with the time functions in BOARD (have a look at our help page: Time functions ) in combination with the "Cycle" on a weekly basis.

Kind Regards,

Helmut

Previous Member

Hi Helmut Heimann,

Yap. I had been try that one before, and successful.

I suggest, when user change that setting safety stock from "2" to "5", I will follow to change that Cycle to 5 right ??

I want try with Dinamic without using function "Offset" or "Cycle" because I think its hardcode

Thank you