Skip to content

Open-source manufacturing ERP, MES and QMS. Quoting, MRP, inventory, shop floor, quality and lot/serial traceability on one Postgres schema, with a REST API and MCP server. Self-host or use Carbon Cloud.

12.4 KB
Raw Blame
// SPDX-License-Identifier: AGPL-3.0-only
// Carbon (github.com/crbnos/carbon). Modified or adapted versions of this file,
// including ports, remain AGPLv3; serving them over a network requires releasing their source.

import type {
  GenealogyAssemblySpec,
  GenealogyInputSpec,
  JobSpec,
  PickingListSpec,
  ProductionData,
  ShiftEventSpec
} from "../../types.ts";

export const JOBS: JobSpec[] = [
  {
    key: "in-progress",
    item: "ROB-2000",
    status: "In Progress",
    quantity: 3,
    quantityComplete: 1,
    salesOrder: "so:lakeshore",
    salesOrderLine: "soline:lakeshore:rob",
    customer: "Lakeshore Automotive",
    deadlineType: "Hard Deadline",
    dueDateOffset: 6,
    releasedDateOffset: -297,
    priority: 3,
    assignee: "self",
    operationOverrides: [
      { order: 1, status: "Done" },
      { order: 2, status: "In Progress", assignee: "self" },
      { order: 3, status: "Waiting" }
    ],
    quantities: [
      { order: 1, type: "Production", quantity: 1 },
      { order: 1, type: "Scrap", quantity: 2, scrapReason: "Damaged" },
      { order: 2, type: "Rework", quantity: 1 }
    ],
    operationNotes: [
      {
        order: 1,
        note: "Base-to-link dowels seated on the second press — torque-striped all J1 fasteners and logged the values in the Lakeshore acceptance packet."
      },
      {
        order: 2,
        note: "Burn-in hour 14 of 24. Repeatability holding at ±0.02 mm on the test cube, J2 drive temp steady at 41C."
      }
    ]
  },
  {
    key: "ready",
    item: "ROB-2000",
    status: "Ready",
    quantity: 1,
    salesOrder: "so:northwind",
    salesOrderLine: "soline:northwind:rob",
    customer: "Northwind Electronics",
    deadlineType: "ASAP",
    dueDateOffset: 14,
    releasedDateOffset: -4,
    priority: 10
  },
  {
    key: "planned",
    item: "ARM-BASE-001",
    status: "Planned",
    quantity: 1,
    salesOrder: "so:planned",
    salesOrderLine: "soline:planned",
    customer: "Cascade Integration Group",
    deadlineType: "Soft Deadline",
    dueDateOffset: 18,
    priority: 12
  },
  {
    key: "draft",
    item: "CTRL-100",
    status: "Draft",
    quantity: 1,
    salesOrder: "so:draft",
    salesOrderLine: "soline:draft",
    customer: "Alpine Research Institute",
    deadlineType: "No Deadline"
  },
  {
    key: "paused",
    item: "ARM-WRIST-001",
    status: "Paused",
    quantity: 1,
    salesOrder: "so:paused",
    salesOrderLine: "soline:paused",
    customer: "Lakeshore Automotive",
    dueDateOffset: 9,
    releasedDateOffset: -266,
    priority: 6
  },
  {
    key: "completed",
    item: "GRP-2F-80",
    status: "Completed",
    quantity: 1,
    quantityComplete: 1,
    salesOrder: "so:completed",
    salesOrderLine: "soline:completed",
    customer: "Northwind Electronics",
    dueDateOffset: -328,
    releasedDateOffset: -434,
    completedDateOffset: -332
  },
  {
    key: "closed",
    item: "ARM-LINK-001",
    status: "Closed",
    quantity: 1,
    quantityComplete: 1,
    salesOrder: "so:closed",
    salesOrderLine: "soline:closed",
    customer: "Cascade Integration Group",
    dueDateOffset: -363,
    releasedDateOffset: -454,
    completedDateOffset: -367
  },
  {
    key: "cancelled",
    item: "HRN-ARM-001",
    status: "Cancelled",
    quantity: 1,
    salesOrder: "so:cancelled",
    salesOrderLine: "soline:cancelled",
    customer: "Alpine Research Institute",
    dueDateOffset: -314,
    releasedDateOffset: -337
  },

  // Released over the last few weeks so every work center has a queue and something running today.
  {
    key: "floor-ctrl-pcb",
    item: "PCB-CTRL-R1",
    status: "In Progress",
    quantity: 6,
    salesOrder: "so:floor-lakeshore",
    salesOrderLine: "soline:floor-lakeshore:ctrl-pcb",
    customer: "Lakeshore Automotive",
    dueDateOffset: 2,
    releasedDateOffset: -6,
    priority: 2,
    assignee: "self",
    operationOverrides: [
      { order: 1, status: "Done" },
      {
        order: 2,
        status: "In Progress",
        assignee: "self",
        running: { type: "Labor", startTimeOfDay: "07:30:00" }
      },
      // The first boards are already on the inspection bench (quality.inspections).
      { order: 3, status: "In Progress" }
    ]
  },
  {
    key: "floor-io-pcb",
    item: "PCB-IO-R1",
    status: "In Progress",
    quantity: 6,
    salesOrder: "so:floor-northwind",
    salesOrderLine: "soline:floor-northwind:io-pcb",
    customer: "Northwind Electronics",
    dueDateOffset: 5,
    releasedDateOffset: -2,
    priority: 4,
    operationOverrides: [{ order: 1, assignee: "self" }]
  },
  {
    key: "floor-drive",
    item: "DRV-J2-MOD",
    status: "In Progress",
    quantity: 4,
    salesOrder: "so:floor-northwind",
    salesOrderLine: "soline:floor-northwind:drive",
    customer: "Northwind Electronics",
    deadlineType: "Soft Deadline",
    dueDateOffset: 12,
    releasedDateOffset: -9,
    priority: 8,
    assignee: "self",
    operationOverrides: [
      {
        order: 1,
        status: "In Progress",
        assignee: "self",
        running: { type: "Setup", startTimeOfDay: "06:45:00" }
      },
      { order: 2, status: "Waiting" }
    ]
  },
  {
    key: "floor-jaw",
    item: "GRP-JAW-80",
    status: "In Progress",
    quantity: 4,
    salesOrder: "so:floor-northwind",
    salesOrderLine: "soline:floor-northwind:jaw",
    customer: "Northwind Electronics",
    dueDateOffset: 7,
    releasedDateOffset: -5,
    priority: 5,
    operationOverrides: [
      {
        order: 1,
        status: "In Progress",
        running: { type: "Machine", startTimeOfDay: "08:15:00" }
      },
      { order: 2, status: "Waiting" }
    ]
  },
  {
    key: "floor-harness",
    item: "HRN-ARM-001",
    status: "Ready",
    quantity: 3,
    salesOrder: "so:floor-lakeshore",
    salesOrderLine: "soline:floor-lakeshore:harness",
    customer: "Lakeshore Automotive",
    deadlineType: "ASAP",
    dueDateOffset: 0,
    releasedDateOffset: -1,
    priority: 1,
    operationOverrides: [{ order: 1, assignee: "self" }]
  },
  {
    key: "floor-wrist",
    item: "ARM-WRIST-001",
    status: "Ready",
    quantity: 2,
    salesOrder: "so:floor-northwind",
    salesOrderLine: "soline:floor-northwind:wrist",
    customer: "Northwind Electronics",
    dueDateOffset: 21,
    releasedDateOffset: -3,
    priority: 13
  },
  {
    key: "floor-ctrl",
    item: "CTRL-100",
    status: "Ready",
    quantity: 1,
    salesOrder: "so:floor-northwind",
    salesOrderLine: "soline:floor-northwind:ctrl",
    customer: "Northwind Electronics",
    deadlineType: "Soft Deadline",
    dueDateOffset: 16,
    releasedDateOffset: -4,
    priority: 11,
    operationOverrides: [{ order: 1, assignee: "self" }]
  },
  // No deadline, so it lands in Priorities' Unscheduled column.
  {
    key: "floor-gripper",
    item: "GRP-2F-80",
    status: "Ready",
    quantity: 2,
    salesOrder: "so:floor-northwind",
    salesOrderLine: "soline:floor-northwind:gripper",
    customer: "Northwind Electronics",
    deadlineType: "No Deadline",
    releasedDateOffset: -1,
    priority: 14
  },
  {
    key: "stock-ctrl-pcb",
    item: "PCB-CTRL-R1",
    status: "In Progress",
    quantity: 10,
    dueDateOffset: 11,
    releasedDateOffset: -2,
    priority: 9
  },
  {
    key: "stock-harness",
    item: "HRN-ARM-001",
    status: "Ready",
    quantity: 6,
    deadlineType: "Soft Deadline",
    dueDateOffset: 9,
    releasedDateOffset: -3,
    priority: 7,
    operationOverrides: [{ order: 1, assignee: "self" }]
  },
  // Feeds the completion-time and estimates-vs-actuals KPIs.
  {
    key: "done-io-pcb",
    item: "PCB-IO-R1",
    status: "Completed",
    quantity: 4,
    quantityComplete: 4,
    salesOrder: "so:floor-lakeshore",
    salesOrderLine: "soline:floor-lakeshore:io-pcb",
    customer: "Lakeshore Automotive",
    dueDateOffset: -8,
    releasedDateOffset: -16,
    completedDateOffset: -11,
    loggedTime: { startOffset: -14, efficiency: 0.92 }
  },
  {
    key: "done-jaw",
    item: "GRP-JAW-80",
    status: "Completed",
    quantity: 2,
    quantityComplete: 2,
    salesOrder: "so:floor-lakeshore",
    salesOrderLine: "soline:floor-lakeshore:jaw",
    customer: "Lakeshore Automotive",
    dueDateOffset: -20,
    releasedDateOffset: -28,
    completedDateOffset: -24,
    loggedTime: { startOffset: -27, efficiency: 1.18 }
  },
  {
    key: "done-base",
    item: "ARM-BASE-001",
    status: "Completed",
    quantity: 1,
    quantityComplete: 1,
    salesOrder: "so:floor-lakeshore",
    salesOrderLine: "soline:floor-lakeshore:base",
    customer: "Lakeshore Automotive",
    dueDateOffset: -2,
    releasedDateOffset: -12,
    completedDateOffset: -4,
    loggedTime: { startOffset: -9, efficiency: 1.07 }
  }
];

// Two recent shifts, nine and eight days before the anchor. One group per
// operation, in operation order.
export const SHIFTS: ShiftEventSpec[][] = [
  [
    {
      type: "Setup",
      startOffset: -9,
      startTimeOfDay: "13:00:00",
      endOffset: -9,
      endTimeOfDay: "13:45:00"
    },
    {
      type: "Labor",
      startOffset: -9,
      startTimeOfDay: "13:45:00",
      endOffset: -9,
      endTimeOfDay: "17:45:00"
    },
    {
      type: "Machine",
      startOffset: -9,
      startTimeOfDay: "13:45:00",
      endOffset: -9,
      endTimeOfDay: "17:45:00"
    }
  ],
  [
    {
      type: "Setup",
      startOffset: -8,
      startTimeOfDay: "13:00:00",
      endOffset: -8,
      endTimeOfDay: "13:20:00"
    },
    {
      type: "Labor",
      startOffset: -8,
      startTimeOfDay: "13:20:00",
      endOffset: -8,
      endTimeOfDay: "16:20:00"
    },
    {
      type: "Machine",
      startOffset: -8,
      startTimeOfDay: "13:20:00",
      endOffset: -8,
      endTimeOfDay: "16:20:00"
    }
  ]
];

// Tracked components consumed into the first arm. Item, lot/serial id, and how
// many of that lot went in — three 750W motors is what one ROB-2000 rolls up to.
export const GENEALOGY_INPUTS: GenealogyInputSpec[] = [
  { item: "MAT-AL6061-BIL", readableId: "LOT-AL6061-2606", quantity: 22 },
  { item: "MAT-AL6061-BIL", readableId: "LOT-AL6061-2607", quantity: 17 },
  { item: "ENC-ABS-19", readableId: "LOT-ENC-2606", quantity: 5 },
  { item: "MOT-AC-750W", readableId: "MOT750-SN-0041", quantity: 1 },
  { item: "MOT-AC-750W", readableId: "MOT750-SN-0042", quantity: 1 },
  { item: "MOT-AC-750W", readableId: "MOT750-SN-0043", quantity: 1 }
];

export const GENEALOGY_ASSEMBLY: GenealogyAssemblySpec = {
  item: "ROB-2000",
  ref: "trackedEntity:rob-0001",
  serial: {
    readableId: "ROB2000-SN-0001",
    quantity: 1,
    status: "Available",
    sourceDocument: "Job",
    sourceDocumentReadableId: "ROB-2000"
  },
  produce: {
    type: "Produce",
    sourceDocument: "Job Operation",
    sourceDocumentReadableId: "ROB-2000",
    quantity: 1
  },
  consume: {
    type: "Consume",
    sourceDocument: "Job Material",
    entityStatus: "Consumed",
    entitySourceDocument: "Item",
    parentQuantity: 1
  }
};

export const PICKING_LISTS: PickingListSpec[] = [
  {
    key: "rob-kit-1",
    status: "Completed",
    job: "in-progress",
    dateOffset: -20,
    lines: [
      {
        item: "FST-M8-SS",
        quantityRequired: 24,
        quantityPicked: 24,
        status: "Picked",
        fromShelf: "A1-L1"
      },
      {
        item: "MAT-CONN-M23",
        quantityRequired: 6,
        quantityPicked: 6,
        status: "Picked",
        fromShelf: "A1-L2"
      }
    ]
  },
  {
    key: "rob-kit-2",
    status: "In Progress",
    job: "in-progress",
    dateOffset: -2,
    lines: [
      {
        item: "BRG-CRB-100",
        quantityRequired: 4,
        quantityPicked: 0,
        status: "Pending",
        fromShelf: "A2-L3"
      },
      {
        item: "CN-GREASE-EP",
        quantityRequired: 1,
        quantityPicked: 0,
        status: "Short",
        fromShelf: "A1-L2"
      }
    ]
  }
];

export const roboticsProduction: ProductionData = {
  jobs: JOBS,
  shifts: SHIFTS,
  genealogyInputs: GENEALOGY_INPUTS,
  genealogyAssembly: GENEALOGY_ASSEMBLY,
  eventsJobKey: "in-progress",
  genealogyJobKey: "in-progress",
  // Must match the operation overridden to In Progress.
  openEvent: { operationOrder: 2 },
  batch: {
    members: [
      { job: "floor-io-pcb", order: 1 },
      { job: "stock-ctrl-pcb", order: 1 }
    ],
    running: { type: "Machine", startTimeOfDay: "07:05:00" }
  },
  rework: {
    quantity: 1,
    reason:
      "J4 wrist repeatability drifted past ±0.03 mm at burn-in hour 9 — return unit 2 to integration for wrist re-shim and encoder re-mate.",
    targetOperationOrder: 1,
    triggeredAtOperationOrder: 2
  },
  pickingLists: PICKING_LISTS
};