MRP / In-House MRP

In-House MRP - Audit Trail, Scrap Variances & Compensating Strategies

Shift handovers, production variance tracking, reversal policies, and rework strategies for the In-House Manufacturing domain.

Audit Trail, Scrap Variances & Compensating Strategies

The In-House Manufacturing domain maintains a comprehensive, immutable audit trail for every production run. Variances are tracked, not overwritten, and corrections are achieved through compensating documents that preserve the original record.


1. Production Audit Trail

Every mutation within the In-House Manufacturing context is recorded with immutable context. The audit trail supports regulatory compliance, root-cause analysis, and continuous improvement initiatives.

Audit Attributes

AttributePurpose
Actor IdentityIdentifies the operator, planner, supervisor, system job, or integration process that initiated the action.
TimestampRecords the precise moment of the action in UTC and local shift time.
Origin ContextIdentifies the source event, terminal, workstation, or integration job that triggered the action.
Before / After SnapshotCaptures the state of the operation, order, or quantity before and after the change.
Reason CodeCaptures the business justification for the mutation, especially for overrides, substitutions, and corrections.
Work Center / MachineIdentifies the physical resource where the action occurred.
Shift IdentifierAssociates the action with the responsible production shift.

Audit Invariants

  • Audit log entries are append-only. They can never be edited or deleted.
  • Every material issue, labor ticket, operation status change, and output report links to an audit entry.
  • Closed manufacturing orders retain a complete lineage of operations, consumption, time logs, and output records.
  • Electronic signatures or approvals are captured where required by quality or regulatory policy.

2. Shift Handovers

Shift handovers ensure continuity of production execution across operating shifts.

Handover Content

ElementDescription
Active OrdersManufacturing Orders currently in progress with remaining operations and quantities.
Operation StatusCurrent state of each active operation (Running, Paused, Awaiting Inspection, etc.).
Material StatusComponents staged, consumed, or awaiting replenishment.
Machine StatusMachines running, under maintenance, or flagged for attention.
Quality IssuesOpen defects, quarantine holds, pending dispositions.
Safety NotesSafety observations, lockout/tagout status, hazard alerts.

Handover Rules

  • Outgoing shift must record a formal handover note before shift end.
  • Incoming shift must acknowledge handover before starting new operations.
  • Disputes about order status are resolved through the immutable audit trail.
  • Incomplete operations remain assigned to the same work center unless explicitly reassigned.

3. Production Variance Tracking

Standard/planned values are compared against actual values throughout production. Variances are used for operational control and financial reporting.

Variance Categories

VarianceFormulaInvestigation Trigger
Material Quantity Variance$(\text{Actual Quantity} - \text{Standard Quantity}) \times \text{Standard Cost}$Excess consumption above scrap factor.
Material Substitution VarianceCost difference between original and substitute component.Engineering waiver or unplanned substitution.
Labor Efficiency Variance$(\text{Actual Hours} - \text{Standard Hours}) \times \text{Standard Rate}$Operator or machine performance outside tolerance.
Labor Rate Variance$(\text{Actual Rate} - \text{Standard Rate}) \times \text{Actual Hours}$Pay rate differences, overtime, or skill mismatch.
Machine Utilization VarianceActual machine hours vs. planned machine hours.Downtime, setup overrun, or speed loss.
Yield Variance$(\text{Actual Good Output} - \text{Expected Output}) \times \text{Standard Cost}$Output shortfall or unexpected overproduction.
Scrap VarianceActual scrap cost vs. planned scrap allowance.Scrap above BOM scrap factor.

Variance Analysis Workflow

flowchart TD
    A[Order Closure] --> B[Calculate Standard vs. Actual]
    B --> C{Variance Within Tolerance?}
    C -->|Yes| D[Seal Variance & Close Order]
    C -->|No| E[Generate Variance Exception]
    E --> F[Assign to Production / Cost Engineer]
    F --> G{Root Cause}
    G -->|Process| H[Update Routing or BOM]
    G -->|Operator| I[Training or Disciplinary Action]
    G -->|Material| J[Supplier Quality Review]
    G -->|Machine| K[CMMS Maintenance Review]
    H --> D
    I --> D
    J --> D
    K --> D

Variance Sealing

  • Variances are calculated and sealed at order closure.
  • Sealed variances cannot be edited; subsequent discoveries are handled through compensating orders.
  • Variance data is forwarded to FMS for period-end reporting and to operations for continuous improvement.

4. Reversal and Rework Policies

The In-House Manufacturing domain does not allow deletion or retroactive editing of completed production records. All corrections follow formal compensating strategies.

Why Deletion Is Forbidden

Deleting a production record would break:

  • The immutable audit trail required by regulators and quality standards.
  • The sequential integrity of lot and serial traceability.
  • The ability to reproduce historical cost of production exactly as originally reported.
  • The compensating document pattern that preserves the complete history of corrections.

Correction Strategies

Correction ScenarioCompensating DocumentDescription
Material under-consumedMaterial Adjustment OrderIssues additional material to the original order or a successor order with full traceability.
Material over-consumedMaterial Return OrderReturns excess material to inventory or writes it off with reason code.
Labor time errorLabor Correction TicketRecords corrected labor hours; original ticket remains visible.
Output shortfall after closureSupplementary Production OrderCreates a new MO to produce the missing quantity; original MO remains closed.
Defect discovered after closureRework Work OrderCreates a dedicated rework order linked to the original MO; original output is moved to quarantine.
Scrap misclassificationScrap Reclassification NoteReclassifies scrap reason or disposition without altering original quantity.

Rework Work Order Lifecycle

A rework order is a special manufacturing order created to correct defective output without overwriting the original production history.

flowchart TD
    A[Defect Discovered Post-Completion] --> B[Original MO Remains Closed]
    B --> C[Rework Work Order Created]
    C --> D[Link to Original MO / Lot / Serial]
    D --> E[Define Rework Routing]
    E --> F[Stage Rework Materials]
    F --> G[Execute Rework Operations]
    G --> H{Re-Inspection}
    H -->|Pass| I[Return to Good Inventory]
    H -->|Fail| J[Scrap or Second Rework]
    I --> K[Close Rework Order with Variance]
    J --> K

Rework Rules

RuleInvariant
Original PreservedThe original Manufacturing Order remains closed and unchanged.
Full TraceabilityRework order references original MO, lot, serial, and operation.
Cost AttributionRework costs may be attributed to the original order’s cost object or to a separate variance account per company policy.
No Double CountingRework output is not added to original MO output; it is received as a separate inventory transaction.
Quality NotificationRework triggers quality notification and may initiate supplier or process corrective action.

5. Scrap Disposal & Recovery

Scrap is managed as a controlled inventory movement with financial and environmental accountability.

Scrap Lifecycle

StageActionDocument
DetectionDefect identified during operation or inspection.Inspection Report or Scrap Tag.
QuarantineDefective quantity moved to quarantine pending disposition.Quarantine Transfer Note.
DispositionDecision made: rework, scrap, or return-to-vendor.Disposition Record.
Scrap BinNon-reworkable quantity moved to scrap location.Scrap Transfer Note.
DisposalScrap sold, recycled, or destroyed.Disposal Order / Certificate.
Cost RecoveryScrap value credited to order or recovered through sale.Credit Note or Cost Adjustment.

Scrap Valuation

MethodUse Case
Net Realizable ValueScrap can be sold or recycled; value credited to the producing order.
Zero ValueScrap has no recoverable value; cost absorbed by good output.
Return-to-VendorDefective supplier material returned for credit; order credited accordingly.

6. Compliance & Regulatory Alignment

The audit and compensation model supports common manufacturing and quality standards:

Standard / FrameworkSupported Capability
ISO 9001Complete traceability, non-conformance management, corrective action records.
ISO 13485 (Medical Devices)Device history record, lot traceability, rework and recall support.
AS9100 (Aerospace)Configuration control, first-article inspection, material certification.
FDA 21 CFR Part 11Electronic records, electronic signatures, immutable audit trails.
Good Manufacturing Practice (GMP)Batch records, deviation management, equipment calibration linkage.

7. Summary

The In-House Manufacturing domain in Obelaw is a rigorous, event-driven bounded context that enforces production correctness through immutable records, sealed variances, formal rework orders, and comprehensive audit trails. It remains isolated from operational and financial contexts via an Anti-Corruption Layer and emits only the production facts necessary for downstream capitalization, inventory movement, and maintenance response.

Our Premium Sponsors

Obelaw is proudly open-source. Continued development, bug fixes, and community support are made possible by the generosity of our sponsors.

Sponsor Obelaw