Weekly Manufacturing KPI Dashboard

Safety
Week #1 - 02 J
Safety - Week Prior Safety - Month To Date Safety - FY To Date Safety - FY to Date
4

HIPOS FIRST AID ORIR HIPOS FIRST AID ORIR HIPOS FIRST AID ORIR 2
# HIPOS
0

l l l l l l l l l
1/2/2012 7/2/2012

15
10

l l l l l l l l l # FIRST AID 5
0
1/2/2012 7/2/2012

l l l l l l l l l
6
4
# ORIR 2
0
1/2/2012 7/2/2012

2 4 4 2 4 4 2 4 4

Quality
Quality - Week Prior Quality - Month To Date Quality - FY To Date Quality - FY To Date
150

CLAIMS # QINS ALERTS CLAIMS # QINS ALERTS CLAIMS # QINS ALERTS # CLAIMS
100
50
0

l l l l l l l l l
1/2/2012 7/2/2012

150
100

l l l l l l l l l
# QINS 50
0
1/2/2012 7/2/2012

l l l l l l l l l
150
100
# ALERTS 50
0
1/2/2012 7/2/2012

39 70 5 39 70 5 39 70 5

Finance
Profit - FY To Date
Weekly Expenditure Weekly Income Weekly Profit $80,000

$40,000
EXPENSE
$0
1/2/2012 7/2/2012

$80,000
40.0 60.0 40.0 60.0 -10.0 10.0 $40,000
INCOME $0
20.0 80.0 20.0 80.0 -30.0 30.0 1/2/2012 7/2/2012

$40,000
0.0
59.6 100.0 0.0
79.6 100.0 -50.0
20.0 50.0
PROFIT
$20,000

$0
1/2/2012 7/2/2012
X 10,000 USD$ X 10,000 USD$ X 10,000 USD$

Materials
Materials - Week Prior Materials - MTD Materials - FYTD Materials - FYTD
150

EXPEDS ON TIME TBD EXPEDS ON TIME TBD EXPEDS ON TIME TBD 100
# EXPEDS 50
0

l l l l l l l l l
1/2/2012 7/2/2012

100.0%

l l l l l l l l l
50.0%
% ON TIME 0.0%
1/2/2012 7/2/2012

l l l l l l l l l
150
100
# TBD 50
0
1/2/2012 7/2/2012

38 67.7% 3 38 67.7% 3 38 67.7% 3

Human Resources
HR - Week Prior HR - Month To Date HR - FY To Date HR - FY To Date
15.0%

% OT # HEADS % TURN % OT # HEADS % TURN % OT # HEADS % TURN OVERTIME

10.0%
5.0%
0.0%

l l l l l l l l l
1/2/2012 7/2/2012

1000

l l l l l l l l l
500
# HEADS 0
1/2/2012 7/2/2012

l l l l l l l l l
3.0%
2.0%
TURNOVER 1.0%
0.0%
1/2/2012 7/2/2012

8.3% 617.0 0.8% 8.3% 617.0 0.8% 8.3% 617.0 0.8%

Production
Prod - Week Prior Weekly MMPP Rate - Weekly Flow Rate - Weekly # Parts Packed
FYTD FYTD - FYTD
MMPP FLOW PACKED 100.0 100% 2000
90.0 90% 1800

l l l
80.0 80% 1600
70.0 70% 1400
60.0 60% 1200

l l l
50.0 50% 1000
40.0 40% 800
30.0 30% 600

l l l
20.0 20% 400
10.0 10% 200
0.0 0% 0
Jan Feb Mar Apr May May Jan Feb Mar Apr May May Jan Feb Mar Apr May May

24.4 81.7% 1519

Safety Widgets Configuration Data

Traffic Light Widget Title Safety - Week Prior Traffic Light Widget Title

#HIPOs FIRST AID #ORIR

Traffic Light Target Value 2 4 4 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 39 70 5 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 59.6 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 38 67.7% 3 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 8.3% 617.0 0.8% 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 Note: The data for this widget ca
My Database Page.
Traffic Light Target Value 24.4 81.7% 1519

Yellow to Red Threshold 70 80.0% 1400

Green to Yellow Threshold 90 90.0% 1600

Traffic Light Widget Title Safety - Month To Date Traffic Light Widget Title

#HIPOs FIRST AID #ORIR

Traffic Light Target Value 2 4 4 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 39 70 5 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 79.6 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 # Expedites

Traffic Light Target Value 38 67.7% 3 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 Traffic Light Widget Title

OT Rate Head Count Turnover

Traffic Light Target Value 8.3% 617.0 0.8% 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 Trend Widget Title

Note: The data for this widget can be found in the Note: The data for this widget can be found in the
My Database Page. My Database Page.
Safety - FY To Date Trend Widget Title Safety - FY to Date

#HIPOs FIRST AID #ORIR Note: The data for this widget can be found in the
My Database Page.
2 4 4

90 90 90

70 70 70

Quality - FY To Date Trend Widget Title Quality - FY To Date

# Claims #QINs #Alerts Note: The data for this widget can be found in the
My Database Page.
39 70 5

2000 2000 2000

1500 1500 1500

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.
20.0

-50

50

Materials - FYTD Trend Widget Title Materials - FYTD

 # Expedites # On Time # TBD Note: The data for this widget can be found in the
My Database Page.
38 67.7% 3

800 80.00% 800

700 90.00% 700

HR - FY To Date Trend Widget Title HR - FY To Date

OT Rate Head Count Turnover Note: The data for this widget can be found in the
My Database Page.
8.3% 617.0 0.8%

8% 1000 1.5%

5% 800 1.2%

Weekly Flow Rate - FYTD Trend Widget Title Weekly # Parts Packed - FYTD

s widget can be found in the Note: The data for this widget can be found in the
My Database Page.
acked - FYTD
Weekly Manufacturing KPI Dashboard Database Page
Week #1 - 02 Jan 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

# # # Claimed # Quality # Claimed

# ORIR # HIPOs # ORIR # QINs
First Aid First Aid Parts Alerts 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

# Quality # Claimed # Quality Weekly Weekly

# QINs # QINs
Alerts Parts Alerts Expenditure 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 On Time On Time

# Expedites # TBD # Expedites # TBD
Profit Delivery Rate Delivery Rate

$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
Hourly
On Time Overtime # Head Overtime # Head
# Expedites # TBD Turnover
Delivery Rate Rate Count Rate Count
Rate
38 68% 3 8.3% 617 0.8% 8.3% 617.0
102 62% 67 9.2% 618 2.0% 8.7% 617.5
201 68% 90 6.5% 625 0.5% 8.0% 620.0
252 64% 187 6.3% 615 1.1% 7.6% 618.8
296 67% 284 8.9% 634 0.7% 7.7% 623.0
302 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 PRODUCTION
NTH TO DATE FY TO DATE
Hourly Hourly
Overtime # Head # Parts
Turnover Turnover MMPP Rate Flow Rate
Rate Count Packed
Rate Rate
0.8% 8.3% 617.0 0.8% 24.4 82% 1519
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
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