Heatmap for Visualize Relationships With Freight Cost Per Unit

Use Heatmap to visualize freight 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

Freight cost per unit is the total freight costs divided by the number of units shipped.

In this worksheet, Freight Cost/Unit ($) is the graph variable. Product and Carrier are the row variables. Pickup Time and Shipping Contract are the column variables.

C1	C2-T	C3-T	C4-T	C5-T
`Freight Cost/Unit ($)`	`Product`	`Carrier`	`Pickup Time`	`Shipping Contract`
1.38	Mix	Speedy Shipping	Peak	Yes
1.22	Mix	Global Delivery	Normal	Yes
2.36	Flavored Oils	Ship-It-Fast	Peak	No
1.75	Flavored Vinegars	Ship Now	Normal	Yes

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Costs, select Freight cost per unit.
Select Visualize relationships with freight 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 freight cost per unit data.
From Function, select the function of freight cost per unit. For example, if you select Mean, the color gradient of the rectangles in the heatmap uses the mean value of freight 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.