use Microsoft excel for charts and Microsoft word for the detailed description and comments for the questions Chapter 9 Questions 6. Jan has noticed that the Blueville Clinic's stockroom is a mess. She sees items that are out of place, items not marked with ID tags, items not unloaded from boxes yet, and items that do not belong to the clinic, as well as many other discrepancies. Jan thinks she could draw a cause-and-effect or fishbone diagram to help her understand why the stockroom is so messed up. Help Jan draw a cause-and-effect diagram for the stockroom's problems. 9. GKS biologicals traced its testing process over about 125 days. the subsequent statistical process control (SPC) chart is presented here. Comment on whether GKS testing process is in control or out of control. (i.e., comment on out of control points and/or runs in the data) Chapter 10 Questions 4. The following table contains 62 trials where during each trial two samples were taken of the processing time (in minutes) of the laboratory technicians. Create an x-bar chart for the data and comment on whether the process is in control. Trial Sample 1 Sample 2 Trial Sample 1 Sample 2 (min.) (min.) (min.) (min.) 1 18 13 32 14 16 2 29 14 33 20 14 3 14 11 34 29 25 4 22 13 35 18 15 5 16 13 36 15 14 6 13 28 37 15 34 7 30 26 38 11 14 8 12 18 39 14 38 9 24 34 10 14 13 10 17 13 41 13 37 11 14 11 42 13 10 12 18 13 43 12 36 13 11 20 44 14 12 14 15 16 45 30 26 15 17 12 46 16 24 16 14 16 17 10 34 17 16 32 18 20 14 18 12 11 49 16 25 19 27 35 50 21 22 20 16 14 51 35 14 21 17 35 52 12 13 22 15 16 53 14 12 23 12 10 51 22 14 24 13 15 55 27 14 25 11 32 56 37 15 26 18 12 57 17 25 27 15 14 58 40 29 28 11 14 59 39 12 29 11 27 60 35 35 30 11 26 61 10 12 31 32 22 62 37 14 The average of the X-bar and range are calculated as 19.1854839 and 8.5 respectively. Now, we will find the UCL and LCL i.e. Uper control limit and lower control limit. UCL = x + A2R and LCL = x- A2R and we can get the value of A2 from the control chart constants. For n=2 as in this case, the value of A2 is 1.886. Therefore, UCL = 19.1854839 + 1.886*8.5 = 35.2164838709677 and LCL = UCL = 19.1854839- 1.886*8.5 =3.15448387096774. Now, the X-bar chart has to be prepared. The control chart is as below. 5. For the previous table create an R chart for the processing time (in minutes) of the laboratory technicians. Comment on whether the process is in control regarding the R chart, and discuss why x-bar and R charts must be used in conjunction with each other. 6. The processing times for patients at the walk in clinic are given in the following table. The target processing time is 20 minutes with upper and lower limits of 30 minutes of 30 and 10 minutes. Calculate a capability ratio for the data set. Also, calculate a Taguchi capbility index, compare it to the capbility ratios, and comment on the similiarities or differences. patient # Process Time (min) 1 23.6 2 35.8 3 20.5 4 24.5 5 25.3 6 20.5 7 34.8 8 13 9 26.2 10 21.5 11 18.9 12 27.6 13 13.7 14 25 15 21.3 16 14.7 17 16.8 18 15.7 19 32 20 16.3 21 24.8 22 17.1 23 17.7 24 13.3 25 19.1 26 18.5 27 18.3 28 14.4 29 21.4 30 19.1 7. the same walk in clinic took data measurements of its processing times on weekends only. maximum times, with an upper limit of 30 minutes, stayed the same. however, the overall target time, 16 minutes, and the lower limit, 5 minutes, were less than for a full week (which were 20 minutes and 10 minutes, respectively. due to increased staff. Calculate a capability ratio and a Taguchi capability index for the data and compare them, explaining why they are different or similar. patient # Process Time (min) 1 23.6 2 35.8 3 20.5 4 24.5 5 25.3 6 20.5 7 34.8 8 13 9 26.2 10 21.5 11 18.9 12 27.6 13 13.7 14 25 15 21.3 16 14.7 17 16.8 18 15.7 19 32 20 16.3 21 24.8 22 17.1 23 17.7 24 13.3 25 19.1 26 18.5 27 18.3 28 14.4 29 21.4 30 19.1 Mini CaseUniversity Health Systems' Environmental Services department is tasked with cleaning patient rooms. The hospital facility is three oors and is horizontally laid out (i.e., long hallways to traverse between departments and rooms). The Environmental Services department has been experiencing some issues with the room cleaning process. Specifically, the issue is delays in cleaning rooms. While delays cannot be completely eliminated, delays need to be monitored. Leigh, Environmental Services director, has compiled some data over the past three weeks on cleaning delays. She has collected the number of cleaning delays per day and the cause of the delay as written by the room attendant. Leigh's co-workers believe day of the week plays a role in how many cleaning delays occur. Leigh does not agree and wants to show her co-workers that their team should actually be concerned with the reason(s) for the delays. Leigh also believes there has been a trend upward in the number of delays over the past three weeks. Leigh needs assistance in substantiating her claims. Problem: There are five categories for causes of delays: patient check-out orders delayed, cleaning staff shortage, room occupied, order for patient check-out canceled, or other. Using a scatter plot and a Pareto diagram, help Leigh develop a way to explain her idea to her co-workers. Include dialogue Leigh could use to help clarify her point