Resource OEE DWH#

Description#

• This report provides information about how the OEE for a resource. OEE stands for Overall Equipment Efficiency. OEE offers a measurement mechanism to evaluate equipment corrective action methods and ensure permanent productivity improvement. A Pareto Chart can be generated as well

Data Source#

• DWH Database

Assumptions#

• Calendar Days must have been generated for the Calendars of the relevant Areas.
• Each state of the Resource that wants to be reported via SEMI E10 has an attribute that contains the SEMI E10 mapped state:
  • Engineering - (Mandatory to map for this report)
  • Productive - (Mandatory to map for this report)
  • Standby
  • UnscheduledDown
  • ScheduledDown
  • NonScheduled

Filters#

• Facility - Multi value filter on facilities
• Area - Multi value filter on Areas (restricted by the Facility filter)
• Shift - Multi value filter on Shifts (restricted by Area)
• Resource Type - Multi value filter on Resource Types
• Model - Multi value filter on Resource Model
• Resource - Multi value filter on Resources (restricted by Facility, Area, Resource Type and Model)
• Date Start - defines the start time threshold filter for resources shift dates (date in DWH is set based on the active shift (or no shift if not defined) at the moment of the fact)
• Date End - defines the end time threshold filter for resources shift dates (date in DWH is set based on the active shift (or no shift if not defined) at the moment of the fact)
• Expand All Items - true or false
• Show Chart - true or false

Fields#

• Resource Facility
• Resource Area
• Resource Type
• Resource Model
• Resource Name
• Date From
• Date To

Quick description of the concepts used in the formulas below:

• Net Production Time - Sum of Production and Engineering times.
• Total Productive State Time - All Production time for the Resource, including Rework and Engineering.
• Resource Operational Uptime - Total Productive State Time including Standby time.
• Units Produced - Material TrackIn quantity at TrackOut during the period.
• Down Time - Sum of Scheduled down time and Unscheduled down time.

• Actual Cycle Time = \(\frac{Net\: Production\: Time}{Units\: Produced\: }\)

• Rate Efficiency (%) = \(100\%\: \times\: \frac{Ideal\: Cycle\: Time}{Actual\: Cycle\: Time}\)

• Operational Efficiency (%) = \(100\%\: \times\: \frac{Total\: Productive\: State\: Time}{Resource\: Operational\: Uptime}\)

• Availability (%) = \(100\%\: \times\: \frac{Total\: Time\: -\: (Down\: Time\: +\: NonScheduled\: time)}{Total\: Time}\)

• Performance Efficiency (%) = \(Rate\: Efficiency\: \times\: Operational\: Efficiency\)

• Rate of Quality (%) = \(100\%\: \times\: \frac{Quantity\: Processed\: -\: Rejects}{Quantity\: Processed}\)

• OEE (%) = \(Availability\: \times\: Performance\: Efficiency\:\times\: Rate\: of\: Quality\)

Additional Information#

When calculating the OEE, the system applies the following rules:

• If a Track-Out crosses multiple shifts, the quantity is divided proportionally to the time spent at each shift. The same principle applies to losses and bonuses. The processed quantity is only considered at the Track-Out time and the system considers the processed quantity as the Track-In Primary Quantity + Sub-Materials Primary Quantity.
• Only losses and bonuses related with the Primary Quantity are considered.
• To avoid double-counting, either the Track-In of the top-most Material is considered (in case that there is no Sub-Material track-in); or the Sub-Materials are considered (in case that sub track-in is enabled) and not the top-most.
• Because multiple products with different cycle times can be processed in the same period, the system normalizes the ideal cycle times using a simple rule of three method. For example, if Resource A can produce 1 product A1 in 1000 seconds, and 1 product A2 in 2000 seconds; in a 86400 seconds day, the ideal production would be 86.4 units of Product A1. If in the same day, both products A1 and A2 would be produced, their quantities should be normalized to A1 and A2 * 2
• OEE calculation will consider the dimensions Resource, {Date}, {ShiftDate , Shift}, {Date , Shift}. Adding a Product, Step or any other dimension to the filter/grouping would generate wrong values as the ideal and real quantities would be incorrect.
• When calculating Availability, Rate Efficiency and Operational Efficiency, the Non-Working Times are not accounted for if the Resource property Can Work in Non-Working Time is false.

Example#