Moving Average Forecast and Cumulative Error
Not what you're looking for?
1. The Fastgro Fertilizer Company distributes fertilizer to various lawn and garden shops. The company must base its quarterly production schedule on a forecast of how many tons of fertilizer will be demanded from it. The company has gathered the following data for the past 3 years from its sales records:
Year Quarter Demand for Fertilizer (tons)
1 1 105
2 150
3 93
4 121
2 5 140
6 170
7 105
8 150
3 9 150
10 170
11 110
12 130
A. Compute a three quarter moving average forecast for quarter 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.
C. Compute a weighted three quarter moving average forecast, using weights (weighing factors) of .50, .33, and .17 for the most recent, next recent, and most distant data, respectively, and compute the forecast error for each quarter.
D. Compare the forecasts developed in (a), (b), and (c), using cumulative error. Which forecast appears to be most accurate? Do any of them exhibit any bias?
Purchase this Solution
Solution Summary
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 EXCEL. Comparison of these Forecast Techniques based on these Forecast Accuracy measures has also been shown.
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
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.
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.