---
alias: user-guide-business-intelligence-dashboard-performance-volume-and-yield
grafana_json: Library/Build/ConfigFiles/Grafana/MES/dashboards/VolumeAndYield.json
tags:
  - dashboards
  - material
---
# Material Volume and Yield

## Overview

The **Material Volume and Yield** dashboard provides insights about the quantity of **Material** processed and the yield achieved over a selected period. It enables performance tracking, identification of top material loss causes, and historical analysis of production efficiency.

## Folder

Material folder.

## Database

- DWH (queried via Cube using GraphQL) for reliability metrics.
- CDM (queried via OData) for maintenance orders.

## Data

The dashboard displays the following key metrics:

- Yield (%)
- Volume In
- Volume Out
- Top Loss Reasons by Quantity
- Top Loss Reasons by Occurrences

## Example

![Example of the Material Volume and Yield dashboard](../images/material_volume_and_yield.png)

## Data Breakdown

| KPI | Description | Formula | Datasource |
| --- | ----------- | ------- | ---------- |
| **Yield (%)** | Share of processed material that becomes usable output. | (Good units ÷ Total units) × 100 | [[business-intelligence-cubes-material-movement]] cube |
| **Volume In** | Total quantity of material that entered a step. | Sum of input volume for the selected period. | [[business-intelligence-cubes-wip-history]] cube|
| **Volume Out** | Total quantity of material that left a step. | Sum of output volume for the selected period. | [[business-intelligence-cubes-wip-history]] cube|
| **Top Loss Reasons by Quantity** | Reasons for material losses sorted by weight/volume lost. | Aggregate loss quantity per reason. | [[dataplatform-dataset-materiallossbonus]] data set|
| **Top Loss Reasons by Occurrences** | Reasons for material losses sorted by number of times they occurred. | Count of loss events per reason. | [[dataplatform-dataset-materiallossbonus]] data set |

## Data Visualization

| Panel | Description | Threshold Values | Datasource |
|-------|-------------|------------------|------------|
| **Overview** | Displays Yield(%), Volume In and Out for the selected time period. | **Yield**: Green ≥ 95%, Yellow 90–94%, Red < 90%. **Volume** thresholds depend on product/material. | [[business-intelligence-cubes-material-movement]] and [[business-intelligence-cubes-wip-history]] cubes |
| **Volume and Yield Over Time** | Time-based trends showing both the processed volume and yield percentage. | N/A | [[business-intelligence-cubes-material-movement]] and [[business-intelligence-cubes-wip-history]] cubes |
| **Top Loss Reasons by Quantity** | Pie chart of material loss causes by volume. Largest segment identifies the primary source of losses. | N/A | [[dataplatform-dataset-materiallossbonus]] data set |
| **Top Loss Reasons by Occurrences** | Pie chart of material loss causes by number of occurrences. Largest segment identifies the most frequent issue. | N/A | [[dataplatform-dataset-materiallossbonus]] data set |
| **Material Volume and Yield History** | Table listing Facility, Area, Step, Step Type, Product Group, Product, Product Group, Material Type, Material Form, Units, Volumes In/Out, Loss Qty, Processed Qty, Yield, Date and Shift. | N/A | [[business-intelligence-cubes-material-movement]] and [[business-intelligence-cubes-wip-history]] cubes |

## Entity Filters

### Single selection

- Enterprise
- Site

### Multiple/All selection

- Facility
- Area
- Step
- Step Type
- Product Group
- Product
- Material Type
- Material Form
- Units
- Shift

{% include-markdown 'includes/pages/dashboards_filter_options.md' %}