Answered step by step
Verified Expert Solution
Question
1 Approved Answer
DigiSonic observes from the sales data that sales of Blu-Ray discs have been decreasing over the last year. As mentioned earlier, this is due
DigiSonic observes from the sales data that sales of Blu-Ray discs have been decreasing over the last year. As mentioned earlier, this is due to the increasing popularity of online movie platforms among customers. DigiSonic wants to incorporate this decreasing trend into its forecasts. You have learned that the double exponential smoothing method accounts for such trends in the data. a. Use the double (trend-adjusted) exponential smoothing method to forecast sales for months 2 to 13 (1.e., F2 to F13), assuming $1=1376 and T1=-25 and set x=0.8 and 3=0.2 (10pt) b. Create a plot showing the actual sales, the double exponential smoothing forecast, and the forecast obtained using simple exponential smoothing in Problem 2 with a=0.8 for months 1 to 12 on the same graph. (3pt) c. Compute MAE and MAPE for months 2 through 12 for the double exponential smoothing forecast and compare them with those of simple exponential smoothing in problem 2(c). Based on your calculations, is single or double exponential smoothing a better approach in this specific case? Why? (3pt) d. Develop a simple linear regression model using month as the independent variable to forecast the DigiSonic's Blu-Ray disc sales for month 13 (ie., F13). Compare this forecast to the forecast obtained in part (a) for sales in month 13. Based on this, explain the difference between the two methods (regression, double exponential smoothing). (9pt) The Excel table on the left calculates MAE and MCE using 3-month simple moving average, the table on the left uses a 3-month weighted average method with weights of 0.5, 0.3 and 0.2 if that helps at all Thanks.
Step by Step Solution
★★★★★
3.32 Rating (149 Votes )
There are 3 Steps involved in it
Step: 1
It looks like the question youve provided is divided into several parts but I dont see the data or a...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