Supply chain analytics that answers any backorder or stock question in seconds, from the source systems
Any backorder or stock question answered in seconds, from the source systems.
See one case, screen by screen ↓It is the analysis planners and supply chain leaders run on backorders, stock, shipments and forecasts to prevent shortages and answer the market. Supply Chain Analytics lets them ask in plain words and get the answer as a chart, with its numbers, the source systems and the read-only query beneath it.
How to choose AI solutions for life sciences →
Updated
The fixed dashboard answers the questions someone thought of last year. A new one that cuts across systems — weeks of cover by market for one brand, net of allocations, against the approved S&OP forecast — needs stock from the ERP, demand from the planning system and a decision on what counts as free stock. It goes to an analyst's queue, and the planner waits while a shortage call is on the calendar.
Self-service tools that query through one shared account make it worse in a different way: the screen checks access, the query does not. A country lead sees another market's stock and allocations, or a planner sees supplier prices. So the extract is cut by hand for each reader, and nobody can say afterwards which table and which forecast version a number came from.
Estimated split for one new cross-system question, such as weeks of cover by market for a brand, answered by analyst request and with the solution.
Six agents screen, route and answer every question read-only, inside the asker's access; a supply chain leader validates shared answers.
Tuesday, October 6, a little before ten. Lena Ortiz, supply chain director for EMEA, runs the weekly S&OP and shortage calls with country managers. She needs to know where Veltrimab — a 2–8 °C biologic in 150 mg and 300 mg prefilled syringes — is running short. Here is what happens next, screen by screen, in the working solution.
Her home is the question box and the last answers, on ERP and supply planning data as of 06:10 today. Already answered for her team this morning: 6 of 14 EMEA backorder SKUs have stock arriving this week, 7 SKUs at Plant 3 — Leiden are below safety stock, and 5 of 6 product families are inside the 20% forecast accuracy target.
“Ask in plain words. The answer comes back as a chart, with its numbers, the source systems and the query beneath it — drawn only from the markets you may see.”
The question screener reads it as a read-only request, brand Veltrimab, grouped by market. Then Lena's access is applied — EMEA, 9 markets, cost visible. The orchestrator sends it to two specialists: Inventory for free stock in the ERP, net of allocations, and Forecast for weekly demand in the September S&OP plan.
Each step shows as it runs, with its time: screened in 0.2 s, access applied in 0.1 s, routed in 0.3 s.
The bars draw against the 3-week minimum and 4-week target: Belgium 1.6 and the United Kingdom 2.2 are below the minimum, Italy sits at 3.1, the Nordics lead at 9.1. EMEA overall is 5.2 weeks on 8,699 free syringes. The 1,500 syringes arriving at DC Eindhoven on Oct 8 (SHP-EU-40809) count once received.
“Showing 9 of 13 markets · 4 outside your access are left out of the chart, the total and the query.”
Stock comes from ERP inventory (inv.stock_on_hand, 06:05 today, 118 rows), demand from the supply planning system (pl.demand_forecast, September S&OP of Sep 29, 36 rows). Both read-only queries carry the market filter. Weeks of cover is free syringes — unrestricted stock minus units allocated to open orders — divided by the average weekly forecast for the next four weeks.
Stock in transit or on quality hold is left out until it is received and released.
Sam is the Central Europe planner. As him, the chart redraws with his four markets — Germany, Switzerland, the Netherlands and Belgium: 6.8 weeks overall, 1 of 4 below the minimum, 4,239 free syringes. Value at standard cost is masked, because planners do not read cost.
“Preview narrows only — it never shows more than you may see. Every preview is kept in the audit trail.”
Grace is the commercial lead for the UK and Ireland, answering hospital trusts and wholesalers. Her view shows one market: the United Kingdom at 2.2 weeks — 572 free syringes against 260 a week, below the 3-week minimum. The other 12 markets are counted, never named, never in her total.
Two specialists, joined on SKU, in 2.9 s: 6 of the 14 SKUs on backorder in EMEA have stock arriving Oct 5–11 — 7,800 units against 6,295 backordered. Four are fully covered. CVT-SH-7F11 and NXL-DES-2515 stay short by 490 units between them. NXL-BC-3020 lands Oct 10 but needs incoming quality release, so it can ship from Oct 12.
The orchestrator joined the two results in the answer itself — the warehouse only ever saw two read-only queries.
The follow-up carries over the 6 SKUs, so nothing is asked twice. CVT-SH-7F11's shortfall grows from 280 to about 1,480 units before the Nov 2 receipt, and demand has run 14% above forecast for eight weeks. NXL-DES-3018 runs out around Oct 17 and is about 300 units short until the Oct 21 receipt.
Forecast is the approved September S&OP version (SOP-2026-09); bias is shown with its sign so the planner can judge it.
The screener reads write intent and stops the question before it reaches the orchestrator. No SQL is written and no table is touched; the full text goes to the audit trail for the quality reviewer. ETAs, orders and stock are changed in their own systems by the teams that own them.
“This asks to change data. Supply Chain Analytics only reads.”
The EMEA arrivals answer is in the Library, validated, re-run at 06:12 after the morning load and sent to the EMEA planning team every Monday at 07:00. Its history shows each re-run and Lena's validation, which saved the expected answer for the nightly check.
History: “Lena Ortiz validated it — expected answer saved for nightly runs”
The same Veltrimab answer, seen by the five people who ask, approve and check it — what their week looked like, and what it looks like now.
Six agents screen, route and answer every question read-only, inside the asker's access; a supply chain leader validates shared answers.
Checks every question before it is routed — stops requests to change data, requests for personal or restricted data, and instructions hidden in a question — and explains a stop in one plain sentence.
Reads each question, picks the specialists, chains them for multi-part questions, passes SKUs, regions and weeks between them, joins their results and draws the chart. Carries context from earlier answers in the conversation.
Answers questions about open backorders — which SKUs, which customers, how old, how much — with one read-only query per question.
Answers questions about free stock, cover, safety stock, shelf life and confirmed receipts by site.
Answers questions about inbound shipments — what is moving, when it lands by carrier ETA, delays and cold-chain logger status.
Answers questions about demand forecast, accuracy and bias by SKU, product family and region, reporting bias with its sign.
Validates the answers the team shares. The agents propose; a named person decides.
Besides the questions that come back as charts, the assistant explains who sees what, sets a watch on a number, schedules a saved answer for a colleague or requests a table — always inside the same rules.
Who can see the Veltrimab cover answer?
Each person sees it inside their own access. You see 9 EMEA markets and the value at standard cost. Sam Patel sees 4 markets — Germany, Switzerland, the Netherlands and Belgium — with cost masked. Grace Whitfield sees the United Kingdom only. Nobody sees a market total that includes rows they may not read.
Which EMEA SKUs are still short after this week's arrivals?
Two stay short: CVT-SH-7F11 by 280 units (next receipt Nov 2) and NXL-DES-2515 by 210 units (clears with the Oct 14 receipt). CVT-SH-7F11 is the one to watch — demand has run 14% above forecast for eight weeks.
Alert me when CVT-SH-7F11 backorders pass 1,000 units
Done. A watch is on CVT-SH-7F11 backordered units in EMEA — 880 today. The Backorders specialist checks it every hour after the warehouse refresh and notifies you when it passes 1,000. It reads the same table as your saved answer, so no new access was needed.
Let the Forecast specialist read supplier lead times
A request is raised to add md.supplier to the Forecast specialist's tables. It already serves Inventory and In-transit. Omar Haddad owns the data and decides; until he approves, the Forecast specialist cannot read it.
13 screens from the working solution, on its sample data. Pick one to see it large.
Read-only queries, answering inside the asker's access and saying what was left out are always on. The rest are settings your team chooses.
| Setting | Default | Choose from |
|---|---|---|
| Rows per query | 5,000 | Step up or down; larger results are cut and the answer says so |
| Time per query | 30 seconds | 15 · 30 · 60 seconds |
| Screen every question | On | On · Off |
| Weeks-of-cover thresholds | Minimum 3 wk · target 4 wk | Minimum 2 wk · target 4 wk · Minimum 3 wk · target 4 wk · Minimum 4 wk · target 6 wk |
| Refresh saved answers | Every morning, 06:15 | Every morning, 06:15 · Every hour · Only when opened |
| Flag numbers that move | 10% | 5% · 10% · 20% |
| Who may preview as a colleague | Supply chain leaders | Supply chain leaders · Leaders and data owner · Nobody |
| Add a table to a specialist — who approves | Omar Haddad | Omar Haddad · Lena Ortiz · Sam Patel · Dana Okafor |
Every figure is labelled: a target the solution is built to, an estimate, a typical published result, or a proven one.
“demo” = seen in the working solution, on its sample supply data · “target” = the design goal, measured in the live solution · “estimated” = our estimate · “typical” = published figures (CEL planning study — 41% of planning time spent on data preparation). People, products, shipments, sites and hospitals named on this page are fictional — characters and sample data in the working solution.
It is the analysis planners and supply chain leaders run on backorders, stock, shipments and forecasts to prevent shortages and answer the market. Supply Chain Analytics lets them ask in plain words and get the answer as a chart, with its numbers, the source systems and the read-only query beneath it.
A question screener checks the request, then an orchestrator sends it to the specialists it needs — here Inventory for free stock in the ERP and Forecast for weekly demand in the approved S&OP plan. Each runs one read-only query on its own tables, and the orchestrator draws the chart. On the sample data, that took 2.6 seconds.
No. A market filter from the person's role is part of every query, so rows outside their access never leave the source system. The chart says how many markets it left out without naming them or adding them to a total, and cost is masked for people who do not read it.
No. Only SELECT statements reach the warehouse, enforced on the connection. A request to change data is stopped at screening before any query is written, and the stop is logged with the full text.
Every answer shows its tables, refresh times, row counts, the query and the reasoning behind its definitions, such as which forecast version and why quality-hold stock is left out. A supply chain leader validates answers the team shares, and validated questions are re-asked every night against their expected answers.
Yes. A supply chain leader validates shared answers and can preview them as a colleague — preview only narrows. The data owner approves every new table for a specialist and every change to a person's markets, and supplier prices stay restricted for everyone.
The ERP for stock, orders and receipts, the supply planning system for approved S&OP forecasts and accuracy, transport management for inbound shipments and cold-chain loggers, product and location master data, and the supplier portal. Saved answers re-run after the morning warehouse load.
The Agentic Solution Engine builds and deploys it from your requirements and documents — your table catalog, access rules by market and a set of real questions with agreed answers — and it goes live once every quality gate has passed. We will walk you through it on your own questions first.
A new data assistant built by an analyst in minutes, with no code.
1-min demoDrug Shortage Early WarningRanked, cited shortage alerts raised weeks before stock runs out.
1-min demoTemperature Excursion ManagementEvery temperature alarm turned into a cited release-or-reject call in hours.
1-min demoWe'll run Supply Chain Analytics on your own backorder, stock and forecast questions.