90.2K
Verified Solution
Link Copied!
SHOW YOUR WORK
| Year | 1990 | 1991 | 1992 | 1993 | 1994 |
| Forecast | 11,800 | 13,100 | 14,325 | 17,030 | ? |
| Actual Demand | 12,075 | 13,885 | 16,015 | 16,542 | |
Calculate MAD for the period 1991-1993
Calculate forecast using exponential smoothing. The smoothing constant () is 0.25.
Using the information below and you answer for B above, calculate the quarterly seasonal index and 2023 monthly forecast.
| Month | 1990 | 1991 | 1992 | 1993 | X | Seasonal Index | 2023 Forecast |
| 1st Quarter | 2900 | 3110 | 3210 | 3618 | | | |
| 2nd Quarter | 3050 | 4175 | 4425 | 4517 | | | |
| 3rd Quarter | 3200 | 3250 | 3975 | 4011 | | | |
| 4th Quarter | 2925 | 3350 | 4405 | 4396 | | | |
| Total | | | | | | | |
Answer & Explanation
Solved by verified expert
