Question: please help with 2 and 4 1 1 Problem 3-2 (Algo) National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period

please help with 2 and 4 please help with 2 and 4 1 1 Problem 3-2 (Algo)
please help with 2 and 4 1 1 Problem 3-2 (Algo)
please help with 2 and 4 1 1 Problem 3-2 (Algo)
1 1 Problem 3-2 (Algo) National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: 5 points Month Feb. Mar. Apr. May. Jun. Jul. Aug. Sales (000) Units 18 16 15 18 20 21 23 Click here for the Excel Data File a. Forecast September sales volume using each of the following: (1) The naive approach Answer is complete and correct Naive approach 23 thousands (2) A five-month moving average. (Round your answer to 2 decimal places.) Mc Graw Hill Proy 1 of 5 !!! Next > 1 (2) A five-month moving average. (Round your answer to 2 decimal places.) 5 points Answer is complete but not entirely correct. Moving average 19.00 thousands (3) A weighted average using 0.65 for August, 0.15 for July, and 0.20 for June. (Round your answer to 2 decimal places.) Answer is complete and correct. 22.10 thousands Weighted average (4) Exponential smoothing with a smoothing constant equal to 015, assuming a March forecast of 164000). (Round your intermediate forecast values and final answer to 2 decimal places.) Answer is complete but not entirely correct. Forecast 21.30 thousands 1 1 Answer is complete and correct. 22.10 thousands Weighted average 5 points (4) Exponential smoothing with a smoothing constant equal to 0.15, assuming a March forecast of 16/000). (Round your intermediate forecast values and final answer to 2 decimal places.) Answer is complete but not entirely correct. Forecast 21.30 thousands (5) A lineer trend equation, (Round your intermediate calculations and final answer to 2 decimal places.) Answer is complete and correct. thousands Y1 23.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!