Question

Exponential smoothing with w​ = 0.70 has been used to calculate forecast values F based on...

Exponential smoothing with w​ = 0.70 has been used to calculate forecast values F based on the actual demand data Y.

Time Period

Y

F

1

119.5

123.4

2

121.5

120.67

3

122.6

121.251

What is the mean absolute deviation​ (MAD) of the​ forecasts? Round to two decimal places.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

The MAD or the mean absolute deviation of the forecasted values is the average value of the absolute error values. To calculate MAD we need to find the error for each time period which is calculated as Y- F, and then we need to find the absolute values of the error values and finally, the mean or the average of the absolute error values gives the MAD.

The following table has the above-stated calculations.

Time Period Y ( Actual value) F ( Forecasted Value) Error Absolute error
1 119.5 123.4 -3.9 3.9
2 121.5 120.67 0.83 0.83
3 122.6 121.251 1.349 1.349
MAD = 2.03

Thus the mean absolute deviation​ (MAD) of the​ forecasts is 2.03

Add a comment
Know the answer?
Add Answer to:
Exponential smoothing with w​ = 0.70 has been used to calculate forecast values F based on...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Use Solver to determine the alpha that minimizes the MAD for the exponential smoothing forecast for...

    Use Solver to determine the alpha that minimizes the MAD for the exponential smoothing forecast for the data that appear in this table. Use the actual demand of period 1 as the forecast for period 2 and then use the forecasts for periods 2 through 9 to calculate MAD. Period Demand 1 272 2 278 3 269 4 280 5 267 6 258 7 278 8 298 9 286 10 290 0.43 0.36 0.54 0.62

  • An analyst is using exponential smoothing to forecast the daily demand for a key product. The...

    An analyst is using exponential smoothing to forecast the daily demand for a key product. The analyst starts with a naive forecast for time period 2, then begins using exponential smoothing with a smoothing constant of 0.15. The table below shows some of the calculations. period actual forecast 1 125 2 136 125 3 144 126.65 4 157 129.25 5 181 ? What is the predicted demand for time period 5? Round your answer to two decimal places. Period Actual...

  • Exercise # 1-0M6322-week 4-Forecasting using Exponential Smoothing The first five periods of demand data are shown...

    Exercise # 1-0M6322-week 4-Forecasting using Exponential Smoothing The first five periods of demand data are shown in the following table Let the smoothing coefficient, alpha, equal 0.2.Compute the exponentially smoothed forecasts for periods one through four Initialize the procedure with a forecast value for period one of 37 Period Aggregate Demand Forecast demand 38 42 40 36 42 37 Determine the Running Sum of Forecast Errors (RSFE), the Mean Absolute Deviation, MADt Land the Tracking Signal(TS) at the end of...

  • A manager has been using a certain technique to forecast demand for project management software at...

    A manager has been using a certain technique to forecast demand for project management software at her store. Actual demand and her corresponding predictions are shown below: MonthActual Demand Manager's Forecast March4545April4250May3445June4840July3845 a. What was the manager's forecast error for each month?b. What is the mean error (ME), the mean squared error (MSE), the mean absolute deviation (MAD), and the tracking signal for these five months of forecasting?c. If the manager had used a 3-month moving average instead of her technique, what would have...

  • i. Find the forecast for week 13. ii. Now obtain the exponential smoothing forecast for the...

    i. Find the forecast for week 13. ii. Now obtain the exponential smoothing forecast for the weeks. A convenience store recently started to carry a new brand of soft drink. Management is interested in estimating future sales volume to determine whether it should continue to carry the new brand or replace it with another brand. The following table provides the number of cans sold per week. Use both the trend projection with regression and the exponential smoothing (let a =...

  • The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 33...

    The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 33 2 29 3 32 4 33 5 35 6 32 7 35 8 42 9 44 10 45 a. Calculate the single exponential smoothing forecast for these data using an α of 0.10 and an initial forecast (F1) of 33. (Round your answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α of 0.10, a...

  • The ollowing 12 periods of actual demand are to be used to produce a double exponential smoothin forecast or period 13. Use a smoothing constant α e 10 se 70 as the inna al to orecast values ll Click...

    The ollowing 12 periods of actual demand are to be used to produce a double exponential smoothin forecast or period 13. Use a smoothing constant α e 10 se 70 as the inna al to orecast values ll Click the icon to view the demand for the previous 12 periods Complete the table below for a double exponential smoothing forecast (enter your responses rounded to one decimal place). More Info Period at FD(DES) 64 Period 35 70 41 64 35...

  • The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 34...

    The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 34 2 37 3 38 4 37 5 40 6 37 7 42 8 44 9 41 10 42 a. Calculate the single exponential smoothing forecast for these data using an ? of 0.20 and an initial forecast (F1) of 34. (Round your intermediate calculations and answers to 2 decimal places.) Month Exponential Smoothing 1 2 3 4 5 6 7 8 9 10 b....

  • The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36...

    The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 36 2 38 3 40 4 41 5 43 6 42 7 43 8 45 9 46 10 48 a. Calculate the single exponential smoothing forecast for these data using an α of 0.30 and an initial forecast (F1) of 36. (Round your intermediate calculations and answers to 2 decimal places.) b. Calculate the exponential smoothing with trend forecast for these data using an α...

  • Two experienced managers at Wilson Boat Inc. are resisting the introduction of a computerized exponential smoothing...

    Two experienced managers at Wilson Boat Inc. are resisting the introduction of a computerized exponential smoothing system, claiming that their judgmental forecasts are much better than any computer could do. Their past record of predictions is as follows: Week Actual Demand Manager's Forecast 1 3,800 4,400 2 4,100 4,800 3 4,300 3,700 4 3,100 3,800 5 3,900 3,500 6 4,500 3,500 7 5,700 4,900 8 4,000 4,700 9 4,500 3,500 10 4,900 5,400 How would the manager’s forecast compare to...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT