Answered step by step
Verified Expert Solution
Link Copied!

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Creating Value in a Dynamic Business Environment

Authors: Ronald Hilton, David Platt

10th edition

78025664, 978-0078025662

More Books

Students also viewed these General Management questions