(solution) Part1 Data for a control chart number of medically complicated

(solution) Part1 Data for a control chart number of medically complicated

Kindly answer the attached question with explanation.

Part1
Data for a control chart number of medically complicated births, Durham Hospital
Using the following data, prepare a control chart. A late surgery is defined as any surgical operation that was started more than 30 minutes after its schedule time.
Month
January
February
March
April Number of Medically Complicated Births
19
27
20
16 May
June
July
August
September
October
November
December
Total
Means 18
25
22
24
17
25
15
17
245
20.4 Part 2
Community
North
South
East
West
Central
Uper
Lower Hospital A
45
159
65
145
32
29
37 Hospital B
64
324
24
68
56
84
14 Hospital
76
12
137
95
78
45
8 Other Hospitals
123
521
311
113
159
814
57 1. Using the following data set on hospital admission, define the service area for Hospital A based on only quantitative factor.
2. Compute the target bed capacity of Cheswick community hospital 10 years from now,
based on the following information:
a) Assume current population of Cheswick community hospital service area = 145,000 b) Assume projected population increase of 8% in service area the next 10 years
c) Assume a future admission rate per 1000 of 102
d) Assume average length of stay of 4.7 days in 10 years
e) assume a target occupancy rate of 78% in 10 years
3. Newgroveton is a community of 445,000. In the most recent years, there were 750 new cases of disease A in the community. Assume the expected incidence rate for disease A is 245 per 100,000 people. Was the community's experience better or worse than expected? Explain why.