Purchase Solution

Single Exponential Smoothing

Not what you're looking for?

Ask Custom Question

Sunrise sports has experienced rapidly expanding retail sales. Its sales levels for the past 12 years are:

(see data in attached file)

Develop a single exponential smoothing model using Alpha =0.30 . use as a starting value the average of the first 6 years' data. Determine the forecast value for year 2001.

a.) Develop a single exponential table using the data from problem 16-39 and a smoothing constant,
alpha = .30.

SET THE FIRST FORECAST VALUE TO 4.0.

b) Calculate the MAD

c) Calculate the MSE

Notice that the directions tell us to set the first forecast value to the average of the first 6 recorded values. Although 4.0 is not the actual average, let us agree to set the first forecast value to 4.0 in order to allow us to focus on the forecasting method rather than getting distracted by more complex calculations.

Attachments
Purchase this Solution
Solution Summary

The expert examines single exponential smoothing.

Solution provided by:
Gaurav Agarwal, MS
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

View More Free Quizzes
Related BrainMass Solutions

  • Forecast Analysis

    Develop spreadsheet models for forecasting prices using single moving average and single exponential smoothing. b.

  • Exponential smoothing forecast

    The formula for single exponential smoothing is: S(t+ 1)= St + a (error) where a is the exponential smoothing coefficient which is used to weight the error of the last observation (St) appropriately, so as to give us a more accurate value for the current

  • Compariosn of forecasting methods

    Calculate the single exponential smoothing forecast for period 10-12 using an initial forecast (F1) of 61 and Alpha of 0.30. d.

  • Time Series Analysis and Forecast

    Based on what you see, which of the exponential smoothing models do you think should be used for forecasting? Why? b. Use simple exponential smoothing to forecast these data, using no holdout period and requesting 12 months of future forecasts.

  • Time series using forecast accuracy and suitability of methods

    For single exponential smoothing, first we identify which value of alpha provides the best fit.

  • Forecasting

    163191 Forecasting- weighted moving average/single exponential smoothing Please help... b & c can be done with the attached template, but I do not know how to implement the data...

  • Expoentail smoothing

    Time Period Value Time Period Value 1 9.4 6 11.0 2 8.2 7 10.3 3 7.9 8 9.5 4 9.0 9 9.1 5 9.8 Answer Exponential Smoothing assigns exponentially decreasing weights as the observation get older whereas in Single

  • Single order exponential smoothing

    69278 Operation management: forecasting using single order exponential smoothing United Airways has tried out single order exponential smoothing for forecasting passenger demand. Below are recent results using alpha = 0.2, 0.4. and 0.6.

  • Toyota Motors Forecasting

    Based on your calculations, is single or double exponential smoothing a better approach in this specific case? Why? Please see Excel file attached.

View More Related Solutions