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

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

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

Example

Days sales of inventory (DSI) is the average number of days to sell all inventory and WIP (work-in-progress). To calculate days sales of inventory, first divide the value of the inventory by the cost of goods sold. Then multiply this ratio by the number of days in the time period.

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

C1
`DSI Days`
52.6
49.8
73.7
36.5

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Inventory, select Days sales of inventory.
Select Visualize days sales of inventory or Forecast days sales of inventory, 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 days sales of inventory data.
Click OK.

Tip

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