# bus644 week 3 discussion

Question # 00004203 Posted By: mac123 Updated on: 11/27/2013 05:06 PM Due on: 11/30/2013
Subject Business Topic Management Tutorials:
Question
bus644 week 3 discussion

Forecasting Methods

1. Read Problem 6 in Chapter 6 of your textbook. Calculate and answer parts a through d. Include all calculations and spreadsheets in your post. Explain why the moving average method was used instead of another forecasting method. What might be another forecasting method that could prove to be just as useful?

2. The figures below indicate the number of mergers that took place in the savings and loan industry over a 12-year period.

Year Mergers Year Mergers

2000 46 2006 83

2001 46 2007 123

2002 62 2008 97

2003 45 2009 186

2004 64 2010 225

2005 61 2011 240

a. Calculate a 5-year moving average to forecast the number of mergers for 2012.

b. Use the moving average technique to determine the forecast for 2005 to 2011. Calculate measurement error using MSE and MAD.

c. Calculate a 5-year weighted moving average to forecast the number of mergers for 2012. Use weights of 0.10, 0.15, 0.20, 0.25, and 0.30, with the most recent year weighted being the largest.

d. Use regression analysis to forecast the number of mergers in 2012.
Tutorials for this Question
1. ## Solution: bus644 week 3 discussion

Tutorial # 00003995 Posted By: mac123 Posted on: 11/27/2013 05:09 PM
Puchased By: 4
Tutorial Preview
The solution of bus644 week 3 discussion...
Attachments
bus644_week_3_discussion.doc (46 KB)
bus644_week_3_discussion.xls (18 KB)
Recent Feedback
Rated By Feedback Comments Rated On
ls...e74 One-on-one chat with the tutors 10/22/2017
Tr...129 Delivery before the deadline 02/28/2014

Great! We have found the solution of this question!