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.

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
Get step-by-step solutions from verified subject matter experts
