Calculate five year moving averagetle.., Operation Management

Assignment Help:
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
2001 46
2002 62
2003 45
2004 64
2005 61
2006 83
2007 123
2008 97
2009 186
2010 225
2011 240

a. Calculate a 5 year moving average for 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 merg- ers 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.

Related Discussions:- Calculate five year moving averagetle..

Explain calculated values in descending order on the same, Create a procedu...

Create a procedure in VBA to do the following actions: -Create a linear series of numbers starting at 1 (e.g. 1, 2, 3,) -Display a Message Box asking if you'd like to calculate ano

Explain performance appraisals are they necessary, 1.What purpose do they s...

1.What purpose do they serve under a performance management system? 2.Performance appraisals are they necessary or not? 3.What to do if an performance appraisal is unsatisfac

Explain when managing organizational change, When managing organizational c...

When managing organizational change, which would be more effective in overcoming resistance to change: rational persuasion, leader-follower relationship, both, or something else

Describe how sharpen the saw is applied, Explain how "sharpen the saw" is a...

Explain how "sharpen the saw" is applied in the Toyota Production System Grading rubric (Highest quality answers will consider ALL of the following) Describe "sharpen the saw

Explain national cattlemens beef association advertises beef, When the Nati...

When the National Cattlemens Beef Association advertises Beef, Its Whats for Dinner, it is trying to stimulate _____ demand. selective primary derived generic second

Need of computer-integrated manufacturing, Q. What is need of computer-inte...

Q. What is need of computer-integrated manufacturing to manufacturing operations? Computer-integrated manufacturing (CIM) implies manufacturing supported through computers. The

Explain can you be innovative in a mature industry, 1. How much of an impac...

1. How much of an impact does "maturity" level of the industry or company have on strategy? 2. Can you be innovative in a mature industry? 3. Can you be conservative in an in

Explain teplitz decides to increase the weights for quantity, Charles Tepli...

Charles Teplitz's firm wishes to use factor rating to help select and outsourcing provider of logistics services. A) with weights 1-5(5 highest) and ratings 1-100 (100 highest), us

Define compare the effectiveness, Compare the effectiveness of 2 week, 4wee...

Compare the effectiveness of 2 week, 4week 6week. I just need the moving averages. For 2,4 and 6 weeks from managing operations across the supply chain book the question is startin

Explain how much should the father deposit, On the day his son was born, a ...

On the day his son was born, a father decided to establish a fund for his son's college education. The father wants the son to be able to withdraw $4000 from the fund on his 18th b

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd