Bar Chart: Function of a Variable for Visualize Relationships With Months On Hand

Use Bar Chart: Function of a Variable to visualize a function of total or average months of available inventory by one categorical variable.

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

Example

Months on hand is the number of months of available inventory that exists if no new purchases are made and sales continue as forecasted. To calculate months on hand inventory, divide the value of the inventory by the cost of goods sold. Then multiply by the number of months in the time period.

In this worksheet, Months on Hand is the graph variable. Style is the categorical variable.

C1	C2-T
`Months on Hand`	`Style`
1.73	Wide
1.64	Crop
3.4	Trouser
2.5	Wide

How-to

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