Time Series Plot for Visualize Inventory Days Of Supply and Forecast Inventory Days Of Supply

Use Time Series Plot to visualize trends in inventory days of supply. Then you can choose between single exponential smoothing and double exponential smoothing to forecast inventory days of supply.

This example applies to the Supply Chain Module. For more information, go to www.minitab.com/supply-chain-module.

Example

Inventory days of supply is the number of days until inventory is depleted if the company does not add to its supply. To calculate inventory days of supply, first divide the value of the average inventory by the expected product demand. Then multiply this ratio by the number of days in the time period. Inventory days of supply is usually calculated monthly.

In this worksheet, Days of Supply is the graph variable in time order.

C1
`Days of Supply`
38.06
37.8
68
62.3

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Inventory, select Inventory days of supply.
Select Visualize inventory days of supply or Forecast inventory days of supply, then click OK.
Select Time Series Plot, then click OK.
In Series (desktop app) or Y-variable (web app), enter the column that contains the inventory days of supply data.
Click OK.

Tip

For more information about this analysis, click Help in the main dialog box.