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)
