Heatmap for Visualize Relationships With Supply Chain Cycle Time

Use Heatmap to visualize verage customer order 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

Supply chain cycle time is the length of time to complete an order if inventory levels are zero. Supply chain cycle time includes the amount of time to order, fulfill, and receive the order.

In this worksheet, Cycle Time is the graph variable. Product is the row variable. Supplier Location and Incentive Plan are the column variables.

C1 C2-T C3-T C4-T
Cycle Time Product Supplier Location Incentive Plan
52 Jigsaw Domestic Standard
37 Drill Domestic Gold
56 Jigsaw Foreign Standard
49 Drill Foreign Gold

How-to

  1. Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
  2. Under Cycle Time, select Supply chain cycle time.
  3. Select Visualize relationships with supply chain cycle time, then click OK.
  4. Select Heatmap, then click OK.
  5. From Display, select Function of a variable.
  6. In Graph variables enter the column that contains the cycle time data.
  7. 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.
  8. In Row variables enter up to five columns that define the rows.
  9. In Column variables enter up to five columns that define the columns.
  10. Click OK.
Tip

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