BOM Shortage Calculator
Compare your BOM with a single-warehouse inventory snapshot. Calculate material shortages, kit readiness, and the maximum number of units you can build. Get a shortage preview in seconds.
Files processed in memory & auto-deleted immediately · Zero data retention · Never used for AI training
4 MB total, up to 5,000 data rows across both tables.
How to map BOM and inventory columns
| Table | Example fields | Example values |
|---|---|---|
| BOM | Part Number / Level / Qty per Parent / UoM | M3-BOLT / 1.1 / 4 / EA |
| Inventory | Part Number / On Hand / Warehouse / Allocated / UoM | M3-BOLT / 35 / MAIN / 2 / EA |
Use Net available when your inventory already reports Available Physical after deductions.
Compare material shortage workflows
| Tool | Workflow |
|---|---|
| SpecRivet | Compare two spreadsheets for one warehouse snapshot and export a shortage report. |
| Katana | Check material availability for manufacturing orders in a connected inventory and production workflow. |
| OpenBOM | Use item catalogs and multilevel bills of materials to plan purchases. |
| MRPeasy | Check parts availability and track manufacturing orders in a production planning workflow. |
| Manual Excel | Maintain hierarchy formulas, inventory matches and an audit trail in the workbook. |
BOM shortage FAQ
What is a BOM shortage calculation?
It compares the components needed for a planned build with usable inventory at one warehouse. It shows a shortage for each part that needs more stock.
How is maximum buildable quantity calculated?
The calculator expands subassemblies, combines shared parts and applies scrap. The limiting verified part determines the maximum. When some parts need review, you may see a verified upper bound.
What happens to missing or ambiguous stock records?
Unrecorded parts default to zero stock. Turn off that setting to review them. A possible part-number mismatch, unknown quantity or conflicting unit stays under Review.
Which BOM and inventory files can I upload?
Upload one Excel workbook with two sheets or separate XLSX, XLS or UTF-8 CSV files. The combined limit is 4 MB and 5,000 data rows.
What is free and how does the export credit work?
The preview and five-row sample are free. A complete report with Excel export uses one credit. A first-login trial credit covers up to 50 combined data rows and 65 nonempty worksheet rows.
Verify material quantities and flagged issues before committing production or purchase orders. To the extent permitted by applicable law, SpecRivet’s total liability for a claim is limited to the amount you actually paid for the credit pack associated with that claim. Mandatory rights and liabilities that cannot lawfully be limited still apply.