Bar Chart: Function of a Variable for Visualize Relationships With Gross Margin Return On Investment

Use Bar Chart: Function of a Variable to visualize a function of gross margin return on investment by one categorical variable.

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

Example

Gross margin return on investment (GMROI) represents the ability to turn inventory into cash above the cost of the inventory. To calculate gross margin return on investment, divide the gross profit by the inventory cost for the same time period.

In this worksheet, GMROI Ratio is the graph variable. Collection is the categorical variable.

C1	C2-T
`GMROI Ratio`	`Collection`
2.6	Classic
2.8	Modern
3.7	Classic
3.5	Modern

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Profitability, select Gross margin return on investment.
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 gross margin return on investment that you want to graph.
In Graph variables (desktop app) or Y-variable (web app), enter the column that contains the gross margin return on investment data.
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.