Purchase Solution

Average Forecast Error

Not what you're looking for?

Ask Custom Question

I am having a hard time calculating the average forecast error for september using a four period moving average.

Month actual demand forecast demand Avg forecast error
march 20
April 25
May 40
June 35
July 30 30
Aug 45 32.5
Sept 37.5

How do I determine sept demand to get the avg forecast error or do I need it?

Purchase this Solution
Solution Summary

The solution shows calculation of the average forecast error for September using a four period moving average.

Solution Preview

Hi,

Using four period moving average, demand forecast for Sept is (May ...

Purchase this Solution
Free BrainMass Quizzes
Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

View More Free Quizzes
Related BrainMass Solutions

  • Moving Average Forecast and Cumulative Error

    This solution is comprised of detailed step-by-step calculations and explanation of various Forecast Techniques like Moving Average Forecast and Weighted Moving Average Forecast and Forecast Accuracy Measures like Forecast Error and Cumulative Error in

  • Exponential smoothing forecast

    Compare the three forecasts using MAD and average error (E) and indicate which forecast seems to be most accurate.

  • Analysis on 4 forecasting models using Excel

    Based upon using the 3-Month Moving Average Model and mean squared error (MSE) as a measure of forecast accuracy, what would be the interval estimate for projected demand for the test equipment for time period 25?

  • Farquart Focus Capacity Question: June Forecast and March Demand

    (a) 2 period moving average Month Demand Forecast Error Absolute error January 14 february 23 March 12 18.50 -6.50 6.50 April 17 17.50 -0.50 0.50 May 18 14.50 3.50 3.50

  • Moving Average Forecast and Forecast Accuracy Measure

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

  • Sales Records for Fastgro Fertilizer Company

    Compute a three-quarter moving average forecast for quarters 4 through 13 and compute the forecast error for each quarter b. Compute a five-quarter moving average forecast for quarters 6 through 13 and compute the forecast error for each quarter.

  • Forecast Accuracy Measure

    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.

  • Forecasting, Weighted Averages: Various Questions

    Average error, or bias (E) Bias is the per period average of cumulative error (E) Where et=Error for period t. A large positive value of Bias indicates a forecast is biased low; a large negative error indicates it is biased high.

  • Forecasting problem

    Day Temperature Forecast Error Absolute error Squared error Absolute % error 1 84 2 80 3 79 82.0 -3.0 3.0 9.0 3.8% 4 81 79.5 1.5 1.5 2.3 1.9% 5 78 80.0 -2.0 2.0 4.0 2.6% 6 73 79.5 -6.5 6.5 42.3 8.9% Yesterday 76 75.5 0.5 0.5

View More Related Solutions