Production Order Cost Calculation

As a Production Planner (Produktionsplanlægger)
I want to see a summary of all finished production orders with their standard, expected, and actual costs side-by-side
So that I can quickly identify which orders came in over or under budget

Setup:

1. Open Production Order Costing page (search for "Productions Order Costing").
2. The list displays all calculated production orders with the following cost columns visible:
   • Order number and item number
   • Finished quantity, order quantity, and finished date
   • Standard cost (from item card)
   • Expected cost (from production plan)
   • Actual cost (from ledger)
   • Cost difference in currency and percentage
3. Scan the "Cost Diff. Pct." column to spot orders where actual cost differs from expected by more than your acceptable variance threshold.

Note: If no rows appear, the cost calculation has not been run yet. See US-02 to run the calculation first.

As a Production Planner (Produktionsplanlægger)
I want to calculate and update costs for one specific finished production order
So that I can immediately see its cost breakdown without waiting for a batch run

Setup:

1. Open Finished Production Orders in Business Central (standard Dynamics 365 list).
2. Find and open the production order you want to cost.
3. In the ribbon, look for the action Prod. Order Cost Calculation (under the Order section).
4. Click the action. The system will calculate costs for this order based on:
   • Standard costs from the item card (taken as-is)
   • Expected costs from the production line routing and capacity setup
   • Actual costs from all consumption and output postings in the item ledger
5. A calculation is performed and the cost data is stored in the app's database.
6. Navigate to Production Order Costing to view the results. The order will appear as a new row (or updated if already calculated).

Note: The calculation respects your setup options: if "Include Released Prod. Orders" is checked, it may also process released orders; if "Calculate Expected Cost from Actual Finished Quantity" is checked, expected costs will be scaled by actual output instead of planned quantity.

As a Accounting Manager (Regnskabschef)
I want to calculate costs for all finished production orders in a date range or for specific items
So that I can get a complete variance analysis for cost accounting purposes

Setup:

1. Open Production Order Costing page (search for "Productions Order Costing").
2. In the ribbon, select Calc. Order Cost (under the Functions section).
3. A request page dialog will open with the following filter options:
   • Item No.: Enter or select items to include (leave blank for all items)
   • Date Filter: Enter a date range filter like "20240101..20240131" to process only orders finished in January 2024 (leave blank for all dates)
   • Location Filter: Filter by location code if you operate multiple facilities
   • Include released production orders: Check this box to include released orders in addition to finished orders
   • Prod. Order No. Filter: Optionally filter to specific production order numbers
   • Calculate expected costs based on actual finished quantity: Check this to scale expected costs by what actually finished, rather than what was planned
4. Click OK. The report will process all matching production orders in sequence. A progress dialog shows the item and percentage complete.
5. When complete, navigate to Production Order Costing to see the results. New orders will be added and existing ones will be updated.

Note: If you have many orders, the batch can take a few minutes. The system commits changes after each item to avoid timeouts.

As a Production Planner (Produktionsplanlægger)
I want to see which materials were consumed, what the standard and actual costs were, and where the variance occurred
So that I can determine if a material was wasted, priced differently than expected, or if the routing quantities need adjustment

Setup:

1. Open Production Order Costing page.
2. Find the production order you want to analyze and click on its Prod. Order No. to open the detail view (Production Order Cost Calc. page).
3. Scroll down to the Materials subpage (appears at the bottom of the page).
4. The Materials section displays one row per consumed material item with:
   • Material item number and description
   • Expected consumption quantity and unit of measure
   • Actual consumption quantity
   • Quantity variance (actual minus expected, and percentage)
   • Expected cost (standard quantity × standard unit cost)
   • Actual cost (from ledger)
   • Cost variance (actual minus expected, and percentage)
5. Sort or filter by the "Diff. Qty. Pct." or "Cost Diff. Pct." columns to focus on problem areas.

Note: The "Expected Consumption" is taken from the production order bill-of-materials (component lines). The "Actual Consumption" is calculated from item ledger entries of type "Consumption" linked to this production order. If "Calculate Expected Cost from Actual Finished Quantity" is enabled in setup, the expected consumption is scaled by the actual finished quantity.

As a Production Planner (Produktionsplanlägger)
I want to see the actual hours spent on each operation, compare them to the standard routing hours, and review the associated costs
So that I can identify bottlenecks, inefficiencies, or changes needed in the routing standard times

Setup:

1. Open Production Order Costing page.
2. Find the production order and click on its Prod. Order No. to open the detail view.
3. Scroll down to the Capacity subpage (appears below Materials).
4. The Capacity section displays one row per operation in the production routing with:
   • Operation number and description
   • Work center or resource number
   • Expected time (in hours or minutes, according to the work center's unit of measure)
   • Actual time used (in the same unit)
   • Time variance (actual minus expected)
   • Expected capacity cost (direct and indirect, broken out by work center standard rates)
   • Actual capacity cost (from ledger)
   • Cost variance (actual minus expected, and percentage)
5. Identify operations where actual time significantly exceeds expected time—these are candidates for process improvement or routing updates.

Note: Capacity costs include both direct cost (hourly rate × hours) and indirect/overhead cost. If the work center is defined as a machine, the app tracks machine hours; if a labor resource, it tracks labor hours.

As a Accounting Manager (Regnskabschef)
I want to understand the difference between:

• Standard cost (from the item card at a point in time)
• Expected cost (calculated routing and BOM costs for this specific order)
• Actual cost (what was really posted to the ledger)
  So that I can diagnose whether variance is due to price changes, route deviations, or execution problems

Setup:

1. Open Production Order Costing and find your order.
2. In the summary row, observe these columns (scroll left/right if needed):
   • Standard Cost: Single fixed amount from the item card
   • Exp. Cost (Expected Cost): Calculated as the sum of standard costs for all materials and operations in the BOM and routing, adjusted for this order's quantity and actual output (if that option is enabled)
   • Act. Cost (Actual Cost): The real ledger total from all consumption, output, and capacity postings
   • Cost Diff. LCY: The difference between actual and expected, in local currency
   • Cost Diff. Pct.: The percentage difference
3. If expected cost is very different from standard cost, the item's BOM or routing differs from the item card's rolled-up standard cost. This is normal for complex multi-level items.
4. If actual cost is very different from expected cost, the order experienced execution variances (more/less material, more/less time, higher/lower labor rates).
5. Drill into Materials and Capacity subpages to isolate which cost elements contributed to the variance.

Note: The expected cost calculation uses current item card costs and routing definitions. If you changed item costs or routing after the order was created, expected cost will reflect those changes; it is not a "frozen" estimate from order creation time.

As a Production Planner (Produktionsplanlægger)
I want to see the difference between the planned order quantity and the actual finished quantity
So that I can flag scrap, overage, or underages for investigation

Setup:

1. Open Production Order Costing and find the order.
2. In the summary row, look for these columns:
   • Order Quantity: The quantity the production order was planned to produce
   • Finished Quantity: The quantity that was actually marked as finished in the ledger
   • Difference Qty: The absolute difference (finished minus planned)
   • Diff. Qty. Pct.: The percentage difference
3. A positive difference indicates overproduction; negative indicates underproduction or scrap.
4. If this variance is large, correlate it with:
   • Material consumption variances (in the Materials subpage): did you consume more material than expected?
   • Capacity cost variances (in the Capacity subpage): did you spend more time?
   • The production order's "Scrap %" field in Business Central, which may explain the shortage.

Note: The system calculates the difference as actual finished quantity minus order quantity. Some companies intentionally overrun to account for expected scrap; if you do, this variance is expected.

As a Business Manager (Forretningschef)
I want to include both released and finished production orders in cost calculations
So that I can analyze costs for orders that haven't yet finished, supporting early variance detection

Setup:

1. Open Production Order Cost Setup page (search for "Prod Order Cost Setup Page").
2. Check the box Include Released Prod. Orders.
3. Optionally, check Calculate Expected Cost from Actual Finished Quantity if you want expected costs to be based on how much has actually been output so far (rather than the full planned quantity). This is useful for orders still in progress.
4. Save and close the page.
5. Next time you run the batch Calc. Order Cost report, it will process both released and finished orders.

Note: Calculations for released orders are updated each time you run the batch. Use this when you want continuous cost visibility throughout the production lifecycle, not just at completion.

As a Accounting Manager (Regnskabschef)
I want to calculate expected costs using the actual finished quantity, not the original planned quantity
So that if we planned to make 100 pieces but only finished 95, the expected material and capacity costs reflect the 95 pieces, making variances more accurate

Setup:

1. Open Production Order Cost Setup page.
2. Check the box Calculate Expected Cost from Actual Finished Quantity.
3. Save and close.
4. Re-run the batch Calc. Order Cost report (or manually recalculate individual orders).
5. Expected costs will now be recalculated: if an order was planned for 100 pieces at 10 LCY each (1000 LCY expected), but only 95 pieces finished, the new expected cost is 950 LCY (95 × 10).
6. The variance will now reflect true execution variances, not scrap/yield differences.

Note: This option is useful when scrap or yield variation is common and you want to isolate cost per finished piece from production volume variance.

As a Production Planner (Produktionsplanlægger)
I want to navigate from a cost variance back to the production order itself
So that I can review the routing, components, and actual postings in detail

Setup:

1. Open Production Order Costing page.
2. Find the production order with the variance you want to investigate.
3. Click the Prod. Order No. field (it is a hyperlink). You will be taken to the Finished Production Order card in Business Central.
4. From here, you can:
   • Review the Lines section to see item details, quantities, and costs
   • Drill into Routing to see which operations were performed and their actual resource usage
   • Open Component Lines or Item Tracking to inspect which materials went into the order
   • Check Capacity Ledger Entries to see actual hours posted per operation
   • Review Item Ledger Entries to see actual material consumption
5. Make notes and return to the cost analysis page to follow up.

As a Accounting Manager (Regnskabschef)
I want to export production order cost data to a file or report
So that I can share it with management, auditors, or external stakeholders

Setup:

1. Open Production Order Costing page.
2. Select all rows (press Ctrl+A) or apply filters to show only the orders you want to export.
3. Use the standard Business Central export options:
   • Share (top ribbon) to create a link to the list
   • Print to send to PDF or printer
   • Open in Excel (if available in your Business Central version) to edit and format in Excel
   • Download as CSV (some versions) to get a delimited file
4. Or use the Production Order Cost Calc Print report for a formatted, printable report layout.

Note: The Print report includes summary tables and is designed for management review. The list page export is more granular.

As a Accounting Manager (Regnskabschef)
I want to print a formatted cost report for a specific production order
So that I can share it with production management or include it in cost accounting records

Setup:

1. Open Production Order Costing page.
2. Find the production order you want to print.
3. Select the row and look for a Print action in the ribbon (or press Ctrl+P).
4. Choose Production Order Cost Calc Print report from the dialog.
5. The report will open in print preview, showing:
   • Order header (order number, item, quantities)
   • Summary costs (standard, expected, actual, variance)
   • Materials detail (consumption, costs)
   • Capacity detail (operation times, costs)
   • Print, save as PDF, or send to email.

Note: The specific layout depends on the Print report design. Check with your system administrator if the report name differs in your environment.

As a IT Manager (IT-chef)
I want to confirm that the Production Order Cost Calculation app is properly licensed and enabled in our Business Central environment
So that users can access its features without unexpected errors

Setup:

1. Open the Production Order Cost Setup page (search for "Prod Order Cost Setup Page").
2. If the page opens successfully without an error message, the app is licensed and enabled.
3. If you see an error like "Missing license" or "App not enabled," contact your Microsoft Dynamics support team or reseller to verify the license is active.
4. Once verified, the app's features will be available to all users with appropriate Business Central roles.

Note: Licensing is managed at the tenant level by your Business Central administrator. Individual users don't need separate app access—the app is either on or off for the entire company.

As a Production Planner (Produktionsplanlægger)
I want to recalculate and update costs for a production order that was previously calculated
So that any new ledger postings (additional scrap, corrections, late material receipts) are reflected

Setup:

1. The previous cost data for the order is retained in the database.
2. Simply trigger the cost calculation again (either manually via the Prod. Order Cost Calculation action on the order, or via the batch Calc. Order Cost report).
3. The system will delete the old cost records for that order and insert fresh ones based on current ledger data.
4. Navigate to Production Order Costing to see the updated figures.

Note: Cost records are stored per entry; each recalculation generates new entry numbers. The list page always shows the most recent data.

As a Accounting Manager (Regnskabschef)
I want to understand that standard costs come from the item card and ensure they are correct before running production order cost calculations
So that the app uses accurate baseline figures for comparison

Setup:

1. The Standard Cost field in the cost calculation is read directly from the Item card's "Standard Cost" field in Business Central.
2. Similarly, the app reads:
   • Std. Cost Materials (single-level material cost) from the item card
   • Std. Cost Manufacturing Overhead (single-level mfg overhead cost) from the item card
   • Std. Cost Capacity Direct and Std. Cost Capacity Indirect from the item card
   • Std. Cost Subcontractor from the item card
3. Before running cost calculations, verify in Business Central's Item cards that standard costs are updated for the items you're analyzing.
4. If you change an item's standard cost, the cost calculation will use the new value the next time you recalculate. (Old calculated records retain their values.)

Note: Standard costs are a snapshot from the item card at calculation time. They are not frozen. This is by design: if you adjust standard costs, all future calculations reflect the change.

As a Production Planner (Produktionsplanlægger)
I want to understand how the cost calculation accounts for components that are themselves manufactured sub-assemblies
So that I can trust the cost breakdown for complex products

Setup:

1. For items with multi-level bills-of-materials (i.e., components that are sub-assemblies with their own components), the app can optionally recalculate expected costs using an "Accumulated Cost" function.
2. This traverses the full BOM tree and rolls up costs from the lowest level.
3. If a production order has a component that is itself a manufactured item, the expected cost includes the standard costs of all sub-components, rolled up from the lowest level.
4. See US-22 (below) for details on triggering the accumulated cost recalculation.

Note: Single-level BOMs (all components are raw materials) are straightforward. Multi-level BOMs may have temporary discrepancies if sub-assembly standard costs are not up-to-date; verify item card standard costs for all levels.

As a Production Planner (Produktionsplanlægger)
I want to spot production orders where finished quantity is significantly less than planned quantity
So that I can investigate scrap or yield issues

Setup:

1. Open Production Order Costing page.
2. Scroll right to find the Difference Qty and Diff. Qty. Pct. columns.
3. Sort by Diff. Qty. Pct. (descending) to see the biggest shortfalls first.
4. Any negative percentage indicates underproduction (scrap, rework, rejection, etc.).
5. For each problem order:
   • Click Prod. Order No. to open the order
   • In the order, check the Scrap % field on the line—if high, this may be expected
   • Review actual ledger postings (Item Ledger Entries, Capacity Ledger Entries) to confirm what happened
   • Compare to the production order's component lines and routing to see if there were unplanned deviations

Note: The app does not separately flag scrap as "good" or "bad"—that's a business judgment. Use the variance data to trigger investigation.

As a Production Planner (Produktionsplanlægger)
I want to run cost calculations for only a specific set of items (e.g., only items in a product family)
So that I can focus on a subset of production without processing the entire backlog

Setup:

1. Open Production Order Costing page.
2. Select Calc. Order Cost in the ribbon.
3. On the request page, in the request filters area (top of the page), fill in the Item No. filter. You can:
   • Type a single item: A100
   • Use a range: A100..A200
   • Use a wildcard pattern: A* (all items starting with A)
4. Click OK. Only production orders for the filtered items will be processed.

Note: If you leave the filter blank, all items are included (subject to other filters like Date Filter and Location Filter).

As a Accounting Manager (Regnskabschef)
I want to run cost calculations only for production orders finished in a specific period (e.g., a month or quarter)
So that I can generate period-specific cost analysis for management reporting

Setup:

1. Open Production Order Costing page.
2. Select Calc. Order Cost in the ribbon.
3. On the request page, in the request filters area, use the standard Business Central date filter format for Finished Date:
   • Single date: 20240115 (January 15, 2024)
   • Range: 20240101..20240131 (all of January 2024)
   • Text expression: LAST MONTH, THIS QUARTER, LAST YEAR (where supported)
4. Click OK. Only production orders with a finished date in the specified period will be processed.

Note: The filter is on the production order's "Finished Date," not the calculation date. Rerun calculations for a period to pick up any orders that finished after your last run.

As a Production Planner (Produktionsplanlägger)
I want to see all materials, capacity operations, and order-level costs in one detailed view
So that I can analyze a complete production order without navigating between pages

Setup:

1. Open Production Order Cost Calc. page (search for "SCB Prod. Order Cost Calc.").
2. This is the detailed page that shows every cost calculation entry: order-level, material-level, and capacity-level rows.
3. Each row represents a distinct cost element:
   • Type = "Order": the production order summary (one row)
   • Type = "Material": one row per consumed material
   • Type = "Capacity": one row per operation
4. The page is read-only. Use the filters at the top to narrow by Prod. Order No., Type, etc.
5. All cost fields, variances, and quantities are visible here in detail.

Note: This is a more technical view. Most users will prefer Production Order Costing (the summary page with subpages), which groups materials and capacity into dedicated subpages for clarity.

As a Accounting Manager (Regnskabschef)
I want to understand how the system calculates expected and actual costs so I can trace any discrepancies
So that I can validate the accuracy of the app's calculations and support audit requirements

Setup:

Expected Cost Calculation:

1. Expected cost is calculated by combining:
   • Standard costs from the item's BOM (from component lines of the production order)
   • Standard costs from the item's routing (from the routing operations linked to the production order line)
   • Overhead rates applied per the production order line's "Indirect Cost %" and "Overhead Rate" fields
2. If the option Calculate Expected Cost from Actual Finished Quantity is enabled, expected quantities are scaled by actual finished quantity. Otherwise, they use the original planned quantities.
3. The result is a "what should have cost" figure based on the plan and the item card standards at calculation time.

Actual Cost Calculation:

1. Actual cost is calculated by reading:
   • Item ledger entries of type "Consumption" linked to the production order, summed by item, location, and unit of measure
   • Item ledger entries of type "Output" linked to the production order to determine actual output quantity
   • Capacity ledger entries linked to the production order operations to determine actual hours and cost
   • The "Cost Amount (Actual)" field from the ledger to get the real posted cost
2. The result is a "what was actually posted" figure from your accounting ledger.

Variance Calculation:

1. Cost Diff. (LCY) = Actual Cost - Expected Cost
2. Cost Diff. (Pct.) = Cost Diff. / Expected Cost × 100

This design ensures transparency and auditability: all figures are traceable to source records.

Note: If you make corrections to ledger entries after a cost calculation, recalculate to update the figures.

As a Accounting Manager (Regnskabschef)
I want to ensure that expected costs for multi-level BOMs are calculated by rolling up from the lowest-level components
So that expected cost reflects the true material and overhead burden for complex products

Setup:

1. The cost calculation has an internal option to recalculate expected material costs using an "Accumulated Cost" function.
2. This traverses the full bill-of-materials tree and rolls up costs from the lowest manufactured item.
3. The option is most relevant for products with manufactured sub-assemblies (e.g., a finished product that contains a sub-assembly, which itself contains components).
4. If you see unexpected differences between expected and standard cost for a multi-level item, the accumulated cost recalculation may help.
5. Contact your system administrator or Abakion support if you need to enable detailed accumulated cost tracing for your analysis.

Note: This is an advanced feature. Standard single-level BOM calculations do not require it. It is automatically invoked during batch cost calculations if the production order contains multi-level components.

As a Accounting Manager (Regnskabschef)
I want to understand the cost breakdown: which costs are direct material, manufacturing overhead, direct capacity, indirect capacity, and subcontractor
So that I can properly allocate costs for financial reporting

Setup:

The app breaks costs into six main categories (displayed in the summary and detail pages):

1. Materials (Direct Material Cost)

   • Includes raw materials and purchased items consumed
   • Split into "Materials - Purchased" (items with replenishment system = Purchase) and "Materials - Produced" (items with replenishment system = Manufacturing or Assembly)

2. Manufacturing Overhead (Indirect Material Cost)

   • Applied based on the production order line's "Indirect Cost %" and "Overhead Rate" fields
   • Typically a percentage of direct material cost or a fixed overhead rate per quantity

3. Capacity - Direct (Direct Labor/Machine Cost)

   • Hours on work centers or resources, costed at the work center's direct hourly rate
   • Split between setup time and operation time

4. Capacity - Indirect (Indirect Labor/Overhead)

   • Overhead allocation on capacity, typically a percentage of direct capacity cost
   • Applied per the work center's overhead rate definition

5. Subcontractor Cost

   • Purchased services or outsourced operations
   • Identified by routing operations with resource type = Subcontractor or by PO receipts linked to the order

6. Total Cost

   • Sum of the above five categories

For financial reporting, consult with your accounting team on which categories map to your chart-of-accounts structure.

Note: The cost breakdown is informational; the actual posting to the general ledger depends on Business Central's standard costing setup and posting rules.

As a Production Planner (Produktionsplanlägger)
I want to see which operations took more or less time than expected
So that I can identify process bottlenecks, inefficiencies, or successful improvements

Setup:

1. Open Production Order Costing page.
2. Find the production order and click its Prod. Order No. to drill into the detail view (Production Order Cost Calc. page).
3. Scroll to the Capacity subpage.
4. For each operation, observe:
   • Operation No.: The sequence step in the routing
   • Description: What the operation does
   • Exp. Time Hours (Expected): Planned hours from the routing (may be split into setup and run time)
   • Act. use of time hours (Actual): Actual hours posted to the capacity ledger
   • Time variance is shown implicitly (you can calculate Actual - Expected)
5. Sort by the largest positive variances (actual > expected) to focus on problem areas.
6. Drill into the work center or resource to review rates and settings if time seems abnormal.

Note: Time units may be hours, minutes, or days, depending on the work center's "Time Unit" setting. Check the work center master if the variance seems unreasonable.

As a Production Planner (Produktionsplanlägger)
I want to analyze historical production order costs to identify which operations are expensive or time-consuming
So that I can decide whether to outsource, automate, or optimize the routing

Setup:

1. Run cost calculations for a representative sample of production orders over a period of time (e.g., the last quarter).
2. Open Production Order Costing and filter or sort by Capacity or Material costs to identify the most expensive components or operations.
3. For capacity, the Capacity subpage shows:
   • Cost per operation
   • Actual vs. expected time
   • Work center or resource used
4. For materials, the Materials subpage shows:
   • Cost per material
   • Consumption variance
5. Use this data to support decisions:
   • If a specific operation consistently runs over budget, evaluate outsourcing or automation
   • If a material is consistently over-consumed, review the BOM quantities or operator training
   • If a work center's costs are high, consider alternative equipment or scheduling
6. Document the analysis and share with process engineering and procurement teams.

Note: Cost data alone doesn't justify decisions—qualitative factors like quality, delivery, and flexibility matter too. Use cost as one input.