Share
Explore BrainMass

Forecast Analysis

Problem 1
Do the Problem and answer all the questions.
Hint for question (c): Compare the errors on the basis of the Mean Absolute Deviation (MAD)?
a) Develop forecasts for period 5 through 10 using 4-month moving averages.

Problem 2
Do the problem and answer all the questions.
Hint for question: Compare the errors on the basis of the Mean Absolute Deviation (MAD)?
a.) Exponential smooting with smoothing constant ? = 0.1. Use the actual value of the first period as the starting forecast for the second period.

Problem 3
Do the problem and answer all the questions.
Hint for question: Compare the errors on the basis of the Mean Absolute Deviation (MAD)?
Copy and paste the following data set in Excel to save the typing effort and possible mistakes in data entry.

Attachments

Solution Summary

This solution is comprised of detailed analysis and step-by-step calculations of various Forecast Techniques like Exponentially Smoothed Forecast, Trend Projection etc. in EXCEL. The solution provides students with a clear perspective of the given problems and the related aspects of forecast analysis.

$2.19