Supply chain control tower dashboard: views and inputs

A supply chain control tower dashboard brings late customer orders, delayed inbound receipts and inventory exposure across sites into one exception review. Build the view around a common cutoff, source records and named owners. A periodic export can support that review without representing current dispatch status.

The useful difference from a general supply chain dashboard is the path from an exception to the person who must check it. A red total without the affected order or receipt is a prompt to investigate, not an actionable work list.

Start with separate, dated exports

Use customer order lines, open purchase order receipt lines and an inventory snapshot. Preserve each file's natural row: an order line, a scheduled receipt line, or a site-item balance. Do not combine them into a wide table that repeats stock beside every order.

Record the extraction time and business cutoff on the review. In this example, a US industrial distributor reviews open records as of October 23, 2026. An unfulfilled commitment dated before that day is late; a commitment dated on that day is still due today.

Keep site codes consistent across files. Include the item, source identifier, due date, open quantity and responsible team wherever relevant. If receipt dates mean dock arrival at one site and goods acceptance at another, agree on a common definition before comparing them.

Flag customer commitments that are already late

On an Orders sheet, columns A through F contain these source fields. Columns G and H are calculated. All dates are actual spreadsheet dates, displayed in US format.

Set K1 to =DATE(2026,10,23). In G2 and H2, enter the following Excel formulas and fill down:

=--AND(D2>0,C2<$K$1)
=IF(G2=1,$K$1-C2,0)

These formulas assume required dates and quantities have already passed validation. Route blanks to a correction list rather than treating them as clean records.

There are 2 late lines out of 4 open lines: 50.0%. Their open value is 1,200 + 1,000 = $2,200, compared with total open value of 1,200 + 900 + 1,000 + 500 = $3,600. The late-value share is 2,200 / 3,600 = 61.1%, rounded to one decimal. It differs from the line percentage because order values differ.

Keep receipt delays and stock gaps distinct

The Inbound sheet has receipt identifier, site, expected date, outstanding units and owner in columns A through E. Its calculated delayed flag is column F.

In F2, fill down:

=--AND(D2>0,C2<Orders!$K$1)

Next, prepare an Inventory sheet. Available units are saleable units available to these overdue orders, including stock allocated to them and excluding blocked stock or stock reserved for other demand. Overdue demand is the open customer quantity already past its promise date, matched by site and the item in column I of Orders.

Columns F and G are:

=MAX(D2-C2,0)
=F2*E2

Dallas has 40 - 25 = 15 gap units, valued at 15 × 20 = $300. Reno has 20 - 12 = 8, valued at 8 × 35 = $280. The combined gap value is $580. This is a prioritization measure at standard cost, not a loss estimate or a complete replenishment calculation.

Build the site comparison and prove it

Put the site name in A2 of a summary sheet. Use these formulas for late lines, late-order value, delayed receipt lines and gap value:

=COUNTIFS(Orders!$B$2:$B$5,A2,Orders!$G$2:$G$5,1)
=SUMIFS(Orders!$E$2:$E$5,Orders!$B$2:$B$5,A2,Orders!$G$2:$G$5,1)
=COUNTIFS(Inbound!$B$2:$B$4,A2,Inbound!$F$2:$F$4,1)
=SUMIFS(Inventory!$G$2:$G$3,Inventory!$A$2:$A$3,A2)

Microsoft documents COUNTIFS as counting rows that meet all specified criteria. Its SUMIFS documentation describes the corresponding sum across qualifying rows.

Each summary column must tie to its own source table. The late list must contain O101 and O103 exactly once. The delayed list must contain I201 and I202 exactly once. The inventory amounts must sum to $580 without being repeated for each order.

Use a site comparison above a detailed exception table. Let the detail retain dates, item codes and owners. For spreadsheet presentation choices, see the supply chain KPI dashboard in Excel; for another presentation approach, see the Tableau supply chain dashboard preparation guide.

Where it goes wrong

• Different cutoffs. Yesterday's inventory beside today's orders can create an apparent shortage that a completed receipt already resolved.
• Repeated inventory. Joining stock to order lines can multiply the same balance. Summarize each source at its own level first.
• Conflicting valuation bases. Customer sales value and standard-cost gaps answer different questions. Show them in separate columns.
• Owners without decisions. An owner name is useful only when the review records what that team will confirm and when it will report back.

Keep a separate record of decisions and verify status with the responsible team before acting. AI analytics for supply chain explains the broader file-based analysis context. Covirage is not affiliated with Microsoft.

Compare your own exception exports in Covirage

Bring a sample of your own order, receipt and inventory exports to Covirage. Covirage maps the columns, its tools compute and check the site comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring your files.

See Covirage for supply chain teams for the supporting industry context.