OPSCB/574 Competency 3 Assessment and Rubric

profileeva.brisen
UpdatedExcelfile.xlsx
Home>Business & Finance homework help>Operations Management homework help>OPSCB/574 Competency 3 Assessment and Rubric

Sheet1

Appointment_ID Scheduling_Error Insurance_Verified CheckIn_Delay_Min Cycle_Time_Min No_Show Mean check In D Upper Control Limit check In D Lower Control Limit check In D
1 0 1 7.3 10 0 7.21 2.87 15.83
2 1 1 6.1 10.9 0 7.21 2.87 15.83
3 0 1 7.3 12.2 0 7.21 2.87 15.83
4 0 1 1 11 0 7.21 2.87 15.83
5 0 1 6.3 8.9 0 7.21 2.87 15.83
6 0 1 8.1 12.1 0 7.21 2.87 15.83
7 0 1 11.4 9.9 0 7.21 2.87 15.83
8 0 1 5.4 12.9 0 7.21 2.87 15.83
9 0 0 4.6 10.2 0 7.21 2.87 15.83
10 0 1 5.5 15.1 0 7.21 2.87 15.83
11 0 1 9.7 10.4 1 7.21 2.87 15.83
12 1 1 8 11.4 1 7.21 2.87 15.83
13 0 1 5.4 13.6 1 7.21 2.87 15.83
14 0 1 8.5 9.5 0 7.21 2.87 15.83
15 0 1 7.3 12.5 0 7.21 2.87 15.83
16 0 1 9.9 14.6 1 7.21 2.87 15.83
17 0 1 4.9 8.8 0 7.21 2.87 15.83
18 0 1 6 12.4 1 7.21 2.87 15.83
19 0 1 5.8 12.5 1 7.21 2.87 15.83
20 0 1 2.6 13.6 0 7.21 2.87 15.83
21 0 1 7.9 9.5 0 7.21 2.87 15.83
22 0 1 7.8 9.4 0 7.21 2.87 15.83
23 0 0 7 13 0 7.21 2.87 15.83
24 0 1 6.3 12.6 0 7.21 2.87 15.83
25 0 1 2.8 12.5 0 7.21 2.87 15.83
26 0 1 5.7 12.7 0 7.21 2.87 15.83
27 0 1 6 10.6 1 7.21 2.87 15.83
28 0 1 4.6 12.5 0 7.21 2.87 15.83
29 0 1 6.5 12.6 0 7.21 2.87 15.83
30 0 1 8.2 10.6 0 7.21 2.87 15.83
31 0 1 12.7 15.7 0 7.21 2.87 15.83
32 0 1 7.5 12.9 1 7.21 2.87 15.83
33 0 1 7.8 9.6 0 7.21 2.87 15.83
34 1 1 6.8 13.3 0 7.21 2.87 15.83
35 1 1 1.2 10.1 0 7.21 2.87 15.83
36 0 1 6.9 13.6 0 7.21 2.87 15.83
37 0 1 7.2 14.3 0 7.21 2.87 15.83
38 0 1 14.4 10.4 0 7.21 2.87 15.83
39 0 1 6.4 13.9 0 7.21 2.87 15.83
40 0 1 7.9 12.8 0 7.21 2.87 15.83
41 0 1 6.9 13.6 0 7.21 2.87 15.83
42 0 1 3.5 15.8 0 7.21 2.87 15.83
43 0 1 10.4 11.5 0 7.21 2.87 15.83
44 1 1 9.3 10.5 1 7.21 2.87 15.83
45 0 1 9.4 10.2 0 7.21 2.87 15.83
46 0 1 4.3 10.4 0 7.21 2.87 15.83
47 0 1 11.2 11.8 0 7.21 2.87 15.83
48 0 1 2.8 12.7 0 7.21 2.87 15.83
49 0 1 8.8 12.6 0 7.21 2.87 15.83
50 0 1 13.6 13.7 0 7.21 2.87 15.83
51 0 1 6.5 12.4 0 7.21 2.87 15.83
52 0 1 8.2 12.5 0 7.21 2.87 15.83
53 0 0 12.7 13.6 0 7.21 2.87 15.83
54 0 1 7.5 9.5 0 7.21 2.87 15.83
55 0 1 7.8 9.4 0 7.21 2.87 15.83
56 0 1 6.8 13 1 7.21 2.87 15.83
57 0 1 1.2 12.6 1 7.21 2.87 15.83
58 0 1 6.9 12.5 1 7.21 2.87 15.83
59 0 1 7.2 12.7 0 7.21 2.87 15.83
60 0 1 14.4 10.6 0 7.21 2.87 15.83
61 0 1 6.4 12.5 1 7.21 2.87 15.83
62 0 1 7.9 12.6 0 7.21 2.87 15.83
63 0 1 6.9 10.6 1 7.21 2.87 15.83
64 0 1 3.5 15.7 1 7.21 2.87 15.83
65 0 0 10.4 12.9 0 7.21 2.87 15.83
66 0 1 9.3 9.6 0 7.21 2.87 15.83
67 0 1 9.4 13.3 0 7.21 2.87 15.83
68 0 1 4.3 10.1 0 7.21 2.87 15.83
69 0 1 11.2 13.6 0 7.21 2.87 15.83
70 0 1 2.8 14.3 0 7.21 2.87 15.83
71 0 0 8.8 10.4 0 7.21 2.87 15.83
72 0 1 13.6 13.9 1 7.21 2.87 15.83
73 0 1 7.3 12.8 0 7.21 2.87 15.83
74 0 1 6.1 13.6 0 7.21 2.87 15.83
75 0 1 7.3 15.8 0 7.21 2.87 15.83
76 0 1 1 11.5 0 7.21 2.87 15.83
77 0 1 6.3 10.5 1 7.21 2.87 15.83
78 0 1 8.1 12.2 0 7.21 2.87 15.83
79 0 0 11.4 11 0 7.21 2.87 15.83
80 0 1 5.4 8.9 0 7.21 2.87 15.83
81 0 1 4.6 12.1 0 7.21 2.87 15.83
82 0 1 5.5 9.9 0 7.21 2.87 15.83
83 0 1 9.7 12.9 0 7.21 2.87 15.83
84 0 1 8 10.2 0 7.21 2.87 15.83
85 0 1 5.4 15.1 0 7.21 2.87 15.83
86 0 1 8.5 10.4 0 7.21 2.87 15.83
87 0 1 7.3 11.4 0 7.21 2.87 15.83
88 0 1 9.9 13.6 1 7.21 2.87 15.83
89 0 1 4.9 9.5 0 7.21 2.87 15.83
90 0 0 6 11.5 0 7.21 2.87 15.83
Mean 7.2144444444
Upper Control Limit (Standard Deviation) 2.87
Lower Control Limit 15.83
0.00
Cp – Process Capability Index 0.87
Cpk – Process Capability Index (Centering) 0.84

Control Chart

Check In Delay

7.3 6.1 7.3 1 6.3 8.1 11.4 5.4 4.5 999999999999996 5.5 9.6999999999999993 8 5.4 8.5 7.3 9.9 4.9000000000000004 6 5.8 2.6 7.9 7.8 7 6.3 2.8 5.7 6 4.5999999999999996 6.5 8.1999999999999993 12.7 7.5 7.8 6.8 1.2 6.9 7.2 14.4 6.4 7.9 6.9 3.5 10.4 9.3000000000000007 9.4 4.3 11.2 2.8 8.8000000000000007 13.6 Mean

7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 UCL

2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 LCL

15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554

Control Chart

Scheduling_Error 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Insurance_Verified 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 0 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 0 CheckIn_Delay _Min 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 7.3 6.1 7.3 1 6.3 8.1 11.4 5.4 4.5999999999999996 5.5 9.6999999999999993 8 5.4 8.5 7.3 9.9 4.9000000000000004 6 5.8 2.6 7.9 7.8 7 6.3 2.8 5.7 6 4.5999999999999996 6.5 8.1999999999999993 12.7 7.5 7.8 6.8 1.2 6.9 7.2 14.4 6.4 7.9 6.9 3.5 10.4 9.3000000000000007 9.4 4.3 11.2 2.8 8.8000000000000007 13.6 6.5 8.1999999999999993 12.7 7.5 7.8 6.8 1.2 6.9 7.2 14.4 6.4 7.9 6.9 3.5 10.4 9.3000000000000007 9.4 4.3 11.2 2.8 8.8000000000000007 13.6 7.3 6.1 7.3 1 6.3 8.1 11.4 5.4 4.5999999999999996 5.5 9.6999999999999993 8 5.4 8.5 7.3 9.9 4.9000000000000004 6 Cycle_Time_Min 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 10 10.9 12.2 11 8.9 12.1 9.9 12.9 10.199999999999999 15.1 10.4 11.4 13.6 9.5 12.5 14.6 8.8000000000000007 12.4 12.5 13.6 9.5 9.4 13 12.6 12.5 12.7 10.6 12.5 12.6 10.6 15.7 12.9 9.6 13.3 10.1 13.6 14.3 10.4 13.9 12.8 13.6 15.8 11.5 10.5 10.199999999999999 10.4 11.8 12.7 12.6 13.7 12.4 12.5 13.6 9.5 9.4 13 12.6 12.5 12.7 10.6 12.5 12.6 10.6 15.7 12.9 9.6 13.3 10.1 13.6 14.3 10.4 13.9 12.8 13.6 15.8 11.5 10.5 12.2 11 8.9 12.1 9.9 12.9 10.199999999999999 15.1 10.4 11.4 13.6 9.5 11.5 No_Show 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 1 0 1 1 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 1 0 1 1 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 Mean check In D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 7.2144444444444398 Upper Control Limit check In D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 2.8715794937653714 Lower Control Limit check In D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554 15.829182925740554

image1.png