1. Business
  2. Operations Management
  3. national scan inc sells radio frequency inventory tags monthly sales...

Question: national scan inc sells radio frequency inventory tags monthly sales...

Question details

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows Sales Month Month (thousand units) Feb 13 21 19 23 20 26 25 Mar May Jun Jul Aug September 4 5 7 Forecast September sales volume using each of the following: (1) A linear trend equation. For this question, this is the same as using regression model with month as the only factor. To do this, create a month column with (Feb-1, Mar-2, Apr-3, May-4, Jun=5, Jul-6, Aug 7, Sep-8) and use this column as X in regression (Round your intermediate calculations and final answer to 2 decimal places.): (2) A five-month moving average. (Round your answer to 2 decimal places): (3) Exponential smoothing with a smoothing constant equal to .10, assuming a March forecast of 17(000). (Round your intermediate forecast values and final answer to 2 decimal places): (4) The naive approach: (5) A weighted average using .65 for August, .20 for July, and .15 for June. (Round your answer to 2 decimal places.):

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution