Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period.
a) Forecast April through September using a three-month moving average
b) Use simple exponential smoothing with an alpha of .3 to estimate April through September
c) Use MAD to decide which method produced the better forecast over the six-month period.
Year Consumption Three-Year Moving Total Three-Year Moving Average Error Exponnetial ...
This solution helps with problems regarding demand management and forecasting. It forecasts a three-month moving average, uses simple exponential smoothing, and uses MAD to decide which method produced best forecast. The solution is provided in an Excel file.