Explore BrainMass

Explore BrainMass

    Forecast Accuracy Measure

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

    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

    © BrainMass Inc. brainmass.com June 3, 2020, 11:29 pm ad1c9bdddf

    Solution Preview

    Dear student, please refer to the attachment for the ...

    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.