Fitted Line Plot for Predict Total Supply Chain Management Cost As A Proportion Of Sales

Use Fitted Line Plot to use one continuous predictor to predict total supply chain management cost as a proportion of sales.

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

Example

Total supply chain management cost as a proportion of sales is the total supply chain costs for a specific time period divided by the total sales.

In this worksheet, Total Cost Proportion is the response. Number of Obsolete Items is the predictor and may explain differences in cost proportions.

C1	C2
`Total Cost Proportion`	`Number of Obsolete Items`
0.154	1500
0.143	675
0.167	2075
0.139	438

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Costs, select Cost as a proportion of sales.
Select Predict total supply chain management cost as a proportion of sales, then click OK.
Select Fitted Line Plot, then click OK.
In Response (Y), enter the column that contains the proportions 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 the cost as a proportion of sales. The predictor is also called the X variable.
Click OK.

Tip

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