Edit

Share via

Current Utilization (Power BI Report)

  • Article

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

The Current Utilization report provides insights into the manufacturing capacity use and helps with capacity planning. It shows the capacity available and used by hours and the percentage of use.

Screenshot of the Current Utilization Power BI Report

Use the report

The report is meant for business leaders and manufacturing teams.

COOs use the report to monitor the percentage of use of resources on production lines and ensure efficient allocation. You can analyze the capacity utilization gauges to track the current week's utilization percentage. The analysis can help you make necessary adjustments to meet production deadlines. The report also helps you track the expected capacity need percentage to keep the utilization rate above the required threshold.

Manufacturing managers use the report to understand the capacity of machine and work centers. The report provides insights into the capacity used by hour, allowing you to optimize the use of your machine and work centers. You can use the gauges to track today's utilization percentage and the current week's utilization percentage, and adjust the production schedules accordingly. The report helps you ensure that you complete production orders on time by keeping the utilization rate above the required threshold.

Key Performance Indicators (KPIs)

The Current Utilization 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
  • Calendar Entry
  • Production Order Routing Line

Try the report

Try the report here: Current Utilization

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