Heatmap for Visualize Relationships With Gross Margin Return On Investment

Use Heatmap to visualize gross margin return on investment by multiple categorical variables.

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

Example

Gross margin return on investment (GMROI) represents the ability to turn inventory into cash above the cost of the inventory. To calculate gross margin return on investment, divide the gross profit by the inventory cost for the same time period.

In this worksheet, GMROI Ratio 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
`GMROI Ratio`	`Item`	`Size`	`Collection`	`Department`
2.6	Jeans	Extra Small	Classic	Misses
2.8	Jeans	Small	Modern	Misses
3.7	Jeans	Medium	Modern	Petite
3.5	Jeans	Extra Large	Vintage	Petite

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Profitability, select Gross margin return on investment.
Select Visualize relationships with gross margin return on investment, then click OK.
Select Heatmap, then click OK.
From Display, select Function of a variable.
In Graph variables enter the gross margin return on investment data.
From Function, select the function of gross margin return on investment. For example, if you select Mean, the color gradient of the rectangles in the heatmap uses the mean value of the gross margin return on investment ratio 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.