Finished Production Order Breakdown (Power BI Report)
APPLIES TO: Generally available in Business Central 2024 release wave 2 (version 25.1).
The Finished Production Order Breakdown report provides insights into the expected quantity versus the finished quantity of production orders. It helps track work in progress and its status to meet expected demand.
Use the report
The report is meant for manufacturing managers and supervisors.
Manufacturing managers use the report to track the progress of production orders and stay on top of production process. The report shows the expected quantity versus the finished quantity, which helps identify the quantity left to produce and the status of the production process. This information helps optimize the use of resources.
Production supervisors use this report to track the progress of production orders and ensure that the production process is running smoothly. The report provides insights into the expected quantity versus the finished quantity, which helps identify discrepancies.
Key Performance Indicators (KPIs)
The Finished Production Order Breakdown report includes the following KPIs and measures:
- Expected Quantity (Base)
- Finished Quantity (Base)
- Qty. Variance
- Qty. Deviation %
- Expected Cost Amt.
- Finished Cost Amt. (Actual)
- Cost Amt. Variance
- Cost Amt. Deviation %
- Capacity Used per Unit (Hours)
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
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:
- Item
- Production Order
Try the report
Try the report here: Finished Production Order Breakdown
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