asusetyo
Board Regular
- Joined
- Feb 18, 2014
- Messages
- 50
Dear friend,
I was trying to calculate 2 things, Opening stock in the next week and Target Inventory in each weeks.
Opening Stock in 2014/10/w2 will be : (Opening Stock - Sell Out) from 2014/10/w1
Target Inventory in 2014/10/w1 will be : SUM of Sell Out 2014/10/w1 & 2014/10/w2 (depends on the Stock Policy, 2 means 2 weeks of Sell Out).
Is there any way to calculate this things?
<colgroup><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>Thanks,
Adit
I was trying to calculate 2 things, Opening stock in the next week and Target Inventory in each weeks.
Opening Stock in 2014/10/w2 will be : (Opening Stock - Sell Out) from 2014/10/w1
Target Inventory in 2014/10/w1 will be : SUM of Sell Out 2014/10/w1 & 2014/10/w2 (depends on the Stock Policy, 2 means 2 weeks of Sell Out).
Is there any way to calculate this things?
Week | SKU CODE | Sell Out | Opening Stock | Stock Policy | Target Inventory |
2014/10/w1 | 100041 | 10 | 20 | 2 | |
2014/10/w2 | 100041 | 10 | 2 | ||
2014/10/w3 | 100041 | 11 | 2 | ||
2014/10/w4 | 100041 | 11 | 2 | ||
2014/10/w5 | 100041 | 10 | 2 | ||
2014/11/w1 | 100041 | 11 | 2 | ||
2014/11/w2 | 100041 | 11 | 2 | ||
2014/11/w3 | 100041 | 12 | 2 | ||
2014/11/w4 | 100041 | 13 | 2 | ||
2014/12/w1 | 100041 | 12 | 2 | ||
2014/12/w2 | 100041 | 12 | 2 | ||
2014/12/w3 | 100041 | 13 | 2 | ||
2014/12/w4 | 100041 | 14 | 2 |
<colgroup><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Adit