Heatmap for Visualize Relationships With Days Sales Of Inventory

Use Heatmap to visualize average inventory days of supply by multiple categorical variables.

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

Example

Inventory days of supply is the number of days until inventory is depleted if the company does not add to its supply. To calculate inventory days of supply, first divide the value of the average inventory by the expected product demand. Then multiply this ratio by the number of days in the time period. Inventory days of supply is usually calculated monthly.

In this worksheet, Days of Supply is the graph variable. Item is the row variable. Collection and Style are the column variables.

C1	C2-T	C3-T	C4-T
`Days of Supply`	`Item`	`Collection`	`Style`
38.06	Jeans	Classic	Wide
37.8	Jeans	Modern	Crop
68	Jeans	Modern	Trouser
62.3	Jeans	Vintage	Wide

How-to

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