Bar Chart: Function of a Variable for Visualize Relationships With Stock Rotation

Use Bar Chart: Function of a Variable to visualize a function of total or average stock rotation by one categorical variable.

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

Example

Stock rotation is the number of days until the inventory stock is depleted. To calculate stock rotation, first divide the average inventory value by the total sales for the same time period. Then multiply this ratio by the number of days in the time period.

In this worksheet, Turnover Days is the graph variable. Collection is the categorical variable.

C1	C2-T
`Turnover Days`	`Collection`
43.8	Classic
41.5	Modern
63.1	Classic
29.9	Modern

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Inventory, select Stock rotation.
Select Visualize relationships with stock rotation, then click OK.
Select Bar Chart: Function of a Variable, then click OK.
From Function, select the function of stock rotation that you want to graph.
In Graph variables (desktop app) or Y-variable (web app), enter the stock rotation column.
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.