OPSCB/574 Competency 2 Assessment and Rubric

profileeva.brisen
Excelfile.xlsx
Home>Business & Finance homework help>Operations Management homework help>OPSCB/574 Competency 2 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.06 2.83 15.56
2 1 1 6.1 10.9 0 7.06 2.83 15.56
3 0 1 7.3 12.2 0 7.06 2.83 15.56
4 0 1 1 11 0 7.06 2.83 15.56
5 0 1 6.3 8.9 0 7.06 2.83 15.56
6 0 1 8.1 12.1 0 7.06 2.83 15.56
7 0 1 11.4 9.9 0 7.06 2.83 15.56
8 0 1 5.4 12.9 0 7.06 2.83 15.56
9 0 0 4.6 10.2 0 7.06 2.83 15.56
10 0 1 5.5 15.1 0 7.06 2.83 15.56
11 0 1 9.7 10.4 1 7.06 2.83 15.56
12 1 1 8 11.4 1 7.06 2.83 15.56
13 0 1 5.4 13.6 1 7.06 2.83 15.56
14 0 1 8.5 9.5 0 7.06 2.83 15.56
15 0 1 7.3 12.5 0 7.06 2.83 15.56
16 0 1 9.9 14.6 1 7.06 2.83 15.56
17 0 1 4.9 8.8 0 7.06 2.83 15.56
18 0 1 6 12.4 1 7.06 2.83 15.56
19 0 1 5.8 12.5 1 7.06 2.83 15.56
20 0 1 2.6 13.6 0 7.06 2.83 15.56
21 0 1 7.9 9.5 0 7.06 2.83 15.56
22 0 1 7.8 9.4 0 7.06 2.83 15.56
23 0 0 7 13 0 7.06 2.83 15.56
24 0 1 6.3 12.6 0 7.06 2.83 15.56
25 0 1 2.8 12.5 0 7.06 2.83 15.56
26 0 1 5.7 12.7 0 7.06 2.83 15.56
27 0 1 6 10.6 1 7.06 2.83 15.56
28 0 1 4.6 12.5 0 7.06 2.83 15.56
29 0 1 6.5 12.6 0 7.06 2.83 15.56
30 0 1 8.2 10.6 0 7.06 2.83 15.56
31 0 1 12.7 15.7 0 7.06 2.83 15.56
32 0 1 7.5 12.9 1 7.06 2.83 15.56
33 0 1 7.8 9.6 0 7.06 2.83 15.56
34 1 1 6.8 13.3 0 7.06 2.83 15.56
35 1 1 1.2 10.1 0 7.06 2.83 15.56
36 0 1 6.9 13.6 0 7.06 2.83 15.56
37 0 1 7.2 14.3 0 7.06 2.83 15.56
38 0 1 14.4 10.4 0 7.06 2.83 15.56
39 0 1 6.4 13.9 0 7.06 2.83 15.56
40 0 1 7.9 12.8 0 7.06 2.83 15.56
41 0 1 6.9 13.6 0 7.06 2.83 15.56
42 0 1 3.5 15.8 0 7.06 2.83 15.56
43 0 1 10.4 11.5 0 7.06 2.83 15.56
44 1 1 9.3 10.5 1 7.06 2.83 15.56
45 0 1 9.4 10.2 0 7.06 2.83 15.56
46 0 1 4.3 10.4 0 7.06 2.83 15.56
47 0 1 11.2 11.8 0 7.06 2.83 15.56
48 0 1 2.8 12.7 0 7.06 2.83 15.56
49 0 0 8.8 12.6 0 7.06 2.83 15.56
50 0 1 13.6 13.7 0 7.06 2.83 15.56
Mean 7.058
Upper Control Limit (Standard Deviation) 2.83
Lower Control Limit 15.56
0.00
Cp – Process Capability Index 0.88
Cpk – Process Capability Index (Centering) 0.83

Control Chart

Check In Delay

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 Mean

7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 7.0579999999999998 UCL

2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 2.8329756476906338 LCL

15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719 15.5569269430719

image1.png