Time Series Plot for Visualize Days Sales Outstanding and Forecast Days Sales Outstanding

Use Time Series Plot to visualize trends in days sales outstanding. Then you can choose between single exponential smoothing and double exponential smoothing to forecast days sales outstanding.

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

Example

Days sales outstanding (DSO) is the average number of days to collect payment for a sale.

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

C1
`DSO`
38
22
36
35

How-to

Choose Solutions Modules > Functions > Supply Chain KPIs, then click Launch.
Under Cycle Time, select Days sales outstanding.
Select Visualize days sales outstanding or Forecast days sales outstanding, 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 days sales outstanding data.
Click OK.

Tip

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