Allocated hours (Power BI report)

APPLIES TO: Generally available in Business Central 2024 release wave 2.

The Allocated Hours report shows allocated production time by work center, source item, capacity type, and production order status. It excludes finished production orders. The report compares allocated time with expected capacity need for individual production orders. Time values use the Show Capacity In unit from Manufacturing Setup, so they aren't necessarily hours.

[Screenshot of the Allocated Hours Power BI Report]

Use the report

Manufacturing managers use the report to plan and allocate resources effectively. The data shows which work centers are over or underutilized, so you can make informed decisions about how to allocate resources.

For example, if you notice that a work center is underused, you can assign more work orders to that center to optimize the use of its resources. Conversely, if a work center is over utilized, you can reallocate work orders or consider adding more resources to that work center.

Manufacturing workers use this report to optimize the use of resources. You can analyze each work center's allocated time in the selected capacity unit, and then plan your work accordingly.

Key performance indicators (KPIs)

The Allocated Hours 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:

  • Production Order Capacity Need
  • Work Center
  • Work Center Group
  • Production Order
  • Manufacturing Setup

Try the report

Try the report here: Allocated Hours

Tip

If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.

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

Find free e-learning modules for Business Central here