“What does one batch of each cookie cost us to make?”

Every step the AI took

1. 1
   Checked the saved queries
   6 saved queries
2. 2
   Read the Fishbowl notes index
   13 topic notes
3. 3
   List bills of materials to find the cookie recipes and compute cost per batch

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT b.id, b.num, b.description, b.activeFlag
   FROM bom AS b
   ORDER BY b.num
   LIMIT 501

   14 rows · 252 ms
4. 4
   Get every line of the cookie bills of materials with quantity, unit conversion and part cost to compute cost per batch

   Now pulling BOM lines with part costs for the cookie BOMs

   ✓ passed read-only checkrow cap applied

   Show the SQL

   SELECT b.id AS bomId, b.num AS bom, bi.id AS itemId, bi.typeId, bit.name AS itemType, p.num AS part, p.description, bi.quantity, lu.code AS bomUom, pu.code AS stockUom, CASE WHEN bi.uomId = p.uomId THEN 1 ELSE uc.multiply / uc.factor END AS convToStock, (uc.id IS NULL AND bi.uomId <> p.uomId) AS missingConv, p.stdCost, pc.avgCost, pc.qty AS costQty, bi.oneTimeItem + 0 AS oneTime, bi.variableQty + 0 AS variableQty, bi.stage + 0 AS stage, sb.num AS stageBom, bg.name AS optionGroup, bi.groupDefault + 0 AS groupDefault, pt.name AS partType
   FROM bom AS b
   JOIN bomitem AS bi ON bi.bomId = b.id
   JOIN bomitemtype AS bit ON bit.id = bi.typeId
   LEFT JOIN part AS p ON p.id = bi.partId
   LEFT JOIN parttype AS pt ON pt.id = p.typeId
   LEFT JOIN uom AS pu ON pu.id = p.uomId
   LEFT JOIN uom AS lu ON lu.id = bi.uomId
   LEFT JOIN uomconversion AS uc ON uc.fromUomId = bi.uomId AND uc.toUomId = p.uomId
   LEFT JOIN partcost AS pc ON pc.partId = p.id
   LEFT JOIN bom AS sb ON sb.id = bi.stageBomId
   LEFT JOIN bomitemgroup AS bg ON bg.id = bi.bomItemGroupId
   WHERE b.id IN (4, 2, 5, 6, 14, 18, 13, 17, 16, 15)
   ORDER BY b.num, bi.typeId, bi.sortIdConfig, bi.id
   LIMIT 501

   89 rows · 204 ms