Question: Complete the table, using the Holt Winters Multiplicative Model. For the information presented below please find the level (l), growth rate (b), seasonal factor (sn),
Complete the table, using the Holt Winters Multiplicative Model. For the information presented below please find the level (l), growth rate (b), seasonal factor (sn), forecast, forecast error, squared forecast error, SSE, MSE and s for period # 1 to 4 using the Holt Winter Multiplicative forecasting method. Assume four quarters in a year as four seasons. Please show your calculations. (20 points)
| n | alpha | gamma | delta | SSE | MSE | s | |
| 4 | 0.2000 | 0.1000 | 0.1000 | ||||
| Forecast | Squared | ||||||
| Growth | Seasonal | Made Last | Forecast | Forecast | |||
| Time | y | Level | Rate | Factor | Period | Error | Error |
| -3 | 0.7062 | ||||||
| -2 | 1.1114 | ||||||
| -1 | 1.2937 | ||||||
| 0 | 95.25 | 2.4706 | 0.8886 | ||||
| 1 | 72 | ||||||
| 2 | 116 | ||||||
| 3 | 136 | ||||||
| 4 | 96 |
Show all steps and calculations, do not show an excel sheet please, thank you!
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
