Bar Chart: Function of a Variable for Visualize Relationships With Turn-earn Index

Use Bar Chart: Function of a Variable to visualize a function of the turn and earn index by one categorical variable.

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

Example

The turn and earn index (T/E Index) balances inventory turnover and profits. To calculate the turn and earn index, multiply inventory turnover and gross profit percentage. For example, if the inventory turns over 10 times in a year and has a 40% profit margin, the turn/earn index is 400.

In this worksheet, T/E Index is the graph variable. Collection is the categorical variable.

C1	C2-T
`T/E Index`	`Collection`
223	Classic
256	Modern
388	Classic
319	Modern

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Profitability, select Turn-earn index.
Select Visualize relationships with gross margin return on investment, then click OK.
Select Bar Chart: Function of a Variable, then click OK.
From Function, select the function of the turn and earn index that you want to graph.
In Graph variables (desktop app) or Y-variable (web app), enter the column that contains the turn and earn index.
In Categorical variable, enter the column of categorical data that defines the groups.
Click OK.

Tip

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