Metrics are helpful to focus on what matters.
The right metrics lead to better performance and results.
Below, I break down 28 essential metrics from Planning, Procurement, Operations, and Logistics, each with practical steps to apply this week.
PLANNING METRICS
# 1 – MAPE (Mean Absolute Percentage Error)
Formula: MAPE = (Σ |Forecast – Actual| / Actual) ÷ N × 100
Concept: Measures how far your forecast is from actual demand on average.
Challenge: Planners rely on aggregate MAPE that hides poor-performing SKUs.
Fix: Calculate MAPE by product or category. A 5% error on one SKU and 50% on another shouldn’t blend into a 20% “average.”
Quick Win: Filter your Excel forecast file by the top 20% of SKUs by revenue. Improve those forecasts first. That’s where accuracy will pay off most.
# 2 – WMAPE (Weighted MAPE)
Formula: WMAPE =(Σ |Forecast – Actual|) / Σ Actual × 100
Concept: Weights errors by sales volume — giving more importance to high-volume items.
Challenge: Teams track MAPE but ignore WMAPE, missing the business impact of key SKUs.
Fix: Add actual sales values as weights in your formula. Focus on high-value products that drive profit.
Quick Win: Use =SUM(ABS(Forecast-Actual))/SUM(Actual) in Excel. This formula shows which customers or products hurt your wallet the most.
# 3 – Forecast Bias
Formula: Forecast Bias = (Forecast – Actual) / Actual × 100
Concept: Shows whether forecasts consistently overestimate or underestimate demand.
Challenge: Many planners never check bias — they just chase accuracy.
Fix: Track positive and negative deviations. Consistent bias means your forecast model or assumptions are off.
Quick Win: Add a column in your report: (Forecast – Actual) / Actual. If the sign is always positive, reduce your safety stock before it eats your cash.
# 4 – OTIF (On-Time In Full)
Formula: OTIF = (Orders Delivered On Time and In Full / Total Orders) × 100
Concept: Percentage of customer orders delivered on time and complete.
Challenge: Teams report OTIF globally, hiding chronic customer issues.
Fix: Break it by customer or region. Late or partial deliveries often trace to process bottlenecks or supplier delays.
Quick Win: Create a simple Excel pivot by customer to identify who gets hit most often. Fixing top offenders can raise overall OTIF 5–10% quickly.
# 5 – Demand Coverage
Formula: Demand Coverage = (Inventory + Confirmed Supply) / Forecast
Concept: Measures how much inventory and confirmed supply cover future demand.
Challenge: Coverage reports are static — not linked to live MRP updates.
Fix: Refresh your coverage view weekly and flag where coverage <4 weeks (or your threshold).
Quick Win: Build a simple Excel chart that shows SKUs with low coverage in red. Share it in your S&OE (sales and operations execution) meeting. Instant visibility.
# 6 – Plan Feasibility
Formula: Plan Feasibility = (Feasible Plan within Capacity / Total Plan) × 100
Concept: Measures whether the production or supply plan fits within capacity limits.
Challenge: Many planners don’t check feasibility before sending plans to production.
Fix: Compare planned hours to available hours in Excel or your APS. Anything >100% means overload.
Quick Win: Do a quick “RCCP” (rough-cut capacity check) before finalizing your MPS. Prevent chaos later.
# 7 – Plan Attainment
Formula: Plan Attainment = (Actual Output / Planned Output) × 100
Concept: Compares what was actually produced/shipped to what was planned.
Challenge: Teams celebrate high output but forget if it matched the plan.
Fix: Track plan attainment weekly. Low attainment = poor scheduling or unstable demand.
Quick Win: Use a simple KPI: (Actual / Plan) × 100. Aim for 90%+. Share with your plant team to align production priorities.
PROCUREMENT METRICS
# 8 – Cost Savings Achieved
Formula: Cost Savings = Baseline Cost – Actual Spend
Concept: Measures actual spend reduction vs. baseline.
Challenge: Teams confuse savings with cost avoidance (prevented increases).
Fix: Document your baseline cost before negotiation and compare after contract signing.
Quick Win: Track the savings per category and share cumulative impact with Finance — builds credibility instantly.
# 9 – Cost Avoidance
Formula: Cost Avoidance = Prevented Cost Increases
Concept: Prevented cost increases through negotiation or alternative sourcing.
Challenge: Hard to quantify because no invoice “proves” the avoided cost.
Fix: Keep a record of supplier quotes before and after negotiation. Show Finance what you prevented.
Quick Win: Create a simple log of “price increases avoided.”
# 10 – Purchase Price Variance (PPV)
Formula: PPV = (Actual Price – Standard Price) / Standard Price × 100
Concept: Difference between actual and standard price.
Challenge: Teams ignore small variances that accumulate to big losses.
Fix: Automate a PPV report by item category and supplier.
Quick Win: Highlight items with >3% variance in red. Discuss them in weekly buyer meetings.
# 11 – PO Cycle Time
Formula: PO Cycle Time = (Approval Date – Creation Date)
Concept: Time from purchase order creation to approval.
Challenge: Long approval chains cause delays and stockouts.
Fix: Map your PO approval flow. Eliminate unnecessary steps or automate low-value approvals.
Quick Win: Measure average PO cycle time this month. Set a target to reduce it by 20% next month.
#12 – Emergency Procurement Rate
Formula: Emergency Procurement % = (Urgent POs / Total POs) × 100
Concept: Share of urgent, unplanned POs.
Challenge: High rate = poor forecasting or planning.
Fix: Tag emergency POs in your system and trace root causes.
Quick Win: Start by classifying the top 10 urgent POs last month — which category or planner caused them? Fix the root to reduce chaos.
#13- Maverick Spend %
Formula: Maverick Spend % = (Unapproved Spend / Total Spend) × 100
Concept: Purchases made outside approved contracts or vendors.
Challenge: Managers lose visibility and leverage on spend.
Fix: Cross-check purchase data with your vendor master file.
Quick Win: Find one supplier that your team keeps buying from without approval and fix that first.
# 14 – Vendor Rating Score
Formula: Vendor Rating = Weighted Average (Delivery, Quality, Cost, Responsiveness)
Concept: Weighted score evaluating supplier performance (price, quality, delivery).
Challenge: Teams collect data but never use it for decisions.
Fix: Update supplier ratings quarterly and link them to sourcing decisions.
Quick Win: Pick one poor-performing vendor and start a joint improvement plan. Improves relationships and reliability.
OPERATIONS METRICS
# 15 – Throughput
Formula: Throughput = Units Produced / Time
Concept: Measures production rate (units/time).
Challenge: Throughput data often excludes downtime or changeovers.
Fix: Track “net throughput” after accounting for lost time.
Quick Win: Identify your slowest line. Focus on removing one bottleneck.
# 16 – First Pass Yield
Formula: FPY = (Units Passed Without Rework / Total Produced) × 100
Concept: Percent of units passing quality inspection without rework.
Challenge: Quality issues are tracked but not quantified financially.
Fix: Multiply rework % by cost per unit to show financial waste.
Quick Win: Set a target FPY ≥ 95%. A 2% increase saves rework hours and materials immediately.
# 17 – Uptime %
Formula: Uptime % = (Run Time / Total Time) × 100
Concept: Percentage of total time machines are running.
Challenge: Operators record time inconsistently.
Fix: Use sensors or shift logs to track downtime reasons.
Quick Win: Focus on top 3 downtime causes — eliminating just one can add hours of production capacity weekly.
# 18 – Scrap Rate
Formula: Scrap Rate = (Scrap Quantity / Total Output) × 100
Concept: Waste material or defective units as a % of total output.
Challenge: Scrap often accepted as “normal.”
Fix: Quantify it in dollars. Visibility drives accountability.
Quick Win: Post scrap % by line or shift on the shop floor board — competition drives improvement.
# 19 – OEE (Overall Equipment Effectiveness)
Formula: OEE = Availability × Performance × Quality
Concept: Product of Availability × Performance × Quality.
Challenge: Overly complex OEE dashboards confuse operators.
Fix: Simplify. Focus on one loss type each week.
Quick Win: If performance is the issue, reduce small stoppages first — it’s the hidden goldmine.
# 20 – Capacity Utilization
Formula: Capacity Utilization = (Actual Output / Potential Output) × 100
Concept: Actual output vs. potential output.
Challenge: Teams overplan capacity or underutilize it.
Fix: Track weekly utilization by line or plant. >90% means risk of overload.
Quick Win: Shift production of low-volume SKUs to off-peak hours. Frees space for core products.
#21 – Schedule Adherence
Formula: Schedule Adherence = (On-Time Jobs / Total Jobs) × 100
Concept: Jobs completed as planned.
Challenge: Frequent rescheduling erodes trust in the plan.
Fix: Freeze the schedule for 24–48 hours before execution.
Quick Win: Measure adherence weekly and discuss misses with planners. Alignment improves fast.
LOGISTICS METRICS
# 22 – On-Time Delivery
Formula: OTD = (Shipments on Time / Total Shipments) × 100
Concept: Shipments that reach customers on or before the promised date.
Challenge: Late shipments often blamed on carriers instead of internal delays.
Fix: Break OTD by carrier, route, and warehouse.
Quick Win: Identify top 3 lanes causing delays and reassign them. You’ll see results in weeks.
# 23 – Dock-to-Stock Time
Formula: Dock-to-Stock = Receipt to Inventory Availability (hours or days)
Concept: Time from receiving goods to availability in inventory.
Challenge: Poor staging or inspection delays slow operations.
Fix: Redesign receiving flow to separate urgent vs. normal loads.
Quick Win: Pre-assign dock doors to frequent suppliers. Cuts receiving time instantly.
# 24 – Freight Cost per Unit
Formula: Freight Cost per Unit = Total Freight Spend / Units Shipped
Concept: Total freight spend divided by units shipped.
Challenge: Hidden costs from poor consolidation or LTL shipments.
Fix: Group small orders and optimize load planning.
Quick Win: Review last month’s small shipments. Consolidate two per week — quick savings without changing rates.
# 25 – Shipping Accuracy
Formula: Shipping Accuracy = (Correct Shipments / Total Shipments) × 100
Concept: Correct shipments vs. total shipments.
Challenge: Errors due to manual picking or labeling.
Fix: Implement barcode scanning or pick verification.
Quick Win: Audit 10 random shipments per day — accuracy improves immediately.
# 26 – Damage Rate
Formula: Damage Rate = (Damaged Goods / Total Shipped) × 100
Concept: Percentage of goods damaged in transit or warehouse.
Challenge: Poor packaging or handling practices.
Fix: Track damages by carrier and SKU. Share photos with vendors.
Quick Win: Introduce “damage-free” bonuses for warehouse shifts. Simple, effective motivator.
# 27 – Warehouse Utilization
Formula: Warehouse Utilization = (Used Space / Available Space) × 100
Concept: Used vs. available storage space.
Challenge: Poor layout hides available capacity.
Fix: Use visual maps or heatmaps to see space use.
Quick Win: Re-slot top 10 fastest-moving SKUs closer to shipping — cuts travel time instantly.
# 28 – Transportation Utilization
Formula: Transportation Utilization = (Used Load / Total Load Capacity) × 100
Concept: How fully truck or container space is used.
Challenge: Shipments go half-full to meet service promises.
Fix: Use load optimization tools or delay non-urgent shipments to fill trucks.
Quick Win: Track average cube utilization weekly. Every 10% gain saves direct cost and carbon emissions.
Conclusion
Pick the few metrics that truly matter for your role. Track them consistently. Act accordingly.
Small, steady improvements in accuracy, cost, uptime, and delivery compound fast.
Master these 28 metrics for excellent performance.
