Display Descriptive Statistics for Visualize Inventory Days Of Supply

Use Display Descriptive Statistics to describe the average, range, and distribution curve of inventory days of supply using graphs and tables.

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 variable. Item and Quarter are the optional grouping variables.

C1 C2-T C3-T
Days of Supply Item Quarter
38.06 Jeans Q1
37.8 Pants Q2
68 Shorts Q1
62.3 Skirts Q2

How-to

  1. Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
  2. Under Inventory, select Inventory days of supply.
  3. Select Visualize inventory days of supply, then click OK.
  4. Select Display Descriptive Statistics, then click OK.
  5. In Variables, enter the column that contains the inventory days of supply data.
  6. In By variables (optional), enter the columns that contain the grouping data to explore the differences between the groups.
  7. Click OK.
Tip

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