S&OP Engineering IV: Scaling to Enterprise (Multi-SKU & Bottlenecks)

Your MVP works. One product, one model, one perfect plan. Congratulations: you just solved the easiest problem in Supply Chain. Now add 3 products sharing the same factory. Product A needs 14,000 units in July. Product C needs 13,000 that same month. Your factory produces 15,000. Who gets shorted? If your answer is "we'll figure it out in Thursday's meeting," your company has an engineering problem, not a management one. Executive Summary: In chapters 1, 2 and 3 we built a working MVP for a single product. In this Chapter 4, we break it. We inject 3 years of history with 3 SKUs of radically different demand profiles (Core, Intermittent, and Seasonal), parallelize Prophet model training with MLOps, and build a unified Linear Programming model where products compete mathematically for limited factory capacity. Welcome to Theory of Constraints executed in code. The Fatal Error: Optimizing in Silos The biggest sin in Supply Chain Planning isn't using dirty data (we fixed that in Chapter 1)