Inventory Remaining Days

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

Access your files securely from anywhere

Zoho Developer Community

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Tout forum

France ZUGs

Zoho SalesIQ Resources

Topic Participants
nikamneelam0
Data Sailing
Nithin R

Sticky Posts
How to Add Users to your Organization in ZohoMail?
A better clarity so you can create other users to start using Zoho Mail. You can directly Add Users from the Control Panel to your Organization. You can invite users with the existing email address. If the person (user) already uses ZohoCRM, then you can import users from Zoho CRM. You can also import them using a .csv file. (if you are planning to add them in Bulk) In this topic, We will be discussing on how to Add and Invite users only. The Import options are self explanatory. ____________________________________________________________________________________________________________

New to Zoho Social?

Manage your brands on social media

Access Zoho Social