Fluent Essays

Assignment: Covenant Hospital Clinic Staffing Covenant Hospital operates a main hospital and three outlying clinics in a medium-size city. All four locations perform similar outpatient services, and patients typically visit the location nearest them. The hospital has recently had more congestion—longer waiting lines—than it (or its patients) would like. As part of a study to learn the causes of these long lines and to suggest possible solutions, all locations have kept track of customer arrivals during 1-hour intervals for the past 10 weeks. All locations are open Monday through Friday from 9 a.m. until 5 p.m. and on Saturday from 9 a.m. until noon. For each location, the hospital and clinics collected data that contains the number of customer arrivals during each hour of a 10-week period. The manager of Covenant has hired you to make some sense of these data. Specifically, your task is to present charts and/or tables that indicate how customer traffic into the hospital locations varies by day of week and hour of day. There is also interest in whether any daily or hourly patterns you observe are stable across weeks. Although you don't have full information about the way the hospital currently runs its operations—you know only its customer arrival pattern and the fact that it is currently experiencing long lines—you are encouraged to append any suggestions for improving operations based on your analysis of the data. For this Assignment, download and review the Covenant Hospital data file in this week's resources (attached). Reflect on what analyses might be required to address the manager's request. The Assignment: (5 pages) · Submit your answers and embedded Excel analysis as a Microsoft Word management report. · Be sure to adhere to APA format when generating your management report. Source This is fictitious data. Data Day Hour Clinic 1 Clinic 2 Clinic 3 Clinic 4 Mon 9 to 10 29 20 20 18 Mon 10 to 11 26 13 13 12 Mon 11 to noon 57 28 26 29 Mon Noon to 1 68 30 31 41 Mon 1 to 2 60 18 35 15 Mon 2 to 3 35 23 14 22 Mon 3 to 4 23 12 11 4 Mon 4 to 5 69 32 37 30 Tue 9 to 10 35 14 13 15 Tue 10 to 11 22 9 11 10 Tue 11 to noon 50 30 38 34 Tue Noon to 1 82 22 39 34 Tue 1 to 2 52 28 24 18 Tue 2 to 3 36 19 14 20 Tue 3 to 4 20 15 17 11 Tue 4 to 5 69 25 37 23 Wed 9 to 10 31 13 19 15 Wed 10 to 11 22 10 13 15 Wed 11 to noon 71 20 30 27 Wed Noon to 1 70 35 36 29 Wed 1 to 2 36 26 26 24 Wed 2 to 3 27 15 17 23 Wed 3 to 4 19 11 10 14 Wed 4 to 5 77 26 33 29 Thu 9 to 10 36 11 16 13 Thu 10 to 11 25 17 11 12 Thu 11 to noon 52 30 30 21 Thu Noon to 1 67 41 43 44 Thu 1 to 2 49 22 17 24 Thu 2 to 3 39 14 17 18 Thu 3 to 4 23 13 15 12 Thu 4 to 5 65 20 32 35 Fri 9 to 10 45 41 30 27 Fri 10 to 11 44 25 22 19 Fri 11 to noon 94 66 48 47 Fri Noon to 1 129 64 61 71 Fri 1 to 2 85 37 42 44 Fri 2 to 3 57 35 29 30 Fri 3 to 4 43 33 30 17 Fri 4 to 5 110 56 59 48 Sat 9 to 10 86 38 30 32 Sat 10 to 11 47 27 30 27 Sat 11 to noon 135 76 79 71 Mon 9 to 10 38 16 24 19 Mon 10 to 11 22 17 16 13 Mon 11 to noon 62 25 36 19 Mon Noon to 1 96 37 41 35 Mon 1 to 2 41 33 26 21 Mon 2 to 3 35 15 23 19 Mon 3 to 4 22 15 7 12 Mon 4 to 5 79 45 29 28 Tue 9 to 10 26 20 20 15 Tue 10 to 11 18 15 12 9 Tue 11 to noon 56 25 25 33 Tue Noon to 1 61 36 29 33 Tue 1 to 2 45 22 25 23 Tue 2 to 3 37 13 19 17 Tue 3 to 4 34 7 15 16 Tue 4 to 5 74 28 29 52 Wed 9 to 10 34 17 16 16 Wed 10 to 11 19 12 19 7 Wed 11 to noon 48 31 22 17 Wed Noon to 1 70 46 43 22 Wed 1 to 2 44 25 23 20 Wed 2 to 3 32 21 9 22 Wed 3 to 4 21 13 17 9 Wed 4 to 5 58 32 36 30 Thu 9 to 10 26 12 19 18 Thu 10 to 11 26 9 10 9 Thu 11 to noon 64 28 27 38 Thu Noon to 1 58 44 44 39 Thu 1 to 2 50 17 23 23 Thu 2 to 3 30 19 18 27 Thu 3 to 4 27 5 12 13 Thu 4 to 5 69 48 33 35 Fri 9 to 10 53 34 29 30 Fri 10 to 11 32 15 20 22 Fri 11 to noon 96 53 52 51 Fri Noon to 1 108 73 60 63 Fri 1 to 2 88 37 45 48 Fri 2 to 3 56 30 27 31 Fri 3 to 4 33 25 27 20 Fri 4 to 5 83 74 57 62 Sat 9 to 10 83 39 40 39 Sat 10 to 11 41 32 20 37 Sat 11 to noon 123 70 76 74 Mon 9 to 10 39 12 11 20 Mon 10 to 11 22 6 11 12 Mon 11 to noon 57 20 32 31 Mon Noon to 1 60 40 32 39 Mon 1 to 2 47 31 26 16 Mon 2 to 3 22 20 17 18 Mon 3 to 4 25 12 20 6 Mon 4 to 5 70 30 42 33 Tue 9 to 10 35 22 17 13 Tue 10 to 11 13 15 14 16 Tue 11 to noon 51 28 26 20 Tue Noon to 1 74 30 36 33 Tue 1 to 2 52 26 28 27 Tue 2 to 3 38 21 13 17 Tue 3 to 4 28 16 7 10 Tue 4 to 5 60 32 22 25 Wed 9 to 10 41 15 23 21 Wed 10 to 11 26 10 10 12 Wed 11 to noon 64 32 23 35 Wed Noon to 1 84 33 34 41 Wed 1 to 2 62 25 26 28 Wed 2 to 3 29 25 14 16 Wed 3 to 4 22 6 13 12 Wed 4 to 5 61 37 37 29 Thu 9 to 10 41 12 12 15 Thu 10 to 11 24 10 14 14 Thu 11 to noon 51 20 27 35 Thu Noon to 1 62 34 30 27 Thu 1 to 2 60 29 16 30 Thu 2 to 3 30 21 17 21 Thu 3 to 4 28 11 12 9 Thu 4 to 5 57 27 27 29 Fri 9 to 10 53 38 42 30 Fri 10 to 11 35 18 21 26 Fri 11 to noon 105 47 49 51 Fri Noon to 1 125 68 46 69 Fri 1 to 2 80 51 42 39 Fri 2 to 3 46 27 34 27 Fri 3 to 4 42 23 26 27 Fri 4 to 5 109 59 47 54 Sat 9 to 10 75 45 36 37 Sat 10 to 11 56 29 24 31 Sat 11 to noon 138 61 64 73 Mon 9 to 10 26 17 9 13 Mon 10 to 11 21 14 3 15 Mon 11 to noon 56 28 31 26 Mon Noon to 1 64 41 38 32 Mon 1 to 2 50 25 29 21 Mon 2 to 3 30 16 13 16 Mon 3 to 4 19 8 9 15 Mon 4 to 5 63 28 30 23 Tue 9 to 10 30 8 24 15 Tue 10 to 11 18 14 13 19 Tue 11 to noon 64 32 22 36 Tue Noon to 1 82 48 30 35 Tue 1 to 2 50 21 22 22 Tue 2 to 3 39 14 14 20 Tue 3 to 4 25 16 9 11 Tue 4 to 5 66 46 27 39 Wed 9 to 10 40 17 17 18 Wed 10 to 11 23 12 12 5 Wed 11 to noon 65 32 31 41 Wed Noon to 1 70 32 33 31 Wed 1 to 2 51 18 21 28 Wed 2 to 3 26 21 8 21 Wed 3 to 4 28 12 9 10 Wed 4 to 5 78 36 33 33 Thu 9 to 10 34 17 16 22 Thu 10 to 11 24 12 13 8 Thu 11 to noon 55 28 31 33 Thu Noon to 1 78 28 24 32 Thu 1 to 2 48 25 23 17 Thu 2 to 3 27 19 14 16 Thu 3 to 4 25 9 16 7 Thu 4 to 5 60 36 32 34 Fri 9 to 10 52 21 26 32 Fri 10 to 11 42 23 24 31 Fri 11 to noon 105 42 39 66 Fri Noon to 1 126 53 70 50 Fri 1 to 2 75 59 61 49 Fri 2 to 3 69 34 27 29 Fri 3 to 4 39 22 20 24 Fri 4 to 5 117 49 56 47 Sat 9 to 10 72 46 39 45 Sat 10 to 11 54 38 30 33 Sat 11 to noon 131 66 66 70 Mon 9 to 10 42 18 18 17 Mon 10 to 11 27 11 18 12 Mon 11 to noon 61 25 31 29 Mon Noon to 1 71 26 42 36 Mon 1 to 2 59 23 28 26 Mon 2 to 3 37 18 21 11 Mon 3 to 4 19 17 13 16 Mon 4 to 5 69 36 39 37 Tue 9 to 10 25 17 13 24 Tue 10 to 11 27 10 14 11 Tue 11 to noon 56 29 34 31 Tue Noon to 1 76 41 36 41 Tue 1 to 2 63 27 21 22 Tue 2 to 3 35 12 9 20 Tue 3 to 4 21 10 9 6 Tue 4 to 5 78 31 34 40 Wed 9 to 10 30 9 15 10 Wed 10 to 11 20 14 12 11 Wed 11 to noon 66 30 30 45 Wed Noon to 1 77 35 36 37 Wed 1 to 2 51 25 27 22 Wed 2 to 3 33 14 20 17 Wed 3 to 4 23 11 11 8 Wed 4 to 5 65 27 32 32 Thu 9 to 10 25 13 17 20 Thu 10 to 11 26 17 12 12 Thu 11 to noon 56 30 29 19 Thu Noon to 1 70 38 40 37 Thu 1 to 2 54 27 24 30 Thu 2 to 3 28 25 16 18 Thu 3 to 4 28 11 14 13 Thu 4 to 5 56 31 28 30 Fri 9 to 10 57 35 29 24 Fri 10 to 11 46 23 16 23 Fri 11 to noon 107 49 51 45 Fri Noon to 1 120 55 67 56 Fri 1 to 2 80 43 50 47 Fri 2 to 3 55 29 18 29 Fri 3 to 4 44 17 15 18 Fri 4 to 5 123 54 64 66 Sat 9 to 10 93 37 47 32 Sat 10 to 11 67 33 22 22 Sat 11 to noon 125 67 77 74 Mon 9 to 10 43 19 14 18 Mon 10 to 11 24 13 19 19 Mon 11 to noon 54 28 22 37 Mon Noon to 1 73 37 36 32 Mon 1 to 2 39 21 21 25 Mon 2 to 3 44 15 20 10 Mon 3 to 4 29 7 11 7 Mon 4 to 5 69 35 41 30 Tue 9 to 10 27 16 18 16 Tue 10 to 11 20 10 14 8 Tue 11 to noon 55 30 26 20 Tue Noon to 1 77 32 49 43 Tue 1 to 2 53 25 19 18 Tue 2 to 3 37 17 8 8 Tue 3 to 4 31 14 14 13 Tue 4 to 5 61 29 24 25 Wed 9 to 10 26 15 15 16 Wed 10 to 11 28 9 13 8 Wed 11 to noon 55 44 23 38 Wed Noon to 1 66 34 40 49 Wed 1 to 2 46 17 23 26 Wed 2 to 3 29 18 23 24 Wed 3 to 4 26 14 12 8 Wed 4 to 5 59 34 34 37 Thu 9 to 10 29 21 14 16 Thu 10 to 11 22 8 10 14 Thu 11 to noon 59 32 27 23 Thu Noon to 1 58 49 32 42 Thu 1 to 2 34 24 25 30 Thu 2 to 3 19 17 18 12 Thu 3 to 4 22 8 12 15 Thu 4 to 5 78 26 31 36 Fri 9 to 10 60 26 27 32 Fri 10 to 11 40 24 23 25 Fri 11 to noon 90 46 43 54 Fri Noon to 1 102 64 70 62 Fri 1 to 2 88 37 25 31 Fri 2 to 3 54 31 39 26 Fri 3 to 4 43 27 20 16 Fri 4 to 5 114 69 62 46 Sat 9 to 10 79 43 40 37 Sat 10 to 11 48 30 29 17 Sat 11 to noon 134 87 59 56 Mon 9 to 10 32 23 13 13 Mon 10 to 11 22 12 10 13 Mon 11 to noon 66 27 22 32 Mon Noon to 1 75 38 39 47 Mon 1 to 2 47 27 30 25 Mon 2 to 3 22 11 23 23 Mon 3 to 4 21 9 11 17 Mon 4 to 5 50 37 27 30 Tue 9 to 10 34 21 15 17 Tue 10 to 11 21 12 11 12 Tue 11 to noon 48 28 30 28 Tue Noon to 1 82 39 55 30 Tue 1 to 2 33 24 30 27 Tue 2 to 3 31 13 8 16 Tue 3 to 4 24 13 15 9 Tue 4 to 5 66 39 36 37 Wed 9 to 10 37 13 15 12 Wed 10 to 11 26 6 21 12 Wed 11 to noon 78 27 31 33 Wed Noon to 1 91 39 39 24 Wed 1 to 2 55 15 39 24 Wed 2 to 3 31 19 14 16 Wed 3 to 4 18 13 9 10 Wed 4 to 5 78 34 30 38 Thu 9 to 10 41 14 18 16 Thu 10 to 11 24 5 14 19 Thu 11 to noon 54 27 39 27 Thu Noon to 1 69 47 38 32 Thu 1 to 2 58 30 22 25 Thu 2 to 3 32 19 25 15 Thu 3 to 4 24 11 10 15 Thu 4 to 5 85 29 32 38 Fri 9 to 10 58 26 24 33 Fri 10 to 11 40 17 16 11 Fri 11 to noon 121 52 44 37 Fri Noon to 1 124 65 71 66 Fri 1 to 2 72 46 43 50 Fri 2 to 3 59 26 27 37 Fri 3 to 4 38 20 23 18 Fri 4 to 5 118 50 71 54 Sat 9 to 10 84 49 35 38 Sat 10 to 11 65 27 25 29 Sat 11 to noon 128 70 68 67 Mon 9 to 10 22 17 20 24 Mon 10 to 11 21 11 9 20 Mon 11 to noon 53 32 22 33 Mon Noon to 1 70 44 37 24 Mon 1 to 2 43 21 17 19 Mon 2 to 3 23 21 19 14 Mon 3 to 4 17 10 8 13 Mon 4 to 5 62 40 40 40 Tue 9 to 10 32 22 19 8 Tue 10 to 11 25 11 15 17 Tue 11 to noon 61 35 33 28 Tue Noon to 1 87 41 42 38 Tue 1 to 2 49 20 20 21 Tue 2 to 3 33 16 13 20 Tue 3 to 4 31 20 13 13 Tue 4 to 5 80 32 34 37 Wed 9 to 10 33 17 9 17 Wed 10 to 11 24 14 9 12 Wed 11 to noon 71 34 39 27 Wed Noon to 1 70 36 30 35 Wed 1 to 2 48 23 23 29 Wed 2 to 3 37 17 15 25 Wed 3 to 4 26 18 14 9 Wed 4 to 5 54 30 39 30 Thu 9 to 10 26 17 18 14 Thu 10 to 11 27 9 7 13 Thu 11 to noon 57 32 28 18 Thu Noon to 1 82 23 38 38 Thu 1 to 2 49 25 22 17 Thu 2 to 3 22 17 17 11 Thu 3 to 4 17 13 17 10 Thu 4 to 5 61 41 31 39 Fri 9 to 10 50 27 31 32 Fri 10 to 11 35 22 20 18 Fri 11 to noon 117 62 51 47 Fri Noon to 1 135 63 68 65 Fri 1 to 2 73 50 27 50 Fri 2 to 3 52 30 24 29 Fri 3 to 4 33 23 27 28 Fri 4 to 5 110 56 65 50 Sat 9 to 10 77 32 43 43 Sat 10 to 11 59 39 27 30 Sat 11 to noon 141 62 72 68 Mon 9 to 10 37 15 20 18 Mon 10 to 11 19 17 11 12 Mon 11 to noon 53 22 24 37 Mon Noon to 1 63 48 42 41 Mon 1 to 2 48 24 20 28 Mon 2 to 3 36 17 19 18 Mon 3 to 4 28 9 11 6 Mon 4 to 5 70 32 39 39 Tue 9 to 10 42 15 18 12 Tue 10 to 11 23 20 14 10 Tue 11 to noon 65 23 32 29 Tue Noon to 1 71 43 39 43 Tue 1 to 2 43 27 22 27 Tue 2 to 3 35 16 23 21 Tue 3 to 4 20 13 12 19 Tue 4 to 5 52 30 32 25 Wed 9 to 10 22 19 13 13 Wed 10 to 11 15 8 10 8 Wed 11 to noon 61 34 36 29 Wed Noon to 1 67 28 38 31 Wed 1 to 2 38 24 36 21 Wed 2 to 3 36 9 23 16 Wed 3 to 4 22 5 10 9 Wed 4 to 5 68 47 36 28 Thu 9 to 10 29 20 16 15 Thu 10 to 11 20 11 7 15 Thu 11 to noon 52 24 22 23 Thu Noon to 1 46 44 49 44 Thu 1 to 2 57 24 21 30 Thu 2 to 3 25 11 16 13 Thu 3 to 4 29 17 12 14 Thu 4 to 5 64 29 34 29 Fri 9 to 10 60 36 38 31 Fri 10 to 11 33 17 25 25 Fri 11 to noon 110 43 46 62 Fri Noon to 1 139 71 49 45 Fri 1 to 2 75 37 57 45 Fri 2 to 3 61 32 32 29 Fri 3 to 4 30 18 20 14 Fri 4 to 5 95 48 52 50 Sat 9 to 10 85 47 52 40 Sat 10 to 11 65 32 28 30 Sat 11 to noon 140 68 61 67 Mon 9 to 10 33 13 10 21 Mon 10 to 11 16 9 5 12 Mon 11 to noon 65 28 26 34 Mon Noon to 1 75 30 28 35 Mon 1 to 2 50 27 27 13 Mon 2 to 3 30 17 20 17 Mon 3 to 4 30 14 13 9 Mon 4 to 5 70 30 32 47 Tue 9 to 10 25 18 22 13 Tue 10 to 11 21 17 11 16 Tue 11 to noon 56 29 34 36 Tue Noon to 1 71 28 45 33 Tue 1 to 2 37 23 14 25 Tue 2 to 3 39 17 16 11 Tue 3 to 4 24 11 12 15 Tue 4 to 5 60 32 33 29 Wed 9 to 10 24 14 24 16 Wed 10 to 11 24 12 13 14 Wed 11 to noon 58 37 31 20 Wed Noon to 1 71 31 36 35 Wed 1 to 2 48 21 22 35 Wed 2 to 3 31 14 16 25 Wed 3 to 4 26 13 11 8 Wed 4 to 5 57 26 41 41 Thu 9 to 10 28 13 16 7 Thu 10 to 11 20 14 11 8 Thu 11 to noon 48 25 29 31 Thu Noon to 1 80 37 40 36 Thu 1 to 2 46 13 17 22 Thu 2 to 3 32 16 18 15 Thu 3 to 4 22 13 9 8 Thu 4 to 5 63 27 37 38 Fri 9 to 10 59 28 19 22 Fri 10 to 11 53 12 19 23 Fri 11 to noon 102 48 44 50 Fri Noon to 1 126 53 60 60 Fri 1 to 2 76 50 39 40 Fri 2 to 3 59 29 29 19 Fri 3 to 4 27 21 17 27 Fri 4 to 5 91 64 59 68 Sat 9 to 10 87 27 38 50 Sat 10 to 11 59 26 34 39 Sat 11 to noon 158 73 68 64 These show the number of patient arrivals for consecutive hourly periods.