Cloud MRP BOM Data Cleanup Worksheet
Bad BOMs cause most MRP failures: wrong quantities, mixed units and missing costs produce wrong purchase suggestions on day one. This worksheet lets you review each BOM line, add scrap, and flag problems before the data goes into a new system.
| Parent item | Component | UoM | Qty per parent | Scrap % (%) | Unit cost | Extended cost | Check status | |
|---|---|---|---|---|---|---|---|---|
$9 | ||||||||
$0 | ||||||||
$2 | ||||||||
$1 | ||||||||
$3 |
Costs here are material only. Add labor and overhead after routings are loaded. Resolve every line not marked Verified before import.
Automated BOM check
Send an export and we will list lines with unit, cost or revision anomalies. Optional.
Optional. The tool and every export work without this. No spam.
How to use it
Paste or type one line per BOM component. Choose the unit of measure that the component is purchased and stocked in, then enter quantity per parent, a scrap percentage, and unit cost. Extended cost is computed as quantity times one plus scrap, times cost. Use the status column to track verification, and filter in Excel after export to build a to-do list for each engineer or buyer.
- Start with your top 50 revenue parts
- Fix units of measure before costs
- Use scrap only where you really lose material
- Mark obsolete components, do not delete them yet
Why units and scrap matter
MRP multiplies quantity per by the order quantity and nets against stock in the stocking unit. If a tube is stored in metres but the BOM says each, the requirement is wrong by an order of magnitude. Scrap percentage increases gross requirement so purchasing covers expected losses. Without it, you short the job; with too much, you overbuy and tie up cash.
Reading the results
Total material cost gives a quick sanity check against your quoted price. If a top assembly shows material cost above the selling price, either a cost or quantity is wrong. The lines marked Missing cost or Wrong UoM are your cleanup backlog. Set a rule that no BOM loads into the new system with any such status.
Common mistakes
Copying old BOMs without checking revision levels, keeping phantom subassemblies that no one builds, and treating one BOM as valid for all variants. Also avoid loading hundreds of dead part numbers, since they clutter planning and slow search. Archive them instead.
Frequently Asked Questions
How clean must a BOM be before MRP?
Component, quantity per, unit of measure and lead time must be right for every active item. Costs can be refined later, but wrong quantities or units give wrong purchase suggestions immediately.
What scrap percentage should I use?
Use your measured loss for the process, such as cutting or coating yield. Start from historical usage data rather than a round guess, and review quarterly.
Should I include labor in this sheet?
Not here. Labor and overhead come from routings and work center rates. Keep this sheet for material so you can verify purchased parts and quantities clearly.
How many BOMs should I clean first?
Start with active products that make up most revenue or most purchasing spend. A good first target is the top 20 percent of parts by annual usage value.
Netray can run an automated check across an exported ERP or spreadsheet BOM set and list lines with unit or cost anomalies.
Related Tools
Small Plant Min Max Reorder Point Worksheet
Compute reorder point, maximum level and suggested order quantity per item so you can load clean planning parameters into your cloud MRP.
ERP Migration & SelectionCloud MRP Implementation Project Plan Worksheet
Editable task list with owner, start date, days, hours and rate that totals your internal and consultant effort for a cloud MRP rollout.
ERP Migration & SelectionCloud MRP Go-Live Cutover Plan Template
A cutover document with freeze dates, opening balance loads, physical count, roles and a rollback decision point for your first day on a new MRP.
ERP Migration & SelectionCloud MRP Vendor Demo Script Template
A scripted demo agenda using your own part, BOM and job so you see how each cloud MRP handles your real work instead of a canned demo.
More Engineering & PLM tools
See all- SAP Super BOM Design Worksheet
- SAP Engineering Change Number Checklist
- SAP Document Info Record Template
- SAP Change Master and Revision Level Log
- SAP Engineering Change Request (ECR) Template
- SAP BOM Usage and Item Category Reference
- SAP Engineering Change Obsolescence Exposure Calculator
- SAP Engineering Change Affected Materials Impact Worksheet
- Part Numbering Scheme Generator Template