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 supply chain excellence, Discuss the four enablers of purchasing an...

Discuss the four enablers of purchasing and supply chain excellence.

Give a specific definition of time study, Give a specific definition of tim...

Give a specific definition of time study. Time study It is defined as a work measurement technique for recording the times and rate of working for the component of a speci

I have some charts that i need help to put it in excel, I have soem charts ...

I have soem charts that were done i word how do I gt them to you for someone to put in excel for me

Explain design-oriented hazards, A comprehensive safety assessment report c...

A comprehensive safety assessment report contains both testing and hazard analysis. What types of safety testing would be performed on commercial aircraft to identify any design-o

Explain bp''s first problem, Describe BP'S first problem, which involved th...

Describe BP'S first problem, which involved the firms IT function. Discuss BP'S solution to this problem.

Explain ability to pay, What are three considerations in the wage determina...

What are three considerations in the wage determination criterion "ability to pay"? Why, by itself, can't the ratio of labour cost to total cost always be the formula of a company'

Explain what is the role of information systems, What is the Role of Inform...

What is the Role of Information Systems in the Learning Organization?

How to use approximation formulas for your calculation, The Northern Emerge...

The Northern Emergency Computer Support has a call center with 10 customer service representatives. Historical statistics show that the durations of customer calls are exponentiall

Describe the steps accuracy of the information, Rate, from the best to the ...

Rate, from the best to the worst, each of the sources you indicated in #1 above as being sources you will use in your analysis in terms of its probable reliability. Discuss the ste

Describe methods to diagnose employee stress, Discuss methods to diagnose e...

Discuss methods to diagnose employee stress and the specific OD (organizational development practitioner) interventions aimed at alleviating it in the workplace.

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