Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Model total inventory position with an initial total decaying based on weekly sales?

I have two data sets:

One is inventory data with the total inventory being a sum of the values.

The other is forecasted sales by week.

 

I would like a visual (with total inventory on the Y axis and time by week on the X) that begins with my total inventory and then each data point shows that total inventory less the forecasted sales from the previous weeks. A resulting metric would be days of inventory (determined by when the total inventory reaches zero, and made with actual forecasts not a sales rate).

 

Any leads for what functions I'll need to utilize and what graphic may allow me to do this?

 

Thanks!

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Anonymous ,

     

    Could you please show some sample data and clarify more details about your requirement?

     

    Community Support Team _ Jimmy Tao

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-yuta-msft 

       

      Here is some sample data:

           

      First we have inventory by product by warehouse, then we have forecasted sales/depletions by week by product by warehouse. I'd like to sum the current inventory, then subtract the sales each week in a cumulative way so that, in this example,by the third week the "remaining inventory" variable would be zero for each product.

       

      Example - New York has 100 Product 1, after week of 6/10 it will have 70, after week of 6/17 it will have 40, after week of 6/24 inventory will be zero.