Weighted Moving Average Calculator

About the Weighted Moving Average Calculator

The Weighted Moving Average (WMA) forecast assigns different weights to each of the last N demand periods, allowing you to emphasize more recent data. Unlike a simple moving average that weights all periods equally, WMA lets you control how much influence each period has on the forecast.

Typically, the most recent period receives the highest weight, the next most recent gets a lower weight, and so on. The forecast equals the sum of each period's demand multiplied by its weight, divided by the sum of all weights.

This calculator lets you enter demand values and corresponding weights for up to six periods. It normalizes the weights and computes the weighted average forecast for the next period.

Use the result to compare operating scenarios, pressure-test assumptions, and rerun the model when volumes, rates, or service targets change.

When This Page Helps

When demand is changing, giving more weight to recent periods produces a more responsive forecast than a simple moving average. This calculator makes it easy to experiment with different weight schemes to find the combination that best tracks your demand pattern.

How to Use the Inputs

1. Enter demand values for recent periods (most recent last).
2. Enter corresponding weights for each period (highest weight for most recent).
3. The calculator normalizes weights so they sum to 1.
4. Review the weighted moving average forecast.
5. Adjust weights to increase or decrease responsiveness to recent changes.
6. Validate by comparing forecasts to subsequent actual demand.

Example Calculation

Tips & Best Practices

• A common weight scheme is 1, 2, 3 for three periods — giving triple weight to the most recent period.
• Weights don't need to sum to 1 — the calculator normalizes them automatically.
• For trending demand, progressively heavier weights on recent data improve tracking.
• Compare WMA results to SMA to see if the added complexity improves accuracy.
• Use error metrics (MAD, MAPE, MSE) to objectively evaluate different weight schemes.
• WMA is a good stepping stone between simple moving average and exponential smoothing.

Weight Schemes in Practice

Common weight schemes include linear (1, 2, 3, ..., N), triangular, and custom patterns. Linear weights are the most popular because they are intuitive and provide a good balance between responsiveness and stability. More aggressive schemes concentrate weight heavily on the last 1–2 periods.

WMA vs Exponential Smoothing

Both methods emphasize recent data, but they differ in implementation. WMA uses explicit weights for a fixed window. Exponential smoothing implicitly weights all historical data with exponentially decaying influence controlled by a single parameter. For most applications, exponential smoothing is preferred for its simplicity.

When to Use WMA

WMA is most useful when you have strong domain knowledge about how much each past period should influence the forecast. For example, if the last two months are highly relevant but earlier months are unreliable due to a known disruption, you can zero out their weights. This flexibility is WMA's key advantage.

Frequently Asked Questions

• How is WMA different from SMA?

  SMA gives equal weight to all periods in the average. WMA assigns custom weights, typically giving more importance to recent periods. This makes WMA more responsive to demand changes than SMA.

• How do I choose the right weights?

  Start with linearly increasing weights (1, 2, 3, ...) and test against historical data. Adjust to minimize forecast error. Some planners use exponentially increasing weights for faster responsiveness.

• How many periods should I include?

  Typically 3 to 6 periods. Including too many periods dilutes the benefit of differential weighting. The optimal number depends on your demand pattern stability and forecasting horizon.

• Is WMA better than exponential smoothing?

  Exponential smoothing is generally preferred because it automatically applies exponentially decreasing weights with just one parameter (α). WMA requires choosing individual weights for each period, which is more flexible but harder to optimize.

• Can WMA handle seasonal demand?

  WMA does not inherently handle seasonality. For seasonal demand, consider deseasonalizing the data before applying WMA, or use a seasonal forecasting method like Holt-Winters.

• Do the weights need to sum to 1?

  No. The calculator divides the weighted sum by the total weight, so any weight values work. Using integers like 1, 2, 3 is simpler than fractions like 0.167, 0.333, 0.500.