Case 3.1. Customer Arrivals at Bank98 Bank98 operates a main location and three branch locations in a medium-size city. All four locations perform similar services, and customers typically do business at the location nearest them. The bank has recently had more congestion-longer waiting lines-than it (or its customers) 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 one-hour intervals for the past 10 weeks. All branches are open Monday through Friday from 9 AM until 5 P.M and on Saturday from 9 A.M until noon. For each location, the file C03_01.xlsx contains the number of customer arrivals during each hour of a 10-week period. The manager of Bank98 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 bank 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 bank 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. x Jx A B C D E F 1 Day Hour Main Branch1 Branch2 Branch3 2 Mon 9 to 10 29 20 20 18 3 Mon 10 to 11 26 13 13 12 4 Mon 11 to noon 57 28 26 29 5 Mon Noon to 1 68 30 31 41 6 Mon 1 to 2 60 18 35 15 7 Mon 2 to 3 35 23 14 22 8 Mon 3 to 4. 23 121 11 4 9 Mon 4 to 5 69 32 37 30 10. Tue 9 to 10 35 14 13 15 11 Tue 10 to 11 22 9 11 10 12 Tue 11 to noon 50 30 38 34 13 Tue Noon to 1 82 22 39 34 14 Tue 1 to 2 52 28 24 18 15 Tue 2 to 3 36 19 14 20 16 Tue 3 to 4 20 15 17 11 17 Tue 4 to 5 69 25 37 23 18 Wed 9 to 10 31 13 19 15 19 Wed 10 to 11 22 10 13 15 20 Wed 11 to noon 71 20 30 27 21 Wed Noon to 1 70 35 36 29 22 Wed 1 to 2 36 26 26 24 23 Wed 2 to 3 27 15 17 23 24 Wed 3 to 4 19 11 10 14 25 Wed 4 to 5 77 26 33 29 26 Thu 9 to 10 36 11 16 13 27 Thu 10 to 11 25 17 11 12 28 Thu 11 to noon 52 30 30 21 29 Thu Noon to 1 67 41 43 44 30 Thu 1 to 2 49 22 17 24 31 Thu 2 to 3 39 14 17 18 32 Thu 3 to 4. 23 13 15 12 33 Thu 4 to 5 65 20 32 35 34 Fri 9 to 10 45 41 30 27 35 Fri 10 to 11 44 25 22 19 36 Fri 11 to noon 94 66 48 47 37 Fri Noon to 1 129 64 61 71 38 Fri 1 to 2 85 37 42 44 39 Fri 2 to 3 57 35 29 30 40 Fri 3 to 4 43 33 30 17 41 Fri 4 to 5 110 56 59 48 42 Sat 9 to 10 86 38 30 32 43 Sat 10 to 11 47 27 30 27 44 Sat 11 to noon 135 76 79 71 Data + Ready Accessibility: Investigate Paste BI J11 fx A B C D E F 44 Sat 11 to noon 135 76 79 71 45 Mon 9 to 10 38 16 24 19 46 Mon 10 to 11 22 17 16 13 47 Mon 11 to noon 62 25 36 19 48 Mon Noon to 1 96 37 41 35 49 Mon 1 to 2 41 33 26 21 50 Mon 2 to 3 35 15 23 19 51 Mon 3 to 4 22 15 7 22 52 Mon 4 to 5 79 45 29 28 53 Tue 9 to 10 26 20 20 15 54 Tue 10 to 11 18 15 12 9 55 Tue 11 to noon 56 25 25 33 56 Tue Noon to 1 61 36 29 33 57 Tue 1 to 2 45 22 25 23 58 Tue 2 to 3 37 13 19 17 59 Tue 3 to 4 34 7 15 16 60 Tue 4 to 5 74 28 29 52 61 Wed 9 to 10 34 17 16 16 62 Wed 10 to 11 19 12 19 7 63 Wed 11 to noon 48 31 22 17 64 Wed Noon to 1 70 46 43 22 65 Wed 1 to 2 44 25 23 20 66 Wed 2 to 3 32 21 9 22 67 Wed 3 to 4 21 13 17 9 68 Wed 4 to 5 58 32 36 30 69 Thu 9 to 10 26 12 19 18 70 Thu 10 to 11 26 9 10 9 71 Thu 11 to noon 64 28 27 38 72 Thu Noon to 1 58 44 44 39 73 Thu 1 to 2 50 17 23 23 74 Thu 2 to 3 30 19 18 27 75 Thu 3 to 4 27 5 12 13 76 Thu 4 to 5 69 48 33 35 77 Fri 9 to 10 53 34 29 30 78 Fri 10 to 11 32 15 20 22 79 Fri 11 to noon 96 53 80 Fri Noon to 1 108 73 81 Fri 1 to 2 88 37 235 51 60 63 45 48 82 Fri 2 to 3 56 30 27 31 83 Fri 3 to 4 33 25 27 20 84 Fri 4 to 5 83 74 57 62 85 Sat 9 to 10 83 39 40 39 86 Sat 10 to 11 41 32 20 37 87 Sat 11 to noon 123 70 76 74 Data + Ready Accessibility; Investigate G