Question: In this question, I need help on part D and E... Problem 3-2 (Algo) National Scan, Inc., sells radio frequency inventory tags. Monthly sales for

In this question, I need help on part D and E...

Problem 3-2 (Algo)

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

Month Sales (000)Units
Feb. 17
Mar. 20
Apr. 14
May. 22
Jun. 21
Jul. 25
Aug. 29

1). Forecast September sales volume using each of the following:

(A) The naive approach : 29 thousands

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

(C) A weighted average using 0.55 for August, 0.20 for July, and 0.25 for June. (Round your answer to 2 decimal places.) : 26.20 thousands

(D) Exponential smoothing with a smoothing constant equal to 0.10, assuming a March forecast of 15(000). (Round your intermediate forecast values and final answer to 2 decimal places.)

forecast = (E) A linear trend equation. (Round your intermediate calculations and final answer to 2 decimal places.)

yt =

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!