Stream

Reading about theory of constraints again. Keep circling back to it whenever a planning process feels stuck — the bottleneck is rarely where the complaints are loudest.

TIL: pandas.DataFrame.explode() solves the bill-of-materials flattening problem cleanly — one list-column per parent, exploded into one row per component, no manual loop.

Every team measures forecast accuracy differently, and almost nobody states which one they mean. MAPE punishes low-volume SKUs unfairly; WMAPE fixes that but hides SKU-level misses. Worth writing up properly at some point.