The time from when a patient is discharged from North Shore Hospital to the time the discharged patient’s bed is ready to be assigned to a new patient is referred to as the bed assignment turnaround time. If the bed turnaround time is excessive, it can cause problems with patient flow and delay medical procedures throughout the hospital. This can cause long waiting times for physicians and patients thus creating customer dissatisfaction. The admissions RN has assigned a patient care associate to measure the bed turnaround time for a randomly selected bed each morning., afternoon, and evening for 30 days. Following are the bed turnaround time sample observations: Day Day Bed Turnaround Times (min) 1 1 127 135 167 144 151 2 2 140 155 122 135 119 3 3 112 128 97 118 131 4 4 223 135 154 187 150 5 5 181 155 160 172 166 6 6 103 158 145 124 149 7 7 146 135 167 150 178 8 8 104 122 115 137 129 9 9 136 158 137 148 156 10 10 145 163 106 139 170 11 11 84 146 125 98 112 12 12 169 152 208 200 178 13 13 216 124 163 172 168 14 14 190 178 103 169 145 15 15 148 205 144 167 152 16 16 157 151 126 144 167 17 17 142 102 95 122 99 18 18 166 178 159 161 139 19 19 177 211 204 189 208 20 20 98 91 158 128 92 21 21 133 160 152 143 115 22 22 212 131 138 167 138 23 23 180 165 134 186 145 24 24 88 126 108 92 89 25 25 95 156 138 126 113 26 26 156 202 177 187 201 27 27 144 157 165 144 156 28 28 184 171 106 172 176 29 29 138 142 155 156 162 30 30 150 99 148 102 108 Develop an X-chart to be used in conjunction with an R-chart using 3-sigma limit to monitor the bed turnaround time and indicate if the process is in control using these charts. Is the hospital capable of consistently achieving bed turnaround times of 180 minutes ± 20 minutes without improving the process? Show and explain the process

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

The time from when a patient is discharged from North Shore Hospital to the time the discharged patient’s bed is ready to be assigned to a new patient is referred to as the bed assignment turnaround time. If the bed turnaround time is excessive, it can cause problems with patient flow and delay medical procedures throughout the hospital. This can cause long waiting times for physicians and patients thus creating customer dissatisfaction. The admissions RN has assigned a patient care associate to measure the bed turnaround time for a randomly selected bed each morning., afternoon, and evening for 30 days. Following are the bed turnaround time sample observations:

Day	Day	Bed Turnaround Times (min)
1	1	127	135	167	144	151
2	2	140	155	122	135	119
3	3	112	128	97	118	131
4	4	223	135	154	187	150
5	5	181	155	160	172	166
6	6	103	158	145	124	149
7	7	146	135	167	150	178
8	8	104	122	115	137	129
9	9	136	158	137	148	156
10	10	145	163	106	139	170
11	11	84	146	125	98	112
12	12	169	152	208	200	178
13	13	216	124	163	172	168
14	14	190	178	103	169	145
15	15	148	205	144	167	152
16	16	157	151	126	144	167
17	17	142	102	95	122	99
18	18	166	178	159	161	139
19	19	177	211	204	189	208
20	20	98	91	158	128	92
21	21	133	160	152	143	115
22	22	212	131	138	167	138
23	23	180	165	134	186	145
24	24	88	126	108	92	89
25	25	95	156	138	126	113
26	26	156	202	177	187	201
27	27	144	157	165	144	156
28	28	184	171	106	172	176
29	29	138	142	155	156	162
30	30	150	99	148	102	108

Develop an X-chart to be used in conjunction with an R-chart using 3-sigma limit to monitor the bed turnaround time and indicate if the process is in control using these charts.
Is the hospital capable of consistently achieving bed turnaround times of 180 minutes ± 20 minutes without improving the process?
Show and explain the process

Expert Solution