Inventory Remaining Days

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​


    Zoho Desk Resources

    • Desk Community Learning Series


    • Digest


    • Functions


    • Meetups


    • Kbase


    • Resources


    • Glossary


    • Desk Marketplace


    • MVP Corner


    • Word of the Day


      • 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. ____________________________________________________________________________________________________________

      Zoho CRM Plus Resources

        Zoho Books Resources


          Zoho Subscriptions Resources

            Zoho Projects Resources


              Zoho Sprints Resources


                Zoho Orchestly Resources


                  Zoho Creator Resources


                    Zoho WorkDrive Resources



                      Zoho Campaigns Resources

                        Zoho CRM Resources

                        • CRM Community Learning Series

                          CRM Community Learning Series


                        • Tips

                          Tips

                        • Functions

                          Functions

                        • Meetups

                          Meetups

                        • Kbase

                          Kbase

                        • Resources

                          Resources

                        • Digest

                          Digest

                        • CRM Marketplace

                          CRM Marketplace

                        • MVP Corner

                          MVP Corner

                        • Word of the Day

                          Word of the Day


                        • CRM Community Learning Series

                          CRM Community Learning Series


                        • Tips

                          Tips

                        • Functions

                          Functions

                        • Meetups

                          Meetups

                        • Kbase

                          Kbase

                        • Resources

                          Resources

                        • Digest

                          Digest

                        • CRM Marketplace

                          CRM Marketplace

                        • MVP Corner

                          MVP Corner

                        • Word of the Day

                          Word of the Day



                          Zoho Writer Writer

                          Get Started. Write Away!

                          Writer is a powerful online word processor, designed for collaborative work.

                            Zoho CRM コンテンツ




                              ご検討中の方