DigiSonic observes from the sales data that sales of Blu-Ray discs have been decreasing over the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Answer rating: 100% (QA)
It looks like the question youve provided is divided into several parts but I dont see the data or a... View the full answer
Related Book For
Managerial Accounting Creating Value in a Dynamic Business Environment
ISBN: 978-0078025662
10th edition
Authors: Ronald Hilton, David Platt
Posted Date:
Students also viewed these general management questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Research various global financial services organizations (for example, UBS AG, E-Trade, Schwab, ING, Bank of America, HSBC, RBS) through their company websites and other publicly available...
-
Gombas Company decided to analyze certain costs for October of the current year. There was no beginning inventory. Units started into production equaled 14000, units transferred out equal 12000, and...
-
An article in the Journal of Quality Technology (Vol. 14, No. 2, 1982, pp. 8089) describes an experiment in which three different methods of preparing fish are evaluated on the basis of sensory...
-
DiCenta Corporation reported net income of $270,000 in 2010 and had 50,000 shares of common stock outstanding throughout the year. Also outstanding all year were 5,000 shares of cumulative preferred...
-
Which report would be most useful for estimating likely bad debts? a. accounts receivable aging schedule b. profitability analysis c. sales analysis d. cash budget
-
Multiple Choice Questions The following questions concern audit reports other than unqualified audit reports with standard wording. Choose the best response. a. The annual audit of Midwestern...
-
Assume we have a client (Tom). Tom owns one-third of X Co. and has a tax basis in his ownership interest of $30 (not including any debt). Tom has held his interest in X Co. for longer than one year....
-
On July 31, 2019, Ping Company purchased 90% of Santos Company?s common stock for $2,010,000 cash. Immediately after the acquisition, the two companies? balance sheets were as follows: Santos Company...
-
Question 1 Rewrite the following 2 sentences as 1 sentence by using an adjective clause to combine them: There is a storage basin at the bottom of the wall. It collects the water as it trickles down....
-
The average power density produced by the transducer radiating into the dat is 10 mW/cm 2 . If the area pf the transducer is 10 cm 2 and its frequency is 3MHz, determine how much average power will...
-
Ancilla (mass 57 kg) goes skydiving. At one point in her descent, the force of air resistance on Ancilla and her parachute is 670 N [up]. (a) What is the force of gravity on Ancilla? (b) What is the...
-
A baseball bat has 120 J of kinetic energy as it hits a baseball (m = 0.145 kg). (a) If the baseball bat transfers 70 J of its kinetic energy to the baseball, what is the efficiency of the energy...
-
Francesca is a departmental manager in the women's wear department for The Bay. She believes that if she places her line of $100 dresses on sale at 30% off, she would see her sales rise by 79%. The...
-
Ancilla (mass 57 kg) goes skating with Wayne Gretzky (mass 83 kg). At one point when both are standing motionless on the ice, she gives Wayne a push of 200 N [S]. (a) What is Wayne's acceleration?...
-
How will participants be recruited to be part of the study ( The Impact of Therapeutic Interventions on Anxiety, Depression, and Quality of Life in Low-Income Caregivers) ?
-
The Ranch 888 Noodle Company sells two types of dried noodles:ramen, at $6.50 per box, and chow fun, at $7.70 per box. So farthis year, the company has sold a total of 110,096 boxes ofnoodles,...
-
Selected data concerning the past years operations of the Lone Star Leather Company are as follows: Required: 1. What was the cost of raw materials purchased during the year? 2. What was the...
-
How is an investment projects accounting rate of return defined? Why do the accounting rate of return and internal rate of return on a capital project generally differ?
-
Jay Rexford, president of Photo Artistry Company, was just concluding a budget meeting with his senior staff. It was November of 20x4, and the group was discussing preparation of the firms master...
-
On December 31, 2017, Brown Company issued \(\$ 750,000\) of 20 -year, eight percent bonds payable for \(\$ 621,307\), yielding an effective interest rate of ten percent. Interest is payable...
-
On December 31, 2017, Shade Company issued \(\$ 250,000\) of 20 -year, eight percent bonds payable for \(\$ 276,694\), yielding an effective interest rate of seven percent. Interest is payable...
-
Matt Enterprises issued \(\$ 200,000\) of ten percent, five-year bonds with interest payable semiannually. Determine the issue price if the bonds are priced to yield (a) ten percent, (b) six percent,...
Study smarter with the SolutionInn App