Purchase Solution

Marketing Research Department of J.E. Hall Inc

Not what you're looking for?

Ask Custom Question

Barbara Herdman is the manager of the Marketing Research Department of J.E. Hall Inc. She recently collected demand data for the last six years of a special product and then asked one of her associates, Mr Brown, to forecast the data for the same past six years using the sales force composite method. The following data provides the details for Mr Brown's forecast:

Year Actual Demand Mr Brown's Forecast
1 490 492
2 510 503
3 535 512
4 560 578
5 590 580
6 630 620

a) Forecast the demand for the 7th year using the exponential smoothing method with alpha = 0.4. Show all details clearly. Use the initial forecast for 1st year of 492?

b) Which of the above methods is more accurate using MAD criteria?

c) Barbara performed a regression analysis on the six year data and established the following equation:

Demand = 456 + 28x(t) where t is code of year (t = 1,2,3,4,5,6)
Where t represents time period in years

Forecast the demand for the 7th year using the equation above.

Purchase this Solution

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
Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Motivation

This tests some key elements of major motivation theories.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.