How to Calculate Stock Coverage for months with the available sales targets
Can anyone tell me how to find stock coverage for months, for example:
Months
jan
feb
mar
apr
Sales Targets
15
5
6
4
For instance when we are talking about the month Jan where stock is 30.
Months
jan
feb
mar
apr
Sales Targets
15
5
6
4
Remaining stock after using
15
10
4
-26
Hence when forecasting stock we find that when we reach April we are deficit by -26 units.
So I would like to show a formula that divides the remaining stock (i.e 4 in march) by the total stock initially available in Jan (i.e 30 ) to give a value of 0.14.
and this 0.14 gets added to the 3 months (JAN, FEB and MAR) where the initial 30 unit stocks lasted.
Which means in total we get 3.14 (i.e the number the months the stock will last given the parameters)
