Formula needed, Projected sell out date

[astclair]

[h=2]I'm trying to find a formula to calculate the projected sell out date of our inventory, example if i have 1582 of one item in stock, and sell 181 a month, when will I sell out? Below is a list of our order, hence why
((D2+F2)/K2) was my first thought, but I am not sure how to make it project a date based on months as to when we will sell out.

I For the life of me cannot figure out the formula as I am still relatively new to this.

A,B- Product name
C-Product Number
D-Total in Warehouse
E-UPC Codes
F-On Order
G-Order Number
H-Stickered
I-Retire?
J-Average sales, June
K-Average Sales, July[/h]

Thank you so much to anyone who can help me. I was doing it manually but with our business growing I no longer have time.

 

[Eric W]

Welcome to the forum.

You could try:

=EOMONTH(TODAY(),(D2+F2)/K2)

which would give you the last day of the last month where you'd have enough.

 

[sheetspread]

You can divide stock by sales for each item, then find the max for the # of months when everything is sold out.

 

[astclair]

Thank you guys so much! I'm sure that will be sufficient enough!

 

[Eric W]

Glad we could help!

Come back if you have any other questions.