Exercise 1. Graph three plots Sales, Forecast, center moving average 2. Predict the sales in year...

Exercise

1. Graph three plots Sales, Forecast, center moving average
2. Predict the sales in year 5 for each quarter using forecasting
Quarter Data for Car Sales
Year	Quarter	Sales (1000's)	Moving average (4)	Center moving average (baseline)
year 1	1	4.8
	2	4.1
	3	6
	4	6.5
Year 2	1	5.8
	2	5.2
	3	6.8
	4	7.4
Year 3	1	6
	2	5.6
	3	7.5
	4	7.8
Year 4	1	6.3
	2	5.9
	3	8
	4	8.4

Expert Solution

Quarter Data for Car Sales
Year	Quarter	Sales (1000's)	Moving average (4)	Center moving average (baseline)
year 1	1	4.80

	2	4.10
			5.35
	3	6.00		5.48
			5.60
	4	6.50		5.74
			5.88
Year 2	1	5.80		5.98
			6.08
	2	5.20		6.19
			6.30
	3	6.80		6.33
			6.35
	4	7.40		6.40
			6.45
Year 3	1	6.00		6.54
			6.63
	2	5.60		6.68
			6.73
	3	7.50		6.76
			6.80
	4	7.80		6.84
			6.88
Year 4	1	6.30		6.94
			7.00
	2	5.90		7.08
			7.15
	3	8.00		7.15

	4	8.40

Using Trend based forecasting in Excel, we get the following forecast for Year 5. In order to get this forecasting , the following steps are followed.. Select the Actual sales -> Data - > Forecast Sheet

	Quarter	Actual Sales (1000's)	Forecasted Sales (1000's)
year 1	Year1-Q1	4.800
	Year1-Q2	4.100
	Year1-Q3	6.000
	Year1-Q4	6.500
Year 2	Year2-Q1	5.800
	Year2-Q2	5.200
	Year2-Q3	6.800
	Year2-Q4	7.400
Year 3	Year3-Q1	6.000
	Year3-Q2	5.600
	Year3-Q3	7.500
	Year3-Q4	7.800
Year 4	Year4-Q1	6.300
	Year4-Q2	5.900
	Year4-Q3	8.000
	Year4-Q4	8.400
Year 5	Year5-Q1		7.33
	Year5-Q2		6.64
	Year5-Q3		8.44
	Year5-Q4		9.00

The green colored values are the forecasted value for each quarter of year 5

orchestra answered 2 years 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...

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

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

Moving Averages. Use the below actual sales to calculate a three-year average which will be used as...

Moving Averages. Use the below actual sales to calculate a three-year average which will be used as the forecast for next periods (chapter 14, text). Exponential Smoothing. Use the same data to forecast sales for the next periods with α=.40 (chapter 14, text). Regression Analysis on Excel. Draw a scatter graph from Insert/Graph/Scatter graph selections in Excel (chapter 15, text). Month Actual Sales 1 3050 2 2980 3 3670 4 2910 5 3340 6 4060 7 4750 8 5510 9 5280...

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

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 11Demand 7 9 5 9 13 8 12 13 9 11 7Starting 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) 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...

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

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

Question

Exercise 1. Graph three plots Sales, Forecast, center moving average 2. Predict the sales in year...

Solutions

Expert Solution

Related Solutions

develop a? three-period moving average forecast for april 2019

(a) Develop a three-year moving average. (b) Develop a four-year moving average.

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

Moving Averages. Use the below actual sales to calculate a three-year average which will be used as...

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

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

1) Using a 5 period simple moving average, the forecast for period 13 will be:

For the attached data set, 1. create a 3-month and 6-month moving average forecast. 2. Calculate...

Find the MAD for the 3-month and the 12-month moving average forecast. Year Month Rate(%) 2009 ...