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 |
- Develop forecasts for June through October using the 3-period moving average technique.
- 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.
- 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
Get step-by-step solutions from verified subject matter experts
