How to calculate as Dinamic

Previous Member
Previous Member
500 Up Votes 500 Likes 500 Comments Second Anniversary
in Platform

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.

 

 

 

 

 

Answers

  • Helmut Heimann
    Helmut Heimann Employee, Community Captain
    50 Answers 500 Comments 250 Likes Fourth Anniversary

    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
    Previous Member
    500 Up Votes 500 Likes 500 Comments Second Anniversary

    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

Categories