Use Holt-Winter’s multiplicative method to create a seasonal model that minimizes the MSE for the data set. Use Solver to determine the optimal values of alpha, beta, and gamma. We can initialize these variables to 0. a. What are the optimal values of alpha, beta, and gamma? b. What are the forecasts for each of the next 6 months using this technique? Year Month Time Period COGS 1 1 1 21637 2 2 25506 3 3 26594 4 4 21933 5 5 23117 6 6 26979 7 7 28337 8 8 28926 9 9 25015 10 10 28196 11 11 24170 12 12 25004 2 1 13 24575 2 14 35848 3 15 35217 4 16 32759 5 17 36542 6 18 36109 7 19 40279 8 20 37816 9 21 36338 10 22 37814 11 23 39359 12 24 34151 3 1 25 39862 2 26 50664 3 27 48533 4 28 45382 5 29 43981 6 30 41276 7 31 44284 8 32 46920 9 33 47469 10 34 43187
Use Holt-Winter’s multiplicative method to create a seasonal model that minimizes the MSE for the data set. Use Solver to determine the optimal values of alpha, beta, and gamma. We can initialize these variables to 0. a. What are the optimal values of alpha, beta, and gamma? b. What are the forecasts for each of the next 6 months using this technique? Year Month Time Period COGS 1 1 1 21637 2 2 25506 3 3 26594 4 4 21933 5 5 23117 6 6 26979 7 7 28337 8 8 28926 9 9 25015 10 10 28196 11 11 24170 12 12 25004 2 1 13 24575 2 14 35848 3 15 35217 4 16 32759 5 17 36542 6 18 36109 7 19 40279 8 20 37816 9 21 36338 10 22 37814 11 23 39359 12 24 34151 3 1 25 39862 2 26 50664 3 27 48533 4 28 45382 5 29 43981 6 30 41276 7 31 44284 8 32 46920 9 33 47469 10 34 43187
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.3: Simple Regression Models
Problem 1P: The file P13_01.xlsx contains the monthly number of airline tickets sold by a travel agency. a. Does...
Related questions
Question
Use Holt-Winter’s multiplicative method to create a seasonal model that minimizes the MSE for the data set. Use Solver to determine the optimal values of alpha, beta, and gamma. We can initialize these variables to 0.
a. What are the optimal values of alpha, beta, and gamma?
b. What are the
Year | Month | Time Period | COGS |
1 | 1 | 1 | 21637 |
2 | 2 | 25506 | |
3 | 3 | 26594 | |
4 | 4 | 21933 | |
5 | 5 | 23117 | |
6 | 6 | 26979 | |
7 | 7 | 28337 | |
8 | 8 | 28926 | |
9 | 9 | 25015 | |
10 | 10 | 28196 | |
11 | 11 | 24170 | |
12 | 12 | 25004 | |
2 | 1 | 13 | 24575 |
2 | 14 | 35848 | |
3 | 15 | 35217 | |
4 | 16 | 32759 | |
5 | 17 | 36542 | |
6 | 18 | 36109 | |
7 | 19 | 40279 | |
8 | 20 | 37816 | |
9 | 21 | 36338 | |
10 | 22 | 37814 | |
11 | 23 | 39359 | |
12 | 24 | 34151 | |
3 | 1 | 25 | 39862 |
2 | 26 | 50664 | |
3 | 27 | 48533 | |
4 | 28 | 45382 | |
5 | 29 | 43981 | |
6 | 30 | 41276 | |
7 | 31 | 44284 | |
8 | 32 | 46920 | |
9 | 33 | 47469 | |
10 | 34 | 43187 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 14 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,