Hi all,
I am trying to show if a product is going to be out of stock between the current date and current date + the leadtime of the product.
For example:
I have a current stock (Stock) of 10.000
The leadtime of the product to be delivered at our warehouse is 30 days
The (linear) demand from our customers in those 30 days will be 20.000.
I have a pending shipment from our supplier of 30.000 which will be deliverd in approximately 24 days.
This will mean that we will be out of stock around day 15 till day 24.
How can I show this in a table saying:
Product | Current Stock | Date out of stock | Date back in stock
Any help will be appreciated!