Question: Develop forecasts for June through October using these techniques: moving average of three period, simple exponential smoothing, and Holt's method (trend-corrected exponential smoothing). (10 points)

Develop forecasts for June through October using these techniques: moving average of three period, simple exponential smoothing, and Holt's method (trend-corrected exponential smoothing). (10 points)

Historical demand for Peeps is as displayed in the table.

Month

Demand

January

15

February

22

March

33

April

42

May

51

June

58

July

70

August

78

September

86

  1. Develop forecasts for June through October using the 3-period moving average technique.
  2. Develop forecasts for June through October using the simple exponential smoothing with an alpha of 0.3. For the simple exponential smoothing model assume that the forecast for May is the actual demand for May.
  3. Develop forecasts for June through October using the Holt's method (trend-corrected exponential smoothing). For Holt's model the regression equation has an intercept of 10.0 (FJan=10.0) and a trend component of 8.0 (TJan=8.0). Beta = 0.2 and alpha = 0.4.

Evaluate the three forecasts using the accuracy measure MAD for only June-September. Identify the forecasting method which is the most accurate and comment on the use of these three methods to generate a forecast in this situation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!