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

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: Month

Post by answerhappygod »

National Scan, Inc., sells radio frequency inventory tags.Monthly sales for a seven-month period were as follows: Month Sales(000)Units Feb. 15 Mar. 23 Apr. 12 May. 25 Jun. 19 Jul. 28 Aug. 26Click here for the Excel Data File a. Forecast September salesvolume using each of the following: (1) The naive approach. (2) Afive-month moving average. (Round your answer to 2 decimal places.)(3) A weighted average using 0.45 for August, 0.20 for July, and0.35 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 intermediateforecast values and final answer to 2 decimal places.) (5) A lineartrend equation. (Round your intermediate calculations and finalanswer to 2 decimal places.)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply