Weekly Manufacturing KPI Dashboard
Week #11 - 12 Mar 2012
Safety Safety - Week Prior
Safety - Month To Date
Safety - FY To Date
Safety - FY to Date 5
HIPOS
FIRST AID
ORIR
HIPOS
FIRST AID
ORIR
HIPOS
FIRST AID
ORIR
# HIPOS
0 Jan
Feb
Mar
Apr
May
20
# FIRST AID
0 Jan
Feb
Mar
Apr
May
Jan
Feb
Mar
Apr
May
10
# ORIR 3
4
2
10
15
15
25
56
0
33
Quality Quality - Week Prior
Quality - Month To Date
Quality - FY To Date
Quality - FY To Date 200
CLAIMS
# QINS
ALERTS
CLAIMS
# QINS
ALERTS
CLAIMS
# QINS
ALERTS
# CLAIMS
0 Jan
Feb
Mar
Apr
May
Jan
Feb
Mar
Apr
May
Jan
Feb
Mar
Apr
May
200
# QINS
0
200
# ALERTS 43
71
47
120
209
210
489
737
0
524
Finance Weekly Expenditure
Weekly Income
Profit - FY To Date
Weekly Profit
$80,000
EXPENSE
$40,000
$0 Jan
Feb
Mar
Apr
May
Jan
Feb
Mar
Apr
May
Jan
Feb
Mar
Apr
May
$80,000
40.0
40.0
60.0
20.0
20.0
80.0
-10.0
60.0
10.0
-30.0
80.0
$40,000
INCOME
$0
30.0 $40,000
0.0
100.0
0.0
100.0
-50.0
50.0
$20,000
PROFIT X 10,000 USD$
X 10,000 USD$
$0
X 10,000 USD$
Materials Materials - Week Prior
Materials - MTD
Materials - FYTD
Materials - FYTD
200
EXPEDS
ON TIME
TBD
EXPEDS
ON TIME
TBD
EXPEDS
ON TIME
TBD
# EXPEDS
0 Jan
Feb
Mar
Apr
May
100.0%
% ON TIME
50.0%
0.0% Jan
Feb
Mar
Apr
May
200
# TBD
0 Jan
24
74.1%
23
202
78.9%
144
554
72.3%
Feb
Mar
Apr
May
586
Human Resources HR - Week Prior
HR - Month To Date
HR - FY To Date
HR - FY To Date
20.0%
% OT
# HEADS
% TURN
% OT
# HEADS % TURN
% OT
# HEADS
% TURN
OVERTIME
0.0% Jan
Feb
Mar
Apr
May
1000
# HEADS
0 Jan
Feb
Mar
Apr
May
Feb
Mar
Apr
May
5.0%
TURNOVER
0.0% Jan
10.0%
624.0
1.1%
7.9%
625.3
1.2%
7.6%
623.7
1.0%
Production Weekly MMPP Rate FYTD
Prod - Week Prior MMPP
FLOW
PACKED
59.5%
1746
Weekly # Parts Packed - FYTD
100%
2000
90.0
90%
1800
80.0
80%
1600
70.0
70%
1400
60.0
60%
1200
50.0
50%
1000
40.0
40%
800
30.0
30%
600
20.0
20%
10.0
10%
0.0 Jan
25.1
Weekly Flow Rate FYTD
100.0
400
200
0% Feb
Mar
Apr
May
May
0 Jan
Feb
Mar
Apr
May
May
Jan
Feb
Mar
Apr
May
May
Safety Widgets Configuration Data Traffic Light Widget Title
Safety - Week Prior
Traffic Light Widget Title
#HIPOs
FIRST AID
#ORIR
Traffic Light Target Value
3
4
2
Traffic Light Target Value
Yellow to Red Threshold
7
7
7
Yellow to Red Threshold
Green to Yellow Threshold
5
5
5
Green to Yellow Threshold
Quality Widgets Configuration Data Traffic Light Widget Title
Quality - Week Prior
Traffic Light Widget Title
# Claims
#QINs
#Alerts
Traffic Light Target Value
43
71
47
Traffic Light Target Value
Yellow to Red Threshold
90
90
90
Yellow to Red Threshold
Green to Yellow Threshold
60
60
60
Green to Yellow Threshold
Finance Widgets Configuration Data Dial Widget Title
Weekly Expenditure
Dial Widget Title
Dial Widget Units
X 10,000 USD$
Dial Widget Units
Actual Value
53.9
Actual Value
Minimum Value
0
Minimum Value
Maximum Value
100
Maximum Value
Materials Widgets Configuration Data Traffic Light Widget Title
Materials - Week Prior
Traffic Light Widget Title
# Expedites
# On Time
# TBD
Traffic Light Target Value
24
74.1%
23
Traffic Light Target Value
Yellow to Red Threshold
60
80.00%
80
Yellow to Red Threshold
Green to Yellow Threshold
50
90.00%
70
Green to Yellow Threshold
Human Resources Widgets Configuration Data Traffic Light Widget Title
HR - Week Prior
Traffic Light Widget Title
OT Rate
Head Count
Turnover
Traffic Light Target Value
10.0%
624.0
1.1%
Traffic Light Target Value
Yellow to Red Threshold
8%
1000
1.5%
Yellow to Red Threshold
Green to Yellow Threshold
5%
800
1.2%
Green to Yellow Threshold
Productivity Widgets Configuration Data Traffic Light Widget Title
Prod - Week Prior
Trend Widget Title
MMPP Rate
Flow Rate
# Packed
Traffic Light Target Value
25.1
59.5%
1746
Yellow to Red Threshold
70
80.0%
1400
Green to Yellow Threshold
90
90.0%
1600
Note: The data for this widget ca My Database Page.
Traffic Light Widget Title
Safety - Month To Date
Traffic Light Widget Title
#HIPOs
FIRST AID
#ORIR
Traffic Light Target Value
10
15
15
Traffic Light Target Value
Yellow to Red Threshold
14
24
17
Yellow to Red Threshold
Green to Yellow Threshold
10
18
15
Green to Yellow Threshold
Traffic Light Widget Title
Quality - Month To Date
Traffic Light Widget Title
# Claims
#QINs
#Alerts
Traffic Light Target Value
120
209
210
Traffic Light Target Value
Yellow to Red Threshold
300
300
300
Yellow to Red Threshold
Green to Yellow Threshold
250
250
250
Green to Yellow Threshold
Dial Widget Title
Weekly Income
Dial Widget Title
Dial Widget Units
X 10,000 USD$
Dial Widget Units
Actual Value
56.5
Actual Value
Minimum Value
0
Minimum Value
Maximum Value
100
Maximum Value
Traffic Light Widget Title
Materials - MTD
Traffic Light Widget Title
# Expedites
# On Time
# TBD
Traffic Light Target Value
202
78.9%
144
Traffic Light Target Value
Yellow to Red Threshold
200
80.00%
300
Yellow to Red Threshold
Green to Yellow Threshold
170
90.00%
250
Green to Yellow Threshold
Traffic Light Widget Title
HR - Month To Date
# Expedites
Traffic Light Widget Title
OT Rate
Head Count
Turnover
Traffic Light Target Value
7.9%
625.3
1.2%
Traffic Light Target Value
Yellow to Red Threshold
8%
1000
1.5%
Yellow to Red Threshold
Green to Yellow Threshold
5%
800
1.2%
Green to Yellow Threshold
Trend Widget Title
Weekly MMPP Rate - FYTD
Note: The data for this widget can be found in the My Database Page.
Trend Widget Title Note: The data for this widget can be found in the My Database Page.
Safety - FY To Date
Trend Widget Title
#HIPOs
FIRST AID
#ORIR
25
56
33
90
90
90
70
70
70
Quality - FY To Date
Note: The data for this widget can be found in the My Database Page.
Trend Widget Title
# Claims
#QINs
#Alerts
489
737
524
2000
2000
2000
1500
1500
1500
Safety - FY to Date
Quality - FY To Date
Note: The data for this widget can be found in the My Database Page.
Weekly Profit
Trend Widget Title
Profit - FY To Date
X 10,000 USD$
Note: The data for this widget can be found in the My Database Page.
2.6 -50 50
Materials - FYTD
Trend Widget Title
Materials - FYTD
# Expedites
# On Time
# TBD
554
72.3%
586
800
80.00%
800
700
90.00%
700
HR - FY To Date
Trend Widget Title
OT Rate
Head Count
Turnover
7.6%
623.7
1.0%
8%
1000
1.5%
5%
800
1.2%
Weekly Flow Rate - FYTD
is widget can be found in the
Note: The data for this widget can be found in the My Database Page.
HR - FY To Date
Note: The data for this widget can be found in the My Database Page.
Trend Widget Title
Weekly # Parts Packed - FYTD
Note: The data for this widget can be found in the My Database Page.
acked - FYTD
Weekly Manufacturing KPI Dashboard Database Page Week #11 - 12 Mar 2012 WEEK PRIOR
MONTH TO DATE
FY2012
Start Date
Week Concatenated
# HIPOs
# First Aid
# ORIR
# HIPOs
Week #1
1/2/2012
Week #1 - 02 Jan 2012
2
4
4
2
Week #2
1/9/2012
Week #2 - 09 Jan 2012
3
6
3
5
Week #3
1/16/2012
Week #3 - 16 Jan 2012
2
5
3
7
Week #4
1/23/2012
Week #4 - 23 Jan 2012
3
9
2
10
Week #5
1/30/2012
Week #5 - 30 Jan 2012
3
2
1
11
Week #6
2/6/2012
Week #6 - 06 Feb 2012
1
5
1
9
Week #7
2/13/2012
Week #7 - 13 Feb 2012
1
10
4
8
Week #8
2/20/2012
Week #8 - 20 Feb 2012
3
4
3
8
Week #9
2/27/2012
Week #9 - 27 Feb 2012
1
6
5
6
Week #10
3/5/2012
Week #10 - 05 Mar 2012
3
1
5
8
Week #11
3/12/2012
Week #11 - 12 Mar 2012
3
4
2
10
Week #12
3/19/2012
Week #12 - 19 Mar 2012
2
4
4
9
Week #13
3/26/2012
Week #13 - 26 Mar 2012
2
7
4
10
Week #14
4/2/2012
Week #14 - 02 Apr 2012
2
6
5
9
Week #15
4/9/2012
Week #15 - 09 Apr 2012
3
9
4
9
Week #16
4/16/2012
Week #16 - 16 Apr 2012
2
4
5
9
Week #17
4/23/2012
Week #17 - 23 Apr 2012
2
1
1
9
Week #18
4/30/2012
Week #18 - 30 Apr 2012
3
2
2
10
Week #19
5/7/2012
Week #19 - 07 May 2012
3
3
1
10
Week #20
5/14/2012
Week #20 - 14 May 2012
Week #21
5/21/2012
Week #21 - 21 May 2012
Week #22
5/28/2012
Week #22 - 28 May 2012
Week #23
6/4/2012
Week #23 - 04 Jun 2012
Week #24
6/11/2012
Week #24 - 11 Jun 2012
Week #25
6/18/2012
Week #25 - 18 Jun 2012
Week #26
6/25/2012
Week #26 - 25 Jun 2012
Week #27
7/2/2012
Week #27 - 02 Jul 2012
Week #28
7/9/2012
Week #28 - 09 Jul 2012
Week #29
7/16/2012
Week #29 - 16 Jul 2012
Week #30
7/23/2012
Week #30 - 23 Jul 2012
Week #31
7/30/2012
Week #31 - 30 Jul 2012
Week #32
8/6/2012
Week #32 - 06 Aug 2012
Week #33
8/13/2012
Week #33 - 13 Aug 2012
Week #34
8/20/2012
Week #34 - 20 Aug 2012
Week #35
8/27/2012
Week #35 - 27 Aug 2012
Week #36
9/3/2012
Week #36 - 03 Sep 2012
Week #37
9/10/2012
Week #37 - 10 Sep 2012
Week #38
9/17/2012
Week #38 - 17 Sep 2012
Week #39
9/24/2012
Week #39 - 24 Sep 2012
Week #40
10/1/2012
Week #40 - 01 Oct 2012
Week #41
10/8/2012
Week #41 - 08 Oct 2012
Week #42
10/15/2012
Week #42 - 15 Oct 2012
Week #43
10/22/2012
Week #43 - 22 Oct 2012
Week #44
10/29/2012
Week #44 - 29 Oct 2012
Week #45
11/5/2012
Week #45 - 05 Nov 2012
Week #46
11/12/2012
Week #46 - 12 Nov 2012
Week #47
11/19/2012
Week #47 - 19 Nov 2012
Week #48
11/26/2012
Week #48 - 26 Nov 2012
Week #49
12/3/2012
Week #49 - 03 Dec 2012
Week #50
12/10/2012
Week #50 - 10 Dec 2012
Week #51
12/17/2012
Week #51 - 17 Dec 2012
Week #52
12/24/2012
Week #52 - 24 Dec 2012
41267
SAFETY MONTH TO DATE
FY TO DATE
WEEK PRIOR
MONTH TO DA
# First Aid
# ORIR
# HIPOs
# First Aid
# ORIR
# Claimed Parts
# QINs
# Quality Alerts
# Claimed Parts
4
4
2
4
4
39
70
5
39
10
7
5
10
7
99
72
48
138
15
10
7
15
10
64
85
9
202
24
12
10
24
12
62
68
72
264
22
9
13
26
13
64
74
37
289
21
7
14
31
14
10
71
87
200
26
8
15
41
18
31
88
56
167
21
9
18
45
21
1
33
33
106
25
13
19
51
26
38
83
75
80
21
17
22
52
31
38
22
55
108
15
15
25
56
33
43
71
47
120
15
16
27
60
37
78
34
26
197
16
15
29
67
41
89
45
97
248
21
15
31
73
46
31
85
33
241
26
17
34
82
50
89
72
76
287
26
18
36
86
55
77
99
95
286
20
15
38
87
56
11
61
77
208
16
12
41
89
58
37
83
67
214
10
9
44
92
59
46
83
44
171
QUALITY
FINANCE
MONTH TO DATE
FY TO DATE
# QINs
# Quality Alerts
# Claimed Parts
# QINs
# Quality Alerts
Weekly Expenditure
Weekly Income
70
5
39
70
5
$59,634
$79,604
142
53
138
142
53
$54,709
$50,789
227
62
202
227
62
$52,197
$73,499
295
134
264
295
134
$55,235
$64,087
299
166
328
369
171
$58,224
$75,581
298
205
338
440
258
$55,456
$57,827
301
252
369
528
314
$52,076
$79,203
266
213
370
561
347
$54,520
$52,736
275
251
408
644
422
$58,837
$63,762
226
219
446
666
477
$51,234
$56,795
209
210
489
737
524
$53,933
$56,535
210
203
567
771
550
$54,088
$70,422
172
225
656
816
647
$53,635
$60,065
235
203
687
901
680
$59,704
$74,345
236
232
776
973
756
$51,640
$77,750
301
301
853
1072
851
$58,022
$57,331
317
281
864
1133
928
$52,875
$55,460
315
315
901
1216
995
$58,267
$56,788
326
283
947
1299
1039
$59,981
$72,684
MATERIALS WEEK PRIOR
MONTH TO DATE
Weekly Profit
# Expedites
On Time Delivery Rate
# TBD
# Expedites
On Time Delivery Rate
# TBD
$19,970
38
67.7%
3
38
67.7%
3
-$3,920
64
56.2%
64
102
62.0%
67
$21,302
99
78.9%
23
201
67.6%
90
$8,852
50
52.1%
97
252
63.7%
187
$17,357
45
81.2%
97
258
67.1%
280
$2,371
6
89.4%
86
200
75.4%
302
$27,127
50
54.2%
73
151
69.2%
352
-$1,783
38
94.8%
15
138
79.9%
270
$4,926
63
89.9%
16
157
82.1%
190
$5,560
77
56.7%
90
228
73.9%
193
$2,602
24
74.1%
23
202
78.9%
144
$16,334
10
78.9%
93
175
74.9%
222
$6,431
32
90.8%
46
144
75.1%
251
$14,641
77
54.7%
44
143
74.6%
206
$26,110
16
64.6%
63
135
72.2%
245
-$691
4
71.0%
52
129
70.3%
205
$2,585
50
86.0%
1
147
69.1%
160
-$1,478
47
99.8%
35
117
80.4%
151
$12,703
39
97.5%
93
140
88.6%
181
HUMAN RESOURCES FY TO DATE
WEEK PRIOR
MONTH TO DATE
# Expedites
On Time Delivery Rate
# TBD
Overtime Rate
# Head Count
38
68%
3
8.3%
617
Hourly Turnover Rate 0.8%
102
62%
67
9.2%
618
201
68%
90
6.5%
252
64%
187
296
67%
302
Overtime Rate
# Head Count
8.3%
617.0
2.0%
8.7%
617.5
625
0.5%
8.0%
620.0
6.3%
615
1.1%
7.6%
618.8
284
8.9%
634
0.7%
7.7%
623.0
71%
370
5.8%
633
0.1%
6.9%
626.8
352
69%
442
7.1%
618
0.7%
7.0%
625.0
390
72%
457
5.6%
631
0.7%
6.9%
629.0
453
74%
473
6.2%
645
1.6%
6.2%
631.8
530
72%
563
9.8%
601
1.4%
7.2%
623.8
554
72%
586
10.0%
624
1.1%
7.9%
625.3
564
73%
679
8.7%
610
0.4%
8.7%
620.0
597
74%
724
7.3%
629
0.7%
8.9%
616.0
674
73%
769
7.5%
608
1.3%
8.4%
617.8
689
72%
831
8.3%
628
1.4%
8.0%
618.8
694
72%
883
8.3%
623
0.2%
7.8%
622.0
744
73%
885
8.7%
628
0.7%
8.2%
621.8
790
75%
920
7.6%
621
0.3%
8.2%
625.0
829
76%
1013
6.3%
601
1.5%
7.7%
618.3
AN RESOURCES
NTH TO DATE Hourly Turnover Rate 0.8%
PRODUCTION FY TO DATE Hourly Turnover MMPP Rate Flow Rate Rate 0.8% 24.4 82%
Overtime Rate
# Head Count
# Parts Packed
8.3%
617.0
1.4%
8.7%
617.5
1.4%
45.0
85%
1041
1.1%
8.0%
620.0
1.1%
71.5
64%
1669
1.1%
7.6%
618.8
1.1%
6.4
51%
1262
1.1%
7.8%
621.8
1.0%
74.9
67%
1757
0.6%
7.5%
623.7
0.9%
92.3
82%
1750
0.7%
7.4%
622.9
0.8%
43.1
84%
1545
0.6%
7.2%
623.9
0.8%
76.2
60%
1619
0.8%
7.1%
626.2
0.9%
80.6
97%
1378
1.1%
7.4%
623.7
1.0%
62.0
81%
1617
1.2%
7.6%
623.7
1.0%
25.1
60%
1746
1.1%
7.7%
622.6
0.9%
43.8
84%
1269
0.9%
7.7%
623.1
0.9%
82.9
84%
1623
0.9%
7.7%
622.0
0.9%
65.8
59%
1744
0.9%
7.7%
622.4
1.0%
62.0
92%
1258
0.9%
7.7%
622.4
0.9%
59.5
53%
1069
0.9%
7.8%
622.8
0.9%
43.9
83%
1409
0.6%
7.8%
622.7
0.9%
8.4
56%
1201
0.7%
7.7%
621.5
0.9%
92.4
88%
1237
1519
Dashboard Dropdown List Week #1 - 02 Jan 2012 Week #2 - 09 Jan 2012 Week #3 - 16 Jan 2012 Week #4 - 23 Jan 2012 Week #5 - 30 Jan 2012 Week #6 - 06 Feb 2012 Week #7 - 13 Feb 2012 Week #8 - 20 Feb 2012 Week #9 - 27 Feb 2012 Week #10 - 05 Mar 2012 Week #11 - 12 Mar 2012 Week #12 - 19 Mar 2012 Week #13 - 26 Mar 2012 Week #14 - 02 Apr 2012 Week #15 - 09 Apr 2012 Week #16 - 16 Apr 2012 Week #17 - 23 Apr 2012 Week #18 - 30 Apr 2012 Week #19 - 07 May 2012 Week #20 - 14 May 2012 Week #21 - 21 May 2012 Week #22 - 28 May 2012 Week #23 - 04 Jun 2012 Week #24 - 11 Jun 2012 Week #25 - 18 Jun 2012 Week #26 - 25 Jun 2012 Week #27 - 02 Jul 2012 Week #28 - 09 Jul 2012 Week #29 - 16 Jul 2012 Week #30 - 23 Jul 2012 Week #31 - 30 Jul 2012 Week #32 - 06 Aug 2012 Week #33 - 13 Aug 2012 Week #34 - 20 Aug 2012 Week #35 - 27 Aug 2012 Week #36 - 03 Sep 2012 Week #37 - 10 Sep 2012 Week #38 - 17 Sep 2012 Week #39 - 24 Sep 2012 Week #40 - 01 Oct 2012 Week #41 - 08 Oct 2012 Week #42 - 15 Oct 2012 Week #43 - 22 Oct 2012 Week #44 - 29 Oct 2012 Week #45 - 05 Nov 2012 Week #46 - 12 Nov 2012 Week #47 - 19 Nov 2012 Week #48 - 26 Nov 2012 Week #49 - 03 Dec 2012 Week #50 - 10 Dec 2012 Week #51 - 17 Dec 2012
Week #52 - 24 Dec 2012
