Purchase Solution

Operation management: forecasting moving average

Not what you're looking for?

Ask Custom Question

The actual sales (demand in thousand units) for 2003, 2004, 2005, 2006, and 2007 are: 1975, 2150, 2580, 3700, and 4920.

(A) Use 3-period weighted moving average with the weights of 0.2, 0.3, and 0.5 to forecast the sales of 2008.

(B) Use simple exponential smoothing technique with smoothing constant of 0.3 to forecast the sales of 2008, given the forecast for 2006 has been 3330. [Hint: Use the forecast for 2006 to figure out the forecast for 2007 and then use that forecast to find out the forecast for 2008.]

(C) Use 3-period moving average to forecast the sales of 2008. What is the forecast? What is the MAD for this model?

(D) Use the following trend model to forecast the sales of 2008. To obtain the trend model, 2003 was entered into the computer as Period 1, 2004 as Period 2, 2005 as Period 3, 2006 as Period 4, .. etc.
Sales = 1100 + 950 * Period

Purchase this Solution

Solution Summary

This solution answers various questions involving trend models and sales forecasts.

Solution provided by:
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
Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

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.

Situational Leadership

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

Production and cost theory

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