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

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

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

Post by answerhappygod »

National Scan, Inc., sells radio frequency inventory tags.Monthly sales for a seven-month period were as follows:
Click here for the Excel Data File
a. Forecast September sales volume usingeach of the following:
(1) The naive approach.
(2) A five-month moving average. (Round your answerto 2 decimal places.)
(3) A weighted average using 0.65 for August, 0.05 for July, and0.30 for June. (Round your answer to 2 decimalplaces.)
(4) Exponential smoothing with a smoothing constant equal to0.20, assuming a March forecast of 14(000). (Roundyour intermediate forecast values and final answer to 2 decimalplaces.)
(5) A linear trend equation. (Round yourintermediate calculations and final answer to 2 decimalplaces.)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply