Below is a set of Holt-Winters method calculations for predicting truck sales: m=1, alpha=0.2 beta=0.3, gamma=.7. There
Fantastic news! We've Found the answer you've been seeking!
Question:
- Below is a set of Holt-Winter’s method calculations for predicting truck sales: m=1, alpha=0.2 beta=0.3, gamma=.7. There is annual seasonality (a season is 12 months).
Year | Period | Month | Dt | Lt | Tt | St | Ft |
2020 | 22 | Jan | 16249.0 | 18688.3 | 18.0 | 0.87 | 19335.2 |
23 | Feb | 18867.0 | 17687.1 | 13.3 | 1.07 | 22415.0 | |
24 | Mar | 23857.0 | 16454.7 | 7.5 | 1.45 | 29988.3 | |
25 | Apr | 16828.0 | 17166.0 | 10.7 | 0.98 | 14968.6 | |
26 | May | 19062.0 | 18379.6 | 16.4 | 1.04 | 15839.7 | |
27 | Jun | 22724.0 | 19490.3 | 21.5 | 1.17 | 19375.6 | |
28 | Jul | 15320.0 | 21071.6 | 28.7 | 0.73 | 12432.7 | |
29 | Aug | 16936.0 | 22305.5 | 34.4 | 0.76 | 14525.7 | |
30 | Sept | 21986.0 | 21730.3 | 31.5 | 1.01 | 23878.8 | |
31 | Oct | 30998.0 | 22144.7 | 33.3 | 1.40 | 29490.8 | |
32 | Nov | 22359.0 | 21725.9 | 31.2 | 1.03 | 23766.3 | |
33 | Dec | 20860.0 | 23017.7 | 37.1 | 0.91 | 17854.7 | |
2021 | 34 | Jan | 24057.0 | 24642.9 | 44.5 | 0.98 | 20045.5 |
35 | Feb | 23506.0 | 23774.7 | 40.2 | 0.99 | 26334.3 | |
36 | Mar | 27985.0 | 33.0 | 1.26 | 34528.4 | ||
37 | Apr | 24416.0 | 23193.5 | 37.2 | 1.05 | 21855.4 | |
38 | May | 24262.0 | 23286.7 | 37.4 | 1.04 | 24093.2 | |
39 | Jun | 29924.0 | 24130.2 | 41.2 | 1.24 | 27194.0 | |
40 | Jul | 21738.0 | 26143.0 | 50.4 | 0.83 | 17573.7 | |
41 | Aug | 20417.0 | 26433.2 | 51.5 | 0.77 | 19887.9 | |
42 | Sept | 33280.0 | 28690.6 | 61.8 | 1.16 | 26796.3 | |
43 | Oct | 35817.0 | 27662.9 | 56.7 | 1.29 | 40247.5 | |
44 | Nov | 26057.0 | 26893.4 | 52.9 | 0.97 | 28527.3 | |
45 | Dec | 23742.0 | 26688.6 | 0.89 | 24420.2 | ||
2022 | 46 | Jan | 26259.0 | 26794.8 | 51.9 | 0.98 | 26104.5 |
47 | Feb | 23995.0 | 25959.5 | 47.8 | 0.92 | 26543.2 | |
48 | Mar | 28421.0 | 24837.3 | 42.3 | 1.14 | 32693.9 | |
49 | Apr | 22357.0 | 23625.9 | 36.5 | 0.95 | 26190.9 | |
50 | May | 23488.0 | 23277.4 | 34.7 | 1.01 | 24653.4 | |
51 | Jun | 29631.0 | 23512.3 | 35.6 | 1.26 | 28909.4 | |
52 | Jul | 20594.0 | 23967.6 | 37.6 | 0.86 | 19580.2 | |
53 | Aug | 20051.0 | 24677.9 | 40.7 | 0.81 | 18541.6 | |
54 | Sept | 27466.0 | 24360.5 | 39.0 | 1.13 | 28672.6 | |
55 | Oct | 34778.0 | 25246.7 | 43.0 | 31591.7 | ||
56 | Nov | 25839.0 | 25764.2 | 45.2 | 1.00 | 24503.2 | |
57 | Dec | 23053.0 | 25845.5 | 45.4 | 0.89 | 22959.9 | |
2023 | 58 | Jan |
- Calculate L36
- Calculate T45
- Calculate S55
- Forecast January 2023.
Related Book For
Data Analysis and Decision Making
ISBN: 978-0538476126
4th edition
Authors: Christian Albright, Wayne Winston, Christopher Zappe
Posted Date: