Skip to main content

MaterialCostBreakdown

Expected vs. actual usage and cost for a single raw material within a work order.

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.

  • ]
    • MaterialCostBreakdown
    {
      "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
        }
      ]
    }