Time Series Plot for Visualize Turn-earn Index and Forecast Turn-earn Index

Use Time Series Plot to visualize trends in the turn and earn index. Then you can choose between single exponential smoothing and double exponential smoothing to forecast the turn and earn index.

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

Example

The turn and earn index (T/E Index) balances inventory turnover and profits. To calculate the turn and earn index, multiply inventory turnover and gross profit percentage. For example, if the inventory turns over 10 times in a year and has a 40% profit margin, the turn/earn index is 400.

In this worksheet, T/E Index is the graph variable in time order.

C1
`T/E Index`
223
256
388
319

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Profitability, select Turn-earn index.
Select Visualize turn-earn index or Forecast turn-earn index, then click OK.
Select Time Series Plot, then click OK.
In Series (desktop app) or Y-variable (web app), enter the column that contains the turn and earn index data.
Click OK.

Tip

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