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

80.2K

Verified Solution

Question

Finance

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. 22
Apr. 8
May. 24
Jun. 19
Jul. 27
Aug. 22

b. Forecast September sales volume using each of thefollowing:
(1) A linear trend equation.(Round your intermediatecalculations and final answer to 2 decimalplaces.)

Yt           thousands
(2) A five-month moving average. (Round your answer to 2decimal places.)
Moving average           thousands
(3) Exponential smoothing with a smoothing constant equal to.25, assuming a March forecast of 17(000). (Round yourintermediate forecast values and final answer to 2 decimalplaces)

Forecast           thousands
(4) The naive approach.
Naive approach           thousands
(5) A weighted average using .50 for August, .15 for July, and.35 for June. (Round your answer to 2 decimalplaces.)
Weighted average           thousands

Answer & Explanation Solved by verified expert

3.8 Ratings (667 Votes)

See Answer

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

Transcribed Image Text

National Scan, Inc., sells radio frequency inventory tags.Monthly sales for a seven-month period were as follows:MonthSales(000)UnitsFeb.19Mar.22Apr.8May.24Jun.19Jul.27Aug.22b. Forecast September sales volume using each of thefollowing:(1) A linear trend equation.(Round your intermediatecalculations and final answer to 2 decimalplaces.)Yt thousands(2) A five-month moving average. (Round your answer to 2decimal places.)Moving average thousands(3) Exponential smoothing with a smoothing constant equal to.25, assuming a March forecast of 17(000). (Round yourintermediate forecast values and final answer to 2 decimalplaces)Forecast thousands(4) The naive approach.Naive approach thousands(5) A weighted average using .50 for August, .15 for July, and.35 for June. (Round your answer to 2 decimalplaces.)Weighted average thousands

Month	Sales (000)Units
Feb.	19
Mar.	22
Apr.	8
May.	24
Jun.	19
Jul.	27
Aug.	22