ABC DO : sin577_course-project_Melissa Cassidy Q sign Layout References Mailings Review View 12 A- A A a ME E Aa e X2 X2 A . A S IV.VV-1 1.VV 11:00-12:00 18 12:00-13:00 18 13:00-14:00 18 14:00-15:00 17 15:00-16:00 18 16:00-17:00 18 17:00-18:00 18 18:00-19:00 18 d. The standard deviation for the service time. Use the data points in the time blocks that correspond to the peak hours. 9-10am = SD 3.59 4-5pm = SD 1.26 2. Use that information to determine: The average arrival rate (customers/hour) 9-10am average arrival rate= 12 patients an hour or 1 patient every 5minutes 4-5pm average arrival rate= 12 patients an hour or 1 patient every 5 etinutes b. The service rate per server (customers/hour) 9-10am it takes 18 minutes to treat 1 patient 1/18 4-5pm It takes 18 minutes to treat 1 patient. 1/18Option 2 If you are using data from the "RedPharm" scenario, complete this section. 1. From the RedPharm data, determine: The average number of customer arrivals for each hour Time Block Average per Time Block 7:00-8:00 12 8:00-9:00 12 9:00-10:00 12 10:00-11:00 11:00-12:00 6 12:00-13:00 6 13:00-14:00 5 14:00-15:00 5 15:00-16:00 5 16:00-17:00 12 17:00-18:00 12 18:00-19:00 12 b. The peak time block in the morning and the peak time block in the afternoon Peak hours 9-10am, and 4-5pm ds X English (United States) FocusProcess For RedPharm, a pharmacy located in a college campus, fall is the busy flu-shot season. The manager of the pharmacy wants to improve the customer experience because there have been a lot of complaints about the waiting time. The RedPharm suggestion box has received notes from a frustrated operations professor telling management to redesign their flu-shot service, starting with the implementation of an appointment policy, an angry customer demanding many others. nurses get their own waiting line so customers can "identify and join the line for the one who's faster," among RedPharm always has four nurses available. Each nurse provides, explains and collects the corresponding signed forms from the customers, and then administers the immunization. In response to the complaints, the manager collected hourly data for 10 days and summarized it in two tables. (You can assume that once customers enter RedPharm, they only leave after getting the flu shot.) Table 1 Table 1 shows the average number of customer arrivals per block. Average Number of Customer Arrivals Time Block Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Day 8 Day 9 Day 10 7:00 - 8:00 12 .16 12.19 11.23 12 11.65 10.97 12.2 12.39 12.08 12.12 8:00 - 9:00 12.68 11.27 11.93 12.21 11.5 12.29 11.94 12.43 11.35 11.73 9:00 - 10:00 11.77 2.83 13.04 11.9 12.16 12.3 11.85 12.11 12.48 12.77 10:00 - 11:00 9.28 5.7 8.46 5.21 7.7 8.55 6.11 1.01 7.23 4.71 11:00 - 12:00 5.71 7.67 5.82 8.41 5.18 3.56 3.32 1.5 7.71 7.35 12:00 - 13:00 4.47 4.6 5.62 4.98 5.68 6.88 5.75 5.59 6:73 5.16 3.72 4.31 4.67 3.56 4.85 4.94 6.5 5.48 13:00 - 14:00 5.29 5.25 5.03 14:00 - 15:00 3.84 5.93 4.58 4.95 6.73 5.2 6.58 5.22 4.72 4.82 4.16 4.86 15:00 - 16:00 3.13 7.61 5.97 4.4 3.83 6.03 5.76 12.35 12.38 12.76 12.09 12.11 12.27 12.05 11.33 1.67 11.6 16:00 - 17:00 11.18 12.34 12.05 12.01 13.34 1,73 1.92 17:00 - 18:00 12.37 11.93 12.14 11.49 12.06 12.4 1 1.84 11.71 12.53 12.11 18:00 - 19:00 11.59 11.86 12.26B C D E G H M N Average number of customer arrivals Time block Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 9 7:00-8:00 Day 8 12.16 Day 9 12.19 Day 10 11.23 12 11.65 10 8:00-9:00 10.97 12.68 12.2 11.27 12.39 12.08 11.93 12.21 12.12 11.5 11 9:00-10:00 12.29 11.94 11.77 12.43 12.83 13.04 11.35 11.9 11.73 12.16 12 10:00-11:00 12.3 11.85 9.28 12.11 5.7 12.48 8.46 12.77 5.21 7.7 3.55 13 11:00-12:00 6.11 6.71 11.01 7.67 7.23 4.71 5.82 8.41 5.18 14 3.56 12:00-13:00 3.32 1.5 4.47 7.71 7.35 4.6 5.62 4.98 5.68 6.88 5.75 15 13:00-14:00 5.59 6.73 5.29 5.16 3.72 5.25 4.31 4.67 3.56 1.85 16 4.94 14:00-15:00 6.5 5.48 3.84 5.9 1.58 4.95 5.2 6.58 5.22 4.72 17 6.73 15:00-16:00 5.03 3.13 7.61 5.97 4.4 3.83 6.03 5.76 4.82 .16 18 1.86 16:00-17:00 12.76 12.09 12.11 12.27 12.05 11.33 11.67 11.6 12.35 12.38 19 17:00-18:00 12.37 11.93 12.14 11.18 12.34 12.05 12.01 13.34 11.73 11.92 20 18:00-19:00 11.59 11.86 11.49 12.06 12.26 12.4 11.84 11.71 12.53 12.11 21 22 23 Average service time (min) 24 Time block Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Day 8 Day 9 Day 10 25 7:00-8:00 18.35 18.03 18.5 17.68 18.34 15.18 18.24 18.02 18.3 17.32 26 8:00-9:00 8.33 18 17.6 17.84 18.09 14.47 17.53 18.02 18.57 18.22 27 9:00-10:00 18.53 17.72 17.79 18.41 17.76 14.8 17.99 18.73 17.66 18.68 28 10:00-11:00 17.99 17.91 18.4 18.75 17.88 14.37 17.18 17.69 17.81 17.65 29 11:00-12:00 18.39 17.77 18.63 17.49 18.74 14.35 19.06 18.29 18.45 18.6 30 12:00-13:00 17.67 17.66 17.88 17.71 18.4 15.62 17.48 18.81 18.17 18.09 31 13:00-14:00 18.75 19.14 17.82 17.81 18.25 15.27 17.38 18.02 18.31 17.85 32 14:00-15:00 17.96 17.7 17.38 17.61 18.13 15 17.79 7.36 17.63 17.13 33 15:00-16:00 17.39 18.14 17.85 17.85 18.2 15.43 18.08 18.29 18.29 17.87 34 16:00-17:00 18.37 18.9 18.56 17.85 17.63 14.34 17.76 17.84 17.84 18.2 35 17:00-18:00 18.51 17.84 18.23 17.55 17.25 15.3 17.63 17.15 18.15 18.5 36 18:00-19:00 18.63 18.33 17.91 18.75 18.45 15.08 17.47 17.85 18.07 17.98 37 38 39 2020 Cornell UniversityLooking at the raw data, the manager saw that the standard deviation of the time between arrivals is equal to the mean, so the coefficient of variation for the time between arrivals can assumed to be equal to 1. Table 2 Table 2 shows the average service time for each time block. This average service time corresponds to the time it takes a nurse to serve a customer and was calculated by averaging the service times of all nurses working in each time block. Average Service Time (min) Time Block Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Day 8 Day 9 Day 10 7:00 - 8:00 18.35 18.03 18.5 17.68 8.34 15.18 18.24 18.02 183 17.32 8:00 - 9:00 18.33 18 17.6 17.84 18.09 14.47 17.53 18.02 18.57 18.22 9:00 - 10:00 18.53 17.72 17.79 18.4 17.76 14.8 17.99 18.73 17.66 18.68 17.65 10:00 - 11:00 17.99 17.91 18.4 18.75 7.88 14.37 17.18 17.69 17.81 1 1:00 - 12:00 18.39 17.77 18.63 17.49 18.74 14.35 9.06 18.29 18.45 18.6 17.88 17.7 18.4 15.6 17.48 18,81 18.17 18.09 12:00 - 13:00 17.67 17.66 19.14 17.82 17.81 18.25 5.27 7.38 18.02 18.31 7.85 13:00 - 14:00 18.75 17.61 18.1 15 17.79 17.36 7.63 7.13 14:00 - 15:00 17.96 17.7 17.38 18.29 18.29 7.87 17.85 17.85 18.2 15.43 8.08 5:00 - 16:00 17.39 18.14 17.6 14.34 17.76 17.84 7.84 18.2 17.85 16:00 - 17:00 18.37 18.9 18.56 18.5 15.37 17.63 17.15 18.15 17.25 17:00 - 18:00 18.51 17.84 8.23 17.55 17.47 17.85 18.07 17.98 18.45 15.08 18:00 - 19:00 18.63 18.33 17.91 18.75