Sales of industrial vacuum cleaners at Larry Armstrong Supply Co. over the past 13 months are...

Transcribed Image Text:

Sales of industrial vacuum cleaners at Larry Armstrong Supply Co. over the past 13 months are shown below: Aug. Sept. Oct. Nov. Dec. Jan. Month Jan. Feb. March April May Sales (in 11 14 thousands) June July 16 10 15 17 11 14 17 12 12 14 16 11 Q1)Using a moving average with 3 periods, determine the demand for vacuum cleaners for next February. Q2)Using a weighted moving average with 3 periods, determine the demand for vacuum cleaners for February. Use 0.6, 0.3, and 0.1 for the weights of the most recent, second most recent, and third most recent periods, respectively. For example, if you were forecasting the demand for February, November would have a weight of 0.1, December would have a weight of 0.3, and January would have a weight of 0.6. Q3)Using MAD, determine which is the better forecast. Q4)What other factors might Armstrong consider in forecasting sales? Sales of industrial vacuum cleaners at Larry Armstrong Supply Co. over the past 13 months are shown below: Aug. Sept. Oct. Nov. Dec. Jan. Month Jan. Feb. March April May Sales (in 11 14 thousands) June July 16 10 15 17 11 14 17 12 12 14 16 11 Q1)Using a moving average with 3 periods, determine the demand for vacuum cleaners for next February. Q2)Using a weighted moving average with 3 periods, determine the demand for vacuum cleaners for February. Use 0.6, 0.3, and 0.1 for the weights of the most recent, second most recent, and third most recent periods, respectively. For example, if you were forecasting the demand for February, November would have a weight of 0.1, December would have a weight of 0.3, and January would have a weight of 0.6. Q3)Using MAD, determine which is the better forecast. Q4)What other factors might Armstrong consider in forecasting sales?