Heatmap for Visualize Relationships With Stock Rotation

Use Heatmap to visualize average stock rotation by multiple categorical 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 is the graph variable. Item and Size are the row variables. Collection and Department are the column variables.

C1	C2-T	C3-T	C4-T	C5-T
`Turnover Days`	`Item`	`Size`	`Collection`	`Department`
43.8	Jeans	Extra Small	Classic	Misses
41.5	Jeans	Small	Modern	Misses
63.1	Jeans	Medium	Modern	Petite
29.9	Jeans	Extra Large	Vintage	Petite

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 Heatmap, then click OK.
From Display, select Function of a variable.
In Graph variables enter the column that contains the stock rotation data.
From Function, select the function of stock rotation. For example, if you select Mean, the color gradient of the rectangles in the heatmap uses the mean value of stock rotation in each rectangle.
In Row variables enter up to five columns that define the rows.
In Column variables enter up to five columns that define the columns.
Click OK.

Tip

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