Share via

Work Centre Statistics (Power BI Report)

APPLIES TO: Generally available in Business Central 2025 release wave 1 (version 26.x).

The Work Centre Statistics report offers a comprehensive view of operational performance across all work centres. Through a combination of high-level metrics and granular details, this report provides insights needed to evaluate efficiency, resource utilization, and production outcomes. The KPI cards and Work Centre Efficiency chart provide concise summaries of key performance indicators (KPIs), enabling quick assessments of work centre performance. For a deeper analysis, you can leverage the detailed insights presented in the Statistic Details table to support decision-making and drive operational improvements.

Screenshot of the Work Centre Statistics Power BI Report

The Work Centre Scrap % KPI card highlights the work centre's scrap percentage, which is an important measure of performance. The KPI compares the ratio of scrap generated to the total output processed by the work centre. This data lets you quickly assess operational efficiency and pinpoint areas for improvement

The Work Centre Load KPI card provides a holistic view of the work centre's workload and capacity by showcasing three essential measures:

  • Work Centre Load
  • Allocated Time
  • Capacity (Effective)

The KPI can help you assess resource utilization, identify bottlenecks, and evaluate operational efficiency within the work centre.

The Work Centre Efficiency chart shows the actual efficiency of each work centre, organized by work centre number. It provides a visual comparison of efficiency levels, enabling you to identify performance variations and target areas for operational improvements.

The Statistics Details table provides a detailed summary of each work centre, including its associated work centre and a range of KPIs. The listed KPIs cover various aspects of performance, such as capacity, efficiency, cost, time allocation, output, scrap metrics, and runtime statistics. The KPIs include:

  • Work Centre Capacity (Total)
  • Work Centre Capacity (Effective)
  • Work Centre Expected Efficiency %
  • Work Centre Actual Need
  • Work Centre Actual Efficiency %
  • Work Centre Actual Total Cost
  • Work Centre Allocated Time

Use the report

The Work Centre Statistics report is designed to help manufacturing managers and production supervisors analyse work centre performance and efficiency.

Manufacturing managers use this report to assess key statistics related to work centre operations. By reviewing the performance metrics, you can identify areas for improvement, optimize resource allocation, and ensure that work centres operate at peak efficiency. This information helps with strategic planning and maintaining smooth production workflows.

Production supervisors rely on this report to monitor work centre performance. By analysing data on output levels, scrap rates, capacity needs, and potential bottlenecks, you can make informed decisions to address inefficiencies and maintain steady production.

Key performance indicators (KPIs)

The Work Centre Statistics report includes the following KPIs and measures:

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:

  • Capacity Ledger Entry
  • Prod Order Capacity Need
  • Calendar Entry
  • Work Centre

Try the report

Try the report here: Work Centre Statistics

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.

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

  • Last updated on