Display Descriptive Statistics for Visualize Months On Hand

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

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

Example

Months on hand is the number of months of available inventory that exists if no new purchases are made and sales continue as forecasted. To calculate months on hand inventory, divide the value of the inventory by the cost of goods sold. Then multiply by the number of months in the time period.

In this worksheet, Months on Hand is the variable. Item and Style are the optional grouping variables.

C1	C2-T	C3-T
`Months on Hand`	`Item`	`Style`
1.73	Jeans	Wide
1.64	Jeans	Crop
3.4	Jeans	Trouser
2.5	Pant	Wide

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Inventory, select Months on hand.
Select Visualize months on hand, then click OK.
Select Display Descriptive Statistics, then click OK.
In Variables, enter the column that contains the months of inventory data.
In By variables (optional), enter the columns that contain the grouping data to explore the differences between the groups.
Click OK.

Tip

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