Question

In: Operations Management

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

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

March 18

April 19

May 20

June 18

July 21

August 19

Forecast September sales volume using each of the following:

a. The naive approach.

b. A three-month moving average.

c. A weighted average using 0.70 for August, 0.20 for July, and 0.10 for June.

d. Exponential smoothing with a smoothing constant 0.30, assuming a March forecast of 19.

Solutions

Expert Solution

Given information:

(a) Forecast using Naive approach:

In Naive approach, the actual values of the last period are considered as the forecasted values for the present period.

Forecast sales for September = Actual sales for August

Forecast sales for September = 19

(b) 3-Month Moving Average method:

Forecast sales for September = (August sales + July sales + June sales) / 3

Forecast sales for September = (19 + 21 + 18) / 3

Forecast sales for September = 19.33

(c) Forecast using Weighted Average:

Forecast sales for September = [(August sales x weight 1) + (July sales x weight 2) + (June sales x weight 3)

Forecast sales for September = [(19 x 0.70) + (21 x 0.20) + (18 x 0.10)]

Forecast sales for September = 19.3

(d) Forecast using Exponential smoothing:

In exponential smoothing,

F(t+1) = A(t) + (1 - ) F(t)

where,

F(t+1) = Forecast for the next period

F(t) = Forecast for the present period

A(t) = Actual values for the present period

= smoothing constant

= 0.30

Forecast sales for September = 19.4


Related Solutions

National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000)Units Feb. 14 Mar. 20 Apr. 11 May. 22 Jun. 21 Jul. 25 Aug. 16 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 thousands (2) A five-month moving average. (Round your answer to 2 decimal places.) Moving average thousands (3) Exponential smoothing with...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000)Units Feb. 17 Mar. 20 Apr. 12 May. 22 Jun. 19 Jul. 24 Aug. 26 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 ______ thousands (4) The naive approach. Naive approach _______ thousands
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000)Units   Feb. 20   Mar. 17   Apr. 13   May. 28   Jun. 17   Jul. 23   Aug. 26 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 thousands      (2) A five-month moving average. (Round your answer to 2 decimal places.   Moving average thousands      (3)...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000)Units Feb. 18 Mar. 17 Apr. 15 May. 22 Jun. 15 Jul. 24 Aug. 28 b. Forecast September sales volume using each of the following: (2) A five-month moving average. (Round your answer to 2 decimal places.) Moving average thousands (3) Exponential smoothing with a smoothing constant equal to .20, assuming a March forecast of 18(000). (Round your intermediate calculations and...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000)Units Feb. 19 Mar. 15 Apr. 8 May. 17 Jun. 19 Jul. 20 Aug. 22 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               thousands (2) A five-month moving average. (Round your answer to 2 decimal places.)    Moving average              thousands...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000)Units Feb. 19 Mar. 22 Apr. 8 May. 24 Jun. 19 Jul. 27 Aug. 22 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            thousands (2) A five-month moving average. (Round your answer to 2 decimal places.) Moving average            thousands...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000)Units Feb. 12 Mar. 22 Apr. 9 May. 24 Jun. 19 Jul. 27 Aug. 24 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 ?? thousands (2) A five-month moving average. (Round your answer to 2 decimal places.) Moving average ?? thousands (3) Exponential...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000)Units Feb. 18 Mar. 16 Apr. 15 May. 18 Jun. 20 Jul. 21 Aug. 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   ______thousands (2) A five-month moving average. (Round your answer to 2 decimal places.) Moving average _______ thousands (3) Exponential smoothing...
1. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were...
1. National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000)Units Feb. 19 Mar. 15 Apr. 8 May. 17 Jun. 19 Jul. 20 Aug. 22 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    21.42 Correct thousands (2) A five-month moving average. (Round your answer to 2 decimal places.) Moving average      ...
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: SalesMonth(000)UnitsFeb.19Mar.22Apr.8May.24Jun.19Jul.27Aug .22b. Forecast September sales volume using each of the following: (1) A linear trend equation. (2) A five-month moving average. (3) Exponential smoothing with a smoothing constant equal to .25, assuming a March forecast of 17(000). (4) The naive approach. (5) A weighted average using .50 for August, .15 for July, and.35 for June. 
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT