NetSuite Work Order Yield and Scrap Start Quantity Calculator
If you need 500 good assemblies you cannot start 500. Scrap at each step compounds, so the start quantity on the work order must be higher. This calculator shows the compounding effect and the cost of the allowance, whether you handle it through component yield, an inflated work order quantity or a planned scrap step.
Your numbers
Material plus value added up to the point scrap occurs; use the average.
Your results
Uses average scrap rates and treats each step as independent. Actual scrap varies by lot, tooling and operator.
Start quantity vs step 2 scrap
Sweeps Scrap at step 2 from 0 to 30, holding your other inputs fixed.
Planned versus actual yield review
Optional: we can outline a read-only comparison of BOM yield against completed work order results.
Optional. The tool and every export work without this. No spam.
How to use it
Enter the good quantity the order must deliver and the scrap percentage at up to three steps, such as cutting, machining and final test. Use measured scrap from recent work order completions and issue-versus-build comparisons, not a guess. The calculator returns the rolled yield, the start quantity and the expected scrap cost. Use the chart to see how a single noisy step inflates the whole order, which helps decide where an improvement project pays back.
The method
Rolled yield is the product of the survival fraction at every step. A 2 percent, 4 percent and 1.5 percent scrap sequence gives 0.98 times 0.96 times 0.985, about 92.7 percent, not 92.5 percent as simple addition suggests. Start quantity is the required good quantity divided by rolled yield, rounded up. Scrap cost is the extra units times their average cost. In NetSuite you can express the allowance through component yield on the BOM or by planning a higher work order quantity, so decide one method and keep it consistent.
- Never add scrap percentages, multiply survival rates
- Round the start quantity up to whole units
- Late-stage scrap costs more than early-stage scrap
Mistakes to avoid
Applying scrap twice is the classic error: once through BOM component yield and again through a higher work order quantity. This overbuys material and distorts variance reports. Another is using one blended scrap rate for all products when only some routings are noisy. Finally, remember lot-size rounding by the supplier: a start quantity of 541 may need to become 550 if material only comes in tens, and the extra goes to stock or the next order.
Frequently Asked Questions
Why not just add the scrap percentages?
Scrap at later steps applies only to units that survived earlier steps. Multiplying survival fractions captures this. For small percentages the difference is minor, but it grows with higher scrap rates and more steps.
Is rolled yield the same as first pass yield?
Rolled throughput yield is the product of first pass yields at each step, which counts rework as a failure. If your steps allow rework back into the flow, use the rate of units that become good without rework for a stricter view.
Where should the scrap allowance live in NetSuite?
Pick one place, such as the component yield on the BOM revision, or a planned quantity on the work order, and document it. Using several mechanisms at once is the most common cause of overstated material requirements.
Does this work for process manufacturing?
The yield math applies, but process flows often have by-products and variable yields tied to batch size or formulation. Use it as a first estimate and adapt for co-products.
Netray can compare planned yield against actual work order completions and scrap in your NetSuite data so allowances reflect what the shop floor really does.
Related Tools
NetSuite Assembly Item Standard Cost Rollup Calculator
Build a per-unit standard cost from material, setup, run time, labor rate and overhead, and see how lot size amortizes setup.
NetSuiteNetSuite Work Order Labor Variance Calculator
Break labor variance on completed work orders into a rate variance and an efficiency variance and read labor efficiency.
NetSuiteNetSuite Reorder Point and Preferred Stock Level Calculator
Work out the safety stock, reorder point and preferred stock level values to enter on a NetSuite item record.
More NetSuite tools
See all- NetSuite Work Order Status Reference
- NetSuite Saved Search Formula Generator
- NetSuite CSV Import Template Guide
- NetSuite Assembly Build Checklist
- NetSuite Role Permission Matrix Worksheet
- NetSuite Inventory Costing Method Reference
- NetSuite Month End Close Checklist
- NetSuite License Cost Estimator
- NetSuite User Access Request Form Template