Question

In: Operations Management

Exponential Smoothing With the following information, identify which alpha value would you use to forecast july-dic...

Exponential Smoothing

With the following information, identify which alpha value would you use to forecast july-dic using exponential smoothing and why? Choose between 0.1, 0.5 or 0.8

Month

June

Actual

16

July

12

August

16

Sept.

15

Oct.

11

Nov.

19

Dec.

21

Solutions

Expert Solution

ALPHA 0.1

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

FORECAST 2 = 16 + (0.1 * (16 - 16) = 16

FORECAST 3 = 16 + (0.1 * (12 - 16) = 15.6

FORECAST 4 = 15.6 + (0.1 * (16 - 15.6) = 15.64

FORECAST 5 = 15.64 + (0.1 * (15 - 15.64) = 15.58

FORECAST 6 = 15.58 + (0.1 * (11 - 15.58) = 15.12

FORECAST 7 = 15.12 + (0.1 * (19 - 15.12) = 15.51

FORECAST ERROR


PERIOD

ACTUAL DEMAND

FORECAST

DEVIATION(D - F)

ABS DEVIATION

1

16

16

0

0

2

12

16

-4

4

3

16

15.6

0.4

0.4

4

15

15.64

-0.64

0.64

5

11

15.58

-4.58

4.58

6

19

15.12

3.88

3.88

7

21

15.51

5.49

5.49

SIGMA

0.55

18.99


MAD = SIGMA(ABSOLUTE DEVIATION) / N, WHERE N = 7

MAD = 18.99 / 7 = 2.71


ALPHA 0.5

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

FORECAST 2 = 16 + (0.5 * (16 - 16) = 16

FORECAST 3 = 16 + (0.5 * (12 - 16) = 14

FORECAST 4 = 14 + (0.5 * (16 - 14) = 15

FORECAST 5 = 15 + (0.5 * (15 - 15) = 15

FORECAST 6 = 15 + (0.5 * (11 - 15) = 13

FORECAST 7 = 13 + (0.5 * (19 - 13) = 16

FORECAST ERROR


PERIOD

ACTUAL DEMAND

FORECAST

DEVIATION(D - F)

ABS DEVIATION

1

16

16

0

0

2

12

16

-4

4

3

16

14

2

2

4

15

15

0

0

5

11

15

-4

4

6

19

13

6

6

7

21

16

5

5

SIGMA

5

21


MAD = 21 / 7 = 3

ALPHA 0.8


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

FORECAST 2 = 16 + (0.8 * (16 - 16) = 16

FORECAST 3 = 16 + (0.8 * (12 - 16) = 12.8

FORECAST 4 = 12.8 + (0.8 * (16 - 12.8) = 15.36

FORECAST 5 = 15.36 + (0.8 * (15 - 15.36) = 15.07

FORECAST 6 = 15.07 + (0.8 * (11 - 15.07) = 11.81

FORECAST 7 = 11.81 + (0.8 * (19 - 11.81) = 17.56


FORECAST ERROR


PERIOD

ACTUAL DEMAND

FORECAST

DEVIATION(D - F)

ABS DEVIATION

1

16

16

0

0

2

12

16

-4

4

3

16

12.8

3.2

3.2

4

15

15.36

-0.36

0.36

5

11

15.07

-4.07

4.07

6

19

11.81

7.19

7.19

7

21

17.56

3.44

3.44

SIGMA

5.4

22.26


MAD = 22.26 / 7 = 3.18





2. USING THE MEAN ABSOLUTE DEVIATION, WE CAN SAY THAT FORECAST WITH ALPHA VALUE OF 0.1 IS THE CLOSEST TO THE ACTUAL DEMAND VALUE AND IS, THEREFORE, MORE SUITABLE.

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


Related Solutions

Use the information below to produce the Simple Exponential Smoothing forecast assuming Alpha=0.3
Use the information below to produce the Simple Exponential Smoothing forecast assuming Alpha=0.3. Enter period 4's forecasted value below. The initialization value for period 1 is given as the actual value for period 1. Round your answer to two decimal places (e.g., 1.23).Alpha=0.3PeriodXSES11.41.427.931.54?
Use the information below to produce the Simple Exponential Smoothing forecast assuming Alpha=0.1.
Use the information below to produce the Simple Exponential Smoothing forecast assuming Alpha=0.1. Enter period 4's forecasted value below. The initialization value for period 1 is given as the actual value for period 1. Round your answer to two decimal places (e.g., 1.23).Alpha=0.1PeriodXSES19.29.228.338.14?
What is this year's forecast using exponential smoothing with alpha = .4, if last year's smoothed forecast was 2600?
The dean of a school of business is forecasting total student enrollment for this year's summer session classes based on the following historical data:Four years ago 2000There years ago 2200Two years ago 2800Last year 3000What is this year's forecast using exponential smoothing with alpha = .4, if last year's smoothed forecast was 2600?A. 2,600B. 2,760C. 2,800D. 3,840E. 3,000
Use an exponential smoothing method with a starting forecast of 21 for month 1 and a...
Use an exponential smoothing method with a starting forecast of 21 for month 1 and a smoothing constant α = 0.5 to calculate month-in-advance forecasts for months 4–12 and forecast for the first month of next year. Calculate the MAD.
Use 5 months moving average and exponential smoothing method (using alpha=0.3) on the following sale of...
Use 5 months moving average and exponential smoothing method (using alpha=0.3) on the following sale of Maggi. You are supposed to forecast the sale of Maggi in the 13th Month. Compare whether there is any difference in forecast based on two methods and Comment. Period (Month) Actual Sale of Maggi 1 1100 2 800 3 1000 4 1050 5 1500 6 750 7 700 8 650 9 1400 10 1200 11 900 12 1000 13
Question: Use the first-order exponential smoothing model with α = 0.2 to forecast for these data...
Question: Use the first-order exponential smoothing model with α = 0.2 to forecast for these data and for the first six months of the third year. Compute MSD/E, MAD, MAPE, and Bias. Month (t) Demand A(t) 1 148 2 125 3 78 4 53 5 25 6 29 7 9 8 68 9 84 10 110 11 147 12 120 13 147 14 109 15 96 16 70 17 42 18 36 19 34 20 28 21 71 22 102...
Use exponential smoothing with trend adjustment. Consider T1 = 2, F1 = 12, α alpha =...
Use exponential smoothing with trend adjustment. Consider T1 = 2, F1 = 12, α alpha = 0.2 , delta = 0.3 PART (A) What is your forecast for period 3? Part (B) What is the related MAD for your forecast? Month Actual Demand 1 15 2 25
The library would like to compare the regression and exponential smoothing models to determine which is...
The library would like to compare the regression and exponential smoothing models to determine which is a better predictor, using the mean absolute error | (books borrowed) – (model’s estimate)|/n as a measure of prediction quality. Select the best of the following four options for splitting the data: A. 15% for training, 15% for validation, 70% for test B. 15% for training, 70% for validation, 15% for test C. 70% for training, 15% for validation, 15% for test D. 55%...
Given the following data, use exponential smoothing with a = 0.3 and α =.5 to develop...
Given the following data, use exponential smoothing with a = 0.3 and α =.5 to develop a demand forecasts for period 7.  Assume that the forecast for week 1= 19. Use the Mean Absolute Percent Error to determine which forecasts are more accurate. Period 1 2 3 4 5 6 Demand 17 19 15 19 13 18
Under what conditions would you prefer a simple exponential smoothing model to the moving averages method...
Under what conditions would you prefer a simple exponential smoothing model to the moving averages method for forecasting a time series? Explain your reasoning.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT