Supply Chain Resilience: 5 Dashboards Every COO Needs

A supply planning dashboard is the operating system for resilience: it shows whether demand, inventory, capacity, and supplier commitments still line up this week — and which exceptions need a decision today. COOs who treat dashboards as slideware get blindsided by stockouts, expedites, and margin leakage. COOs who treat five decision-grade views as a control loop absorb shocks without drowning the P&L in safety stock.

This guide names those five dashboards, the metrics each must surface, the data systems that feed them, and how to set green/yellow/red thresholds so exceptions route to owners — not into another unread report.

Why resilience is a dashboard problem, not a slogan

Visibility alone is not resilience. Supply chain visibility means you can see inventory, orders, shipments, and partner status across tiers; a control tower goes further by aggregating ERP, WMS, TMS, planning, and partner signals so teams can plan and act in one loop. Industry coverage of control towers stresses the same shift: from static KPI screens to exception management, prediction, and what-if response (see AltexSoft’s overview of control-tower architecture and integrations at https://www.altexsoft.com/blog/supply-chain-control-tower-visibility/). Gartner and peer research repeatedly flag planning quality, multi-tier visibility, and inventory strategy as the capabilities that turn disruption from a crisis into a managed scenario.

Practitioners on the ground make the same point in blunter language: tracking OTIF and inventory turns is table stakes; the win is translating those metrics into cash released, revenue protected, and risk quantified. If your board pack still lists percentages without dollar impact, the dashboards are incomplete.

For mid-market manufacturers and distributors, the practical path is not a multi-year “tower” program. It is five focused views, wired to clean transactional data from your ERP and adjacent systems, with clear owners and cadences. Odoo Supply Chain and related inventory/purchase modules often sit at the center of that stack when teams want one system of record instead of a spreadsheet federation.

The five dashboards (and the decision each exists to force)

Treat each dashboard as a standing question the COO asks every operating rhythm:

1. Supply planning — Can we meet the plan with available supply, capacity, and lead times?
2. Inventory health — Where is cash trapped, and where is service at risk?
3. Supplier risk and performance — Which suppliers threaten the plan, and what is the dual-source status?
4. Fulfillment and service (OTIF / perfect order) — Are customers receiving the promise we sold?
5. Cold chain and quality source of truth — Is product integrity intact from plant to customer when temperature, lot, or compliance matter?

Build these in order. Without a credible supply planning view, inventory and OTIF dashboards become forensic tools after the miss.

Dashboard 1: Supply planning dashboard

Primary job: Match unconstrained demand (or the consensus forecast) to constrained supply — materials, capacity, lead times, and open purchase/manufacturing orders — and flag the gap early enough to act.

Core metrics to show

• Forecast accuracy and bias (MAPE or WMAPE by product family; bias to catch systematic over/under-forecasting). Demand-planning practice treats MAPE as the standard closeness metric and WMAPE when high-volume SKUs should dominate the score (see SPS Commerce and demand-planning references on forecast accuracy hierarchies).
• Projected available-to-promise (ATP) or capable-to-promise (CTP) by week for A-items.
• Supply vs demand balance by product family and plant: surplus weeks, short weeks, and the first short week date.
• Purchase order and manufacturing order compliance: planned vs actual receipt and completion dates.
• Capacity utilization for constrained resources (critical work centers, cold rooms, packing lines) vs the load the plan implies.
• Expedite count and premium freight $ tied to planning misses (this is the P&L translation executives need).

Refresh cadence and owners

• Daily exception strip for A-items and customer-committed orders (S&OE).
• Weekly full planning pack for S&OP / SIOP (forecast accuracy, plan attainment, inventory days of cover planned vs actual).
• Owner: demand/supply planning lead; COO reviews exceptions and trade-offs, not every SKU row.

Data sources

ERP demand and order books, MRP/APS outputs, open POs and MOs, capacity calendars, and preferably a single consensus forecast rather than five departmental versions. When forecast and supply live in different tools, the dashboard must reconcile them explicitly or it will institutionalize false comfort.

Decisions this dashboard forces

• Pull in supply (expedite, alternate supplier, overtime) vs push out demand (allocate, re-promise, commercial conversation).
• Change safety stock or freeze horizon when bias and MAPE show the plan is systematically wrong.
• Prioritize capacity for margin or strategic accounts when load exceeds capability.

Starter green / yellow / red (tune to your industry)

• Forecast WMAPE: green under target band, yellow 1–1.5× target, red above 1.5× or rising three periods.
• First short week for A-items: green none in 4+ weeks, yellow inside 2–4 weeks, red inside 2 weeks with no recovery PO/MO.
• Plan attainment (receipts/completions on time): green ≥95%, yellow 90–95%, red under 90%.

This is the view that ranks for “supply planning dashboard” intent: not a pretty chart of last month’s history, but a forward shortfall radar with owners and actions.

Dashboard 2: Inventory health and working capital

Primary job: Show where inventory is insurance versus dead weight, and how many days of cover you actually hold by segment.

Core metrics

• Inventory turns and days of supply (IDS / DIO): turns = COGS / average inventory; days of supply ≈ average inventory / COGS per day (standard definitions used across manufacturing KPI guides such as https://www.mrpeasy.com/blog/supply-chain-kpis/).
• Days of cover by ABC class and by channel, planned vs actual.
• Stockout and near-stockout count (SKUs under safety stock or with projected stockout inside lead time).
• Excess and obsolete (E&O) value and aging buckets.
• Fill rate (order, line, and item variants) as the customer-facing complement to turns — high turns with collapsing fill rate is not a win.
• Cash released or trapped month over month when turns and E&O move.

Why COOs care

Inventory is working capital wearing a warehouse badge. A 15% turns improvement that is not translated into “$X cash freed” fails the executive language test that operators keep repeating in 2026 discussions: connect KPIs to EBITDA and cash, not vanity ratios.

Cadence and owners

Weekly for planners and plant/warehouse leads; monthly deep dive with finance on cash and E&O write-down risk. Owner: inventory control + finance business partner.

Threshold sketch

• A-item stockouts: green zero, yellow any near-stockout with recovery plan, red open stockout on committed demand.
• E&O as % of inventory: green under policy, yellow above policy, red rising two quarters.
• Days of cover: green inside target band by class, yellow outside band with explanation, red outside band with no action plan.

Dashboard 3: Supplier risk and performance scorecard

Primary job: Rank suppliers by how they threaten or protect the plan — delivery, quality, capacity concentration, and external risk signals — and drive dual-source and escalation decisions.

Modern scorecards mix operational KPIs (on-time delivery, defect/PPM, invoice accuracy) with compliance and third-party risk (financial health, sanctions, country risk, continuity plans). Vendor and supplier scorecard practice in 2025–2026 emphasizes real-time dashboards over annual PDF reviews, and weighted categories so “cheap but late” cannot hide behind a blended average (frameworks from procurement platforms and guides such as Ivalua, Amazon Business vendor scorecard guidance, and supplier performance management write-ups).

Core metrics

• Supplier OTIF / OTD and in-full rate (inbound).
• Quality: defect rate, PPM, return rate, CAPA aging.
• Lead-time reliability: promised vs actual, variability (not just mean).
• Concentration: % of spend or critical components on single source; dual-source readiness for A-parts.
• Risk flags: financial distress, geo/political exposure, audit findings, contract and insurance status.
• Responsiveness: acknowledgment time, expedite acceptance rate.

Cadence and owners

Monthly scorecard review for strategic suppliers; weekly exception alerts for critical misses. Owner: procurement / supplier development with quality and planning in the room.

Decisions

• Dual-source or safety stock for single points of failure.
• Volume shift and business reviews with clear score thresholds.
• Exit or new-source projects when red status repeats without recovery.

Threshold sketch

• Inbound OTIF: green at/above SLA (often 95%+; retail/OEM contracts may demand 98%), yellow 1–3 points under, red chronic underperformance.
• Single-source A-parts without qualified alternate: always yellow or red until dual path exists.
• Open critical CAPAs past due: red.

Dashboard 4: Fulfillment and service — OTIF, fill rate, perfect order

Primary job: Measure the promise the customer actually experienced, not only when the truck left the dock.

OTIF (On Time In Full) is the percentage of orders delivered on time and complete; fill rate measures how much demand you satisfied from stock or first shipment without the full timing dimension. Guides from Kaizen, MRPeasy, FourKites, and others agree on the split: fill rate is availability; OTIF is reliability of the full customer experience. Practitioners also warn that warehouse-scored OTIF often diverges from customer-scored OTIF/DIFOT when “on time” is measured at ship rather than at delivery — align the definition with commercial SLAs.

Core metrics

• OTIF / DIFOT by channel, customer tier, and ship-from.
• Order, line, and SKU fill rates.
• Perfect order rate (on time, in full, damage-free, correct documentation).
• Late root-cause tags: inventory, pick/pack, carrier, address/data, credit hold.
• Cycle time: order-to-ship and order-to-deliver.
• Cost of poor service: expedites, penalties, credits, lost-order estimates.

Benchmarks to contextualize (not copy blindly)

Industry commentary often treats OTIF above ~95% as strong, with critical industries aiming 98–100% consistency rather than a one-time peak (see Kaizen’s OTIF guidance at https://kaizen.com/insights/otif-supply-chain-indicator/). Walmart-class retail OTIF programs historically push high nineties with financial consequences for misses — use contract language as your true target.

Cadence and owners

Daily for DC and customer-service exceptions; weekly trend for COO and commercial leadership. Owner: fulfillment / logistics with sales ops on customer escalations.

Threshold sketch

• OTIF: green at SLA, yellow 1–2 points under, red 3+ under or any strategic account miss without recovery.
• Perfect order: track damage and documentation separately so “in full and on time but wrong paperwork” does not disappear.

Dashboard 5: Cold chain and quality source of truth

Primary job: One authoritative view of product integrity — especially temperature, humidity, lot genealogy, and excursion history — so quality, logistics, and commercial teams argue from the same facts.

This is the niche intent behind queries like “cold chain source of truth dashboard.” Pharma, biologics, food, chemicals, and high-value perishables lose product and trust when sensor data, warehouse logs, and carrier claims live in separate inboxes. Industry estimates of cold-chain waste in pharma run into the tens of billions annually; monitoring vendors stress real-time alerts, centralized multi-site dashboards, and audit-ready excursion reports (see e.g. cold-chain monitoring guidance from Eupry, Sensitech, and related integrity KPI summaries).

Core metrics

• Temperature exceedance rate: share of shipments or storage intervals with at least one out-of-range event.
• Time-out-of-range and mean time to detection / intervention.
• Spoilage, discard, and write-off value by SKU and route.
• Lane and 3PL integrity scores (repeat excursion partners).
• Lot/serial genealogy: ability to answer “where is this lot and has it ever been out of range?”
• Audit packet completeness: sensor calibration status, continuous logging coverage, exception closed-loop rate.

Cadence and owners

Real-time alerts to quality and logistics; daily open-excursion board; monthly integrity review. Owner: quality assurance with logistics as co-owner; IT/ERP owns the identity of lot and location so sensor events attach to the right inventory.

Source of truth rules

• One product identity (lot/serial) shared across ERP inventory, WMS locations, and IoT platforms.
• Excursions create a quality disposition workflow — quarantine, release, scrap — not only a chart.
• Customer-facing claims use the same record the warehouse used at ship confirmation.

Threshold sketch

• Open unreviewed excursions: red until dispositioned.
• Exceedance rate above policy or rising trend: yellow/red by severity and product criticality.
• Missing continuous logging coverage on validated lanes: red for regulated products.

Data architecture: how the five views stay honest

Pretty BI on dirty data creates confident wrong decisions. A resilient stack usually looks like this:

• ERP as system of record for items, BOMs, orders, inventory valuation, and financials (including manufacturing ERP for plant-centric operations).
• WMS for warehouse tasks, locations, and pick accuracy.
• TMS / carrier feeds for in-transit status and delivery events (critical for true customer OTIF).
• APS / MRP / planning for time-phased supply and capacity.
• Quality / QMS and IoT for deviations, CAPAs, and cold-chain telemetry.
• Supplier portal or EDI for ASN, confirmations, and inbound OTIF.

Control-tower literature describes the same pattern: internal systems plus external partner and market data into a hub that supports monitoring, prediction, and action — not five disconnected exports. For growing companies, logistics and supply chain processes often start cleaner when inventory, purchase, barcode, and accounting share one Odoo (or equivalent) backbone before you bolt on specialized visibility tools.

Implementation order that avoids dashboard theater

1. Fix master data and unit of measure consistency for A-items.
2. Agree metric definitions in writing (especially OTIF ship vs deliver, fill rate order vs line).
3. Ship the supply planning exception strip and OTIF daily board first.
4. Add inventory health and supplier scorecards once receipt and issue transactions are trustworthy.
5. Layer cold-chain/quality when sensors and lot IDs are integrated, not as a standalone pilot that never hits inventory status.

How to run the operating rhythm

Dashboards fail when nobody owns the red cells. Use a simple exception protocol:

• Green: monitor on standard cadence; no meeting time.
• Yellow: owner posts recovery plan within one business day; appears on weekly ops review.
• Red: same-day owner assignment, commercial or procurement notified if customer or supply impact is material, and COO visibility until green or accepted risk.

S&OP monthly should review forecast accuracy, inventory days of cover planned vs actual, capacity, and supplier concentration. S&OE daily/weekly should live inside dashboards 1 and 4. Translate every “we improved turns” story into cash and every “OTIF dipped” story into revenue at risk and expedite cost — the framing that actually moves executive attention.

Common failure modes

• Too many KPIs, no decisions. Start with the metrics listed above; expand only when an exception repeatedly lacks a signal.
• Ship-time vanity OTIF. If customers score delivery and you score dock departure, you will celebrate while accounts churn.
• Safety stock as the only resilience lever. Excess inventory hides bad forecast bias and single-source risk until cash is tight.
• Supplier scorecards without consequences. If red scores never shift volume, the scorecard is theater.
• Cold chain charts without quarantine workflow. Seeing an excursion without binding inventory is not a source of truth.

FAQ

What belongs on a supply planning dashboard first? Forward supply-demand balance for A-items, first short-week dates, open PO/MO attainment, constrained capacity load, and forecast accuracy/bias. History charts are secondary to the next shortage you can still prevent.

How is OTIF different from fill rate? Fill rate answers whether you could fulfill quantity from available supply; OTIF answers whether the order arrived complete and on time. You can have strong fill rate and weak OTIF if deliveries are late, and the reverse if partials ship on time.

Do we need a full control tower before these five views? No. Most mid-market teams get more resilience from clean ERP/WMS data and five decision dashboards with owners than from a branded tower on top of siloed truth. Grow the hub as multi-tier and multi-modal visibility becomes the binding constraint.

What is a cold chain source of truth dashboard? A single pane where lot identity, location, sensor history, excursion status, and quality disposition agree — so logistics, quality, and customers do not maintain parallel stories. It is mandatory for regulated or high-spoilage categories; optional only if temperature never affects product value or compliance.

How should a COO use these without living in BI? Review red exceptions and dollar impact weekly; audit metric definitions quarterly; demand that each dashboard names an owner, a cadence, and the decision it is allowed to trigger. Skip green-status page flips.

Turning dashboards into a durable operating system

Resilience is the ability to see a break early, choose among real options (expedite, reallocate, dual-source, re-promise), and measure whether the choice worked — without permanent overstock. The five dashboards above encode that loop: plan integrity, inventory cash, supplier risk, customer promise, and product integrity.

If your current stack is spreadsheets plus lagging monthly packs, start by defining OTIF and short-week rules, wiring a daily exception board from the ERP, and assigning red-cell owners. When you are ready to unify inventory, purchasing, manufacturing, and reporting on a modern platform, ERP implementation services that respect process design — not just chart building — are what make these views trustworthy at scale. Flectic helps operations teams design that lifecycle: discovery, requirements, process mapping, configuration, integrations and data migration, QA/UAT, go-live training, and continuous optimization so the COO’s five dashboards stay decision tools, not wallpaper.