Forecast Analysis
Not what you're looking for?
Consulting income at Jake Welch Associates for the period February - July is below. Forecast August's income using the following techniques.
a) Two month moving average.
b) Two month weighted moving average, where the most recent month is weighted 60% and the second most recent month is weighted 40%.
c) Exponential smoothing, using a 0.1 smoothing factor and Feb. forecast of $69,000.
d) Exponential smoothing, using a 0.4 smoothing factor and Feb. forecast of $69,000.
e) Which technique provides the best forecast and why.
Please see attachment for details.
Purchase this Solution
Solution Summary
This solution is comprised of detailed analysis and step-by-step calculations of various Forecast Techniques like Exponentially Smoothed Forecast, Weighted Moving Average Forecast etc. in Excel. The solution provides students with a clear perspective of the given problems and the related aspects of forecast analysis.
Education
- MSc, Osmania University
- MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
- BSc, Banaras Hindu University
Recent Feedback
- "Very fast turnaround. Excellent communication! Much appreciated!"
- "excellent"
- "excellent"
- "excellent work"
- "Fantastic..great solution and very well explained!!!!"
Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.