Question

In: Economics

Starting in year 4 and going to year 12, forecast demand using a 3-year moving average.

Consider the following data:

Year 1 2 3 4 5 6 7 8 9 10 11

Demand 7 9 5 9 13 8 12 13 9 11 7

Starting in year 4 and going to year 12, forecast demand using a 3-year moving average.

(a): What is the predicted value for the next period (Year 12)?

(b): What is the MAD value for this forecast? Starting in year 4 and going to year 12, forecast demand using a 3-year weighted moving average with weights of .1, .3, and .6, using .6 for the most recent year. What is the predicted value for the next period (Year 12)?

(c): What is the predicted value for the next period (Year 12)?

(d): What is the MAD value for this forecast?

Solutions

Expert Solution

Answer

(a)

In order to predict the value for the next period that is 12 th year . As given we have to take 8 year mving average .

So starting fromyear 4 to 12 , we get

Demand in year 12 = sum of demand from year 4 till 11 / number of observations = 9+13+8+12+13+9+11+7 / 8 =82/8 = 10.25 or 10

hence the predicted value for year 12 is 10

(b)

Now calculating the Mean absolute deviation(MAD) we have , the formula

MAD = summation of (xi-x (bar ) / n)

where xi is the individual demand and x(bar is the mean) and n is the no. of observation

So, mean is equal to = 9+13+8+12+13+9+11+7 +10 / 9 = 10.22 or 10

Now constructing the table

xi xi- x(bar) mod ( xi-x bar)
9 9-10 = -1 1
13 13-10 =3 3
8 8-10=-2 2
12 12-10 2
13 13-10=3 3
9 9-10=-1 1
11 11-10=1 1
7 7-10=-3 3
10 10-10=0 0

MAD = (1+3+2+2+3+1+1+3+0)/ 9= 16/9 = 1.77 or 2 (approx)

(c)

So, using weighted moving average we use the formula

Predicted value = most recent period demand * weight assigned / sum of weights

Demand in year 12 = (9*0.1+11*0.3+7*0.6)/(0.1+0.3+0.6) = 8.4/1 =8.4

hence predicted value in year 12 using weighted moving average is 8.4

(d)

mean is equal to = 9+13+8+12+13+9+11+7 +8.4 / 9 =90.4/9 = 10.044 or 10

MAD =

xi xi- x(bar) mod ( xi-x bar)
9 9-10 = -1 1
13 13-10 =3 3
8 8-10=-2 2
12 12-10 2
13 13-10=3 3
9 9-10=-1 1
11 11-10=1 1
7 7-10=-3 3
8.4 8.4 -10 = -1.6 1.6

MAD = (1+3+2+2+3+1+1+3+1.6/9= 17.6/9=1.955 or 2 (approx)

hence MAD is same in both the cases

Rahul Sunny answered 2 years ago
Next > < Previous

Related Solutions

Find the MAD for the 3-month and the 12-month moving average forecast. Year   Month   Rate(%) 2009  ...
Find the MAD for the 3-month and the 12-month moving average forecast. Year   Month   Rate(%) 2009   Jan   7.9 2009   Feb   8.5 2009   Mar   8.7 2009   Apr   9.1 2009   May   9.4 2009   Jun   9.4 2009   Jul   9.7 2009   Aug   9.5 2009   Sep   9.9 2009   Oct   9.9 2009   Nov   9.9 2009   Dec   9.7 2010   Jan   9.7 2010   Feb   9.6 2010   Mar   9.8 2010   Apr   9.7 2010   May   9.5 2010   Jun   9.4 2010   Jul   9.4 2010   Aug   9.4 2010   Sep   9.4 2010   Oct  ...
a. Show the naive forecast, an exponential smoothing forecasts using α = 0.2, and a 3-month moving average forecast.
Month137244335450534630750829936103511411245a.  Show the naive forecast, an exponential smoothing forecasts using α = 0.2, and a 3-month moving average forecast.b. Compare the MFE, MSE, and MAPE on the modelsc.  Make a conclusion on which model to use.d. Find the alpha (smoothing constant) that minimizes the MSE.
1) Using a 5 period simple moving average, the forecast for period 13 will be:
Question 1 contains the actual values for 12 periods (listed in order, 1-12). In Excel, create forecasts for periods 6-13 using each of the following methods: 5 period simple moving average; 4 period weighted moving average (0.63, 0.26, 0.08, 0.03); exponential smoothing (alpha = 0.23 and the forecast for period 5 = 53); linear regression with the equation based on all 12 periods; and quadratic regression with the equation based on all 12 periods. Round all numerical answers to two...
Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and...
Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and you know that sales will be decreasing every period for the foreseeable future. What of the following would be the best set of weights to use? (listed in order from the most recent period to four periods? ago, respectively)? A.0.00, 0.00,? 0.00, 1.00 B.?0.25, 0.25,? 0.25, 0.25 C.?1.00, 0.00,? 0.00, 0.00 D.0.10, 0.20,? 0.30, 0.40 E. ?0.40, 0.30,? 0.20, 0.10
Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and...
Suppose that you are using the? four-period weighted moving average forecasting method to forecast sales and you know that sales will be decreasing every period for the foreseeable future. What of the following would be the best set of weights to use? (listed in order from the most recent period to four periods? ago, respectively)? A.0.00, 0.00,? 0.00, 1.00 B.?0.25, 0.25,? 0.25, 0.25 C.?1.00, 0.00,? 0.00, 0.00 D.0.10, 0.20,? 0.30, 0.40 E. ?0.40, 0.30,? 0.20, 0.10
develop a? three-period moving average forecast for april 2019
A geneticist discovers a new mutation in Drosophila melanogaster that causes the flies to shake and quiver. She calls this mutation spastic (sps) and determines that it is due to an autosomal recessive gene. She wants to determine if the gene encoding spastic is linked to the recessive gene for vestigial wings (vg). She crosses a fly homozygous for spastic and vestigial traits with a fly homozygous for the wild-type traits and then uses the resulting F1 females in a...
Forecast the price index for Q3 2018 using a​ two-period simple moving average. (Round to two...
Forecast the price index for Q3 2018 using a​ two-period simple moving average. (Round to two decimal places) Calculate the MAD for the forecast in part a (Round to two decimal places) Forecast the price index for Q3 2017 using a​ three-period simple moving average. (Round to two decimal places) Calculate the MAD for the forecast in part c. (Round to two decimal places) Quarter Price Q1 2017 186.4 Q2 2017 190.5 Q3 2017 196.2 Q4 2017 196.2 Q1 2018...
(a) Develop a three-year moving average. (b) Develop a four-year moving average.
Question 1 Sales for the Forever Young Cosmetics Company (in $ millions) are as follows: Year Sales ($ millions) Year Sales ($ Millions) Year Sales ($ Milions 1996 2.4 2003 4.4 2010 4.5 1997 2.7 2004 4.8 2011 4.8 1998 3.3 2005 5.1 2012 5.1 1999 4.6 2006 5.3 2013 5.5 2000 3.2 2007 5.2 2014 5.7 2001 3.9 2008 4.6 2002 4 2009 4.5 (a) Develop a three-year moving average. (b) Develop a four-year moving average. (c) Develop a...
For the attached data set, 1. create a 3-month and 6-month moving average forecast. 2. Calculate...
For the attached data set, 1. create a 3-month and 6-month moving average forecast. 2. Calculate the standard errors 3. compare their forecast accuracy Month/Year Unemployment rate Jan-17 5.1 Feb-17 4.9 Mar-17 4.6 Apr-17 4.1 May-17 4.1 Jun-17 4.5 Jul-17 4.6 Aug-17 4.5 Sep-17 4.1 Oct-17 3.9 Nov-17 3.9 Dec-17 3.9 Jan-18 4.5 Feb-18 4.4 Mar-18 4.1 Apr-18 3.7 May-18 3.6 Jun-18 4.2 Jul-18 4.1 Aug-18 3.9 Sep-18 3.6 Oct-18 3.5 Nov-18 3.5
1.at is the root mean square error (RMSE) for a "next period forecast" using 3-month moving...
1.at is the root mean square error (RMSE) for a "next period forecast" using 3-month moving average model for these three years of demand? Give your answer as an integer. 2.at is the root mean square error (RMSE) for a "next period forecast" using naive model for these three years of demand? Give your answer as an integer 3.What is the root mean square error (RMSE) for a "next period forecast" using cumulative model for these three years of demand?...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT