Founder at SpecRivet · Pre-PO Excel BOM & Quote Auditing
Ex-A.O. Smith Lean Manufacturing | Building pre-PO Excel BOM shortage & supplier quote MOQ audit tools for 10-to-100 person commercial hardware manufacturers.
Markdown supported · ⌘↵ to post
Dov at HireDov
The MOQ step-up trap is the one that bites us most. One small addition to your pre-PO checklist: round each net shortage up to the reel multiple, then compare the extra pieces' cost against the next price break. Sometimes buying the full reel is cheaper than the exact shortfall, and the leftover becomes free stock for the next batch. I'd also add a column that flags parts whose open PO ETA lands after the build date, so they count as zero available. Do you treat late POs as zero in your template, or discount them by a lead-time buffer?