Demand Forecast Calculator

Forecast demand using moving average, weighted MA, and exponential smoothing.

Month 1 Actual

Month 2 Actual

Month 3 Actual

Month 4 Actual

Month 5 Actual

Month 6 Actual

Smoothing Factor (alpha)

Tab to move between fields

SMA Forecast (Next Month)

1,217

WMA Forecast1,233

Exponential Smoothing Forecast1,204

Trend-Based Forecast1,313

Monthly Trend (units)51.4

Monthly Growth Rate4.5%

Average Demand1,133

How to Use This Calculator

Enter historical demand data for the relevant period.
Select the forecasting method (simple moving average, weighted average, or exponential smoothing).
Set the smoothing factor or number of periods as required by the method.
Review the forecast for the next period and the mean absolute percentage error (MAPE).
Lower MAPE indicates better forecast accuracy — adjust the method or parameters to minimize it.

Ad Placeholder

Related Calculators

Calculate buffer inventory needed to prevent stockouts.

Calculate when to reorder inventory based on lead time and demand.

Calculate the optimal order size using the EOQ formula.

Ad Placeholder