Fitted Line Plot for Predict Stock Rotation

Use Fitted Line Plot to use one continuous predictor to predict stock rotation time.

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

Example

Stock rotation is the number of days until the inventory stock is depleted. To calculate stock rotation, first divide the average inventory value by the total sales for the same time period. Then multiply this ratio by the number of days in the time period.

In this worksheet, Turnover Days is the response. Sales Promotions is the predictor and may explain differences in stock rotation time.

C1	C2
`Turnover Days`	`Sales Promotions`
43.8	4
41.5	1
63.1	6
29.9	6

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Inventory, select Stock rotation.
Select Predict stock rotation, then click OK.
Select Fitted Line Plot, then click OK.
In Response (Y), enter the column that contains the stock rotation data. The response is also called the Y variable.
In Predictor (X), enter a column of numeric data that may explain or predict changes in stock rotation time. The predictor is also called the X variable.
Click OK.

Tip

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