Calculate a forecast using a trend adjusted smoothing.

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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

© BrainMass Inc. brainmass.com December 24, 2021, 4:47 pm ad1c9bdddf
https://brainmass.com/business/business-math/calculate-forecast-trend-adjusted-smoothing-7515

Solution Preview

Let alpha 1 = A1 and alpha 2 = A2

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

Solution Summary

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

$2.49