OTE Performance Dashboard by Shift Calculation
Creation date: 5/30/2025 4:23 AM
Updated: 6/3/2025 5:05 AM
Figure 1.0
The Hourly Target & Shift Target will be come from Product Setup 2 new fields at Performance Related Tab refer figure 1.1
Figure 1.1
Shift Qty (pcs): Quantity completed during current shift.
Required Headcount & Actual Headcount refer figure 1.2
Figure 1.2
Overall SFC Performance
Qty Produced (pcs): total quantity completed
For support only:
select * from DataWarehouseYieldProduction with(nolock) where WorkOrderId = 150997 and OperationId = 261 and IsOperationFirstTransaction = 1
Sum of [QuantityCompleted]
First Pass Yield (%): total quantity passed / total quantity completed
For support only:
select * from DataWarehouseYieldProduction with(nolock) where WorkOrderId = 150997 and OperationId = 261 and IsOperationFirstTransaction = 1
Sum of [QuantityPassed] / Sum of [QuantityCompleted]
RTY (%): Refer attached RTY sample.xlsx sheet 2
For support only:
SELECT OperationId,SUM(QuantityCompleted) AS QuantityCompleted, SUM(QuantityPassed) As QuatityPassed
FROM DataWarehouseYieldProduction WITH (NOLOCK)WHERE WorkOrderId = 150997 AND IsOperationFirstTransaction = 1
GROUP BY OperationId;
Calculation of Circular Progress CHART
Quality chart
Figure 1.2 is calculated from table attached below (multiplication of all quality)
(0.9905*0.9885*0.9807) * 100
Availability chart
Figure 1.3 is calculated from table attached below (average of availability)
(1+0.9979+1)/3 * 100
Performance chart
Figure 1.4 Performance chart will be retrieve last operation form table below
OTE Chart
Figure 1.5 is calculated by multiplication of 3 charts on the left (0.9602 * 0.9993 * 0.8781) * 100
Action required: User & Support
DataImage4.png
DataImage48.png
DataImage97.png
DataImage80.png
RTY Sample.xlsx
DataImage85.png
DataImage59.png
DataImage85[1].png
DataImage27.png
DataImage60.png
DataImage54.png
DataImage45.png
DataImage37.png
DataImage17.png
DataImage32.png