National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: MonthSales…

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:

MonthSales

(000)UnitsFeb.17Mar.20Apr.12May.22Jun.19Jul.24Aug.26

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            thousands

(2) A five-month moving average. (Round your answer to 2 decimal places.)

Moving average           thousands

(3) Exponential smoothing with a smoothing constant equal to .20, 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           thousands

(5) A weighted average using .60 for August, .10 for July, and .30 for June. (Round your answer to 2 decimal places.)

Weighted average           thousands

Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!