Free manufacturing calculator
BOM shortage calculator for open production jobs
Calculate component demand from your bill of materials, compare it with inventory and incoming supply, and see which jobs can start without a material shortfall.
Open the free calculatorHow the calculation works
For each open job, the calculator multiplies job quantity by each BOM component quantity. It then allocates available supply in production start-date order so the same inventory is not counted twice.
If Product A needs 4 bearings per unit and a job calls for 20 units, that job requires 80 bearings. If 100 bearings are on hand, an earlier job has already consumed 40 and no receipt arrives before the start date, only 60 are available to the new job and the shortage is 20.
Required files
- Inventory: sku, on_hand
- BOM: product_sku, component_sku, qty_per
- Open jobs: job_id, product_sku, qty, start_date
- Incoming POs, optional: component_sku, qty, due_date
What this calculator intentionally does not do
The validation build supports a single-level BOM and does not perform capacity planning, labor scheduling, accounting, purchasing automation or shop-floor tracking. The purpose is to validate one narrow decision: whether each production job has the materials it needs in time.
Private by design during validation
The CSV calculation runs in your browser. Production files are not uploaded to the server. Only anonymous usage events and any email you deliberately submit for early access are stored.
Calculate my BOM shortages