Explore BrainMass
Share

Explore BrainMass

    Moving Average Forecast and Forecast Accuracy Measure

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

    Aztec Industries has developed a forecasting model that was used to forecast during a 10-month period. The forecasts and actual demand were as follows:

    (see attached file for data)

    Measure the accuracy of the forecast by using MAD, MAPD, and cumulative error. Does the forecast method appear to be accurate?

    © BrainMass Inc. brainmass.com October 10, 2019, 12:33 am ad1c9bdddf
    https://brainmass.com/statistics/central-tendency/moving-average-forecast-and-forecast-accuracy-measure-296449

    Attachments

    Solution Preview

    Please refer to the attachment 'Solution.xlsx' for the workings and solutions.

    Judging by the low ...

    Solution Summary

    Detailed step-by-step calculations involving Moving Average Forecast and Forecast Accuracy Measures of MAD, MAPD and Cumulative Error has been shown in Excel.

    $2.19