Question

Use trial and error to find the value of alpha that minimizes MAD. Restrict the value...

Use trial and error to find the value of alpha that minimizes MAD. Restrict the value of alpha to be between .05 and .30.

period 1 2 3 4 5 6 7 8 9 10
demand 60 52 55 42 57 33 26 42 35 31

Homework Answers

Answer #1

Answer: Alpha= 0.30

Explanation:

Absolute deviation= |Forecast - Sales|

MAD= mean absolute deviation= sum of absolute deviation/no. of periods

the formula to be used in Exponential smoothing is

Ft+1= alpha*At + (1-alpha) Ft

At means Actual demand of t'th month, if you want to find out the Forecast through exponential smoothing= forecast of 3rd month = alpha*actual demand of 2nd month+(1-alpha) *forecast demand of 2nd month

remember forecast of 1st month is actual demand of 1st month

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Plot the following data and then calculate and plot a three-period moving average. then calculate and...
Plot the following data and then calculate and plot a three-period moving average. then calculate and plot a five-period moving average. What do you observe in comparing the plots of he three and five period moving averages? period 1 2 3 4 5 6 7 8 9 10 demand 60 52 55 42 57 33 26 42 35 31 Develop a forecast for period 11 using expontentional smoothing and three values of alpha: .05, .30 and .90 Plot actual data...
Person number X Value Y Value Person number X Value Y Value Person number X Value...
Person number X Value Y Value Person number X Value Y Value Person number X Value Y Value 1 24 30 11 39 42 21 21 27 2 42 53 12 60 65 22 33 29 3 20 27 13 34 40 23 25 27 4 31 30 14 24 26 24 22 25 5 22 24 15 51 57 25 28 33 6 46 47 16 80 83 26 34 40 7 52 60 17 28 27 27 53...
Data Set Height Weight Age Shoe Size Waist Size Pocket Change 64 180 39 7 36...
Data Set Height Weight Age Shoe Size Waist Size Pocket Change 64 180 39 7 36 18 66 140 31 9 30 125 69 130 31 9 25 151 63 125 36 7 25 11 68 155 24 8 31 151 62 129 42 6 32 214 63 173 30 8 34 138 60 102 26 6 25 67 66 180 33 8 30 285 66 130 31 9 30 50 63 125 32 8 26 32 68 145 33...
B. Determine whether or not the table is a valid probability distribution of a discrete random...
B. Determine whether or not the table is a valid probability distribution of a discrete random variable. Explain fully. X 0.23 0.14 0.17 P(X=x) -0.22 0.38 0.84 Daily sales of a medium sized restaurant are normally distributed with a mean of $720 and a standard deviation of $80. What is the probability that a randomly selected day will make a sales of at least $656? What is the probability that a randomly selected day will make a sales between $680...
Q1. A clinical trial is run to assess the effects of different forms of regular exercise...
Q1. A clinical trial is run to assess the effects of different forms of regular exercise on HDL levels in persons between the ages of 18 and 29. Participants in the study are randomly assigned to one of three exercise groups - Weight training, Aerobic exercise, or Stretching/Yoga – and instructed to follow the program for 8 weeks. Their HDL levels are measured after 8 weeks and are summarized below. Weight Training Aerobic Exercise Stretching/Yoga 48 38 56 49 41...
I need the answer for (e) : Use trial and error to find a value of...
I need the answer for (e) : Use trial and error to find a value of the exponential smoothing coefficient α that results in a smaller MSE than what you calculated for α = 0.20. Use a two-decimal digit precision. Consider the following time series data. Week 1 2 3 4 5 6 Value 18 15 15 13 17 14 (b) Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. If required,...
Bag Blue Orange Green Yellow Red Brown Total Number of Candies 1 7 23 9 11...
Bag Blue Orange Green Yellow Red Brown Total Number of Candies 1 7 23 9 11 4 6 60 2 16 16 4 7 9 4 56 3 14 14 3 10 5 11 57 4 13 14 7 8 8 6 56 5 18 12 7 10 5 7 59 6 12 9 11 9 8 8 57 7 15 16 6 6 6 8 57 8 15 17 8 4 6 7 57 9 12 14 10 5...
Following are the ages of 23 Academy Awarad winner Actors. 41 31 57 62 37 71...
Following are the ages of 23 Academy Awarad winner Actors. 41 31 57 62 37 71 58 73 69 52 74 64 72 30 33 47 26 36 42 27 29 67 55 Create the Stem and leaf and find the following parts:       Find the value reprtesenting 20th percentile?    Find the value reprtesenting 65th percentile?    Blank 1: Blank 2: Blank 3: Blank 4: Blank 5: Blank 6: Blank 7: Blank 8: Blank 9: Blank 10: Blank...
A clinical trial is run to assess the effects of different forms of regular exercise on...
A clinical trial is run to assess the effects of different forms of regular exercise on HDL levels in persons between the ages of 18 and 29. Participants in the study are randomly assigned to one of three exercise groups - Weight training, Aerobic exercise or Stretching/Yoga – and instructed to follow the program for 8 weeks. Their HDL levels are measured after 8 weeks and are summarized below Weight Training Aerobic Exercise Stretching/Yoga 48 38 56 49 41 57...
Table 1. Use the information to calculate the following TC, AFC, AVC, ATC, AND MC (I...
Table 1. Use the information to calculate the following TC, AFC, AVC, ATC, AND MC (I through 50) TP TFC TVC TC AFC AVC ATC MC 150 0 (1) (11) (21) (31) (41) 2 150 70 (2) (12) (22) (32) (42) 3 150 130 (3) (13) (23) (33) (43) 4 150 240 (4) (14) (24) (34) (44) 5 150 300 (5) (15) (25) (35) (45) 6 150 360 (6) (16) (26) (36) (46) 7 150 390 (7) (17) (27) (37)...