Question: Based on your calculations for the Holt-Winter's forecasting method, what are the following? The forecast for period 126 is The MAD for the forecast is












Based on your calculations for the Holt-Winter's forecasting method, what are the following? The forecast for period 126 is The MAD for the forecast is The seasonal value for period 115 is The trend value for period 110 is The expected level or base value for period 62 is Using the Holt-Winter's forecasting method and the data below, forecast Period 53 through Period 156 and determine the MAD using the forecast for Period 53 through Period 156. Alpha, beta, and gamma must all equal 0.7. You will be forecasting Grabeez Cup Sales. Actual Grabeez Cup Sales are provided in the data below. \begin{tabular}{|c|c|c|c|} \hline Year & Week & Period & Actual Grabeez Cup Sales \\ \hline 2018 & 1 & 1 & 5,418 \\ \hline 2018 & 2 & 2 & 7,856 \\ \hline 2018 & 3 & 3 & 8,495 \\ \hline 2018 & 4 & 4 & 4,706 \\ \hline 2018 & 5 & 5 & 6,733 \\ \hline 2018 & 6 & 6 & 7,098 \\ \hline 2018 & 7 & 7 & 3,875 \\ \hline 2018 & 8 & 8 & 5,103 \\ \hline 2018 & 9 & 9 & 8,587 \\ \hline 2018 & 10 & 10 & 9,108 \\ \hline 2018 & 11 & 11 & 6,955 \\ \hline 2018 & 12 & 12 & 7,768 \\ \hline 2018 & 13 & 13 & 9,902 \\ \hline 2018 & 14 & 14 & 11,111 \\ \hline 2018 & 15 & 15 & 4,496 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2018 & 16 & 16 & 4,360 \\ \hline 2018 & 17 & 17 & 8,465 \\ \hline 2018 & 18 & 18 & 7,533 \\ \hline 2018 & 19 & 19 & 3,927 \\ \hline 2018 & 20 & 20 & 4,698 \\ \hline 2018 & 21 & 21 & 10,685 \\ \hline 2018 & 22 & 22 & 3,875 \\ \hline 2018 & 23 & 23 & 8,929 \\ \hline 2018 & 24 & 24 & 7,127 \\ \hline 2018 & 25 & 25 & 7,352 \\ \hline 2018 & 26 & 26 & 11,078 \\ \hline 2018 & 27 & 27 & 10,105 \\ \hline 2018 & 28 & 28 & 9,895 \\ \hline 2018 & 29 & 29 & 9,597 \\ \hline 2018 & 30 & 30 & 6,250 \\ \hline 2018 & 31 & 31 & 4,026 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2018 & 32 & 32 & 5,681 \\ \hline 2018 & 33 & 33 & 7,518 \\ \hline 2018 & 34 & 34 & 7,167 \\ \hline 2018 & 35 & 35 & 8,532 \\ \hline 2018 & 36 & 36 & 7,092 \\ \hline 2018 & 37 & 37 & 7,314 \\ \hline 2018 & 38 & 38 & 4,015 \\ \hline 2018 & 39 & 39 & 5,162 \\ \hline 2018 & 40 & 40 & 9,660 \\ \hline 2018 & 41 & 41 & 7,314 \\ \hline 2018 & 42 & 42 & 9,895 \\ \hline 2018 & 43 & 43 & 5,790 \\ \hline 2018 & 44 & 44 & 10,004 \\ \hline 2018 & 45 & 45 & 10,508 \\ \hline 2018 & 46 & 46 & 5,657 \\ \hline 2018 & 47 & 47 & 7,241 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2018 & 48 & 48 & 9,332 \\ \hline 2018 & 49 & 49 & 5,504 \\ \hline 2018 & 50 & 50 & 8,877 \\ \hline 2018 & 51 & 51 & 7,247 \\ \hline 2018 & 52 & 52 & 5,966 \\ \hline 2019 & 1 & 53 & 6,138 \\ \hline 2019 & 2 & 54 & 7,686 \\ \hline 2019 & 3 & 55 & 5,660 \\ \hline 2019 & 4 & 56 & 5,021 \\ \hline 2019 & 5 & 57 & 10,473 \\ \hline 2019 & 6 & 58 & 6,955 \\ \hline 2019 & 7 & 59 & 4,813 \\ \hline 2019 & 8 & 60 & 4,975 \\ \hline 2019 & 9 & 61 & 5,941 \\ \hline 2019 & 10 & 62 & 4,689 \\ \hline 2019 & 11 & 63 & 3,963 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2019 & 12 & 64 & 10,773 \\ \hline 2019 & 13 & 65 & 3,889 \\ \hline 2019 & 14 & 66 & 4,624 \\ \hline 2019 & 15 & 67 & 8,215 \\ \hline 2019 & 16 & 68 & 5,697 \\ \hline 2019 & 17 & 69 & 5,315 \\ \hline 2019 & 18 & 70 & 8,597 \\ \hline 2019 & 19 & 71 & 7,197 \\ \hline 2019 & 20 & 72 & 6,789 \\ \hline 2019 & 21 & 73 & 4,971 \\ \hline 2019 & 22 & 74 & 4,064 \\ \hline 2019 & 23 & 75 & 9,673 \\ \hline 2019 & 24 & 76 & 4,601 \\ \hline 2019 & 25 & 77 & 8,688 \\ \hline 2019 & 26 & 78 & 10,700 \\ \hline 2019 & 27 & 79 & 10,082 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2019 & 28 & 80 & 4,969 \\ \hline 2019 & 29 & 81 & 6,873 \\ \hline 2019 & 30 & 82 & 8,480 \\ \hline 2019 & 31 & 83 & 7,888 \\ \hline 2019 & 32 & 84 & 10,945 \\ \hline 2019 & 33 & 85 & 4,265 \\ \hline 2019 & 34 & 86 & 5,080 \\ \hline 2019 & 35 & 87 & 9,349 \\ \hline 2019 & 36 & 88 & 8,553 \\ \hline 2019 & 37 & 89 & 8,791 \\ \hline 2019 & 38 & 90 & 9,137 \\ \hline 2019 & 39 & 91 & 10,097 \\ \hline 2019 & 40 & 92 & 9,267 \\ \hline 2019 & 41 & 93 & 5,447 \\ \hline 2019 & 42 & 94 & 3,854 \\ \hline 2019 & 43 & 95 & 6,827 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2019 & 44 & 96 & 8,165 \\ \hline 2019 & 45 & 97 & 10,357 \\ \hline 2019 & 46 & 98 & 10,437 \\ \hline 2019 & 47 & 99 & 9,973 \\ \hline 2019 & 48 & 100 & 11,004 \\ \hline 2019 & 49 & 101 & 5,613 \\ \hline 2019 & 50 & 102 & 9,322 \\ \hline 2019 & 51 & 103 & 9,469 \\ \hline 2019 & 52 & 104 & 9,234 \\ \hline 2020 & 1 & 105 & 4,513 \\ \hline 2020 & 2 & 106 & 8,532 \\ \hline 2020 & 3 & 107 & 8,014 \\ \hline 2020 & 4 & 108 & 9,776 \\ \hline 2020 & 5 & 109 & 6,275 \\ \hline 2020 & 6 & 110 & 9,143 \\ \hline 2020 & 7 & 111 & 8,072 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2020 & 8 & 112 & 6,573 \\ \hline 2020 & 9 & 113 & 10,660 \\ \hline 2020 & 10 & 114 & 8,667 \\ \hline 2020 & 11 & 115 & 7,188 \\ \hline 2020 & 12 & 116 & 10,156 \\ \hline 2020 & 13 & 117 & 3,778 \\ \hline 2020 & 14 & 118 & 3,772 \\ \hline 2020 & 15 & 119 & 7,356 \\ \hline 2020 & 16 & 120 & 11,040 \\ \hline 2020 & 17 & 121 & 7,232 \\ \hline 2020 & 18 & 122 & 6,334 \\ \hline 2020 & 19 & 123 & 6,336 \\ \hline 2020 & 20 & 124 & 5,277 \\ \hline 2020 & 21 & 125 & 4,736 \\ \hline 2020 & 22 & 126 & 9,137 \\ \hline 2020 & 23 & 127 & 8,186 \\ \hline 2020 & 24 & 128 & 6,785 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|} \hline 2020 & 25 & 129 & 5,240 \\ \hline 2020 & 26 & 130 & 5,544 \\ \hline 2020 & 27 & 131 & 7,054 \\ \hline 2020 & 28 & 132 & 5,013 \\ \hline 2020 & 29 & 133 & 7,812 \\ \hline 2020 & 30 & 134 & 5,240 \\ \hline 2020 & 31 & 135 & 8,891 \\ \hline 2020 & 32 & 136 & 6,235 \\ \hline 2020 & 33 & 137 & 4,257 \\ \hline 2020 & 34 & 138 & 4,316 \\ \hline 2020 & 35 & 139 & 8,108 \\ \hline 2020 & 36 & 140 & 8,673 \\ \hline 2020 & 37 & 141 & 7,953 \\ \hline 2020 & 38 & 142 & 8,665 \\ \hline 2020 & 39 & 143 & 4,660 \\ \hline 2020 & 40 & 144 & 4,824 \\ \hline 2020 & 41 & 145 & 8,936 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2020 & 41 & 145 & 8,936 \\ \hline 2020 & 42 & 146 & 10,870 \\ \hline 2020 & 43 & 147 & 4,286 \\ \hline 2020 & 44 & 148 & 5,941 \\ \hline 2020 & 45 & 149 & 9,322 \\ \hline 2020 & 46 & 150 & 7,638 \\ \hline 2020 & 47 & 151 & 4,475 \\ \hline 2020 & 48 & 152 & 6,607 \\ \hline 2020 & 49 & 153 & 4,175 \\ \hline 2020 & 50 & 154 & 10,847 \\ \hline 2020 & 51 & 155 & 3,854 \\ \hline 2020 & 52 & 156 & 10,223 \\ \hline \end{tabular} Based on your calculations for the Holt-Winter's forecasting method, what are the following? The forecast for period 126 is The MAD for the forecast is The seasonal value for period 115 is The trend value for period 110 is The expected level or base value for period 62 is Using the Holt-Winter's forecasting method and the data below, forecast Period 53 through Period 156 and determine the MAD using the forecast for Period 53 through Period 156. Alpha, beta, and gamma must all equal 0.7. You will be forecasting Grabeez Cup Sales. Actual Grabeez Cup Sales are provided in the data below. \begin{tabular}{|c|c|c|c|} \hline Year & Week & Period & Actual Grabeez Cup Sales \\ \hline 2018 & 1 & 1 & 5,418 \\ \hline 2018 & 2 & 2 & 7,856 \\ \hline 2018 & 3 & 3 & 8,495 \\ \hline 2018 & 4 & 4 & 4,706 \\ \hline 2018 & 5 & 5 & 6,733 \\ \hline 2018 & 6 & 6 & 7,098 \\ \hline 2018 & 7 & 7 & 3,875 \\ \hline 2018 & 8 & 8 & 5,103 \\ \hline 2018 & 9 & 9 & 8,587 \\ \hline 2018 & 10 & 10 & 9,108 \\ \hline 2018 & 11 & 11 & 6,955 \\ \hline 2018 & 12 & 12 & 7,768 \\ \hline 2018 & 13 & 13 & 9,902 \\ \hline 2018 & 14 & 14 & 11,111 \\ \hline 2018 & 15 & 15 & 4,496 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2018 & 16 & 16 & 4,360 \\ \hline 2018 & 17 & 17 & 8,465 \\ \hline 2018 & 18 & 18 & 7,533 \\ \hline 2018 & 19 & 19 & 3,927 \\ \hline 2018 & 20 & 20 & 4,698 \\ \hline 2018 & 21 & 21 & 10,685 \\ \hline 2018 & 22 & 22 & 3,875 \\ \hline 2018 & 23 & 23 & 8,929 \\ \hline 2018 & 24 & 24 & 7,127 \\ \hline 2018 & 25 & 25 & 7,352 \\ \hline 2018 & 26 & 26 & 11,078 \\ \hline 2018 & 27 & 27 & 10,105 \\ \hline 2018 & 28 & 28 & 9,895 \\ \hline 2018 & 29 & 29 & 9,597 \\ \hline 2018 & 30 & 30 & 6,250 \\ \hline 2018 & 31 & 31 & 4,026 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2018 & 32 & 32 & 5,681 \\ \hline 2018 & 33 & 33 & 7,518 \\ \hline 2018 & 34 & 34 & 7,167 \\ \hline 2018 & 35 & 35 & 8,532 \\ \hline 2018 & 36 & 36 & 7,092 \\ \hline 2018 & 37 & 37 & 7,314 \\ \hline 2018 & 38 & 38 & 4,015 \\ \hline 2018 & 39 & 39 & 5,162 \\ \hline 2018 & 40 & 40 & 9,660 \\ \hline 2018 & 41 & 41 & 7,314 \\ \hline 2018 & 42 & 42 & 9,895 \\ \hline 2018 & 43 & 43 & 5,790 \\ \hline 2018 & 44 & 44 & 10,004 \\ \hline 2018 & 45 & 45 & 10,508 \\ \hline 2018 & 46 & 46 & 5,657 \\ \hline 2018 & 47 & 47 & 7,241 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2018 & 48 & 48 & 9,332 \\ \hline 2018 & 49 & 49 & 5,504 \\ \hline 2018 & 50 & 50 & 8,877 \\ \hline 2018 & 51 & 51 & 7,247 \\ \hline 2018 & 52 & 52 & 5,966 \\ \hline 2019 & 1 & 53 & 6,138 \\ \hline 2019 & 2 & 54 & 7,686 \\ \hline 2019 & 3 & 55 & 5,660 \\ \hline 2019 & 4 & 56 & 5,021 \\ \hline 2019 & 5 & 57 & 10,473 \\ \hline 2019 & 6 & 58 & 6,955 \\ \hline 2019 & 7 & 59 & 4,813 \\ \hline 2019 & 8 & 60 & 4,975 \\ \hline 2019 & 9 & 61 & 5,941 \\ \hline 2019 & 10 & 62 & 4,689 \\ \hline 2019 & 11 & 63 & 3,963 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2019 & 12 & 64 & 10,773 \\ \hline 2019 & 13 & 65 & 3,889 \\ \hline 2019 & 14 & 66 & 4,624 \\ \hline 2019 & 15 & 67 & 8,215 \\ \hline 2019 & 16 & 68 & 5,697 \\ \hline 2019 & 17 & 69 & 5,315 \\ \hline 2019 & 18 & 70 & 8,597 \\ \hline 2019 & 19 & 71 & 7,197 \\ \hline 2019 & 20 & 72 & 6,789 \\ \hline 2019 & 21 & 73 & 4,971 \\ \hline 2019 & 22 & 74 & 4,064 \\ \hline 2019 & 23 & 75 & 9,673 \\ \hline 2019 & 24 & 76 & 4,601 \\ \hline 2019 & 25 & 77 & 8,688 \\ \hline 2019 & 26 & 78 & 10,700 \\ \hline 2019 & 27 & 79 & 10,082 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2019 & 28 & 80 & 4,969 \\ \hline 2019 & 29 & 81 & 6,873 \\ \hline 2019 & 30 & 82 & 8,480 \\ \hline 2019 & 31 & 83 & 7,888 \\ \hline 2019 & 32 & 84 & 10,945 \\ \hline 2019 & 33 & 85 & 4,265 \\ \hline 2019 & 34 & 86 & 5,080 \\ \hline 2019 & 35 & 87 & 9,349 \\ \hline 2019 & 36 & 88 & 8,553 \\ \hline 2019 & 37 & 89 & 8,791 \\ \hline 2019 & 38 & 90 & 9,137 \\ \hline 2019 & 39 & 91 & 10,097 \\ \hline 2019 & 40 & 92 & 9,267 \\ \hline 2019 & 41 & 93 & 5,447 \\ \hline 2019 & 42 & 94 & 3,854 \\ \hline 2019 & 43 & 95 & 6,827 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2019 & 44 & 96 & 8,165 \\ \hline 2019 & 45 & 97 & 10,357 \\ \hline 2019 & 46 & 98 & 10,437 \\ \hline 2019 & 47 & 99 & 9,973 \\ \hline 2019 & 48 & 100 & 11,004 \\ \hline 2019 & 49 & 101 & 5,613 \\ \hline 2019 & 50 & 102 & 9,322 \\ \hline 2019 & 51 & 103 & 9,469 \\ \hline 2019 & 52 & 104 & 9,234 \\ \hline 2020 & 1 & 105 & 4,513 \\ \hline 2020 & 2 & 106 & 8,532 \\ \hline 2020 & 3 & 107 & 8,014 \\ \hline 2020 & 4 & 108 & 9,776 \\ \hline 2020 & 5 & 109 & 6,275 \\ \hline 2020 & 6 & 110 & 9,143 \\ \hline 2020 & 7 & 111 & 8,072 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2020 & 8 & 112 & 6,573 \\ \hline 2020 & 9 & 113 & 10,660 \\ \hline 2020 & 10 & 114 & 8,667 \\ \hline 2020 & 11 & 115 & 7,188 \\ \hline 2020 & 12 & 116 & 10,156 \\ \hline 2020 & 13 & 117 & 3,778 \\ \hline 2020 & 14 & 118 & 3,772 \\ \hline 2020 & 15 & 119 & 7,356 \\ \hline 2020 & 16 & 120 & 11,040 \\ \hline 2020 & 17 & 121 & 7,232 \\ \hline 2020 & 18 & 122 & 6,334 \\ \hline 2020 & 19 & 123 & 6,336 \\ \hline 2020 & 20 & 124 & 5,277 \\ \hline 2020 & 21 & 125 & 4,736 \\ \hline 2020 & 22 & 126 & 9,137 \\ \hline 2020 & 23 & 127 & 8,186 \\ \hline 2020 & 24 & 128 & 6,785 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|} \hline 2020 & 25 & 129 & 5,240 \\ \hline 2020 & 26 & 130 & 5,544 \\ \hline 2020 & 27 & 131 & 7,054 \\ \hline 2020 & 28 & 132 & 5,013 \\ \hline 2020 & 29 & 133 & 7,812 \\ \hline 2020 & 30 & 134 & 5,240 \\ \hline 2020 & 31 & 135 & 8,891 \\ \hline 2020 & 32 & 136 & 6,235 \\ \hline 2020 & 33 & 137 & 4,257 \\ \hline 2020 & 34 & 138 & 4,316 \\ \hline 2020 & 35 & 139 & 8,108 \\ \hline 2020 & 36 & 140 & 8,673 \\ \hline 2020 & 37 & 141 & 7,953 \\ \hline 2020 & 38 & 142 & 8,665 \\ \hline 2020 & 39 & 143 & 4,660 \\ \hline 2020 & 40 & 144 & 4,824 \\ \hline 2020 & 41 & 145 & 8,936 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline 2020 & 41 & 145 & 8,936 \\ \hline 2020 & 42 & 146 & 10,870 \\ \hline 2020 & 43 & 147 & 4,286 \\ \hline 2020 & 44 & 148 & 5,941 \\ \hline 2020 & 45 & 149 & 9,322 \\ \hline 2020 & 46 & 150 & 7,638 \\ \hline 2020 & 47 & 151 & 4,475 \\ \hline 2020 & 48 & 152 & 6,607 \\ \hline 2020 & 49 & 153 & 4,175 \\ \hline 2020 & 50 & 154 & 10,847 \\ \hline 2020 & 51 & 155 & 3,854 \\ \hline 2020 & 52 & 156 & 10,223 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
