Calculate a 5-year weighted moving average to forecast

Assignment Help Operation Management

Reference no: EM132082113

Question : 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.

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? Your initial post should be 200-250 words.

Reference no: EM132082113

Questions Cloud

Why time series research designs are important : Imagine you have a client whom you think would benefit from participating in a time series study. Provide a brief description of the study you would conduct.

How does a lessee determine whether specific lease contract : Question - Operating and Capital Leases - How does a lessee determine whether a specific lease contract is an operating lease or a capital lease

What discount should they offer in order make the terms : Assuming an average cost of capital of 15%, what discount should they offer in order make the terms float neutral?

Discuss the internal environmental impacts : Imagine you are a health care manager of a facility that will be moving into a new facility that is being renovated. You and your team have been asked to manage

Calculate a 5-year weighted moving average to forecast : Calculate a 5-year weighted moving average to forecast the number of mergers for 2012. Use regression analysis to forecast the number of mergers in 2012.

What can be the limitations of critical path scheduling : What can be the limitations of critical path scheduling? list four examples of a server’s citizenship behavior and four examples of counterproductive behavior.

What is the balance in the capital account : The remainder is divided 20% to C, 35% to E, and 45% to E. What is the balance in the capital account at the end of the year if net income was $80,000

How much was lantz operating income : Cash collections from customers for services yet to be provided totaled $88,000. How much was Lantz operating income

Emergency management disciplines : How does the function of mitigation differ from the other 3 emergency management disciplines?

User Account

All Pages