Heatmap for Visualize Relationships With Total Supply Chain Management Cost As A Proportion Of Sales

Use Heatmap to visualize total supply chain management cost as a proportion of sales by multiple categorical variables.

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

Example

Total supply chain management cost as a proportion of sales is the total supply chain costs for a specific time period divided by the total sales.

In this worksheet, Total Cost Proportion is the graph variable. Product and Standard Parts are the row variables. Auto Purchase Order and Shipping are the column variables.

C1	C2-T	C3-T	C4-T	C5-T
`Total Cost Proportion`	`Product`	`Standard Parts`	`Auto Purchase Order`	`Shipping`
0.154	Jigsaw	No	No	Partial Truck
0.143	Drill	Yes	Yes	Full Truck
0.167	Jigsaw	No	No	Partial Truck
0.139	Drill	No	No	Parcel

How-to

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