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 days sales of 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

Days sales of inventory (DSI) is the average number of days to sell all inventory and WIP (work-in-progress). To calculate days sales of inventory, first divide the value of the inventory by the cost of goods sold. Then multiply this ratio by the number of days in the time period.

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

C1	C2-T
`DSI Days`	`Collection`
52.6	Classic
49.8	Modern
73.7	Classic
36.5	Modern

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Inventory, select Days sales of inventory.
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 days sales of inventory that you want to graph.
In Graph variables (desktop app) or Y-variable (web app), enter the column that contains the days sales 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.