Correlogram for Visualize Relationships With Stock Rotation

Use Correlogram to visually compare the correlations between stock rotation and other continuous variables.

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, Sales Promotions, % Price Reduction, and % Customer Returns are the variables.

C1	C2	C3	C4
`Turnover Days`	`Sales Promotions`	`% Price Reduction`	`% Customer Returns`
43.8	4	15	25.0
41.5	1	15	22.5
63.1	6	10	17.6
29.9	6	20	12.9

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Inventory, select Stock rotation.
Select Visualize relationships with stock rotation, then click OK.
Select Correlogram, then click OK.
In Variables, enter at least two columns of numeric data.
Select Display correlation values.
Click OK.

Tip

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