Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1: Following table shows the weekly sales of smart phones at electronic retail store: Week Number of smart phones Sold Forecast using 3 period moving
1: Following table shows the weekly sales of smart phones at electronic retail store: Week Number of smart phones Sold Forecast using 3 period moving average Error Forecast using exponential smoothing (with a=0.4) Error 1 23 14 Strikethrough -23456 7 8 26 33 29 20 Answer the following questions based on the data given above. Show all your calculations. a. What is the expected sales for the 7th week based on 3 period moving average? What is the forecast for the 8th week using the same method if the actual sales for week 7 happens to be 25? (15 Points) ANSWER: Week 7: Week 8: b. What is the expected sales for the 7th week based on exponential smoothing with a = 0.4? (15 Points) ANSWER: Week 7: c. Which of the above two forecasting method is better based on MSE? Why? (20 Points)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started