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

milcah answered 2 years ago
Next > < Previous

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?
3) (20 pts) If you used a two-year moving average on the data below, how many...
3) (20 pts) If you used a two-year moving average on the data below, how many iPhone’s would you expect to sell in 2019? What is the MAD for this forecasting method? Year    iPhone sales (# of phones) 2014    125,000,000 2015    150,000,000 2016    169,000,000 2017    231,000,000     2018    212,000,000 b) If you used a 3-year weighted moving average, how many iPhones would you expect to sell in 2019 if you assign weights of 20%, 30%, and 50% with the higher weights assigned to more recent forecasts?    c)...
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.
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT