Scatterplot for Visualize Relationships With Days Sales Of Inventory

Use Scatterplot to visualize inventory days of supply versus one continuous 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 Y variable, and Sales Promotions is the X variable.

C1	C2
`Days of Supply`	`Sales Promotions`
38.06	4
37.8	1
68	6
62.3	6

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 Scatterplot, then click OK.
In Y variables, enter the column that contains the inventory days of supply data.
In X variables, enter a corresponding column that might explain or predict changes in the inventory days of supply.
Click OK.

Tip

For more information about this analysis, click Help in the main dialog box.