Problem 3-2 National Scan, Inc., sells radio frequency inventory tags. Monthly s

Question

Problem 3-2

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

    

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

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

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

The naive approach.

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

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

Month Sales
(000)Units   Feb. 19   Mar. 16   Apr. 10   May. 25   Jun. 16   Jul. 25   Aug. 20 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.)

(2)

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

(3)

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

(4)

The naive approach.

(5)

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

Explanation / Answer

https://www.dropbox.com/s/dwo6mokskipkwfp/excel%20solution.xlsx?dl=0

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.