Display Descriptive Statistics for Visualize Turn-earn Index

Use Display Descriptive Statistics to describe the average, range, and distribution curve of the turn and earn index using graphs and tables.

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

C1	C2-T	C3-T
`T/E Index`	`Item`	`Collection`
223	Jeans	Classic
256	Jeans	Classic
388	Shorts	Athletic
319	Shorts	Athletic

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Profitability, select Turn-earn index.
Select Visualize turn-earn index, then click OK.
Select Display Descriptive Statistics, then click OK.
In Variables, enter the column that contains the turn and earn index 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.