Description of this paper

STATS - National scan, Inc., sells radio frequency inventory tags

Description

solution


Question

Question;1. National scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:Month Sales(units)Feb 19Mar 18Apr 17May 20Jun 19Jul 22Aug 20a. Forecast September sales volume using the na?ve approach.b. Forecast September sales volume using a linear equation. a=17.43, b = 0.46.c. Forecast September sales volume using a five-month moving averaged. Forecast September sales volume using a weighted average using.60 for August,.30 for July, and.10 for June.e. Forecast September sales volume using Exponential smoothing with a smoothing constant equal to.20, assuming a March forecast of 19.2, A dry cleaner uses exponential smoothing to forecast equipment usage at its main plant.August usage was forecast to be 88 percent of capacity, actual usage was 89.6 percent of capacity. A smoothing constant (Alpha) of.2 is used.a. Prepare a forecast for September.b. Assuming actual September usage of 92 percent, prepare a forecast for October usage.3. A cosmetics manufacturer?s marketing department has developed a linear trend equation that can be used to predict annual sales of its popular Hand & Foot Cream.F t t = 80 +14WhereFt Annual forecast in sales (bottles)t= 0 corresponds to 1990a. Predict annual sales for the year 2006 using the equation.4. The manager of travel agency has been using a seasonally adjusted forecast to predict demand for packaged tours. The actual and predicted values are as follows:Period Demand Predicted1 129 1242 194 2003 156 1504 91 945 85 806 132 1407 126 1288 126 1249 95 10010 149 150a. Compute MAD for the 5th periodb. Compute MAPE for the 10th period

 

Paper#54564 | Written in 18-Jul-2015

Price : $22
SiteLock