A large health maintenance organization (HMO) was created as a result of a corpo
ID: 3351776 • Letter: A
Question
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.
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
Explanation / Answer
b)
Moving average is best as MSE for moving is least (76.3125)
Month Number of Lawsuits MA weighted exponential 1 16 2 25 3 16 4 24 17.8 5 38 20.25 22.5 6 46 25.75 33 7 54 31 42.2 8 52 40.5 50.8 9 51 47.5 51.8 10 56 50.75 51.5 11 67 53.25 54.6 12 45 56.5 63.2 13 53 54.75 50.5 14 61 55.25 52.8 15 55 56.5 57.8 16 69 53.5 56 17 63 59.5 65.4 70 18 57 62 63.4 67.9 19 48 61 59.4 64.63 20 55 59.25 51.3 59.641 21 61 55.75 53.8 58.2487 22 51 55.25 58.5 59.07409 23 56 53.75 53.4 56.651863 24 53 55.75 55.5 56.4563041 25 55.25 53.4 55.41941287Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.