Hi,
I would like to know if there is a way to have a report that is done automatically that shows how much days there is left for a SKU.
This would be the formula : ''Available Stock''/(''Average sales per month for last 3 months'')= remaining month for available SKY
For exeple let's say I have product 'AB'.
At the moment I have in stock 60 cases of the product.
Zoho calculates that in the last 3 month I sold 90 cases, so 30 cases per month.
Zoho calculates that I have 2 months remaining inventory :
--> ''Stock''/''Sales per month''
--> --> 60/30 = 2 months
But this calculates in ''real time'' so if today I sell another 10 cases it becomes :
Stock = 50 cases
Sales per month = 100 cases in 3 month --> 33 cases per month
Remaining days = ''stock''/''sales per month'' = 50 / 33 --> 1.5 month
This helps me manage inventory in knowing when to place orders, what products need to be ordered rush, etc