Consumption Variance (Power BI Report)

APPLIES TO: Generally available in Business Central 2024 release wave 2 (version 25.1).

The Consumption Variance report highlights the variance between expected and actual consumption costs on a monthly basis. The report can give a better understanding of consumption and ways to optimize production processes.

Use the report

The report is meant for manufacturing managers and supervisors.

Manufacturing managers use the report to monitor and manage the consumption costs of production operations.

Production supervisors use this report to track the consumption costs of production lines and ensure they operate within budget. By tracking the actual costs against the expected costs, you can quickly find and report deviations so the manufacturing manager can address them.

Key Performance Indicators (KPIs)

The Consumption Variance report includes the following KPIs and measures:

• Consumption Cost Amt. Deviation %
• Expected Consumption Cost Amount
• Consumed Cost Amount (Actual)
• Consumption Cost Amt. Variance

Click on the link for a KPI to learn more about what it means, how it is calculated, and what data was used in the calculations.

Tip

Tip:
You can easily track the KPIs that the Power BI reports display against your business objectives. To learn more, go to Track your business KPIs with Power BI metrics.

Data used in the report

The report uses data from the following tables in Business Central:

• Production Order
• Item Ledger Entry

Try the report

Try the report here: Consumption Variance

Tip

Tip:
If you hold down the CTRL key while you select the report link, the report opens on a new browser tab. In this way, you can stay on the current page while you explore the report on the other browser tab.

See also

Track your business KPIs with Power BI metrics
Power BI Manufacturing app
Built-in production reports
Manufacturing overview