Question

In: Math

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

  1. 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).
  2. Exponential Smoothing. Use the same data to forecast sales for the next periods with α=.40 (chapter 14, text).
  3. 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

10

5504

11

5810

12

6100

Solutions

Expert Solution

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

Formula:

2 . Exponential Smoothing. Use the same data to forecast sales for the next periods with α=.40 (chapter 14, text).

Formula:

  1. Regression Analysis on Excel. Draw a scatter graph from Insert/Graph/Scatter graph selections in Excel (chapter 15, text).


Related Solutions

Requirements: Moving Averages. Use the below actual sales to calculate a one-year average which will be...
Requirements: Moving Averages. Use the below actual sales to calculate a one-year average which will be used as the forecast for next periods (chapter 14, text). Choose a moving average period that best supports this calculation. 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...
Requirements: Moving Averages. Use the below actual sales to calculate a one-year average which will be...
Requirements: Moving Averages. Use the below actual sales to calculate a one-year average which will be used as the forecast for next periods (chapter 14, text). Choose a moving average period that best supports this calculation. 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...
(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...
This passge below require critical analysis and breakdown Moving averages, weighted moving averages, and exponential smoothing...
This passge below require critical analysis and breakdown Moving averages, weighted moving averages, and exponential smoothing methods are forecasting methods that are used for a time series with a horizontal pattern. These methods provide a high level of accuracy for short-range forecasts, such as a forecast for the next time period and are used to smooth out random fluctuations in the time series and have a high level of accuracy for short-range forecast. The moving Average method uses the average...
This passge below require critical analysis and breakdown Moving averages, weighted moving averages, and exponential smoothing...
This passge below require critical analysis and breakdown Moving averages, weighted moving averages, and exponential smoothing methods are three forecasting methods that are appropriate for a time series with a horizontal pattern. These methods are easy to use and generally provide a high level of accuracy for short-range forecasts, such as a forecast for the next time period. “The moving averages method uses the average of the most recent k data values in the time series as the forecast for...
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
Of the three quantitative forecasting techniques (moving average, weighted moving average, and exponential smoothing), which do...
Of the three quantitative forecasting techniques (moving average, weighted moving average, and exponential smoothing), which do you think provides the most accurate forecast and why?
Consider the following given information, determine the 3-year moving averages that would have been used to...
Consider the following given information, determine the 3-year moving averages that would have been used to forecast the sales (in millions) for the years subsequent to each group of three years. Determine the forecast error associated with each forecast. Year(t) 1993/ 1994 /1995 /1996 /1997 /1998 /1999 /2000 Profit Y(t) 0.9 / 1.1 /1.2 / 1.3 / 1.4 / 1.5 / 1.6 / 1.7 You may create a table with below information. Year / Sales in millions / 3-year Moving...
Discuss the techniques of moving averages and filter rules as they are used by technical analysts....
Discuss the techniques of moving averages and filter rules as they are used by technical analysts. Include in your answer a discussion of technical analysis for an investor wishing to invest in emerging markets.
this passage require Analysis and breakdown Moving averages is a forecasting method that uses the average...
this passage require Analysis and breakdown Moving averages is a forecasting method that uses the average of the k most recent data values in the time series as the forecast for the next period (Anderson, Sweeney, Williams, Camm, Cochran, Fry, & Ohlmann). This approach can be used when the company requires immediately forecasting for a massive volume of data. Exponential smoothing a forecasting method that uses a weighted average of past time series values as the forecast; it is a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT