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

Reviews

Write a Review

 

Operation Management Questions & Answers

  Explain impact of globalization also information technology

Compare also contrast three different types of entrepreneurs also state which you are most likely to emulate should you begin a small business. Assess impact of globalization also information technology on creation of small businesses.

  You and your fellow operations department teammates have

write 400-600 words that respond to the following with your thoughts ideas and comments. be substantive and clear and

  Why does effective management diversity make good business

why dose the effective management of diversity make good business senes ?

  Evaluate how these challenges impact the traditional

Review the unique challenges companies face in new product development. Evaluate how these challenges impact the traditional new product process

  Which vehicles received the highest ratings

Which vehicles received the highest ratings? The lowest ratings?

  Discuss the techniques these companies are applying

Research several issues of business magazines such as Fortune, Business Week, Fast Organization, etc. also find examples of two companies that are using approaches to busting bureaucracy. Discuss the techniques these companies are applying.

  Determine the expected number of entrants in the system

On the average, an entrant arrives at his station once every six minutes. Assume a single server waiting line system and determine the expected number of entrants in the system.

  Effect of operating characteristi on managerial decesion

For the scenario in the attachment, use the queuing formulas to calculate the averages under present conditions and the alternatives. using the information given, determine the alternative you would select. List your assumptions and/or additional inf..

  Ms abc ltd is a medium-sized engineering company producing

ms. abc ltd is a medium-sized engineering company producing a large-range of product lines according to customer

  What is the implied cost of shortage

what is the implied cost of shortage, given the actual order size? What might be a reason for this difference in shortage costs? ($2.39)

  Elucidate what is the probability of normal distribution

Elucidate what is the probability which a random number from the triangular distribution is less than 400. Elucidate what is this probability for the normal distribution.

  What are the two external dimensions of the space matrix

What are the two external dimensions of the SPACE Matrix?

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