In our recipe thus far, we have treated our data table, R01_Table, in terms of a historical record showing ending inventory levels and demand levels per week. However, supply chain managers often use forecasting tables for inventory and demand. These forecasting tables are generated from Advanced Shipping Notices (ASNs) that are received from suppliers indicating when stock will be received as well as sales forecasts or other information regarding when stock will be depleted. In these cases, supply chain managers are attempting to forecast and optimize Days of Supply so that they keep the minimum possible amount of stock in hand, without the risk of running out of that stock.
We can implement this version of calculating Days ...
