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
Keep exploring
Free tools
- Small Manufacturer MRP Readiness AssessmentScore your readiness for MRPeasy, Katana, Odoo, ERPNext or a similar system, and see what to fix before you buy.
- Small Manufacturer ERP Requirements Document TemplateA fill-in requirements document you can send to MRPeasy, Katana, Odoo, ERPNext or Fishbowl resellers so every vendor quotes the same scope.
- ERPNext BOM Import TemplateAn editable BOM worksheet with finished item, component, quantity, UoM and rate columns, calculating extended and rolled up cost before you import to ERPNext.
ERP fixes and how-tos
- Katana MRP Integrations and the MRPeasy REST APIKatana MRP integrations and the MRPeasy REST API: what the Shopify, accounting and marketplace connectors sync, where the API fits and how to avoid sync gaps.
- Odoo Manufacturing Tutorial: From BOM to Finished ProductOdoo manufacturing tutorial for small manufacturers: set up products, BOMs, work centers and operations, run a manufacturing order, and what to check in Odoo 19.
- How to Compare Planned vs Actual Cost in MRPeasyHow to compare planned and actual cost on MRPeasy manufacturing orders, find why a product cost looks wrong, and trace material, labour and overhead variance.
Guides
- ERP Master Data Cleanup with AI: A Practical GuideClean up ERP master data with AI: duplicate detection, standardization, and a governance model that keeps your item and customer records clean long term.
- AI BOM Scrubbing for Electronics ManufacturersHow AI scrubs customer BOMs for EMS and electronics manufacturers: part matching, refdes checks, lifecycle flags, alternates, and what stays human reviewed.
- How to Fix Slow MRP Performance in SyteLineSpeed up SyteLine MRP runs that take hours instead of minutes. Covers SQL optimization, MRP parameters, data cleanup, and parallel processing configuration.
AI on your ERP
- AI for Katana Cloud ManufacturingAdd private AI on top of Katana: natural-language answers across Katana, Shopify, and QuickBooks Online, plus agents for reorder points and channel demand, without a public model reading your data.
- AI for MRPeasy Manufacturing ERPAdd private AI to MRPeasy: natural-language answers over production, inventory, and lot traceability data, plus MRP exception and PO follow-up agents, without a public AI reading your data.
Integrations
- How to connect Power BI to KatanaConnect Power BI to Katana: why there is no direct database, how to land the REST API in a warehouse, key dashboards, refresh limits and adding natural-language Q&A.
- How to add an AI chatbot to KatanaAdd an AI chatbot to Katana: answer order and stock questions for staff and customers, grounded in the Katana API, with guardrails, handoff and a private-model option.
Software
- MRPeasyMRPeasy is a cloud MRP and ERP system for small manufacturers. See its modules, integrations, limitations and alternatives for shortlisting.
- KatanaKatana is a cloud inventory and manufacturing system for small product makers. See its modules, integrations, limits and alternatives before you choose.