Heatmap for Visualize Relationships With Supply Chain Cost Per Unit

Use Heatmap to visualize supply chain cost per unit by multiple categorical variables.

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

Example

Supply chain cost per unit is the total supply chain costs divided by the number of units sold.

In this worksheet, Supply Chain Cost/Unit ($) is the graph variable. Product is the row variable. Auto Purchase Order and Shipping are the column variables.

C1	C2-T	C3-T	C4-T
`Supply Chain Cost/Unit ($)`	`Product`	`Auto Purchase Order`	`Shipping`
3.90	Jigsaw	No	Partial Truck
2.56	Drill	Yes	Full Truck
4.70	Jigsaw	No	Partial Truck
3.49	Drill	No	Parcel

How-to

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