Question: Need 3, 4, and 5. Please show work (not excel) will rate! Problem 3-2 National Scan, Inc., sells radio frequency inventory tags. Monthly sales for
Need 3, 4, and 5. Please show work (not excel) will rate!
Problem 3-2 National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Feb. Mar. Apr. May Jun. Jul. Aug Sales (200) Units 18 16 15 18 2e 21 23 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.) Yt 23 thousands (2) A five-month moving average. (Round your answer to 2 decimal places.) Moving average 19.40 thousands (3) Exponential smoothing with a smoothing constant equal to 15, assuming a March forecast of 16(000). (Round your intermediate forecast values and final answer to 2 decimal places) Forecast thousands (4) The naive approach Naive approach thousands (5) A weighted average using 65 for August, 15 for July, and 20 for June (Round your answer to 2 decimal places.) Weighted average thousands


Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
