多次加工完成RUN RATE怎么分析

各位好
请问如何一个产品是两次加工而成（先注塑再分2次喷漆完成）请问怎么填？
1。合格产品数：是不是指从喷好漆后的一次合格产品（不包括返工合格品）？
2。产品周期：是不是指注塑周期 + 2次喷涂周期？
3。 一般情况上OEE为多少是比较合理的？

追加：
1。 如果是两位手工喷涂工一起做，那么下面2项应该写多少？
Percentage availability to Manufacture Component. (Dedicated Process = 100%)
2。这项产品周期是否要除以2？
Planned cycle time-the one used for capacity planning (seconds/part)
3。按下面的计算OEE》1，AJ项为负数肯定是不对的，请懂行的分析指导。

原表格如下：
Operating pattern and machine data: Process 3
A. Shifts/day 1.00
B. Hours/shift 12.00
C. Minutes/shift = B x 60 720.00
D. Percentage availability to Manufacture Component. (Dedicated Process = 100%) 100.00%
E. Total Minutes available per shift = C x D 720.00
F. Planned downtime: lunch, breaks (minutes/shift) Note: If tag relief is used, enter 0 60.00
G. Total planned production time/shift (minutes) = E - F 660.00
H. Total planned production time/day (minutes) = A x G 660.00
I. Days/week 6.00
J. Total planned production time/week (minutes) = H x I 3,960.00

Sample production run data: Process 3
K. Total minutes run 720.00
L. Total breakdown time + time for minor set-ups and adjustments (minutes) 60.00
M. Total number of parts made (good + bad) 528.00
N. Total good parts (first time through only- do not include parts that were re-processed or reworked) 400.00
O. Total bad parts = M - N 128.00
P. Actual cycle time (sec/part) = ((K - L)*60) / M 75.00

Other data: Process 3
Q. Planned cycle time-the one used for capacity planning (seconds/part) 150.00
R. Projected time per changeover (minutes) 10.00
S. Projected changeovers per shift 1.00
T. Projected downtime: changeover time/shift (minutes) = R x S 10.00
U. Projected downtime: (breakdown time+time for minor set-ups and adjustments)/shift (minutes) 55.00
V. Total projected unplanned downtime/day (minutes) = (T + U) x A 65.00

OEE calculation Process 1 Process 2 Process 3
W. Equipment Availability: = (H - V) / H 0.90
X. Performance Efficiency = Q / P 2.00
Y. Quality Rate: = N / M 0.76
Z. OEE: = W x X x Y 1.37

Capacity analysis Process 1 Process 2 Process 3
AA. Planned uptime (hours/day) = H / 60 11.00
AB. Planned uptime (days/week) = I 6.00
AC. Planned rate of production (parts/minute) = 60 / Q 0.40
AD. Theoretical production capacity per day = AA x 60 x AC 264.00
AE. Theoretical production capacity per week = AD x Z 1,584.00
AF. Weekly Demand 4,807.00
AG. Weekly Parts Available for Shipment = AE x Z 2,163.64
AH. Daily Demand (DPV) = AF / AB 801.17
AI. Daily Parts Available for Shipment = AD x Z 360.61
AJ. Percent above/below DPV = (AI - AH) / AH -54.99%

Percent above/below DPV for bottleneck operation (Minimum value of AH) : -54.99%