Understanding the GainSeeker Kit for OEE

The OEE (Overall Equipment Effectiveness) Kit in the GainSeeker Platform Library includes a sample data set. This sample data set includes a collection of installable GainSeeker Inspections, Dashboards, Desktops, Retrievals and other tools that users can adapt their specific situation. This page provides detailed notes on the design assumptions used in implementing these tools.

Assumptions

Here are the assumptions that we made when developing the sample data set:

The kit provides for manual data entry only. It does not integrate with other business systems, or harvest data from devices.
We assume that one operator has all the information needed in one place and can complete the data entry for all aspects of OEE at one time.
We are not tracking breaks or lunches.
Product cycles at a rate of 1100 units produced per hour.
This plant has several operators on two shifts.
Shifts are 12 hours long.
Each plant has two lines, and makes two core products.
There are two plants
Users roll up data by Operator, Line, and Plant.
Downtime reasons are stored as defects assigned to a machine.

Data Structure

To implement sample solutions that met these assumptions, the OEE Kit structures the GainSeeker database as follows:

GainSeeker Defect System Field	Setting	Notes
Quality Process	“Molding”	Typical defects include “Bad Part”, “Broken”, “Crack”, “Damaged”, “Heavy”, “Loose” Part Standards include 20 OZ and 2L
Downtime Process	“OEE”	Typical defects include “Changeover”, “Lack of raw material”, “Machine Issue”, “Startup” Part Standards include 20 OZ and 2L
Trace 1 =		Trace 1 is not used.
Trace 2 = Shift	1, 2	Assume two 12-hour shifts.
Trace 3 = Work Center	A, B
Trace 4 = Machine Number	250, 251, 350, 351	Machines 250 and 350 are for the Main Plant. Machines 251 and 351 are for the Springfield Plant.
Trace 5 = Plant	Main, Springfield
Trace 6 = Operator
Trace 7 = Inspection Page
Trace 8 = Inspection Test Name
Trace 9 = Available Time		OEE Required Trace Field. Scheduled time – Downtime
Trace 10 = Scheduled Time		OEE Required Trace Field. For this data set, we assume a 12 hour shift with no scheduled downtime, or 720 minutes of Available Time.
Trace 11 = Good Parts		OEE Required Trace Field. Total parts – defective parts.
Trace 12 = Total Parts		OEE Required Trace Field. Total parts produced.
Trace 13 = Ideal Cycle Time	Target = 0.055 min/part	OEE Required Trace Field. For this sample data set we assume a target of 1100 parts per hour.
Trace 14 = GUID		The GUID (Global Unique Indentifier) is a hidden value that uniquely identifies each record. It is used to update the availability record so that all OEE data is in one record.

Understanding the GainSeeker Kit for OEE