A large health maintenance organization (HMO) was created as a result of a corporate merger two years ago. To help in preparing a staffing plan, the operations manager needs to develop a forecast for the Number of Lawsuits for Month 25. Following is the Number of Lawsuits for the past 24 months.

Month	Number of Lawsuits	Month	Number of Lawsuits	Month	Number of Lawsuits
1	16	9	51	17	63
2	25	10	56	18	57
3	16	11	67	19	48
4	24	12	45	20	55
5	38	13	53	21	61
6	46	14	61	22	51
7	54	15	55	23	56
8	52	16	69	24	53

   

Calculate your forecast results to one (1) decimal place (xx.x).

a) Make a forecast for the Number of Lawsuits for Month 25 using the moving average, weighted moving average and exponential smoothing forecasting methods on the following basis:

For the moving average, use a four-period moving average

For the weighted moving average, use a three-period weighted moving average with a weight of 0.70 for the most recent period, 0.20 for the next most recent period and the appropriate weight for the third most recent period.

For exponential smoothing, using an σ = 0.30, and the forecast for the Number of Lawsuits for Month 16 is 70.

b)From the results of a), which method provides the better forecast for Month 25? Why? Your selection criteria must be based on one of the numerical evaluation methods we used in our related homework problem using the forecast results for Month 20 through Month 24. Only saying “it is the easier method” is not acceptable.

Answer rating: 100% (QA)

Month Number of Lawsuits Moving Average 4 points Moving average weighted Exponential smoothing MAD A... View the full answer