> ## Documentation Index
> Fetch the complete documentation index at: https://docs.stockful.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Production

> Production batches: what each set out to make, what it actually made, and the material it took to do it.

Production batches: what each set out to make, what it actually made, and the material it took to do it.

## Example

```sql theme={null}
FROM production
  SHOW batches, planned_qty
  GROUP BY batch
  ORDER BY batches DESC
```

## Metrics

| Metric | Type | Description |
| - | - | - |
| `batches` | Number | How many production runs the group covers. |
| `planned_qty` | Number | Units the batches set out to make. |
| `actual_qty` | Number | Units the batches actually produced. Blank until a batch closes. |
| `yield_variance` | Number | Made less planned. Negative means the batch fell short of its recipe. |
| `yield_rate` | Percent | Made as a share of planned. |
| `material_used` | Number | Units of material the batches drew, in each material's own unit. |
| `material_cost` | Currency | What the material the batches consumed cost. |

## Dimensions

| Dimension | Description |
| - | - |
| `batch` | One production run, by its document number. |
| `status` | Where the batch got to: underway, completed or cancelled. |
| `material` | A material the batch consumed - one row per material on the recipe. |
| `material_category` | The grouping on the consumed material's product. |
| `location` | Where the batch was made. |

## Filters

| Filter | Type | Description |
| - | - | - |
| `status` | Text | Where the batch got to. |
| `material_name` | Text | A material the batch consumed. |
| `material_category` | Text | The grouping on the consumed material's product. |

## Related datasets

* [Raw materials](https://docs.stockful.app/stockfulql/datasets/materials.md)
* [Material movements](https://docs.stockful.app/stockfulql/datasets/material_movements.md)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.