# Consolidated Material Usage Variance

<p class="doc-lead">Aggregates raw material usage variance across all Production Orders in a date range. Compares total standard vs actual consumption by component — based on production order date.</p>

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

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

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

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

<p><b>What it shows.</b> One row per raw material component with aggregated standard quantity/amount, actual quantity/amount, variance, variance %, and limit %. Footnote: based on production order date.</p>

<p><b>When to use it.</b> Use for period-end material variance review across all orders rather than one order at a time.</p>

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

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

<ul>
<li><b>Finance</b> — Monthly review of total raw material over- or under-consumption by component.</li>
<li><b>Production head</b> — Identify consistently over-used materials across multiple orders.</li>
</ul>

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

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

<b>Date range</b> — filters by Production Order date.

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

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

| **Column** | **Description** |
|------------|-----------------|
| Component | Raw material. |
| Unit | Unit of measure. |
| Unit Cost | Average or standard unit cost. |
| Standard — Quantity | Total standard quantity. |
| Standard — Amount | Total standard cost. |
| Actual — Quantity | Total actual consumed. |
| Actual — Amount | Total actual cost. |
| Variance — Quantity | Quantity difference. |
| Variance — Amount | Cost difference. |
| Var. % | Variance percentage. Sortable. |
| Limit % | Deviation limit. |

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

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

<ul>
<li><b>Generate</b> — run the report</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>How is this different from Material Usage Variance?</b><br>Material Usage Variance is for a single order. This report consolidates all orders in the date range into one component-level view.</p>

<p><b>What date is used — order date or voucher date?</b><br>Production order date.</p>
<p><b>Consolidated vs standard variance?</b><br>Rolls up variance across orders; standard report is order-level.</p>
<p><b>Threshold from settings?</b><br>Variance limits from Production Settings drive approval — report shows exceedance.</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>