National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: A) Pl
Posted: Sun Jul 03, 2022 1:32 pm
National Scan, Inc., sells radio frequency inventory tags.Monthly sales for a seven-month period were as follows:
A) Plot the monthly data on a sheet of graph paper.
B) Forecast September sales volume using each of thefollowing:
(1) A linear trend equation.
(2) A five-month moving average.
(3) Exponential smoothing with a smoothing constant equal to.20, assuming a March forecast of 19(000).
(4) The naive approach.
(5) A weighted average using .60 for August, .30 for July, and.10 for June.
Month Feb. Mar. Apr. May Jun. Jul. Aug. Sales (000 units) 19 18 15 20 18 22 20
A) Plot the monthly data on a sheet of graph paper.
B) Forecast September sales volume using each of thefollowing:
(1) A linear trend equation.
(2) A five-month moving average.
(3) Exponential smoothing with a smoothing constant equal to.20, assuming a March forecast of 19(000).
(4) The naive approach.
(5) A weighted average using .60 for August, .30 for July, and.10 for June.
Month Feb. Mar. Apr. May Jun. Jul. Aug. Sales (000 units) 19 18 15 20 18 22 20