National Scan, Inc., sells radio frequency inventory tags

profileKnowledgeCats
 (Not rated)
 (Not rated)
Chat

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

Month Sales
(000)Units
Feb. 18
Mar. 19
Apr. 11
May. 28
Jun. 16
Jul. 23
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 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 .30, assuming a March forecast of 20(000). (Round your intermediate calculations 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

    • 7 years ago
    National Scan, Inc., Solution
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      national_scan_inc._solution.docx