Hello all,
I currently need help with a formula to calculate the Stock Covers in weeks as follows:
<tbody>
</tbody>
The formula should read that I have OS (Opening Stocks) = 100 in Week 1, then it would cover the requirements of Weeks 1,2,3 (50+40+5), then the Cover for Week 1 should be "3.0". Similarly, for Week 2 would be "2.0", etc. The table would be extended for 52 Weeks. Any ideas?
Edit: Opening Stocks for Week 2 = Opening Stocks for Week 1 - Requirement of Week 1 + Order-In of Week 2
Thanks in advance
I currently need help with a formula to calculate the Stock Covers in weeks as follows:
Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | ||||||||||||||||||||||||
Order | OS | Cover | Req | Order | OS | Cover | Req | Order | OS | Cover | Req | Order | OS | Cover | Req | Order | OS | Cover | Req | Order | OS | Cover | Req | Order | OS | Cover | Req | Order | OS | Cover | Req |
100 | 3.0 | 50 | 50 | 2.0 | 40 | 10 | 1.0 | 5 | 10 | 15 | 2.0 | 10 | 5 | 1.0 | 5 | 0 | 0.0 | 5 | 10 | 5 | 1.0 | 5 | 0 | 0.0 | 5 |
<tbody>
</tbody>
The formula should read that I have OS (Opening Stocks) = 100 in Week 1, then it would cover the requirements of Weeks 1,2,3 (50+40+5), then the Cover for Week 1 should be "3.0". Similarly, for Week 2 would be "2.0", etc. The table would be extended for 52 Weeks. Any ideas?
Edit: Opening Stocks for Week 2 = Opening Stocks for Week 1 - Requirement of Week 1 + Order-In of Week 2
Thanks in advance
Last edited: