Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Projecting Inventory to Expire based on forecast

Hi everyone!   Posting this question for my inventory tracking project.  Summary: I would like to build a tracker/dashboard to track my inventory expiration risks based on forecasted usage.   In...
Need Help
Show and Tell
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Greg_Deckler ,

 

I'm valuating the opposite which is excess supply. 

I'm stuck with the problem considering that:

 

1. Different batches and different expiration dates per material,

2. I need to factor in First to Expire, First to Use concept. 

 

A straightforward calculation of Total Usage - Inventory will not work for the project. 😞

 

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi Anonymous ，

 

Could you show us your .pbix file or sample data if there's nothing confidential?You can upload it to onedrive and share us with the link.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
 

 

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      6 years ago

      Hi Anonymous ，

       

      So for "status":

      IF('Table'[date]>'Table'[Expiration date]&&'Table'[On hand Inventory]>0,"overstock",BLANK())

      What date should I use to compare with 'expiration date'?Today()?

       

      For"Inventory stock",how should I get the result?

       

      Your sample data is really a bit complex,better show me a clear logic.

       

      Best Regards,
      Kelly
      Did I answer your question? Mark my post as a solution!
       
      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        hi, since Anonymous ist not active I will try to put some logic. 

         

        Expiration date should pe a parameter until when the goods can be used. 

         

        In case that FC qty. until the expiration day is lower than stock on hand, you will end up with excessive stock that has to be evaluated. In this case from the day of expiration you need to switch to the next exp. date batch of the same product if existing and continue to supply according to the forecast. 

         

        In the opposite case where FC qty. ist higher than qty. expirarion day simply switch to next batch if available when stock ist utilised. 

         

        Hope it helps. br Mila