Manufacturing KPI Dashboard

(1)

0 200 400 600 800 1000 1200 1400 1600 1800 2000

Jan Feb Mar Apr May May Weekly # Parts Packed - FYTD 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100%

Jan Feb Mar Apr May May Weekly Flow Rate -

FYTD 0.0 10.0 20.0 30.0 40.0 50.0 60.0 70.0 80.0 90.0 100.0

Jan Feb Mar Apr May May Weekly MMPP Rate - FYTD 1746 59.5% 25.1 PACKED FLOW MMPP

Prod - Week Prior

Production

0.0% 5.0%

Jan Feb Mar Apr May 0

1000

Jan Feb Mar Apr May 0.0%

20.0%

Jan Feb Mar Apr May

TURNOVER # HEADS OVERTIME HR - FY To Date 1.0% 623.7 7.6% % TURN # HEADS % OT HR - FY To Date 1.2% 625.3 7.9% % TURN # HEADS % OT HR - Month To Date 1.1% 624.0 10.0% % TURN # HEADS % OT HR - Week Prior

Human Resources

0 200

Jan Feb Mar Apr May 0.0%

50.0% 100.0%

Jan FebMar AprMay 0

200

# TBD % ON TIME # EXPEDS Materials - FYTD 586 72.3% 554 TBD ON TIME EXPEDS Materials - FYTD 144 78.9% 202 TBD ON TIME EXPEDS Materials - MTD 23 74.1% 24 TBD ON TIME EXPEDS

Materials - Week Prior

Materials

$0 $20,000 $40,000

Jan FebMar AprMay $0

$40,000 $80,000

Jan FebMar AprMay $0

$40,000 $80,000

Jan FebMar AprMay

PROFIT INCOME EXPENSE Profit - FY To Date 50.0 30.0 10.0 -10.0 -30.0 -50.0 X 10,000 USD$ Weekly Profit 100.0 80.0 60.0 40.0 20.0 0.0 X 10,000 USD$ Weekly Income 100.0 80.0 60.0 40.0 20.0 0.0 X 10,000 USD$ Weekly Expenditure

Finance

0 200

200

# ALERTS # QINS # CLAIMS Quality - FY To Date 524 737 489 ALERTS # QINS CLAIMS Quality - FY To Date 210 209 120 ALERTS # QINS CLAIMS

Quality - Month To Date

47 71 43 ALERTS # QINS CLAIMS

Quality - Week Prior

Quality

0 10

20

5

# ORIR # FIRST AID # HIPOS Safety - FY to Date 33 56 25 ORIR FIRST AID HIPOS Safety - FY To Date 15 15 10 ORIR FIRST AID HIPOS

Safety - Month To Date

2 4 3 ORIR FIRST AID HIPOS

Safety - Week Prior

Safety

(2)

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

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

(3)

# 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 Note: The data for this widget can be found in the

My Database Page.

Traffic Light Target Value 25.1 59.5% 1746

Yellow to Red Threshold 70 80.0% 1400

(4)

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

#HIPOs FIRST AID #ORIR

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

# Claims #QINs #Alerts

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

(5)

# Expedites # On Time # TBD # Expedites

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

(6)

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.

25 56 33

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.

489 737 524

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

-50 50

(7)

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

554 72.3% 586

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.

7.6% 623.7 1.0%

8% 1000 1.5%

5% 800 1.2%

Weekly Flow Rate - FYTD Trend Widget Title Weekly # Parts Packed - FYTD Note: The data for this widget can be found in the Note: The data for this widget can be found in the

(8)

(9)

(10)

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

(11)

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

(12)

SAFETY

MONTH TO DATE FY TO DATE WEEK PRIOR MONTH TO DATE

#

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

(13)

(14)

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

(15)

(16)

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

(17)

(18)

HUMAN RESOURCES

FY TO DATE WEEK PRIOR MONTH TO DATE

# Expedites On Time Delivery Rate # TBD Overtime Rate # Head Count Hourly Turnover Rate Overtime Rate # Head Count 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

(19)

(20)

HUMAN RESOURCES PRODUCTION

MONTH TO DATE FY TO DATE

Hourly Turnover Rate Overtime Rate # Head Count Hourly Turnover Rate

MMPP Rate Flow Rate # Parts

Packed 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

(21)

(22)

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

(23)