Ben Swanson, owner and manager of Swanson€™s Department Store, has decided to use statistical forecasting to get a better handle on the demand for his major products. However, Ben now needs to decide which forecasting method is most appropriate for each category of product. One category is major household appliances, such as washing machines, which have a relatively stable sales level. Monthly sales of washing machines last year are shown below.

(a) Considering that the sales level is relatively stable, which of the most basic forecasting methods€”the last-value method or the averaging method or the moving-average method€”do you feel would be most appropriate for forecasting future sales? Why?
T (b) Use the last-value method retrospectively to determine what the forecasts would have been for the last 11 months of last year. What is MAD?
T (c) Use the averaging method retrospectively to determine what the forecasts would have been for the last 11 months of last year. What is MAD?
T (d) Use the moving-average method with n 3 retrospectively to determine what the forecasts would have been for the last 9 months of last year. What is MAD?
(e) Use their MAD values to compare the three methods.
(f) Use their MSE values to compare the three methods.
(g) Do you feel comfortable in drawing a definitive conclusion about which of the three forecasting methods should be the most accurate in the future based on these 12 months of data?

Transcribed Image Text:

Month Sales Month SalesMonth Sales January 22 September 21 May Febary 24 June 22 July 23 27 October March April 29 20 November 23 28 August 26 December 28