Purchase Solution

Calculate a forecast using a trend adjusted smoothing.

Not what you're looking for?

Ask Custom Question

The business analyst for Ace Business Machines, Inc. wants to forecast this year's
demand for manual typewriters based on the following historical data:

TIME PERIOD-------DEMAND
5 years ago---------------900
4 years ago--------------- 700
3 years ago--------------- 600
2 years ago--------------- 500
Last year---------------- 300

What is the forecast for this year using trend adjusted (double) smoothing with alpha(1) = 0.3 and alpha(2) = 0.2, if the forecast for last year was 310, the forecast for two years ago was 430, and the trend estimate for last year's forecast was -150?

* Please use 310, 430, -150 instead (if the forecast for last year was 310, the forecast for two years ago was 430, and the trend estimate for last year's forecast was -150).

Purchase this Solution
Solution Summary

The solution is very detailed including the math and narrative to aid in fully understanding the problem.

Solution Preview

Let alpha 1 = A1 and alpha 2 = A2

The basic formulas for double exponential smoothing are
Bt= A2(St - St-1) + ...

Purchase this Solution
Free BrainMass Quizzes
Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

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.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

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.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

View More Free Quizzes
Related BrainMass Solutions

  • Small questions on Forecasting

    Using the data shown below, prepare a forecast using each method and calculate the Cumulative Forecast Error (CFE) and Mean Absolute Deviation (MAD) to determine which method is more appropriate.

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

  • Production & Operations of a Marina

    Your task, should you accept it and continue to be employed at the marina, is to use trend-adjusted exponential smoothing to calculate a FIT (look on page 327 for what a FIT is).

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

  • Compariosn of forecasting methods

    Calculate the exponential smoothing with trend component forecast for periods 10-12 using an initial trend forcast (T9) of 1.8, and exponential smoothing forecast (F9) of 60, and alpha of 0.30 and beta of 0.30.

  • Sales Records for Fastgro Fertilizer Company

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

  • Quantitative modeling

    For the demand data in Problem 11, develop a seasonally adjusted forecast for 2006. (Use a linear trend line model to develop a forecast estimate for 2006.)

  • Different Methods for Forecasting Sales

    This question gives the sales for 7 months, and asks to forecast sales for the next month. You need to calculate moving average and weighted average, exponential smoothing and look at linear trend equation.

  • Forecasting Problems

    Using the exponential smoothing with a weight of = 0.30, develop forecasts for years 2 through 6. 5-22 Using the trend projection method, develop a forecasting model for the sales of Cool-Man air conditioners (see problem 5-18). 5-33 Management

View More Related Solutions