Forecast Accuracy Measure
Not what you're looking for?
RAP Computer assembles personal computers from generic parts it purchases at a discount, and it sells the units via phone orders it receive from customers responding to the company's ad in trade journal. The business has developed an exponential smoothing forecast model to forecast future computer demand. Actual demand for th company's computer for the past 8 months as well as forecast are shown in the following table:
Month Demand Forecast
March 120 -
April 110 120.0
May 150 116.0
June 130 129.6
July 160 129.7
August 165 141.8
September 140 151.1
October 155 146.7
Nov - 150.0
Using a measure of forecast accuracy of your choice, ascertain whether the forecast appears to be accurate
Determine whether a 3- month moving average would provide a better forecast
Purchase this Solution
Solution Summary
This solution shows the calculation of error, absolute error, three-period moving average forecast, error and absolute error in the attached Excel file. This solution identifies the accuracy of the forecast, which forecast would be better, and why.
Solution Preview
Dear student, please refer to the attachment for the ...
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
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.
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.