Method 9: Weighted Moving Average

The Weighted Moving Average formula is similar to Method 4, Moving Average formula, because it averages the previous month's sales history to project the next month's sales history. However, with this formula you can assign weights for each of the prior periods.

This method requires the number of weighted periods selected plus the number of periods best fit data. Similar to Moving Average, this method lags behind demand trends, so this method is not recommended for products with strong trends or seasonality. This method is useful to forecast demand for mature products with demand that is relatively level.