Hi, I am looking for a one cell formula that can be copied down, that will give me my forward inventory cover. To explain, forward cover is the number of weeks or days that I have of inventory as cover for a specific level of inventory at a particular period of time, based on forecast sales. ie: ( I hope this little table makes sense!)
Week / Sales / Stock-value / Cover weeks
1 / 150 / 500 / 3.2
2 / 150 / 500 / 2.8
3 / 150 / 600 / 3.25
4 / 150 / 800 / 5
5 / 250 / 800 / 6.5
6 / 200 / 700 / 6.5
7 / 150 / 600 / 6
8 / 100 / 500 / 5
9 / 100 / 500 / 5
I have manually worked out the cover weeks in the above example to (ie for week 1 we have stock of 500 and this will cover us for 3.2 weeks at the projected sales), but it is this that I want to caluclate as a formula.
All help is greatly appreciated.
Regards,
GS
Week / Sales / Stock-value / Cover weeks
1 / 150 / 500 / 3.2
2 / 150 / 500 / 2.8
3 / 150 / 600 / 3.25
4 / 150 / 800 / 5
5 / 250 / 800 / 6.5
6 / 200 / 700 / 6.5
7 / 150 / 600 / 6
8 / 100 / 500 / 5
9 / 100 / 500 / 5
I have manually worked out the cover weeks in the above example to (ie for week 1 we have stock of 500 and this will cover us for 3.2 weeks at the projected sales), but it is this that I want to caluclate as a formula.
All help is greatly appreciated.
Regards,
GS