# Arnold Palmer Case

1128 Words5 Pages
Arnold Palmer Hospital Case Study 1. The case study indicates that the approach to match capacity to demand utilized by Arnold Palmer Hospital must be approach (a), leading demand with an incremental expansion. The reason for this is that it is evident that Arnold Palmer Hospital is attempting to acquire capacity to stay ahead of demand, or in other words by leading capacity, on account of the fact that the opening of the new 11-store hospital building will increase yearly birthing capacity to 16,000, which is far above the estimated 13,600 births expected during 2007, as shown by Table S7.3. Furthermore, the fact that the hospital and Swanson in particular is choosing to follow a multi-stage approach in terms of the hospital’s…show more content…
That is to say, the population in the area may for example be aging and thus birth rates may fall, etc. Also, they need to look at the economic situation in the area as well. By that I mean looking at whether young couples/families are continuing to move into the area? Are there enough job opportunities in the area that will fuel growth of this demographic group? All this may affect population growth and subsequently birth rates. 3. Using Excel’s data analysis regression tool, the follow data was found by plugging in the years (coded from 1 through 13) in column A and the number of births in column B and then substituting column A for input X range and column B for input Y range: SUMMARY OUTPUT | | | | | | | | | | | | | | | | | | |Regression Statistics | | | | | | | | |Multiple R |0.984835305 | | | | | | | | |R Square |0.969900578 | | | | | | | | |Adjusted R Square |0.967164267 | | | | | | | | |Standard Error |473.2824687 | | | | | | | | |Observations |13 | | | | | | | | | | | | | | | | | | |ANOVA | | | | | | | | | | |df |SS |MS |F |Significance F | | | | |Regression |1 |79396723.52 |79396723.52 |354.455521 |1.02108E-09 | | | | |Residual |11 |2463959.247 |223996.2952 | | | | | | |Total |12 |81860682.77 | | | | | | | | | | | | | | | | | | |Coefficients |Standard Error |t Stat |P-value |Lower 95% |Upper 95% |Lower 95.0% |Upper 95.0% | |Intercept |4679.884615 |278.4549858 |16.80661096 |3.42384E-09 |4067.009324 |5292.759906 |4067.009324