Simple Oee Spreadsheet 6u2c3m

Calculating OEE Worksheet Fill in the highlighted areas with your production data for a single shift. In some cases, you may have to convert units to simplify the calculation. For example, 3600 PPH (Pieces per Hour) is 60 PPM (Pieces per Minute).

Production Data Shift Length Short Breaks Meal Break Down Time Ideal Run Rate Total Pieces Reject Pieces

Hours = 0 Minutes Breaks @ Minutes Each = Breaks @ Minutes Each = Minutes PPM (Pieces Per Minute) Pieces Pieces

Variable Planned Production Time Operating Time Good Pieces

Calculation

OEE Factor Availability Performance Quality Overall OEE

Calculation Operating Time / Planned Production Time (Total Pieces / Operation Time) / Ideal Run Rate Good Pieces / Total Pieces Availability x Performance x Quality

OEE Factor Availability Performance Quality Overall OEE

Shift Length - Breaks Planned Production Time - Down Time Total Pieces - Reject Pieces

0 Minutes Total 0 Minutes Total

Result 0 Minutes 0 Minutes 0 Pieces

My OEE%

World My OEE Class % 90.00% 95.00% 99.90% 85.00%

World Class Overall OEE for discrete manufacturing plants is generally considered to be 85% or better. Studies indicate that the average Overall OEE score for discrete manufacturing plants is approximately 60%.

©2002-2005 Vorne Industries Inc., Itasca, IL USA ● (630) 875-3600 ● www.vorne.com ● www.oee.com

Calculating OEE Worksheet Fill in the highlighted areas with your production data for a single shift. In some cases, you may have to convert units to simplify the calculation. For example, 3600 PPH (Pieces per Hour) is 60 PPM (Pieces per Minute).

Production Data Shift Length Short Breaks Meal Break Down Time Ideal Run Rate Total Pieces Reject Pieces

8 2 1 47 60 19,271 423

Hours = 480 Minutes Breaks @ 15 Minutes Each = Breaks @ 30 Minutes Each = Minutes PPM (Pieces Per Minute) Pieces Pieces

30 Minutes Total 30 Minutes Total

Variable Planned Production Time Operating Time Good Pieces

Calculation

Result

Shift Length - Breaks Planned Production Time - Down Time Total Pieces - Reject Pieces

420 Minutes 373 Minutes 18,848 Pieces

OEE Factor Availability Performance Quality Overall OEE

Calculation Operating Time / Planned Production Time (Total Pieces / Operation Time) / Ideal Run Rate Good Pieces / Total Pieces Availability x Performance x Quality

OEE Factor Availability Performance Quality Overall OEE

My OEE% 88.81% 86.11% 97.80% 74.79%

World My OEE Class % 90.00% 88.81% 95.00% 86.11% 99.90% 97.80% 85.00% 74.79%

World Class Overall OEE for discrete manufacturing plants is generally considered to be 85% or better. Studies indicate that the average Overall OEE score for discrete manufacturing plants is approximately 60%.

©2002-2005 Vorne Industries Inc., Itasca, IL USA ● (630) 875-3600 ● www.vorne.com ● www.oee.com