Understanding Push And Pull Worksheets
I first ran into these when someone in operations asked me to help map where a new product line should switch from forecast-driven manufacturing to demand-driven replenishment. What they handed me was a blank grid and a vague request. That was three years ago. Since then, I have built, rebuilt, and redone these things enough times that I can at least explain how they actually work in practice. A Push And Pull Worksheets is a planning artifact that maps your supply chain so you can see where materials, components, or finished goods are driven by forecasts versus where they are triggered by actual customer demand. The push side handles items with stable demand patterns that are economical to stock in advance. The pull side handles variability-heavy items where producing ahead of need creates excess inventory that nobody wants to hold. The worksheet itself is usually just a table. One column for each stage of your process. Another column marking whether that stage operates as push or pull. Then columns for lead time, batch size, supplier constraints, and safety stock logic. Simple on paper. Messy in reality.
How To Fill One Out
Start with your bill of materials or process flow and walk through it from raw material to shipment. For each node, answer one question: does demand here reliably predict the next period's requirements, or does it fluctuate enough that building ahead just creates waste? If it predicts well, that is push. If it reacts to actual orders, that is pull. Mark the boundary between push and pull. This is called the decoupling point. Everything upstream of that point is manufactured or procured based on forecasts. Everything downstream is triggered by real orders. Getting this line right is where most people mess up. I learned this the hard way on a project for a mid-size electronics assembler. Their previous consultant had drawn the decoupling point at the sub-assembly level, which looked clean on paper. When we actually tried to run it, the supplier for a specific capacitor had a twelve-week lead time and a minimum order quantity that forced us to stock four months of demand as safety inventory. The pull side collapsed under its own carrying costs within six weeks. We moved the decoupling point downstream to final assembly and kept the capacitor on a push replenishment schedule with a properly calculated reorder point. It took two weeks of argument with procurement to make the change stick.
Key Columns to Include
Your worksheet needs more than just a push or pull label at each stage. Here is what actually matters in the columns: Stage name and description. Be specific. "Sub-assembly" is not enough. Use the actual part or process identifier your people recognize on the floor. Mode designation. Push, pull, or hybrid. Hybrid exists when you produce a base platform on forecast and customize it on order. Do not force everything into a binary choice.
Get the Full Details
Lead time. Real lead time, not the textbook number. Include procurement lag, internal processing time, and transit. Measure it from actual data if you can get it. Batch or lot sizing rule. Economic order quantity, fixed interval, min-max, kanban. Whatever you actually use. If you do not have a rule yet, write "undefined" and treat that as a gap to address. Safety stock approach. Fixed quantity, percentage of average demand, or service-level based. The worksheet forces you to commit to an approach instead of vaguely hoping inventory will be enough.
Demand source. Forecast, customer order, or historical consumption. This tells you why the item is classified the way it is. Responsibility owner. Name the person or team accountable for managing that stage. A worksheet without ownership is just decoration.
Where People Go Wrong
The biggest mistake I see is treating the push-pull boundary as a one-time decision. It is not. Seasonality, supplier changes, and product lifecycle shifts move that line constantly. I review these worksheets at least quarterly with whoever runs the actual production planning. When someone stops doing that, the worksheet becomes a historical document that nobody uses and everyone pretends still exists. A second common error is over-indexing on push for everything. Forecast-driven manufacturing feels safer because it keeps machines running and workers busy. But it also buries obsolescence risk. I once saw a company carry eighteen months of inventory for a component that got superseded when the product line was quietly discontinued. The worksheet had marked that stage as push with no review date attached. There was nothing in the document to trigger a reevaluation. Push And Pull Worksheets also suffer when people include every single line item. Do not map a $0.40 washer the same way you map a custom-milled housing. Group low-value, stable-demand items into aggregate categories. The effort to model each one individually does not justify the output. Your planning team will spend more time maintaining the sheet than using it.
When This Tool Falls Short
There are scenarios where a push and pull worksheet simply does not give you enough signal. Highly customized or engineered-to-order environments where almost every stage reacts to a specific customer configuration struggle to find a meaningful decoupling point. The worksheet still works there, but the insights are thin and you are better off pairing it with a configure-to-order framework instead of relying on it alone. Pure contract manufacturing operations where the manufacturer has no visibility into end-market demand also hit a wall. If your customer dictates replenishment cadence and you do not control the forecast, the push side of your worksheet is basically a promise you cannot guarantee. In those cases, negotiate for demand sharing agreements rather than trying to force the model to work without the data it needs.
A Quick Walkthrough
Here is a stripped example for a small appliance manufacturer to show what a populated row looks like: Stage: Motor sourcing. Mode: Push. Lead time: 6 weeks. Batch rule: MOQ 500 units. Safety stock: 3 weeks of average demand. Demand source: Rolling 13-week forecast. Owner: Procurement lead. Stage: Final assembly. Mode: Pull. Lead time: 3 days. Batch rule: One-by-one matching daily orders. Safety stock: None. Demand source: Customer purchase orders. Owner: Production scheduler.
Decoupling point sits between motor sourcing and final assembly. Everything above that point is built to forecast. Everything below it responds to confirmed orders. That is the structure. The difficulty is in the details. Getting the lead times right requires actual data, not hope. Choosing the right batch sizing rule requires understanding your supplier's constraints. Deciding whether something is truly pull or just push wearing a different name requires looking at what actually triggers the order, not what your ERP system calls the process. If you want a template, search for lean manufacturing pull system templates or supply chain decoupling point frameworks. The structure is standard enough that most operations consulting firms have downloadable versions. The value is not in the template itself. It is in filling it out honestly and revisiting it when conditions change.
