Question

In: Statistics and Probability

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

4 2910

5 3340

6 4060

7 4750

8 5510

9 5280

10 5504

11 5810

12 6100

Solutions

Expert Solution


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...
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...
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...
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...
(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...
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.  
(a) Using practical examples, differentiate between the following commercial averages: (i) Moving Average (ii) Progressive Average...
(a) Using practical examples, differentiate between the following commercial averages: (i) Moving Average (ii) Progressive Average (iii) Composite Average (b) Explain what you understand by a theoretical probability distribution and how it is useful in business decision-making? (c) Explain the process of hypothesis testing, detailing clearly under which condition the Normal distribution may be used. (d) Explain the difference between the following four non-probability sampling methods: quota sampling, judgmental sampling, snowball sampling and convenience sampling. (e) Explain how the sampling...
All ratios should use year-end totals and not averages and be compared to its industry average...
All ratios should use year-end totals and not averages and be compared to its industry average as well as time trend analysis. Calculate the ratios mentioned in the table below. For the turnover in days, assume 365 days. Also the debt ratio industry average given in the case is actually the liabilities-to-asset ratio. Hint: for Cash flow statement, you have to add back amortization to the Land, Plant, and Equipment item. Ratios: Current Ratio Fixed Assets Turnover Operating Profit Margin...
Identify situations in which tools such as linear regression and the moving averages and smoothing techniques...
Identify situations in which tools such as linear regression and the moving averages and smoothing techniques used for a business in predicting future revenues. Which tool is best for long-range projections? Which is the simplest for a small business? Why?  
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT