Heatmap for Visualize Relationships With Days Sales Of Inventory

Use Heatmap to visualize average days sales 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

Days sales of inventory (DSI) is the average number of days to sell all inventory and WIP (work-in-progress). To calculate days sales of inventory, first divide the value of the inventory by the cost of goods sold. Then multiply this ratio by the number of days in the time period.

In this worksheet, DSI 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
`DSI Days`	`Item`	`Size`	`Collection`	`Department`
52.6	Jeans	Extra Small	Classic	Misses
49.8	Jeans	Small	Modern	Misses
73.7	Jeans	Medium	Modern	Petite
36.5	Jeans	Extra Large	Vintage	Petite

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Inventory, select Days sales of inventory.
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 days sales of inventory data.
From Function, select the function of days sales of inventory. For example, if you select Mean, the color gradient of the rectangles in the heatmap uses the mean value of days sales of 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.