Metrics are critical. This applies especially to the busy supply planner juggling countless tasks and constant firefighting.
The right metrics sharpen focus. They deliver results the business truly values. And with stronger results come bigger career opportunities.
Below are 10 metrics every supply planner should apply daily to make better decisions. For each, you will see a practical use case, a common challenge, and a quick fix you can put into action right away.
1. Weeks of Supply
Formula: On-Hand Inventory ÷ Avg Weekly Demand
How to apply: Run this weekly by SKU to see how long your inventory can last without replenishment. Use it to prioritize items at risk of stockout.
Challenge: Demand often fluctuates, so an average can give a false sense of security.
Fix: Layer in demand variability (use a rolling 13-week average or include forecast error) to spot “false cushions” in inventory.
2. Inventory Turnover
Formula: Cost of Goods Sold ÷ Avg Inventory
How to apply: Compare turnover across product categories. Low turnover = tied-up cash, high turnover = risk of shortages.
Challenge: Finance and supply chain often calculate turnover differently (units vs. value).
Fix: Align on one method with finance, ideally in cost terms, so decisions are consistent across the business.
3. Fill Rate
Formula: Total Shipped ÷ Total Ordered
How to apply: Track fill rate by customer and SKU to see who is impacted most. A 95% average can hide low-performing SKUs or customers at 70%.
Challenge: Many planners only look at overall service level.
Fix: Disaggregate; report fill rate at the top 20 customers and SKUs that drive 80% of revenue.
4. Obsolescence Ratio
Formula: Obsolete Inventory ÷ Total Inventory
How to apply: Spot items that are aging and at risk of write-off. Use this in S&OP to trigger actions like promotions or supplier returns.
Challenge: Many companies only calculate obsolescence annually for finance.
Fix: Run it monthly in planning reviews to prevent write-offs before they hit the P&L.
5. Schedule Adherence
Formula: Actual Production ÷ Scheduled Production
How to apply: Measure how closely your plant sticks to the plan. If you planned 10,000 units and only made 8,000, ask why.
Challenge: Frequent changeovers, machine downtime, or missing materials distort adherence.
Fix: Record reasons for misses daily (machine, material, labor) and share trends in weekly S&OE meetings to drive root-cause fixes.
6. Plan Attainment
Formula: Actual Output ÷ Planned Output (for period)
How to apply: Use at a higher level (weekly/monthly) to track if the factory is meeting aggregate plans.
Challenge: Planners confuse it with schedule adherence. One measures “daily discipline,” the other measures “big picture.”
Fix: Report both separately: adherence for operations, attainment for executives.
7. Capacity Utilization
Formula: Actual Output ÷ Available Capacity
How to apply: Compare utilization across lines or plants to spot bottlenecks or underused assets.
Challenge: Capacity assumptions are often unrealistic (e.g., assuming 24/7 when you only staff 5 days).
Fix: Define realistic available hours; adjust for maintenance, holidays, and labor, to make the ratio actionable.
8. Rough-Cut Capacity Planning (RCCP)
Formula: Required Capacity = Forecasted Demand × Process Time
How to apply: Use RCCP early in S&OP to see if next month’s demand fits available hours.
Challenge: Many skip RCCP and only discover problems once detailed scheduling starts.
Fix: Run RCCP monthly to flag overloads early; buy time for decisions like adding overtime, outsourcing, or shifting demand.
9. MRP Net Requirements
Formula: Gross Requirements – (On-Hand + Scheduled Receipts)
How to apply: Check net requirements weekly to trigger material purchase or production orders.
Challenge: Data integrity issues—incorrect lead times or BOM errors—produce wrong signals.
Fix: Audit the “why” behind big swings in requirements. Clean BOMs and lead times continuously.
10. Open Purchase Order (PO) Coverage
Formula: Sum of Open PO Qty ÷ Avg Weekly Usage
How to apply: Use this to answer: “How many weeks of supply are already inbound?” It helps avoid double-ordering or stockouts.
Challenge: Planners often miss late or unconfirmed POs, making coverage unreliable.
Fix: Partner with procurement to review open PO reports weekly, chasing suppliers before problems hit production.
Conclusion
These 10 metrics are decision drivers. Build a simple dashboard (Excel or Power BI) that refreshes weekly. Apply the fixes above. And watch transformation with financial impact.
