Number new bicycle sales at a local bicycle shop are shown in the following table. a. Develop
Fantastic news! We've Found the answer you've been seeking!
Question:
Number new bicycle sales at a local bicycle shop are shown in the following table.
a. Develop a 3-month moving average forecast and compute the MAD.
b. Develop a 4-month moving average forecast and compute the MAD.
c. Estimate demand again with a 3-month weighted moving average in which sales in the most recent month are given a weight of 2 and sales in the previous 2 months are each given a weight of 1. (Wt-1 = 2, Wt-2= 1, Wt-3 = 1). What is the MAD?
d. Using MAD, determine which forecasting method (3-mo MA, 4-mo MA, 3-mo WMA) is more accurate.
Month | Jan. | Feb. | Mar. | Apr. | May | June | July | Aug. | Sept. | Oct. | Nov. | Dec. |
Bike Sales | 10 | 12 | 13 | 16 | 19 | 23 | 26 | 30 | 21 | 18 | 16 |
|
Related Book For
Applied Regression Analysis and Other Multivariable Methods
ISBN: 978-1285051086
5th edition
Authors: David G. Kleinbaum, Lawrence L. Kupper, Azhar Nizam, Eli S. Rosenberg
Posted Date: