Difference between revisions of "How to Set Target for OEE"

From 42Q
Jump to navigation Jump to search
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
  
  
−
= <span class="mw-headline" id="Introduction">Introduction&nbsp;</span> =
 
  
−
This document is about how to set the target for OEE, and includes:
+
= <span class="mw-headline" id="Introduction"><span class="mw-headline" id="Introduction">Summary&nbsp;</span></span> =
  
−
*The target fields table and how to define the target value in the system.  
+
This document is about how to set the target for OEE and includes:
−
*Which OEE Modules or pages will be impacted once the fields are updated.
+
 
 +
*The target fields table shows how to define the target value in the system.  
 +
*Which OEE Modules or pages will be impacted once the fields are updated?
  
 
&nbsp;
 
&nbsp;
  
  
−
= <span class="mw-headline" id="Target_Fields"><span class="mw-headline" id="Target_Fields">Target Fields&nbsp;</span></span> =
+
= <span class="mw-headline" id="Target_Fields"><span class="mw-headline" id="Target_Fields"><span class="mw-headline" id="Target_Fields">Target Fields&nbsp;</span></span></span> =
  
−
&nbsp; For OEE, the users need to configure two tables (SOMS_Target, OEE_Target) with the target values for OEE, in the module Target Maintenance. &nbsp;
+
&nbsp;For OEE, the users need to configure two tables (SOMS_Target, OEE_Target) with the target values for OEE, in the module Target Maintenance. &nbsp;
  
 
*'''SOMS_Target '''table  
 
*'''SOMS_Target '''table  
  
−
&nbsp; '''Figure 1: SOMS Target Fields'''
+
&nbsp;
 +
 
 +
'''Figure 1: SOMS Target Fields'''
  
 
[[File:SOMS Target csv.png|border|700px|SOMS Target csv.png]]
 
[[File:SOMS Target csv.png|border|700px|SOMS Target csv.png]]
Line 23: Line 26:
 
*'''OEE_Target''' table  
 
*'''OEE_Target''' table  
  
−
&nbsp; '''Figure 2: OEE Target Fields'''
+
&nbsp;
 +
 
 +
'''Figure 2: OEE Target Fields'''
  
 
'''[[File:OEE Target csv.png|border|700px|OEE Target csv.png]]'''
 
'''[[File:OEE Target csv.png|border|700px|OEE Target csv.png]]'''
Line 29: Line 34:
 
&nbsp;
 
&nbsp;
  
−
== <span class="mw-headline" id="SOMS_Target"><span class="mw-headline" id="SOMS_Target">SOMS_Target</span></span> ==
+
== <span class="mw-headline" id="SOMS_Target"><span class="mw-headline" id="SOMS_Target"><span class="mw-headline" id="SOMS_Target">SOMS_Target</span></span></span> ==
  
−
&nbsp; The OEE features that require the values of the SOMS Target fields are: &nbsp;
+
&nbsp;The OEE features that require the values of the SOMS Target fields are: &nbsp;
  
 
&nbsp;(1) '''OEE Performance''' value for target qty = TargetTPhr * duration:
 
&nbsp;(1) '''OEE Performance''' value for target qty = TargetTPhr * duration:
Line 40: Line 45:
  
 
'''Soms_target fields''': Part Number, Workstation or Process or MFG Line, TargetHPU &nbsp;
 
'''Soms_target fields''': Part Number, Workstation or Process or MFG Line, TargetHPU &nbsp;
 +
 +
&nbsp;
  
 
'''Figure 3: SOMS Target Example''' &nbsp; &nbsp;
 
'''Figure 3: SOMS Target Example''' &nbsp; &nbsp;
  
−
[[File:Soms.png|border|700px]] &nbsp;
+
[[File:Soms.png|border|700px|Soms.png]] &nbsp;
  
−
<u>'''Note'''</u>: Please visit the [https://42qrpt1.42-q.com/mes_wiki/index.php/42Q-MES0136-C_OEE_Configuration#SOMS_Target:_Define_Target OEE Configuration(target maintenance section) ]to see the priorities for the fields about part number/process/workstation. &nbsp;
+
&nbsp;
 +
 
 +
<u>'''Note'''</u>: Please visit the [https://42qrpt1.42-q.com/mes_wiki/index.php/42Q-MES0136-C_OEE_Configuration#SOMS_Target:_Define_Target OEE Configuration(target maintenance section) ]to see the priorities for the fields related to part number/process/workstation. &nbsp;
  
 
&nbsp;
 
&nbsp;
  
−
== <span class="mw-headline" id="OEE_Target"><span class="mw-headline" id="OEE_Target">OEE_Target</span></span> ==
+
== <span class="mw-headline" id="OEE_Target"><span class="mw-headline" id="OEE_Target"><span class="mw-headline" id="OEE_Target">OEE_Target</span></span></span> ==
  
−
&nbsp; The OEE features that require the values of the OEE Target fields are: &nbsp;
+
&nbsp;The OEE features that require the values of the OEE Target fields are: &nbsp;
  
 
&nbsp;(1) '''42Q Live/Operation Dashboard/OEE Dashboard '''to identify the OEE health status, such as Green, Yellow, Red.
 
&nbsp;(1) '''42Q Live/Operation Dashboard/OEE Dashboard '''to identify the OEE health status, such as Green, Yellow, Red.
Line 61: Line 70:
 
'''Figure 4: OEE Target Example''' &nbsp; &nbsp;
 
'''Figure 4: OEE Target Example''' &nbsp; &nbsp;
  
−
[[File:Oee target.png|border|700px]]
+
[[File:Oee target.png|border|700px|Oee target.png]]
  
 
= Steps and Details =
 
= Steps and Details =
 
&nbsp;  
 
&nbsp;  
−
== Configure data in Shop Floor Configuration ==
 
  
−
The users need to configure Location/Process/MFG Line/Part Number/Family/Route in the Shop Floor Control Module.
+
== <span class="mw-headline" id="Configure_data_in_Shop_Floor_Configuration">Configure data in Shop Floor Configuration</span> ==
 +
 
 +
The users need to configure Location/Process/MFG Line/Part Number/Family/Route in the '''Shop Floor Control '''Module.
  
 
Navigate to Shop Floor Control > Configuration > Shop Floor Configuration, to configure the necessary data.&nbsp;
 
Navigate to Shop Floor Control > Configuration > Shop Floor Configuration, to configure the necessary data.&nbsp;
  
−
*
+
*'''Location'''
−
Location
+
*'''Process'''
 +
*'''MFG Line'''
 +
*'''Part Number/Family'''
 +
*'''Route'''
  
−
*
+
&nbsp; Please visit the&nbsp; [https://42qrpt1.42-q.com/mes_wiki/index.php/SOP-42Q-MES0007_Location_Maintenance Location], [https://42qrpt1.42-q.com/mes_wiki/index.php/SOP-42Q-MES0009_Mfg_Line_Maintenance MFG Line], [https://42qrpt1.42-q.com/mes_wiki/index.php/SOP-42Q-MES0011_Part_Number_Maintenance Part Number], [https://42qrpt1.42-q.com/mes_wiki/index.php/SOP-42Q-MES0012_Product_Route_Maintenance Route]&nbsp; for more information. &nbsp;
−
Process
 
  
−
*
 
−
MFG Line
 
  
−
*
+
== <span class="mw-headline" id="Configure_Target"><span class="mw-headline" id="Configure_Target">Configure Target</span></span> ==
−
Part Number/Family
 
  
−
*
+
Navigate to '''Shop Floor Control > Configuration > Target Maintenance''', to configure the SOMS target and OEE target. &nbsp;
−
Route
 
  
−
&nbsp;
+
If it is the first time to set the Target value and do not have the table, the users can create the soms_target tables and the OEE_Target tables by importing the SOMS_Target and OEE_Target .csv file: &nbsp;
−
Please visit the&nbsp; [https://42qrpt1.42-q.com/mes_wiki/index.php/SOP-42Q-MES0007_Location_Maintenance Location], [https://42qrpt1.42-q.com/mes_wiki/index.php/SOP-42Q-MES0009_Mfg_Line_Maintenance MFG Line], [https://42qrpt1.42-q.com/mes_wiki/index.php/SOP-42Q-MES0011_Part_Number_Maintenance Part Number], [https://42qrpt1.42-q.com/mes_wiki/index.php/SOP-42Q-MES0012_Product_Route_Maintenance Route]&nbsp; for more information.
 
−
&nbsp;  
 
−
== Configure Target ==
 
  
−
Navigate to '''Shop Floor Control > Configuration > Target Maintenance''', to configure the SOMS target and OEE target.
+
#At the '''Target Maintenance''' page, select the + Icon to open the '''Target Form''' sub-page.  
−
&nbsp;
+
#Input the '''Target Name'''.
−
If it is the first time to set the Target value and do not have the table, the users can create the soms_target tables and the OEE_Target tables by importing the SOMS_Target and OEE_Target .csv file:
+
#Select the '''Select…''' to open the prepared file with the target values.  
−
&nbsp;
+
#Select Save to import the target table with target values.  
−
#
 
−
At the Target Maintenance page, select the + Icon to open the Target Form sub-page.
 
  
−
#
+
<br/> '''Figure 5: Create Target Table'''
−
Input the Target Name.
 
  
−
#
+
[[File:Create target table.png|border|700px|Create target table.png]]&nbsp;<br/> <br/> &nbsp; If you already have the two tables, you just need to search and open them, then add/delete/update one or more columns/lines. Here is an example for adding one target line.
−
Select the Select… to open the prepared file with the target values.
 
  
−
#
+
#At the '''Target Maintenance''' page, enter the target name in the '''Target Name''' field, then select '''Filter''' to search your existing target table.
−
Select Save to import the target table with target values.
+
#Double-click on the Target name field to open the target table.
 +
#Select '''Create''' line, there will be a new line in the bottom.
 +
#Enter the values for the needed fields then select Save Tab.
 +
#The new target line will be saved into the system.  
  
−
<br/>
+
&nbsp; '''Figure 6: Search the Target table'''
−
'''Figure 5: Create Target Table'''
 
  
−
&nbsp;
+
'''[[File:Search targe table.png|border|700px|Search targe table.png]]'''
−
<br/> <br/> &nbsp;
 
−
If you already have the two tables, you just need to search and open them, then add/delete/update one or more columns/lines. Here is an example for adding one target line.
 
−
<br/>
 
−
#
 
−
At the Target Maintenance page, enter the target name in the Target Name field, then select Filter to search your existing target table.
 
  
−
#
+
&nbsp; '''Figure 7: Create Target Line'''
−
Double-click on the Target name field to open the target table.
 
  
−
#
+
'''[[File:Create target line.png|border|700px|Create target line.png]]'''
−
Select Create line, there will be a new line in the bottom.
 
  
−
#
+
&nbsp;<br/> Please visit the [https://42qrpt1.42-q.com/mes_wiki/index.php/SOP-MES0084_Target_Maintenance Target Maintenance] for more information. &nbsp;
−
Enter the values for the needed fields then select Save Tab.
 
  
−
#
 
−
The new target line will be saved into the system.
 
  
−
&nbsp;
+
= <span class="mw-headline" id="Effects_of_these_fields:"><span class="mw-headline" id="Effects_of_these_fields:">Effects of these fields:</span></span> =
−
'''Figure 6: Search the Target table'''
 
  
 
&nbsp;
 
&nbsp;
−
&nbsp;
 
−
'''Figure 7: Create Target Line'''
 
  
−
&nbsp;
+
*'''SOMS_Target effects'''
−
<br/>
 
−
Please visit the [https://42qrpt1.42-q.com/mes_wiki/index.php/SOP-MES0084_Target_Maintenance Target Maintenance] for more information.
 
−
&nbsp;
 
−
= Effects of these fields: =
 
−
&nbsp;
 
−
*
 
−
SOMS_Target effects
 
  
 +
The fields '''TargetHPU''', '''TargetTPhr''' defined in the SOMS_Target table will affect items in the '''OEE Data Collection''' and the '''OEE Workbench''' modules. &nbsp;
  
 
&nbsp;
 
&nbsp;
  
−
The fields TargetHPU, TargetTPhr defined in the SOMS_Target table will affect items in the OEE Data Collection and the OEE Workbench modules.
+
== <span class="mw-headline" id="OEE_Data_Collection"><span class="mw-headline" id="OEE_Data_Collection">OEE Data Collection</span></span> ==
−
&nbsp;  
+
 
−
#
+
&nbsp; In the '''OEE Data Collection '''module to report a new asset event, when users enter/select the Asset, Asset Status(Running), Location, Shop Order, Part Number, Start Time, End Time, then the '''Target UPH/Target QTY''' will be filled automatically. &nbsp;
−
== OEE Data Collection ==
 
  
−
&nbsp;
 
−
In the OEE Data Collection module to report a new asset event, when users enter/select the Asset, Asset Status(Running), Location, Shop Order, Part Number, Start Time, End Time, then the Target UPH/Target QTY will be filled automatically.
 
−
&nbsp;
 
 
'''Figure 8: OEE Data Collection Report Asset Event'''
 
'''Figure 8: OEE Data Collection Report Asset Event'''
  
−
&nbsp;
+
[[File:OEE Data collection33.png|border|OEE Data collection33.png]]
−
&nbsp;  
+
 
−
OEE Performance = Finished QTY / Target QTY
+
&nbsp; &nbsp; OEE Performance = Finished QTY / Target QTY
  
 
Target QTY = TargetTPhr * duration
 
Target QTY = TargetTPhr * duration
Line 166: Line 146:
 
TargetTPhr = TargetUPH = Target Unit Per Hour
 
TargetTPhr = TargetUPH = Target Unit Per Hour
  
−
duration = End Time - Start Time
+
duration = End Time - Start Time &nbsp;
−
&nbsp;  
 
−
== OEE Workbench ==
 
  
−
In the OEE Workbench/PWB module, the progress bar will be in different colors according to the TargetHPU.
 
−
<br/> <br/> &nbsp;
 
−
*
 
−
TargetHPU = TargetHourPerUnit&nbsp;
 
  
−
**
+
== <span class="mw-headline" id="OEE_Workbench"><span class="mw-headline" id="OEE_Workbench"><span class="mw-headline" id="OEE_Workbench">OEE Workbench</span></span></span> ==
−
The progress bar will be displayed like the below pic.
 
  
−
**
+
In the '''OEE Workbench/PWB''' module, the progress bar will be in different colors according to the TargetHPU.<br/> <br/> &nbsp;
−
0-->50%: GREEN | 50-->99%: ORANGE | 99% or more: RED
 
−
 
 
−
<br/>
 
−
'''Figure 9: OEE Workbench Progress bar'''
 
  
−
&nbsp;
+
*'''TargetHPU''' = TargetHourPerUnit&nbsp;  
−
&nbsp;
+
**The progress bar will be displayed like the below pic.
−
*
+
**0-->50%: <span style="color:#1abc9c;">GREEN</span> | 50-->99%: <span style="color:#f39c12;">ORANGE</span> | 99% or more: <span style="color:#e74c3c;">RED</span> 
−
OEE_Target effects
 
  
−
**
+
<br/> '''Figure 9: OEE Workbench Progress bar'''
−
Asset Name
 
  
−
**
+
[[File:Workbench progress bar.png|border|700px]]&nbsp; &nbsp;
−
OEE/OEE Yellow; TEEP/TEEP Yellow; A/A Yellow; P/P Yellow; Q/Q Yellow; Level; Coordinates; Site; U/U Yellow
 
  
−
**
+
*'''OEE_Target effects'''
−
Target MTTR; Target MTBF
+
**Asset Name
−
    
+
**OEE/OEE Yellow; TEEP/TEEP Yellow; A/A Yellow; P/P Yellow; Q/Q Yellow; Level; Coordinates; Site; U/U Yellow
 +
**Target MTTR; Target MTBF   
  
 
&nbsp;
 
&nbsp;
  
−
== MTBF and MTTR Report ==
+
== <span class="mw-headline" id="MTBF_and_MTTR_Report"><span class="mw-headline" id="MTBF_and_MTTR_Report">MTBF and MTTR Report</span></span> ==
  
 
The fields Target MTTR and Target MTBF defined in the OEE_Target table will affect the MTBF And MTTR Report.
 
The fields Target MTTR and Target MTBF defined in the OEE_Target table will affect the MTBF And MTTR Report.
Line 209: Line 176:
 
'''Figure 10: MTBF and MTTR Report'''
 
'''Figure 10: MTBF and MTTR Report'''
  
−
&nbsp;
+
[[File:MTBF and MTTR Report.png|border|700px|MTBF and MTTR Report.png]]&nbsp; &nbsp;
−
&nbsp;  
+
 
−
== 42Q Live/OEE Dashboard&nbsp; ==
+
 
−
&nbsp;
+
== <span class="mw-headline" id="42Q_Live.2FOEE_Dashboard"><span class="mw-headline" id="42Q_Live.2FOEE_Dashboard"><span class="mw-headline" id="42Q_Live.2FOEE_Dashboard">42Q Live/OEE Dashboard&nbsp;</span></span></span> ==
−
The fields Asset Name, OEE, OEE Yellow, TEEP, TEEP Yellow, A, A Yellow, P, P Yellow, Level, Coordinates, Site, Asset Type defined in the OEE_Target table will affect the 42Q Live/Operation Dashboard/OEE Dashboard to identify the OEE health status, such as Green, Yellow, Red.
+
 
 +
The fields '''Asset Name, OEE, OEE Yellow, TEEP, TEEP Yellow, A, A Yellow, P, P Yellow, Level, Coordinates, Site, Asset Type'''
 +
 
 +
defined in the OEE_Target table will affect the 42Q Live/Operation Dashboard/OEE Dashboard to identify the OEE health status, such as Green, Yellow, and Red.
  
 
&nbsp;
 
&nbsp;
  
 
'''Figure 11: 42Q Live'''
 
'''Figure 11: 42Q Live'''
 +
 +
[[File:42Q Live.png|border|700px|42Q Live.png]]
 +
 +
&nbsp;<br/> <br/> &nbsp; '''Figure 12: OEE Dashboard''' &nbsp; &nbsp;<br/> [[File:OEE dashboard.png|border|700px|OEE dashboard.png]]
  
 
&nbsp;
 
&nbsp;
 +
 +
----
  
 
&nbsp;
 
&nbsp;
−
<br/> <br/> &nbsp;
 
−
'''Figure 12: OEE Dashboard'''
 
−
&nbsp;
 
−
&nbsp;
 
−
<br/> &nbsp;
 

Latest revision as of 14:18, 24 October 2024


Summary 

This document is about how to set the target for OEE and includes:

  • The target fields table shows how to define the target value in the system.
  • Which OEE Modules or pages will be impacted once the fields are updated?

 


Target Fields 

 For OEE, the users need to configure two tables (SOMS_Target, OEE_Target) with the target values for OEE, in the module Target Maintenance.  

  • SOMS_Target table

 

Figure 1: SOMS Target Fields

SOMS Target csv.png

  • OEE_Target table

 

Figure 2: OEE Target Fields

OEE Target csv.png

 

SOMS_Target

 The OEE features that require the values of the SOMS Target fields are:  

 (1) OEE Performance value for target qty = TargetTPhr * duration:

   Soms_target fields: Part Number/Family, TargetTPhr, Workstation/Process/MFG Line/Asset

(2) OEE Workbench to get Target:

Soms_target fields: Part Number, Workstation or Process or MFG Line, TargetHPU  

 

Figure 3: SOMS Target Example    

Soms.png  

 

Note: Please visit the OEE Configuration(target maintenance section) to see the priorities for the fields related to part number/process/workstation.  

 

OEE_Target

 The OEE features that require the values of the OEE Target fields are:  

 (1) 42Q Live/Operation Dashboard/OEE Dashboard to identify the OEE health status, such as Green, Yellow, Red.

OEE_Target fields: Asset Name, OEE, OEE Yellow, TEEP, TEEP Yellow, A, A Yellow, P, P Yellow, Level, Coordinates, Site, Asset Type fields. 

  (2) MTBF And MTTR Report: 
 

Figure 4: OEE Target Example    

Oee target.png

Steps and Details

 

Configure data in Shop Floor Configuration

The users need to configure Location/Process/MFG Line/Part Number/Family/Route in the Shop Floor Control Module.

Navigate to Shop Floor Control > Configuration > Shop Floor Configuration, to configure the necessary data. 

  • Location
  • Process
  • MFG Line
  • Part Number/Family
  • Route

  Please visit the  Location, MFG Line, Part Number, Route  for more information.  


Configure Target

Navigate to Shop Floor Control > Configuration > Target Maintenance, to configure the SOMS target and OEE target.  

If it is the first time to set the Target value and do not have the table, the users can create the soms_target tables and the OEE_Target tables by importing the SOMS_Target and OEE_Target .csv file:  

  1. At the Target Maintenance page, select the + Icon to open the Target Form sub-page.
  2. Input the Target Name.
  3. Select the Select… to open the prepared file with the target values.
  4. Select Save to import the target table with target values.


Figure 5: Create Target Table

Create target table.png 

  If you already have the two tables, you just need to search and open them, then add/delete/update one or more columns/lines. Here is an example for adding one target line.

  1. At the Target Maintenance page, enter the target name in the Target Name field, then select Filter to search your existing target table.
  2. Double-click on the Target name field to open the target table.
  3. Select Create line, there will be a new line in the bottom.
  4. Enter the values for the needed fields then select Save Tab.
  5. The new target line will be saved into the system.

  Figure 6: Search the Target table

Search targe table.png

  Figure 7: Create Target Line

Create target line.png

 
Please visit the Target Maintenance for more information.  


Effects of these fields:

 

  • SOMS_Target effects

The fields TargetHPU, TargetTPhr defined in the SOMS_Target table will affect items in the OEE Data Collection and the OEE Workbench modules.  

 

OEE Data Collection

  In the OEE Data Collection module to report a new asset event, when users enter/select the Asset, Asset Status(Running), Location, Shop Order, Part Number, Start Time, End Time, then the Target UPH/Target QTY will be filled automatically.  

Figure 8: OEE Data Collection Report Asset Event

OEE Data collection33.png

    OEE Performance = Finished QTY / Target QTY

Target QTY = TargetTPhr * duration

TargetTPhr = TargetUPH = Target Unit Per Hour

duration = End Time - Start Time  


OEE Workbench

In the OEE Workbench/PWB module, the progress bar will be in different colors according to the TargetHPU.

 

  • TargetHPU = TargetHourPerUnit 
    • The progress bar will be displayed like the below pic.
    • 0-->50%: GREEN | 50-->99%: ORANGE | 99% or more: RED


Figure 9: OEE Workbench Progress bar

Workbench progress bar.png   

  • OEE_Target effects
    • Asset Name
    • OEE/OEE Yellow; TEEP/TEEP Yellow; A/A Yellow; P/P Yellow; Q/Q Yellow; Level; Coordinates; Site; U/U Yellow
    • Target MTTR; Target MTBF

 

MTBF and MTTR Report

The fields Target MTTR and Target MTBF defined in the OEE_Target table will affect the MTBF And MTTR Report.

 

Figure 10: MTBF and MTTR Report

MTBF and MTTR Report.png   


42Q Live/OEE Dashboard 

The fields Asset Name, OEE, OEE Yellow, TEEP, TEEP Yellow, A, A Yellow, P, P Yellow, Level, Coordinates, Site, Asset Type

defined in the OEE_Target table will affect the 42Q Live/Operation Dashboard/OEE Dashboard to identify the OEE health status, such as Green, Yellow, and Red.

 

Figure 11: 42Q Live

42Q Live.png

 

  Figure 12: OEE Dashboard    
OEE dashboard.png

 

 

Retrieved from "https://42qrpt1.42-q.com/mes_wiki/index.php?title=How_to_Set_Target_for_OEE&oldid=51806"