Heatmap for Visualize Relationships With Turn-earn Index

Use Heatmap to visualize the turn and earn index by multiple categorical variables.

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

Example

The turn and earn index (T/E Index) balances inventory turnover and profits. To calculate the turn and earn index, multiply inventory turnover and gross profit percentage. For example, if the inventory turns over 10 times in a year and has a 40% profit margin, the turn/earn index is 400.

In this worksheet, T/E Index 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
`T/E Index`	`Item`	`Size`	`Collection`	`Department`
223	Jeans	Extra Small	Classic	Misses
256	Jeans	Small	Modern	Misses
388	Jeans	Medium	Modern	Petite
319	Jeans	Extra Large	Vintage	Petite

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Profitability, select Turn-earn index.
Select Visualize relationships with turn-earn index, then click OK.
Select Heatmap, then click OK.
From Display, select Function of a variable.
In Graph variables enter the column that contains the turn and earn index data.
From Function, select the function of the turn and earn index. For example, if you select Mean, the color gradient of the rectangles in the heatmap uses the mean value of the turn and earn index 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.