National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a s

Question

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

A linear trend equation.(Round your intermediate calculations and final answer to 2 decimal places.)

A five-month moving average. (Round your answer to 2 decimal places.)

Exponential smoothing with a smoothing constant equal to .30, assuming a March forecast of 15(000). (Round your intermediate calculations and final answer to 2 decimal places.)

A weighted average using .50 for August, .10 for July, and .40 for June. (Round your answer to 2 decimal places.)

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

Explanation / Answer

Month Month # (x) Sales (y) xy x^2   Feb. 1 16 16 1   Mar. 2 18 36 4   Apr. 3 14 42 9   May. 4 25 100 16   Jun. 5 15 75 25   Jul. 6 24 144 36   Aug. 7 23 161 49 Total 28 135 574 140 1. A linear trend equation.(Round your intermediate calculations and final answer to 2 decimal places.) Slope: =(n(xy)xy)/(nx2(x)2) Offset: =(yx)/n Trendline formula: y=x+ = 1.21 = 14.43 Trend Line: y = 1.21 x + 14.43 Forecast for september: x = 8 y = 24.14 thousands 2. A five-month moving average. (Round your answer to 2 decimal places.) Month Sales MA   Feb. 16   Mar. 18   Apr. 14   May. 25   Jun. 15   Jul. 24 17.6   Aug. 23 19.2 sep. 20.2 Forecast based on Five month MA: sep. 20.2 thousands 3. Exponential smoothing with a smoothing constant equal to .30, assuming a March forecast of 15(000). (Round your intermediate calculations and final answer to 2 decimal places.) Month Sales (D) Forecast (F)   Feb. 16   Mar. 18 15   Apr. 14 15.90   May. 25 15.33   Jun. 15 18.23   Jul. 24 17.26   Aug. 23 19.28 sep. 20.40 Formula Used: F (t+1)=(Dt*S)+(Ft*(1-S)) S 0.3 Forecast 20.40 thousands 4. Naïve Approach A naïve forecast simply uses the actual demand for the past period as the forecasted demand for the next period. Month Sales Forecast   Feb. 16   Mar. 18 16   Apr. 14 18   May. 25 14   Jun. 15 25   Jul. 24 15   Aug. 23 24 Sep. 23 Forecast 23 thousands 5. A weighted average using .50 for August, .10 for July, and .40 for June. (Round your answer to 2 decimal places.) Month Sales Weights   Feb. 16   Mar. 18   Apr. 14   May. 25   Jun. 15 0.4   Jul. 24 0.1   Aug. 23 0.5 Sep. Weighted Avg = sum (weight * sales) Weighted Avg = 0.5 * 23 + 0.1 * 24 + 0.4 * 15 Forecast 19.90 thousands

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.