Q1 — does stock go negative at intermediate storage?

From the precomputed location_balance: lowest the running stock ever reaches (opening 31-Mar-2024 + time-ordered trip in/out). Restricted to jetty / plant / stockyard / port (intermediate storage), because mines & out-of-Goa suppliers are unbounded sources (production / imports enter as a permit origin, not a trip) and would go "negative" as a data-boundary artifact. Royalty has no 2024 opening baseline, so its negatives are not conclusive.

SELECT location, ore_stream, location_type,
       min_running_balance, min_balance_dt, has_2024_baseline
FROM location_balance
WHERE goes_negative = 1
  AND location_type IN ('jetty','plant','stockyard','port')
ORDER BY min_running_balance;