Display Descriptive Statistics for Visualize Stock Rotation

Use Display Descriptive Statistics to describe the average, range, and distribution curve of stock rotation using graphs and tables.

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

Example

Stock rotation is the number of days until the inventory stock is depleted. To calculate stock rotation, first divide the average inventory value by the total sales for the same time period. Then multiply this ratio by the number of days in the time period.

In this worksheet, Turnover Days is the variable. Item and Collection are the optional grouping variables.

C1	C2-T	C3-T	C4-D
`Turnover Days`	`Item`	`Collection`	`Date`
43.8	Jeans	Classic	4/1
41.5	Jeans	Classic	4/2
63.1	Shorts	Athletic	4/1
29.9	Shorts	Athletic	4/2

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Inventory, select Stock rotation.
Select Visualize stock rotation, then click OK.
Select Display Descriptive Statistics, then click OK.
In Variables, enter the column that contains the stock rotation 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.