Mr. Proper Manufacturing Graph

Which suppliers indirectly support which products, through materials and formulas?

MATCH (s:Supplier)-[:SUPPLIED]->(m:RawMaterial)
  -[:USED_IN]->(f:Formula)-[:PRODUCES]->(p:Product)
RETURN s.name, m.name, f.productName, p.title

Materials sourced from only one supplier — a single point of failure in production.

MATCH (s:Supplier)-[:SUPPLIED]->(m:RawMaterial)
WITH m, collect(DISTINCT s.name) AS suppliers
WHERE size(suppliers) = 1
RETURN m.name, suppliers[0] AS soleSupplier

Trace every ingredient that goes into a product formula, with costs.

MATCH (m:RawMaterial)-[r:USED_IN]->(f:Formula {id: "form-tile"})
RETURN m.name, r.quantity, r.totalCost
ORDER BY r.totalCost DESC