Display Descriptive Statistics for Visualize Days Sales Of Inventory

Use Display Descriptive Statistics to describe the average, range, and distribution curve of days sales of inventory using graphs and tables.

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 variable. Item and Collection are the optional grouping variables.

C1	C2-T	C3-T
`DSI Days`	`Item`	`Collection`
52.6	Jeans	Classic
49.8	Jeans	Classic
73.7	Shorts	Athletic
36.5	Shorts	Athletic

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, then click OK.
Select Display Descriptive Statistics, then click OK.
In Variables, enter the column that contains the days sales of inventory data.
In By variables (optional), enter the columns that contain the grouping data to explore the differences between the groups.
Click OK.

Tip

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