The replenishment review that recommends almost no buying.
7 order signals. 7 cancellations. 2 transfers that beat purchases.

SELECT m.item_id, COUNT(*) AS months_active,
       ROUND(AVG(m.qty),3) AS avg_mo, ROUND(AVG(m.qty*m.qty),3) AS avg_mo_sq,
       MAX(m.qty) AS max_mo, SUM(m.qty) AS total_12m
FROM (
  SELECT tl.item AS item_id, TO_CHAR(t.trandate,'YYYY-MM') AS mth,
         SUM(ABS(tl.quantity)) AS qty
  FROM transaction t
  JOIN transactionline tl ON tl.transaction = t.id
  WHERE t.type IN ('CustInvc','CashSale')
    AND tl.mainline='F' AND tl.taxline='F'
    AND tl.item IS NOT NULL AND tl.subsidiary <> 4
    AND t.trandate >= ADD_MONTHS(TRUNC(SYSDATE), -12)
  GROUP BY tl.item, TO_CHAR(t.trandate,'YYYY-MM')
) m
GROUP BY m.item_id
-- STDDEV() is rejected by this instance's SuiteQL ("Invalid or unsupported search").
-- σ = SQRT(AVG(x²) − AVG(x)²) computed in the sandbox over 12 buckets incl. zeros.

SELECT po.entity AS vendor_id, v.companyname,
       COUNT(DISTINCT po.id) AS pos_received, COUNT(*) AS receipt_lines,
       ROUND(AVG(TRUNC(r.trandate)-TRUNC(po.trandate)),2) AS avg_lead,
       ROUND(AVG((TRUNC(r.trandate)-TRUNC(po.trandate))
               * (TRUNC(r.trandate)-TRUNC(po.trandate))),2) AS avg_lead_sq,
       MAX(TRUNC(r.trandate)-TRUNC(po.trandate)) AS max_lead,
       MIN(TRUNC(r.trandate)-TRUNC(po.trandate)) AS min_lead
FROM transaction r
JOIN transactionline rl ON rl.transaction=r.id AND rl.mainline='F' AND rl.item IS NOT NULL
JOIN transaction po ON rl.createdfrom=po.id AND po.type='PurchOrd'
JOIN vendor v ON v.id=po.entity
WHERE r.type='ItemRcpt' AND r.trandate >= ADD_MONTHS(TRUNC(SYSDATE),-24)
GROUP BY po.entity, v.companyname
-- ItemRcpt→PO lineage is on transactionline.createdfrom, line level.

SELECT po.entity AS vendor_id, v.companyname, COUNT(*) AS po_lines,
       ROUND(AVG(TRUNC(pol.expectedreceiptdate)-TRUNC(po.trandate)),2) AS avg_quoted_lead,
       SUM(CASE WHEN pol.isclosed='F'
             AND ABS(pol.quantity)-NVL(pol.quantityshiprecv,0) > 0 THEN 1 ELSE 0 END) AS open_lines,
       SUM(CASE WHEN pol.isclosed='F'
             AND ABS(pol.quantity)-NVL(pol.quantityshiprecv,0) > 0
             AND pol.expectedreceiptdate < TRUNC(SYSDATE) THEN 1 ELSE 0 END) AS open_past_promise
FROM transaction po
JOIN transactionline pol ON pol.transaction=po.id AND pol.mainline='F' AND pol.item IS NOT NULL
JOIN vendor v ON v.id=po.entity
WHERE po.type='PurchOrd' AND po.trandate >= ADD_MONTHS(TRUNC(SYSDATE),-24)
GROUP BY po.entity, v.companyname
-- Companion query joins receipts to promised dates per item-vendor pair:
-- AVG(TRUNC(r.trandate) − TRUNC(pol.expectedreceiptdate)) = received-vs-promise.

SELECT iv.item, iv.vendor, v.companyname, iv.purchaseprice, iv.preferredvendor
FROM itemvendor iv
JOIN vendor v ON v.id = iv.vendor
WHERE iv.subsidiary = :primarySub OR iv.subsidiary IS NULL

SELECT iil.item, iil.location, loc.name,
       iil.quantityonhand, iil.quantityavailable,
       NVL(iil.quantitycommitted,0) AS committed,
       NVL(iil.quantitybackordered,0) AS backordered,
       NVL(iil.quantityonorder,0) AS on_order
FROM inventoryitemlocations iil
JOIN location loc ON loc.id = iil.location
WHERE NVL(iil.quantitybackordered,0) > 0
   OR NVL(iil.quantitycommitted,0) > NVL(iil.quantityavailable,0)
-- Plus per-location 12-mo demand (Q1 grouped by tl.location) to direct transfers
-- from surplus sites that retain cover above their own ROP after the move.

Available as the review workbook — the appendix arrays were computed in-session
(evalJs, Acklam inverse-normal for z) and are reproducible from Q1–Q5 plus the
model formulas in §02. Request "export the replenishment workbook as CSV" to
regenerate the full table as a file.