• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculating Inventory Days

yaronc98

New Member
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.
 
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
 
Back
Top