# Material Usage Variance

<p class="doc-lead">For one Production Order, compares standard vs actual raw material usage by BOM component. Highlights components where usage variance exceeds the configured deviation limit.</p>

<div class="doc-toc">
<p class="doc-toc-title">On this page</p>
<div class="doc-toc-links">
<a href="#/production/reports/material-usage-variance?id=overview">Overview</a>
<a href="#/production/reports/material-usage-variance?id=use-cases">Use Cases</a>
<a href="#/production/reports/material-usage-variance?id=filters">Filters</a>
<a href="#/production/reports/material-usage-variance?id=columns">Columns</a>
<a href="#/production/reports/material-usage-variance?id=actions">Actions</a>
<a href="#/production/reports/material-usage-variance?id=faq">FAQ</a>
</div>
</div>

<hr class="doc-section-divider">

<h2 id="overview">Overview</h2>

Go to <b>Production → Reports → Material Usage Variance</b>.

<p><b>What it shows.</b> Header row with Production Order, item code, and item name, followed by one row per BOM component showing standard vs actual quantity and amount, variance, variance %, and limit %.</p>

<p><b>When to use it.</b> Use after completing or closing an order to audit raw material consumption against the BOM standard.</p>

<hr class="doc-section-divider">

<h2 id="use-cases">Use Cases</h2>

<ul>
<li><b>Cost controller</b> — Investigate orders where raw material usage exceeded BOM standards.</li>
<li><b>Store keeper</b> — Verify that issued quantities match voucher consumption before closing an order.</li>
</ul>

<hr class="doc-section-divider">

<h2 id="filters">Filters</h2>

<b>Production Order Id</b> — enter or search for a Production Order. Generate is disabled until an order is selected.

<hr class="doc-section-divider">

<h2 id="columns">Columns</h2>

| **Column** | **Description** |
|------------|-----------------|
| Component | Raw material component. |
| BOM | BOM name. |
| Unit | Unit of measure. |
| Unit Cost | Cost per unit. |
| Standard — Quantity | BOM standard quantity. |
| Standard — Amount | Standard cost. |
| Actual — Quantity | Actual consumed quantity. |
| Actual — Amount | Actual cost. |
| Variance — Quantity | Quantity difference. |
| Variance — Amount | Cost difference. |
| Var. % | Variance percentage. Sortable. |
| Limit % | Raw material deviation limit. |

<hr class="doc-section-divider">

<h2 id="actions">Actions</h2>

<ul>
<li><b>Generate</b> — run the report for the selected order</li>
<li><b>Export</b> — export to Excel</li>
<li><b>Print</b> — print the report</li>
<li>Click <b>Var. %</b> column header to sort</li>
</ul>

<hr class="doc-section-divider">

<h2 id="faq">FAQ</h2>

<p><b>Where is the deviation limit set?</b><br>In Production Settings — <b>Default raw material deviation limit (%)</b>. Individual BOM components may also have limits.</p>

<p><b>What counts as Actual quantity?</b><br>Raw materials consumed on approved Production Vouchers linked to the order.</p>
<p><b>BOM standard vs actual?</b><br>Compares consumed raw materials to BOM expectation.</p>
<p><b>Investigate?</b><br>Drill to production voucher lines for batch/serial detail.</p>
<p><b>Can I export this report?</b><br>Yes — use Export from report actions for Excel analysis.</p>
<p><b>Which production setting affects this?</b><br>Review <a href="#/production/production-settings-config">Production Settings</a> for variance, quantity, and BOM rules.</p>