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.
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 |
For more information about this analysis, click Help in the main dialog box.