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,
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.
Step by Step Solution
3.32 Rating (146 Votes )
There are 3 Steps involved in it
Step: 1
Month Number of Lawsuits Moving Average 4 points Moving average weighted Exponential smoothing MAD A...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started