CSE Forumla to calculate no of months for which stock will suffice

[fastnswift]

Hi, I am new to his forum and to CSE functions... I have in row 20 the no of units in stock at the end of each month. In another row, I have the demand for units every month. Is it possible for excel to automatically calculate the no of months for which the stock in hand will suffice? Many thanks for all your help in advance

 

[gaz_chops]

Welcome to the forum.

Add an example of your data, see my signature for ways of doing so.

 

[fastnswift]

		Jan-15	Feb-15	Mar-15	Apr-15	May-15	Jun-15	Jul-15	Aug-15	Sep-15	Oct-15	Nov-15	Dec-15	Jan-16
opening balance		0	3	3	5	7	11	15	15	24	37	27	21	17
Units Purchased		15	10	12	16	20	24	17	15	28	10	20	23	14
Units available in stock		15	13	15	21	27	35	32	30	52	47	47	44	31
Demand		12	10	10	14	16	20	17	6	15	20	26	27	10
Closing balance		3	3	5	7	11	15	15	24	37	27	21	17	21

<colgroup><col style="mso-width-source:userset;mso-width-alt:5083;width:104pt" width="139"> <col style="width:48pt" span="14" width="64"> </colgroup><tbody>
</tbody>

 

[fastnswift]

Hi gaz_chops,

Thanks for your revert... The above is a snapshot of my data. I just need to calculate the number of months for which my stock in hand at the beginning of the month would suffice. For E.g. the output I am looking for is 15 units in Jan (after purchases) would suffice for 1 month of demand. 35 units of June 15 would suffice for 2 months of demand, etc... This is an almost perpetual sheet running into a number of months with the demand numbers fluctuating frequently. Hence, the need to automate it.

Thanks for your help