Display Descriptive Statistics for Visualize Gross Margin Return On Investment

Use Display Descriptive Statistics to describe the average, range, and distribution curve of gross margin return on investment using graphs and tables.

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 variable. Item and Collection are the optional grouping variables.

C1	C2-T	C3-T
`GMROI Ratio`	`Item`	`Collection`
2.6	Jeans	Classic
2.8	Jeans	Classic
3.7	Shorts	Athletic
3.5	Shorts	Athletic

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Profitability, select Gross margin return on investment.
Select Visualize gross margin return on investment, then click OK.
Select Display Descriptive Statistics, then click OK.
In Variables, enter the column that contains the gross margin return on investment ratio data.
In By variables (optional), enter the columns that contain the grouping data to explore the differences between the groups.
Click OK.

Tip

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