1 / 8

Problem 5-24

Problem 5-24. Sales of industrial vacuum cleaners at R. Lowenthal Supply Co. over the past 13 months are as follows:. (a) Moving average with three periods, determine the demand for vacuum cleaners for next February. (b) Using a weighted moving average with three periods,

japheth
Download Presentation

Problem 5-24

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Problem 5-24 Sales of industrial vacuum cleaners at R. Lowenthal Supply Co. over the past 13 months are as follows: Angie Cook

  2. (a) Moving average with three periods, determine the demand for vacuum cleaners for next February. Angie Cook

  3. (b) Using a weighted moving average with three periods, determine the demand for vacuum cleaners for February. Use 3, 2, and 1 for the weights of the most recent periods. Angie Cook

  4. Weighted Moving Average with Three Periods Angie Cook

  5. (c) Evaluate the accuracy of each of these methods. The mean absolute deviation (MAD) of the moving average and weighted moving average is computed by taking the sum of the absolute values of the individual forecast errors and dividing by the number of errors (n). Angie Cook

  6. Forecast Error of the MAD.Sum of absolute values of the individual forecast errors divided by the number of errors n=10 Angie Cook

  7. Forecast Error of the Weighted MAD.Sum of absolute values of the individual forecast errors divided by the number of errors n=10 Angie Cook

  8. (d) What other factors might R. Lowenthal consider in forecasting sales? Two problems with moving average method. 1. Increasing the size of n smoothes out fluctuations better, but makes the method less sensitive to real changes in the data. 2. Cannot pick up trends very well because they are averages, using past levels and will not predict a change to a higher or a lower level. Angie Cook

More Related