Heatmap for Visualize Relationships With Cash-to-cash Cycle Time

Use Heatmap to visualize average cash-to-cash cycle time by multiple categorical variables.

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

Example

Cash-to-cash cycle time is the length of time between the purchase of raw materials and payment for a finished product.

In this worksheet, Number of Days is the graph variable. Product is the row variable. Region and Discount are the column variables.

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

For more information about this analysis, click Help in the main dialog box.