The following table shows the actual demand observed over the last 11​ years:                                                                                                                                             Year 1 2 3 4 5 6 7 8 9 10 11 Demand 6 8 4 10 11 9 12 12 8 13 6   This exercise contains only parts​ b, c, and d. ​b) Using the​ 3-year moving​ average, provide the forecast from periods 4 through 12 ​(round your responses to one decimal​ place).   Year 4 5 6 7 8 9 10 11 12 Forecast 66 7.337.33 8.338.33 1010 10.6610.66 1111 10.6610.66 1111 99 ​c) Using the​ 3-year weighted moving average with weights 0.15​, 0.30​, and 0.55​, using 0.55 for the most recent​ period, provide the forecast from periods 4 through 12​ (round your responses to two decimal​ places).

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...
icon
Related questions
Question
The following table shows the actual demand observed over the last 11​ years:
                                                                                                                                           
Year
1
2
3
4
5
6
7
8
9
10
11
Demand
6
8
4
10
11
9
12
12
8
13
6
 
This exercise contains only parts​ b, c, and d.
​b) Using the​ 3-year moving​ average, provide the forecast from periods 4 through 12 ​(round your responses to one decimal​ place).
 
Year
4
5
6
7
8
9
10
11
12
Forecast
66
7.337.33
8.338.33
1010
10.6610.66
1111
10.6610.66
1111
99
​c) Using the​ 3-year weighted moving average with weights
0.15​,
0.30​,
and
0.55​,
using
0.55
for the most recent​ period, provide the forecast from periods 4 through 12​ (round your responses to two decimal​ places).
 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Forecasting
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing