Heatmap for Visualize Relationships With Months On Hand

Use Heatmap to visualize average months of available inventory by multiple categorical variables.

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

Example

Months on hand is the number of months of available inventory that exists if no new purchases are made and sales continue as forecasted. To calculate months on hand inventory, divide the value of the inventory by the cost of goods sold. Then multiply by the number of months in the time period.

In this worksheet, Months on Hand is the graph variable. Item is the row variable. Collection and Style are the column variables.

C1	C2-T	C3-T	C4_T
`Months on Hand`	`Item`	`Collection`	`Style`
1.73	Jeans	Classic	Wide
1.64	Jeans	Modern	Crop
3.4	Jeans	Modern	Trouser
2.5	Jeans	Vintage	Wide

How-to

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