Help Manual

Contents






Sigma Magic Help Version 15

OEE Analysis

Overview

Overall Equipment Efficiency (OEE) worksheet can be used to determine the effectiveness metric for the equipment. It calculates three ratios (Availability, Performance, and Quality). It then multiplies them together to get an overall effectiveness number called OEE. OEE numbers vary from 0% to 100% with a higher number indicating better equipment efficiency.

To add this template your workbook, click on Lean and then select OEE Metric.

Inputs

Click on Analysis Setup to open the menu options for this template.

Setup

A sample screenshot of the setup menu is shown below.
inputs
1
Area Name: Specify the name of the work area for which the OEE is being determined. This field is optional and can be left blank.
2
Equipment Name: Specify the name of the equipment for which the OEE is being determined. Note that both Area Name and Equipment Name cannot be blank.
3
Report Frequency: Specify the frequency of collection of data for the OEE. The available options are:
OptionDescription
DailyYou will need to enter daily numbers for the OEE on the worksheet.
WeeklyYou will need to report weekly numbers for the OEE on the worksheet.
MonthlyYou will need to report monthly numbers for the OEE on the worksheet.
4
Num Rows: Specify the number of rows to format the worksheet. Note that all data below these rows will be cleared.
5
Target OEE: Specify the target value of OEE. The default global benchmark for OEE is 85%. This information is just used to compare the actual OEE to a target value.
6
Highlight OEE: Specify if you want to highlight any rows on the worksheet. The default global benchmark for OEE is 85%, so you could choose to highlight all rows with less than this value. If you do not want to highlight any rows, enter 0%.
7
Help Button: Click on this button to open the help file on this topic.
8
Cancel Button: Click on this button to exit without saving any changes.
9
OK Button: Click on this button to save changes and update your analysis results.
Enter the following information on the worksheet:
  • Enter the date for which we want to calculate the OEE metric. If you have several pieces of equipment, then you could rename this column for equipment and enter different equipment numbers. This will give you the historical performance of the given equipment.
  • Enter the planned hours that you plan to use this equipment. For example, if you are planning to have a one-shift operation, then the plan hours could be 8.
  • Enter the number of hours the machine is not scheduled for production. For example, lunch breaks, tea breaks, etc. This could equal 1 hour. If the equipment works during Lunch and breaks, then enter 0 hours.
  • Enter the number of hours the equipment is down due to equipment problems. This is the unplanned downtime of the equipment. If the equipment is down several times in a day, then add up all the hours to report the total downtime. For example, if the equipment is down in the morning for 1/2 an hour and in the afternoon for 1/2 an hour, then you would report 1 hour as the downtime.
  • Enter the ideal output of the equipment. This is equal to the rate of production under ideal conditions times the number of hours the equipment runs. So, if the ideal rate of production is 4/hour and the equipment is producing for 7 hours, then the ideal output is 28.
  • Enter the actual output of the equipment - as measured at the end of the shift/day. For example, if you counted 20 pieces produced at the end of the day, then report 20.
  • Enter the first time right quantity. So, of the 20 that were produced if 1 of them required to rework and 2 of them were scrapped, then the first time right quantity = 17.

Charts

If you click on the Charts button, you will see the following dialog box. Charts
1
Title: The system will automatically pick a title for your chart. However, if you would like to override that with your own title you can specify a title for your chart here. Note that this input is optional.
2
Sub Title: The system will automatically pick a subtitle for your chart. However, if you would like to override that with your own subtitle you can specify a subtitle for your chart here. Note that this input is optional.
3
X Label: The system will automatically pick a label for the x-axis. However, if you would like to override that with your own label for the x-axis you can specify a different label here. Note that this input is optional.
4
Y Label: The system will automatically pick a label for the y-axis. However, if you would like to override that with your own label for the y-axis you can specify a different label here. Note that this input is optional.
5
X Axis: The system will automatically pick a scale for the x-axis. However, if you would like to override that with your values for the x-axis, you can specify them here. The format for this input is to specify the minimum, increment, and maximum values separated by a semi-colon. For example, if you specify 10;20 then the minimum x-axis scale is set at 10 and the maximum x-axis scale is set at 20. If you specify 10;2;20, then, in addition to minimum and maximum values, the x-axis increment is set at 2. Note that this input is currently disabled and you will not be able to change this setting.
6
Y Axis: The system will automatically pick a scale for the y-axis. However, if you would like to override that with your values for the y-axis, you can specify them here. The format for this input is to specify the minimum, increment, and maximum values separated by a semi-colon. For example, if you specify 10;20 then the minimum y-axis scale is set at 10 and the maximum y-axis scale is set at 20. If you specify 10;2;20, then, in addition to minimum and maximum values, the y-axis increment is set at 2. Note that this input is currently disabled and you will not be able to change this setting.
7
Horizontal Lines: If you want to add a few extra horizontal reference lines on top of your chart you can specify the values here. The format for this input is numeric values separated by semi-colon. For example, if you specify 12;15 then two horizontal lines are plotted at Y = 12 and Y = 15 respectively. Note that this input is optional.
8
Vertical Lines: If you want to add a few extra vertical reference lines on top of your chart you can specify the values here. The format for this input is numeric values separated by semi-colon. For example, if you specify 2;5 then two vertical lines are plotted at X = 2 and X = 5 respectively. Note that this input is optional.

Verify

If you click on the Verify button, the software will perform some checks on the data you have entered. A sample screenshot of the dialog box is shown in the figure below. Verify The objective of this analysis as well as any checks that are performed is listed in this dialog box. For example, the software may check if you have correctly specified the input options and entered the required data on the worksheet. The results of the analysis checks are listed on the right. If the checks are passed, then they are shown as a green-colored checkmark. If the verification checks fail, then they are shown as a red-colored cross. If the verification checks result in a warning, they are shown in the orange color exclamation mark and finally, any checks that are required to be performed by the user are shown as blue info icons.

Outputs

Click on Compute Outputs to update the output calculations. A sample screenshot of the worksheet is shown below. outputs The analysis reports the availability, performance, quality, and OEE metrics for each day that the information is entered into the worksheet. A graph of the variation of these metrics by day is also plotted as a time-series plot. This plot shows the trend of the OEE (if it is getting better or worse with time). Finally, the comments area shows the overall OEE metric for all data points put together. It also compares this metric with the benchmark metric of 85%.

Notes

Here are a few notes regarding this analysis:
  • Note that OEE numbers cannot exceed 100%. If you make a mistake in data entry then the software will let you know that and it will not calculate more than 100%.

Examples

Following examples can be found in the Examples folder within the software.
  • For the data given in the file, calculate the OEE metric (OEE 1.xlsm)