Reference no: EM132167413
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales February 19
March 18
April 19
May 20
June 18
July 21
August 19
Forecast September sales volume using each of the following:
a. The naive approach.
b. A three-month moving average.
c. A weighted average using 0.70 for August, 0.20 for July, and 0.10 for June.
d. Exponential smoothing with a smoothing constant 0.30, assuming a March forecast of 19.
2. An electrical contractor’s records during the last five weeks indicate the number of jobs requests:
Week Sales
1 30
2 32
3 35
4 37
5 39
Predict the number of requests for week 6 using each of the following:
a. The naive approach.
b. A four-week moving average.
c. A weighted average using weights of 0.60 for week 5, 0.30 for week 4, and 0.10 for week 3.
d. Exponential smoothing with a smoothing constant 0.30. Use 20 for week 2 forecast.