The following time series shows the sales of a particular product over the past 12 months. Month Sales 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110
The following time series shows the sales of a particular product over the past 12 months. Month Sales 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter13: Regression And Forecasting Models
Section13.7: Exponential Smoothing Models
Problem 26P: The file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel...
Related questions
Question
100%
The following time series shows the sales of a particular product over the past 12 months.
Month | Sales |
---|---|
1 | 105 |
2 | 135 |
3 | 120 |
4 | 105 |
5 | 90 |
6 | 120 |
7 | 145 |
8 | 140 |
9 | 100 |
10 | 80 |
11 | 100 |
12 | 110 |
(a)Use ? = 0.4 to compute the exponential smoothing values for the time series. (Round your answers to two decimal places.)
Month t | Time Series Value Yt
|
Ft
|
---|---|---|
1 | 105 | |
2 | 135 | |
3 | 120 | |
4 | 105 | |
5 | 90 | |
6 | 120 | |
7 | 145 | |
8 | 140 | |
9 | 100 | |
10 | 80 | |
11 | 100 | |
12 | 110 |
(b)Use a smoothing constant of ? = 0.6 to compute the exponential smoothing forecasts. (Round your answers to two decimal places.)
Month t | Time Series Value Yt
|
Forecast
Ft
|
---|---|---|
1 | 105 | |
2 | 135 | |
3 | 120 | |
4 | 105 | |
5 | 90 | |
6 | 120 | |
7 | 145 | |
8 | 140 | |
9 | 100 | |
10 | 80 | |
11 | 100 | |
12 | 110 |
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 7 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,