Purchase Solution

Excel: exponential smoothing forecast

Not what you're looking for?

Ask Custom Question

** Please refer to the attached file for the following question **
Develop a forecast for years 2 through 12 using exponential smoothing with ? = .4 and a forecast for year 1 of 6. Plot your new forecast on a graph with the actual data and the naive forecast. Based on a visual inspection, which forecast is better?

Please refer to attachment for details.

Attachments
Purchase this Solution
Solution Summary

In this solution we use Excel to develop two forecasts based on the given parameters and data and highlights which of these forecasts is better.

Solution Preview

** Please see the attachment for the complete solution **

We have the Exponential smoothing forecast,
Ft = Ft-1 + α (At-1 - Ft-1)
i.e., New ...

Purchase this Solution
Free BrainMass Quizzes
Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Operations Management

This quiz tests a student's knowledge about Operations Management

View More Free Quizzes
Related BrainMass Solutions

  • Forecast Analysis

    Using MAD, MSE, and MAPE as guidance, find the best number of moving average periods and best smoothing constant for exponential smoothing. 4. For the data in the Excel file Gasoline Prices do the following: a.

  • Stocks

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

  • Forecasting methods in Excel

    Develop an appropriate forecast using a moving average approach. b. Develop an appropriate forecast using a simple exponential smoothing approach. c. Develop an appropriate forecast using exponential smoothing with trend (Holt's method.) d.

  • Exponential Smoothing Forecast

    168573 Exponential Smoothing Forecast. 16. Look at the attached spreadsheet....Use excel or QM to do exponential smoothing to compute miles for weeks 2 through 12, assuming an initial forecast for week 1 of 17,000. Use alpha of 0.2.

  • Use Excel to answer forecasting questions

    (a) Exponential Smoothing (from 3a) (b) Regression   Problem Please use the following data in MS Excel to answer the below questions (no need to send Excel file).

  • Exponential Smoothing to Forecast a Time Series.

    The solution illustrates the application of Exponential smoothing technique to forecast a time series. Response includes a Word and Excel document.

  • Development of Appropriate Forecasting Model

    Show work for the following forecast techniques: a. Moving average ( n=3) b. Moving average (n=5) c. Linear trend line d. Exponential smoothing (alpha = .3) e. Exponential smoothing (alpha = .5) f.

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

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

View More Related Solutions