Hi,
Need advise from the experts in this forum. Data is below
<colgroup><col><col span="10"></colgroup><tbody>
</tbody>
I would like to get a automatic calculation formulation for Week supply. For example. In Week 1 Week supply is 2 because of Week 1 closing stock can cover forecast for week 2 and week 3 (20+20) - 40 = 0, therefore it is 2.
However in Week 5 Week supply is 1.5 week because week 6 forecast is 10 and week 7 forecast is 20, closing stock in week 5 is 20, therefore week supply base on closing stock week 5 going forward is 1.5.
Hope this explains.
Cheers
Sasils
Need advise from the experts in this forum. Data is below
W1 | W2 | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | |
Forecast | 10 | 20 | 20 | 10 | 10 | 20 | 10 | 20 | 10 | 10 |
Closing stock | 40 | 20 | 40 | 20 | 20 | 20 | 10 | 40 | 10 | 10 |
Week supply | 2 | 1 | 3 | 1.5 | 1 | 1.5 | 0.5 |
<colgroup><col><col span="10"></colgroup><tbody>
</tbody>
I would like to get a automatic calculation formulation for Week supply. For example. In Week 1 Week supply is 2 because of Week 1 closing stock can cover forecast for week 2 and week 3 (20+20) - 40 = 0, therefore it is 2.
However in Week 5 Week supply is 1.5 week because week 6 forecast is 10 and week 7 forecast is 20, closing stock in week 5 is 20, therefore week supply base on closing stock week 5 going forward is 1.5.
Hope this explains.
Cheers
Sasils