Bar Chart: Function of a Variable for Visualize Relationships With Days Sales Of Inventory

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

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

Example

Inventory days of supply is the number of days until inventory is depleted if the company does not add to its supply. To calculate inventory days of supply, first divide the value of the average inventory by the expected product demand. Then multiply this ratio by the number of days in the time period. Inventory days of supply is usually calculated monthly.

In this worksheet, Days of Supply is the graph variable. Style is the categorical variable.

C1	C2-T
`Days of Supply`	`Style`
38.06	Wide
37.8	Crop
68	Trouser
62.3	Wide

How-to

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