Hello All,
This should be fairly straight forward, but I'm struggling to construct a formula to give me the result I want.
I have drawn up a simple summary to show what I am trying to achieve:
I want to calculate how much cover, in days, the current Stock position gives me, based on the forward Demand that exists. If the days cover is actually negative, the formula should treat it as such.
I'd greatly appreciate any suggestions people have got.
Thanks,
Matty
This should be fairly straight forward, but I'm struggling to construct a formula to give me the result I want.
I have drawn up a simple summary to show what I am trying to achieve:
Book1 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | Week1 | Week2 | Week3 | Week4 | Week5 | Week6 | Week7 | Week8 | Week9 | Week10 | |||
2 | Demand | 10 | 15 | 12 | 8 | 16 | 20 | 13 | 15 | 7 | 25 | ||
3 | Production | 0 | 25 | 0 | 0 | 25 | 0 | 25 | 0 | 25 | 0 | ||
4 | Stock | 35 | 25 | 35 | 23 | 15 | 24 | 4 | 16 | 1 | 19 | ||
5 | Cover(Days) | ? | ? | ? | ? | ? | ? | ? | ? | ? | ? | ||
Sheet1 |
I want to calculate how much cover, in days, the current Stock position gives me, based on the forward Demand that exists. If the days cover is actually negative, the formula should treat it as such.
I'd greatly appreciate any suggestions people have got.
Thanks,
Matty