Reference no: EM132287516
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Sales
Month (000) Units
Feb. 18
Mar. 16
Apr. 15
May. 18
Jun. 20
Jul. 21
Aug. 23
b. Forecast September sales volume using each of the following:
(1) A linear trend equation.(Round your intermediate calculations and final answer to 2 decimal places.)
Yt 22.99 thousands
(2) A five-month moving average. (Round your answer to 2 decimal places.)
Moving average 19.4 thousands
(3) Exponential smoothing with a smoothing constant equal to .15, assuming a March forecast of 16(000). (Round your intermediate forecast values and final answer to 2 decimal places)
Forecast thousands
(4) The naive approach.
Naive approach 23 thousands
(5) A weighted average using .65 for August, .15 for July, and .20 for June. (Round your answer to 2 decimal places.)
Weighted average thousands