Sample output from the Component Shortage Dependency Graph prompt in the Sonar AI Prompt Library, run against a NetSuite test account. Every name and number here is test data. Back to the post · The library

Component Shortage Dependency Graph Chokepoint Analysis

Open work orders (Planned / Released / In Process) vs. available + on-order inventory · Account TD3092577 · 2026-08-09
$151,199
Customer orders blocked
$14,580
Cost to clear all 4 chokepoints
10.4×
Overall leverage
33
Blocked customer WOs
7
Customers waiting
12
Parts short
💡 The asymmetry: KAP001 (Kapton Plastic, a $2.10 part) is the sole blocker on 13 work orders feeding $43,655 of sales orders for 4 customers. Buying the missing 1,442 units costs $3,028 — a 14.4× buy-back. Likewise, a 5¢ carton (CTN002) plus lime juice and garbanzo beans — $11,552 of ingredients — gate $107,544 of food shipments to 3 wholesale customers.
Dependency Network — shortages ◀ work orders ◀ sales orders ◀ customers
Shortage (size = cost to fill — note how small they are) Blocked work order Sales order (size = $) Customer (size = total $ waiting) Stock builds (no customer yet)
Hover any node for details · click a shortage to light up everything it blocks · drag nodes to untangle · scroll to zoom.
Chokepoint Leverage Table — smallest lever, biggest unlock first
ComponentBlocksUnit costShort byCost to fillCustomer $ gatedLeverageAction
KAP001 — Kapton Plastic13 WOs · 4 CUSTOMERS$2.101,442$3,028$43,65514.4×PO today — sole blocker
LIM002L — Lime Juice20 WOs · 3 CUSTOMERS
joint blockers —
all 3 needed
$0.1018,025$1,803$107,5449.3×
as a set
PO as a set —
GAR002 — Garbanzo Beans$0.506,427$3,213partial fills
CTN002 — Carton, 8 oz$0.05130,725$6,536unlock nothing
SOTAL002L — Sodium Tallowate15 STOCK WOs$2.0062,153$124,305$0 directStock replenishment — schedule, don't expedite
ALE002L — Aloe Leaf ExtractSTOCK WOs$4.002,999$11,994$0 direct150 on order; top up
GLY002L — GlycerinSTOCK WOs$3.002,906$8,717$0 direct300 on order; top up
MM-Cowhide20 STOCK WOs$0.1030,608$2,976$0 directCheap fill, low urgency
OWRAP002 / HWRAP001 — wrapsSTOCK WOs$0.0472,000 ea$5,760$0 directBundle with carton PO
LAN-COM-0017 STOCK WOs$12.00283$3,396$0 direct100 on order; top up
SOPLM001L — Sodium PalmateSTOCK WOs$3.00306$919$0 direct100 on order; top up
Who's waiting
CustomerOrders blocked$ waitingBlocked by
Restaurant Wholesale Inc6$45,509Food trio (CTN002 · LIM002L · GAR002)
Premium Victualers Supply7$40,479Food trio
Riverboat Manufacturing4$22,385KAP001
Dabfeed Provisions7$21,557Food trio
Jones Manufacturing4$10,801KAP001
MacroVision4$5,344KAP001
Polycon Corporation1$5,124KAP001