AnsweredAssumed Answered

How to calculate as Dinamic

Question asked by chrisyanmanalu on Nov 14, 2018
Latest reply on Nov 14, 2018 by chrisyanmanalu

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.

 

 

 

 

 

Outcomes