Purchase Solution

Forecasting

Not what you're looking for?

Ask Custom Question

Please help... b & c can be done with the attached template, but I do not know how to implement the data...

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. Using a simple three month moving average, find July forecast?
c. Using single exponential smoothing with alpha= 0.2 and a June forecast = 13, find the July forecast. Make whatever assumptions you wish.

Attachments
Purchase this Solution
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
Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Operations Management

This quiz tests a student's knowledge about Operations Management

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

View More Free Quizzes
Related BrainMass Solutions

  • Planning tools for forecasting

    Forecasting Planning Tools 1. Quantitative Forecasting - This type of forecasting is a common method used in organizations. Quantitative predictions are generated by using past or historical data to forecast the future.

  • Appropriate Forecasting Technique for Aldi Foods

    (forecasting, n.d).

  • Developing a Financial Forecast for the Division

    Forecasting is an essential part of budgeting. Forecasting can be made by a firm for purpose other than budgeting whereas Budgeting makes by firm for purpose of forecasting (Kinney & Raiborn, 2008).

  • discussion on methodology of forecasting

    389756 Discussion on Methodology of Forecasting Provide an introduction and background discussion on methodology of forecasting. Give an example on forecasting. Forecasting is the practice of estimating future events.

  • Forecasting tools

    223236 Forecasting tools What criteria should an organization use in deciding what type of forecasting tools they should use? Criteria Used to Select Forecasting Tools Forecasting Tool is used to estimate the unknown events and situations.

  • Understanding Forecasting models as they apply to products

    houses can be forecasted by using linear regression model of forecasting-a quantitative method of demand forecasting.

  • Types of demand forecasting

    This discusses the types of demand forecasting

  • Forecasting Methods used by Modern Corporations

    One of the newer forecasting techniques is called "scenario forecasting" (Dictionary of American History, 2003).

  • RevPAR and Forecasting

    409845 RevPAR and Forecasting Why is forecasting so important? How are RevPAR used for forecasting? Why is forecasting so important? How are RevPAR used for forecasting? Forecasting is important because it is less time consuming.

  • The Challenges of Forecasting

    Consequences of under/over forecasting: • Under forecasting can result to opportunity cost of not being able to sell the product because no inventory exists • Under forecasting will result to lost commission for potential sales • Over forecasting

View More Related Solutions