OracleFree calculatorPDF, Excel, Word exportOracle E-Business SuiteDiscrete Manufacturing

Oracle EBS Operation Yield and Job Start Quantity Calculator

Yield and shrinkage decide how many units you must start to ship the quantity the customer ordered. This calculator multiplies the operation yields on a routing, grosses up the component requirement for the BOM component yield and shows what the loss costs.

Your numbers

units
%
%
%
%

Component yield factor on the BOM line, as a percent.

units
$

Your results

Job start quantity
1,061
Units to start so that the expected good output equals demand.
Component quantity required
3,232
Start quantity times quantity per, grossed up for component yield.
Cumulative routing yield
94.3%
Product of the operation yields.
Expected scrap units
61
Component cost for the job
$5,979
Component cost caused by yield loss
$429
Spend above the no loss requirement.

Assumes independent yields that multiply and scrap occurring at the end of each operation. Check how your routing yields and the component yield factor are used in your MRP and WIP settings.

Save results:

Start quantity vs Operation 20 yield

Sweeps Operation 20 yield from 85 to 100, holding your other inputs fixed.

Compare planned yield to actual yield

An optional review of scrap history against routing yield assumptions.

Optional. The tool and every export work without this. No spam.

How to use it

Enter the good units you need, the yield percentage for each operation from the routing, the component yield and the quantity per assembly. The tool gives the cumulative routing yield, the number of units to start in the job, the expected scrap, and the component quantity to release. Use the chart to see how sensitive the start quantity is to the weakest operation. Sliding the yield of operation 20 from 100 down to 85 shows quickly why a single poor step can dominate your material demand.

  • Use yields measured from scrap transactions, not targets
  • Enter percentages such as 98, not 0.98
  • Keep component yield separate from operation yield to avoid double counting

The method

If each operation has an independent yield, the cumulative yield is the product of the individual yields. Start quantity equals required good units divided by the cumulative yield, rounded up. Component requirement equals start quantity times quantity per assembly divided by the component yield, because a component yield of 98.5 percent means 1.5 percent of what you issue is lost before it is used. Oracle bills of material carry a component yield factor for this reason, and routings can carry operation yield, which feeds the planning of start quantity.

Worked example

With 98, 97 and 99.2 percent, cumulative yield is about 94.3 percent, so 1,000 good units need 1,061 units started, 61 of them expected scrap. At 3 components each and a 98.5 percent component yield the job needs about 3,231 components, versus 3,000 in a perfect process. At 1.85 each, the yield loss costs roughly 430 dollars on this one job, which adds up across many jobs a month.

Common mistakes

Applying yield twice, once as scrap in the routing and again as a shrink factor on the same loss, inflates demand. Setting yields to 100 percent because the data is missing hides real scrap. Using yields from a different product family is another trap. Review yield from actual scrap transactions every quarter, and remember that a cumulative yield below 90 percent usually points to a process problem that deserves engineering attention more than a larger start quantity.

Frequently Asked Questions

Is yield the same as scrap?

They are two sides of one number. A 97 percent yield means 3 percent of units are lost. Scrap transactions in WIP record actual loss, while the routing yield is the planning assumption used to size the job.

Where is component yield set in EBS?

On the bill of material component, there is a component yield factor. It scales the requirement so the quantity issued covers the expected loss before the component is consumed in the assembly.

Should operation yields be multiplied?

If scrap at each step is independent and happens after the operation, yes. The cumulative yield is the product. If a later step reworks earlier loss, or the yields are not independent, model it explicitly.

Why round the start quantity up?

You cannot start a fraction of a unit, and rounding down leaves you short of the customer's demand. Rounding up is the safe choice. Some sites then apply a lot multiple on top.

Netray can calculate actual operation yields from your EBS scrap and move transactions and compare them with the values in your routings.