Develop a three-period moving average forecast for April 2019 through January 2020. Calculate the MFE, MAD,...

Develop a three-period moving average forecast for April 2019 through January 2020. Calculate the MFE, MAD, and MAPE values for April through December 2019. LOADING... Click the icon to view the time series data. Develop a three-period moving average and fill-in the table below (enter your responses rounded to one decimal place). Month Demand Forecast January 2019 123123 February 7474 March 114114 April 7777 103.66103.66 May 9898 88.3388.33 June 136136 96.3396.33 July 103103 103.66103.66 August 106106 112.33112.33 September 100100 103103 October 9393 99.6699.66 November 9090 94.9394.93 December 8989 90.6690.66 The forecast for January 2020 is nothing. (Enter your response rounded to one decimal place.) The MFE is nothing. (Enter your response rounded to one decimal place and include a minus sign if necessary.) The MAD is nothing. (Enter your response rounded to one decimal place.) The MAPE is nothing %. (Enter your response rounded to one decimal place.) Enter your answer in each of the answer boxes.

Expert Solution

As per three period moving average method:

forecast of particular month=(sum of demand of previous three month)/3

So, forecast of April month=(123+74+114)/3=103.67

forecast of May month=(74+114+77)/3=88.33

similarly you can calculate for other months(image attached) and formula of MFE, MAD and MAPE also attached

Now

N=number of forecast calculated period

so, for April to December, N=9

MFE=(-24.33/9)=-2.7

MAD=(123/9)=13.7

MAPE=(122.77/9)=13.6

Colby Messinger answered 1 year ago

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...

Develop a three-week moving average for this time series. Compute MSE and a forecast for week...

Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. Week Time SeriesValue Forecast 1 18 2 13 3 16 4 11 5 17 6 14 MSE :The forecast for week 7 :Use = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places....

(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...

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...

Given the attached data. Answer the following questions for a 6 period moving average. MAD =...

Given the attached data. Answer the following questions for a 6 period moving average. MAD = Average(|A-F|) TS =SUM(A-F)/MAD MSE = Average(A-F)2 1. Compute your forecast for period 51. The potential answers are: A: 4414 units. B: 10290.67 units. C: 8020.83 units. D: 6324.8 units. E: 6351.86 units. 2. Compute the MAD value for period 50. The potential answers are: A: 2655.35 units. B: 3753.86 units. C: 3892.54 units. D: 3732.56 units. E: 3205.7 units. 3. Compute standard deviation of...

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 ...

b. Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week 7

Consider the following time series data. Week 1 2 3 4 5 6 Value 19 13 17 11 17 15 b. Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week 7 (to 2 decimals if necessary). MSE The forecast for week 7 c. Use a=.2 to compute the exponential smoothing forecasts for the time series. Compute MSE and a forecast for week 7 (to 2 decimals). MSE The forecast for week d....

Develop the three-week moving average forecasts for this time series.

Consider the following time series data. Week 1 2 3 4 5 6 Value 17 11 14 10 16 13 (a) (b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 17 2 11 3 14 4 10 5 16 6 13 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (c) Use α = 0.2 to...

Table 6-3. Calculation of MAD Time Period Actual Sales 3 Month Moving Average Absolute Deviation

Table 6-3. Calculation of MAD Time Period Actual Sales 3 Month Moving Average Absolute Deviation Weighted Moving Average W=.1,.3,.6 Absolute Deviation Exponential Smoothing Ft = 350 Absolute Deviation 1 230 350 2 238 326 3 260 308 4 275 243 250 299 5 300 258 267 294 6 285 278 289 295 7 270 287 289 293 8 290 285 278 289 9 305 282 284 289 10 320 288 297 292 11 335 305 313 298 12 320 328 305 SUM = n = MAD 73) Refer to Table 6-3. Calculate MAD for all forecasting models. The model you would use for your forecast, based on MAD is _____________________________________. Please show work.

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

Question