Days of Supply Report
An inventory manager may need to know whether the supply is enough to meet the demand, and on the average, how long the current supply will last. The Days of Supply Report provides visibility into the estimated number of days the inventory supply will be available, and the total supply and demand.
Note: If you use
IBM® Sterling™ Intelligent Promising Inventory Visibility to manage your inventory, use Order Hub to view the Days of supply metrics. For more information about configuring the
inventory thresholds and viewing the metrics on the Order Hub workspace, see Configuring alert thresholds for inventory and KPIs in.
For a specific enterprise and ship node, the Estimated Days of Supply is calculated as:
Demand for the past 7-day period/7 = Average Demand
Current Supply/Average Demand = Estimated Days of Supply
The Estimated Days of Supply is rounded up and displays only two decimal places.
The Days of Supply Report should be run at night, during a period of light load.
If there is no past week demand for an item, the Estimated Days of Supply is shown in the report as 999.
The following image shows a sample of the Days of Supply Report.
Note:
- The sample reports provided are designed to run with low data volumes.
- The sample reports are designed to run for a 7-day period or lesser but not beyond 7 days.