Centerville Bikes and Stuff (CBS) sells motorcycles and accessories. The number of helmets sold by CBS per week for the past six weeks follows. Week 1 2 3 4 5 6 Value 18 11 14 10 17 12   (b) Develop the three-week moving average for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 18   2 11   3 14   4 10   5 17   6 12   Compute MSE. (Round your answer to two decimal places.) MSE =    What is the forecast for week 7?   (c)Use ? = 0.2 to compute the exponential smoothing values for the time series.   Week Time Series Value Forecast 1 18   2 11   3 14   4 10   5 17   6 12   Compute MSE. (Round your answer to two decimal places.) MSE =    What is the forecast for week 7? (Round your answer to two decimal places.)   (e)Use ? = 0.4 to compute the exponential smoothing values for the time series.   Week Time Series Value Forecast 1 18   2 11   3 14   4 10   5 17   6 12

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
icon
Concept explainers
Question
Centerville Bikes and Stuff (CBS) sells motorcycles and accessories. The number of helmets sold by CBS per week for the past six weeks follows.
Week 1 2 3 4 5 6
Value 18 11 14 10 17 12
 
(b)
Develop the three-week moving average for this time series. (Round your answers to two decimal places.)
Week Time Series
Value
Forecast
1 18  
2 11  
3 14  
4 10  
5 17  
6 12  

Compute MSE. (Round your answer to two decimal places.)

MSE = 
 
What is the forecast for week 7?
 
(c)Use ? = 0.2 to compute the exponential smoothing values for the time series.
 
Week Time Series
Value
Forecast
1 18  
2 11  
3 14  
4 10  
5 17  
6 12  

Compute MSE. (Round your answer to two decimal places.)

MSE = 
 
What is the forecast for week 7? (Round your answer to two decimal places.)
 
(e)Use ? = 0.4 to compute the exponential smoothing values for the time series.
 
Week Time Series
Value
Forecast
1 18  
2 11  
3 14  
4 10  
5 17  
6 12  
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 6 images

Blurred answer
Knowledge Booster
Advertising
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
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