Purchase Solution

Business Forecasting: Exponential Smoothing

Not what you're looking for?

Ask Custom Question

HP uses the AMD chip in some of its desktop computers. The prices for the chip during the last 12 months were as follows:

Month Price per Chip
January $1.80
February $1.67
March $1.70
April $1.85
May $1.90
June $1.87
July $1.80
August $1.83
September $1.70
October $1.65
November $1.70
December $1.75

A. Use a 2 month moving average on all the data and plot the averages and prices.
B. Use a 3 month moving average and add the 3 month plot to the graph created in part (A)
C. Which is better (using the mean absolute deviation): the 2 month average or the 3 month average?
D. Compute the forecasts for each month using exponential smoothing, with an initial forecast for January of $1.80 Use α = .3, and finally α = .5 Using MAD, which α is the best?

Must show all work via excel.

Purchase this Solution
Solution Summary

This response compares the 2 month moving average and the 3 month moving average of HP.

Purchase this Solution
Free BrainMass Quizzes
Learning Lean

This quiz will help you understand the basic concepts of Lean.

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.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

View More Free Quizzes
Related BrainMass Solutions

  • Moving Average Approach and Exponential Smoothing approach

    Quantitative Techniques for Business Management 2nd Edition. Rex Bookstore. This solution shows the difference between the Moving Average approach and Exponential Smoothing approach to forecasting.

  • Forecasting model

    322118 Forecasting Model in Business The forecasting model that assumes previous time periods have some influence on future sales, but the influence varies by time period, is: a. exponential smoothing.

  • Forecasting Methods

    This posting provides solution to four problems on forecasting methods including moving averages forecasting, exponential smoothing and a problem on deicision making for evaluating cost.

  • Demand Forecasting: Measuring forecast accuracy and comparing different techniques/algorithms

    The solution provides help on two forecasting techniques: 1) Moving average methods, 2) Exponential smoothing. In excel, it demonstrates forecast and forecasting error calculations.

  • Forecast Analysis

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

  • Forecasting Exponential Smoothing

    The expert examines forecasting exponential smoothing.

  • Compariosn of forecasting methods

    78864 Forecasting:"Exponential smoothing", "Moving averages","Weighted moving average","Exponential smoothing with trend", (See attached file for full problem description) Your manager is trying to determine what forecasting method to use.

  • Time Series

    Winters' method takes exponential smoothing and adds in trends and seasonality factors. Answer: Simple exponential smoothing This solution analyzes which time series forecasting method would not be used to forecast seasonal data.

  • Evaluate trendless data; forecasts to improve communciation

    When should exponential smoothing be used for data? Explain with an example. In exponential smoothing, what type of smoothing constant should be chosen for little smoothing compared with moderate smoothing?

  • Forecasting and Forecasting Errors in Business

    498759 Forecasting and Forecasting Errors in Business Should your division be using moving average, weighted average, or exponential smoothing in forecasting calculations? Why? What are some sources of forecast errors?

View More Related Solutions