Forum Discussion

mb0307's avatar
mb0307
Responsive Resident
5 years ago

Inventory Analysis

Hi,   Please see tables below and key requirements in red:  Click to Data Download link TOTAL SHELF-LIFE - is total life of any product when they are manufactured. MIN ACCEPTABLE LIFE ...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi mb0307 ,

 

Is this what you want? Please refer to my .pbix file.

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • mb0307's avatar
    mb0307
    Responsive Resident
    5 years ago

    v-lionel-msft  Thanks but your solution is not fulfilling 2 key requirements below:

    2 key requirements:

    1. Insufficient demand to consume.
      1. Stock on hand is more than Demand - only consider number of weeks available in the Demand table
    2. Sufficient demand but Insufficient acceptable shelf life
      1. Remaining shelf-life of products will reduce as we look into week on week in the Demand table.
      2. Considering MIN ACCEPTABLE LIFE, need to identify how much of Stock will be consumed and how much we will NOT be consumed.

     

     

    In your PBIX, stock cumulative figures are just repeating.  It should reduce as look into week on week demand. 

     

    Also,  it should consider MIN ACCEPTABLE LIFE.

     

    Thanks for looking into this.