Purchase Solution

Exponential and Adjusted Exponential Forecast and MAPD

Not what you're looking for?

Ask Custom Question

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. Compare the accuracy of the two forecast methods using MAPD.

[Please refer to the attachment for data].

Attachments
Purchase this Solution
Solution Summary

A detailed forecast analysis has been performed in EXCEL.

Solution provided by:
Anwesha Ghosh, MSc
Education
  • MSc, Osmania University
  • MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
  • BSc, Banaras Hindu University
Recent Feedback
  • "Very fast turnaround. Excellent communication! Much appreciated!"
  • "excellent"
  • "excellent"
  • "excellent work"
  • "Fantastic..great solution and very well explained!!!!"
Purchase this Solution
Free BrainMass Quizzes
Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Probability Quiz

Some questions on probability

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

View More Free Quizzes
Related BrainMass Solutions

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

  • Forecast and Regression Analysis

    314451 Moving Average Forecast, Exponential Smoothing Forecast, Adjusted Exponential Smoothing Forecast, MAD, MAPD, Cumulative Error, Comparison among different Forecast Techniques and Regression Analysis 1.

  • Stocks

    A moving average forecast and exponential smoothing forecast has been performed on stock prices in EXCEL.

  • Petroco Service Station: Exponentially smoothed forecast & MAPD

    The solution comprises of detailed calculations of Exponential Smoothing Forecast and MAPD in Excel.

  • Time series analysis of ice cream production

    Develop: a) an exponential smoothing model (= 0.50) b) moving average model (k = 4) c) a trend model; and d) a seasonally adjusted model to forecast demand.

  • Management Science: Forecasting

    with alpha=.40, the adjusted exponential smoothing forecast with alpha=.40 and beta=.30, and the linear trend line forecast.

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

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

  • Adjusted Exponential Smoothing Model

    exponential smoothing model (α = 0.30, β = 0.20) and a linear trend line model, and compare the forecast accuracy of the two using MAD.

View More Related Solutions