Calculating Inventory Days

[yaronc98]

Hi ,

i have a row with expected sales by month for 12 months ahead.

i also now the projected inventory every month


is there a way to calculate how many days of sales will my current inventory cover ? (without using a complicated vba function, just with a regular formula)


thanks,

yaron.

 

[Hui]

Can you post an example ?

 

[yaronc98]

type Open Invtry Jan-11 Feb-11 Mar-11 Apr-11 May-11

Sales - 161 142 192 111 82

Supply - 245 736 213 - -

Inventory Balance 129 213 807 827 716 634


what i would like to calculate is for example how many days/months of sales (looking forwared) will the 213 in inventory in Jan cover


Yaron