WorkOrderCostSummary

Expected vs. actual cost comparison for a work order, including material, labor, and overhead breakdowns.

workOrderNumberstring

The work order number.

Example: WO-2025-0312

skuNamestring

Display name of the SKU produced.

Example: Roasted Garlic Hummus

quantitynumber

Total quantity produced.

Example: 500

unitstring

Unit of measure for the quantity.

Example: lbs

expected object

Budgeted costs, calculated from the SKU recipe, standard labor rates, and overhead allocations before production begins.

materialCostnumber

Total expected cost of all raw materials.

Example: 4200

laborCostnumber

Total expected labor cost based on standard hours and rates.

Example: 850

overheadCostnumber

Total expected overhead (e.g., utilities, equipment depreciation).

Example: 300

totalCostnumber

Sum of material, labor, and overhead.

Example: 5350

costPerUnitnumber

Expected total cost divided by production quantity.

Example: 10.7

productionHoursnumber

Estimated production time in hours.

Example: 6

actual object

Real costs recorded after production completes, based on actual material consumption, logged labor hours, and applied overhead.

materialCostnumber

Total actual cost of all raw materials consumed.

Example: 4480

laborCostnumber

Total actual labor cost.

Example: 920

overheadCostnumber

Total actual overhead applied.

Example: 310

totalCostnumber

Sum of material, labor, and overhead.

Example: 5710

costPerUnitnumber

Actual total cost divided by production quantity.

Example: 11.42

productionHoursnumber

Actual production time in hours.

Example: 6.5

variance object

The difference between actual and expected costs. Positive values mean over budget; negative values mean under budget.

materialVariancenumber

Actual material cost minus expected material cost. Positive means overspend.

Example: 280

materialVariancePercentnumber

Material variance as a percentage of expected material cost.

Example: 6.67

laborVariancenumber

Actual labor cost minus expected labor cost.

Example: 70

totalVariancenumber

Actual total cost minus expected total cost.

Example: 360

totalVariancePercentnumber

Total variance as a percentage of expected total cost.

Example: 6.73

additionalCosts object[]

Any extra costs applied to this work order beyond standard material, labor, and overhead (e.g., expedite fees, rework costs).

Array [

descriptionstring

What the additional cost is for.

amountnumber

Cost amount.

]

materialBreakdown object[]

Per-material cost and usage detail. See the MaterialCostBreakdown schema for field descriptions.

Array [

itemIdstring

Reference to the item.

Example: 2087

itemNamestring

Display name of the item.

Example: Organic Tahini

inventoryCodestring

Inventory tracking code for the item.

Example: INV-000312

unitstring

Unit of measure for all quantities in this breakdown.

Example: lbs

expectedQuantitynumber

Quantity this material was expected to consume, based on the SKU recipe and batch count.

Example: 12.5

expectedUnitCostnumber

Budgeted cost per unit for this material.

Example: 3.25

expectedTotalCostnumber

Expected quantity multiplied by expected unit cost.

Example: 40.63

actualQuantitynumber

Quantity actually consumed during production, recorded via outtake transactions.

Example: 13.1

actualUnitCostnumber

Weighted average cost per unit of the lots actually consumed.

Example: 3.25

actualTotalCostnumber

Actual quantity multiplied by actual unit cost.

Example: 42.58

quantityVariancenumber

Actual quantity minus expected quantity. Positive means more was used than planned.

Example: 0.6

costVariancenumber

Actual total cost minus expected total cost. Positive means overspend.

Example: 1.95

costVariancePercentagenumber

Cost variance as a percentage of expected total cost.

Example: 4.8

wasteQuantitynumber

Net material wasted during production — the quantity consumed beyond what was expected. A value of 0 means no waste.

Example: 0.6

wastePercentagenumber

Waste quantity as a percentage of expected quantity. Use this to compare waste rates across materials and production runs.

Example: 4.8

lotDetails object[]

Breakdown of which specific inventory lots were consumed and at what cost. Present when lot-level tracking is available.

Array [

lotIdstring

Identifier for the inventory lot consumed.

quantitynumber

Quantity consumed from this lot.

unitstring

Unit of measure.

costnumber

Total cost for the quantity consumed from this lot.

]

]

WorkOrderCostSummary

{
  "workOrderNumber": "WO-2025-0312",
  "skuName": "Roasted Garlic Hummus",
  "quantity": 500,
  "unit": "lbs",
  "expected": {
    "materialCost": 4200,
    "laborCost": 850,
    "overheadCost": 300,
    "totalCost": 5350,
    "costPerUnit": 10.7,
    "productionHours": 6
  },
  "actual": {
    "materialCost": 4480,
    "laborCost": 920,
    "overheadCost": 310,
    "totalCost": 5710,
    "costPerUnit": 11.42,
    "productionHours": 6.5
  },
  "variance": {
    "materialVariance": 280,
    "materialVariancePercent": 6.67,
    "laborVariance": 70,
    "totalVariance": 360,
    "totalVariancePercent": 6.73
  },
  "additionalCosts": [
    {
      "description": "string",
      "amount": 0
    }
  ],
  "materialBreakdown": [
    {
      "itemId": "2087",
      "itemName": "Organic Tahini",
      "inventoryCode": "INV-000312",
      "unit": "lbs",
      "expectedQuantity": 12.5,
      "expectedUnitCost": 3.25,
      "expectedTotalCost": 40.63,
      "actualQuantity": 13.1,
      "actualUnitCost": 3.25,
      "actualTotalCost": 42.58,
      "quantityVariance": 0.6,
      "costVariance": 1.95,
      "costVariancePercentage": 4.8,
      "wasteQuantity": 0.6,
      "wastePercentage": 4.8,
      "lotDetails": [
        {
          "lotId": "string",
          "quantity": 0,
          "unit": "string",
          "cost": 0
        }
      ]
    }
  ]
}