Time Series Plot for Visualize Gross Margin Return On Investment and Forecast Gross Margin Return On Investment

Use Time Series Plot to visualize trends in gross margin return on investment. Then you can choose between single exponential smoothing and double exponential smoothing to forecast gross margin return on investment.

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

Example

Gross margin return on investment (GMROI) represents the ability to turn inventory into cash above the cost of the inventory. To calculate gross margin return on investment, divide the gross profit by the inventory cost for the same time period.

In this worksheet, GMROI Ratio is the graph variable in time order.

C1
`GMROI Ratio`
2.6
2.8
3.7
3.5

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then select Launch.
Under Profitability, select Gross margin return on investment.
Select Visualize gross margin return on investment or Forecast gross margin return on investment, 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 gross margin return on investment data.
Click OK.

Tip

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