Purchase Solution

forecast with moving average or weighted average

Not what you're looking for?

Ask Custom Question

Data collected on the yearly demand for 50-pound
bags of fertilizer at Wallace Garden Supply are
shown in the following table. Develop a 3-year moving
average to forecast sales. Then estimate demand
again with a weighted moving average in which
sales in the most recent year are given a weight of 2
and sales in the other 2 years are each given a weight
of 1. Which method do you think is best?
DEMAND FOR FERTILIZER
YEAR (1,000S OF BAGS)
1 4
2 6
3 4
4 5
5 10
6 8
7 7
8 9
9 12
10 14
11 15

Purchase this Solution
Solution Summary

This solution provides explanation how to perform forecast by using moving average or weighted average.

Solution Preview

Hi there,

Thanks for allowing me to work on your questions. Here, let's define variable first. For year x, x1=1,x2=2,x3=3,x4=4,x5=5,x6=6,x7=7,x8=8,x9=9,x10=10,x11=11. Meanwhile, demand for fertilizer y, ...

Purchase this Solution
Free BrainMass Quizzes
Exponential Expressions

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

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.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Probability Quiz

Some questions on probability

Solving quadratic inequalities

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

View More Free Quizzes
Related BrainMass Solutions

  • Forecasting: Time Series and Moving Average

    A _________ moving average model for time series data is a moving average model with _________ weights. a. Simple, unequal b. Weighted, equal c. Weighted, unequal d. Either simple, unequal or weighted, equal e.

  • Forecast using moving average and waighted moving average

    3-What is the forecast for your Year 6 sales using a weighted 2-year moving average with weights of 70% for the most recent year and 30% for the year before that?

  • Demand Forecasting and Forecasting Error

    The graphs are being created with fictitious data to show forecasting trends, moving average, weighted moving average, exponential moving average, and trend line with regression equation.

  • Three-Year Moving Average

    The smaller the MAD, the more reliable the forecast. We conclude that the 3-yr weighted moving average is a better forecast. This solution shows how to calculate a 3-year moving average and a 3-year weighted moving average.

  • Analysis on 4 forecasting models using Excel

    • 3-Month Moving Average Model • 3-Month Weighted Moving Average Model • Exponential Smoothing Model • Regression Model 2.

  • Director of Supply Chain is developing forecasts: moving average, smoothing factor

    The solution carefully explains how to construct a moving average, a weighted moving average, and a forecast using a smoothing factor.

  • Weighted Moving Average Forecast and MAD in EXCEL

    A 3 Month Moving Average Forecast and another 3 Month Weighted Moving Average Forecast, using different smoothing/weighing factors, has been performed in Excel.

  • Time Series Forecasting Methods

    In other words, a comparison of a 3, 4 or 5 month moving average will show that the forecast will be smoother for the 5 month moving average vs. the 3 or 4 month moving average.

  • Forecasting

    The solution computes a three-month moving average forecast and a weighted three-month moving average forecast and compares the two forecasts using MAD (mean absolute deviation).

  • Different Methods for Forecasting Sales

    trend equation, Y = 16.86+0.5*T; a) 5-month moving average; Using the 5-month moving average, the forecast for September 15+20+18+22+20/5 = 19 (in units of thousands) b) Weighted average, where the weights are - 0.60 (August), 0.30 (July)

View More Related Solutions