Purchase Solution

Historical Demand : Weighted Average

Not what you're looking for?

Ask Custom Question

The following data summarizes the historical demand for a product

Month Actual demand
March 20
April 25
May 40
June 35
July 30
August 45

Use a weighted moving average method with weights w1 = .2, w2 = .3 and w3 = .5 and determine the forecasted demand for August and September.

Purchase this Solution
Solution Summary

The expert examines the weighted average for historical demand.

Solution Preview

Month Actual demand
March 20
April 25
May 40
June 35
July 30
August 45

Use a weighted ...

Solution provided by:
Gaurav Agarwal, MS
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Introduction to Finance

This quiz test introductory finance topics.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

View More Free Quizzes
Related BrainMass Solutions

  • Chapter 13 -Problem 17 Operations Management for Competitive

    From the choice of simple moving average, weighted moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate? Why? b.

  • Expected Value of Umbrellas Using Historical Data

    These weightings determine the relative importance of each quantity on the average http://www.investopedia.com/terms/w/weightedaverage.asp Hence we will find the weighted average: =Sum of the product of the Umbrella demand with its frequency

  • Forecasting

    Historical demand for a product is: Demand Jan 12 Feb 11 March 15 APril 12 May 16 June 15 a. using weighted moving average with weights of .60, .30 and .10. What is July forecast? b.

  • Forecasting: weighted moving average

    Thank You Excel file shows a month's foretasted demand using: a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast. b. Using a simple three-month moving average c.

  • Forecasting

    70099 Operation management: Forecasting Historical demand for the number of doctors on night shift in a local hospital is: Week Doctors 1 45 2 48 3 44 4 36 5 48 6 30 Forecast the number of doctors in week 7 by applying each of the following

  • Forecasting model

    b. historical analogy. c. mean absolute deviation. d. moving average. e. weighted moving average.

  • Time Series Forecasting Methods

    The moving average shows the forecasting demand is stable but doesn't show trends in the demand behavior. The moving average will have a smoother forecast when the moving average period is longer.

  • Forecast inventory for next year.

    If the weighted moving average method is used, high weights are placed on prior periods belonging to the same season.

  • Weighted Moving Average

    212201 Weighted Moving Average What is weighted moving average with weights w1= .2 w2= .3 and w3 =.5 and what is the forecast demand for August and September for the data below?

View More Related Solutions