Power BI Manufacturing app KPIs and measures

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

This page provides a list of all Key Performance Indicators (KPIs) included in the semantic model for the Power BI Manufacturing report.

Explore the list of KPIs below to learn more about how they can help you achieve your business goals.

Each KPI is described, including how it is calculated and what data was used in the calculations.

Capacity KPIs

• Capacity Cost Amt. Deviation %
• Capacity Cost Amt. Variance
• Capacity Used Deviation %
• Capacity Used Variance (Hours)
• Direct Cost Deviation %
• Direct Cost Variance
• Expected Capacity Need %
• Load %
• Overhead Cost Deviation %
• Overhead Cost Variance
• Scrap %
• Utilization %

Capacity Cost Amt. Deviation%

Formula

• This measure calculates the deviation between the actual capacity cost amount and the expected capacity cost amount, expressed as a percentage.

  Capacity Cost Amt. Deviation % = (Capacity Cost Amt. (Actual) - Expected Capacity Cost Amount)/ Expected Capacity Cost Amount

Data Sources

• Item Ledger Entry

Capacity Cost Amt. Variance

Formula

• This measure calculates the variance between the expected cost of capacity utilization and the actual cost of capacity utilization.

  Capacity Cost Amt. Variance = -(Expected Capacity Cost Amount - Capacity Cost Amt. (Actual))

Data Sources

• Capacity Ledger Entry
• Prod. Order Routing Line

Capacity Used Deviation%

Formula

Capacity Used Deviation = ( Capacity Used (Hours) - Expected Capacity Need (Hours) ) / Expected Capacity Need (Hours)

Data Sources

• Capacity Ledger Entry
• Prod. Order Routing Line

Capacity Used Variance (Hours)

Formula

• This measure shows the variance between the expected capacity need and the actual capacity used.

  Capacity Used Variance (Hours) = -(Expected Capacity Need (Hours) - Capacity Used (Hours))

Data Sources

• Prod. Order Routing Line
• Capacity Ledger Entry

Direct Cost Deviation%

Formula

Direct Cost Deviation = ( Direct Cost - Expected Operation Cost Amt. ) / Expected Operation Cost Amt.

Data Sources

• Prod. Order Routing Line
• Capacity Ledger Entry

Direct Cost Variance

Formula

Direct Cost Variance = Expected Operation Cost Amt. - Direct Cost

Data Sources

• Prod. Order Routing Line
• Capacity Ledger Entry

Expected Capacity Need%

Formula

Expected Capacity Need % = Expected Capacity Need (Hours) / Capacity Available (Hours) Data Sources

• Prod. Order Routing Line
• Calendar Entry

Load%

Formula

• This measure is calculates the percentage of available capacity that is currently being utilized, expressed as a percentage..

  Load % = Allocated Time (Hours) / Capacity Available (Hours)

Data Sources

• Calendar Entry
• Prod. Order Routing Line

Overhead Cost Deviation%

Formula
Overhead Cost Deviation % = ( Overhead Cost - Expected Capacity Ovhd. Cost ) / Expected Capacity Ovhd. Cost

Data Sources

• Prod. Order Routing Line
• Capacity Ledger Entry

Overhead Cost Variance

Formula

Overhead Cost Variance = Expected Capacity Ovhd. Cost - Overhead Cost

Data Sources

• Prod. Order Routing Line
• Capacity Ledger Entry

Scrap%

Formula

Scrap % = Capacity Scrap Qty. / Capacity Output Qty.

Data Source

• Capacity Ledger Entry

Utilization%

Formula

Utilization % = Capacity Used (Hours) / Capacity Available (Hours)

Data Source

• Capacity Ledger Entry
• Calendar Entry

Capacity Measures

• Allocated Time (Hours)
• Capacity Available (Hours)
• Capacity Cost Amt. (Actual)
• Capacity Output Qty.
• Capacity Scrap Qty.
• Capacity Used (Hours)
• Capacity Used per Unit (Hours)
• Direct Cost
• Expected Capacity Cost Amount
• Expected Capacity Need (Hours)
• Expected Capacity Ovhd. Cost
• Expected Operation Cost Amt.
• Overhead Cost
• Run Time (Hours)
• Run Time per Unit (Hours)
• Setup Time
• Setup Time per Unit (Hours)
• Stop Time
• Stop Time per Unit (Hours)

Allocated Time (Hours)

Formula

• This measure shows the amount of time in hours that are allocated for production order routing lines by summing up all the allocated time values from the Production Data table.

Data Sources

• Prod. Order Capacity Need
• Prod. Order Routing Line

Capacity Available (Hours)

Formula

• This measure shows the total amount of available capacity in hours by summing up all capacity available values from the Production Data table.

Data Sources

• Calendar Entry

Capacity Cost Amt. (Actual)

Formula

• This measure calculates the actual cost of capacity utilization for a given period by summing up the Direct Cost and the Overhead Cost. The Direct Cost represents the direct expenses incurred in producing a product, while the Overhead Cost represents the indirect expenses incurred in producing a product, such as rent, utilities, and maintenance.

  Capacity Cost Amt. (Actual) = Direct Cost + Overhead Cost

Data Sources

• Capacity Ledger Entry

Capacity Output Qty.

Formula

• This measure calculates the total Capacity Output Quantity in a given period by summing up the output quantity for each capacity ledger entry from the Production Data table.

Data Sources

• Capacity Ledger Entry

Capacity Scrap Qty.

Formula

• This measure calculates the total scrap quantity in a given period by summing up the scrap quantity for each capacity ledger entry from the Production Data table.

Data Sources

• Capacity Ledger Entry

Capacity Used (Hours)

Formula

• This measure shows the total number of capacity hours used by summing up the capacity requirement for each production activity from the Production Data table.

Data Sources

• Capacity Ledger Entry

Capacity Used per Unit (Hours)

Formula

• This measure shows the amount of capacity utilized to produce a single unit of a product.

  Capacity Used per Unit (Hours) = Capacity Used (Hours) / Finished Quantity (Base)

Data Sources

• Capacity Ledger Entry

Direct Cost

Formula

• This measure calculates the direct cost by summing up the Direct Cost for each capacity ledger entry from the Production Data table.

Data Sources

• Capacity Ledger Entry

Expected Capacity Cost Amount

Formula

• This measure calculates the expected cost of capacity utilization for a given period by summing up the Expected Operation Cost Amount and the Expected Capacity Overhead Cost. The Expected Operation Cost Amount represents the expected cost of operating the equipment or machinery used in production, while the Expected Capacity Overhead Cost represents the expected cost of indirect resources used in production, such as rent, utilities, and maintenance.

  Expected Capacity Cost Amount = Expected Operation Cost Amount + Expected Capacity Overhead Cost

Data Sources

• Prod. Order Routing Line

Expected Capacity Need (Hours)

Formula

• This measure shows the expected total capacity required for production by summing up the expected capacity need (in hours) for each production activity from the Production Data table.

Data Sources

• Prod. Order Routing Line

Expected Capacity Ovhd. Cost

Formula

• This measure calculates the Expected Capacity Ovhd. Cost by summing up the Expected Capacity Ovhd. Cost for each Prod. Order Routing Line from the Production Data table.

Data Sources

• Prod. Order Routing Line

Expected Operation Cost Amt.

Formula

• This measure calculates the Expected Operation Cost Amt. by summing up the Expected Operation Cost Amt. for each Prod. Order Routing Line from the Production Data table.

Data Sources

• Prod. Order Routing Line

Overhead Cost

Formula

• This measure calculates the Overhead Cost by summing up the Overhead Cost for each Capacity Ledger Entry from the Production Data table.

Data Sources

• Capacity Ledger Entry

Run Time (Hours)

Formula

• This measure calculates the Run Time (Hours) by summing up the Run Time (Hr.) for each Capacity Ledger Entry from the Production Data table.

Data Sources

• Capacity Ledger Entry

Run Time per Unit (Hours)

Formula

• This measure is shows the amount of time required to produce a single unit of a product.

  Run Time per Unit (Hours) = Run Time (Hours) / Finished Quantity (Base)

Data Sources

• Capacity Ledger Entry

Setup Time (Hours)

Formula

• This measure calculates the Setup Time (Hours) by summing up the Setup Time (Hr.) for each Capacity Ledger Entry from the Production Data table

Data Sources

• Capacity Ledger Entry

Setup Time per Unit (Hours)

Formula

• This measure shows the amount of time required to set up a machine or equipment for production.

  Setup Time per Unit (Hours) = Setup Time (Hours) / Finished Quantity (Base)

Data Sources

• Capacity Ledger Entry

Stop Time (Hours)

Formula

• This measure calculates the Stop Time (Hours) by summing up the Stop Time (Hr.) for each Capacity Ledger Entry from the Production Data table

Data Sources

• Capacity Ledger Entry

Stop Time per Unit (Hours)

Formula

• This measure shows the amount of time lost due to equipment downtime or stoppages, per unit produced.

  Stop Time per Unit (Hours) = Stop Time (Hours) / Finished Quantity (Base)

Data Sources

• Capacity Ledger Entry

Consumption KPIs

• % Consumed
• % Consumption Rem.
• Consumption Cost Amt. Deviation %
• Consumption Cost Amt. Variance
• Consumption Qty. Deviation %
• Consumption Qty. Variance

%Consumed

Formula
Qty. Consumed (Base) / Expected Consumption Qty. (Base)

Data Sources

• Item Ledger Entry
• Prod. Order Component

%Consumed Rem.

Formula
Rem. Qty. to Consume (Base) / Expected Consumption Qty. (Base)

Data Sources

• Prod. Order Component

Consumption Cost Amt. Deviation%

Formula

• This measure calculates the deviation between the actual consumption cost amount and the expected consumption cost amount, expressed as a percentage.

  Consumption Cost Amt. Deviation % = (Consumed Cost Amount (Actual) - Expected Consumption Cost Amount) / Expected Consumption Cost Amount

Data Sources

• Item Ledger Entry
• Prod. Order Component

Consumption Cost Amt. Variance

Formula

• This measure shows the variance between the expected cost of consumed items and the actual cost of consumed items.

  Consumption Cost Amt. Variance = -(Expected Consumption Cost Amount - Consumed Cost Amount (Actual))

Data Sources

• Prod. Order Component
• Item Ledger Entry

Consumption Qty. Deviation%

Formula
( Qty. Consumed (Base) - Expected Consumption Qty. (Base) ) / Expected Consumption Qty. (Base)

Data Sources

• Prod. Order Component
• Item Ledger Entry

Consumption Qty. Variance

Formula
Expected Consumption Qty. (Base) - Qty. Consumed (Base)

Data Sources

• Prod. Order Component
• Item Ledger Entry

Consumption Measures

• Consumed Cost Amount (Actual)
• Expected Consumption Cost Amount
• Expected Consumption Qty. (Base)
• Qty. Consumed (Base)
• Rem. Consumption Cost Amt.
• Rem. Qty. to Consume (Base)

Consumed Cost Amount (Actual)

Formula

• This measure shows the actual cost of consumed items for a given period by summing up the actual cost of each item used in production. To calculate this cost amount, the measure calculates the sum of the actual cost of items consumed from the Production Data Table, filtered for the Consumption data source.

Data Sources

• Item Ledger Entry

Expected Consumption Cost Amount

Formula

• This measure shows the expected cost of consumed items for a given period by summing up the expected consumption cost of each item used in production. To calculate this cost amount, the measure multiplies the expected consumption quantity of each item by its related unit cost and then sums up the results from the Production Data table.

Data Sources

• Prod. Order Component

Expected Consumption Qty. (Base)

Formula

• This measure calculates the expected consumption quantity by summing up the Expected Consumption Qty. (Base) for each Prod. Order Component from the Production Data table.

Data Sources

• Prod. Order Component

Qty. Consumed (Base)

Formula

• This measure calculates the quantity consumed by summing up Quantity for each consumption Item Ledger Entry from the Production Data table.

Data Sources

• Item Ledger Entry

Rem. Consumption Cost Amt.

Formula

• The Rem. Consumption Cost Amt. measure calculates the total remaining consumption cost for production order components. It filters the Production Data Table to include only rows where the [Data Source] is Prod. Order Component. For these rows, it multiplies the Rem. Qty. to Consume (Base) by the Unit Cost (LCY) from the related Item table.

Data Sources

• Prod. Order Component
• Item

Rem. Qty. to Consume (Base)

Formula

• This measure calculates the remaining quantity to consume by summing up Remaining Qty. (Base) for each consumption Prod. Order Component from the Production Data table.

Data Sources

• Prod. Order Component

Output KPIs

• % Finished
• % Remaining
• Cost Amt. Deviation %
• Cost Amt. Variance
• Qty. Deviation %
• Qty. Variance

%Finished

Formula
% Finished = ( Finished Quantity (Base) / Expected Quantity (Base) )

Data Sources

• Item Ledger Entry
• Prod. Order Line

%Remaining

Formula
% Remaining = ( Remaining Qty. (Base) / Expected Quantity (Base) )

Data Sources

• Prod. Order Line

Cost Amt. Deviation%

Formula

• This measure calculates the deviation between the expected cost amount and the actual cost amount for finished goods produced, expressed as a percentage.

  Cost Amt. Deviation % = (Finished Cost Amt. (Actual) - Expected Cost Amt.) / Expected Cost Amt.

Data Sources

• Item Ledger Entry
• Prod. Order Line

Cost Amt. Variance

Formula

• This measure calculates the variance between the expected cost amount and the actual cost amount for finished goods produced.

  Cost Amt. Variance = -(Expected Cost Amt. - Finished Cost Amt. (Actual))

Data Sources

• Item Ledger Entry
• Prod. Order Line

Qty. Deviation%

Formula

• This measure shows the deviation between the expected quantity and the actual quantity produced, expressed as a percentage.

  Qty. Deviation % = (Finished Quantity (Base) - Expected Quantity (Base)) / [Expected Quantity (Base)

Data Sources

• Item Ledger Entry
• Prod. Order Line

Qty. Variance

Formula

• This measure calculates the variance between the expected quantity and the actual quantity produced.

Data Sources

• Item Ledger Entry
• Prod. Order Line

Output Measures

• Expected Cost Amt.
• Expected Quantity (Base)
• Finished Cost Amt. (Actual)
• Finished Quantity (Base)
• Remaining Cost Amt.
• Remaining Qty. (Base)

Expected Cost Amt.

Formula

• This measure shows the total expected cost amount by multiplying the quantity (in base units) for each production order line from the Production Data Table by the unit cost (in local currency) for the corresponding item, and summing up the results.

Data Sources

• Prod. Order Line

Expected Quantity (Base)

Formula

• This measure calculates the total expected quantity (in base units) for a given period by summing up the base quantity for each production order line from the Production Data table.

Data Sources

• Prod. Order Line

Finished Cost Amt. (Actual)

Formula

• This measure shows total actual cost amount for finished goods produced by summing up the actual cost amount for each output item ledger entry from the Production Data Table.

Data Sources

• Item Ledger Entry

Finished Quantity (Base)

Formula

• This measure calculates the total quantity of finished products produced in base units over a given period by summing up all the output quantities from the Production Data table.

Data Sources

• Item Ledger Entry

Remaining Cost Amt.

Formula

• This measure calculates the total remaining cost for production order lines. It filters the Production Data Table to include only rows where [Data Source] is Prod. Order Line. For each of these rows, it multiplies [Remaining Qty. (Base)] by the [Unit Cost (LCY)] from the related Item table.

Data Sources

• Prod. Order Line.
• Item

Remaining Qty. (Base)

Formula

• This measure calculates the total remaining quantity for production order lines. It sums the [Remaining Qty. (Base)] column in the Production Data Table, but only for rows where [Data Source] is Prod. Order Line.

Data Sources

• Prod. Order Line

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.

See also

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

Find free e-learning modules for Business Central here