Question

The following shows the performance of a forecasting method: YEAR   ACTUAL DEMAND (units)   FORECAST (units) 1...

The following shows the performance of a forecasting method:

YEAR   ACTUAL DEMAND (units)   FORECAST (units)

1         3765     3821

2      3674   3615

3      3726           3758

Based on these information, the mean absolute deviation (MAD) for this forecasting method is

Homework Answers

Answer #1

Mean absolute deviation of a data set refers to the average distance between each data value and its mean. It helps in calculating the absolute dispersion of the deviation, which is measured as the mean of the sum of absolute differences between actual demand and forecasted demand. Thus, the formula is,

Mean absolute deviation (MAD) = (Σ | D- F|)/n,

Where D represents the actual demand for each period,

F represents the forecasted demand for each period,

n represents the number of periods or observations.

Year

Actual Demand

Forecast

(D-F)

| D- F|

1

3765

3821

-56

56

2

3674

3615

59

59

3

3726

3758

-32

32

Sum

11165

11194

-29

147

Average

3721.67

3731.33

-9.67

49.00

Therefore,

MAD = (Σ | D- F|)/n = 147/3= 49.

Thus, the actual demand is 49 units on average, from the forecasted value.

If you liked the answer please give an up-vote, this will be quite encouraging for me, thank you!!

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
The following shows the performance of a forecasting method: YEAR ACTUAL DEMAND (units) FORECAST (units) 1...
The following shows the performance of a forecasting method: YEAR ACTUAL DEMAND (units) FORECAST (units) 1 3765 3821 2 3674 3615 3 3726 3758 Based on these information, the mean absolute deviation (MAD) for this forecasting method is a. +147 b. -29 c. +32 d. None of the above
The table below shows the results of two methods (Forecast 1 and Forecast 2) of forecasting...
The table below shows the results of two methods (Forecast 1 and Forecast 2) of forecasting for frozen prepared dinners, as well as the demand for the five periods.          PREDICTED DEMAND Period Demand F1 F2 1 68 67 65 2 75 72 64 3 70 72 70 4 74 67 70 5 69 75 74 6 72 67 79 7 80 74 77 8 78 73 81          a. Compare the accuracy of Forecast 1 and Forecast 2 by...
The table below shows the actual demand and the forecasted amounts (where available). Use this table...
The table below shows the actual demand and the forecasted amounts (where available). Use this table to answer questions. Actual Forecast 1 100 - 2 95 - 3 102 - 4 100 105 5 110 111 6 120 115 7 112 115 8 130 125 9 130 128 What is the mean absolute deviation for the forecast? 3.5 2.33 3.89 2.86 What is the mean squared error for the forecast (round to two decimal point)? 89.12 9.94 14.83 4.72 The...
Your manager is trying to determine what forecasting method to use. Based upon the following historical...
Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. - PLEASE show all work in Excel including formulas. a. Calculate the simple three-month moving average forecast for periods 4-12. b. Calculate the weighted three-month moving average using weights of 0.50, 0.30, and 0.20 for periods 4-12. c. Calculate the single exponential smoothing forecast for periods 2-12 using an initial forecast (F1)...
Question 5: Forecasting (8 p) The table below shows the demand (in units per quarter) of...
Question 5: Forecasting (8 p) The table below shows the demand (in units per quarter) of a specific product in the past three years. Quarter Year 1 2 3 4 2015 350 254 176 228 2016 367 258 169 236 2017 342 250 166 228 Predict demand in quarter 1 and quarter 2 of 2018, given that the demand forecast for the whole year is a total of 1,040 units.
Question 12 The constant difference (higher or lower) between actual demand and forecast demand is called...
Question 12 The constant difference (higher or lower) between actual demand and forecast demand is called what? It can also be found using the running sum of the forecasting error and the mean forecast error. Group of answer choices error magnitude mean absolute percent error bias Question 13 How much the forecast deviates from the actual observations is called what? It can be found by using MAPE and SDFE. Group of answer choices error running sum of the forecasting error...
1 Which of the following statements is TRUE regarding time series forecasting methods? a Moving average...
1 Which of the following statements is TRUE regarding time series forecasting methods? a Moving average (MA) method is appropriate for forecasting an item that shows seasonal pattern b By assigning larger weight to the most recent period data, weighted moving average (WMA) method is more reflective to the changes in the most recent period of data than MA method c Simple exponential smoothing method is NOT appropriate for forecasting stable item without trend d Linear trend line method is...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 28...
The following table contains the demand from the last 10 months: MONTH ACTUAL DEMAND 1 28 2 30 3 29 4 40 5 43 6 42 7 43 8 45 9 44 10 47 a. Calculate the single exponential smoothing forecast for these data using an α of 0.20 and an initial forecast (F1) of 28. (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 tabulations are actual sales of units for six months and a starting forecast in...
The following tabulations are actual sales of units for six months and a starting forecast in January. ACTUAL FORECAST January 116 96 February 112 March 115 April 88 May 82 June 112 a. Calculate forecasts for the remaining five months using simple exponential smoothing with α = 0.3. b. Calculate the MAD for all the forecasts, including January's. (Round your answer to 1 decimal place.)
The following are monthly actual and forecast demand levels for May through December for units of...
The following are monthly actual and forecast demand levels for May through December for units of a product manufactured by the D. Bishop Company in Des Moines:    Month Actual Demand Forecast Demand May 108 104 June 80 100 July 112 99 August 112 101 September 105 100 October 106 106 November 125 102 December 115 111 For the given forecast, the tracking signal = ___ MADs (round your response to two decimal places).