Purchase Solution

Adjusted Exponential Smoothing Model

Not what you're looking for?

Ask Custom Question

The Willow River Mining Company mines and ships coal. It has experienced the following demand for coal during the past eight years:

Year Coat Sales (tons)

1 4260
2 4510
3 4050
4 3720
5 3900
6 3470
7 2890
8 3100

Develop an adjusted exponential smoothing model (α = 0.30, β = 0.20) and a linear trend line model, and compare the forecast accuracy of the two using MAD. Indicate which forecast seems to be most accurate.

Purchase this Solution
Solution Summary

The solution gives detailed steps on forecasting coat sales using Excel under two models: adjusted exponential smoothing and linear trend line.

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.

Measures of Central Tendency

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

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

  • Quantitative modeling

    Which forecast model do you perceive to be accurate: the exponential smoothing model from Problem 11or the seasonally adjusted forecast?

  • Small questions on Forecasting

    You need to evaluate the simple exponential smoothing method (without trend) and compare it to the trend-adjusted exponential smoothing method to finalize your decision.

  • Exponential smoothing forecast

    354416 Compute an exponential smoothing forecast with a=0.20, an adjusted exponential smoothing forecast with a=0.20 and b=0.20 and a linear trend line forecast.

  • Toyota Motors Forecasting

    Use the double (trend-adjusted) exponential smoothing method to forecast sales for months 2 to 13, assuming S1 = 1,243 and T1 = -30 and set α=0.7 and β=0.4. b.

  • Exponential and Adjusted Exponential Forecast and MAPD

    496800 Exponential and Adjusted Exponential Forecast and MAPD Perform an Exponential Smoothing Forecast (a=0.3) and an Adjusted Exponential Smoothing Forecast (b=0.2) on the given data and forecast the demand for the month of November.

  • Quantitative Methods: Demand for Product ZXT

    263576 Moving Average Forecast, Exponential Smoothing Forecast, Adjusted Exponential Smoothing Forecast, Mean Absolute Deviation (MAD) and Mean Square Error (MSE) Recent past demand for product ZXT is given in the following table: Month Actual Demand

  • Forecasting & Regression (12 Problems) : Hypothesis Testing and 2 and 3-Parameter Exponential Smoothing

    Use a 2-parameter exponential smoothing model with α = .2 and γ = .4. Next, use a 3-parameter exponential smoothing model with α = .2, γ = .4, and β = .7. Which of the following are true? a.

  • Exponentially Smoothed Forecast, MAD, MAPD in EXCEL

    Exponential Smoothed Forecast, with alpha=0.30 is better, since, MAPD for this one is less as compared to Adjusted Exponential Smoothing Forecast,with alpha=0.20.

  • The exponential smoothing model

    410908 Exponential Smoothing Model: Review In an exponential smoothing model, if the smoothing constant (alpha) were equal to 0, then a. the forecast would never change. b.

View More Related Solutions