Purchase Solution

Forecast Accuracy Measure

Not what you're looking for?

Ask Custom Question

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

Solution provided by:
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.