National Scan, Inc., sells radio frequency inventory tags.Monthly sales for a seven-month period were as follows:
Month | Sales (000)Units |
Feb. | 19 |
Mar. | 15 |
Apr. | 8 |
May. | 17 |
Jun. | 19 |
Jul. | 20 |
Aug. | 22 |
|
b. Forecast September sales volume using each of thefollowing:
(1) A linear trend equation.(Round your intermediatecalculations and final answer to 2 decimal places.)
Yt thousands
(2) A five-month moving average. (Round your answer to 2decimal places.)
Moving average thousands
(3) Exponential smoothing with a smoothing constant equal to.25, assuming a March forecast of 15(000). (Round yourintermediate forecast values and final answer to 2 decimalplaces)
Forecast thousands
(4) The naive approach.
Naive approach thousands
(5) A weighted average using .65 for August, .10 for July, and.25 for June. (Round your answer to 2 decimalplaces.)
Weighted average thousands