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?