Question

In: Operations Management

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 with a smoothing constant equal to .15, assuming a March forecast of 16(000). (Round your intermediate forecast values and final answer to 2 decimal places)

Forecast ______ thousands

(4) The naive approach.

Naive approach _______ thousands

(5) A weighted average using .65 for August, .15 for July, and .20 for June. (Round your answer to 2 decimal places.)

Weighted average ______thousands

Solutions

Expert Solution

1. 22.99

PERIOD (X)

DEMAND (Y)

X

Y

X * Y

X^2

1

18

1

18

18

1

2

16

2

16

32

4

3

15

3

15

45

9

4

18

4

18

72

16

5

20

5

20

100

25

6

21

6

21

126

36

7

23

7

23

161

49

SIGMA

28

131

554

140

INTERCEPT = (SIGMA(Y) * SIGMA(X^2) - SIGMA(X) * SIGMA(XY)) / (N * SIGMA(X^2) - SIGMA(X)^2)

INTERCEPT = (131 * 140) - (28 * 554) / ((7 * 140) - 28^2) = 14.43

SLOPE = ((N * SIGMA(XY)) - (SIGMA(X) * SIGMA(Y))) - (N * SIGMA(X^2) - SIGMA(X)^2)

SLOPE = ((7 * 554) - (28 * 131) / ((7 * 140) - 28^2) = 1.07




Y = A + B(x), WHERE A IS THE INTERCEPT, B IS THE SLOPE, x IS THE PERIOD = 14.43 + (1.07 * X)

FOR THE VALUE OF X = 8 FORECAST = 14.43 + (1.07 * 8) = 22.99

2. FORECAST = SIGMA(PREVIOUS N DEMANDS) / N

WHERE N = 5

FORECAST 8 = (15 + 18 + 20 + 21 + 23) / 5 = 19.4

3. FORECAST = FORECAST + (ALPHA * (ACTUAL DEMAND - FORECAST))


FORECAST 3 = 16 + (0.15 * (16 - 16) = 16

FORECAST 4 = 16 + (0.15 * (15 - 16) = 15.85

FORECAST 5 = 15.85 + (0.15 * (18 - 15.85) = 16.17

FORECAST 6 = 16.17 + (0.15 * (20 - 16.17) = 16.74

FORECAST 7 = 16.74 + (0.15 * (21 - 16.74) = 17.38

FORECAST 8 = 17.38 + (0.15 * (23 - 17.38) = 18.22


4. NAIVE FORECAST = DEMAND IN PREVIOUS PERIOD = 23

5. FORECAST = SIGMA(WEIGHT FOR PERIOD * DEMAND PER PERIOD) / SUM OF THE WEIGHTS

WHERE LARGEST WEIGHTS ARE MULTIPLIED BY THE MOST RECENT DEMANDS

FORECAST 8 = ((23 * 0.65) + (21 * 0.15) + (20 * 0.2)) / 1 = 22.1

** Leaving a thumbs-up would really help me out. Let me know if you face any problems.


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 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. 
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...
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      ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT