Use Excel to solve the following:

a. Compute a three-month moving average forecast of demand for April through January (of the next year)

b. Compute 3 month weighted moving average forecast with weights 0.5 for the most recent month/data, 0.3 for the next most recent data and 0.2 for the distant data

c. Compute exponentially smoothed forecast with = 0.3

d. Compare the three forecasts in (a), (b) and (c) above using MAD, and indicate which seems to be the most accurate

12.1 The Hartley-Davis motorcycle dealer in the Minneapolis-St. Paul area wants to be able to forecast accurately the demand for the Roadhog Super motorcycle during the next month. From sales records, the dealer has accumulated the data in the following table for the past year. MONTH MOTORCYCLE SALES January 9 February 7 March 10 April 8 May 7 June 12 July 10 August 11 September 12 October 10 November 14 December 16