編集

次の方法で共有

Power BI Manufacturing app KPIs and measures

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

This article 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 to learn more about how they can help you achieve your business goals. Each KPI is described, including how it's calculated and what data is used in the calculations.

Calendar Entries

Calendar Entry Measures

Capacity (Effective)

Formula

  • Calculates the total effective capacity from the Calendar Entries table by summing up all values in the Capacity Effective column.

Data Source

  • Calendar Entry

Capacity (Total)

Formula

  • Calculates the overall total effective capacity from the Calendar Entries table by summing up all values in the Capacity Total column.

Data Source

  • Calendar Entry

Capacity Ledger Entries

Capacity Ledger Entry Measures

Capacity Ledger Output Quantity

Formula

  • Calculates the total output quantity recorded in the Capacity Ledger Entries table by summing up all values in the outputQuantity column.

Data Source

  • Capacity Ledger Entry

Capacity Ledger Quantity

Formula

  • Calculates the total quantity recorded in the Capacity Ledger Entries table by summing up all values in the Quantity column.

Data Source

  • Capacity Ledger Entry

Direct Cost

Formula

  • Calculates the cost amount actual from the Value Entries table, specifically filtering for entries categorized as Direct Cost. This measure determines the direct cost for capacity ledger entries by summing the related value entry cost amounts.

Data Source

  • Capacity Ledger Entry
  • Value Entry

Overhead Cost

Formula

  • Calculates the cost amount actual from the Value Entries table, specifically filtering for entries categorized as Indirect Cost. This measure determines the indirect cost for capacity ledger entries by summing the related value entry cost amounts.

Data Source

  • Capacity Ledger Entry
  • Value Entry

Run Time

Formula

  • Calculates the total runtime recorded in the Capacity Ledger Entries table by summing up all values in the Runtime column.

Data Source

  • Capacity Ledger Entry

Scrap Percent

Formula

  • Calculates the percentage of scrapped output by dividing the Scrap Quantity by the total Output Quantity recorded in the Capacity Ledger Entries table.

Data Source

  • Capacity Ledger Entry

Scrap Quantity

Formula

  • Calculates the total amount of scrapped output recorded in the Capacity Ledger Entries table by summing up all values in the scrapQuantity column.

Data Source

  • Capacity Ledger Entry

Setup Time

Formula

  • Calculates the total setup time recorded in the Capacity Ledger Entries table by summing up all values in the setupTime column.

Data Source

  • Capacity Ledger Entry

Stop Time

Formula

  • Calculates the total stop time recorded in the Capacity Ledger Entries table by summing up all values in the stopTime column.

Data Source

  • Capacity Ledger Entry

Item Ledger Entries

Item Ledger Entry Measures

Consumption Quantity

Formula

  • Calculates the total Quantity of item ledger entries where the Entry Type is Consumption by filtering the Item Ledger Entries table before summing.

Data Source

  • Item Ledger Entry

Item Ledger Entry Cost Amount Actual

Formula

  • Calculates the total actual cost recorded in the Item Ledger Entries table by summing up all values in the costAmountActual column.

Data Source

  • Item Ledger Entry

Output Quantity

Formula

  • Calculates the total Quantity of item ledger entries where the Entry Type is Output by filtering the Item Ledger Entries table before summing.

Data Source

  • Item Ledger Entry

Quantity

Formula

  • Sums the values in the Qty column of the Item Ledger Entries table to calculate the total quantity across all records.

Data Source

  • Item Ledger Entry

Machine Center

Machine Center Measures

Machine Center Availability After Orders

Formula

Data Source

  • Prod Order Capacity Need
  • Calendar Entry

Machine Center Load

Formula

Data Source

  • Prod Order Capacity Need
  • Calendar Entry

Machine Center Output

Formula

  • Calculates the total output quantity for machine centers by summing the outputQuantity column in the Capacity Ledger Entries table, filtered to include only rows where Type is Machine Center.

Data Source

  • Capacity Ledger Entry

Machine Center Run Time

Formula

  • Calculates the total run time for machine centers by summing the runTime and setupTime columns in the Capacity Ledger Entries table, filtered to include only rows where Type is Machine Center. This is done using the SUMX function over the filtered table.

Data Source

  • Capacity Ledger Entry

Machine Center Scrap

Formula

  • Calculates the total scrap quantity for machine centers by summing the scrapQuantity column in the Capacity Ledger Entries table, filtered to include only rows where Type is Machine Center.

Data Source

  • Capacity Ledger Entry

Machine Center Scrap Percent

Formula

Data Source

  • Capacity Ledger Entry

Machine Center Stop Percent

Formula

Data Source

  • Capacity Ledger Entry

Machine Center Stop Time

Formula

  • Calculates the total stop time for machine centers by summing the stopTime column in the Capacity Ledger Entries table, filtered to include only rows where Type is Machine Center.

Data Source

  • Capacity Ledger Entry

Machine Center Statistics

Machine Center Actual Efficiency Percent

Formula

Data Source

  • Capacity Ledger Entry
  • Calendar Entry

Machine Center Actual Need

Formula

  • Calculates the total actual time required for machine centers by summing the setupTime, runTime, and stopTime columns in the Capacity Ledger Entries table, filtered to include only rows where Type is Machine Center. This is done using the SUMX function over the filtered table.

Data Source

  • Capacity Ledger Entry

Machine Center Actual Total Cost

Formula

  • Calculates the total actual cost for machine centers by adding the Direct Cost and Overhead Cost measures, filtered to include only rows in the Capacity Ledger Entries table where Type is Machine Center.

Data Source

  • Capacity Ledger Entry
  • Value Entry

Machine Center Allocated Time

Formula

  • Calculates the total allocated time for machine centers by summing the allocatedTime column in the Prod Order Capacity Need table, filtered to include only rows where Type is Machine Center and Requested Only is FALSE.

Data Source

  • Prod Order Capacity Need

Machine Center Capacity (Effective)

Formula

  • Calculates the total effective capacity for machine centers by summing the Capacity Effective column in the Calendar Entries table, filtered to include only rows where Capacity Type is Machine Center.

Data Source

  • Calendar Entry

Machine Center Capacity (Total)

Formula

  • Calculates the total capacity for machine centers by summing the Capacity Total column in the Calendar Entries table, filtered to include only rows where Capacity Type is Machine Center.

Data Source

  • Calendar Entry

Machine Center Expected Efficiency Percent

Formula

Data Source

  • Calendar Entry

Prod Order Capacity Need

Prod Order Capacity Need Measures

Allocated Time

Formula

  • Calculates the total allocated time by summing the allocatedTime column in the Prod Order Capacity Need table, filtered to include only rows where Requested Only is FALSE.

Data Source

  • Prod Order Capacity Need

Needed Time

Formula

  • Calculates the total needed time by summing the neededTime column in the Prod Order Capacity Need table.

Data Source

  • Prod Order Capacity Need

Needed Time (MS)

Formula

  • Calculates the total needed time in manufacturing-specific units by dividing the sum of neededTimeMs from the Prod Order Capacity Need table by a Time Factor. The Time Factor is retrieved using LOOKUPVALUE based on the capacity unit of measure selected in the Manufacturing Setup table.

Data Source

  • Prod Order Capacity Need
  • Manufacturing Setup

Prod Order Components

Prod Order Component Measures

Prod Order Component Cost Amount

Formula

  • Calculates the total cost of production order components by summing the costAmount column in the Prod Order Components table.

Data Source

  • Prod Order Component

Prod Order Component Expected Qty. (Base)

Formula

  • Calculates the total expected quantity (in base units) of production order components by summing the expectedQtyBase column in the Prod Order Components table.

Data Source

  • Prod Order Component

Prod Order Component Remaining Qty. (Base)

Formula

  • Calculates the total remaining quantity (in base units) of production order components by summing the remainingQtyBase column in the Prod Order Components table.

Data Source

  • Prod Order Component

Prod Order Routing Lines

Prod Order Routing Measures

Expected Operation Cost

Formula

  • Calculates the total expected operational cost by using SUMX to iterate over the Prod Order Routing Lines table and summing the difference between Expected Operation Cost Amt. and Expected Capacity Ovhd. Cost for each row.

Data Source

  • Prod Order Routing Line

Operation Move Time

Formula

  • Calculates the total move time for production order routing lines by summing the Move Time column in the Prod Order Routing Lines table.

Data Source

  • Prod Order Routing Line

Operation Run Time

Formula

  • Calculates the total run time for production order routing lines by summing the Run Time column in the Prod Order Routing Lines table.

Data Source

  • Prod Order Routing Line

Operation Setup Time

Formula

  • Calculates the total setup time for production order routing lines by summing the Setup Time column in the Prod Order Routing Lines table.

Data Source

  • Prod Order Routing Line

Operation Wait Time

Formula

  • Calculates the total wait time for production order routing lines by summing the Wait Time column in the Prod Order Routing Lines table.

Data Source

  • Prod Order Routing Line

Prod Order Routing Expected Capacity Need

Formula

  • Calculates the total expected capacity requirement for production order routing lines by summing the Expected Capacity Need column in the Prod Order Routing Lines table.

Data Source

  • Prod Order Routing Line

Prod Order Routing Expected Capacity Ovhd. Cost

Formula

  • Calculates the total expected capacity overhead cost for production order routing lines by summing the Expected Capacity Ovhd. Cost column in the Prod Order Routing Lines table.

Data Source

  • Prod Order Routing Line

Prod Order Routing Expected Operation Cost Amt

Formula

  • Calculates the total expected operation cost amount for production order routing lines by summing the Expected Operation Cost Amt. column in the Prod Order Routing Lines table.

Data Source

  • Prod Order Routing Line

Total Duration Days

Formula

  • Calculates the total duration of production order routing lines in days by summing the Duration Total Days column in the Prod Order Routing Lines table. The Duration Total Days column is calculated in Power Query from the Starting Date Time and Ending Date Time fields on the Prod Order Routing Line.

Data Source

  • Prod Order Routing Line

Total Duration Hours

Formula

  • Calculates the total duration of production order routing lines in hours by summing the Duration Total Hours column in the Prod Order Routing Lines table. The Duration Total Hours column is calculated in Power Query from the Starting Date Time and Ending Date Time fields on the Prod Order Routing Line.

Data Source

  • Prod Order Routing Line

Production Order Lines

Production Order Line Measures

Finished Quantity (Base)

Formula

  • Calculates the total finished quantity in base units for production order lines by summing the finishedQtyBase column in the Production Order Lines table.

Data Source

  • Prod. Order Line

Quantity (Base)

  • Calculates the total quantity in base units for production order lines by summing the quantityBase column in the Production Order Lines table.

Data Source

  • Prod. Order Line

Remaining Quantity (Base)

Formula

  • Calculates the total remaining quantity in base units for production order lines by summing the remainingQtyBase column in the Production Order Lines table.

Data Source

  • Prod. Order Line

Production Orders

Production Order Measures

Actual Time Used

Formula

  • Calculates the total actual time used by production orders. It first summarizes the production orders and computes the Actual Time by summing the Quantity from the Capacity Ledger Entries table, only when there is a Finished Quantity. Then, it sums up these values across all production orders using SUMX.

Data Source

  • Capacity Ledger Entry
  • Production Order

Average Production Time Per Finished Quantity

Formula

Data Source

  • Capacity Ledger Entry
  • Production Order

Expected Production Order Scrap Quantity

Formula

  • Calculates the expected scrap quantity for production orders by multiplying the Finished Quantity by the Prod Order Source No. Scrap % for the selected production order.

Data Source

  • Production Order
  • Item
  • Item Ledger Entries

Finished Percent

Formula

Data Source

  • Production Order
  • Item Ledger Entry

Finished Quantity

Formula

  • Calculates the total finished quantity for each production order source number. It summarizes the Production Orders table by Production Order and Prod Order Source No., and then calculates the finished quantity by summing the Qty from the Item Ledger Entries table where the Entry Type is Output and the Item No. matches the selected Prod Order Source No.. Finally, it sums the finished quantities across all production orders using SUMX.

Data Source

  • Production Order
  • Item Ledger Entry

No. of Production Orders

Formula

  • The No. of Production Orders measure calculates the total number of production orders by counting the distinct entries in the Production Order column of the Production Orders table.

Data Source

  • Production Order

Planned Quantity

Formula

  • The Planned Quantity measure calculates the total planned quantity for production orders by summing the Quantity column in the Production Orders table.

Data Source

  • Production Order

Production Order Scrap Percent

Formula

  • The Production Order Scrap % measure calculates the percentage of scrap quantity relative to the finished quantity by dividing the Scrap Quantity by the Finished Quantity.

Data Source

  • Item Ledger Entry
  • Capacity Ledger Entry

Remaining Percent

Formula

  • Calculates the remaining percentage of the planned quantity that hasn't been finished. It checks whether the Finished Quantity is less than the Planned Quantity. If it is, it returns the negative of the Variance Quantity divided by the Planned Quantity. If the finished quantity is greater than or equal to the planned quantity, it returns BLANK.

Data Source

  • Item Ledger Entry
  • Production Order

Variance Quantity

Formula

  • Calculates the difference between the Finished Quantity and the Planned Quantity, indicating whether the production order has a surplus or deficit in finished quantity relative to what was planned.

Data Source

  • Item Ledger Entry
  • Production Order

Production Order Statistics

Actual Costs

Actual Capacity Cost

Formula

Calculates the actual cost of capacity usage based on production order lines and related inventory adjustments. Here's a breakdown of the calculation:

  1. Variables for Production Order Details: The measure defines variables for the Production Order Number, Production Order Line Number, Item Number, and Production Order Status from the Production Order Lines table.

  2. Inventory Adjustment Lines: It then creates a table of relevant inventory adjustment lines that correspond to the current production order line, with the condition that the iSFinished status is set to TRUE if the production order status is Finished.

  3. Inventory Adjustment Details: The measure selects the order number, item number, and order line number from the inventory adjustment lines.

  4. Capacity Ledger Entries: It then filters the Capacity Ledger Entries table to match the Order No., Order Line No., and Item No. from the inventory adjustments and ensures Subcontracting is excluded.

  5. Return the Actual Capacity Cost: Finally, the measure calculates the sum of directCost from the Capacity Ledger Entries table, dividing it by the ShareOfCapCost measure to account for the specific share of capacity costs.

This complex calculation ties together various production and inventory details to derive the actual capacity cost for the production orders.

Data Source

  • Prod. Order Line
  • Capacity Ledger Entry
  • Inventory Adjmt. Entry (Order)
Actual Capacity Overhead Cost

Formula

  • Calculates the total overhead cost recorded in capacity ledger entries by summing the overheadCost column in the Capacity Ledger Entries table.

Data Source

  • Capacity Ledger Entry
Actual Manufacturing Overhead Cost

Formula

Calculates the total overhead cost incurred during manufacturing by combining indirect cost percentages and per-unit overhead rates with actual production metrics. Here's how it works:

  1. IndirectCost: It sums the indirectCostPercent values across all production order lines.

  2. OverheadRate: It sums the overheadRate values across all production order lines.

  3. OutputQty: It calculates the total output quantity from the Item Ledger Entries table, filtered to include only entries of type "Output", and scoped to the currently selected production order.

  4. Final Calculation: The measure multiplies the sum of the following by the IndirectCost percentage (converted from percent to decimal), and then adds the product of OutputQty and OverheadRate.

This measure captures both proportional overhead based on other costs and fixed overhead based on output volume.

Data Sources

  • Prod. Order Line
  • Item Ledger Entry
  • Capacity Ledger Entry
  • Value Entry
Actual Material Cost

Formula

Calculates the total material cost consumed in production by summing the costAmountActual from the Value Entries table, filtered to:

  • Exclude entries where entryType is Rounding.
  • Include only entries where Item Ledger Entry Type is Consumption.

The result is then multiplied by -1 to reflect material consumption as a cost.

Data Source

  • Value Entry
Actual Subcontracted Cost

Formula Calculates the total direct cost of subcontracted work associated with production orders. Here's how it works:

  1. Context per Line: For each row in the Production Order Lines table, it defines key variables:

    • ProdOrderNo
    • ProdOrderLineNo
    • ProdOrderItem
    • ProdOrderStatus

  2. Inventory Adjustment Matching: It retrieves matching rows from Inventory Adjustment Entry Order Line, where:

    • THe order number, line number, and item match the production order line variables.
    • The iSFinished flag corresponds to whether the production order is marked as Finished.

  3. Subcontracted Capacity Ledger Entries: It then filters the Capacity Ledger Entries table to:

    • Match the order number, order line number, and item number from the inventory adjustment.
    • Include only entries where Subcontracting is TRUE.

  4. Cost Calculation: It calculates the total directCost from these filtered subcontracted capacity ledger entries and divides it by the ShareOfCapCost measure.

  5. Aggregation: SUMX iterates this logic over all production order lines, returning the total actual subcontracted cost.

This measure isolates and aggregates costs related to subcontracted operations.

Data Source

  • Prod. Order Line
  • Capacity Ledger Entry
  • Inventory Adjmt. Entry (Order)
Total Actual Cost

Formula

Calculates the full cost of production by summing the following measures:

This measure provides a comprehensive view of all actual costs incurred during the production process.

Data Source

  • Prod. Order Line
  • Capacity Ledger Entry
  • Inventory Adjmt. Entry (Order)
  • Value Entry
  • Item Ledger Entry

Capacity Need

Prod Order Actual Capacity Need

Formula

Calculates the actual capacity used for production orders, converted into the unit of measure specified in the manufacturing setup. Here's how it works:

  1. Manufacturing Time Factor: Retrieves the appropriate time factor from the Time Factors table based on the capacity unit defined in the Manufacturing Setup.

  2. Quantity Calculation (Qty variable): Iterates over filtered Capacity Ledger Entries (excluding subcontracting), and for each row:

    • Determines the Qty Per Capacity Unit of Measure (defaulting to 1 if zero).

    • Looks up the appropriate Time Factor:

      • If the Qty Per Capacity Unit of Measure is zero, it uses the time factor based on the work center’s unit of measure. Otherwise, it uses the time factor based on the entry's own capacity unit.
      • Computes the adjusted quantity as quantity / QtyPerCapUnitOfMeasure * TimeFactor.

  3. Final Conversion: Divides the total adjusted quantity by the Manufacturing Time Factor to express it in the target unit.

This measure provides a standardized view of how much capacity was actually used, accounting for differences in units and time factors across capacity entries.

Data Source

  • Capacity Ledger Entry
  • Manufacturing Setup
Prod Order Capacity Need Dev Percent

Formula

Data Source

  • Prod Order Routing Line
  • Prod Order Capacity Need
  • Capacity Ledger Entry
  • Manufacturing Setup
Prod Order Capacity Need Variance

Formula

Data Sources

  • Prod Order Routing Line
  • Prod Order Capacity Need
  • Capacity Ledger Entry
  • Manufacturing Setup
Prod Order Expected Capacity Need

Formula

Returns the appropriate expected capacity need based on the status of the production order:

The measure reflects different logic depending on whether the production order is completed or still in progress.

Data Source

  • Prod Order Routing Line
  • Prod Order Capacity Need
  • Manufacturing Setup
Prod Order Expected Capacity Need (Finished)

Formula

Calculates the expected capacity required for finished production orders, adjusted to a standardized unit of measure. Here's how it works:

  1. Time Factor: Retrieves the time conversion factor from the Time Factors table based on the unit configured in the Manufacturing Setup.

  2. Expected Capacity Need: Sums the Expected Capacity Need from the Prod Order Routing Lines table, filtering for:

    • Production orders with status "Finished".
    • Work centers that are not subcontractors.

  3. Conversion: Divides the total expected capacity by the Time Factor to express the result in the standard capacity unit.

This measure provides a normalized view of planned capacity usage for completed production orders, excluding subcontracted operations.

Data Source

  • Prod Order Routing Line
  • Manufacturing Setup
Prod Order Expected Capacity Need (Non Finished)

Formula

Calculates the expected capacity required for non-finished production orders, adjusted to a standardized unit of measure. Here's how it works:

  1. Time Factor: Retrieves the time conversion factor from the Time Factors table based on the unit defined in the Manufacturing Setup.

  2. Expected Capacity Need: Sums the neededTimeMs from the Prod Order Capacity Need table, filtering for:

    • Production orders with a status not equal to Finished.
    • Work centers that are not subcontractors. For example, Work Center Subcontractor No. is blank.

  3. Conversion: Divides the total neededTimeMs by the Time Factor to express the result in the standard capacity unit.

This measure provides a normalized view of the planned capacity usage for ongoing or unfinished production orders, excluding subcontracted operations.

Data Source

  • Prod Order Capacity Need
  • Manufacturing Setup

Expected Costs

Expected Capacity Cost

Formula

Data Source

  • Prod Order Line
  • Prod Order Routing Line
  • Prod Order Component
Expected Capacity Overhead Cost

Formula

  • Calculates the total overhead cost expected from capacity usage by summing the Expected Capacity Ovhd. Cost field from the Prod Order Routing Lines table. This represents the anticipated indirect costs associated with capacity operations in the production process.

Data Source

  • Prod Order Routing Line
Expected Manufacturing Overhead Cost

Formula

The Expected Manufacturing Overhead Cost measure calculates the total manufacturing overhead cost for a production order by:

  1. Retrieving Direct Cost: It uses the variable ExpMfgDirCost, which represents the expected manufacturing direct cost.

  2. Iterating Over Production Order Lines: For each line, it adds:

    • The value of ExpOvhdCost: Calculated by iterating over each row in the Production Order Lines table. Multiplying the overheadRate by the quantityBase.
    • A percentage-based overhead component, calculated as the line’s indirectCostPercent multiplied by the total ExpMfgDirCost, divided by 100.

  3. Summing the Result: SUMX aggregates the per-line overhead contributions into a total.

Data Source

  • Prod. Order Line
  • Prod Order Routing Line
  • Prod Order Components
Expected Material Cost

Formula

  • Calculates the total expected cost of materials for a production order by summing the costAmount field from the Prod Order Components table. This represents the projected material expense based on the components planned for use.

Data Source

  • Prod Order Component
Expected Subcontracted Cost

Formula

Estimates the portion of expected capacity cost attributed to subcontracted operations by:

  1. Identifying Subcontracting Work Centers: Filters the Work Center table to include only those with a Subcontractor No.. For example, subcontracted operations.

  2. Calculating Expected Operation Cost for Subcontracting: Computes Expected Operation Cost restricted to those subcontracting work centers.

  3. Determining Share of Total Capacity Cost: Retrieves the ShareOfTotalCapCost for the current production order from the Production Order Lines table.

  4. Final Calculation: Multiplies the Expected Operation Cost for Subcontracting by the order’s share of total capacity cost.

Data Source

  • Prod Order Line
  • Prod Order Routing Line
  • Prod Order Component
Total Expected Cost

Calculates the overall anticipated cost of a production order by summing the following components:

This measure provides a complete view of all expected production costs, combining direct and indirect, in-house and subcontracted expenses.

Data Source

  • Prod Order Line
  • Prod Order Routing Line
Variance to Expected Cost
Expected Capacity Cost Variance

Formula

Data Source

  • Prod Order Line
  • Prod Order Routing Line
  • Prod Order Component
  • Capacity Ledger Entry
  • Inventory Adjmt. Entry (Order)
Expected Capacity Overhead Cost Variance

Formula

Data Source

  • Capacity Ledger Entry
  • Prod Order Routing Line
Expected Manufacturing Overhead Cost Variance

Formula

Data Source

  • Prod. Order Line
  • Item Ledger Entry
  • Capacity Ledger Entry
  • Value Entry
  • Prod Order Routing Line
  • Prod Order Component
Expected Material Cost Variance

Formula

Data Source

  • Value Entry
  • Prod Order Component
Expected Subcontracted Cost Variance

Formula

Data Source

  • Prod. Order Line
  • Capacity Ledger Entry
  • Inventory Adjmt. Entry (Order)
  • Prod Order Routing Line
  • Prod Order Component
Total Expected Cost Variance

Formula

Calculates the overall difference between actual and expected costs by summing the following sub-measures:

Data Source

  • Prod. Order Line
  • Capacity Ledger Entry
  • Inventory Adjmt. Entry (Order)
  • Prod Order Routing Line
  • Prod Order Component
  • Value Entry
  • Item Ledger Entry
Variance to Expected Cost Deviation %
Expected Capacity Cost Dev Percent

Formula

Data Source

  • Prod Order Line
  • Prod Order Routing Line
  • Prod Order Component
  • Capacity Ledger Entry
  • Inventory Adjmt. Entry (Order)
Expected Capacity Overhead Cost Dev Percent

Formula

Data Source

  • Capacity Ledger Entry
  • Prod Order Routing Line
Expected Manufacturing Overhead Cost Dev Percent

Formula

Data Source

  • Prod. Order Line
  • Item Ledger Entry
  • Capacity Ledger Entry
  • Value Entry
  • Prod Order Routing Line
  • Prod Order Component
Expected Material Cost Dev Percent

Formula

Data Source

  • Value Entry
  • Prod Order Component
Expected Subcontracted Cost Dev Percent

Formula

Data Source

  • Prod. Order Line
  • Capacity Ledger Entry
  • Inventory Adjmt. Entry (Order)
  • Prod Order Routing Line
  • Prod Order Component
Total Expected Cost Dev Percent

Formula

Data Source

  • Prod. Order Line
  • Capacity Ledger Entry
  • Inventory Adjmt. Entry (Order)
  • Prod Order Routing Line
  • Prod Order Component
  • Value Entry
  • Item Ledger Entry

Standard Costs

Standard Capacity Cost

Formula

Calculates the standard capacity cost for production order lines, using either item master data or finalized inventory adjustments:

  • For each production order line:
    • If the line is fully invoiced, use the finished quantity multiplied by the single-level capacity cost from the inventory adjustment.
    • Otherwise, use the quantity Base from Production Order Lines multiplied by the Item Single-Level Capacity Cost from the Item Card.

Data Source

  • Prod Order Line
  • Inventory Adjmt. Entry (Order)
  • Item
Standard Capacity Overhead Cost

Formula

Calculates the standard capacity overhead cost for each production order line, using either item master data or finalized inventory adjustments:

  • For each production order line:
    • If fully invoiced, multiply the finished quantity by the single-level capacity overhead cost from the inventory adjustment entry.
    • Otherwise, use the quantity Base from Production Order Lines multiplied by the Item Single-Level Cap. Ovhd Cost from the Item Card.

Data Source

  • Prod Order Line
  • Inventory Adjmt. Entry (Order)
  • Item
Standard Manufacturing Overhead Cost

Formula

Calculates the standard manufacturing overhead cost for each production order line, using either finalized inventory adjustment data or standard item-level overhead rates.

  • For each production order line:
    • If the line is fully invoiced, multiply the finished quantity by the single-level manufacturing overhead cost from the inventory adjustment.
    • Otherwise, use the quantity Base from Production Order Lines multiplied by the Item Single-Level Mfg. Ovhd Cost from the Item Card.

Data Source

  • Prod Order Line
  • Inventory Adjmt. Entry (Order)
  • Item
Standard Material Cost

Formula

Calculates the standard material cost for each production order line based on either finalized inventory adjustments or item-level standard costs:

  • For each production order line:
    • If the line is fully invoiced, multiply the finished quantity by the single-level material cost from the inventory adjustment entry.
    • Otherwise, use the quantity Base from Production Order Lines multiplied by the Item Single-Level Material Cost from the Item Card.

Data Source

  • Prod Order Line
  • Inventory Adjmt. Entry (Order)
  • Item
Standard Subcontracted Cost

Formula

Calculates the standard subcontracted cost for each production order line based on either finalized inventory adjustments or item-level standard costs:

  • For each production order line:
    • If the line is fully invoiced, multiply the finished quantity by the single-level subcontracted cost from the inventory adjustment entry.
    • Otherwise, use the quantity Base from Production Order Lines multiplied by the Item Single-Level Subcontrd. Cost from the Item Card.

Data Source

  • Prod Order Line
  • Inventory Adjmt. Entry (Order)
  • Item
Total Standard Cost

Formula

Sums up the various standard cost components associated with a production order. The measure calculates the total standard cost by adding up the following:

Data Source

  • Prod Order Line
  • Inventory Adjmt. Entry (Order)
  • Item
Variance to Standard Cost
Standard Capacity Cost Variance

Formula

Calculates the difference between the Actual Capacity Cost and Standard Capacity Cost.

Data Source

  • Prod. Order Line
  • Capacity Ledger Entry
  • Inventory Adjmt. Entry (Order)
  • Item
Standard Capacity Overhead Cost Variance

Formula

Calculates the difference between the Actual Capacity Overhead Cost and Standard Capacity Overhead Cost.

Data Source

  • Capacity Ledger Entry
  • Prod Order Line
  • Inventory Adjmt. Entry (Order)
  • Item
Standard Manufacturing Overhead Cost Variance

Formula

Calculates the difference between the Actual Manufacturing Overhead Cost and Standard Manufacturing Overhead Cost.

Data Source

  • Prod. Order Line
  • Item Ledger Entry
  • Capacity Ledger Entry
  • Value Entry
  • Inventory Adjmt. Entry (Order)
  • Item
Standard Material Cost Variance

Formula

Calculates the difference between the Actual Material Cost and Standard Material Cost.

Data Source

  • Value Entry
  • Prod Order Line
  • Inventory Adjmt. Entry (Order)
  • Item
Standard Subcontracted Cost Variance

Formula

Calculates the difference between the Actual Subcontracted Cost and Standard Subcontracted Cost.

Data Source

  • Prod. Order Line
  • Capacity Ledger Entry
  • Inventory Adjmt. Entry (Order)
  • Item
Total Standard Cost Variance

Formula

Calculates the total deviation from standard costs by summing the following individual variances:

Data Source

  • Prod. Order Line
  • Item Ledger Entry
  • Capacity Ledger Entry
  • Inventory Adjmt. Entry (Order)
  • Item
  • Value Entry
Variance to Standard Cost Deviation %
Standard Capacity Cost Dev Percent

Formula

Calculates the percentage deviation between the actual and standard capacity costs by dividing the Standard Capacity Cost Variance by the Standard Capacity Cost.

Data Source

  • Prod. Order Line
  • Capacity Ledger Entry
  • Inventory Adjmt. Entry (Order)
  • Item
Standard Capacity Overhead Cost Dev Percent

Formula

Calculates the percentage deviation between the actual and standard capacity overhead costs by dividing the Standard Capacity Overhead Cost Variance by the Standard Capacity Overhead Cost.

Data Source

  • Prod. Order Line
  • Capacity Ledger Entry
  • Inventory Adjmt. Entry (Order)
  • Item
Standard Manufacturing Overhead Cost Dev Percent

Formula

Calculates the percentage deviation between the actual and standard manufacturing overhead costs by dividing the Standard Manufacturing Overhead Cost Variance by the Standard Manufacturing Overhead Cost.

Data Source

  • Prod. Order Line
  • Item Ledger Entry
  • Capacity Ledger Entry
  • Value Entry
  • Inventory Adjmt. Entry (Order)
  • Item
Standard Material Cost Dev Percent

Formula

Calculates the percentage deviation between the actual and standard material costs by dividing the Standard Material Cost Variance by the Standard Material Cost.

Data Source

  • Prod. Order Line
  • Value Entry
  • Inventory Adjmt. Entry (Order)
  • Item
Standard Subcontracted Cost Dev Percent

Formula

Calculates the percentage deviation between the actual and standard subcontracted costs by dividing the Standard Subcontracted Cost Variance by the Standard Subcontracted Cost.

Data Source

  • Prod. Order Line
  • Capacity Ledger Entry
  • Inventory Adjmt. Entry (Order)
  • Item
Total Standard Cost Dev Percent

Formula

Calculates the overall percentage deviation between actual and standard total costs by dividing the Total Standard Cost Variance by the Total Standard Cost.

Data Source

  • Prod. Order Line
  • Item Ledger Entry
  • Capacity Ledger Entry
  • Inventory Adjmt. Entry (Order)
  • Item
  • Value Entry

Value Entries

Production Order - WIP

Beginning Balance Value

Formula

Calculates the value of work in progress (WIP) by summing the cumulative values of:

Each measure is filtered to include only transactions that occurred before the earliest date in the current filter context to provide the starting WIP balance.

Data Source

  • Value Entry

Capacity Value

Formula

Calculates the total actual cost associated with capacity usage by summing the costAmountActual field from the Value Entries table where the Item Ledger Entry Type is Blank. This typically isolates capacity-related entries not linked to standard inventory transactions like consumption or output.

Data Source

  • Value Entry

Consumption Value

Formula

Calculates the total negative actual cost of materials consumed by summing the costAmountActual from the 'Value Entries' table where the Item Ledger Entry Type is "Consumption" and the Entry Type is not "Revaluation". The negative sign reflects that consumption reduces inventory value.

Data Source

  • Value Entry

Ending Balance Value

Formula

Calculates the total value of Work in Progress (WIP) at the end of the selected period. It's calculated by summing the following measures:

Data Source

  • Value Entry

Output Value

Formula

Calculates the total negative value of actual and expected output costs by summing the costAmountActual and costAmountExpected fields from the Value Entries table for entries where:

  • Item Ledger Entry Type is Output.
  • entryType is Direct Cost.

Then, the result is multiplied by -1 to reflect it as a cost deduction.

Data Source

  • Value Entry

Value Entry Measures

Cost Amount Actual

Formula

  • Calculates the total actual cost amount by summing the costAmountActual field from the Value Entries table.

Data Source

  • Value Entry

Cost Amount Expected

Formula

  • Calculates the total expected cost amount by summing the costAmountExpected field from the Value Entries table.

Data Source

  • Value Entry

Cost Posted to G/L

Formula

Calculates the total cost amount posted to the General Ledger by summing the costPostedtoGL field from the Value Entries table.

Data Source

  • Value Entry

Expected Cost

Formula

Calculates the total expected cost by summing the expectedCost field from the Value Entries table.

Data Source

  • Value Entry

Expected Cost Posted to G/L

Formula

Calculates the total expected cost posted to the general ledger by summing the expectedCostPostedtoGL field from the Value Entries table.

Data Source

  • Value Entry

Item Ledger Entry Quantity

Formula

Calculates the total item ledger entry quantity by summing the itemLedgerEntryQuantity field from the Value Entries table.

Data Source

  • Value Entry

Valued Quantity

Formula

Calculates the total valued quantity of items by summing the valuedQuantity field from the Value Entries table.

Data Source

  • Value Entry

Work Center

Work Center Measures

Work Center Availability After Orders

Formula

Calculates the available capacity of a work center after considering the allocated time by subtracting the Work Center Allocated Time from the Work Center Capacity (Effective).

Data Source

  • Calendar Entry
  • Prod Order Capacity Need

Work Center Load

Formula

Calculates the load on a work center by dividing the Work Center Allocated Time by the Work Center Capacity (Effective), providing the ratio of the allocated time to the available capacity.

Data Source

  • Calendar Entry
  • Prod Order Capacity Need

Work Center Output

Formula

Calculates the total output quantity for a work center by summing the outputQuantity field from the Capacity Ledger Entries table, filtered where the Type is Work Center.

Data Source

  • Capacity Ledger Entry

Work Center Scrap

Formula

  • Calculates the total scrap quantity for a work center by summing the scrapQuantity field from the Capacity Ledger Entries table, filtered where the Type is Work Center.

Data Source

  • Capacity Ledger Entry

Work Center Scrap Percent

Formula

Calculates the percentage of scrap relative to the total output for a work center by dividing the Work Center Scrap by the Work Center Output.

Data Source

  • Capacity Ledger Entry

Work Center Statistics

Work Center Actual Efficiency Percent

Formula

Calculates the actual efficiency of a work center by dividing the Work Center Actual Need by the Work Center Capacity (Total).

Data Source

  • Capacity Ledger Entry
  • Calendar Entry

Work Center Actual Need

Formula

  • Calculates the total actual time required by summing the setupTime, runTime, and stopTime fields from the Capacity Ledger Entries table.

Data Source

  • Capacity Ledger Entry

Work Center Actual Total Cost

Data Source

  • Capacity Ledger Entry
  • Value Entry

Work Center Allocated Time

Formula

  • Calculates the total allocated time for work centers by summing the allocatedTime column in the Prod Order Capacity Need table, filtered to include only rows where Requested Only is FALSE.

Data Source

  • Prod Order Capacity Need

Work Center Capacity (Effective)

Formula

  • Calculates the total effective capacity for work centers by summing the Capacity Effective column in the Calendar Entries table, filtered to include only rows where Capacity Type is Work Center.

Data Source

  • Calendar Entry

Work Center Capacity (Total)

Formula

  • Calculates the total capacity for work centers by summing the Capacity Total column in the Calendar Entries table, filtered to include only rows where Capacity Type is Work Center.

Data Source

  • Calendar Entry

Work Center Expected Efficiency Percent

Formula

Data Source

  • Calendar Entry

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