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

50.1K

Verified Solution

Question

Accounting

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

Month Sales (000)Units

Feb. 20

Mar. 20

Apr. 7

May. 22

Jun. 18

Jul. 24

Aug. 30

a. Forecast September sales volume using each of the following:

(1) The naive approach.

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

(3) A weighted average using 0.65 for August, 0.05 for July, and 0.30 for June. (Round your answer to 2 decimal places.)

(4) Exponential smoothing with a smoothing constant equal to 0.20, assuming a March forecast of 14(000). (Round your intermediate forecast values and final answer to 2 decimal places.) (5) A linear trend equation. (Round your intermediate calculations and final answer to 2 decimal places.)

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students