Question: Please do this problem in excel and upload the solution as an excel attachment.Thank you.Also, if you say anything I won't be able to comment

Please do this problem in excel and upload the solution as an excel attachment.Thank you.Also, if you say anything I won't be able to comment or respond as I've tried to comment before & it didin't work.

Please do this problem in excel and upload the solution as an

Question 2 (Module 2): Sales for the past 12 months at the Dalworth Company are given here: Month Sales ($ millions) Month Sales ($ millions) January 20 July 53 February 24 August 62 March 27 September 54 April 31 October 36 May 37 November 32 June 47 December 29 a. Use three-month moving average to forecast the sales for the months April through December. b. Use exponential smoothing with a = 0.6 to forecast the sales for the months April through December. Assume that the initial forecast for January was $22 million. Start error measurement in April. Compare the performance of the two methods by using the mean absolute deviation as the performance criterion, with error measurement beginning in April. Which method would you recommend

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!