E8.12 Determination of the Yield per Work Order

[cekay90]

Hello all,

I am not a developer and I don't have access to the JDE programs. I only have access to the raw tables from our Oracle DB.
My goal is to determine the planned yield per work order for the last years. This value recorded in the OPYP column in the F3003 per item and work center / work step. In the column CPYP you can find the cumulative Yield.
With the help of OPYP I can now determine (multiplication of all work steps and the planned yield) how much yield was planned.
Fortunately, the Routing Master F3003 also contains historical values. This means that work steps that are no longer active, but are of interest to me, can be included.
My question is, is there a standard report/ SQL which can tell me how much yield was planned per Work Order (F4801)?
Or is there a column/ table where this is listed per Work Order? We do not have the URAB column.


I am grateful for any tip!

 

[Larry_Jones]

Maybe this will help

Shrink​

Shrink is defined in the Additional System Information in the Item Branch/Plant record (P41026 table F4102) and is functional only if it is defined on the parent item. Shrink will not affect the parts list quantity if it is defined on the component item.
This is the first calculation used when adding additional items to the part list to compensate for shrinkage for the parent item.
Example-
Parent item defined with 20% Shrink
Bill of Material: Component A - 1 each
Component B - 2 each
Work Order quantity = 100
Parts list calculations: Component A - 100 * 1.2 = 120 each
Component B - 200 * 1.2 = 240 each

Using a shrink factor for a manufactured item is allowed and is therefore supported but it isn’t recommended for manufactured items because the extra component quantity that will be issued to a work order won’t be part of the standard cost (shrink isn’t included in a cost rollup). As such, work orders for these items will always generate a material (A1) variance. Instead of a shrink factor, component requirements can be inflated on the standard BOM (% of scrap) for each item, and/or parts and labor can be inflated by operation on the standard routing (yield % <100) and rolled up cost will accurately reflect the expected extra cost.

---

Scrap Percent​

Scrap Percent is defined in the bill of materials (BOM) (P3002 / F3002) for the individual components of the parent item. The percentage is in whole numbers, i.e., 20% scrap is 20, not .20

Example-
Bill of Material: Component A - 1 each (20% Scrap)
Component B - 1 each (15% Scrap)
Work Order quantity = 100
Parts list calculation: Component A - 100 * 1.2 = 120 each
Component B - 100 * 1.15 = 115 each

---

Operation Yield​

This calculation is defined in the routing (P3003 / F3003). The yield percentage is defined for each operation. The system then calculates additional material and labor to complete the required quantity on the work order.

Operation Step	Operational Yield %	Cumulative Yield %	Operation Scrap %
40​	80 %​	80 %​	(100 % / 80 %) - 100 % = 25 %​
30​	90 %​	80 % * 90% = 72 %​	(100 % / 72 %) - 100 % = 38.89 %​
20​	100 %​	72 % * 100% = 72 %​	(100 % / 72 %) - 100 % = 38.89 %​
10​	95 %​	72 % * 95 % = 68.4 %​	(100 % / 68 %) - 100 % = 46.2 %​

The calculations begin from the last operation and calculate back to the first.

Operation Yield % - This value is entered into the routing and represents the Planned Output Yield Percent for the operation step.

Cumulative Yield % - The system updates the Cumulative Planned Yield Percent on the routing.

The system uses this value to increase or decrease the amount of labor hours needed to make up for loss within the operation. In this example, only 68.4% of the product that goes through step 10 will make it to finished goods.

Operation Scrap % - The system updates the Operation Scrap Percent on the bill of materials (P3002). The system uses this value to increase or decrease the amount of materials to account for loss within the operation. A valid operation step must defined for the component in the routing for this calculation to take place.

Example:

Parent work order quantity of 1,000 each
Component A - 1 each (OP 10)
Component B - 1 each (OP 40)

Parts list calculation would be:
Component A - 1,000 * 1.462 = 1,462 each
Component B - 1,000 * 1.250 = 1,250 each

The routing, using 1 hour per unit, is calculated as:

OP-10 = (1.00 / .684) * 1000 = 1,461.99 Hours

OP-20 = (1.00 / .72) * 1000 = 1,388.89 Hours

OP-30 = (1.00 / .72) * 1000 = 1,388.89 Hours

OP-40 = (1.00 / .80) * 1000 = 1,250 Hour

Combination of all three- Scrap, Shrink and Yield:
The parts list calculation follows a hierarchy when there is a combination of these three: shrink, scrap and yield calculations. They are calculated in the following order.

1. Parent shrink percentage from the F4102
2. Component scrap input into the P3002
3. Operational yields from the routing P3003

Example:

• Work order quantity = 1,000
  Component A = 1 Each
  Component B = 1 Each
• Parent Shrink = 20%
• Scrap % on component A = 10%
• Yield %: OP-10 = 95 %
  OP-20 = 100 %
  OP-30 = 90 %
  OP-40 = 80 %

Using the calculations from above, the parts list for the components are calculated as follows:

	Component A:​
Shrink​	(1,000 * 1.2) = 1,200​
Scrap​	(1,200 * 1.1) = 1,320​
Yield​	(1,320 * 1.462) = 1,930​

	Component B:​
Shrink​	(1,000 * 1.2) = 1,200​
Yield​	(1,200 * 1.3889) = 1,667​

The routing is not affected by component scrap but will be affected by Operation Yield and Parent Shrink

OP-10 = (1.00 / .684) * 1000 = 1,461.99	1,461.99 * 1.2 = 1,754.39 Hours
OP-20 = (1.00 / .72) * 1000 = 1,388.89	1,388.89 * 1.2 = 1.666.67 Hours
OP-30 = (1.00 / .72) * 1000 = 1,388.89	1,388.89 * 1.2 = 1.666.67 Hours
OP-40 = (1.00 / .80) * 1000 = 1,250.00	1,250.00 * 1.2 = 1,500.00 Hours

When the Routing is create first and the BOM Operation Sequence is populated correctly the BOM will be created with the correct Operation Scrap Percent. When the BOM has been created first or when there are changes to the Routing Yield % the R3093 Planned Yield Update must be run.