Calculate a 5-year moving average to forecast the mergers

Assignment Help Operation Management

Reference no: EM13738560

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?

1) 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

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

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

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.

Use regression analysis to forecast the number of mergers in 2012.

Reference no: EM13738560

Questions Cloud

Information security and ethical concerns : Submit a 400 word section of the paper with the following:

Explain facts about writing being connected to government : Explain facts about writing being connected to government in ancient Mesopotamia.

What is legally necessary to file in order to form business : Provide a 100- to 200-word summary in which you provide an example business that you would start for each form. What is legally necessary to file in order to form that business

Measuring efficiency of human assets : Question 1: Find a metric proposed or used by a company for measuring efficiency of human assets (cite your resources per APA guidelines).

Calculate a 5-year moving average to forecast the mergers : 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 j..

Explain the significance of world view chart : Describe the selected content and explain the significance of the selected category across the religions studied. Provide one specific example of how the selected category is manifested in your social environment.

Resolving ethical business challenges : Read "Resolving Ethical Business Challenges", and then address the following points. Support your response with evidence from the text.

Explain how the laws of supply and demand are illustrated : Explain how the Laws of Supply and Demand are illustrated in this graph and describe the equilibrium price and quantity in this market.

Key advantages of equity financing : Determine at least two (2) key advantages of equity financing compared to debt financing options. Provide a rationale for your response

User Account

All Pages