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
NOTE: I HOPE THIS ANSWER IS HELPFULL TO YOU...**PLEASE SUPPORT ME WITH YOUR RATING....
orchestra answered 1 year agoRelated 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
Latest Questions
- A sample human input file that contains test values that a human would enter on the...
- A solution is prepared by dissolving 15 ml of methanol in 150.0 ml water at 25...
- Consider a newlywed who is planning a wedding anniversary gift of a trip to Canada for...
- We are evaluating a project that costs $868,000, has a life of eight years, and has...
- a.) Given sample data: 61.2, 61.9, 62.8, 63.1, 64.0, 64.3, 64.9, 65.5, 66.3 and 67.9, test...
- A research paper describes an experiment in which 74 men were assigned at random to one...
- 1. Which components would a retail organization consider while surveying/assessing the suitability of its products for...
ADVERTISEMENT